IMPORT

2014-10-31 12:32:35 +0200
-- create_table("temp_products", {:id=>false})
   -> 0.0131s
-- add_index("temp_products", :external_code, {:unique=>true})
   -> 0.0070s
-- add_index("temp_products", :group_external_code)
   -> 0.0059s
2014-10-31T10:32:35Z 30994 TID-u6ci4 Import1c::ProductsImportWorker JID-11ddc0bff75cc6c720698409 INFO: fail: 3.47 sec
2014-10-31T10:32:35Z 30994 TID-u6ci4 WARN: {"retry"=>true, "queue"=>"default", "class"=>"Import1c::ProductsImportWorker", "args"=>[[321]], "jid"=>"11ddc0bff75cc6c720698409", "enqueued_at"=>1414751552.4323335, "error_message"=>"PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block\n:         INSERT INTO spree_variants(sku, code_1c, description)(\n          SELECT\n            trim(coalesce(tp.title, '')),\n            tp.external_code,\n            tp.short_description\n          FROM temp_products AS tp\n          LEFT JOIN spree_variants AS p\n            ON p.code_1c = tp.external_code\n          WHERE p.id IS NULL\n        )\n", "error_class"=>"ActiveRecord::StatementInvalid", "failed_at"=>2014-10-31 10:32:35 UTC, "retry_count"=>0}
2014-10-31T10:32:35Z 30994 TID-u6ci4 WARN: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
:         INSERT INTO spree_variants(sku, code_1c, description)(
          SELECT
            trim(coalesce(tp.title, '')),
            tp.external_code,
            tp.short_description
          FROM temp_products AS tp
          LEFT JOIN spree_variants AS p
            ON p.code_1c = tp.external_code
          WHERE p.id IS NULL
        )