Lucie created this task.
Lucie added a subscriber: Lucie.
Lucie added projects: Wikidata, WikibaseQueryEngine.
Lucie changed Security from none to none.
TASK 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
TASK DETAIL
https://phabricator.wikimedia.org/T78658
REPLY HANDLER ACTIONS
Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign
<username>.
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucie
Cc: Aklapper, Lucie, Wikidata-bugs, aude
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
