Trouble with COPY IN
От | Matthew Wakeling |
---|---|
Тема | Trouble with COPY IN |
Дата | |
Msg-id | alpine.DEB.2.00.1007161753160.8895@aragorn.flymine.org обсуждение исходный текст |
Ответы |
Re: Trouble with COPY IN
|
Список | 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.
В списке pgsql-jdbc по дате отправления: