#1548 - Cannot load from mysql.proc. The table is probably corrupted

エラーメッセージ

 状態:暗礁  閲覧数:2,572  投稿日:2014-09-10  更新日:2014-09-10  
#1548 - Cannot load from mysql.proc. The table is probably corrupted
# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Error: Couldn't execute 'SHOW DATABASES': Can't read dir of '.' (errno: 24)
Running 'mysqlcheck with default connection arguments
mysqlcheck: Error: Couldn't execute 'SHOW DATABASES': Can't read dir of '.' (errno: 24)
Running 'mysql_fix_privilege_tables'...
ERROR 1016 (HY000) at line 23: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 28: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 31: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 37: Can't open file: './mysql/func.frm' (errno: 24)
ERROR 1016 (HY000) at line 40: Can't open file: './mysql/plugin.frm' (errno: 24)
ERROR 1016 (HY000) at line 43: Can't open file: './mysql/servers.frm' (errno: 24)
ERROR 1016 (HY000) at line 46: Can't open file: './mysql/tables_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 48: Can't open file: './mysql/columns_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 51: Can't open file: './mysql/help_topic.frm' (errno: 24)
ERROR 1016 (HY000) at line 54: Can't open file: './mysql/help_category.frm' (errno: 24)
ERROR 1016 (HY000) at line 57: Can't open file: './mysql/help_relation.frm' (errno: 24)
ERROR 1016 (HY000) at line 60: Can't open file: './mysql/help_keyword.frm' (errno: 24)
ERROR 1016 (HY000) at line 63: Can't open file: './mysql/time_zone_name.frm' (errno: 24)
ERROR 1016 (HY000) at line 66: Can't open file: './mysql/time_zone.frm' (errno: 24)
ERROR 1016 (HY000) at line 69: Can't open file: './mysql/time_zone_transition.frm' (errno: 24)
ERROR 1016 (HY000) at line 72: Can't open file: './mysql/time_zone_transition_type.frm' (errno: 24)
ERROR 1016 (HY000) at line 75: Can't open file: './mysql/time_zone_leap_second.frm' (errno: 24)
ERROR 1016 (HY000) at line 78: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 80: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 86: Can't open file: './mysql/general_log.frm' (errno: 24)
ERROR 1243 (HY000) at line 87: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1016 (HY000) at line 94: Can't open file: './mysql/slow_log.frm' (errno: 24)
ERROR 1243 (HY000) at line 95: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1016 (HY000) at line 98: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 101: Can't open file: './mysql/ndb_binlog_index.frm' (errno: 24)
ERROR 1016 (HY000) at line 136: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 138: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1005 (HY000) at line 183: Can't create table 'cond_instances' (errno: 24)
ERROR 1005 (HY000) at line 213: Can't create table 'events_waits_current' (errno: 24)
ERROR 1005 (HY000) at line 227: Can't create table 'events_waits_history' (errno: 24)
ERROR 1005 (HY000) at line 241: Can't create table 'events_waits_history_long' (errno: 24)
ERROR 1005 (HY000) at line 262: Can't create table 'events_waits_summary_by_instance' (errno: 24)
ERROR 1005 (HY000) at line 283: Can't create table 'events_waits_summary_by_thread_by_event_name' (errno: 24)
ERROR 1005 (HY000) at line 303: Can't create table 'events_waits_summary_global_by_event_name' (errno: 24)
ERROR 1005 (HY000) at line 320: Can't create table 'file_instances' (errno: 24)
ERROR 1005 (HY000) at line 339: Can't create table 'file_summary_by_event_name' (errno: 24)
ERROR 1005 (HY000) at line 359: Can't create table 'file_summary_by_instance' (errno: 24)
ERROR 1005 (HY000) at line 376: Can't create table 'mutex_instances' (errno: 24)
ERROR 1005 (HY000) at line 394: Can't create table 'performance_timers' (errno: 24)
ERROR 1005 (HY000) at line 412: Can't create table 'rwlock_instances' (errno: 24)
ERROR 1005 (HY000) at line 428: Can't create table 'setup_consumers' (errno: 24)
ERROR 1005 (HY000) at line 445: Can't create table 'setup_instruments' (errno: 24)
ERROR 1005 (HY000) at line 461: Can't create table 'setup_timers' (errno: 24)
ERROR 1005 (HY000) at line 478: Can't create table 'threads' (errno: 24)
ERROR 1005 (HY000) at line 481: Can't create table 'proxies_priv' (errno: 24)
ERROR 1016 (HY000) at line 510: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 514: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 516: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 517: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 518: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 521: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 522: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 523: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 529: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 534: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 539: Can't open file: './mysql/tables_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 542: Can't open file: './mysql/tables_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 551: Can't open file: './mysql/tables_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 566: Can't open file: './mysql/columns_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 570: Can't open file: './mysql/columns_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 580: Can't open file: './mysql/columns_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 588: Can't open file: './mysql/func.frm' (errno: 24)
ERROR 1016 (HY000) at line 596: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 598: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 609: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 615: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 625: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 628: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 632: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 635: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 636: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 637: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 638: Can't open file: './mysql/func.frm' (errno: 24)
ERROR 1016 (HY000) at line 642: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 646: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 671: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 676: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 690: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 694: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 708: Can't open file: './mysql/func.frm' (errno: 24)
ERROR 1016 (HY000) at line 710: Can't open file: './mysql/func.frm' (errno: 24)
ERROR 1016 (HY000) at line 719: Can't open file: './mysql/general_log.frm' (errno: 24)
ERROR 1016 (HY000) at line 730: Can't open file: './mysql/slow_log.frm' (errno: 24)
ERROR 1016 (HY000) at line 744: Can't open file: './mysql/plugin.frm' (errno: 24)
ERROR 1016 (HY000) at line 753: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 758: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 759: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 761: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 762: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 764: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 765: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 770: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 771: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 773: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 774: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 776: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 777: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 782: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 788: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 793: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 794: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 796: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 797: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 799: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 800: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 805: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 806: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 808: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 809: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 811: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 812: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 814: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 815: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 817: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 818: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 823: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 824: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 825: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 830: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 837: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 839: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 840: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 841: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 849: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 853: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 857: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 861: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 865: Can't open file: './mysql/procs_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 873: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 920: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 922: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 929: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 932: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 935: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 941: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 944: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 947: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 950: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 956: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 959: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 962: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 965: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 971: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 977: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 979: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 982: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 989: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 991: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 992: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 994: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 996: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 997: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 1002: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1003: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1005: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1007: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1041: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1043: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1044: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1046: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1048: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1051: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1054: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1057: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1060: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1063: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1066: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1069: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1071: Can't open file: './mysql/event.frm' (errno: 24)
ERROR 1016 (HY000) at line 1079: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1081: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1082: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1084: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 1085: Can't open file: './mysql/host.frm' (errno: 24)
ERROR 1016 (HY000) at line 1087: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 1088: Can't open file: './mysql/db.frm' (errno: 24)
ERROR 1016 (HY000) at line 1090: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1097: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1099: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1100: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1102: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1111: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 1112: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 1125: Can't open file: './mysql/proc.frm' (errno: 24)
ERROR 1016 (HY000) at line 1127: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1128: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1129: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1134: Can't open file: './mysql/proxies_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 1135: Can't open file: './mysql/tmp_proxies_priv.frm' (errno: 24)
ERROR 1016 (HY000) at line 1136: Can't open file: './mysql/proxies_priv.frm' (errno: 24)
ERROR 1051 (42S02) at line 1137: Unknown table 'tmp_proxies_priv'
ERROR 1016 (HY000) at line 1140: Can't open file: './mysql/user.frm' (errno: 24)
ERROR 1016 (HY000) at line 1146: Can't open file: './mysql/host.frm' (errno: 24)
FATAL ERROR: Upgrade failed



Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_2dd6_0.MYI' (Errcode: 24)'

#1016 - Can't open file: './database_name/#sql-38f_36aa.frm' (errno: 24)

コメント投稿(ログインが必要)



週間人気ページランキング / 11-16 → 11-22
順位 ページタイトル抜粋 アクセス数
1 ブラウザを閉じたらセッションデータはどうなるの? | セッション 8
2 Parse error: syntax error, unexpected 'public' (T_PUBLIC) | Parse error(エラーメッセージ) 5
3 Fatal error: Access level to ▲::$△ must be protected (as in class ●) or weaker | Fatal error(エラーメッセージ) 4
3 Warning: strlen() expects parameter 1 to be string, array given in ○○.php on line △△ | Warning(エラーメッセージ) 4
4 PHPで定数を定義する方法は2種類ある / 配列定数の定義 3
4 インポートするデータを受信できませんでした。ファイル名が送信されていないか、ファイルサイズが PHP の設定で許可された最大値を超えています。FAQ 1.16 をご覧ください | エラーメッセージ 3
4 ブラウザを閉じたらセッションデータはどうなるの? | セッション 3
4 クラスの継承 | クラスとオブジェクト 3
5 curl で Cookie を使用する 2
5 例外処理 | 制御構造 2
5 Fatal error: Uncaught Error: Call to a member function modify() on string | Fatal error(エラーメッセージ) 2
5 関数定義内での「外部ファイル読込」 | 制御構造 2
5 set_error_handler | 例外処理(制御構造) 2
5 ( ! ) Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined | Fatal error(エラーメッセージ) 2
5 コード例 … 「例外処理」はネストすることができる 2
5 PHP用語 2
5 register_shutdown_function | 関数処理 関数 2
6 クロージャ | 関数 1
6 session.cookie_lifetime / session.use_cookies | セッション 1
6 セッション管理が必要な理由は、HTTPプロトコルには状態を保持する機能がないため | セッション 1
2024/11/23 1:01 更新