large e-mail attachments session expired

[spiderling]

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
Solution 2 used

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)

[SKaero]

Did you upgrade the database? Does this happen with a fresh install?

[spiderling]

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`);

[spiderling]

Any ideas??  

[SKaero]

Try a fresh install of the SVN and see if this still happens.

[spiderling]

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:

[SKaero]

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.