From: | "John Lyssy" <jlyssy(at)charter(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2538: Hang on insert/select |
Date: | 2006-07-18 13:55:03 |
Message-ID: | 200607181355.k6IDt3gB029098@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2538
Logged by: John Lyssy
Email address: jlyssy(at)charter(dot)net
PostgreSQL version: 8.1.4
Operating system: Windows 2003 Server
Description: Hang on insert/select
Details:
Client application hangs on doing insert and/or select statement
2006-07-18 08:13:31 ERROR: duplicate key violates unique constraint
"document_addrbook_xref_pkey"
2006-07-18 08:13:31 ERROR: duplicate key violates unique constraint
"document_addrbook_xref_pkey"
2006-07-18 08:13:31 ERROR: duplicate key violates unique constraint
"document_addrbook_xref_pkey"
2006-07-18 08:13:31 ERROR: duplicate key violates unique constraint
"document_addrbook_xref_pkey"
I use insert statements to reload the same datafile and use the primary key
constraint to drop any already loaded data (e.g. I want the db constraint to
ignore inserts), after running for a few hours the client application hangs.
There are other php scripts importing data into other databases. I cancel
the hung insert command and the script starts working. I made a modification
to an import php script and want to verify that I have processed all data.
From | Date | Subject | |
---|---|---|---|
Next Message | Thiago Silva | 2006-07-19 17:03:26 | XML2 module: odd query results |
Previous Message | somas | 2006-07-18 09:57:10 | BUG #2537: PHP-Postgres connection fails |