remark : 디비에 lock 걸린 컬럼을 삭제 하나거 30분 정도 후에 다시 시도해 봐도 안된다.
1.wp_debug = false 로 하여 에러메시지 찍히게 하니
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
워드프레스 데이터베이스 오류: [Incorrect key file for table './auctionpro/wp_options.MYI'; try to repair it] INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1670546476.4048149585723876953125', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) 워드프레스 데이터베이스 오류: [Incorrect key file for table './auctionpro/wp_options.MYI'; try to repair it] INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_site_transient_timeout_theme_roots', '1670548277', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) 워드프레스 데이터베이스 오류: [Incorrect key file for table './auctionpro/wp_options.MYI'; try to repair it] INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_site_transient_theme_roots', 'a:3:{s:9:\"atahualpa\";s:7:\"/themes\";s:10:\"iconic-one\";s:7:\"/themes\";s:3:\"pen\";s:7:\"/themes\";}', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) 워드프레스 데이터베이스 오류: [Incorrect key file for table './auctionpro/wp_options.MYI'; try to repair it] UPDATE `wp_options` SET `option_value` = 'O:8:\"stdClass\":4:{s:7:\"updates\";a:5:{i:0;O:8:\"stdClass\":10:{s:8:\"response\";s:7:\"upgrade\";s:8:\"download\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.1.zip\";s:6:\"locale\";s:5:\"ko_KR\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.1.zip\";s:10:\"no_content\";s:0:\"\";s:11:\"new_bundled\";s:0:\"\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:5:\"6.1.1\";s:7:\"version\";s:5:\"6.1.1\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"6.1\";s:15:\"partial_version\";s:0:\"\";}i:1;O:8:\"stdClass\":10:{s:8:\"response\";s:7:\"upgrade\";s:8:\"download\";s:59:\"https://downloads.wordpress.org/release/wordpress-6.1.1.zip\";s:6:\"locale\";s:5:\"en_US\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:59:\"https://downloads.wordpress.org/release/wordpress-6.1.1.zip\";s:10:\"no_content\";s:70:\"https://downloads.wordpress.org/release/wordpress-6.1.1-no-content.zip\";s:11:\"new_bundled\";s:71:\"https://downloads.wordpress.org/release/wordpress-6.1.1-new-bundled.zip\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:5:\"6.1.1\";s:7:\"version\";s:5:\"6.1.1\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"6.1\";s:15:\"partial_version\";s:0:\"\";}i:2;O:8:\"stdClass\":11:{s:8:\"response\";s:10:\"autoupdate\";s:8:\"download\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.1.zip\";s:6:\"locale\";s:5:\"ko_KR\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.1.zip\";s:10:\"no_content\";s:0:\"\";s:11:\"new_bundled\";s:0:\"\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:5:\"6.1.1\";s:7:\"version\";s:5:\"6.1.1\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"6.1\";s:15:\"partial_version\";s:0:\"\";s:9:\"new_files\";s:1:\"1\";}i:3;O:8:\"stdClass\":11:{s:8:\"response\";s:10:\"autoupdate\";s:8:\"download\";s:63:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.zip\";s:6:\"locale\";s:5:\"ko_KR\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:63:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.1.zip\";s:10:\"no_content\";s:0:\"\";s:11:\"new_bundled\";s:0:\"\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:3:\"6.1\";s:7:\"version\";s:3:\"6.1\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"6.1\";s:15:\"partial_version\";s:0:\"\";s:9:\"new_files\";s:1:\"1\";}i:4;O:8:\"stdClass\":11:{s:8:\"response\";s:10:\"autoupdate\";s:8:\"download\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.0.3.zip\";s:6:\"locale\";s:5:\"ko_KR\";s:8:\"packages\";O:8:\"stdClass\":5:{s:4:\"full\";s:65:\"https://downloads.wordpress.org/release/ko_KR/wordpress-6.0.3.zip\";s:10:\"no_content\";s:0:\"\";s:11:\"new_bundled\";s:0:\"\";s:7:\"partial\";s:0:\"\";s:8:\"rollback\";s:0:\"\";}s:7:\"current\";s:5:\"6.0.3\";s:7:\"version\";s:5:\"6.0.3\";s:11:\"php_version\";s:6:\"5.6.20\";s:13:\"mysql_version\";s:3:\"5.0\";s:11:\"new_bundled\";s:3:\"6.1\";s:15:\"partial_version\";s:0:\"\";s:9:\"new_files\";s:1:\"1\";}}s:12:\"last_checked\";i:1670546478;s:15:\"version_checked\";s:5:\"6.0.2\";s:12:\"translations\";a:1:{i:0;a:7:{s:4:\"type\";s:4:\"core\";s:4:\"slug\";s:7:\"default\";s:8:\"language\";s:5:\"ko_KR\";s:7:\"version\";s:5:\"6.0.2\";s:7:\"updated\";s:19:\"2022-09-25 12:03:54\";s:7:\"package\";s:64:\"https://downloads.wordpress.org/translation/core/6.0.2/ko_KR.zip\";s:10:\"autoupdate\";b:1;}}}', `autoload` = 'no' WHERE `option_name` = '_site_transient_update_core' |
2.해결 : wp_options 가 깨져 있었다. 명령어로 정상화
OPTIMIZE TABLE wp_options; 로 정상화
Case 2
워드프레스 업데이트
Warning: ftp_close(): SSL_read on shutdown: error:0A000126:SSL routines::unexpected eof while reading in /var/www/auctionpro/wordpress/wp-admin/includes/class-wp-filesystem-ftpext.php on line 828
https://downloads.wordpress.org/release/ko_KR/wordpress-7.0.zip에서 업데이트 다운로드 중…
업데이트 압축 해제 중…
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/auctionpro/wordpress/wp-admin/includes/class-wp-filesystem-ftpext.php on line 212
이 웹사이트에 치명적인 오류가 있습니다.
PHP 실행 시간 30초 제한
현재 PHP 설정이 30초라서 업데이트가 중간에 죽었습니다.
확인:
|
1 2 3 |
php -i | grep max_execution_time |
Apache PHP라면 예:
|
1 2 3 |
sudo nano /etc/php/*/apache2/php.ini |
수정:
|
1 2 3 4 5 |
max_execution_time = 300 max_input_time = 300 memory_limit = 256M |
적용:
sudo systemctl restart apache2|
1 2 3 |
sudo systemctl restart apache2 |
