dcsimg

Import Log for Paleobiology Database

  • Started: February 25, 2022 07:56
  • Completed: 01:45:35.000
  • Failed: No.
  • Status: completed

Events (most recent first):

  • 01:45:35.000 (ends) Complete
  • 01:45:35.000 (ends) TOTAL TIME: 12.0h
  • 01:45:35.000 (infos) Removing trait and metadata files
  • 01:45:35.000 (infos) no metadata to add
  • 01:44:30.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_17.csv
  • 01:42:39.000 (warns) FAILED on build_nodes query (Trait), will re-try once...
  • 01:42:39.000 (warns) The transaction has been terminated. Retry your operation in a new transaction, and you should see a successful result. The transaction has not completed within the specified timeout (dbms.transaction.timeout). You may want to retry with a longer timeout.
  • 01:42:39.000 (warns) Exception (Neo4j::Driver::Exceptions::ClientException) QUERY: {USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM 'https://eol.org/data/paleobiology_db/new_traits_1645545266_1645721181_chunk_16.csv' AS row WITH row WHERE 1=1 MERGE (trait:Trait { eol_pk: row.eol_pk }) ON CREATE SET trait.resource_pk = row.resource_pk ON MATCH SET trait.resource_pk = row.resource_pk ON CREATE SET trait.source = row.source ON MATCH SET trait.source = row.source ON CREATE SET trait.literal = row.literal ON MATCH SET trait.literal = row.literal ON CREATE SET trait.measurement = row.measurement ON MATCH SET trait.measurement = row.measurement ON CREATE SET trait.scientific_name = row.scientific_name ON MATCH SET trait.scientific_name = row.scientific_name ON CREATE SET trait.normal_measurement = row.normal_measurement ON MATCH SET trait.normal_measurement = row.normal_measurement ON CREATE SET trait.sample_size = row.sample_size ON MATCH SET trait.sample_size = row.sample_size ON CREATE SET trait.citation = row.citation ON MATCH SET trait.citation = row.citation ON CREATE SET trait.remarks = row.remarks ON MATCH SET trait.remarks = row.remarks ON CREATE SET trait.method = row.method ON MATCH SET trait.method = row.method} MESSAGE: The transaction has been terminated. Retry your operation in a new transaction, and you should see a successful result. The transaction has not completed within the specified timeout (dbms.transaction.timeout). You may want to retry with a longer timeout.
  • 01:40:48.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_16.csv
  • 00:20:40.000 (infos) Waiting 4800 seconds for the last 'chunk' to be added to neo4j...
  • 00:19:11.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_15.csv
  • 23:04:09.000 (infos) Waiting 4500 seconds for the last 'chunk' to be added to neo4j...
  • 23:02:39.000 (warns) FAILED on build_nodes query (Trait), will re-try once...
  • 23:02:39.000 (warns) The transaction has been terminated. Retry your operation in a new transaction, and you should see a successful result. The transaction has not completed within the specified timeout (dbms.transaction.timeout). You may want to retry with a longer timeout.
  • 23:02:39.000 (warns) Exception (Neo4j::Driver::Exceptions::ClientException) QUERY: {USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM 'https://eol.org/data/paleobiology_db/new_traits_1645545266_1645721181_chunk_14.csv' AS row WITH row WHERE 1=1 MERGE (trait:Trait { eol_pk: row.eol_pk }) ON CREATE SET trait.resource_pk = row.resource_pk ON MATCH SET trait.resource_pk = row.resource_pk ON CREATE SET trait.source = row.source ON MATCH SET trait.source = row.source ON CREATE SET trait.literal = row.literal ON MATCH SET trait.literal = row.literal ON CREATE SET trait.measurement = row.measurement ON MATCH SET trait.measurement = row.measurement ON CREATE SET trait.scientific_name = row.scientific_name ON MATCH SET trait.scientific_name = row.scientific_name ON CREATE SET trait.normal_measurement = row.normal_measurement ON MATCH SET trait.normal_measurement = row.normal_measurement ON CREATE SET trait.sample_size = row.sample_size ON MATCH SET trait.sample_size = row.sample_size ON CREATE SET trait.citation = row.citation ON MATCH SET trait.citation = row.citation ON CREATE SET trait.remarks = row.remarks ON MATCH SET trait.remarks = row.remarks ON CREATE SET trait.method = row.method ON MATCH SET trait.method = row.method} MESSAGE: The transaction has been terminated. Retry your operation in a new transaction, and you should see a successful result. The transaction has not completed within the specified timeout (dbms.transaction.timeout). You may want to retry with a longer timeout.
  • 23:00:53.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_14.csv
  • 21:50:50.000 (infos) Waiting 4200 seconds for the last 'chunk' to be added to neo4j...
  • 21:49:49.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_13.csv
  • 20:44:46.000 (infos) Waiting 3900 seconds for the last 'chunk' to be added to neo4j...
  • 20:43:46.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_12.csv
  • 19:43:43.000 (infos) Waiting 3600 seconds for the last 'chunk' to be added to neo4j...
  • 19:42:41.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_11.csv
  • 18:47:39.000 (infos) Waiting 3300 seconds for the last 'chunk' to be added to neo4j...
  • 18:46:38.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_10.csv
  • 17:56:37.000 (infos) Waiting 3000 seconds for the last 'chunk' to be added to neo4j...
  • 17:55:35.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_9.csv
  • 17:10:34.000 (infos) Waiting 2700 seconds for the last 'chunk' to be added to neo4j...
  • 17:09:33.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_8.csv
  • 16:49:32.000 (infos) Waiting 1200 seconds for the last 'chunk' to be added to neo4j...
  • 16:48:32.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_7.csv
  • 16:31:01.000 (infos) Waiting 1050 seconds for the last 'chunk' to be added to neo4j...
  • 16:29:59.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_6.csv
  • 16:14:59.000 (infos) Waiting 900 seconds for the last 'chunk' to be added to neo4j...
  • 16:13:56.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_5.csv
  • 16:01:26.000 (infos) Waiting 750 seconds for the last 'chunk' to be added to neo4j...
  • 16:00:24.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_4.csv
  • 15:50:23.000 (infos) Waiting 600 seconds for the last 'chunk' to be added to neo4j...
  • 15:49:21.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_3.csv
  • 15:41:51.000 (infos) Waiting 450 seconds for the last 'chunk' to be added to neo4j...
  • 15:40:48.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_2.csv
  • 15:35:48.000 (infos) Waiting 300 seconds for the last 'chunk' to be added to neo4j...
  • 15:34:46.000 (infos) Importing 128000 rows from new_traits_1645545266_1645721181_chunk_1.csv
  • 15:34:46.000 (warns) Found 2140044 rows, will break up into 128000
  • 15:34:45.000 (infos) adding new traits
  • 15:34:45.000 (infos) removed 2021385 traits
  • 13:43:29.000 (infos) removing traits specified in diff file
  • 13:43:27.000 (infos) Connecting to https://content.eol.org/ ...
  • 13:43:15.000 (infos) Connecting to https://content.eol.org/ ...
  • 13:43:14.000 (infos) polling for trait diff metadata: /resources/532/publish_diffs.json?since=1645622839
  • 13:43:14.000 (starts) #publish_traits = TraitBank::Slurp.load_resource_from_repo