| 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: | Whole Thread | Raw Message | 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 ? |