| From: | Leif Jensen <leif(at)crysberg(dot)dk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Soren Haxvig <sh(at)crysberg(dot)dk>, Danny Ørndrup <dannyo(at)crysberg(dot)dk> |
| Subject: | Multithread problem: Error in transaction processing |
| Date: | 2008-03-10 07:09:14 |
| Message-ID: | Pine.LNX.4.58.0803100747400.13361@samba.crysberg.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Guys,
We have a system with a multithreaded daemon running on Linux using
PostgreSQL 8.2.4 Embedded SQL in C. Most of the threads are doing database
access and they have each their own conection which is opened when the
thread is created (as one of the first things within the thread).
We pretty often gets the error:
-401:08007 Error in transaction processing in line 200
which is where there is an EXEC SQL AT :xxx START TRANSACTION ...
I have checked and re-checked the code for non- coomit/rollback and
added lots of test output to verify that every transaction is either
committed or rolled back. I have also made sure that there is no
cross-thread use of connection, especially looking at the test output.
Any ideas ?
Leif
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2008-03-10 07:30:55 | Re: large object import |
| Previous Message | Raymond O'Donnell | 2008-03-10 06:55:48 | Re: loading a psql input file on win xp |