Deadlock when executing multiple select statements from multiple threads

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

Responses

Browse pgsql-odbc by date

  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 ?