Deadlock when executing multiple select statements from multiple threads

Ayman Samamry <[email protected]>
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <E1ABCC87AAEA0A4C939B08AAB318F5587A1EE2@ir-mail2-srv>
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.
_______________________________________________________________________
MultithreadedSelectDeadlock.zip (application/x-zip-compressed, 141.5 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.