Skip to content

Instantly share code, notes, and snippets.

@janhoy

janhoy/log.txt

Created June 10, 2020 11:20
Show Gist options
  • Save janhoy/5ff8003acb2b548bcacbb57409c4c74e to your computer and use it in GitHub Desktop.
Save janhoy/5ff8003acb2b548bcacbb57409c4c74e to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade to 6.2 prerelease migration failure
Raw
log.txt
$ docker-compose run --rm app bin/rake db:migrate
Pulling app (o19s/quepid:6.2-prerelease)...
6.2-prerelease: Pulling from o19s/quepid
7568c21980bd: Pull complete
4a9f2207c812: Pull complete
6fe350d2b140: Pull complete
d95a2fdc8b3d: Pull complete
760eb225f9e8: Pull complete
6ba1f6b9517b: Pull complete
ce86e3018f7e: Pull complete
a6cea0b60396: Pull complete
5cac564727b9: Pull complete
05e70ecad675: Pull complete
4624a69c038b: Pull complete
1341f98f0ab5: Pull complete
13905178c107: Pull complete
41de33e9f404: Pull complete
1c80938cbaca: Pull complete
36af165e7a5e: Pull complete
362e0ac6266f: Pull complete
a19d32e248b0: Pull complete
bad5762dae66: Pull complete
Digest: sha256:306ef465d02feb0efaba62d0e7724c214f62ad68fdabec08e6fb840d30887a4b
Status: Downloaded newer image for o19s/quepid:6.2-prerelease
Running via Spring preloader in process 17
ActiveRecord::SchemaMigration Load (0.8ms) SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to DropDefaultFromDefaultScorer (20200313204611)
== 20200313204611 DropDefaultFromDefaultScorer: migrating =====================
-- remove_column(:default_scorers, :default)
(48.5ms) ALTER TABLE `default_scorers` DROP `default`
-> 0.0491s
== 20200313204611 DropDefaultFromDefaultScorer: migrated (0.0492s) ============
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200313204611')
(3.8ms) COMMIT
Migrating to DropCommunalFromScorers (20200314193226)
== 20200314193226 DropCommunalFromScorers: migrating ==========================
-- remove_column(:scorers, :communal)
(21.4ms) ALTER TABLE `scorers` DROP `communal`
-> 0.0217s
== 20200314193226 DropCommunalFromScorers: migrated (0.0218s) =================
(0.8ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200314193226')
(4.0ms) COMMIT
Migrating to RenameUsersUsernameToEmail (20200413184942)
== 20200413184942 RenameUsersUsernameToEmail: migrating =======================
-- rename_column(:users, :username, :email)
(8.7ms) ALTER TABLE `users` CHANGE `username` `email` varchar(80) DEFAULT NULL
-> 0.0131s
== 20200413184942 RenameUsersUsernameToEmail: migrated (0.0132s) ==============
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200413184942')
(4.2ms) COMMIT
Migrating to UpdateDemoSolrEsToNonDefaultPorts (20200428150211)
== 20200428150211 UpdateDemoSolrEsToNonDefaultPorts: migrating ================
Try Load (0.9ms) SELECT `tries`.* FROM `tries` WHERE (search_url like '%quepid-solr.dev.o19s.com:8983/solr%')
Try Load (0.8ms) SELECT `tries`.* FROM `tries` WHERE (search_url like '%quepid-elasticsearch.dev.o19s.com:9200%')
== 20200428150211 UpdateDemoSolrEsToNonDefaultPorts: migrated (0.0047s) =======
(0.6ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200428150211')
(4.2ms) COMMIT
Migrating to MigrateUserDefaultScorer (20200517162038)
== 20200517162038 MigrateUserDefaultScorer: migrating =========================
-- foreign_keys("users")
(1.1ms) SELECT fk.referenced_table_name as 'to_table'
,fk.referenced_column_name as 'primary_key'
,fk.column_name as 'column'
,fk.constraint_name as 'name'
FROM information_schema.key_column_usage fk
WHERE fk.referenced_column_name is not null
AND fk.table_schema = 'quepid'
AND fk.table_name = 'users'
(0.8ms) SHOW CREATE TABLE `users`
-> 0.0027s
-- remove_foreign_key(:users, {:column=>:default_scorer_id})
(0.9ms) SELECT fk.referenced_table_name as 'to_table'
,fk.referenced_column_name as 'primary_key'
,fk.column_name as 'column'
,fk.constraint_name as 'name'
FROM information_schema.key_column_usage fk
WHERE fk.referenced_column_name is not null
AND fk.table_schema = 'quepid'
AND fk.table_name = 'users'
(0.8ms) SHOW CREATE TABLE `users`
(7.0ms) ALTER TABLE `users` DROP FOREIGN KEY fk_rails_3c4ba42168
-> 0.0096s
(4.0ms) UPDATE users
SET default_scorer_id = scorer_id
WHERE scorer_id IS NOT NULL
-- add_column(:scorers, :communal, :boolean, {:default=>false})
(21.9ms) ALTER TABLE `scorers` ADD `communal` tinyint(1) DEFAULT 0
-> 0.0225s
== 20200517162038 MigrateUserDefaultScorer: migrated (0.0395s) ================
(0.7ms) BEGIN
SQL (0.8ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200517162038')
(3.9ms) COMMIT
Migrating to AddNewDefaultScorers (20200517162819)
== 20200517162819 AddNewDefaultScorers: migrating =============================
Scorer Load (0.7ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'v1' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.7ms) BEGIN
SQL (0.8ms) INSERT INTO `scorers` (`name`, `scale`, `code`, `communal`, `query_test`, `created_at`, `updated_at`) VALUES ('v1', '1,2,3,4,5,6,7,8,9,10', '// Gets the average score over a scale of 100\n// (assumes query rating on a scale of 1-10)\nvar score = avgRating100(10);\nif (score !== null) {\n // Adds a distance penalty to the score\n score -= editDistanceFromBest(10);\n}\nsetScore(score);\n', 1, 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(5.0ms) COMMIT
Scorer Load (0.9ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'nDCG@5' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.7ms) BEGIN
SQL (0.8ms) INSERT INTO `scorers` (`name`, `scale`, `show_scale_labels`, `code`, `communal`, `manual_max_score`, `manual_max_score_value`, `scale_with_labels`, `query_test`, `created_at`, `updated_at`) VALUES ('nDCG@5', '0,1,2,3,4', 1, 'var k = 5 // @Rank\n\nvar ideal = topRatings(k)\n\nk = ideal.length < k ? ideal.length : k\nvar scores = Array(k).fill(0);\n\nfunction DCG(vals, k) {\n var dcg = 0;\n for (var i = 0; i < k; i++) {\n var d = Math.log2(i + 2);\n var n = Math.pow(2, vals[i]) - 1;\n dcg += d ? (n / d) : 0;\n }\n return dcg;\n}\n\nfunction nDCG(vals, k) {\n var ideal = topRatings(k)\n var n = DCG(vals, k);\n var d = DCG(ideal, k);\n return d ? (n / d) : 0;\n}\n\neachDoc(function (doc, i) {\n if (hasDocRating(i)) {\n scores[i] = (docRating(i));\n }\n}, k)\n\nsetScore(nDCG(scores, k));\n', 1, 1, 1, '{\"0\":\"Irrelevant\",\"1\":\"Poor\",\"2\":\"Fair\",\"3\":\"Good\",\"4\":\"Perfect\"}', 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(5.2ms) COMMIT
Scorer Load (0.7ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'DCG@5' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.6ms) BEGIN
SQL (0.8ms) INSERT INTO `scorers` (`name`, `scale`, `show_scale_labels`, `code`, `communal`, `scale_with_labels`, `query_test`, `created_at`, `updated_at`) VALUES ('DCG@5', '0,1,2,3,4', 1, 'var k = 5 // @Rank\nvar score = 0;\n\neachDoc(function(doc, i) {\n var d = Math.log2(i+2); // i is the JSindex not the DocRank; 0 vs 1\n var n = Math.pow(2,docRating(i))-1; \n score += d?(n/d):0;\n}, k)\n\nsetScore(score);', 1, '{\"0\":\"Irrelevant\",\"1\":\"Poor\",\"2\":\"Fair\",\"3\":\"Good\",\"4\":\"Perfect\"}', 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(4.5ms) COMMIT
Scorer Load (0.8ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'CG@5' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `scorers` (`name`, `scale`, `show_scale_labels`, `code`, `communal`, `scale_with_labels`, `query_test`, `created_at`, `updated_at`) VALUES ('CG@5', '0,1,2,3,4', 1, 'var k = 5 // @Rank\nvar score = 0;\n\neachDoc(function(doc, i) {\n score += docRating(i);\n}, k)\n\nsetScore(score);', 1, '{\"0\":\"Irrelevant\",\"1\":\"Poor\",\"2\":\"Fair\",\"3\":\"Good\",\"4\":\"Perfect\"}', 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(4.0ms) COMMIT
Scorer Load (0.8ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'P@5' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.6ms) BEGIN
SQL (0.7ms) INSERT INTO `scorers` (`name`, `scale`, `show_scale_labels`, `code`, `communal`, `scale_with_labels`, `query_test`, `created_at`, `updated_at`) VALUES ('P@5', '0,1', 1, 'var k = 5 // @Rank\nvar score = avgRating(k);\n\nsetScore(score);', 1, '{\"0\":\"Irrelevant\",\"1\":\"Relevant\"}', 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(4.6ms) COMMIT
Scorer Load (0.8ms) SELECT `scorers`.* FROM `scorers` WHERE `scorers`.`name` = 'AP@5' ORDER BY `scorers`.`id` ASC LIMIT 1
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `scorers` (`name`, `scale`, `show_scale_labels`, `code`, `communal`, `scale_with_labels`, `query_test`, `created_at`, `updated_at`) VALUES ('AP@5', '0,1', 1, 'var k = 5; // @Rank\ntotal = 0\n\neachDoc(function(doc, i) {\n total += avgRating(i+1)\n}, k);\n\nvar score = total / k;\nsetScore(score);\n', 1, '{\"0\":\"Irrelevant\",\"1\":\"Relevant\"}', 0, '2020-06-10 11:17:39', '2020-06-10 11:17:39')
(4.3ms) COMMIT
== 20200517162819 AddNewDefaultScorers: migrated (0.0780s) ====================
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200517162819')
(3.9ms) COMMIT
Migrating to AddFkToScorers (20200517164239)
== 20200517164239 AddFkToScorers: migrating ===================================
-- remove_column(:users, :scorer_id)
(62.0ms) ALTER TABLE `users` DROP `scorer_id`
-> 0.0623s
-- add_foreign_key("users", "scorers", {:column=>"default_scorer_id"})
(37.7ms) ALTER TABLE `users` ADD CONSTRAINT `fk_rails_3c4ba42168`
FOREIGN KEY (`default_scorer_id`)
REFERENCES `scorers` (`id`)
-> 0.0384s
== 20200517164239 AddFkToScorers: migrated (0.1010s) ==========================
(0.7ms) BEGIN
SQL (0.7ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20200517164239')
(4.3ms) COMMIT
Migrating to RemoveScorerType (20200522215022)
== 20200522215022 RemoveScorerType: migrating =================================
(1.2ms)
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 1
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =1 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 2
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =2 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 3
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =3 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 4
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =4 and scorer_type = 'DefaultScorer'
// check that everything migrated
// select count(*) from cases where scorer_type = 'DefaultScorer'
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = ' at line 23:
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 1
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =1 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 2
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =2 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 3
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =3 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 4
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =4 and scorer_type = 'DefaultScorer'
// check that everything migrated
// select count(*) from cases where scorer_type = 'DefaultScorer'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `block in execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/mysql2_adapter.rb:217:in `execute'
/srv/app/db/migrate/20200522215022_remove_scorer_type.rb:10:in `change'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:608:in `exec_migration'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:591:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:590:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:768:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1023:in `block in execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1071:in `ddl_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1022:in `execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:984:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `each'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:823:in `up'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:801:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/tasks/database_tasks.rb:139:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `block in load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:240:in `load_dependency'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = ' at line 23:
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 1
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =1 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 2
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =2 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 3
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =3 and scorer_type = 'DefaultScorer'
INSERT INTO scorers (
code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
)
SELECT code,
name,
scale,
manual_max_score,
manual_max_score_value,
show_scale_labels,
scale_with_labels,
created_at,
updated_at
FROM default_scorers WHERE id = 4
SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = @last_id_in_scorers, scorer_type = 'Scorer' where scorer_id =4 and scorer_type = 'DefaultScorer'
// check that everything migrated
// select count(*) from cases where scorer_type = 'DefaultScorer'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `block in execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/mysql2_adapter.rb:217:in `execute'
/srv/app/db/migrate/20200522215022_remove_scorer_type.rb:10:in `change'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:608:in `exec_migration'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:591:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:590:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:768:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1023:in `block in execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1071:in `ddl_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1022:in `execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:984:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `each'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:823:in `up'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:801:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/tasks/database_tasks.rb:139:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `block in load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:240:in `load_dependency'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
Caused by:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @last_id_in_scorers = LAST_INSERT_ID();
update cases set scorer_id = ' at line 23
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/bundle/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `block in execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:317:in `execute'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/mysql2_adapter.rb:217:in `execute'
/srv/app/db/migrate/20200522215022_remove_scorer_type.rb:10:in `change'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:608:in `exec_migration'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:592:in `block (2 levels) in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:591:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:590:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:768:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1023:in `block in execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1071:in `ddl_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:1022:in `execute_migration_in_transaction'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:984:in `block in migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `each'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:980:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:823:in `up'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/migration.rb:801:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/tasks/database_tasks.rb:139:in `migrate'
/usr/local/bundle/gems/activerecord-4.2.11/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `block in load'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:240:in `load_dependency'
/usr/local/bundle/gems/activesupport-4.2.11/lib/active_support/dependencies.rb:268:in `load'
-e:1:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment