Error in one query makes subsequent queries fail

Bug #180134 reported by Anand Chitipothu
2
Affects Status Importance Assigned to Milestone
web.py
Fix Released
High
Anand Chitipothu

Bug Description

The following test fails.

    def testWrongQuery(self):
        # It should be possible to run a correct query after getting an error from a wrong query.
        try:
            web.select('wrong_table')
        except:
            pass
        web.select('person')

Here is exception trace:

=====================================
ERROR: testWrongQuery (__main__.DBTest)
----------------------------------------------------------------------
Traceback (most recent call last):
 File "test/db.py", line 29, in testWrongQuery
   web.select('person')
 File "./web/db.py", line 605, in select
   return query(qout, processed=True)
 File "./web/db.py", line 457, in query
   web.ctx.db_execute(db_cursor, sql_query)
 File "./web/db.py", line 356, in db_execute
   out = cur.execute(sql_query.s, sql_query.v)
ProgrammingError: current transaction is aborted, commands ignored
until end of transaction block

Changed in webpy:
assignee: nobody → anandology
importance: Undecided → High
milestone: none → 0.23
status: New → Fix Committed
Changed in webpy:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.