This is a database issue more than a web2py issue but I am interested to
get to the bottom of it.
Can you ty open a web2py shell
$ python web2py.py -S yourapp -M
>>> fields = [db.auth_user.generation, db.auth_user.id, db.auth_user.
first_name]
>>> raw_rows = db.executesql('CALL sp_recursive_start(1);', fields=fields)
>>> db.rollback()
What do you get?
On Monday, 25 February 2013 07:39:24 UTC-6, __pyslan__ wrote:
>
> No, Massimo, is not ... With or without the try... except... the error is
> the same ... I've tried this several times.
>
> The code of gist: https://gist.github.com/pyslan/5007364 (without try...
> except...) print it on the terminal server:
>
> <Row {'generation': 1, 'first_name': 'Root', 'id': 1}>
> <Row {'generation': 2, 'first_name': 'Teste', 'id': 2}>
> ERROR:web2py:Traceback (most recent call last):
> File "/home/ctx/PROJECTS/WEB/web2py/gluon/main.py", line 632, in wsgibase
> BaseAdapter.close_all_instances('rollback')
> File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 543, in
> close_all_instances
> db._adapter.close(action)
> File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 523, in close
> getattr(self, action)()
> File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 1670, in rollback
> if self.connection: return self.connection.rollback()
> ProgrammingError: (2014, "Commands out of sync; you can't run this command
> now")
>
>
>
>
>
> On Sat, Feb 23, 2013 at 5:58 PM, Massimo Di Pierro
> <massimo....@gmail.com<javascript:>
> > wrote:
>
>> This is causing the problem. What if you remove the try... except? What
>> ticket do you get?
>>
>> try:
>> raw_rows = db.executesql('CALL sp_recursive_start(1);',
>> fields=fields)
>> except Exception, e:
>> print 'ERROR NOW:', e
>> db.rollback()
>>
>>
>>
>>
>> On Saturday, 23 February 2013 12:58:44 UTC-6, __pyslan__ wrote:
>>>
>>> After reading this
>>> thread<http://en.usenet.digipedia.org/thread/16137/52728/>,
>>> as Anthony suggested, I tried this:
>>>
>>> import MySQLdb
>>> from gluon.dal import MySQLAdapter
>>> MySQLAdapter.driver = MySQLdb
>>>
>>> After that, even commenting this block of code I get the result
>>> correctly because the print rows, but the error below is thrown anyway:
>>>
>>> Traceback (most recent call last):
>>> File "/media/sda3/pyslan/PROJECTS/**web2py/gluon/main.py", line 632, in
>>> wsgibase
>>>
>>>
>>> BaseAdapter.close_all_**instances('rollback')
>>>
>>>
>>> File "/media/sda3/pyslan/PROJECTS/**web2py/gluon/dal.py", line 543, in
>>> close_all_instances
>>>
>>>
>>> db._adapter.close(action)
>>>
>>>
>>> File "/media/sda3/pyslan/PROJECTS/**web2py/gluon/dal.py", line 523, in
>>> close
>>>
>>>
>>> getattr(self, action)()
>>>
>>>
>>> File "/media/sda3/pyslan/PROJECTS/**web2py/gluon/dal.py", line 1670, in
>>> rollback
>>>
>>>
>>> if self.connection: return self.connection.rollback()
>>>
>>> ProgrammingError: (2014, "Commands out of sync; you can't run this command
>>> now")
>>>
>>>
>>>
>>> The code:
>>> https://gist.github.com/**pyslan/5007364<https://gist.github.com/pyslan/5007364>
>>>
>>> Something related with this?
>>> https://groups.google.com/**forum/#!msg/web2py/**
>>> 1s7vDix8QC8/mgvot4PEvBgJ<https://groups.google.com/forum/#!msg/web2py/1s7vDix8QC8/mgvot4PEvBgJ>
>>>
>>>
>>>
>>>
>>>
>>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
