Woocommerce database error

  • Im getting mail notice:

    Error details
    =============
    Error type E_ERROR was caused in line 675 file /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error report: Uncaught RuntimeException: Failed to claim actions. Database error. in /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675
    Stack trace:
    #0 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, ”)
    #1 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(206): ActionScheduler_DBStore->stake_claim(25, NULL, Array, ”)
    #2 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_HybridStore->stake_claim(25)
    #3 /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueR

    System status

    ### WordPress Environment ###

    WordPress address (URL): https://www.sherlock-michalovce.sk
    Site address (URL): https://www.sherlock-michalovce.sk
    WC Version: 4.0.1
    REST API Version: ? 1.0.7
    WC Blocks Version: ? 2.5.15
    Action Scheduler Version: ? 3.1.4
    WC Admin Version: ? 1.0.3
    Log Directory Writable: ?
    WP Version: ? 5.3.2 – Je dostupná nov?ia verzia WordPressu (5.4)
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: sk_SK
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.3.6
    PHP Post Max Size: 128 MB
    PHP Time Limit: 90
    PHP Max Input Vars: 10000
    cURL Version: 7.29.0
    NSS/3.36

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.1.37-MariaDB
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 3.8.1
    WC Database Prefix: wp_
    Celková ve?kos? databázy: 16.64MB
    Ve?kos? údajov v databáze: 14.48MB
    Ve?kos? indexu databázy: 2.16MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 1.08MB + Index: 0.11MB + Engine InnoDB
    wp_postmeta: Data: 1.52MB + Index: 0.73MB + Engine InnoDB
    wp_posts: Data: 1.38MB + Index: 0.13MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_UPCP_Catalogues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Catalogue_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Custom_Fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Fields_Meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Item_Images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_SubCategories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Tagged_Items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Tag_Groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_UPCP_Videos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_usermeta: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 2.23MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 2.02MB + Index: 0.09MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 142
    custom_css: 1
    feedback: 2
    jetpack_migration: 2
    jp_img_sitemap: 2
    jp_sitemap: 2
    jp_sitemap_master: 2
    nav_menu_item: 18
    oembed_cache: 3
    page: 14
    popupbuilder: 1
    post: 6
    product: 22
    product_variation: 200
    revision: 116
    scheduled-action: 5

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (14) ###

    WPBruiser: Mihai Chelaru – 3.1.38
    All-in-One WP Migration: ServMask – 7.19
    Business Hours Indicator: Maarten Belmans – 2.2.6
    Jetpack od WordPress.com: Automattic – 8.3
    LoginPress – Customizing the WordPress Login: WPBrigade – 1.4.3
    Popup Builder: Sygnoos – 3.65.2
    TinyMCE Advanced: Andrew Ozz – 5.3.0
    WooCommerce Blocks: Automattic – 2.5.15
    WooCommerce Services: Automattic – 1.22.5
    WooCommerce: Automattic – 4.0.1
    Wordfence Security: Wordfence – 7.4.6
    Yoast SEO: Team Yoast – 13.4.1
    WP-Optimize – Clean, Compress, Cache: David Anderson
    Ruhani Rabin
    Team Updraft – 3.0.19

    YITH WooCommerce Catalog Mode: YITH – 1.6.19

    ### Inactive Plugins (0) ###

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)

    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)

    Connected to WooCommerce.com: –

    ### WC Pages ###

    Slug pre obchod: #349 – /obchod/
    Ko?ík: #351 – /kosik/
    Pokladňa: #353 – /kontrola-objednavky/
    M?j ú?et: #355 – /moj-ucet/
    V?eobecné obchodné podmienky: ? Stránka nenastavená

    ### Theme ###

    Name: Neve
    Version: 2.6.4
    Author URL: https://themeisle.com
    Child Theme: ? – Ak upravujete WooCommerce na rodi?ovskej téme
    ktorú ste nevytvorili
    odporú?ame pou?i? odvodenú tému. Pre?ítajte si návod Ako vytvori? odvodenú tému.

    WooCommerce Support: ?

    ### Templates ###

    Overrides: –

    ### Action Scheduler ###

    Ozna?i? ako vybavenú: 4
    Oldest: –
    Newest: –

    Vybavuje sa: 1
    Oldest: –
    Newest: –

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter korenisko

    (@korenisko)

    WordPress verzia 5.3.2
    Aktuálna téma: Neve (verzia 2.6.4)
    Aktuálny plugin: WooCommerce (verzia 4.0.1)
    PHP verzia 7.3.6

    Hey @korenisko,

    Did you only run into this error while updating? Was the database update able to finish?

    Let us know and we’ll go from there.

    Thanks!

    Thread Starter korenisko

    (@korenisko)

    Did you only run into this error while updating? Was the database update able to finish?

    No.

    Was the database update able to finish?

    No, I tried manually to run database update, but it cant finish. It leeds to blank page with notice: “Na va?ej webovej stránke vznikla kritická chyba. Skontrolujte správcovskú e-mailovú schránku a zistite viac.” (on your page is critical error. Check admin email adress and find more.)
    see picture: https://uloz.to/file/YpkYRxfNpamR/woocommerce-png

    Thank You for help ??

    Thanks for letting me know. Could I get you to check for any error logs? Go to WooCommerce > Status > Logs and use the drop-down at the top to look for any critical error or fatal error logs from the last few days. Then click the view button next to the drop-down. Copy any error messages from them and paste them here in your reply.

    If you go to Tools > Scheduled Actions, does it show any pending scheduled actions? If so, what’s the first one?

    Cheers

    Thread Starter korenisko

    (@korenisko)

    no logs. I enabled debug log now in woocommerce.
    see picture from Tools – scheduled actions:
    https://uloz.to/smazat/f0iEKNfTvixe/7086030754565229568

    Thread Starter korenisko

    (@korenisko)

    Can you look at this? Problems persistst till now.
    My web host has two mysql users, one for public web viewing and second with more rights probably. So may be that problems occurs from not enough mysql user rights?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Woocommerce database error’ is closed to new replies.