-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Normal
-
None
-
Affects Version/s: None
-
Component/s: Edit system
-
None
https://musicbrainz.org/edit/140687708 was somehow submitted with:
{"new": {"tracklist": [{"id": 56034337, "name": "Chase", "length": 315000, "number": "1", "position": 1, "recording_id": "44849610", "artist_credit": {"names": [{"name": "Park Drive", "artist": {"id": "2921582", "name": "Park Drive"}, "join_phrase": ""}]}, "is_data_track": "0"}, {"id": 56034338, "name": "Follow Me (live on City Sound radio)", "length": 288000, "number": "2", "position": 2, "recording_id": "44849611", "artist_credit": {"names": [{"name": "Park Drive", "artist": {"id": "2921582", "name": "Park Drive"}, "join_phrase": ""}]}, "is_data_track": "0"}, {"id": null, "name": "Mango Mirror (acoustic)", "length": 0, "number": "3", "position": 3, "recording_id": null, "artist_credit": {"names": [{"name": "Park Drive", "artist": {"id": "2921582", "name": "Park Drive"}, "join_phrase": ""}]}, "is_data_track": "0"}]}, "old": {"tracklist": [{"id": 56034337, "name": "Chase", "length": 315000, "number": "1", "position": 1, "recording_id": "44849610", "artist_credit": {"names": [{"name": "Park Drive", "artist": {"id": "2921582", "name": "Park Drive"}, "join_phrase": ""}]}, "is_data_track": "0"}, {"id": 56034338, "name": "Follow Me (live on City Sound radio)", "length": 288000, "number": "2", "position": 2, "recording_id": "44849611", "artist_credit": {"names": [{"name": "Park Drive", "artist": {"id": "2921582", "name": "Park Drive"}, "join_phrase": ""}]}, "is_data_track": "0"}]}, "release": {"id": 5511367, "name": "Chase"}, "entity_id": 5982167}
which caused an ISE:
DBD::Pg::st execute failed: ERROR: new row for relation "recording" violates check constraint "recording_length_check"
(note: I've already manually fixed the edit to replace the 0 length with null)