INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 INSERT INTO cell (key, zone_id, cell_picking_type, barcode, old_barcode, height, length, width, placing_order, picking_order, inventory_task_id, last_inventory_date, last_inventory_worker_id, deactivate_reason) VALUES (%(key)s, %(zone_id)s, %(cell_picking_type)s, %(barcode)s, %(old_barcode)s, %(height)s, %(length)s, %(width)s, %(placing_order)s, %(picking_order)s, %(inventory_task_id)s, %(last_inventory_date)s, %(last_inventory_worker_id)s, %(deactivate_reason)s) RETURNING cell.id, cell.active, cell.mix_type, cell.skus_amount INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 35.51s ago] {'key': 'QA-75205340821102592', 'zone_id': , 'cell_picking_type': , 'barcode': None, 'old_barcode': '2026-04-03T08:35:40.821116', 'height': None, 'length': None, 'width': None, 'placing_order': None, 'picking_order': None, 'inventory_task_id': None, 'last_inventory_date': None, 'last_inventory_worker_id': None, 'deactivate_reason': None} 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 account.wms_id, account.is_active, account.first_name, account.last_name, account.password, account.phone, account.is_pass_change_needed, account.code, account.date_created, account.linked_delivery_point_id, account.patronymic, account.zone_id, account.role_wms_id, account.warehouse_id, account.barcode, account.cell_key, account.jobtitle, account.pinfl FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s AND account.warehouse_id = %(warehouse_id_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 36.82s ago] {'first_name_1': 'Phantom', 'last_name_1': 'Lancer', 'barcode_1': , 'warehouse_id_1': 1693627, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.first_name AS account_first_name, account.last_name AS account_last_name, account.password AS account_password, account.phone AS account_phone, account.is_pass_change_needed AS account_is_pass_change_needed, account.code AS account_code, account.date_created AS account_date_created, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.warehouse_id AS account_warehouse_id, account.barcode AS account_barcode, account.cell_key AS account_cell_key, account.jobtitle AS account_jobtitle, account.pinfl AS account_pinfl FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 36.82s ago] {'pk_1': 100344} 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 36.82s ago] {'barcode': , 'wms_id_1': 100344} INFO root:api_client.py:709 __make_url schema='https', self.__service_name='dm-wms-be-service-account', mesh='', self.__cluster_domain='k8s-review.dailymail-tech.uz' 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 35.57s ago] {'pk_1': 488030} 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 account.wms_id, account.is_active, account.is_pass_change_needed, account.first_name, account.last_name, account.password, account.phone, account.barcode, account.cell_key, account.code, account.date_created, account.jobtitle, account.linked_delivery_point_id, account.patronymic, account.pinfl, account.warehouse_id, account.zone_id, account.role_wms_id, account.language_code, account.profile_pic, account.cabinet_type, account.company_id FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 35.55s ago] {'first_name_1': , 'last_name_1': , 'barcode_1': , 'param_1': 1} 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 35.55s ago] {'barcode': , 'wms_id_1': 10280} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.is_pass_change_needed AS account_is_pass_change_needed, account.first_name AS account_first_name, account.last_name AS account_last_name, account.password AS account_password, account.phone AS account_phone, account.barcode AS account_barcode, account.cell_key AS account_cell_key, account.code AS account_code, account.date_created AS account_date_created, account.jobtitle AS account_jobtitle, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.pinfl AS account_pinfl, account.warehouse_id AS account_warehouse_id, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.language_code AS account_language_code, account.profile_pic AS account_profile_pic, account.cabinet_type AS account_cabinet_type, account.company_id AS account_company_id FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 35.55s ago] {'pk_1': 10280} INFO root:api_client.py:709 __make_url schema='https', self.__service_name='dm-ff-be-service-supply', mesh='', self.__cluster_domain='k8s-review.dailymail-tech.uz' WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/batch/template WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/batch/template INFO root:api_client.py:709 __make_url schema='https', self.__service_name='dm-ff-be-service-supply', mesh='', self.__cluster_domain='k8s-review.dailymail-tech.uz' WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/batch WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/batch INFO root:api_client.py:709 __make_url schema='https', self.__service_name='dm-ff-be-service-supply', mesh='', self.__cluster_domain='k8s-review.dailymail-tech.uz' WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/67163436198 WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/67163436198 WARNING urllib3.connectionpool:connectionpool.py:868 Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NameResolutionError("HTTPSConnection(host='dm-ff-be-service-supply.k8s-review.dailymail-tech.uz', port=443): Failed to resolve 'dm-ff-be-service-supply.k8s-review.dailymail-tech.uz' ([Errno -2] Name or service not known)")': /api/v1/sku/67163436198 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:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully 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 account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 37.11s ago] {'barcode': , 'wms_id_1': 100313} 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 37.15s ago] {'pk_1': 103044} 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.00013s] {'param_1': 103044} 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.00016s] {'id': 103044} 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 37.18s ago] {'barcode': , 'wms_id_1': 100313} 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 37.18s ago] {'barcode': , 'wms_id_1': 100313} 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 37.18s ago] {'barcode': , 'wms_id_1': 100370} 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 37.21s ago] {'pk_1': 103045} 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.0615s ago] {'param_1': 103045} 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.05956s ago] {'id': 103045} 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 37.23s ago] {'barcode': , 'wms_id_1': 100370} 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 37.23s ago] {'barcode': , 'wms_id_1': 100356} 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 37.26s ago] {'pk_1': 103046} 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.1168s ago] {'param_1': 103046} 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.1133s ago] {'id': 103046} 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 37.28s ago] {'barcode': , 'wms_id_1': 100356} 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 37.29s ago] {'barcode': , 'wms_id_1': 100064} 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 36.01s ago] {'pk_1': 487984} 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.00020s] {'param_1': 487984} 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.00020s] {'param_1': 487984} 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.00016s] {'param_1': 487984} 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.00014s] {'param_1': 487984} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'id': 487984} 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 37.32s ago] {'barcode': , 'wms_id_1': 100367} 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 36.03s ago] {'pk_1': 487995} 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.02567s ago] {'param_1': 487995} 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.01961s ago] {'param_1': 487995} 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.018s ago] {'param_1': 487995} 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.01675s ago] {'param_1': 487995} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01622s ago] {'id': 487995} 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 37.34s ago] {'barcode': , 'wms_id_1': 100088} 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 36.05s ago] {'pk_1': 488000} 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.04014s ago] {'param_1': 488000} 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.03392s ago] {'param_1': 488000} 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.03243s ago] {'param_1': 488000} 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.03121s ago] {'param_1': 488000} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03055s ago] {'id': 488000} 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 37.35s ago] {'barcode': , 'wms_id_1': 100017} 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 36.06s ago] {'pk_1': 488002} 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.05342s ago] {'param_1': 488002} 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.04739s ago] {'param_1': 488002} 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.04571s ago] {'param_1': 488002} 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.045s ago] {'param_1': 488002} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04447s ago] {'id': 488002} 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 37.37s ago] {'barcode': , 'wms_id_1': 100386} 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 36.08s ago] {'pk_1': 488009} 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.06821s ago] {'param_1': 488009} 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.06217s ago] {'param_1': 488009} 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.06048s ago] {'param_1': 488009} 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.05916s ago] {'param_1': 488009} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05848s ago] {'id': 488009} 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 37.39s ago] {'barcode': , 'wms_id_1': 100210} 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 36.1s ago] {'pk_1': 488014} 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.09551s ago] {'param_1': 488014} 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.08942s ago] {'param_1': 488014} 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.0879s ago] {'param_1': 488014} 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.08666s ago] {'param_1': 488014} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08597s ago] {'id': 488014} 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 37.41s ago] {'barcode': , 'wms_id_1': 100395} 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 36.12s ago] {'pk_1': 488017} 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.1091s ago] {'param_1': 488017} 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.1026s ago] {'param_1': 488017} 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.1009s ago] {'param_1': 488017} 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.09955s ago] {'param_1': 488017} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.09879s ago] {'id': 488017} 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 37.42s ago] {'barcode': , '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 36.13s ago] {'pk_1': 488018} 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.1213s ago] {'param_1': 488018} 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.1149s ago] {'param_1': 488018} 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.1132s ago] {'param_1': 488018} 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.1118s ago] {'param_1': 488018} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1111s ago] {'id': 488018} 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 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 36.14s ago] {'pk_1': 488019} 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.1325s ago] {'param_1': 488019} 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.126s ago] {'param_1': 488019} 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.1244s ago] {'param_1': 488019} 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.1232s ago] {'param_1': 488019} 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': 38884243} 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 36.15s ago] {'pk_1': 488019} 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.1454s ago] {'param_1': 488019} 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.139s ago] {'param_1': 488019} 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.1374s ago] {'param_1': 488019} 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.1361s ago] {'param_1': 488019} 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.01218s ago] {'cell_id': None, 'reservation_id': 38884243} 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 36.16s ago] {'pk_1': 488019} 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.156s ago] {'param_1': 488019} 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.1497s ago] {'param_1': 488019} 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.1481s ago] {'param_1': 488019} 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.1469s ago] {'param_1': 488019} 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.02313s ago] {'cell_id': None, 'reservation_id': 38884243} 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 37.47s ago] {'barcode': , 'wms_id_1': 100212} 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.00011s] {'worker_id': 0, 'id_1': 1499478} 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': , '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': , 'current_assembly_id': None, 'barcode_1': '12.18.1.47'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 37.56s ago] {'barcode': , 'wms_id_1': 100212} 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 37.59s ago] {'pk_1': 103047} 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.441s ago] {'param_1': 103047} 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.4394s ago] {'id': 103047} 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 37.61s ago] {'barcode': , 'wms_id_1': 100212} 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 37.61s ago] {'barcode': , 'wms_id_1': 100212} 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.1441s ago] {'status': , 'worker_id_1': 33349} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08988s ago] {'status': , 'current_assembly_id': None, 'barcode_1': '12.18.1.47'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 37.65s ago] {'barcode': , 'wms_id_1': 100212} 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 36.36s ago] {'pk_1': 488030} 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.3501s ago] {'param_1': 488030} 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.3453s ago] {'param_1': 488030} 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.3436s ago] {'param_1': 488030} 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.3424s ago] {'param_1': 488030} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3417s ago] {'id': 488030} 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 37.66s ago] {'barcode': , 'wms_id_1': 100344}