View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002215SymmetricDSBugpublic2015-02-24 15:032022-09-12 14:18
Reporterondrejhala Assigned To 
Prioritynormal 
Status closedResolutionduplicate 
Product Version3.7.6 
Target Version3.7.28Fixed in Version3.7.28 
Summary0002215: Error during use of dbexport feature on PostgreSQL database
DescriptionIllegal State Exception is fired during export of table from PosgreSQL database v8.4.2 with dbexport tool.

Exception message: Cannot translate a java.lang.Long into a byte[].

This happens only on tables with large object column.
Steps To ReproduceCall dbexport on PosgreSQL database v8.4.2 on table that contains column with type lo.

.\dbexport --engine SymmetricDsPSRV --format=csv --dir=C:\DBExport attachment
Additional InformationStructure of table:
CREATE TABLE attachment
(
  id integer NOT NULL,
  packed_len bigint NOT NULL,
  packed_len_id integer NOT NULL,
  buffer lo
)

Log OUTPUT:

Log output will be written to C:\SymmetricDS\symmetric-psrv-export/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=engine, value={SymmetricDsPSRV}
[] - AbstractCommandLauncher - Option: name=format, value={csv}
[] - AbstractCommandLauncher - Option: name=dir, value={C:\DBExport}
[] - JdbcDatabasePlatformFactory - Detected database 'PostgreSQL', version '8', protocol 'postgresql'
[] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSqlDat
abasePlatform
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.IllegalStateException: Cannot translate a java.lang.Long into a byte[]
        at org.jumpmind.db.sql.Row.toBytes(Row.java:72)
        at org.jumpmind.db.sql.Row.getBytes(Row.java:131)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.getStringValues(AbstractDatabasePlatform.java:487)
        at org.jumpmind.symmetric.io.data.DbExport$WriterWrapper.writeRow(DbExport.java:510)
        at org.jumpmind.symmetric.io.data.DbExport$1.mapRow(DbExport.java:222)
        at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:115)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:193)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:182)
        at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:123)
        at org.jumpmind.symmetric.io.data.DbExport.writeTable(DbExport.java:220)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:181)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:159)
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:149)
        at org.jumpmind.symmetric.DbExportCommand.executeWithOptions(DbExportCommand.java:192)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:190)
        at org.jumpmind.symmetric.DbExportCommand.main(DbExportCommand.java:75)
-------------------------------------------------------------------------------
Tagsdbimport/dbexport, dialect: postgresql, large objects

Relationships

duplicate of 0002328 closedchenson Error during use of dbexport feature on PostgreSQL database 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-02-24 15:03 ondrejhala New Issue
2015-02-24 15:04 ondrejhala Tag Attached: dbexport
2015-02-24 15:04 ondrejhala Tag Attached: large objects
2015-02-24 15:04 ondrejhala Tag Attached: lo
2015-02-24 15:04 ondrejhala Tag Attached: postgres
2015-02-24 15:04 ondrejhala Tag Attached: postgresql
2019-04-12 12:48 admin Tag Detached: lo
2019-04-12 12:48 admin Tag Detached: postgres
2019-04-12 16:40 admin Tag Renamed dbexport => dbimport/dbexport
2019-04-23 20:50 admin Tag Renamed postgresql => dialect: postgresql
2022-09-12 14:18 emiller Status new => closed
2022-09-12 14:18 emiller Resolution open => duplicate
2022-09-12 14:18 emiller Fixed in Version => 3.7.28
2022-09-12 14:18 emiller Relationship added duplicate of 0002328