[ psqlodbc-Bugs-1000457 ] Autocommit and Cancel

Bugs item #1000457, was opened at 2005-11-30 15:36
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10004 57&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: Accepted
Priority: 3
Submitted By: Nobody (None)
Assigned to: Ludek Finstrle (luf)
Summary: Autocommit and Cancel

Initial Comment:
Our application in one thread issued long time SELECT, another thread cancelled this statement. After that first thread tried to issue next SELECT and got error message because current transaction is aborted with error. As I saw in postgresql server logs there was no ROLLBACK statement issued by driver after cancellation.

We're using autocommit mode. Mylog file is attached.
Server version is 7.4.6, psqlodbc version is 08.01.0101.
Also, we use unixODBC 2.2.8 with option "Threading=0" in odbcinst.ini.

Thank you.

------------------------------------------------------------ ----------

>Comment By: Ludek Finstrle (luf)
Date: 2005-12-20 16:04

Message:
Reporter wrote to pgsql-odbc mailing list:
I've tried this version from development snapshot.

* 1000457. Cancelling statement from another thread is working
fine. There was normal "ROLLBACK" in thread that called target
statement.

Bug is fixed.

------------------------------------------------------------ ----------

Comment By: Ludek Finstrle (luf)
Date: 2005-12-18 11:18

Message:
What is the state of this? Please could you report?
I add this fix into development snapshot 8.01.0105.
If nobody answer in this week I close this bug.

------------------------------------------------------------ ----------

Comment By: Ludek Finstrle (luf)
Date: 2005-12-09 02:23

Message:
I'm sorry, you wrote you use unixODBC ...
I attach patch againist CVS source now. Please try it.

------------------------------------------------------------ ----------

Comment By: Nobody (None)
Date: 2005-12-08 10:15

Message:
Sorry for missing mylog, I'll try to resend it into pgsql-odbc, because I can't attach file into existence issue.
Also, I couldn't try your driver, because it's for Windows, but I'm using Linux and unixODBC.

Thank you.

------------------------------------------------------------ ----------

Comment By: Ludek Finstrle (luf)
Date: 2005-12-07 12:14

Message:
I try to fix this problem. Please try one of attached drivers. Send me feedback throught pgsql-odbc mailing list with attached mylog and with yours odbc.ini settings for used datasource (I think you have to use usedeclarefetch option).

I see no mylog attached (as you wrote you attach one).

------------------------------------------------------------ ----------

Comment By: Ludek Finstrle (luf)
Date: 2005-12-06 11:14

Message:
There is problem that exec is blocking and cancel is for non-blocking operations.
I'll fix it as soon as possible.

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10004 57&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match