From: | Ayman Samamry <Ayman(dot)Samamry(at)ir(dot)com> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Cc: | Henry Santosa <Henry(dot)Santosa(at)ir(dot)com>, Denn Sporcic <Denn(dot)Sporcic(at)ir(dot)com> |
Subject: | Deadlock when executing multiple select statements from multiple threads |
Date: | 2018-04-10 05:51:51 |
Message-ID: | E1ABCC87AAEA0A4C939B08AAB318F5587A1EE2@ir-mail2-srv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
We are having a deadlock issue when executing multiple select statements from multiple threads, the issue happens with driver version (9.6.4.0) or newer, doesn't happen on 9.6.3.1 .
I've attached a simple project that triggers the deadlock, tested with visual studio 2017, release x64 build, PostgreSQL 10.3, usually happens after few runs.[please note that the proper database connection string and the table names need to be provided in the code for it to work].
I've also included the stack trace of the two threads in deadlock.
Regards,
Ayman
_____________________________________________________________________
This email, including any attachments, is confidential and/or privileged. If you are not the intended recipient, any use for any purpose or disclosure its contents to any other person or copying of this Email is strictly prohibited; please notify us immediately by return email or telephone +61 2 9966 1066 and destroy the original message. IR entities reserve the right to monitor all email communications through their networks.
_______________________________________________________________________
Attachment | Content-Type | Size |
---|---|---|
MultithreadedSelectDeadlock.zip | application/x-zip-compressed | 141.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2018-04-11 03:03:43 | Re: Deadlock when executing multiple select statements from multiple threads |
Previous Message | Clemens Ladisch | 2018-04-04 13:02:17 | Re: Bug in SQLRowCount ? |