Imports broken due to missing usage id

10630
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: Imports broken due to missing usage id
Priority: Blocker
Resolution: Fixed
Status: Closed
Created: 2012-01-15 12:16:23.124
Updated: 2013-12-09 13:40:36.601
Resolved: 2012-01-27 12:06:43.449
        
Description: 13:44:28.254 Copy usages from import3.name_usage ...
13:44:28.987 Import failed! Error importing checklist from dwc archive /mnt/extra/ecat-indexing/checklists/3
org.gbif.checklistbank.imports.ChecklistImportError: Error importing checklist from dwc archive /mnt/extra/ecat-indexing/checklists/3
        at org.gbif.checklistbank.imports.ChecklistImportPgSql.processData(ChecklistImportPgSql.java:1644) ~[clb.jar:na]
        at org.gbif.checklistbank.service.impl.ChecklistImportServicePgSql.importChecklist(ChecklistImportServicePgSql.java:138) ~[clb.jar:na]
        at org.gbif.checklistbank.cli.CommandLineInterpreter.doImportResources(CommandLineInterpreter.java:502) [clb.jar:na]
        at org.gbif.checklistbank.cli.CommandLineInterpreter.main(CommandLineInterpreter.java:178) [clb.jar:na]
Caused by: org.gbif.checklistbank.jdbc.DataAccessException: insert into import3.classification (id,parent_fk,rank_fk,is_synonym)  SELECT u.id,u.parent_fk,u.rank_fk,u.is_synonym FROM import3.name_usage u join name_string n on u.name_fk=n.id order by n.scientific_name, n.id
        at org.gbif.checklistbank.jdbc.JdbcTemplate.executeUpdate(JdbcTemplate.java:228) ~[clb.jar:na]
        at org.gbif.checklistbank.service.impl.PgSqlBaseService.executeUpdate(PgSqlBaseService.java:254) ~[clb.jar:na]
        at org.gbif.checklistbank.imports.ClassificationGeneratorPgSql.updateImportClassification(ClassificationGeneratorPgSql.java:523) ~[clb.jar:na]
        at org.gbif.checklistbank.service.impl.ClassificationServicePgSql.updateImportClassification(ClassificationServicePgSql.java:218) ~[clb.jar:na]
        at org.gbif.checklistbank.imports.ChecklistImportPgSql.processData(ChecklistImportPgSql.java:1629) ~[clb.jar:na]
        ... 3 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[clb.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[clb.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[clb.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[clb.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[clb.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[clb.jar:na]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[clb.jar:na]
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[clb.jar:na]
        at org.gbif.checklistbank.jdbc.JdbcTemplate.executeUpdate(JdbcTemplate.java:226) ~[clb.jar:na]
        ... 7 common frames omitted]]>
    

Author: mdoering@gbif.org
Comment: the latest liquibase change had removed a sequence from the import table causing the error. Manually fixed the clb dbs and added it to liquibase
Created: 2012-01-27 12:06:43.478
Updated: 2012-01-27 12:06:43.478