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

Падает mysqld.exe при установке форума SMF

Добавлено: 15 дек 2011, 10:16
NeBox
Вот такая ошибка.

win7, 64. OS 4.0.0

Как поправить?

Лог не прикрепить. Выкладываю тут
111215 10:54:39 [Note] Plugin 'FEDERATED' is disabled.
111215 10:54:39  InnoDB: Initializing buffer pool, size = 10.0M
111215 10:54:39  InnoDB: Completed initialization of buffer pool
111215 10:54:39  InnoDB: Started; log sequence number 0 52899
111215 10:54:39 [Note] Event Scheduler: Loaded 0 events
111215 10:54:39 [Note] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: ready for connections.
Version: '5.1.59-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_board_permissions' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_board_permissions'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_boards' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_boards'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_calendar_holidays' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_calendar_holidays'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_categories' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_categories'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_membergroups' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_membergroups'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_message_icons' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_message_icons'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_messages' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_messages'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_package_servers' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_package_servers'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_permission_profiles' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_permission_profiles'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_permissions' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_permissions'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_scheduled_tasks' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_scheduled_tasks'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_settings' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_settings'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_smileys' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_smileys'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_spiders' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_spiders'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_themes' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_themes'
111215 10:55:17 [ERROR] W:\server\mysql\MySQL-5.1.59\bin\mysqld.exe: Table '.\test\smf_topics' is marked as crashed and should be repaired
111215 10:55:17 [Warning] Checking table:   '.\test\smf_topics'
111215 10:55:45 - mysqld got exception 0xc0000005 ;
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=26214400
read_buffer_size=262144
max_used_connections=2
max_threads=100
threads_connected=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 154241 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7ab5d60
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...
77B18DA9    ntdll.dll!RtlIntegerToUnicodeString()
77B18CB8    ntdll.dll!RtlIntegerToUnicodeString()
0068D6A6    mysqld.exe!my_pread()
0067F9F3    mysqld.exe!end_key_cache()
006809AF    mysqld.exe!key_cache_read()
00655BC0    mysqld.exe!?check_next_symbol@Gis_read_stream@@QAE_ND@Z()
006431E1    mysqld.exe!?check_next_symbol@Gis_read_stream@@QAE_ND@Z()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0799DAC0): =OPTIMIZE TABLE `smf_admin_info_files`
Connection ID (thread ID): 12
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: падает mysqld.exe при установке форума SMF

Добавлено: 15 дек 2011, 16:43
NeBox
Есть у кого идеи в чем проблема?
Не охота ради одного скрипта ставить другие сервера....

Re: падает mysqld.exe при установке форума SMF

Добавлено: 15 дек 2011, 21:45
musicman
На InnoDB так только? Похоже сервер тут не при чем. Судя по всему либо буфер переполняется от инфы либо еще что то. Увеличьте буфер на базу в настройках.

Re: падает mysqld.exe при установке форума SMF

Добавлено: 16 дек 2011, 13:58
NeBox
Пробовал увеличивать все где-то в два, где-то нулей дописал - результата нет.
Какой конкретно параметр подкрутить?

И да, как же не сервер, если именно на нем такая фигня? На предыдущей версии OS ставил SMF и было норм. на 4,0,0 не ставиться.

Re: падает mysqld.exe при установке форума SMF

Добавлено: 21 дек 2011, 11:21
NeBox
Есть у кого предыдущая версия?
Вижу, что проблему решить не хотят помогать....

Re: падает mysqld.exe при установке форума SMF

Добавлено: 07 янв 2012, 00:56
Максим
попробуйте так
key_buffer_size=1M
read_buffer_size=1M
max_used_connections=2
max_threads=10
ну и max_connections=100 если есть то тоже - max_connections=10

Добавлено: 07 мар 2013, 10:44
mishanya84
Та же проблема...
Где эти строки исправить Максим?

Добавлено: 07 мар 2013, 11:09
Максим
mishanya84 писал(а):Та же проблема...
Где эти строки исправить Максим?
В конфиге mysql, где же еще.

Добавлено: 07 мар 2013, 11:11
mishanya84
Дай путь пожалуйста до конфига...

Добавлено: 07 мар 2013, 12:46
Максим
:shock: О боже... Меню программы откройте и глаза разуйте.