Trouble with COPY IN

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.

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-jdbc by date

  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