Mysql has stopped working

Asked

Viewed 271 times

0

Hello I am using Mariadb 10.2, I executed the TRUNCATE command in a table with 4 GB and Mysql stopped funionar, I can no longer access any other database, I am using Mysql in xampp and it presents the following message:

2018-11-12 11:28:18 8748 [ERROR] [FATAL] Innodb: The page [page id: space = 6277, page number = 16384] cannot be read in the buffer pool after 100 attempts. The most likely cause of this error may be that the table has been corrupted. Or the table was riddled with an algorithm that is not supported by that instance. If it is not a decompression failure, you can try to fix this problem using innodb_force_recovery. We will try our best to get some information that will help diagnose the problem, but since we have already failed, something is definitely wrong and this may have failed. Server version: 10.2. 2-MariaDB key_buffer_size = 16777216 read_buffer_size = 262144 max_used_connections = 0 max_threads = 1001 thread_count = 0 É possível que o mysqld possa usar até key_buffer_size + (read_buffer_size + sort_buffer_size) * max_threads = 787136 K bytes de memória Espero que esteja ok; If not, decrease some variables in the equation. Thread pointer: 0x0x0 Trying to backtrace. You can use the following information to find out where mysqld died. If you don’t see any messages after that, something went wrong [Note] Innodb: Loading buffer pool(s) from C: xampp mysql data ib_buffer_pool 2018-11-12 14:23:57 6300 [Note] 'FEEDBACK' plugin is disabled. 2018-11-12 14:23:57 6300 [Note] Server socket created on IP: '::'. 2018-11-12 14:23:57 1828 [Note] Innodb: Buffer pool(s) of cargo completed in 181112 14: 23:57 mysqld.exe! my_parameter_handler () [my_init. c: 256] mysqld.exe! raise () [winsig. c: 587] mysqld.exe! abort () [abort. c: 75] kernel32.dll! Heapfree () mysqld.exe! free () [free. c: 51] The http://dev.mysql.com/doc/mysql/en/Crashing.html manual page contains information that should help you find out what is causing the failure.

  • Had backup of that bank? Such kind of error has face of not being recoverable in any way.

  • Yes, I had to reinstall Mysql, but I wanted to know if there is a way to recover ...(As I am with Mariadb in xampp and by default the most current version of xampp comes with version 10.1, to upgrade to version 10.2 is a very boring job)

  • has a command of Repair table tries to do it sometimes works.

  • the problem that after this problem, I can no longer log into mysql, therefore I can’t run any commands...

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.