X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F1798D1B4B9 for ; Thu, 4 Dec 2003 11:41:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16017-06 for ; Thu, 4 Dec 2003 07:41:12 -0400 (AST) Received: from mailserv.intranet.gr (mailserv.intranet.GR [146.124.14.106]) by svr1.postgresql.org (Postfix) with ESMTP id 65F1FD1B499 for ; Thu, 4 Dec 2003 07:41:07 -0400 (AST) Received: from mailserv.intranet.gr (localhost [127.0.0.1]) by mailserv.intranet.gr (8.11.7/8.11.3) with ESMTP id hB4BjFF04596 for ; Thu, 4 Dec 2003 13:45:15 +0200 (EET) Received: from alpha.intranet.gr (alpha.intranet.GR [146.124.12.11]) by mailserv.intranet.gr (8.11.7/8.11.3) with ESMTP id hB4BjEk04589 for ; Thu, 4 Dec 2003 13:45:14 +0200 (EET) Received: from csms (csms [146.124.12.43]) by alpha.intranet.gr (8.11.7p1+Sun/8.11.7) with SMTP id hB4Brgh22971 for ; Thu, 4 Dec 2003 13:53:42 +0200 (EET) From: "Demetres Pantermalis" To: Subject: Possible bug in ECPGlib thread-safety (Postgres 7.4)... Date: Thu, 4 Dec 2003 13:43:24 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0019_01C3BA6C.96988C80" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/12 X-Sequence-Number: 4621 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C3BA6C.96988C80 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: 7bit 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 followed by the inserts is used, instead of the"EXEC SQL AT ..." 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. ------=_NextPart_000_0019_01C3BA6C.96988C80 Content-Type: application/x-gzip; name="thr_sfty.tar.gz" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="thr_sfty.tar.gz" H4sIAIoXzz8CA+1XbXPaRhDmq/QrNu6kEcS1dRIvNhjPECynTDE4IPIyjscj xAHXgkSlw22m8X/vniRAmBfjevySKfsBxGlv99lnb/cWTn1+xfsetTpkb9Sz E48gKlHVbDqdUFFIOht8q1r4GyWtZzIJNZfL6lk1o6sarpOMlsHvxBPI2OeW hy5Hrs97HvVX61HPXxekiImoUVC5xA8i+ykZUpIZHADgeBhg5Lk9zxqK5fY3 OO+zARvBF8vzLFzal2X5J+bYg3GHwtEoPDh7/ePYos87A9YWa/K1yzqSxByf KOIxWZitaJMV2fhslKH5oQrvjPeVGpwY5WqpYUDTKJuVeq0g233LkwAg1Wk7 1pAWZOZw8RsYp57Fmev4UASiFmaWjNrJoh2xTx5azFHwASyvZ++CsA0pfL6+ uEzK/8hSFNEVl6Ka2JUlKXrWCndilQQ2yXP/8u9EI7EuKAIFHIEG378HiOAY 9KQsIRCpO/LQWFdBOqnn7cJOy7d6NA+vfQiJgIsZAZdfnZ1dCOJQL5FUxED5 2HOA4PONLEU7iqEKuZzzXywGTqU5Pi3uMiXQ1gKDQjum8BoxvyqCugpsTHWI FQZtCpYD9Jo64IyHbeoh4CU4hZce5dS5VnaQuvq5uZNMglE+f9+h7XFPIbuh h2QBMIIpw+V6rYbEglmHfBRqqRmcZjwVm6iRzdS0zdT0Qhxc0zAnupj5CSpZ 2k/BSaN+DkPW63PoWmwgymu2L3hplt5VjWBP1KTnEDSMkmks6ihD6ovDAqbx 2UzOYz47q5jwqd74Lb58UmlOopnCm1SCjZ+cKj9P6gFqrWp1F4LyhRQoqWT0 iIkSlR4qCK/LLWh3WdAWLfzuYtXOAVjxdrZ3fQL0wtz7qoi8XG/VTAQDlZpI qShiOG3Uz1ayvxGX+qTUAntYarPKEDUX1c3OV6c5tm1M215UGHTg07n3p3hA xh6dvI/qBlN1E/ZZedZmRSMLGpHE4sg+/WrUjI9GA/w/B1hDriceAgcFGSJZ RxoRoXRxm8KwQagFYNi6YoW+DxquvX0b9YQJ9JA5IJAX2aUeZ05vUv1Td5Va 02iYIfUxvuFjqdoymsqbKPlvgsyuNg0d16GR8ZtVuZrEessKkDzY7nDIeGRg VUoDHpZAEL5fhXsxJ9OkaI+aFO1BSQHt4UnRlidlZvpBSdE2TIq2JCli81xS Elu5LeJu3Ru4vcf0ccf8nyEqmcz/uUxGjNBET6vZ7fz/BHJBdP1Av8zPhqw8 +JQDd4HIcy9t13GozfPgjqiD7QI6Frfalk9hNATXgaMT47TUqprHMHKx6Gc/ /wdm6N/UHnMKA+ZQyOBF8qFlNL5g9/HcEaDBAZ1roMJy5BmbdDhzrTUI9T/y sYFwna42dR7OXbDEvwLxCRG7blK03nuC0gJQ8Rl0Xpt7Ft4/oa4OVmi1GHXz uKfibV/UHvWuusxhfh8d3IIE9sD1aWdvDbQDfcpBdAPhteDOMXBtDcbUV2A6 WCAFi/GTtU6C+KM7Ulezh5oeLxnepx4F5oM1EB6+gQUBIxERzAn/aGMepls8 i/niDOIEYLv4V/qXrKqvQUDUzH3j1JbHqT0Fmdr6UBbYzCCbyASEU9HmdD47 Y8uCyQJ5kbhyLxTXwQvAtaTCD4G8wFLR1duwYr2XqId3N98NaAin9eeOfjEn Onn+nCxBpa1JyUHuXhmZtj7H/S9XSHpZF11tarNrmEyv4e1fqK1sZStb+SHl XxjLrwEAHgAA ------=_NextPart_000_0019_01C3BA6C.96988C80--