Страница 1 из 1

Перестали подходить данные при подключении к MYSQL

Добавлено: 27 май 2023, 06:58
Likoto
Здравствуйте! Случилась следующая ситуация: я заливал картинки в Wordpress, потом - отключили электричество. Из-за этого, часть картинок залилась с ошибками, я их удалил (картинок около тысячи), после чего, wordpress стал писать, что не может соединиться с базой данных. Попробовал зайти через phpmyadmin, но меня не пустило:
mysqli::real_connect(): (HY000/2002): Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение
Данные для авторизации стояли обычные - логин: root, пароль - пусто.

Логи отладки Mysql:
2023-05-27T03:54:48.518714Z 0 [System] [MY-010116] [Server] c:\ospanel\modules\database\MySQL-8.0-Win10\bin\mysqld.exe (mysqld 8.0.30) starting as process 11784
2023-05-27T03:54:48.522665Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=67108864. Please use innodb_redo_log_capacity instead.
2023-05-27T03:54:48.524428Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-27T03:54:49.487214Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-05-27T03:54:49.717329Z 0 [Warning] [MY-010068] [Server] CA certificate c:/ospanel/userdata/MySQL-8.0-Win10/ca.pem is self signed.
2023-05-27T03:54:49.717526Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-05-27T03:54:49.748509Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060
2023-05-27T03:54:49.748574Z 0 [System] [MY-010931] [Server] c:\ospanel\modules\database\MySQL-8.0-Win10\bin\mysqld.exe: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-05-27T03:54:50.668893Z 0 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table `wordpress`.`sopedon_postmeta` index `PRIMARY`, father ptr page no 98, child page no 248
PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: len 8; hex 000000000000d471; asc        q;;
 1: len 6; hex 000000165c20; asc     \ ;;
 2: len 7; hex 82000000910110; asc        ;;
 3: len 8; hex 00000000000041dd; asc       A ;;
 4: len 17; hex 5f77705f61747461636865645f66696c65; asc _wp_attached_file;;
 5: len 8; hex 343138372e6a7067; asc 4187.jpg;;
PHYSICAL RECORD: n_fields 2; compact format; info bits 16
 0: len 8; hex 0000000000000001; asc         ;;
 1: len 4; hex 00000062; asc    b;;
2023-05-27T03:54:50.669272Z 0 [ERROR] [MY-011854] [InnoDB] [FATAL] You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to http://dev.mysql.com/doc/refman/8.0/en/ ... overy.html for information about forcing recovery. Then dump + drop + reimport.
2023-05-27T03:54:50.669288Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0btr.cc:700:ib::fatal triggered thread 4520
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/ ... overy.html
InnoDB: about forcing recovery.
03:54:50 UTC - mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x2399eaa4ea0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
7ff673ef0858    mysqld.exe!?my_print_stacktrace@@YAXPEBEK@Z()
7ff67308e92b    mysqld.exe!?print_fatal_signal@@YAXH@Z()
7ff67308e6f3    mysqld.exe!?my_server_abort@@YAXXZ()
7ff673ed47fa    mysqld.exe!?my_abort@@YAXXZ()
7ff67411ca99    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff673ff9643    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff674182cc3    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6741827c9    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff67417f0f9    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff67418932f    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff67418df82    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff67423761f    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6742373cd    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff674237349    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6742367f4    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff6742385b7    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff674235700    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff674235024    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff674234e1c    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ff673ff8bb7    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff673ff932b    mysqld.exe!??$endl@DU?$char_traits@D@std@@@std@@YAAEAV?$basic_ostream@DU?$char_traits@D@std@@@0@AEAV10@@Z()
7ff6740b033d    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
7ffa757e1bb2    ucrtbase.dll!_configthreadlocale()
7ffa77387034    KERNEL32.DLL!BaseThreadInitThunk()
7ffa778a2651    ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): 
Connection ID (thread ID): 0
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

Перезагрузка сервера/ос не помогает. Подскажите, что можно сделать, чтобы починить это?

Re: Перестали подходить данные при подключении к MYSQL

Добавлено: 05 июн 2023, 01:33
Максим