Hi folks,
I am running roundcube on an Ubuntu 10.04 LTS for some years now. I have an old user which is unable to check its mails or compose new. When trying to compose a new message I get this on the error log:
[19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysql_2c2b391612904b84a62da258fe79b33e2e8ad03fc] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_3b8a178a5521b8c2fe131aeea5d22f803152283fb FROM 'UPDATE session SET vars=?, changed='2012-03-19 13:15:48' WHERE sess_id=?'] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48 -0300]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_3b8a178a5521b8c2fe131aeea5d22f803152283fb FROM 'UPDATE session SET vars=?, changed='2012-03-19 13:15:48' WHERE sess_id=?'] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now] in /var/www/roundcube/program/include/rcube_mdb2.php on line 293 (GET /?_task=mail&_action=compose&_reply_uid=12424&_mbox=INBOX) [19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysql_2e8cc86bba4898aea4305b0ac268bb7f89bd09dce] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48 -0300]: PHP Error: Invalid compose ID in /var/www/roundcube/program/steps/mail/compose.inc on line 52 (GET /?_task=mail&_id=1719649054f675bb43d3a7&_action=compose)
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
Can someone help me solve this or at least find what is wrong?
Thanks in advance, best regards.
Bump!
BTW, what happed to the list? Got 3 days without any message.....?
Regards.
Em Seg 19 Mar 2012 13:25:38 BRT, Marcio Merlone escreveu:
Hi folks,
I am running roundcube on an Ubuntu 10.04 LTS for some years now. I have an old user which is unable to check its mails or compose new. When trying to compose a new message I get this on the error log:
[19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysql_2c2b391612904b84a62da258fe79b33e2e8ad03fc] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_3b8a178a5521b8c2fe131aeea5d22f803152283fb FROM 'UPDATE session SET vars=?, changed='2012-03-19 13:15:48' WHERE sess_id=?'] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48 -0300]: DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_3b8a178a5521b8c2fe131aeea5d22f803152283fb FROM 'UPDATE session SET vars=?, changed='2012-03-19 13:15:48' WHERE sess_id=?'] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now] in /var/www/roundcube/program/include/rcube_mdb2.php on line 293 (GET /?_task=mail&_action=compose&_reply_uid=12424&_mbox=INBOX) [19-Mar-2012 13:15:48] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysql_2e8cc86bba4898aea4305b0ac268bb7f89bd09dce] [Native code: 2014] [Native message: Commands out of sync; you can't run this command now]
[19-Mar-2012 13:15:48 -0300]: PHP Error: Invalid compose ID in /var/www/roundcube/program/steps/mail/compose.inc on line 52 (GET /?_task=mail&_id=1719649054f675bb43d3a7&_action=compose)
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
Can someone help me solve this or at least find what is wrong?
Thanks in advance, best regards.
-- *Marcio Merlone*
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
On 2012-03-19 17:25, Marcio Merlone wrote:
Hi folks,
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
Can someone help me solve this or at least find what is wrong?
It seems what you are hitting is a situation in which Roundcube / MDB2 is trying to fetch data from two (or more) prepared statements simultaneously, or not having finished fetching all data from the first prepared statement when it attempts to fetch data from the second prepared statement.
See also this thread: http://forums.mysql.com/read.php?168,238786,247628#msg-247628
Kind regards,
Jeroen van Meeuwen
Em 23-03-2012 12:11, Jeroen van Meeuwen (Kolab Systems) escreveu:
On 2012-03-19 17:25, Marcio Merlone wrote:
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
It seems what you are hitting is a situation in which Roundcube / MDB2 is trying to fetch data from two (or more) prepared statements simultaneously, or not having finished fetching all data from the first prepared statement when it attempts to fetch data from the second prepared statement.
See also this thread: http://forums.mysql.com/read.php?168,238786,247628#msg-247628
Thank you very much, but that doesn't help me much. This happens consistently with just one user whenever he tries to compose a new message, among other situations which involves his addressbook (mysql). It seems something is wrong with this user's data, but I can't drop it. Can you help me find what's wrong and fix it?
Best regards.
On 2012-03-23 20:33, Marcio Merlone wrote:
Em 23-03-2012 12:11, Jeroen van Meeuwen (Kolab Systems) escreveu:
On 2012-03-19 17:25, Marcio Merlone wrote:
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
It seems what you are hitting is a situation in which Roundcube / MDB2 is trying to fetch data from two (or more) prepared statements simultaneously, or not having finished fetching all data from the first prepared statement when it attempts to fetch data from the second prepared statement.
See also this thread: http://forums.mysql.com/read.php?168,238786,247628#msg-247628
Thank you very much, but that doesn't help me much. This happens consistently with just one user whenever he tries to compose a new message, among other situations which involves his addressbook (mysql). It seems something is wrong with this user's data, but I can't drop it. Can you help me find what's wrong and fix it?
I can't *really* help you, but I might be able to.
After all I'm not a Roundcube developer...
I can try and suggest where the culprit may lay; you need to raise the issue with the Roundcube developers in order to get it resolved though.
If it is only this one user the issue is occurring with, I suggest you destroy all cache table records associated with the user, and check whether his preferences accidentally list his one MySQL address book twice.
Kind regards,
Jeroen van Meeuwen
Hi,
Please remove me from this list.
Thank you,
Paul
On 23.03.2012 18:48, Jeroen van Meeuwen (Kolab Systems) wrote:
On 2012-03-23 20:33, Marcio Merlone wrote:
Em 23-03-2012 12:11, Jeroen van Meeuwen (Kolab Systems) escreveu:
On 2012-03-19 17:25, Marcio Merlone wrote:
I googled for this error but got zarro boogs found, I mean, no google results. I had 0.7.1 installed, he was using without any problem, and then today he started to get this error. I upgraded to 0.7.2 in a hope to solve the problem, but no luck.
It seems what you are hitting is a situation in which Roundcube / MDB2 is trying to fetch data from two (or more) prepared statements simultaneously, or not having finished fetching all data from the first prepared statement when it attempts to fetch data from the second prepared statement.
See also this thread: http://forums.mysql.com/read.php?168,238786,247628#msg-247628
Thank you very much, but that doesn't help me much. This happens consistently with just one user whenever he tries to compose a new message, among other situations which involves his addressbook (mysql). It seems something is wrong with this user's data, but I can't drop it. Can you help me find what's wrong and fix it?
I can't *really* help you, but I might be able to.
After all I'm not a Roundcube developer...
I can try and suggest where the culprit may lay; you need to raise the issue with the Roundcube developers in order to get it resolved though.
If it is only this one user the issue is occurring with, I suggest you destroy all cache table records associated with the user, and check whether his preferences accidentally list his one MySQL address book twice.
Kind regards,
Jeroen van Meeuwen
On 2012-03-24 20:30, TerraForma Outdoor Solutions wrote:
Hi,
Please remove me from this list.
Thank you,
Paul
Hi Paul,
you can do so yourself using the mailing list interface at http://lists.roundcube.net/mailman/listinfo/users (near the bottom of the page, the last text input field).
If you do not have the password associated with your email address, the interface permits the resending of the password (supply the email address you are subscribed with in the aforementioned interface and click remind near the bottom of the next page you are presented with).
Kind regards,
Jeroen van Meeuwen
-
Jeroen van Meeuwen (Kolab Systems) -
Marcio Merlone -
TerraForma Outdoor Solutions