WP-CLI, error occurs when executing Duplicated Post Meta
-
Hello
Thanks for providing such a great plugin
I’m running Delete Duplicated Post Meta
I encountered the following error when I ran wp-cli
My Duplicated Post Meta number is 227,487
The following message prompts that there is insufficient writing space, but I am sure that only 20% of the space is used
Finally, I found that the temporary tmp kept growing space during execution until there was insufficient space.
My ssd has 1.2TBplease help thank you so much
WordPress database error Error writing file ‘/tmp/MYfd=31’ (OS errno 28 – No space left on device) for query SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, post_id, COUNT(*) AS count FROM wp_postmeta GROUP BY post_id, meta_key, meta_value HAVING count > 1 made by include(‘phar:///usr/local/bin/wp/php/boot-phar.php’), include(‘phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php’), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher{closure}, call_user_func, WPSweep_Command->__invoke, WPSweep_Command->run_sweep, WPSweep->sweep, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
PHP Fatal error: Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in /var/www/xxxx.xxxx/wp-includes/class-wpdb.php:3868
Stack trace: 0 /var/www/xxxx.xxxx/wp-includes/class-wpdb.php(3868): mysqli_num_fields() 1 /var/www/xxxx.xxxx/wp-includes/class-wpdb.php(780): wpdb->load_col_info() 2 /var/www/xxxx.xxxx/wp-content/plugins/w3-total-cache/DbCache_WpdbInjection_QueryCaching.php(218): wpdb->__get() 3 /var/www/xxxx.xxxx/wp-content/plugins/w3-total-cache/DbCache_WpdbNew.php(122): W3TC\DbCache_WpdbInjection_QueryCaching->query() 4 /var/www/xxxx.xxxx/wp-includes/class-wpdb.php(3146): W3TC\DbCache_WpdbNew->query() 5 /var/www/xxxx.xxxx/wp-content/plugins/wp-sweep/inc/class-wpsweep.php(686): wpdb->get_results() 6 /var/www/xxxx.xxxx/wp-content/plugins/wp-sweep/inc/class-wpsweep-command.php(122): WPSweep->sweep() 7 /var/www/xxxx.xxxx/wp-content/plugins/wp-sweep/inc/class-wpsweep-command.php(97): WPSweep_Command->run_sweep() 8 [internal function]: WPSweep_Command->__invoke() 9 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php(100): call_user_func() 10 [internal function]: WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher{closure}() 11 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php(488): call_user_func() 12 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(436): WP_CLI\Dispatcher\Subcommand->invoke() 13 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(459): WP_CLI\Runner->run_command() 14 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1284): WP_CLI\Runner->run_command_and_exit() 15 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Bootstrap/LaunchRunner.php(28): WP_CLI\Runner->start() 16 phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/bootstrap.php(83): WP_CLI\Bootstrap\LaunchRunner->proce
The topic ‘WP-CLI, error occurs when executing Duplicated Post Meta’ is closed to new replies.