Hi @tomasw
Just as an FYI we received another bad snapshot last night. The frequency of these bad ones is down considerably and they aren’t causing any meaningful business problems, so from our end its low priority but figured you’d still want to know.
FWIW, it seems the recent ones are all related to MySQL dropped connections.
{'snapshot_id': '60432168bc328f87217efa34', 'job_user_id': 'VXNlcjo0MzQ3', 'job_account_id': 'QWNjb3VudDoyMTM2', 'warehouse_id': 'V2FyZWhvdXNlOjMzMDU=', 'post_url': 'https://admin.ficksmusic.com/XXXXXXXXXXXXXX//', 'status': 'error', 'error': "(_mysql_exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query')\n[SQL: SELECT purchase_order_line_items.id AS purchase_order_line_items_id, purchase_order_line_items.account_id AS purchase_order_line_items_account_id, purchase_order_line_items.po_number AS purchase_order_line_items_po_number, purchase_order_line_items.sku AS purchase_order_line_items_sku, purchase_order_line_items.vendor_sku AS purchase_order_line_items_vendor_sku, purchase_order_line_items.product_id AS purchase_order_line_items_product_id, purchase_order_line_items.variant_id AS purchase_order_line_items_variant_id, purchase_order_line_items.quantity AS purchase_order_line_items_quantity, purchase_order_line_items.quantity_received AS purchase_order_line_items_quantity_received, purchase_order_line_items.quantity_rejected AS purchase_order_line_items_quantity_rejected, purchase_order_line_items.price AS purchase_order_line_items_price, purchase_order_line_items.product_name AS purchase_order_line_items_product_name, purchase_order_line_items.option_title AS purchase_order_line_items_option_title, purchase_order_line_items.expected_weight_in_lbs AS purchase_order_line_items_expected_weight_in_lbs, purchase_order_line_items.fulfillment_status AS purchase_order_line_items_fulfillment_status, purchase_order_line_items.po_id AS purchase_order_line_items_po_id, purchase_order_line_items.updated_at AS purchase_order_line_items_updated_at, purchase_order_line_items.created_at AS purchase_order_line_items_created_at, purchase_order_line_items.partner_line_item_id AS purchase_order_line_items_partner_line_item_id, purchase_order_line_items.sell_ahead AS purchase_order_line_items_sell_ahead, purchase_order_line_items.note AS purchase_order_line_items_note, purchase_order_line_items.warehouse_id AS purchase_order_line_items_warehouse_id, purchase_order_line_items.vendor_id AS purchase_order_line_items_vendor_id, product_info_1.sku AS product_info_1_sku, product_info_1.account_id AS product_info_1_account_id, product_info_1.kit AS product_info_1_kit, product_info_1.parent_id AS product_info_1_parent_id, product_info_1.barcode AS product_info_1_barcode, product_info_1.updated_at AS product_info_1_updated_at, product_info_1.created_at AS product_info_1_created_at, product_info_1.id AS product_info_1_id, product_info_1.name AS product_info_1_name, product_info_1.`option` AS product_info_1_option, product_info_1.active AS product_info_1_active, product_info_1.thumbnail AS product_info_1_thumbnail, product_info_1.value AS product_info_1_value, product_info_1.product_note AS product_info_1_product_note, product_info_1.country_of_manufacture AS product_info_1_country_of_manufacture, product_info_1.weight_in_oz AS product_info_1_weight_in_oz, product_info_1.height AS product_info_1_height, product_info_1.length AS product_info_1_length, product_info_1.width AS product_info_1_width, product_info_1.barcode_pdf AS product_info_1_barcode_pdf, product_info_1.barcode_image AS product_info_1_barcode_image, product_info_1.barcode_zpl AS product_info_1_barcode_zpl, product_info_1.tariff_code AS product_info_1_tariff_code, product_info_1.thumbnail_updated_time AS product_info_1_thumbnail_updated_time, product_info_1.large_thumbnail AS product_info_1_large_thumbnail, product_info_1.`virtual` AS product_info_1_virtual, product_info_1.reorder_amount AS product_info_1_reorder_amount, product_info_1.reorder_level AS product_info_1_reorder_level, product_info_1.value_currency AS product_info_1_value_currency, product_info_1.price AS product_info_1_price, product_info_1.kit_build AS product_info_1_kit_build, product_info_1.no_air AS product_info_1_no_air, product_info_1.final_sale AS product_info_1_final_sale, product_info_1.customs_value AS product_info_1_customs_value, product_info_1.customs_description AS product_info_1_customs_description, product_info_1.not_owned AS product_info_1_not_owned, product_info_1.ignore_on_invoice AS product_info_1_ignore_on_invoice, product_info_1.ignore_on_customs AS product_info_1_ignore_on_customs, product_info_1.thumbnail_from_url AS product_info_1_thumbnail_from_url, product_info_1.dropship AS product_info_1_dropship, product_info_1.li_ion AS product_info_1_li_ion, product_info_1.dangerous_goods_code AS product_info_1_dangerous_goods_code, product_info_1.needs_serial_number AS product_info_1_needs_serial_number, product_info_1.needs_lot_tracking AS product_info_1_needs_lot_tracking, product_info_1.auto_fulfill AS product_info_1_auto_fulfill \nFROM purchase_order_line_items INNER JOIN purchase_orders ON purchase_orders.id = purchase_order_line_items.po_id LEFT OUTER JOIN product_info AS product_info_1 ON product_info_1.sku = purchase_order_line_items.sku AND product_info_1.account_id = purchase_order_line_items.account_id \nWHERE purchase_order_line_items.sku = %s AND purchase_order_line_items.account_id = %s AND purchase_order_line_items.fulfillment_status = %s AND purchase_orders.fulfillment_status IN (%s, %s, %s) AND purchase_order_line_items.warehouse_id = %s]\n[parameters: ('M901200159', 2136, 'pending', 'pending', 'receiving', 'arrived', 3305)]\n(Background on this error at: http://sqlalche.me/e/13/e3q8)", 'created_at': '2021-03-06T06-30-00+00:00', 'enqueued_at': '2021-03-06T06-30-00+00:00', 'updated_at': '2021-03-06T06-43-33+00:00', 'post_url_pre_check': False, 'customer_account_id': None, 'notification_email': None, 'email_error': None, 'post_error': None, 'snapshot_url': None, 'snapshot_expiration': None}