Deadlock when executing multiple select statements from multiplethreads

Поиск
Список
Период
Сортировка
От Ayman Samamry
Тема Deadlock when executing multiple select statements from multiplethreads
Дата
Msg-id E1ABCC87AAEA0A4C939B08AAB318F5587A1EE2@ir-mail2-srv
обсуждение исходный текст
Ответы Re: Deadlock when executing multiple select statements from multiplethreads  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список 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.
_______________________________________________________________________
Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Clemens Ladisch
Дата:
Сообщение: Re: Bug in SQLRowCount ?
Следующее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: Deadlock when executing multiple select statements from multiplethreads