API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 10th, 2017
462
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.98 KB | None | 0 0
raw download clone embed print report
  1. Queue: base
  2.  
  3. Worker: k6121-lm-job:13840:upload,base,traits_binding,products,products_bind,groups_bind,product_prices,products_soft_deletion,declined_trait_value_unbinding,images_deleting,videos,merge_users,delete_empty_product_groups
  4.  
  5. Payload: {"class"=>"CompaniesImport::CsvImportJob", "args"=>["f9988ebbef5334e44d1d80cf00d877dc67913bd6", "/home/sg/sites/sguide/releases/20170808115220/public/files/shared/companies_import.csv", {"import_id"=>"", "country_id"=>"24462", "region_id"=>"1", "limit"=>"15", "delete_file"=>true, "original_file_name"=>"Косметика Екатеринбург_1.csv"}]}
  6.  
  7. Exception:
  8. PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block : UPDATE "company_imports" SET "status" = 'error', "log" = 'загружено городов: 138 некорректные данные, email: "\"ИП, ООО\";\"Клиент\";\"URL\";\"E-mail\";\"город\";\"Код\";\"\";\"\"" некорректные данные, phone: "\"ИП, ООО\";\"Клиент\";\"URL\";\"E-mail\";\"город\";\"Код\";\"\";\"\"" некорректные данные, phone: "\"\";\"Эталон здоровья\";\"http://like-life.ru/\";\"etalonvita@yandex.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"Точка красоты\";\"www.точкакрасоты96.рф\";\"daryagryaznova@yandex.ru\";\"екатеринбург\";\"963\";\"\";\"\"" некорректные данные, phone: "\"\";\"Аромаркет\";\"http://www.aro-market.ru/\";\"ekb@aro-market.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"Мимишоп\";\"www.мимишоп.рф\";\"mimishop@list.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"RomaDoma\";\"http://www.romadoma.ru/\";\"info@romadoma.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"Proaroma\";\"http://proaroma.ru/\";\"info@proaroma.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"Пекин66\";\"http://pekin66.ru/\";\"info@pekin66.ru\";\"екатеринбург\";\"982\";\"\";\"\"" некорректные данные, phone: "\"\";\"Пчелки\";\"http://pchelky.ru/\";\"admin@pchelky.ru\";\"екатеринбург\";\"343\";\"\";\"\"" некорректные данные, phone: "\"\";\"Merk Nails Studio\";\"http://merknails.ru/\";\"info@merknails.ru\";\"екатеринбург\";\"912\";\"\";\"\"" компаний: 0 компаний с некорректным email: 1 компаний с некорректным городом: 0 компаний с некорректным телефоном: 10 Ошибка при загрузке базы компаний: PG::SyntaxError: ERROR: syntax error at or near ")" LINE 7: ); ^ : SELECT companies.id, lower(trim(contacts.value)) AS email FROM companies INNER JOIN addresses ON addresses.company_id = companies.id INNER JOIN contacts ON contacts.address_id = addresses.id WHERE lower(trim(contacts.value)) IN ( ); /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in `block in execute'' /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'' /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument'' /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'' /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/active_record.rb:67:in `log_with_newrelic_instrumentation'' /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:649:in `execute'' (eval):9:in `execute_with_at_active_record'' /home/sg/sites/sguide/releases/20170808115220/vendor/plugins/core_companies_import/lib/core_companies_import/csv.rb:203:in `prepare_companies'' /home/sg/sites/sguide/releases/20170808115220/vendor/plugins/core_companies_import/lib/core_companies_import/csv.rb:26:in `block in import!'' /home/sg/.gem/ruby/2.2.0/gems/redis-mutex-2.1.1/lib/redis/mutex.rb:81:in `with_lock'' ', "loaded_at" = '2017-08-08 13:12:20.478277' WHERE "company_imports"."id" = 30929
  9.  
  10. /home/sg/.gem/ruby/2.2.0/gems/apress-utils-2.3.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `async_exec'
  11. /home/sg/.gem/ruby/2.2.0/gems/apress-utils-2.3.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `exec_no_cache'
  12. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_delete'
  13. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  14. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  15. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  16. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/active_record.rb:67:in `log_with_newrelic_instrumentation'
  17. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:670:in `exec_delete'
  18. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in `update'
  19. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
  20. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/persistence.rb:359:in `update'
  21. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/locking/optimistic.rb:68:in `update'
  22. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/attribute_methods/dirty.rb:74:in `update'
  23. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/timestamp.rb:71:in `update'
  24. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/callbacks.rb:272:in `block in update'
  25. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:403:in `_run__2173902063640750725__update__923637068448585119__callbacks'
  26. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:405:in `__run_callback'
  27. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:385:in `_run_update_callbacks'
  28. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:81:in `run_callbacks'
  29. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/callbacks.rb:272:in `update'
  30. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/persistence.rb:348:in `create_or_update'
  31. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/callbacks.rb:264:in `block in create_or_update'
  32. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:436:in `_run__2173902063640750725__save__923637068448585119__callbacks'
  33. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:405:in `__run_callback'
  34. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:385:in `_run_save_callbacks'
  35. /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/callbacks.rb:81:in `run_callbacks'
  36. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/callbacks.rb:264:in `create_or_update'
  37. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/persistence.rb:84:in `save'
  38. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/validations.rb:50:in `save'
  39. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/attribute_methods/dirty.rb:22:in `save'
  40. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:259:in `block (2 levels) in save'
  41. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:313:in `block in with_transaction_returning_status'
  42. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  43. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:208:in `transaction'
  44. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:311:in `with_transaction_returning_status'
  45. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:259:in `block in save'
  46. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:270:in `rollback_active_record_state!'
  47. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:258:in `save'
  48. /home/sg/.gem/ruby/2.2.0/gems/active_scaffold-3.3.3/lib/active_scaffold/extensions/unsaved_record.rb:15:in `save_with_unsaved_flag'
  49. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/active_record_helper.rb:26:in `block in save'
  50. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/transaction.rb:858:in `with_database_metric_name'
  51. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent.rb:584:in `with_database_metric_name'
  52. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/active_record_helper.rb:25:in `save'
  53. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/persistence.rb:217:in `block in update_attributes'
  54. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:313:in `block in with_transaction_returning_status'
  55. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  56. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:208:in `transaction'
  57. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:311:in `with_transaction_returning_status'
  58. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/persistence.rb:215:in `update_attributes'
  59. /home/sg/sites/sguide/releases/20170808115220/vendor/plugins/core_companies_import/app/jobs/companies_import/csv_import_job.rb:38:in `block in execute'
  60. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  61. /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/transactions.rb:208:in `transaction'
  62. /home/sg/sites/sguide/releases/20170808115220/vendor/plugins/core_companies_import/app/jobs/companies_import/csv_import_job.rb:15:in `execute'
  63. /home/sg/.gem/ruby/2.2.0/gems/resque-integration-1.14.0/lib/resque/integration/unique.rb:104:in `perform'
  64. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:240:in `block (3 levels) in perform'
  65. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/resque.rb:41:in `block in around_perform_with_monitoring'
  66. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:363:in `perform_action_with_newrelic_trace'
  67. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/resque.rb:33:in `around_perform_with_monitoring'
  68. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:239:in `block (2 levels) in perform'
  69. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `call'
  70. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `block (3 levels) in perform'
  71. /home/sg/.gem/ruby/2.2.0/gems/resque-lock-1.1.0/lib/resque/plugins/lock.rb:80:in `around_perform_lock'
  72. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `block (2 levels) in perform'
  73. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `call'
  74. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `block (3 levels) in perform'
  75. /home/sg/.gem/ruby/2.2.0/gems/resque-integration-1.14.0/lib/resque/integration/backtrace.rb:8:in `around_perform_backtrace'
  76. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:235:in `block (2 levels) in perform'
  77. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `call'
  78. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/job.rb:247:in `perform'
  79. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:250:in `perform'
  80. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:189:in `block in work'
  81. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:166:in `loop'
  82. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/worker.rb:166:in `work'
  83. /home/sg/.gem/ruby/2.2.0/gems/resque-1.25.2/lib/resque/tasks.rb:41:in `block (2 levels) in '
  84. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:236:in `call'
  85. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:236:in `block in execute'
  86. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:231:in `each'
  87. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:231:in `execute'
  88. /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:33:in `block in execute_with_newrelic_trace'
  89. /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:363:in `perform_action_with_newrelic_trace'
  90. /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:32:in `execute_with_newrelic_trace'
  91. /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:23:in `execute'
  92. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
  93. /usr/lib64/ruby/2.2.0/monitor.rb:211:in `mon_synchronize'
  94. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:168:in `invoke_with_call_chain'
  95. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:161:in `invoke'
  96. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:149:in `invoke_task'
  97. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block (2 levels) in top_level'
  98. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `each'
  99. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block in top_level'
  100. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:115:in `run_with_threads'
  101. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:100:in `top_level'
  102. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:78:in `block in run'
  103. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handling'
  104. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
  105. /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/bin/rake:33:in `'
  106. /home/sg/.gem/ruby/2.2.0/bin/rake:22:in `load'
  107. /home/sg/.gem/ruby/2.2.0/bin/rake:22:in `'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!