Skip to content

Instantly share code, notes, and snippets.

@ferbncode

ferbncode/error

Created July 13, 2017 08:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ferbncode/0f289e7368d58f3b4eae522d965d844f to your computer and use it in GitHub Desktop.
Save ferbncode/0f289e7368d58f3b4eae522d965d844f to your computer and use it in GitHub Desktop.
Download ZIP
Failed query (fetching releases)
Raw
error
perl dump-entities-sql.pl release_group 8ef859e3-feb2-4dd1-93da-22b91280d768
-- Automatically generated, do not edit.
-- release_group 8ef859e3-feb2-4dd1-93da-22b91280d768
SET client_min_messages TO 'warning';
-- Temporarily drop triggers.
DROP TRIGGER deny_deprecated ON link;
ALTER TABLE medium DISABLE TRIGGER ALL;INSERT INTO area (begin_date_day, begin_date_month, begin_date_year, comment, edits_pending, end_date_day, end_date_month, end_date_year, ended, gid, id, last_updated, name, type) VALUES
(NULL, NULL, NULL, '', 0, NULL, NULL, NULL, '0', '489ce91b-6658-3307-9877-795b68554c98', 222, '2013-06-15 18:06:39.59323+00', 'United States', 1),
(NULL, NULL, NULL, '', 0, NULL, NULL, NULL, '0', 'a71b0d32-7752-49e9-8594-2247ad6ac12c', 10861, '2014-12-17 15:02:24.481268+00', 'Brooklyn', 5),
(NULL, NULL, NULL, '', 0, NULL, NULL, NULL, '0', 'ab42be96-8579-4952-b29a-5cbdf7227e7e', 22398, '2013-11-11 17:15:10.807333+00', 'Agoura Hills', 3);
INSERT INTO artist (area, begin_area, begin_date_day, begin_date_month, begin_date_year, comment, edits_pending, end_area, end_date_day, end_date_month, end_date_year, ended, gender, gid, id, last_updated, name, sort_name, type) VALUES
(222, 10861, 4, 12, 1969, 'US rapper, formerly Jay-Z', 0, NULL, NULL, NULL, NULL, '0', 1, 'f82bcf78-5b69-4622-a5ef-73800768d9ac', 167, '2016-12-25 04:00:22.603122+00', 'JAY Z', 'JAY Z', 1),
(222, 22398, NULL, NULL, 1995, '', 0, NULL, NULL, NULL, NULL, '0', NULL, 'f59c5520-5f46-4d2c-b2c4-822eabf53419', 11330, '2015-09-23 21:00:36.940792+00', 'Linkin Park', 'Linkin Park', 2);
INSERT INTO artist_alias (artist, begin_date_day, begin_date_month, begin_date_year, edits_pending, end_date_day, end_date_month, end_date_year, ended, id, last_updated, locale, name, primary_for_locale, sort_name, type) VALUES
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 176, '2012-05-15 18:57:13.252186+00', NULL, 'Jay Z', '0', 'Jay Z', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 102, '2012-05-15 18:57:13.252186+00', NULL, 'Jayz', '0', 'Jayz', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 67507, '2012-05-15 18:57:13.252186+00', NULL, 'Jaÿ-Z', '0', 'Jaÿ-Z', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 6863, '2012-05-15 18:57:13.252186+00', NULL, 'Jay - Z', '0', 'Jay - Z', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '1', 175062, '2016-03-16 04:58:02.665073+00', NULL, 'Jay-Z', '0', 'Jay-Z', 1),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 74664, '2016-12-04 12:00:45.604632+00', NULL, 'S. Carter', '0', 'S. Carter', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 73267, '2016-12-04 12:00:45.604632+00', NULL, 'Shawn C Carter', '0', 'Shawn C Carter', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 48579, '2016-12-04 12:00:45.604632+00', NULL, 'Shawn Corey Carter', '0', 'Shawn Corey Carter', NULL),
(167, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 186272, '2016-12-04 12:00:45.604632+00', NULL, 'Shawn Carter', '0', 'Carter, Shawn', NULL),
(11330, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 14395, '2012-05-15 18:57:13.252186+00', NULL, 'Hybrid Theory', '0', 'Hybrid Theory', NULL),
(11330, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 1633, '2012-05-15 18:57:13.252186+00', NULL, 'Lincoln Park', '0', 'Lincoln Park', NULL),
(11330, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 14309, '2012-05-15 18:57:13.252186+00', NULL, 'Xero', '0', 'Xero', NULL),
(11330, NULL, NULL, NULL, 0, NULL, NULL, NULL, '0', 34211, '2012-05-15 18:57:13.252186+00', NULL, 'Limkin Park', '0', 'Limkin Park', NULL);
INSERT INTO tag (id, name, ref_count) VALUES
(7, 'rock', 65222),
(20, 'alternative rock', 8940),
(47, 'industrial rock', 272),
(62, 'rap', 2880),
(92, 'metal', 5349),
(111, 'american', 2199),
(150, 'hip-hop', 9611),
(235, 'hip hop', 3685),
(273, 'usa', 2112),
(349, 'nu metal', 366),
(553, 'hiphop', 242),
(644, 'new metal', 27),
(748, 'américain', 557),
(1072, 'alternative metal', 374),
(1091, 'pop rock', 3967),
(1102, 'rapcore', 68),
(1182, 'pop rap', 551),
(1277, 'rap metal', 71),
(1915, 'rapper', 129),
(2349, 'rap rock', 107),
(2976, 'us', 93),
(3295, 'nu-metal', 100),
(3678, 'mashup', 151),
(4662, 'rock and indie', 2005),
(4667, 'hip hop rnb and dance hall', 664),
(5221, 'united states', 112),
(36080, 'boom bap', 1),
(48881, 'east coast hip hop', 0),
(49117, 'hardcore hip hop', 0),
(49458, 'roxette', 0);
INSERT INTO artist_tag (artist, count, last_updated, tag) VALUES
(167, 0, '2016-12-04 12:00:45.604632+00', 62),
(167, 0, '2016-12-04 12:00:45.604632+00', 150),
(167, 2, '2016-12-04 12:00:45.604632+00', 235),
(167, 0, '2016-12-04 12:00:45.604632+00', 553),
(167, 2, '2016-12-04 12:00:45.604632+00', 1182),
(167, 0, '2016-12-04 12:00:45.604632+00', 1915),
(167, 0, '2016-12-04 12:00:45.604632+00', 2976),
(167, 1, '2016-12-04 12:00:45.604632+00', 3678),
(167, 0, '2016-12-04 12:00:45.604632+00', 4667),
(167, 0, '2016-12-04 12:00:45.604632+00', 5221),
(167, 1, '2016-12-04 12:00:45.604632+00', 36080),
(167, 2, '2016-12-04 12:00:45.604632+00', 48881),
(167, 1, '2016-12-04 12:00:45.604632+00', 49117),
(11330, 3, '2013-01-14 10:05:39.579132+00', 7),
(11330, 3, '2015-07-16 22:08:24.498981+00', 20),
(11330, 1, '2011-05-16 14:57:06.530063+00', 47),
(11330, 1, '2011-05-16 14:57:06.530063+00', 92),
(11330, 1, '2015-08-16 14:14:37.66654+00', 111),
(11330, 1, '2015-07-16 22:08:24.519938+00', 235),
(11330, 0, '2015-08-16 14:14:51.914034+00', 273),
(11330, 3, '2015-07-16 22:08:24.471133+00', 349),
(11330, 1, '2011-05-16 14:57:06.530063+00', 644),
(11330, 0, '2015-07-16 22:10:13.065471+00', 748),
(11330, 1, '2011-05-16 14:57:06.530063+00', 1072),
(11330, 1, '2015-07-16 22:08:24.50467+00', 1091),
(11330, 2, '2015-02-06 13:50:58.698582+00', 1102),
(11330, 1, '2011-05-16 14:57:06.530063+00', 1277),
(11330, 5, '2016-03-17 05:45:44.348841+00', 2349),
(11330, 0, '2015-07-16 22:11:53.211294+00', 3295),
(11330, 0, '2015-07-16 22:09:52.556986+00', 4662),
(11330, 0, '2015-08-16 14:14:51.897752+00', 5221),
(11330, 0, '2015-07-16 22:09:15.33297+00', 49458);
INSERT INTO artist_credit (artist_count, created, id, name, ref_count) VALUES
(2, '2014-04-12 07:28:03.370147+00', 1302095, 'Linkin Park & JAY Z', 18);
INSERT INTO artist_credit_name (artist, artist_credit, join_phrase, name, position) VALUES
(11330, 1302095, ' & ', 'Linkin Park', 0),
(167, 1302095, '', 'JAY Z', 1);
INSERT INTO release_group (artist_credit, comment, edits_pending, gid, id, last_updated, name, type) VALUES
(1302095, '', 0, '8ef859e3-feb2-4dd1-93da-22b91280d768', 1110052, '2015-02-15 23:01:28.86754+00', 'Collision Course', 3);
INSERT INTO tag (id, name, ref_count) VALUES
(43, 'heavy metal', 3753),
(188, 'crossover', 147),
(1216, 'hardcore rap', 14),
(4695, 'alternative and punk', 4997),
(5384, 'rap-metal', 4),
(6638, 'rap hip-hop', 75),
(21726, 'mash up', 38),
(31591, 'pop-rap', 3),
(41014, 'pop/rock', 0),
(41016, 'nü metal', 0);
INSERT INTO release_group_tag (count, last_updated, release_group, tag) VALUES
(3, '2013-11-01 04:57:21.463958+00', 1110052, 1216),
(7, '2014-09-12 12:45:46.756422+00', 1110052, 4695),
(1, '2012-01-29 19:00:09.103309+00', 1110052, 349),
(1, '2012-01-29 19:00:09.103309+00', 1110052, 6638),
(1, '2012-01-29 19:00:09.103309+00', 1110052, 7),
(1, '2012-01-29 19:00:09.103309+00', 1110052, 1277),
(3, '2012-07-12 09:39:47.927754+00', 1110052, 235),
(3, '2012-07-12 09:39:47.927754+00', 1110052, 188),
(4, '2014-09-12 12:45:46.756422+00', 1110052, 1072),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 41014),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 62),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 43),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 41016),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 31591),
(1, '2012-07-01 21:15:37.022811+00', 1110052, 5384),
(2, '2012-10-19 15:40:25.314912+00', 1110052, 21726),
(4, '2013-11-01 04:57:21.463958+00', 1110052, 150),
(2, '2014-09-12 12:45:46.756422+00', 1110052, 48881);
INSERT INTO url (edits_pending, gid, id, last_updated, url) VALUES
(0, 'e1340355-3ad0-4d6b-8eeb-ca219a95ec3f', 276953, '2016-10-14 05:00:02.571367+00', 'https://en.wikipedia.org/wiki/Collision_Course_(album)'),
(0, 'ba7a6f42-0ee2-44bd-bf21-7ed44c83ef3c', 1028345, '2016-07-29 17:00:02.40377+00', 'https://www.discogs.com/master/47318'),
(0, 'b38a5f72-059e-4894-b38c-865ca0a2992f', 1472711, '2012-08-27 10:23:40.136004+00', 'http://www.allmusic.com/album/mw0000709574'),
(0, '93bb8713-3c4a-4ec3-af07-e537f39326fc', 2294802, '2016-07-11 23:00:02.413799+00', 'https://www.wikidata.org/wiki/Q20001');
INSERT INTO link (attribute_count, begin_date_day, begin_date_month, begin_date_year, created, end_date_day, end_date_month, end_date_year, ended, id, link_type) VALUES
(0, NULL, NULL, NULL, '2011-05-16 15:03:23.368437+00', NULL, NULL, NULL, '0', 6303, 89),
(0, NULL, NULL, NULL, '2011-05-16 15:03:23.368437+00', NULL, NULL, NULL, '0', 6309, 90),
(0, NULL, NULL, NULL, '2011-07-28 21:43:56.077951+00', NULL, NULL, NULL, '0', 28614, 284),
(0, NULL, NULL, NULL, '2013-05-09 09:56:17.113888+00', NULL, NULL, NULL, '0', 117677, 353);
INSERT INTO l_release_group_url (edits_pending, entity0, entity0_credit, entity1, entity1_credit, id, last_updated, link, link_order) VALUES
(0, 1110052, '', 276953, '', 38402, '2012-01-29 19:00:09.103309+00', 6303, 0),
(0, 1110052, '', 1028345, '', 86656, '2012-01-29 19:00:09.103309+00', 6309, 0),
(0, 1110052, '', 1472711, '', 198438, '2012-09-10 08:00:12.99265+00', 28614, 0),
(0, 1110052, '', 2294802, '', 306086, '2013-12-09 00:26:00.690071+00', 117677, 0);
Failed query:
'SELECT release FROM release_group WHERE id = any(?) ORDER BY release'
(ARRAY(0x4c087a8))
42703 DBD::Pg::st execute failed: ERROR: column "release" does not exist
LINE 1: SELECT release FROM release_group WHERE id = any('{"1110052"...
^ [for Statement "SELECT release FROM release_group WHERE id = any(?) ORDER BY release" with ParamValues: 1='{"1110052"}']
at /home/ferbncode/musicbrainz-server/script/../lib/Sql.pm line 460.
Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x93fa570)) called at /home/ferbncode/perl5/lib/perl5/Try/Tiny.pm line 124
Try::Tiny::try(CODE(0x4dd8d80), Try::Tiny::Catch=REF(0x93fa750), Try::Tiny::Finally=REF(0x93fa798)) called at /home/ferbncode/musicbrainz-server/script/../lib/Sql.pm line 466
Sql::_select_list(Sql=HASH(0x47070f0), "SELECT release FROM release_group WHERE id = any(?) ORDER BY "..., ARRAY(0x4bb46d0), "arrayref", CODE(0x4c086b8)) called at /home/ferbncode/musicbrainz-server/script/../lib/Sql.pm line 485
Sql::select_list_of_lists(Sql=HASH(0x47070f0), "SELECT release FROM release_group WHERE id = any(?) ORDER BY "..., ARRAY(0x4c087a8)) called at /home/ferbncode/musicbrainz-server/script/../lib/Sql.pm line 416
Sql::select_single_column_array(Sql=HASH(0x47070f0), "SELECT release FROM release_group WHERE id = any(?) ORDER BY "..., ARRAY(0x4c087a8)) called at dump-entities-sql.pl line 326
main::dump_release_groups(MusicBrainz::Server::Context=HASH(0x1db6348), ARRAY(0x468edc8)) called at dump-entities-sql.pl line 362
main::main() called at dump-entities-sql.pl line 372
42703 DBD::Pg::st execute failed: ERROR: column "release" does not exist
LINE 1: SELECT release FROM release_group WHERE id = any('{"1110052"...
^ [for Statement "SELECT release FROM release_group WHERE id = any(?) ORDER BY release" with ParamValues: 1='{"1110052"}']%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment