INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.3s ago] {'barcode': , 'wms_id_1': 100024} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.2s ago] {'pk_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00017s] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00032s] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00295s] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] [{'cell_id': None, 'reservation_id': 38884438}, {'cell_id': None, 'reservation_id': 38884439}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.3s ago] {'pk_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02809s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02231s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.0201s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02218s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01869s ago] [{'cell_id': None, 'reservation_id': 38884438}, {'cell_id': None, 'reservation_id': 38884439}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.3s ago] {'pk_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04815s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04196s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03976s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03812s ago] {'param_1': 488363} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03398s ago] [{'cell_id': None, 'reservation_id': 38884438}, {'cell_id': None, 'reservation_id': 38884439}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.4s ago] {'barcode': , 'wms_id_1': 100024} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.2s ago] {'pk_1': 103242} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00016s] {'param_1': 103242} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00024s] {'id': 103242} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.5s ago] {'barcode': , 'wms_id_1': 100091} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.4s ago] {'pk_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1337s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1289s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.13s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1285s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1246s ago] [{'cell_id': None, 'reservation_id': 38884445}, {'cell_id': None, 'reservation_id': 38884446}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.4s ago] {'pk_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1631s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1576s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1555s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.154s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1499s ago] [{'cell_id': None, 'reservation_id': 38884445}, {'cell_id': None, 'reservation_id': 38884446}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.4s ago] {'pk_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1797s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1768s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1759s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1746s ago] {'param_1': 488386} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1707s ago] [{'cell_id': None, 'reservation_id': 38884445}, {'cell_id': None, 'reservation_id': 38884446}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.5s ago] {'barcode': , 'wms_id_1': 100091} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.3s ago] {'pk_1': 103248} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1292s ago] {'param_1': 103248} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1287s ago] {'id': 103248} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.6s ago] {'barcode': , 'wms_id_1': 100039} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.5s ago] {'pk_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2504s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.245s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2428s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2412s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2381s ago] [{'cell_id': None, 'reservation_id': 38884449}, {'cell_id': None, 'reservation_id': 38884450}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.5s ago] {'pk_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2662s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2604s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2592s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2581s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.254s ago] [{'cell_id': None, 'reservation_id': 38884449}, {'cell_id': None, 'reservation_id': 38884450}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.5s ago] {'pk_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2827s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2785s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2766s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2756s ago] {'param_1': 488392} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2716s ago] [{'cell_id': None, 'reservation_id': 38884449}, {'cell_id': None, 'reservation_id': 38884450}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.6s ago] {'barcode': , 'wms_id_1': 100039} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.4s ago] {'pk_1': 103250} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2313s ago] {'param_1': 103250} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2286s ago] {'id': 103250} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.7s ago] {'barcode': , 'wms_id_1': 100001} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.6s ago] {'pk_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3532s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.348s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3459s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3445s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3414s ago] [{'cell_id': None, 'reservation_id': 38884454}, {'cell_id': None, 'reservation_id': 38884455}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.6s ago] {'pk_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3679s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.362s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3601s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3588s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3552s ago] [{'cell_id': None, 'reservation_id': 38884454}, {'cell_id': None, 'reservation_id': 38884455}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.6s ago] {'pk_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3813s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3758s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3737s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3721s ago] {'param_1': 488396} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.368s ago] [{'cell_id': None, 'reservation_id': 38884454}, {'cell_id': None, 'reservation_id': 38884455}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE picking_task SET worker_id=%(worker_id)s WHERE picking_task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00028s] {'worker_id': 0, 'id_1': 1499565} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00031s] {'status': , 'worker_id_1': 33349} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00019s] {'status': , 'current_assembly_id': None, 'barcode_1': '12.18.1.46'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.8s ago] {'barcode': , 'wms_id_1': 100059} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.6s ago] {'pk_1': 103252} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3618s ago] {'param_1': 103252} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3588s ago] {'id': 103252} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07997s ago] {'status': , 'worker_id_1': 33349} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08061s ago] {'status': , 'current_assembly_id': None, 'barcode_1': '12.18.1.46'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'barcode': , 'wms_id_1': 100061} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'barcode': , 'wms_id_1': 100348} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.7s ago] {'pk_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5129s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5085s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5064s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5055s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5015s ago] [{'cell_id': None, 'reservation_id': 38884457}, {'cell_id': None, 'reservation_id': 38884458}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.8s ago] {'pk_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.527s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5208s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5185s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5169s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5126s ago] [{'cell_id': None, 'reservation_id': 38884457}, {'cell_id': None, 'reservation_id': 38884458}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.8s ago] {'pk_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5372s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5314s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5295s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5282s ago] {'param_1': 488399} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5243s ago] [{'cell_id': None, 'reservation_id': 38884457}, {'cell_id': None, 'reservation_id': 38884458}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE picking_task SET worker_id=%(worker_id)s WHERE picking_task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1577s ago] {'worker_id': 0, 'id_1': 1499567} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1563s ago] {'status': , 'worker_id_1': 33349} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1463s ago] {'status': , 'current_assembly_id': None, 'barcode_1': '12.18.1.47'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'barcode': , 'wms_id_1': 100324} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.7s ago] {'pk_1': 103256} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.505s ago] {'param_1': 103256} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5033s ago] {'id': 103256} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.226s ago] {'status': , 'worker_id_1': 33349} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2258s ago] {'status': , 'current_assembly_id': None, 'barcode_1': '12.18.1.47'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235s ago] {'barcode': , 'wms_id_1': 100213} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235s ago] {'barcode': , 'wms_id_1': 100334} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'pk_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6575s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6525s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6504s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6497s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6465s ago] [{'cell_id': None, 'reservation_id': 38884461}, {'cell_id': None, 'reservation_id': 38884462}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'pk_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6726s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6673s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6655s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6641s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6601s ago] [{'cell_id': None, 'reservation_id': 38884461}, {'cell_id': None, 'reservation_id': 38884462}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 234.9s ago] {'pk_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6857s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6796s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6774s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6758s ago] {'param_1': 488402} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6716s ago] [{'cell_id': None, 'reservation_id': 38884461}, {'cell_id': None, 'reservation_id': 38884462}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235s ago] {'barcode': , 'wms_id_1': 100334} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.8s ago] {'pk_1': 103257} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6281s ago] {'param_1': 103257} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6282s ago] {'id': 103257} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'barcode': , 'wms_id_1': 100334} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'barcode': , 'wms_id_1': 100334} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 232.9s ago] {'pk_1': 103258} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6833s ago] {'param_1': 103258} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.6824s ago] {'id': 103258} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'barcode': , 'wms_id_1': 100334} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'barcode': , 'wms_id_1': 100319} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235s ago] {'pk_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8068s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8017s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.7993s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.7977s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'cell_id': None, 'sku_cell_id': 1279420} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235s ago] {'pk_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8192s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.814s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8117s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.81s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01206s ago] {'cell_id': None, 'sku_cell_id': 1279420} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'pk_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8305s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8241s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8218s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8202s ago] {'param_1': 488403} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02448s ago] {'cell_id': None, 'sku_cell_id': 1279420} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'barcode': , 'wms_id_1': 100332} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'pk_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8442s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8379s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8356s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.834s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03598s ago] {'cell_id': None, 'sku_cell_id': 1279421} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'pk_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8543s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8479s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8456s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8439s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04595s ago] {'cell_id': None, 'sku_cell_id': 1279421} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.1s ago] {'pk_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8674s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8616s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8596s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8587s ago] {'param_1': 488404} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.06158s ago] {'cell_id': None, 'sku_cell_id': 1279421} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233s ago] {'pk_1': 103259} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8123s ago] {'param_1': 103259} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8102s ago] {'id': 103259} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.3s ago] {'barcode': , 'wms_id_1': 100343} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'pk_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9342s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9294s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9276s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9264s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9227s ago] [{'cell_id': None, 'reservation_id': 38884463}, {'cell_id': None, 'reservation_id': 38884465}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'pk_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9477s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9414s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9393s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9376s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9339s ago] [{'cell_id': None, 'reservation_id': 38884463}, {'cell_id': None, 'reservation_id': 38884465}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.2s ago] {'pk_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9589s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9524s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9502s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9485s ago] {'param_1': 488406} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9442s ago] [{'cell_id': None, 'reservation_id': 38884463}, {'cell_id': None, 'reservation_id': 38884465}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.1s ago] {'pk_1': 103260} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9001s ago] {'param_1': 103260} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8972s ago] {'id': 103260} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.2s ago] {'pk_1': 103261} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9488s ago] {'param_1': 103261} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.9456s ago] {'id': 103261} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.4s ago] {'barcode': , 'wms_id_1': 100260} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.3s ago] {'pk_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.07s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.064s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.062s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.061s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.057s ago] [{'cell_id': None, 'reservation_id': 38884466}, {'cell_id': None, 'reservation_id': 38884467}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.3s ago] {'pk_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.083s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.077s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.075s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.073s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.069s ago] [{'cell_id': None, 'reservation_id': 38884466}, {'cell_id': None, 'reservation_id': 38884467}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.3s ago] {'pk_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.094s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.087s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.085s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.083s ago] {'param_1': 488407} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.079s ago] [{'cell_id': None, 'reservation_id': 38884466}, {'cell_id': None, 'reservation_id': 38884467}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.3s ago] {'pk_1': 103262} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.034s ago] {'param_1': 103262} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.031s ago] {'id': 103262} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.3s ago] {'pk_1': 103263} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.082s ago] {'param_1': 103263} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.078s ago] {'id': 103263} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.6s ago] {'barcode': , 'wms_id_1': 100355} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.4s ago] {'pk_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.202s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.197s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.195s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.193s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'cell_id': None, 'reservation_id': 38884468} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.4s ago] {'pk_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.214s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.208s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.205s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.203s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01056s ago] {'cell_id': None, 'reservation_id': 38884468} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.5s ago] {'pk_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.224s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.219s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.216s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.215s ago] {'param_1': 488408} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02209s ago] {'cell_id': None, 'reservation_id': 38884468} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.4s ago] {'pk_1': 103264} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.172s ago] {'param_1': 103264} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.169s ago] {'id': 103264} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.6s ago] {'barcode': , 'wms_id_1': 100344} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.5s ago] {'pk_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.294s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.289s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.287s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.285s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.4873s ago] {'cell_id': None, 'sku_cell_id': 1279426} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.5s ago] {'pk_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.306s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.3s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.298s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.296s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.4984s ago] {'cell_id': None, 'sku_cell_id': 1279426} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.5s ago] {'pk_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.317s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.311s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.309s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.307s ago] {'param_1': 488409} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.509s ago] {'cell_id': None, 'sku_cell_id': 1279426} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.5s ago] {'pk_1': 103265} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.258s ago] {'param_1': 103265} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.256s ago] {'id': 103265} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.7s ago] {'barcode': , 'wms_id_1': 100001} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.6s ago] {'pk_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.381s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.376s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.374s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.373s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.575s ago] {'cell_id': None, 'sku_cell_id': 1279427} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.6s ago] {'pk_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.394s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.388s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.386s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.384s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.5859s ago] {'cell_id': None, 'sku_cell_id': 1279427} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason FROM cell WHERE cell.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 235.6s ago] {'pk_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned FROM lost_goods WHERE %(param_1)s = lost_goods.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.404s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key FROM reservation WHERE %(param_1)s = reservation.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.398s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.396s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.394s ago] {'param_1': 488410} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.596s ago] {'cell_id': None, 'sku_cell_id': 1279427} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 233.6s ago] {'pk_1': 103266} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.345s ago] {'param_1': 103266} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 1.34s ago] {'id': 103266} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode