Re: Deadlock when executing multiple select statements from multiple threads

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Ayman Samamry <Ayman(dot)Samamry(at)ir(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, Henry Santosa <Henry(dot)Santosa(at)ir(dot)com>, Denn Sporcic <Denn(dot)Sporcic(at)ir(dot)com>
Subject: Re: Deadlock when executing multiple select statements from multiple threads
Date: 2018-04-13 08:52:25
Message-ID: 66e9a5db-f150-e32b-86da-c740926544e9@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

On 2018/04/11 12:03, Inoue, Hiroshi wrote:
> Hi Ayman,
>
> Thanks for the report.
> I would examine the issue.

Could you please try the test drivers 10.02.0100 on Windows at
    https://winpg.jp/~inoue/psqlodbc/index.html
?

regards,
Hiroshi Inoue

>
> regards,
> Hiroshi Inoue
>
> On 2018/04/10 14:51, Ayman Samamry wrote:
>>
>> 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.
>> _______________________________________________________________________

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ayman Samamry 2018-04-16 00:41:04 RE: Deadlock when executing multiple select statements from multiple threads
Previous Message Inoue, Hiroshi 2018-04-11 03:03:43 Re: Deadlock when executing multiple select statements from multiple threads