search

aodn / content

Tracks AODN Portal content and configuration issues
0 stars 0 forks source link

talend soop_sst_harvest failing #125

Closed danfruehauf closed 9 years ago

danfruehauf commented 9 years ago

Errors in the form of:

Exception in component tPostgresqlCommit_1
org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
        at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:813)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlCommit_1Process(SOOP_SST_Data_Harvest.java:12420)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlInput_3Process(SOOP_SST_Data_Harvest.java:12355)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlInput_2Process(SOOP_SST_Data_Harvest.java:10847)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlInput_1Process(SOOP_SST_Data_Harvest.java:9459)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.iNetCDFInput_1Process(SOOP_SST_Data_Harvest.java:8850)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlRow_1Process(SOOP_SST_Data_Harvest.java:909)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.tPostgresqlConnection_1Process(SOOP_SST_Data_Harvest.java:762)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.iIncludeSdiLibraries_1Process(SOOP_SST_Data_Harvest.java:639)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.runJobInTOS(SOOP_SST_Data_Harvest.java:12852)
        at soop_sst.soop_sst_data_harvest_2_0.SOOP_SST_Data_Harvest.runJob(SOOP_SST_Data_Harvest.java:12715)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.iHarvestResources_1Process(SOOP_SST_harvester.java:2227)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.iDeletedResources_1Process(SOOP_SST_harvester.java:1999)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.iPostgresqlDbUpdate_1Process(SOOP_SST_harvester.java:1676)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.iIndexFiles_1_iFilesProcess(SOOP_SST_harvester.java:3155)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.runJobInTOS(SOOP_SST_harvester.java:4919)
        at soop_sst.soop_sst_harvester_2_0.SOOP_SST_harvester.main(SOOP_SST_harvester.java:4707)
Exception while processing /mnt/imos-t3/IMOS/opendap/SOOP/SOOP-SST/C6FS9_Stadacona/2012/IMOS_SOOP-SST_MT_20120104T010000Z_C6FS9_FV01_C-20120528T070907Z.nc

Not entirely sure what it means.

jonescc commented 9 years ago

The harvester is trying to commit a transaction using tPostgresqlCommit_1 when autocommit is turned on (probably in the tPostgresqlConnection options). Harvester needs to be modified - shouldn't be trying to commit in two ways like this.

danfruehauf commented 9 years ago

Closed by https://github.com/aodn/harvesters/pull/285