[Bug] Duplicate statement errors on import
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	Lucie
	Dec 16 2014, 1:58 PM

Description

"I tried importing Q1 up to Q100 and encountered the following errors:

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q76", "item", "P580", 1, 1232409600, 1232409600, 1232496000, "7afbf3dffeb235c543393502beaa82d8"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7afbf3dffeb235c543393502beaa82d8-P580-Q76' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_entityid (subject_id, subject_type, property_id, statement_rank, value_id, value_type) VALUES (?, ?, ?, ?, ?, ?)' with params ["Q55", "item", "P518", 1, "Q2118709", "item"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Q2118709-P518-Q55' for key 'UNIQ_88B6BD45F920BBA2549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q80", "item", "P585", 1, 883612800, 883612800, 915169752, "a2b6e4ec3aa5d9f5d1184de2ea4f9884"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'a2b6e4ec3aa5d9f5d1184de2ea4f9884-P585-Q80' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_string (subject_id, subject_type, property_id, statement_rank, value, hash) VALUES (?, ?, ?, ?, ?, ?)' with params ["Q90", "item", "P554", 1, "paris", "paris"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'paris-P554-Q90' for key 'UNIQ_19C638B5D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q95", "item", "P580", 1, 1379635200, 1379635200, 1379721600, "5cca7f8231252331c13a2ce0ef473890"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5cca7f8231252331c13a2ce0ef473890-P580-Q95' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q35", "item", "P580", 1, 1167609600, 1167609600, 1167696000, "0fd2f2295683507391b4f25986c9b0f2"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0fd2f2295683507391b4f25986c9b0f2-P580-Q35' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_entityid (subject_id, subject_type, property_id, statement_rank, value_id, value_type) VALUES (?, ?, ?, ?, ?, ?)' with params ["Q34", "item", "P31", 1, "Q6869253", "item"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Q6869253-P31-Q34' for key 'UNIQ_88B6BD45F920BBA2549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q27", "item", "P580", 1, 94694400, 94694400, 94780800, "4210bf057fd490d985927c0f08dedc9c"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4210bf057fd490d985927c0f08dedc9c-P580-Q27' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q29", "item", "P580", 1, 504921600, 504921600, 505008000, "43ee1a5832bd4bd76b2849fb150004f1"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '43ee1a5832bd4bd76b2849fb150004f1-P580-Q29' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q30", "item", "P580", 1, -2529705600, -2529705600, -2529619200, "acb2df7defd9dbb41f14421b924337d5"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'acb2df7defd9dbb41f14421b924337d5-P580-Q30' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_time (subject_id, subject_type, property_id, statement_rank, value_timestamp, value_min_timestamp, value_max_timestamp, hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' with params ["Q33", "item", "P580", 1, 788918400, 788918400, 789004800, "db98f4cc686b307485b7230aa8f8cfd7"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'db98f4cc686b307485b7230aa8f8cfd7-P580-Q33' for key 'UNIQ_2CAE8640D1B862B8549213EC23EDC87'

1 times: An exception occurred while executing 'INSERT INTO qe_qualifier_entityid (subject_id, subject_type, property_id, statement_rank, value_id, value_type) VALUES (?, ?, ?, ?, ?, ?)' with params ["Q16", "item", "P31", 2, "Q3089219", "item"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Q3089219-P31-Q16' for key"

https://github.com/wmde/WikibaseQueryEngine/issues/99