Support » Plugin: Broadcast » Processing Queue…Trying again in XX seconds = FOREVER

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author edward_plainview

    (@edward_plainview)

    A loop in queue processing is usually due to a fatal error of some kind.

    Why is the queue not being processed properly?

    If you find a post is not disappearing from the queue after being processed, it’s probably due to an error during broadcasting.

    In order to find out what the problem is:

    – disable automatic processing of the queue in the settings
    – enable WP_DEBUG
    – enable Broadcast debug to browser mode
    – manually process the item in the queue

    You should see a long debug text. An error message should appear at the end, telling you what is wrong.

    We’re looking for an “exception” or “fatal error” at the end.

    Broadcast > Queue > Settings > Automatic AJAX processing > unchecked

    Added: define( ‘WP_DEBUG’, true ); to wp-config.php

    Enabled Broadcast debug to browser mode

    Returned this:
    Ajax error
    2019-04-01 11:55:55.5378 ThreeWP_Broadcast: Post_Queue: Starting prepare_meta_box.
    2019-04-01 11:55:55.0539 ThreeWP_Broadcast: Post_Queue: Build process data.
    2019-04-01 11:55:55.0543 ThreeWP_Broadcast: Post_Queue: Built process data.
    2019-04-01 11:55:55.5434 ThreeWP_Broadcast: Post_Queue: Finished prepare_meta_box.
    2019-04-01 11:55:55.055 ThreeWP_Broadcast: User_Blog_Settings: 0 modifications found.
    2019-04-01 11:55:55.5503 ThreeWP_Broadcast: User_Blog_Settings: Applying 0 modifications.
    2019-04-01 11:55:55.5506 ThreeWP_Broadcast: User_Blog_Settings: Finished applying modifications.
    2019-04-01 11:55:55.5771 ThreeWP_Broadcast: Queue: Data 2 inserted.
    2019-04-01 11:55:55.5776 ThreeWP_Broadcast: Queue: Inserting queue item. 370 bytes.
    2019-04-01 11:55:55.5795 ThreeWP_Broadcast: Queue: Item 6 inserted.
    2019-04-01 11:55:55.5801 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 11:55:55.5812 ThreeWP_Broadcast: Queue: Item 7 inserted.
    2019-04-01 11:55:55.5816 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 11:55:55.5826 ThreeWP_Broadcast: Queue: Item 8 inserted.
    2019-04-01 11:55:55.5829 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 11:55:55.5842 ThreeWP_Broadcast: Queue: Item 9 inserted.
    2019-04-01 11:55:55.5845 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 11:55:55.5852 ThreeWP_Broadcast: Queue: Item 10 inserted.
    2019-04-01 11:55:55.5855 ThreeWP_Broadcast: Post_Queue: Finished queueing. Stopping Broadcast.

    OK. I am not sure what to do from here…maybe you can lead me in the right direction…Thanks so much for time and expertise.

    matt

    ERROR LOG WHen trying to update the home page:

    [01-Apr-2019 12:21:48 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_criteria2’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_criteria2 made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\ThreeWP_Broadcast->admin_menu, plainview\sdk_broadcast\wordpress\actions\action->execute, do_action(‘threewp_broadcast_admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->threewp_broadcast_admin_menu, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->cached_user_modifications, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_all_criteria, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:21:49 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_modifications’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_modifications made by include(‘wp-admin/admin-footer.php’), do_action(‘admin_print_footer_scripts’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings_post\User_Blog_Settings_Post->admin_print_footer_scripts, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_modifications, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:21:56 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_criteria2’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_criteria2 made by do_action(‘wp_ajax_broadcast_post_bulk_action’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\ThreeWP_Broadcast->wp_ajax_broadcast_post_bulk_action, plainview\sdk_broadcast\wordpress\actions\action->execute, do_action(‘threewp_broadcast_post_action’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\rebroadcast\Rebroadcast->threewp_broadcast_post_action, threewp_broadcast\broadcasting_data::make, threewp_broadcast\broadcasting_data->__construct, plainview\sdk_broadcast\wordpress\actions\action->execute, do_action(‘threewp_broadcast_prepare_meta_box’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->threewp_broadcast_prepare_meta_box, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->cached_user_modifications, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_all_criteria, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:24:20 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_criteria2’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_criteria2 made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\ThreeWP_Broadcast->admin_menu, plainview\sdk_broadcast\wordpress\actions\action->execute, do_action(‘threewp_broadcast_admin_menu’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->threewp_broadcast_admin_menu, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->cached_user_modifications, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_all_criteria, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:24:21 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_modifications’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_modifications made by require_once(‘wp-admin/admin.php’), do_action(‘admin_action_elementor’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Editor->init, Elementor\Editor->print_editor_template, include(‘/plugins/elementor/includes/editor-templates/editor-wrapper.php’), do_action(‘admin_print_footer_scripts’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings_post\User_Blog_Settings_Post->admin_print_footer_scripts, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_modifications, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:24:51 UTC] WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_criteria2’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_criteria2 made by do_action(‘wp_ajax_elementor_ajax’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Core\Common\Modules\Ajax\Module->handle_ajax_request, call_user_func, Elementor\TemplateLibrary\Manager->Elementor\TemplateLibrary\{closure}, Elementor\TemplateLibrary\Manager->handle_ajax_request, call_user_func, Elementor\TemplateLibrary\Manager->update_templates, Elementor\TemplateLibrary\Manager->update_template, Elementor\TemplateLibrary\Source_Local->update_item, Elementor\DB->save_editor, Elementor\Core\Base\Document->save, Elementor\Core\Base\Document->save_elements, do_action(‘elementor/editor/after_save’), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, threewp_broadcast\api->update_children, threewp_broadcast\broadcasting_data::make, threewp_broadcast\broadcasting_data->__construct, plainview\sdk_broadcast\wordpress\actions\action->execute, do_action(‘threewp_broadcast_prepare_meta_box’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->threewp_broadcast_prepare_meta_box, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->cached_user_modifications, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_all_criteria, plainview\sdk_broadcast\wordpress\base->query
    [01-Apr-2019 12:24:51 UTC] PHP Warning: file_get_contents(/var/www/vhosts/mylivekaya.com/httpdocs/wp-content/uploads/elementor/css/post-861.css): failed to open stream: No such file or directory in /var/www/vhosts/mylivekaya.com/httpdocs/wp-content/plugins/threewp-broadcast-premium-pack/src/elementor/Elementor.php on line 150
    [01-Apr-2019 12:24:52 UTC] PHP Warning: file_get_contents(/var/www/vhosts/mylivekaya.com/httpdocs/wp-content/uploads/elementor/css/post-864.css): failed to open stream: No such file or directory in /var/www/vhosts/mylivekaya.com/httpdocs/wp-content/plugins/threewp-broadcast-premium-pack/src/elementor/Elementor.php on line 150
    [01-Apr-2019 12:24:53 UTC] PHP Warning: file_get_contents(/var/www/vhosts/mylivekaya.com/httpdocs/wp-content/uploads/elementor/css/post-867.css): failed to open stream: No such file or directory in /var/www/vhosts/mylivekaya.com/httpdocs/wp-content/plugins/threewp-broadcast-premium-pack/src/elementor/Elementor.php on line 150
    [01-Apr-2019 12:24:53 UTC] PHP Warning: file_get_contents(/var/www/vhosts/mylivekaya.com/httpdocs/wp-content/uploads/elementor/css/post-882.css): failed to open stream: No such file or directory in /var/www/vhosts/mylivekaya.com/httpdocs/wp-content/plugins/threewp-broadcast-premium-pack/src/elementor/Elementor.php on line 150
    [01-Apr-2019 12:24:54 UTC] PHP Warning: file_get_contents(/var/www/vhosts/mylivekaya.com/httpdocs/wp-content/uploads/elementor/css/post-962.css): failed to open stream: No such file or directory in /var/www/vhosts/mylivekaya.com/httpdocs/wp-content/plugins/threewp-broadcast-premium-pack/src/elementor/Elementor.php on line 150

    Ok…missing DB tables…we are in testing phase and I deleted a ton of orphan tables from testing replication instances. Must of gotten over zealous…plug was not installed for the last round of backups ;(

    Best practices for recreating the tables…then I can move on to the other errors…

    Plugin Author edward_plainview

    (@edward_plainview)

    Missing DB tables: disable the UBS Broadcast add-on and then reactivate. The tables should be recreated.

    If not, then use the uninstall bulk command (instead of deactivate) and then reactivate.

    That should get the tables up and running again, although I’m not 100% sure that’s the cause of the fatal error, but we’ll see.

    Also, disable the queue completely to get the fatal error displayed directly.

    Network Admin > Braodcast > Add-Ons > selected: User Blog Settings – dropdown – deactivate

    Then selected UBS > dropdown > activate

    Manually Rebroadcasted from primary site: Just returns:

    Ajax error
    2019-04-01 15:38:33.6671 ThreeWP_Broadcast: Post_Queue: Starting prepare_meta_box.
    2019-04-01 15:38:33.6679 ThreeWP_Broadcast: Post_Queue: Build process data.
    2019-04-01 15:38:33.6727 ThreeWP_Broadcast: Post_Queue: Built process data.
    2019-04-01 15:38:33.6731 ThreeWP_Broadcast: Post_Queue: Finished prepare_meta_box.
    2019-04-01 15:38:33.6799 ThreeWP_Broadcast: User_Blog_Settings: 0 modifications found.
    2019-04-01 15:38:33.6802 ThreeWP_Broadcast: User_Blog_Settings: Applying 0 modifications.
    2019-04-01 15:38:33.6805 ThreeWP_Broadcast: User_Blog_Settings: Finished applying modifications.
    2019-04-01 15:38:33.6851 ThreeWP_Broadcast: Post_Queue: Delete existing queued item 21
    2019-04-01 15:38:33.6859 ThreeWP_Broadcast: Post_Queue: Delete existing queued item 22
    2019-04-01 15:38:33.6866 ThreeWP_Broadcast: Post_Queue: Delete existing queued item 23
    2019-04-01 15:38:33.6873 ThreeWP_Broadcast: Post_Queue: Delete existing queued item 24
    2019-04-01 15:38:33.6879 ThreeWP_Broadcast: Post_Queue: Delete existing queued item 25
    2019-04-01 15:38:33.7116 ThreeWP_Broadcast: Queue: Data 6 inserted.
    2019-04-01 15:38:33.7122 ThreeWP_Broadcast: Queue: Inserting queue item. 370 bytes.
    2019-04-01 15:38:33.7145 ThreeWP_Broadcast: Queue: Item 26 inserted.
    2019-04-01 15:38:33.7148 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 15:38:33.7159 ThreeWP_Broadcast: Queue: Item 27 inserted.
    2019-04-01 15:38:33.7161 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 15:38:33.7171 ThreeWP_Broadcast: Queue: Item 28 inserted.
    2019-04-01 15:38:33.7174 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 15:38:33.7184 ThreeWP_Broadcast: Queue: Item 29 inserted.
    2019-04-01 15:38:33.7187 ThreeWP_Broadcast: Queue: Inserting queue item. 371 bytes.
    2019-04-01 15:38:33.7198 ThreeWP_Broadcast: Queue: Item 30 inserted.
    2019-04-01 15:38:33.7201 ThreeWP_Broadcast: Post_Queue: Finished queueing. Stopping Broadcast.

    Disable Queue…disable the same as deactivate ?

    The above the Queue was still ACTIVATED.

    • This reply was modified 5 months, 3 weeks ago by  mabron.

    I failed to mention that I did check myphp for the following relevant tables

    wp_3wp_broadcast_queue_data
    wp_3wp_broadcast_queue_items
    wp_3wp_broadcast_ubs_criteria2
    wp__3wp_broadcast_broadcastdata

    THIS TABLE WAS NOT THERE:
    wp_3wp_broadcast_ubs_modifications

    Network Admin > Braodcast > Add-Ons > Queue >– dropdown – deactivate

    Main Site Admin > Pages > Selected Home > Dropdown > Rebroadcast

    2019-04-01 16:14:51.0587 ThreeWP_Broadcast: User_Blog_Settings: 0 modifications found.
    2019-04-01 16:14:51.5875 ThreeWP_Broadcast: User_Blog_Settings: Applying 0 modifications.
    2019-04-01 16:14:51.5877 ThreeWP_Broadcast: User_Blog_Settings: Finished applying modifications.
    2019-04-01 16:14:51.6071 ThreeWP_Broadcast: System info:

    +++ Large Debuggin Window

    Link to Latest Error Log
    http://livekaya.com/pdfs/debug-copy.log

    ERROR LOG SUMMARY:

    Mainsite Admin > Pages > Select Home Page > Dropdown > Rebroadcast

    WordPress database error Table ‘wordpress_m.wp_3wp_broadcast_ubs_modifications’ doesn’t exist for query SELECT * FROM wp_3wp_broadcast_ubs_modifications made by include(‘wp-admin/admin-footer.php’), do_action(‘admin_print_footer_scripts’), WP_Hook->do_action, WP_Hook->apply_filters, threewp_broadcast\premium_pack\user_blog_settings_post\User_Blog_Settings_Post->admin_print_footer_scripts, threewp_broadcast\premium_pack\user_blog_settings\User_Blog_Settings->get_modifications, plainview\sdk_broadcast\wordpress\base->query

    First seen: 2019-04-01 06:21:49 -06:00
    Last seen: 2019-04-01 11:13:00 -06:00
    Total events: 71

    Plugin Author edward_plainview

    (@edward_plainview)

    Maybe it would be most efficient if I could take a look for myself? Please contact me via e-mail and we can continue debugging there. edward@plainviewplugins.com

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