Apache an mysql log error cant fix

Keywords: WordPress - Google Cloud Platform - Technical issue - Services (Apache, MariaDB, MySQL…)

bnsupport ID: d614f7cc-1c81-94d2-9cf7-128661738ba8

bndiagnostic output:

? Apache: Found possible issues
? Mysql: Found possible issues
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-errors-apache/
https://docs.bitnami.com/bch/apps/moodle/troubleshooting/deny-connections-bots-apache/
https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mysql/

Description:
hello, I run bitnami machine tool and get apache an mysql log errors and fix them

Hi @riseitup

Thanks for using Bitnami WordPress!

I have been checking the report generated by the tool and it seems that your database is corrupted. More precisely, the table wp_options is marked as crashed:

/opt/bitnami/apache/logs/error_log

...
[Thu Sep 09 15:24:21.479157 2021] [proxy_fcgi:error] [pid 15280:tid 139792536635136] [client XX.XX.XX.XX:57893] AH01071: Got error 'PHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE option_name = 'siteurl' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), wp_plugin_directory_constants, get_option\nPHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE option_name = 'home' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), wp_cookie_constants, get_option\nPHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE option_name = 'cron' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), WP_Recovery_Mode->initialize, wp_next_scheduled, wp_get_scheduled_event, _get_cron_array, get_option\nPHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1631201061;a:1:{s:32:\\"recovery_mode_clean_expired_keys\\";a:1:{s:32:\\"40cd750bba9870f18aada2478b24840a\\";a:3:{s:8:\\"schedule\\";s:5:\\"daily\\";s:4:\\"args\\";a:0:{}s:8:\\"interval\\";i:86400;}}}s:7:\\"version\\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), WP_Recovery_Mode->initialize, wp_schedule_event, _set_cron_array, update_option, add_option\nPHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE option_name = 'active_plugins' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), wp_get_active_and_valid_plugins, get_option\nPHP message: WordPress database error Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired for query SELECT option_value FROM wp_options WHERE o

/opt/bitnami/mysql/data/mysqld.log

...
2021-09-09T15:46:24.151698Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
2021-09-09T15:46:44.750583Z 8 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T15:46:44.750831Z 8 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T15:46:44.751022Z 8 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T15:46:49.923077Z 9 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T15:46:49.923298Z 9 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T15:46:49.923489Z 9 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-09-09T16:01:20.229475Z 10 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired

Do you happen to have a backup of your database? Else, you can try to follow our guide on how to recover a MySQL database:

https://docs.bitnami.com/google/infrastructure/mysql/administration/recover-database-mysql/

Please, bear in mind that we highly recommend creating a backup of your instance before performing any change:

https://docs.bitnami.com/google/faq/administration/backup-restore-server/

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart: