Receiving error webhooks

Hi,

We are receiving a few bad inventory snapshot webhooks. It’s certainly not every one but has been a few per day. Here are some examples:

{'snapshot_id': '5fb45cf8e7b6bf77d3ffefec', 'job_user_id': 'VXNlcjo0MzQ3', 'job_account_id': 'QWNjb3VudDoyMTM2', 'warehouse_id': 'V2FyZWhvdXNlOjMzMDU=', 'post_url': 'https://XXXXX.ficksmusic.com/XXXXXXXXXXXXXXX/', 'status': 'error', 'error': "Process restarted\nProcess restarted\n(_mysql_exceptions.InterfaceError) (0, '')\n[SQL: SELECT products_vendors.id AS products_vendors_id, products_vendors.sku AS products_vendors_sku, products_vendors.vendor_id AS products_vendors_vendor_id, products_vendors.account_id AS products_vendors_account_id, products_vendors.manufacturer_sku AS products_vendors_manufacturer_sku, products_vendors.price AS products_vendors_price \nFROM products_vendors \nWHERE products_vendors.sku = %s AND products_vendors.account_id = %s]\n[parameters: ('UE3641B', 2136)]\n(Background on this error at: http://sqlalche.me/e/rvf5)", 'created_at': '2020-11-17T23-30-00+00:00', 'enqueued_at': '2020-11-17T23-30-00+00:00', 'updated_at': '2020-11-17T23-43-36+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}

and

{'snapshot_id': '5fb47918d7ea2f9ca6910843', 'job_user_id': 'VXNlcjo0MzQ3', 'job_account_id': 'QWNjb3VudDoyMTM2', 'warehouse_id': 'V2FyZWhvdXNlOjMzMDU=', 'post_url': 'https://admin.ficksmusic.com/integration/reports/shiphero/inventory-snapshot-done/', 'status': 'error', 'error': "Process restarted\nProcess restarted\nInstance '<Product at 0x7f0c2775b470>' is not persistent within this Session", 'created_at': '2020-11-18T01-30-00+00:00', 'enqueued_at': '2020-11-18T01-30-00+00:00', 'updated_at': '2020-11-18T01-36-24+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}

It’s not the end of the world; we use them to reconcile any other missed webhooks transactions, but figured you might want to address it internally.

Hi @david!
We apologize we missed this post! Thanks for that information.
We have just sent a fix for these errors to the Inventory Snapshot feature. Please let us know if you continue to see this kind of errors.
Thanks for reporting this!
Tom

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}

Hi @david!
Thanks for reporting this!
We have an open ticket with engineering regarding this error. We will keep you updated on the progress!
Thanks again!
Tom