From: | Matthew Wakeling <matthew(at)flymine(dot)org> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Trouble with COPY IN |
Date: | 2010-07-16 16:56:52 |
Message-ID: | alpine.DEB.2.00.1007161753160.8895@aragorn.flymine.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
I'm having some trouble with a COPY IN BINARY statement. I have the
following stack trace:
Caused by: java.sql.SQLException: Error writing to database, running
statement COPY InterMineObject (OBJECT, class, tableclass, longObjType,
fullTime, dateObjType, floatType, longType, booleanType, booleanObjType,
title, bigDecimalObjType, stringObjType, doubleObjType, intObjType, name,
id, doubleType, shortObjType, rangeStart, intermine_end, seniority,
floatObjType, intType, shortType, vatNumber, debt, salary, rangeEnd,
address, age, addressId, bankId, companyId, departmentId,
businessAddressId, managerId, personalAddressId, parentId,
departmentThatRejectedMeId, CEOId) FROM STDIN BINARY
at org.intermine.sql.writebatch.FlushJobPostgresCopyImpl.flush(FlushJobPostgresCopyImpl.java:56)
at org.intermine.sql.writebatch.Batch$BatchFlusher.run(Batch.java:456)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: Tried to end inactive copy
at org.postgresql.core.v3.QueryExecutorImpl.endCopy(QueryExecutorImpl.java:803)
at org.postgresql.core.v3.CopyInImpl.endCopy(CopyInImpl.java:61)
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:181)
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:161)
at org.intermine.sql.writebatch.FlushJobPostgresCopyImpl.flush(FlushJobPostgresCopyImpl.java:51)
I have had a brief look at the JDBC driver code, and as far as I can see,
this shouldn't ever happen. All I did was call CopyManager.copyIn(). It
should have kept the correct locks to complete the operation.
For some reason, this seems to exhibit with some data but not with others.
Any clues would be very welcome.
Matthew
--
First law of computing: Anything can go wro
sig: Segmentation fault. core dumped.
From | Date | Subject | |
---|---|---|---|
Next Message | Hitoshi Harada | 2010-07-16 17:03:03 | Re: reducing NUMERIC size for 9.1 |
Previous Message | Robert Haas | 2010-07-16 16:56:33 | Re: SHOW TABLES |
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2010-07-16 17:32:01 | Re: Trouble with COPY IN |
Previous Message | Florence Cousin | 2010-07-13 19:09:20 | documentation on PGResultSetMetaData |