+ Reply to Thread
Results 1 to 7 of 7

Thread: large e-mail attachments session expired

  1. #1
    spiderling is offline Roundcube Newcomer
    Join Date
    Jul 2009
    Posts
    6
    Downloads
    0
    Uploads
    0

    Default large e-mail attachments session expired

    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_49ec8624721c0aa2ac827b0f1f785 efe52d48295c 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&_par t=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_4748c3c503667bab6511e772392fd 822fae19d1a8 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_4748c3c503667bab6511e772392fd 822fae19d1a8 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&_par t=3)
    [01-Feb-2010 14:32:12 -0500]: IMAP Error: Empty startup greeting (mydomain.com:143) (GET /?_task=mail&_action=getunread&_remote=1&_=12650527 27093&_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_4dd226347ab0c777172c97c8dce10 55bb0076a762 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_4dd226347ab0c777172c97c8dce10 55bb0076a762 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&_par t=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_455450f32da8e3331297f2107a494 d5f6d052de61 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)

  2. #2
    skaero's Avatar
    skaero is offline Administrator
    Join Date
    Jun 2006
    Location
    USA - New Mexico
    Posts
    2,085
    Downloads
    5
    Uploads
    0

    Default

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

  3. #3
    spiderling is offline Roundcube Newcomer
    Join Date
    Jul 2009
    Posts
    6
    Downloads
    0
    Uploads
    0

    Default

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

  4. #4
    spiderling is offline Roundcube Newcomer
    Join Date
    Jul 2009
    Posts
    6
    Downloads
    0
    Uploads
    0

    Default

    Any ideas??

  5. #5
    skaero's Avatar
    skaero is offline Administrator
    Join Date
    Jun 2006
    Location
    USA - New Mexico
    Posts
    2,085
    Downloads
    5
    Uploads
    0

    Default

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

  6. #6
    spiderling is offline Roundcube Newcomer
    Join Date
    Jul 2009
    Posts
    6
    Downloads
    0
    Uploads
    0

    Default

    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.

  7. #7
    skaero's Avatar
    skaero is offline Administrator
    Join Date
    Jun 2006
    Location
    USA - New Mexico
    Posts
    2,085
    Downloads
    5
    Uploads
    0

    Default

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts