Database error about table that doesn’t exist

  • Resolved Rafael Fischmann

    (@rfischmann)


    1 month, 3 weeks ago

    Hi,

    I’ve updated Jetpack to 13.9 yesterday and am now seeing errors like these in my error_log:

    [03-Oct-2024 19:54:45 UTC] WordPress database error Table 'wordpress.wp_jetpack_sync_queue' doesn't exist for query INSERT INTO wp_jetpack_sync_queue (queue_id, event_id, event_payload) VALUES ('sync', 'jpsq_sync-1727985285.879033-866352-19','a:6:{i:0;s:21:\"jetpack_sync_callable\";i:1;a:2:{i:0;s:8:\"site_url\";i:1;s:25:\"https://macmagazine.com.br\";}i:2;i:0;i:3;d:1727985285.878902912139892578125;i:4;b:0;i:5;a:14:{s:13:\"wpcom_user_id\";N;s:16:\"external_user_id\";i:0;s:12:\"display_name\";N;s:10:\"user_email\";N;s:10:\"user_roles\";a:0:{}s:15:\"translated_role\";N;s:7:\"is_cron\";b:1;s:7:\"is_rest\";b:0;s:9:\"is_xmlrpc\";b:0;s:10:\"is_wp_rest\";b:0;s:7:\"is_ajax\";b:0;s:11:\"is_wp_admin\";b:0;s:6:\"is_cli\";b:0;s:8:\"from_url\";s:26:\"https://macmagazine.com.br\";}}') made by do_action_ref_array('jetpack_sync_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Actions::do_cron_sync, Automattic\Jetpack\Sync\Actions::do_cron_sync_by_type, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, do_action('jetpack_sync_callable'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Queue->add, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->insert_item
    [03-Oct-2024 19:54:45 UTC] WordPress database error Table 'wordpress.wp_jetpack_sync_queue' doesn't exist for query INSERT INTO wp_jetpack_sync_queue (queue_id, event_id, event_payload) VALUES ('sync', 'jpsq_sync-1727985285.879427-866352-20','a:6:{i:0;s:21:\"jetpack_sync_callable\";i:1;a:2:{i:0;s:14:\"paused_plugins\";i:1;a:0:{}}i:2;i:0;i:3;d:1727985285.879290103912353515625;i:4;b:0;i:5;a:14:{s:13:\"wpcom_user_id\";N;s:16:\"external_user_id\";i:0;s:12:\"display_name\";N;s:10:\"user_email\";N;s:10:\"user_roles\";a:0:{}s:15:\"translated_role\";N;s:7:\"is_cron\";b:1;s:7:\"is_rest\";b:0;s:9:\"is_xmlrpc\";b:0;s:10:\"is_wp_rest\";b:0;s:7:\"is_ajax\";b:0;s:11:\"is_wp_admin\";b:0;s:6:\"is_cli\";b:0;s:8:\"from_url\";s:26:\"https://macmagazine.com.br\";}}') made by do_action_ref_array('jetpack_sync_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Actions::do_cron_sync, Automattic\Jetpack\Sync\Actions::do_cron_sync_by_type, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, do_action('jetpack_sync_callable'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Queue->add, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->insert_item
    [03-Oct-2024 19:54:45 UTC] WordPress database error Table 'wordpress.wp_jetpack_sync_queue' doesn't exist for query INSERT INTO wp_jetpack_sync_queue (queue_id, event_id, event_payload) VALUES ('sync', 'jpsq_sync-1727985285.879813-866352-21','a:6:{i:0;s:21:\"jetpack_sync_callable\";i:1;a:2:{i:0;s:13:\"paused_themes\";i:1;a:0:{}}i:2;i:0;i:3;d:1727985285.879683971405029296875;i:4;b:0;i:5;a:14:{s:13:\"wpcom_user_id\";N;s:16:\"external_user_id\";i:0;s:12:\"display_name\";N;s:10:\"user_email\";N;s:10:\"user_roles\";a:0:{}s:15:\"translated_role\";N;s:7:\"is_cron\";b:1;s:7:\"is_rest\";b:0;s:9:\"is_xmlrpc\";b:0;s:10:\"is_wp_rest\";b:0;s:7:\"is_ajax\";b:0;s:11:\"is_wp_admin\";b:0;s:6:\"is_cli\";b:0;s:8:\"from_url\";s:26:\"https://macmagazine.com.br\";}}') made by do_action_ref_array('jetpack_sync_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Actions::do_cron_sync, Automattic\Jetpack\Sync\Actions::do_cron_sync_by_type, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, do_action('jetpack_sync_callable'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Queue->add, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->insert_item
    [03-Oct-2024 19:54:45 UTC] WordPress database error Table 'wordpress.wp_jetpack_sync_queue' doesn't exist for query SELECT COUNT(*) FROM wp_jetpack_sync_queue WHERE queue_id = 'sync' made by do_action_ref_array('jetpack_sync_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Actions::do_cron_sync, Automattic\Jetpack\Sync\Actions::do_cron_sync_by_type, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count
    [03-Oct-2024 19:54:45 UTC] WordPress database error Table 'wordpress.wp_jetpack_sync_queue' doesn't exist for query INSERT INTO wp_jetpack_sync_queue (queue_id, event_id, event_payload) VALUES ('sync', 'jpsq_sync-1727985285.886437-866352-22','a:6:{i:0;s:12:\"added_option\";i:1;a:2:{i:0;s:48:\"jetpack_sync_settings_custom_queue_table_enabled\";i:1;i:0;}i:2;i:0;i:3;d:1727985285.8862340450286865234375;i:4;b:0;i:5;a:14:{s:13:\"wpcom_user_id\";N;s:16:\"external_user_id\";i:0;s:12:\"display_name\";N;s:10:\"user_email\";N;s:10:\"user_roles\";a:0:{}s:15:\"translated_role\";N;s:7:\"is_cron\";b:1;s:7:\"is_rest\";b:0;s:9:\"is_xmlrpc\";b:0;s:10:\"is_wp_rest\";b:0;s:7:\"is_ajax\";b:0;s:11:\"is_wp_admin\";b:0;s:6:\"is_cli\";b:0;s:8:\"from_url\";s:26:\"https://macmagazine.com.br\";}}') made by do_action_ref_array('jetpack_sync_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Actions::do_cron_sync, Automattic\Jetpack\Sync\Actions::do_cron_sync_by_type, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count, Automattic\Jetpack\Sync\Settings::update_settings, update_option, add_option, do_action('added_option'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Queue->add, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->insert_item

    Any help, please? Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Jeremy Herve

    (@jeherve)

    Jetpack Mechanic ??

    I’m sorry to hear you’ve run into issues.

    Could you check your site’s database, and confirm that the table does exist, with this wordpress.wp prefix? If you’re not sure how to access and view your site’s database, I would recommend getting in touch with your hosting provider, they should be able to guide you through that.

    Let us know what you find.

    Thread Starter Rafael Fischmann

    (@rfischmann)

    The table wp_jetpack_sync_queue does exist, I believe “wordpress.” refers to the database’s name.

    It seems those errors only happened on October 3rd, don’t know why. But I haven’t seen them anymore in my logs.

    Plugin Author Jeremy Herve

    (@jeherve)

    Jetpack Mechanic ??

    Thanks for the extra details. Is it possible that there was a partial outage on your site around that time? Do you see any other errors on that day?

    If the errors haven’t happened again in the past week, things may be back to normal now. It may be okay to monitor your logs to see if that happens again. If it does, it would be good to know if it happens when you take a specific action on your site (updating WordPress, or a theme, or plugins).

    Thread Starter Rafael Fischmann

    (@rfischmann)

    Thanks, @jeherve. That was the only error that day and we have no logs of an outage. But maybe it did happen very quickly, I don’t know.

    I’ll keep my eyes open!

    Plugin Support Alin (a11n)

    (@alinclamba)

    Hi @rfischmann,

    In that case, it seems like the issue might have been a temporary glitch. Since the errors have not reappeared, monitoring your logs for any future occurrences is a good approach. If the issue resurfaces, try to identify any specific actions that might trigger it, such as updates to WordPress, themes, or plugins.

    Best!

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.