Добрый вечер.
При переключении пхп с 7.4 на 7.3. и обратно нету больше возможности подключиться к бд. Если зайти через phpmyadmin или админнер, и выбрать любую базу данных, то вылетает с ошибкой "Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение." Другие некоторые дейсвия могу совершать, например создать новую бд или пользователя.
лог:
2022-01-11T17:02:21.610298Z 0 [Note] d:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe (mysqld 5.7.33) starting as process 12324 ...
2022-01-11T17:02:21.614765Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-01-11T17:02:21.614815Z 0 [Note] InnoDB: Uses event mutexes
2022-01-11T17:02:21.614831Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2022-01-11T17:02:21.614844Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-11T17:02:21.615105Z 0 [Note] InnoDB: Number of pools: 1
2022-01-11T17:02:21.615244Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-01-11T17:02:21.616765Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-01-11T17:02:21.623425Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-11T17:02:21.666447Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-01-11T17:02:21.691015Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 340382548
2022-01-11T17:02:21.691041Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 340382567
2022-01-11T17:02:21.691059Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-01-11T17:02:21.691064Z 0 [Note] InnoDB: Starting crash recovery.
2022-01-11T17:02:23.799648Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-11T17:02:23.799697Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-11T17:02:23.799903Z 0 [Note] InnoDB: Setting file 'd:\openserver\userdata\MySQL-5.7\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-11T17:02:24.053845Z 0 [Note] InnoDB: File 'd:\openserver\userdata\MySQL-5.7\ibtmp1' size is now 12 MB.
2022-01-11T17:02:24.054991Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-01-11T17:02:24.055005Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-01-11T17:02:24.055293Z 0 [Note] InnoDB: Waiting for purge to start
2022-01-11T17:02:24.179599Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 340382567
2022-01-11T17:02:24.179847Z 0 [Note] InnoDB: Loading buffer pool(s) from d:\openserver\userdata\MySQL-5.7\ib_buffer_pool
2022-01-11T17:02:24.179955Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-01-11T17:02:24.366905Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-01-11T17:02:24.367125Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2022-01-11T17:02:24.367257Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2022-01-11T17:02:24.367324Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-01-11T17:02:24.465742Z 0 [Note] Event Scheduler: Loaded 0 events
2022-01-11T17:02:24.465889Z 0 [Note] d:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.33' socket: '' port: 3306 MySQL Community Server (GPL)
2022-01-11T17:02:24.494316Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220111 20:02:24
2022-01-11T17:03:29.997759Z 32 [Warning] InnoDB: A transaction id in a record of table `mysql`.`innodb_index_stats` is newer than the system-wide maximum.
2022-01-11T17:03:29.997818Z 32 [Warning] InnoDB: A transaction id in a record of table `mysql`.`innodb_index_stats` is newer than the system-wide maximum.
2022-01-11 20:03:29 0x1f20 InnoDB: Assertion failure in thread 7968 in file trx0rec.ic line 109
InnoDB: Failing assertion: next_undo_offset > undo_offset
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/5.7/en/ ... overy.html
InnoDB: about forcing recovery.
17:03:30 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=33554432
read_buffer_size=2097152
max_used_connections=2
max_threads=64
thread_count=2
connection_count=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 295692 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x16d1faf9720
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...
7ff6bfaf9252 mysqld.exe!my_errno()
7ffa2b67ec9d MSVCR120.dll!raise()
7ffa2b684874 MSVCR120.dll!abort()
7ff6bfc150a4 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd7babc mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd79bdd mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd79a87 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd7b30c mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd4b837 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfce27a8 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfce1fd6 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfce4b42 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd24afa mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd2440d mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd24202 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfd2394d mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfca2b45 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfca587e mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfb51fb2 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bf3b6b36 mysqld.exe!?ha_open@handler@@QEAAHPEAUTABLE@@PEBDHH@Z()
7ff6bf56340a mysqld.exe!?open_table_from_share@@YAHPEAVTHD@@PEAUTABLE_SHARE@@PEBDIIIPEAUTABLE@@_N@Z()
7ff6bf478076 mysqld.exe!?open_table@@YA_NPEAVTHD@@PEAUTABLE_LIST@@PEAVOpen_table_context@@@Z()
7ff6bf47713d mysqld.exe!?open_and_lock_tables@@YA_NPEAVTHD@@PEAUTABLE_LIST@@IPEAVPrelocking_strategy@@@Z()
7ff6bf478df1 mysqld.exe!?open_tables@@YA_NPEAVTHD@@PEAPEAUTABLE_LIST@@PEAIIPEAVPrelocking_strategy@@@Z()
7ff6bf4791ae mysqld.exe!?open_tables_for_query@@YA_NPEAVTHD@@PEAUTABLE_LIST@@I@Z()
7ff6bf416554 mysqld.exe!?fill_information_schema_tables@THD@@QEAA_NXZ()
7ff6bf410cac mysqld.exe!?get_all_tables@@YAHPEAVTHD@@PEAUTABLE_LIST@@PEAVItem@@@Z()
7ff6bf416199 mysqld.exe!?deallocate@?$allocator@Ust_mysql_show_var@@@std@@QEAAXPEAUst_mysql_show_var@@_K@Z()
7ff6bf4183a0 mysqld.exe!?get_schema_tables_result@@YA_NPEAVJOIN@@W4enum_schema_table_state@@@Z()
7ff6bf572c51 mysqld.exe!?prepare_result@JOIN@@QEAA_NXZ()
7ff6bf95d0ac mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff6bf570bb1 mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
7ff6bf3d4f07 mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
7ff6bf3d6e86 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff6bf3da90e mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff6bf3d3985 mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff6bf3d497a mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff6bf39b87c mysqld.exe!handle_connection()
7ff6bfde9372 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6bfaf90bc mysqld.exe!my_thread_once()
7ffa2b634f6b MSVCR120.dll!_beginthreadex()
7ffa2b635098 MSVCR120.dll!_endthreadex()
7ffa45067034 KERNEL32.DLL!BaseThreadInitThunk()
7ffa46a02651 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (16d1fbf51b0): SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` IN ('grandmontaj') ORDER BY Name ASC LIMIT 250 OFFSET 0
Connection ID (thread ID): 32
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.
- Главная Список форумов Ошибки Open Server
- Поиск
-
- Текущее время: 18 апр 2025, 22:11
- Часовой пояс: UTC+03:00
Информация: Конференция переехала на GitHub. Старый форум доступен только для чтения.