Importer le journal pour 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