форумы  помощь  поиск  регистрация  майллист  ВХОД  слежка

Вариант для распечатки		Архивированная нить - только для чтения!  Пред. тема | След. тема
Форумы OpenNET: Виртуальная конференция (Public)
Изначальное сообщение		[Проследить за развитием треда]

"Повреждена база"
Сообщение от RaZOR on 16-Мрт-04, 11:19  (MSK)
При некорректном завершении работы mysql 4.0.16 (с InnoDB, FreeBSD 5.1) была повреждена база. Все сводится к файлу /usr/local/mysql/var/ibdata1 при запуске пишет ошибку: 040315 22:18:39  mysqld started 040315 22:18:39  InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 416798017 InnoDB: Doing recovery: scanned up to log sequence number 0 416798017 InnoDB: Page directory corruption: supremum not pointed to 040315 22:18:39  InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex 00000 <skiped> ..........;InnoDB: End of page dump 040315 22:18:39  InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Error: trying to access a stray pointer 8db1bff8 InnoDB: buf pool start is at 9528000, number of pages 4480 040315 22:18:39  InnoDB: Assertion failure in thread 137302016 in file ../../innobase/include/buf0buf.ic line 284 InnoDB: Failing assertion: 0 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to mysql@lists.mysql.com mysqld got signal 11; 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. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 040315 22:18:39  mysqld ended Посоветуйте рецепт оздоровления базы! прям не знаю, что делать... работа стоит :(
	Рекомендовать в FAQ | Cообщить модератору | Наверх

Индекс форумов | Темы | Пред. тема | След. тема

Сообщения по теме

1. "Повреждена база"
Сообщение от Nightman on 16-Мрт-04, 11:28  (MSK)
>При некорректном завершении работы mysql 4.0.16 (с InnoDB, FreeBSD 5.1) была повреждена >база. Все сводится к файлу /usr/local/mysql/var/ibdata1 >при запуске пишет ошибку: >040315 22:18:39  mysqld started >040315 22:18:39  InnoDB: Database was not shut down normally. >InnoDB: Starting recovery from log files... >InnoDB: Starting log scan based on checkpoint at >InnoDB: log sequence number 0 416798017 >InnoDB: Doing recovery: scanned up to log sequence number 0 416798017 >InnoDB: Page directory corruption: supremum not pointed to >040315 22:18:39  InnoDB: Page dump in ascii and hex (16384 bytes): > > len 16384; hex 00000 <skiped> ..........;InnoDB: End of page dump >040315 22:18:39  InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 >InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 >InnoDB: Page lsn 0 0, low 4 bytes of lsn at page >end 0 >InnoDB: Error: trying to access a stray pointer 8db1bff8 >InnoDB: buf pool start is at 9528000, number of pages 4480 >040315 22:18:39  InnoDB: Assertion failure in thread 137302016 in file ../../innobase/include/buf0buf.ic >line 284 >InnoDB: Failing assertion: 0 >InnoDB: We intentionally generate a memory trap. >InnoDB: Send a detailed bug report to mysql@lists.mysql.com >mysqld got signal 11; >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. >We will try our best to scrape up some info that will >hopefully help diagnose >the problem, but since we have already crashed, something is definitely wrong > >and this may fail. > >key_buffer_size=16777216 >read_buffer_size=131072 >max_used_connections=0 >max_connections=100 >threads_connected=0 >It is possible that mysqld could use up to >key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K >bytes of memory >Hope that's ok; if not, decrease some variables in the equation. > >040315 22:18:39  mysqld ended > >Посоветуйте рецепт оздоровления базы! прям не знаю, что делать... работа стоит :( > mysqlcheck --help
	Рекомендовать в FAQ | Cообщить модератору | Наверх

	2. "Повреждена база"
	Сообщение от RaZOR on 16-Мрт-04, 11:34  (MSK)
	>mysqlcheck --help я не могу запустить mysql-сервер без него не пашет
		Рекомендовать в FAQ | Cообщить модератору | Наверх

Удалить

Индекс форумов | Темы | Пред. тема | След. тема

Пожалуйста, прежде чем написать сообщение, ознакомьтесь с данными рекомендациями.