The error refers to the transaction being not usable anymore. So the error happened erlier somewhere, but web2py traps it and lets the application go on with an unsusable transaction. Probably a bug.
You can try to increase logging to log errors in posrgesql.conf and restart the server, then you will be able to find the root cause. Once you have the info open an issue on web2py.googlecode.com to help fix the bug. mic 2012/5/28 Jason Brower <encomp...@gmail.com> > I have my system runing on sqlite at my dev environment, but when I push > to production which uses postres I get this: > Ticket ID > > 80.75.108.196.2012-05-28.05-45-56.74d0c90a-1a1b-4b60-8ba6-c13af5955bbb > <class 'psycopg2.InternalError'> current transaction is aborted, commands > ignored until end of transaction block Version web2py™ (1, 99, 7, > datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable') Python Python > 2.7.2+: /usr/bin/python Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 205, in restricted > exec ccode in environment > File > "/home/www-data/web2py/applications/welcome/controllers/event_admin.py" > <https://interestid.com/admin/default/edit/welcome/controllers/event_admin.py>, > line 321, in <module> > File "/home/www-data/web2py/gluon/globals.py", line 173, in <lambda> > self._caller = lambda f: f() > File "/home/www-data/web2py/gluon/tools.py", line 2575, in f > return action(*a, **b) > File > "/home/www-data/web2py/applications/welcome/controllers/event_admin.py" > <https://interestid.com/admin/default/edit/welcome/controllers/event_admin.py>, > line 127, in invitations > need_nickname = db(db.auth_user.nickname == (nickname + > str(counter))).select() > File "/home/www-data/web2py/gluon/dal.py", line 7578, in select > return adapter.select(self.query,fields,attributes) > File "/home/www-data/web2py/gluon/dal.py", line 1315, in select > rows = response(sql) > File "/home/www-data/web2py/gluon/dal.py", line 1305, in response > self.execute(sql) > File "/home/www-data/web2py/gluon/dal.py", line 1392, in execute > return self.log_execute(*a, **b) > File "/home/www-data/web2py/gluon/dal.py", line 1386, in log_execute > ret = self.cursor.execute(*a, **b)InternalError: current transaction is > aborted, commands ignored until end of transaction block > > > Error snapshot [image: help] > > <class 'psycopg2.InternalError'>(current transaction is aborted, commands > ignored until end of transaction block ) > > inspect attributes > > > How can I solve this? I think it has something to do with the new table I > needed to create, but I though most migrations where handle seamlessly. > --- > BR, > Jason Brower >
