Import Log for USDA PLANTS images

Started: June 05, 2018 12:14
Completed: 12:16:07
Failed: 12:16:07
Status: completed

Events (most recent first):

show warnings (8)

12:16:07 (ends) Complete
12:16:07 (ends) TOTAL TIME: 1.6m
12:16:07 (errors) Mysql2::Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'eol_web_staging.page_contents.position' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT COUNT(*) AS count_all, `page_contents`.`page_id` AS page_contents_page_id FROM `page_contents` WHERE `page_contents`.`page_id` IN (47124031, 1033071, 596059, 1061732, 1033078, 584458, 1034953, 596060, 1033074, 49944499, 1061728, 47105601, 1061727, 481950, 584456, 49166407, 1033079, 642979, 584739, 39940157, 49322435, 642655, 648386, 49909878, 49897391, 468842, 649008, 418438, 108288, 643770, 1123481, 392751, 582251, 643764, 418432, 596593, 47116405, 49123866, 49123868, 661835, 663357, 684065, 49909896, 666957, 49909897, 49946967, 684149, 49507846, 582249, 47116410, 418414, 1145984, 49946969, 49944712, 49909898, 468702, 49299197, 639984, 49909899, 49322427, 49123894, 655496, 690308, 593681, 49909901, 582252, 1115565, 8684941, 686955, 467225, 49901930, 11260586, 583069, 418885, 49946069, 49123913, 687277, 49946973, 596730, 49909885, 49123919, 49910485, 49123922, 1143015, 595010, 49909884, 596824, 648693, 583071, 417618, 49909904, 230884, 583070, 594790, 691015, 689285, 583073, 467230, 689739, 1115804, 49123934, 596408, 47372146, 642124, 417613, 49909876, 417376, 49909883, 582246, 49296282, 594656, 468705, 49946974, 49946975, 49946976, 690383, 583072, 582247, 49909906, 417606, 2860542, 690612, 47116267, 49944714, 49946070, 595760, 640000, 483779, 49909907, 596823, 47276650, 47116321, 47116268, 596963, 47116432, 1153892, 49123955, 595628, 468512, 597687, 637532, 594988, 488744, 646813, 597685, 595629, 640387, 1115619, 581628, 1115730, 1115620, 1114003, 49946071, 584981, 640551, 582235, 1114006, 582241, 1249737, 582243, 640699, 1115621, 1115622, 582244, 581940, 640049, 49947401, 641109, 1115624, 1114746, 1114007, 1115626, 416860, 416861, 49944716, 688586, 697126, 1113993, 1083810, 47141503, 49947831, 49123991, 579119, 468155, 596789, 1033627, 1114170, 1114171, 1115618, 1114166, 1114012, 1115805, 468160, 966731, 49946075, 1083882, 1114163, 596788, 1114011, 1114167, 1260720, 1114173, 579122, 579797, 401721, 579123, 587250, 1114174, 468167, 49124007, 637540, 1083907, 1114175, 1113994, 579126, 49947944, 1114176, 1114177, 1113995, 1114164, 1114178, 1083935, 579127, 579110, 1113996, 637541, 1114179, 579800, 579129, 49909833, 579130, 1083967, 1083970, 1083972, 8694536, 1114180, 1114181, 637546, 579111, 637548, 1113998, 49946079, 579803, 1114182, 579116, 47158167, 637549, 1114169, 1114183, 578484, 49124036, 579806, 1084032, 1113999, 5614169, 1114137, 48301989, 49946082, 71151, 1114138, 579638, 579637, 1084210, 47113972, 1114187, 49910011, 1114186, 583948, 49947661, 49235788, 1084258, 1084162, 1271473, 1084337, 1084338, 1114191, 2483230, 1084354, 1084355, 644072, 1114009, 583949, 1084451, 1084167, 1084499, 1084517, 1114188, 49124080, 1145874, 1084191, 49947668, 597505, 1145865, 1296948, 1296947, 640054, 580712, 47115113, 596590, 1145649, 49322468, 791888, 1114193, 1084748, 1084743, 1084752, 49948288, 645932, 49947673, 584767, 1084793, 596346, 586920, 580669, 1084197, 49505636, 646484, 47160959, 1085717, 1145613, 584460, 1145612, 642391, 646579, 1084926, 1114194, 1084944, 49947677, 1145611, 1084993, 1084200, 1085044, 1114139, 1085051, 1085061, 1084202, 1085092, 642408, 1085100, 1085098, 49322486, 49948289, 47280747, 641093, 468194, 47128714, 411731, 49945807, 587129, 468175, 1114196, 582305, 49945025, 583152, 633503, 1085758, 468195, 585582, 47128686, 1114195, 638811, 49531703, 585502, 585579, 585504, 416296, 640055, 642105, 1244793, 583150, 582307, 585506, 585507, 585509, 468215, 49945808, 47114029, 642106, 468210, 585511, 49945810, 633509, 583151, 580094, 584988, 474361, 1085787, 49299263, 640057, 49944720, 592501, 585490, 584992, 468222, 585493, 49946089, 585492, 48434083, 633516, 49910089, 596679, 585494, 633519, 581404, 49947329, 468218, 468221, 597119, 585496, 792891, 584989, 467917, 583434, 596329, 1114202, 5038877, 468395, 1114146, 581755, 580760, 1114197, 581756, 597034, 49299049, 596394, 596392, 584997, 1054913, 467920, 468394, 1126520, 1085862, 584734, 596602, 467919, 1114203, 1115617, 1114204, 1114199, 1054891, 584995, 1115763, 49124232, 49124233, 1114002, 1114145, 47140958, 1276530, 581763, 597029, 595161, 1114209, 585588, 1114205, 581753, 468228, 578449, 405042, 596846, 49299050, 49946093, 1054863, 49124257, 467891, 583476, 1114147, 580761, 596398, 467978, 396380, 638813, 467912, 583717, 47155878, 596347, 596397, 1114023, 1054183, 592384, 591742, 1054831, 1114200) GROUP BY `page_contents`.`page_id` ORDER BY `page_contents`.`position` ASC
12:16:07 (errors) gem:activesupport-4.2.10/lib/active_support/dependencies.rb:240:in `load_dependency'
12:16:07 (errors) gem:activesupport-4.2.10/lib/active_support/dependencies.rb:274:in `require'
12:16:07 (errors) bin/rails:4:in `<main>'
12:16:03 (infos) Batch 0/16...
12:16:03 (infos) 15856 Media to process (in 16 batches)
12:16:03 (starts) MediaContentCreator#by_resource
12:16:03 (starts) MediaContentCreator
12:16:03 (starts) Fixing native nodes...
12:16:03 (warns) Skipping reindexing. You should reindex soon.
12:16:03 (infos) importing 68 Pages
12:16:03 (infos) importing 1000 Pages
12:16:02 (infos) importing 1000 Pages
12:16:02 (infos) importing 1000 Pages
12:16:02 (infos) importing 1000 Pages
12:16:01 (infos) importing 1000 Pages
12:16:00 (infos) importing 1000 Pages
12:16:00 (infos) importing 1000 Pages
12:15:59 (infos) importing 1000 Pages
12:15:59 (infos) importing 1000 Pages
12:15:58 (infos) importing 1000 Pages
12:15:58 (infos) importing 1000 Pages
12:15:57 (infos) importing 1000 Pages
12:15:38 (starts) create_new_pages
12:15:38 (starts) PageCreator
12:15:38 (warns) Trait Publishing failed: Couldn't load the external resource at: https://demo:fungi@beta.eol.org/traits_469.csv
12:15:37 (warns) MISSING http://eol-repo-app:3000/data/usda_plants_imag/publish_metadata.tsv [404] (7 bytes); skipping
12:15:37 (warns) MISSING http://eol-repo-app:3000/data/usda_plants_imag/publish_traits.tsv [404] (7 bytes); skipping
12:15:37 (starts) #publish_traits
12:15:37 (starts) Remove traits
12:15:37 (warns) MISSING http://eol-repo-app:3000/data/usda_plants_imag/publish_references.tsv [404] (7 bytes); skipping
12:15:37 (starts) Reference
12:15:37 (starts) #propagate_ids ImageInfo
12:15:36 (starts) #import ImageInfo
12:15:36 (starts) ImageInfo
12:15:36 (starts) #propagate_ids Attribution
12:15:35 (starts) #import Attribution
12:15:35 (starts) Attribution
12:15:35 (starts) #propagate_ids Medium
12:15:31 (starts) #import Medium
12:15:31 (starts) Medium
12:15:31 (warns) MISSING http://eol-repo-app:3000/data/usda_plants_imag/publish_articles.tsv [404] (7 bytes); skipping
12:15:31 (starts) Article
12:15:29 (starts) #propagate_ids Vernacular
12:15:21 (starts) #import Vernacular
12:15:21 (starts) Vernacular
12:15:18 (starts) #propagate_ids NodeAncestor
12:15:06 (starts) #import NodeAncestor