This error is out of DAL control so it does not get reported. You have to enable logging in postgresql.conf (and restart postgresql). Then find the error in the postgres logs. It should help find the exact command that makes postgres choke.
mic 2012/6/15 Bruce Wade <bruce.w...@gmail.com> > I have just found if I have a secondary database with no tables and I try > to use the database I get the following very unclear and very hard to debug > error: > > <class 'psycopg2.InternalError'> current transaction is aborted, commands > ignored until end of transaction block > TRACEBACK > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > > Traceback (most recent call last): > > File "/home/developer/projects/yaw/gluon/restricted.py", line 205, in > restricted > > exec ccode in environment > File > "/home/developer/projects/yaw/applications/advertisement/controllers/manage_customers.py" > > <https://ad.youadworld.com/admin/edit/advertisement/controllers/manage_customers.py>, > line 600, in <module> > > File "/home/developer/projects/yaw/gluon/globals.py", line 173, in <lambda> > > self._caller = lambda f: f() > > File "/home/developer/projects/yaw/gluon/tools.py", line 2575, in f > > return action(*a, **b) > > File > "/home/developer/projects/yaw/applications/advertisement/controllers/manage_customers.py" > > <https://ad.youadworld.com/admin/edit/advertisement/controllers/manage_customers.py>, > line 147, in index > > formname='myform' > File "/home/developer/projects/yaw/gluon/sqlhtml.py", line 1769, in grid > > rows = > dbset.select(left=left,orderby=orderby,limitby=limitby,*table_fields) > > File "/home/developer/projects/yaw/gluon/dal.py", line 7578, in select > > return adapter.select(self.query,fields,attributes) > > File "/home/developer/projects/yaw/gluon/dal.py", line 1315, in select > > rows = response(sql) > > File "/home/developer/projects/yaw/gluon/dal.py", line 1305, in response > > self.execute(sql) > > File "/home/developer/projects/yaw/gluon/dal.py", line 1392, in execute > > return self.log_execute(*a, **b) > > File "/home/developer/projects/yaw/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 > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.fittraineronline.com - Fitness Personal Trainers Online > http://www.warplydesigned.com > >
