Что предшествовало проблеме точно сказать не могу. Вроде пытались импортировать большую базу (более 2гб),
выдало ошибку, затем сервер начал ругаться что на разделе с сервером закончилось место, что-то подчистили,
он запустился. Но после ребута сервера умер и больше не поднимается.
Подскажите, как починить или хотя бы переустановить без потери данных?
~# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
var/log/syslog:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 [Note] Plugin 'FEDERATED' is disabled.
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Initializing buffer pool, size = 8.0M
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Completed initialization of buffer pool
Jan 3 12:12:23 servname mysqld: InnoDB: The log sequence number in ibdata files does not match
Jan 3 12:12:23 servname mysqld: InnoDB: the log sequence number in the ib_logfiles!
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Database was not shut down normally!
Jan 3 12:12:23 servname mysqld: InnoDB: Starting crash recovery.
Jan 3 12:12:23 servname mysqld: InnoDB: Reading tablespace information from the .ibd files...
Jan 3 12:12:23 servname mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
Jan 3 12:12:23 servname mysqld: InnoDB: buffer...
Jan 3 12:12:23 servname mysqld: InnoDB: Page directory corruption: infimum not pointed to
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Page dump in ascii and hex (16384 bytes) ...Здесь дампы...
Jan 3 12:12:23 servname mysqld: ;InnoDB: End of page dump
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
Jan 3 12:12:23 servname mysqld: InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page number (if stored to page already) 0,
Jan 3 12:12:23 servname mysqld: InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page may be a freshly allocated page
Jan 3 12:12:23 servname mysqld: InnoDB: Page directory corruption: supremum not pointed to
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Page dump in ascii and hex (16384 bytes):
Jan 3 12:12:23 servname mysqld: len 16384; hex
...Здесь дампы...
Jan 3 12:12:23 servname mysqld: ;InnoDB: End of page dump
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
Jan 3 12:12:23 servname mysqld: InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page number (if stored to page already) 0,
Jan 3 12:12:23 servname mysqld: InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
Jan 3 12:12:23 servname mysqld: InnoDB: Page may be a freshly allocated page
Jan 3 12:12:23 servname mysqld: 130103 12:12:23InnoDB: Error: trying to access a stray pointer 0x341abff8
Jan 3 12:12:23 servname mysqld: InnoDB: buf pool start is at 0xb419c000, end at 0xb499c000
Jan 3 12:12:23 servname mysqld: InnoDB: Probable reason is database corruption or memory
Jan 3 12:12:23 servname mysqld: InnoDB: corruption. If this happens in an InnoDB database recovery, see
Jan 3 12:12:23 servname mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
Jan 3 12:12:23 servname mysqld: InnoDB: how to force recovery.
Jan 3 12:12:23 servname mysqld: 130103 12:12:23 InnoDB: Assertion failure in thread 3075106512 in file ../../../storage/innobase/include/buf0buf.ic line 264
Jan 3 12:12:23 servname mysqld: InnoDB: We intentionally generate a memory trap.
Jan 3 12:12:23 servname mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
Jan 3 12:12:23 servname mysqld: InnoDB: If you get repeated assertion failures or crashes, even
Jan 3 12:12:23 servname mysqld: InnoDB: immediately after the mysqld startup, there may be
Jan 3 12:12:23 servname mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to
Jan 3 12:12:23 servname mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
Jan 3 12:12:23 servname mysqld: InnoDB: about forcing recovery.
Jan 3 12:12:23 servname mysqld: 08:12:23 UTC - mysqld got signal 6 ;
Jan 3 12:12:23 servname mysqld: This could be because you hit a bug. It is also possible that this binary
Jan 3 12:12:23 servname mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Jan 3 12:12:23 servname mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Jan 3 12:12:23 servname mysqld: We will try our best to scrape up some info that will hopefully help
Jan 3 12:12:23 servname mysqld: diagnose the problem, but since we have already crashed,
Jan 3 12:12:23 servname mysqld: something is definitely wrong and this may fail.
Jan 3 12:12:23 servname mysqld:
Jan 3 12:12:23 servname mysqld: key_buffer_size=16777216
Jan 3 12:12:23 servname mysqld: read_buffer_size=131072
Jan 3 12:12:23 servname mysqld: max_used_connections=0
Jan 3 12:12:23 servname mysqld: max_threads=151
Jan 3 12:12:23 servname mysqld: thread_count=0
Jan 3 12:12:23 servname mysqld: connection_count=0
Jan 3 12:12:23 servname mysqld: It is possible that mysqld could use up to
Jan 3 12:12:23 servname mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 345939 K bytes of memory
Jan 3 12:12:23 servname mysqld: Hope that's ok; if not, decrease some variables in the equation.
Jan 3 12:12:23 servname mysqld:
Jan 3 12:12:23 servname mysqld: Thread pointer: 0x0
Jan 3 12:12:23 servname mysqld: Attempting backtrace. You can use the following information to find out
Jan 3 12:12:23 servname mysqld: where mysqld died. If you see no messages after this, something went
Jan 3 12:12:23 servname mysqld: terribly wrong...
Jan 3 12:12:23 servname mysqld: stack_bottom = 0 thread_stack 0x30000
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2d) [0xb7d868ad]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x4a4) [0xb7b6ae64]
Jan 3 12:12:23 servname mysqld: /lib/i686/cmov/libpthread.so.0(+0xe508) [0xb77a1508]
Jan 3 12:12:23 servname mysqld: /lib/i686/cmov/libc.so.6(abort+0x182) [0xb74d5bb2]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(page_cur_search_with_match+0x9a3) [0xb7ca3fb3]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(btr_cur_search_to_nth_level+0x5ae) [0xb7c3b66e]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(btr_pcur_open_on_user_rec+0x73) [0xb7d050a3]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(+0x48aa95) [0xb7c5aa95]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(dict_load_sys_table+0x75) [0xb7c61375]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(dict_boot+0xd27) [0xb7d06957]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(innobase_start_or_create_for_mysql+0x1404) [0xb7cdcce4]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(+0x459056) [0xb7c29056]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(ha_initialize_handlerton(st_plugin_int*)+0x3f) [0xb7b5913f]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(+0x42b3df) [0xb7bfb3df]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(plugin_init(int*, char**, int)+0x89f) [0xb7bfedef]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(+0x278382) [0xb7a48382]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(main+0x212) [0xb7a4cd62]
Jan 3 12:12:23 servname mysqld: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb74beca6]
Jan 3 12:12:23 servname mysqld: /usr/sbin/mysqld(+0x18feb1) [0xb795feb1]
Jan 3 12:12:23 servname mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jan 3 12:12:23 servname mysqld: information that should help you find out what is causing the crash.
Jan 3 12:12:23 servname mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jan 3 12:12:37 servname /etc/init.d/mysql[11592]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 3 12:12:37 servname /etc/init.d/mysql[11592]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 3 12:12:37 servname /etc/init.d/mysql[11592]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 3 12:12:37 servname /etc/init.d/mysql[11592]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 3 12:12:37 servname /etc/init.d/mysql[11592]:
