ProgrammingError: (2014, "Commands out of sync; you can't run this command now")

[Rodrigo Culagovski]

In a production site, all of a sudden while trying to edit the site
via the admin interface I get:

ProgrammingError: (2014, "Commands out of sync; you can't run this
command now")

This is when trying to access the record list: "/admin/core/pagina/"
This is only while trying to edit this one specific model ('pagina'),
I can edit the others without errors.
I dumped the database to my development server, and I get the same
error. It was working fine right before importing the DB from the
production server, so I'm thinking there's a problem in the actual DB.
I ran Optimize, Check and Repair on the DB in MySQL Administrator. No
dice.
I haven't updated or changed anything on either server. Development's
running XP, production Linux.

Full traceback:

Traceback (most recent call last):

File "C:\django\djtrunk\django\core\servers\basehttp.py", line 277,
in run
self.result = application(self.environ, self.start_response)

File "C:\django\djtrunk\django\core\servers\basehttp.py", line 631,
in __call__
return self.application(environ, start_response)

File "C:\django\djtrunk\django\core\handlers\wsgi.py", line 205, in
__call__
response = self.get_response(request)

File "C:\django\djtrunk\django\core\handlers\base.py", line 117, in
get_response
receivers = dispatcher.send(signal=signals.got_request_exception,
request=request)

File "C:\django\djtrunk\django\dispatch\dispatcher.py", line 360, in
send
**named

File "C:\django\djtrunk\django\dispatch\robustapply.py", line 47, in
robustApply
return receiver(*arguments, **named)

File "C:\django\djtrunk\django\db\__init__.py", line 73, in
_rollback_on_exception
transaction.rollback_unless_managed()

File "C:\django\djtrunk\django\db\transaction.py", line 149, in
rollback_unless_managed
connection._rollback()

File "C:\django\djtrunk\django\db\backends\mysql\base.py", line 195,
in _rollback
BaseDatabaseWrapper._rollback(self)

File "C:\django\djtrunk\django\db\backends\__init__.py", line 24, in
_rollback
return self.connection.rollback()

ProgrammingError: (2014, "Commands out of sync; you can't run this
command now")

[ANOOP M.S]

any idea why this happens?

[Constantine Covtushenko]

Hi Anoop,

I've checked that such kind of errors comes from MySQL server. You can check detailed explanation here.

Do you have any procedure run on your server?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6894ba6a-193e-4d29-81db-0cca6f1a9a23%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.