Text only | Text with Images

Roundcube Community Forum

Release Support => Pending Issues => Topic started by: spiderling on February 02, 2010, 12:10:10 AM

Title: large e-mail attachments session expired
Post by: spiderling on February 02, 2010, 12:10:10 AM
I upgraded from 0.3 to 0.3.1 over the weekend. An issue I am having is a large e-mail with photo attachments. The e-mail is about 28MB and has 4 JPG attachments. I double click to open the message and after a few seconds I receive "Your session is invalid or expired." at the top of RC, and I am kicked back to my message list.

I checked the error log for the initial errors below. I searched the forum and was able to get rid of all the errors except one, but I am still having the same problem.
Solution 1 used (http://www.roundcubeforum.net/5-release-support/17-pending-issues/5943-mdb2-error-constraint-violation.html#post23865)
Solution 2 used (http://www.roundcubeforum.net/5-release-support/17-pending-issues/5783-session-invalid-expired.html#post23727)

I did some troubleshooting. I sent an e-mail with just over 3MB of photos attached and was able to open the message. Then I tried 11MB of photos and after a few seconds I am kicked back to the message list without session invalid / expired error. Still though on the 28MB I receive the session invalid / expired error, and the only error in the log is below.

Is it RC or a configuration setting??

Thanks in advance
Pasquale

### initial errors
[01-Feb-2010 14:32:11 -0500]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_49ec8624721c0aa2ac827b0f1f785efe52d48295c USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '14-INBOX.msg-2956' for key 2]  in /usr/share/psa-horde/program/include/rcube_mdb2.php on line 627 (GET /?_task=mail&_action=get&_uid=2956&_mbox=INBOX&_part=4)
[01-Feb-2010 14:32:11] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_4748c3c503667bab6511e772392fd822fae19d1a8 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '14-INBOX.msg-2956' for key 2]

[01-Feb-2010 14:32:11 -0500]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_4748c3c503667bab6511e772392fd822fae19d1a8 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '14-INBOX.msg-2956' for key 2]  in /usr/share/psa-horde/program/include/rcube_mdb2.php on line 627 (GET /?_task=mail&_action=get&_uid=2956&_mbox=INBOX&_part=3)
[01-Feb-2010 14:32:12 -0500]: IMAP Error: Empty startup greeting (mydomain.com:143) (GET /?_task=mail&_action=getunread&_remote=1&_=1265052727093&_unlock=0)
[01-Feb-2010 14:43:00] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_4dd226347ab0c777172c97c8dce1055bb0076a762 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '14-INBOX.msg-2684' for key 2]

[01-Feb-2010 14:43:00 -0500]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_4dd226347ab0c777172c97c8dce1055bb0076a762 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '14-INBOX.msg-2684' for key 2]  in /usr/share/psa-horde/program/include/rcube_mdb2.php on line 627 (GET /?_task=mail&_action=get&_uid=2684&_mbox=INBOX&_part=3)
[01-Feb-2010 14:43:01] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_455450f32da8e3331297f2107a494d5f6d052de61 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '14-INBOX.msg-2684' for key 2]


#### remaining error
[01-Feb-2010 23:46:42 -0500]: IMAP Error: Empty startup greeting (mydomain.com:143) (GET /?_task=mail&_action=check-recent&_t=1265085998786&_list=1&_quota=1&_remote=1&_=1265085998786&_unlock=1)
Title: large e-mail attachments session expired
Post by: SKaero on February 02, 2010, 12:22:28 AM
Did you upgrade the database? Does this happen with a fresh install?
Title: large e-mail attachments session expired
Post by: spiderling on February 02, 2010, 12:45:35 AM
I replaced the following:
/bin
/installer
/plugins
/program
/skins/default
/SQL
all rootfiles

I manually ran the following MySQL queries:
-- Updates from version 0.3-stable

ALTER TABLE `messages`
    ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);

TRUNCATE `messages`;

ALTER TABLE `session`
    CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;

ALTER TABLE `contacts`
    ADD INDEX `user_contacts_index` (`user_id`,`email`);
Title: large e-mail attachments session expired
Post by: spiderling on February 04, 2010, 12:18:22 AM
Any ideas??  :)
Title: large e-mail attachments session expired
Post by: SKaero on February 04, 2010, 12:50:26 AM
Try a fresh install of the SVN and see if this still happens.
Title: large e-mail attachments session expired
Post by: spiderling on February 05, 2010, 01:54:07 PM
Does a fresh install include creating the tables again? Or just replacing all the RC files / folders?

Please bear with me if I have a few more basic questions. I just don't want to do something irreversible with the clients' e-mails, contacts, etc. :S

Thanks. :cool:
Title: large e-mail attachments session expired
Post by: SKaero on February 08, 2010, 02:57:24 AM
Sorry for the delay in my replay, It would be best to use a separate database for the SVN, that way its a clean database as that looks be be part of the problem.
Text only | Text with Images