ERROR HPOS tables are missing in the database and couldn’t be created.

System info:

` WordPress Environment

WordPress address (URL): https://xxx.xxx
Site address (URL): https://xxx.xxx
WC Version: 8.2.1
REST API Version: ? 8.2.1
WC Blocks Version: ? 11.1.2
Action Scheduler Version: ? 3.6.4
Log Directory Writable: ?
WP Version: 6.3.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE
External object cache: – Server Environment

Server Info: nginx/1.24.0
PHP Version: 8.0.30
PHP Post Max Size: 64 MB
PHP Time Limit: 900
PHP Max Input Vars: 6000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 8.0.34-cluster
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Dein Server verfügt nicht über eine lauff?hige Version der SoapClient Klasse - einige Zahlungsschnittstellen
welche SOAP nutzen
funktionieren unter Umst?nden nicht korrekt.

DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.2.1
WC Database Prefix: wp_
Datenbank-Gesamtgr??e: 0.84MB
Datenbank-Datengr??e: 0.84MB
Datenbank-Indexgr??e: 0.00MB
wp_woocommerce_sessions: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_attribute_taxonomies: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_order_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_actionscheduler_actions: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_actionscheduler_claims: Daten: 0.03MB + Index: 0.00MB + Engine ndbcluster
wp_actionscheduler_groups: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_actionscheduler_logs: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_commentmeta: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_comments: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_e_events: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_links: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_options: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_postmeta: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_posts: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_term_relationships: Daten: 0.03MB + Index: 0.00MB + Engine ndbcluster
wp_term_taxonomy: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_termmeta: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_terms: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_usermeta: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_users: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_wc_order_coupon_lookup: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_wc_product_attributes_lookup: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_wc_product_download_directories: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_wc_product_meta_lookup: Daten: 0.06MB + Index: 0.00MB + Engine ndbcluster
wp_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster
wp_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine ndbcluster Post Type Counts

attachment: 212
elementor_library: 1
mc4wp-form: 1
nav_menu_item: 29
page: 33
portfolio: 12
post: 13
product: 18
product_variation: 1
pxl-slider: 9
pxl-template: 26
shop_order: 1
wp_global_styles: 1
wpcf7_contact_form: 3 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (15)

Redux Framework: von Team Redux – 4.4.7
Action Scheduler: von Automattic – 3.6.4
Case Addons: von Case Themes – 1.0.5
Classic Editor: von WordPress-Mitwirkende – 1.6.3
Contact Form 7: von Takayuki Miyoshi – 5.8.1
Elementor Pro: von Elementor.com – 3.16.2
Elementor: von Elementor.com – 3.16.6
Extendify: von Extendify – 1.10.0
MC4WP: Mailchimp for WordPress: von ibericode – 4.9.9
Maintenance: von WebFactory Ltd – 4.08
WPC Smart Compare for WooCommerce: von WPClever – 6.1.5
WPC Smart Quick View for WooCommerce: von WPClever – 3.5.1
WPC Smart Wishlist for WooCommerce: von WPClever – 4.7.6
WooCommerce: von Automattic – 8.2.1
ProfilePress: von ProfilePress Membership Team – 4.13.4 Inactive Plugins (2)

Akismet Anti-spam: Spam Protection: von Automattic - Anti-spam Team – 5.3
Hello Dolly: von Matt Mullenweg – 1.7.2 Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
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: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – WC Pages

Shop-Basis: #7 - /shop/
Warenkorb: #8 - /cart/
Kasse: #9 - /checkout/
Mein Konto: #10 - /my-account/
Allgemeine Gesch?ftsbedingungen: ? Seite nicht festgelegt Theme

Name: Ecohub Child
Version: 1.0.5
Author URL: https://casethemes.net/
Child Theme: ?
Parent Theme Name: Ecohub
Parent Theme Version: 1.0.5
Parent Theme Author URL: https://casethemes.net/
WooCommerce Support: ? Templates

Archive Template: Dein Theme hat eine woocommerce.php-Datei
was dazu führt
dass du das Template woocommerce/archive-product.php nicht überschreiben kannst
da woocommerce.php h?her gewichtet wird als archive-product.php. Das ist beabsichtigt
um Darstellungsprobleme zu verhindern.

Overrides: – Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: customize-store
minified-js
new-product-management-experience
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-10-19 10:22:43 +02:00
Options: ?
Notes:
Onboarding: - Action Scheduler

Complete: 5
Oldest: 2023-10-18 12:20:20 +0200
Newest: 2023-10-18 12:25:58 +0200

Failed: 1
Oldest: 2023-10-18 12:24:48 +0200
Newest: 2023-10-18 12:24:48 +0200

Pending: 1
Oldest: 2023-10-19 12:22:49 +0200
Newest: 2023-10-19 12:22:49 +0200 Status report information

Generated at: 2023-10-18 13:03:10 +02:00
`

Hi @hokascha

Yes, this issue could indeed be related to the MySQL NDB Cluster and the large varchar columns exceeding its limits.

By the way, I’ve spotted a similar issue on our GitHub. You might find some useful insights there: https://github.com/woocommerce/woocommerce/issues/39051

Here are a few steps you could take to resolve this issue:

1. Ensure that the database user assigned to your WordPress installation has sufficient permissions to create and modify tables.
2. If possible, you could try to increase the limits of your MySQL NDB Cluster to accommodate larger tables.
3. There might have been an issue during the WooCommerce installation. You could try to uninstall and reinstall the WooCommerce plugin.

If the issue persists, I recommend reaching out to your hosting provider. They might be able to provide more insights or make necessary adjustments to the server configuration.

I hope this clarifies your concern. If you have any other questions, feel free to ask.