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 258.9s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100207}
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 258.8s ago] {'pk_1': 480174}
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.00014s] {'param_1': 480174}
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.00012s] {'param_1': 480174}
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.00012s] {'param_1': 480174}
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.00034s] {'param_1': 480174}
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.00013s] [{'cell_id': None, 'reservation_id': 38879809}, {'cell_id': None, 'reservation_id': 38879810}]
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 258.8s ago] {'pk_1': 480174}
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.02325s ago] {'param_1': 480174}
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.02049s ago] {'param_1': 480174}
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.01952s ago] {'param_1': 480174}
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.0176s ago] {'param_1': 480174}
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.0161s ago] [{'cell_id': None, 'reservation_id': 38879809}, {'cell_id': None, 'reservation_id': 38879810}]
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 258.8s ago] {'pk_1': 480174}
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.03525s ago] {'param_1': 480174}
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.03146s ago] {'param_1': 480174}
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.03044s ago] {'param_1': 480174}
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.02804s ago] {'param_1': 480174}
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.02641s ago] [{'cell_id': None, 'reservation_id': 38879809}, {'cell_id': None, 'reservation_id': 38879810}]
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 259s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100207}
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 256.9s ago] {'pk_1': 98666}
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.00012s] {'param_1': 98666}
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.00017s] {'id': 98666}
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 259s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100228}
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 258.9s ago] {'pk_1': 480198}
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.1051s ago] {'param_1': 480198}
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.102s ago] {'param_1': 480198}
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.1014s ago] {'param_1': 480198}
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.09919s ago] {'param_1': 480198}
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.09792s ago] [{'cell_id': None, 'reservation_id': 38879816}, {'cell_id': None, 'reservation_id': 38879817}]
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 258.9s ago] {'pk_1': 480198}
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.1185s ago] {'param_1': 480198}
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.115s ago] {'param_1': 480198}
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.1141s ago] {'param_1': 480198}
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.112s ago] {'param_1': 480198}
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.1106s ago] [{'cell_id': None, 'reservation_id': 38879816}, {'cell_id': None, 'reservation_id': 38879817}]
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 258.9s ago] {'pk_1': 480198}
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.1303s ago] {'param_1': 480198}
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.1285s ago] {'param_1': 480198}
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.1283s ago] {'param_1': 480198}
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.1262s ago] {'param_1': 480198}
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.1254s ago] [{'cell_id': None, 'reservation_id': 38879816}, {'cell_id': None, 'reservation_id': 38879817}]
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 259.1s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100228}
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 257s ago] {'pk_1': 98670}
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.09976s ago] {'param_1': 98670}
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.09775s ago] {'id': 98670}
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 259.1s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100341}
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 259s ago] {'pk_1': 480205}
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.2016s ago] {'param_1': 480205}
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.199s ago] {'param_1': 480205}
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.1981s ago] {'param_1': 480205}
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.1966s ago] {'param_1': 480205}
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.1955s ago] [{'cell_id': None, 'reservation_id': 38879819}, {'cell_id': None, 'reservation_id': 38879820}]
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 259s ago] {'pk_1': 480205}
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.2158s ago] {'param_1': 480205}
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.2121s ago] {'param_1': 480205}
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.2111s ago] {'param_1': 480205}
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.2088s ago] {'param_1': 480205}
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.2075s ago] [{'cell_id': None, 'reservation_id': 38879819}, {'cell_id': None, 'reservation_id': 38879820}]
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 259s ago] {'pk_1': 480205}
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.2271s ago] {'param_1': 480205}
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.2235s ago] {'param_1': 480205}
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.2225s ago] {'param_1': 480205}
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.2202s ago] {'param_1': 480205}
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.2187s ago] [{'cell_id': None, 'reservation_id': 38879819}, {'cell_id': None, 'reservation_id': 38879820}]
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 259.2s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100341}
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 257s ago] {'pk_1': 98672}
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.192s ago] {'param_1': 98672}
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.1903s ago] {'id': 98672}
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 259.2s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100396}
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 259.1s ago] {'pk_1': 480208}
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.294s ago] {'param_1': 480208}
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.2926s ago] {'param_1': 480208}
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.2916s ago] {'param_1': 480208}
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.2903s ago] {'param_1': 480208}
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.289s ago] [{'cell_id': None, 'reservation_id': 38879825}, {'cell_id': None, 'reservation_id': 38879826}]
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 259.1s ago] {'pk_1': 480208}
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.3087s ago] {'param_1': 480208}
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.3059s ago] {'param_1': 480208}
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.305s ago] {'param_1': 480208}
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.3026s ago] {'param_1': 480208}
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.3011s ago] [{'cell_id': None, 'reservation_id': 38879825}, {'cell_id': None, 'reservation_id': 38879826}]
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 259.1s ago] {'pk_1': 480208}
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.321s ago] {'param_1': 480208}
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.3187s ago] {'param_1': 480208}
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.3177s ago] {'param_1': 480208}
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.3154s ago] {'param_1': 480208}
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.314s ago] [{'cell_id': None, 'reservation_id': 38879825}, {'cell_id': None, 'reservation_id': 38879826}]
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.00015s] {'worker_id': 0, 'id_1': 1497158}
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.00010s] {'status': <SortingTaskStatus.CANCELED: 'CANCELED'>, '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.00018s] {'status': <AssemblyWallCellStatus.EMPTY: 'EMPTY'>, 'current_assembly_id': None, 'barcode_1': '12.12.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 259.3s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100094}
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 257.2s ago] {'pk_1': 98674}
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.3252s ago] {'param_1': 98674}
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.3246s ago] {'id': 98674}
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.08887s ago] {'status': <SortingTaskStatus.CANCELED: 'CANCELED'>, '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.08759s ago] {'status': <AssemblyWallCellStatus.EMPTY: 'EMPTY'>, 'current_assembly_id': None, 'barcode_1': '12.12.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 SELECT stock_return_task.id AS stock_return_task_id, stock_return_task.status AS stock_return_task_status, stock_return_task.warehouse_id AS stock_return_task_warehouse_id, stock_return_task.current_cell_barcode AS stock_return_task_current_cell_barcode, stock_return_task.current_sku_barcode AS stock_return_task_current_sku_barcode, stock_return_task.date_created AS stock_return_task_date_created, stock_return_task.date_returned AS stock_return_task_date_returned, stock_return_task.date_updated AS stock_return_task_date_updated, stock_return_task.worker_id AS stock_return_task_worker_id 
FROM stock_return_task 
WHERE stock_return_task.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 190.5s ago] {'pk_1': 39117}
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 259.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100215}
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 259.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100090}
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 259.3s ago] {'pk_1': 480216}
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.4662s ago] {'param_1': 480216}
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.4644s ago] {'param_1': 480216}
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.4643s ago] {'param_1': 480216}
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.4627s ago] {'param_1': 480216}
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.4616s ago] [{'cell_id': None, 'reservation_id': 38879829}, {'cell_id': None, 'reservation_id': 38879830}]
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 259.3s ago] {'pk_1': 480216}
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.4825s ago] {'param_1': 480216}
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.4798s ago] {'param_1': 480216}
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.4793s ago] {'param_1': 480216}
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.4774s ago] {'param_1': 480216}
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.476s ago] [{'cell_id': None, 'reservation_id': 38879829}, {'cell_id': None, 'reservation_id': 38879830}]
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 259.3s ago] {'pk_1': 480216}
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.4966s ago] {'param_1': 480216}
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.4934s ago] {'param_1': 480216}
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.4924s ago] {'param_1': 480216}
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.4901s ago] {'param_1': 480216}
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.4888s ago] [{'cell_id': None, 'reservation_id': 38879829}, {'cell_id': None, 'reservation_id': 38879830}]
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.1743s ago] {'worker_id': 0, 'id_1': 1497161}
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.1711s ago] {'status': <SortingTaskStatus.CANCELED: 'CANCELED'>, '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.1583s ago] {'status': <AssemblyWallCellStatus.EMPTY: 'EMPTY'>, 'current_assembly_id': None, 'barcode_1': '12.12.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 259.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100345}
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 257.3s ago] {'pk_1': 98678}
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.4796s ago] {'param_1': 98678}
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.4779s ago] {'id': 98678}
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.2387s ago] {'status': <SortingTaskStatus.CANCELED: 'CANCELED'>, '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.2376s ago] {'status': <AssemblyWallCellStatus.EMPTY: 'EMPTY'>, 'current_assembly_id': None, 'barcode_1': '12.12.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 SELECT stock_return_task.id AS stock_return_task_id, stock_return_task.status AS stock_return_task_status, stock_return_task.warehouse_id AS stock_return_task_warehouse_id, stock_return_task.current_cell_barcode AS stock_return_task_current_cell_barcode, stock_return_task.current_sku_barcode AS stock_return_task_current_sku_barcode, stock_return_task.date_created AS stock_return_task_date_created, stock_return_task.date_returned AS stock_return_task_date_returned, stock_return_task.date_updated AS stock_return_task_date_updated, stock_return_task.worker_id AS stock_return_task_worker_id 
FROM stock_return_task 
WHERE stock_return_task.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 190.6s ago] {'pk_1': 39119}
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 259.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100026}
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 259.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 259.4s ago] {'pk_1': 480222}
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.6146s ago] {'param_1': 480222}
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.6127s ago] {'param_1': 480222}
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.6121s ago] {'param_1': 480222}
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.6098s ago] {'param_1': 480222}
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.6083s ago] [{'cell_id': None, 'reservation_id': 38879833}, {'cell_id': None, 'reservation_id': 38879835}, {'cell_id': None, 'reservation_id': 38879837}, {'cell_id': None, 'reservation_id': 38879838}]
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 259.4s ago] {'pk_1': 480222}
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.6285s ago] {'param_1': 480222}
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.626s ago] {'param_1': 480222}
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.6251s ago] {'param_1': 480222}
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.6228s ago] {'param_1': 480222}
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.6216s ago] [{'cell_id': None, 'reservation_id': 38879833}, {'cell_id': None, 'reservation_id': 38879835}, {'cell_id': None, 'reservation_id': 38879837}, {'cell_id': None, 'reservation_id': 38879838}]
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 259.4s ago] {'pk_1': 480222}
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.642s ago] {'param_1': 480222}
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.6395s ago] {'param_1': 480222}
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.6393s ago] {'param_1': 480222}
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.6372s ago] {'param_1': 480222}
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.6359s ago] [{'cell_id': None, 'reservation_id': 38879833}, {'cell_id': None, 'reservation_id': 38879835}, {'cell_id': None, 'reservation_id': 38879837}, {'cell_id': None, 'reservation_id': 38879838}]
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 259.6s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 257.5s ago] {'pk_1': 98680}
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.6086s ago] {'param_1': 98680}
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.6071s ago] {'id': 98680}
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 259.6s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 259.6s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 257.5s ago] {'pk_1': 98682}
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.6629s ago] {'param_1': 98682}
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.6616s ago] {'id': 98682}
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 259.7s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 259.7s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 257.6s ago] {'pk_1': 98683}
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.7203s ago] {'param_1': 98683}
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.7158s ago] {'id': 98683}
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 259.7s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 259.7s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 257.6s ago] {'pk_1': 98684}
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.7728s ago] {'param_1': 98684}
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.7701s ago] {'id': 98684}
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 259.8s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100081}
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 259.8s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100020}
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 259.7s ago] {'pk_1': 480230}
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.874s ago] {'param_1': 480230}
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.8738s ago] {'param_1': 480230}
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.8729s ago] {'param_1': 480230}
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.8708s ago] {'param_1': 480230}
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.00013s] {'cell_id': None, 'sku_cell_id': 1271229}
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 259.7s ago] {'pk_1': 480230}
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.8901s ago] {'param_1': 480230}
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.8873s ago] {'param_1': 480230}
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.8864s ago] {'param_1': 480230}
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.8843s ago] {'param_1': 480230}
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.01331s ago] {'cell_id': None, 'sku_cell_id': 1271229}
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 259.7s ago] {'pk_1': 480230}
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.9024s ago] {'param_1': 480230}
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.8989s ago] {'param_1': 480230}
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.8981s ago] {'param_1': 480230}
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.8959s ago] {'param_1': 480230}
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.02486s ago] {'cell_id': None, 'sku_cell_id': 1271229}
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 259.8s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100397}
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 259.7s ago] {'pk_1': 480231}
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.9159s ago] {'param_1': 480231}
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.9132s ago] {'param_1': 480231}
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.9122s ago] {'param_1': 480231}
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.9099s ago] {'param_1': 480231}
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.03885s ago] {'cell_id': None, 'sku_cell_id': 1271230}
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 259.7s ago] {'pk_1': 480231}
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.9287s ago] {'param_1': 480231}
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.9258s ago] {'param_1': 480231}
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.9247s ago] {'param_1': 480231}
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.9225s ago] {'param_1': 480231}
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.05123s ago] {'cell_id': None, 'sku_cell_id': 1271230}
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 259.7s ago] {'pk_1': 480231}
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.941s ago] {'param_1': 480231}
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.9376s ago] {'param_1': 480231}
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.9368s ago] {'param_1': 480231}
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.9349s ago] {'param_1': 480231}
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.06383s ago] {'cell_id': None, 'sku_cell_id': 1271230}
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 257.8s ago] {'pk_1': 98685}
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.9054s ago] {'param_1': 98685}
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.9026s ago] {'id': 98685}
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 259.9s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, '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 259.8s ago] {'pk_1': 480232}
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.005s ago] {'param_1': 480232}
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.002s ago] {'param_1': 480232}
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.001s ago] {'param_1': 480232}
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.9989s ago] {'param_1': 480232}
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.9974s ago] [{'cell_id': None, 'reservation_id': 38879840}, {'cell_id': None, 'reservation_id': 38879841}]
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 259.8s ago] {'pk_1': 480232}
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.018s ago] {'param_1': 480232}
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.014s ago] {'param_1': 480232}
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.014s ago] {'param_1': 480232}
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.011s ago] {'param_1': 480232}
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.01s ago] [{'cell_id': None, 'reservation_id': 38879840}, {'cell_id': None, 'reservation_id': 38879841}]
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 259.8s ago] {'pk_1': 480232}
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.03s ago] {'param_1': 480232}
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.026s ago] {'param_1': 480232}
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.025s ago] {'param_1': 480232}
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.023s ago] {'param_1': 480232}
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.021s ago] [{'cell_id': None, 'reservation_id': 38879840}, {'cell_id': None, 'reservation_id': 38879841}]
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 257.8s ago] {'pk_1': 98686}
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.9933s ago] {'param_1': 98686}
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.9907s ago] {'id': 98686}
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 257.9s ago] {'pk_1': 98687}
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.042s ago] {'param_1': 98687}
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.04s ago] {'id': 98687}
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 260.1s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100030}
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 260s ago] {'pk_1': 480233}
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.144s ago] {'param_1': 480233}
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.143s ago] {'param_1': 480233}
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.142s ago] {'param_1': 480233}
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.139s ago] {'param_1': 480233}
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.138s ago] [{'cell_id': None, 'reservation_id': 38879842}, {'cell_id': None, 'reservation_id': 38879843}]
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 260s ago] {'pk_1': 480233}
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.159s ago] {'param_1': 480233}
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.155s ago] {'param_1': 480233}
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.154s ago] {'param_1': 480233}
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.154s ago] {'param_1': 480233}
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.153s ago] [{'cell_id': None, 'reservation_id': 38879842}, {'cell_id': None, 'reservation_id': 38879843}]
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 260s ago] {'pk_1': 480233}
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.174s ago] {'param_1': 480233}
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.172s ago] {'param_1': 480233}
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.171s ago] {'param_1': 480233}
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.168s ago] {'param_1': 480233}
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.167s ago] [{'cell_id': None, 'reservation_id': 38879842}, {'cell_id': None, 'reservation_id': 38879843}]
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 258s ago] {'pk_1': 98688}
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.139s ago] {'param_1': 98688}
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.134s ago] {'id': 98688}
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 258s ago] {'pk_1': 98689}
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.189s ago] {'param_1': 98689}
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.183s ago] {'id': 98689}
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 260.2s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100269}
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 260.1s ago] {'pk_1': 480234}
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.287s ago] {'param_1': 480234}
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.285s ago] {'param_1': 480234}
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.284s ago] {'param_1': 480234}
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.282s ago] {'param_1': 480234}
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': 38879844}
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 260.1s ago] {'pk_1': 480234}
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.301s ago] {'param_1': 480234}
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.301s ago] {'param_1': 480234}
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.3s ago] {'param_1': 480234}
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.298s ago] {'param_1': 480234}
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.01567s ago] {'cell_id': None, 'reservation_id': 38879844}
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 260.1s ago] {'pk_1': 480234}
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': 480234}
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.315s ago] {'param_1': 480234}
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.314s ago] {'param_1': 480234}
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.312s ago] {'param_1': 480234}
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.02989s ago] {'cell_id': None, 'reservation_id': 38879844}
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 258.1s ago] {'pk_1': 98690}
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.283s ago] {'param_1': 98690}
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.284s ago] {'id': 98690}
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 260.3s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100280}
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 260.2s ago] {'pk_1': 480235}
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.387s ago] {'param_1': 480235}
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.385s ago] {'param_1': 480235}
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.384s ago] {'param_1': 480235}
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.382s ago] {'param_1': 480235}
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.5108s ago] {'cell_id': None, 'sku_cell_id': 1271234}
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 260.2s ago] {'pk_1': 480235}
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.401s ago] {'param_1': 480235}
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.397s ago] {'param_1': 480235}
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.397s ago] {'param_1': 480235}
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.395s ago] {'param_1': 480235}
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.5236s ago] {'cell_id': None, 'sku_cell_id': 1271234}
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 260.2s ago] {'pk_1': 480235}
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.413s ago] {'param_1': 480235}
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.409s ago] {'param_1': 480235}
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.408s ago] {'param_1': 480235}
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.406s ago] {'param_1': 480235}
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.5346s ago] {'cell_id': None, 'sku_cell_id': 1271234}
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 258.2s ago] {'pk_1': 98691}
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.376s ago] {'param_1': 98691}
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.374s ago] {'id': 98691}
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 260.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100021}
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 260.3s ago] {'pk_1': 480237}
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.477s ago] {'param_1': 480237}
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.474s ago] {'param_1': 480237}
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.473s ago] {'param_1': 480237}
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.471s ago] {'param_1': 480237}
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.6002s ago] {'cell_id': None, 'sku_cell_id': 1271236}
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 260.3s ago] {'pk_1': 480237}
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.49s ago] {'param_1': 480237}
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.487s ago] {'param_1': 480237}
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.486s ago] {'param_1': 480237}
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.484s ago] {'param_1': 480237}
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.6127s ago] {'cell_id': None, 'sku_cell_id': 1271236}
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 260.3s ago] {'pk_1': 480237}
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.502s ago] {'param_1': 480237}
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.499s ago] {'param_1': 480237}
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.498s ago] {'param_1': 480237}
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.495s ago] {'param_1': 480237}
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.6245s ago] {'cell_id': None, 'sku_cell_id': 1271236}
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 258.3s ago] {'pk_1': 98694}
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.466s ago] {'param_1': 98694}
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.461s ago] {'id': 98694}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode