Hi all,
I am relatively new working with SQL Workbench so excuse me if the answer to my problem is obvious.
I am trying to copy a table from one database to another using the data pumper. Everything seems to be set correctly and once I start the data pumping I see in my task manager that the workbench is using the network followed by using some RAM memory but then it suddenly stops working. The workbench log file shows the following:
2018-11-01 16:43:08 INFO Creating table using sql: CREATE TABLE earth.loww_a320_201707_201801_enriched
(
LIST OF COLUMNS
)
2018-11-01 16:43:09 INFO Statement for insert: INSERT INTO earth.loww_a320_201707_201801_enriched (LIST OF COLUMNS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2018-11-01 16:43:09 INFO Starting import for table earth.loww_a320_201707_201801_enriched
2018-11-01 16:43:56 ERROR Error releasing savepoint A result was returned when none was expected. [SQL State=0100E]
org.postgresql.util.PSQLException: A result was returned when none was expected.
at org.postgresql.jdbc.PgConnection.execSQLUpdate(PgConnection.java:442)
at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:1658)
at workbench.db.WbConnection.rollback(WbConnection.java:790)
at workbench.db.datacopy.QueryCopySource.start(QueryCopySource.java:178)
at workbench.db.importer.DataImporter.startImport(DataImporter.java:764)
at workbench.db.datacopy.DataCopier.startCopy(DataCopier.java:590)
at workbench.db.datacopy.DataCopier$1.run(DataCopier.java:561)
Trying to copy another table with less rows (110.000 vs 690.000 for the one I try to copy) works perfectly but I just can't get this table to be copied.
Anyone an idea of what might be wrong? Is it something with the table itself?
Thanks in advance,
Jeroen