Skip site navigation (1) Skip section navigation (2)

Re: Possible bug in ECPGlib thread-safety (Postgres

From: Philip Yarra <philip(at)utiba(dot)com>
To: Demetres Pantermalis <dpant(at)intracom(dot)gr>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Possible bug in ECPGlib thread-safety (Postgres
Date: 2003-12-04 12:08:12
Message-ID: Pine.LNX.4.44.0312042302230.11170-100000@ser1.cpc.net.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi Demetres, I'm the guy whose emails you quoted below! 

You *must* always use the AT conn_name in a multi-threaded application... 
using SET CONNECTION will not work.

I assume your test results work if you use the thread test application as 
included (I wrote it, so I'd be interested to know if it works, as I have 
not tested RH9 and SunOS5.8 (though I tested RH7.3 and SunOS2.6)

Regards, Philip Yarra.

On Thu, 4 Dec 2003, Demetres Pantermalis wrote:

> Dear All,
> 
> trying to run some tests for the thread-safety of the ecpg library, I
> modified the test_thread.pgc to be like the one attached (test_thread1.pgc).
> 
> The changes are as follows:
> 1) All the connections used for insertions, begin in main function (and not
> inside each thread)
> 2) The statement "EXEC SQL SET CONNECTION <conn> followed by the inserts is
> used, instead of the"EXEC SQL AT <conn> ..." statement.
> 3) A new line for ECPGlog was added.
> 
> The results of executing the code are unexpected. Either a core dump
> results, or one of the two threads inserts the rows in the table and the
> process never returns to OS prompt, while the other thread seems to insert
> the rows, but never commits.
> 
> A log file produced by ECPGlog is also attached.
> 
> Platforms tested: SunOS 5.8 and Linux RH9 (with the same results)
> 
> Any suggestions appreciated.
> 
> PS. I've found out that somebody else had about the same problem, but that
> was during testing phase and I assumed that it could have been solved by
> now. The links found are:
> http://archives.postgresql.org/pgsql-hackers/2003-06/msg00513.php
> http://archives.postgresql.org/pgsql-hackers/2003-06/msg00792.php
> 
> Demetres Pantermalis
> Intracom SA
> Network Support Systems.
> 


In response to

Responses

pgsql-interfaces by date

Next:From: Demetres PantermalisDate: 2003-12-04 12:47:27
Subject: Re: Possible bug in ECPGlib thread-safety (Postgres 7.4)...
Previous:From: Demetres PantermalisDate: 2003-12-04 11:43:24
Subject: Possible bug in ECPGlib thread-safety (Postgres 7.4)...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group