Форум программистов, компьютерный форум, киберфорум
Наши страницы
MySQL
Войти
Регистрация
Восстановить пароль
 
tdmitriiv
9 / 9 / 4
Регистрация: 22.12.2010
Сообщений: 39
1

Периодически падает БД

03.02.2014, 08:35. Просмотров 819. Ответов 0
Метки нет (Все метки)

Всем привет, недавно перенес сайт на hetzner с обычного хостинга, вот теперь периодически сайт выводит ошибку подключения к БД, а в логах выводит данную ошибку....

error.log
Кликните здесь для просмотра всего текста

140129 14:20:26 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140129 14:20:26 [Note] Plugin 'FEDERATED' is disabled.
140129 14:20:27 InnoDB: The InnoDB memory heap is disabled
140129 14:20:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140129 14:20:27 InnoDB: Compressed tables use zlib 1.2.3.4
140129 14:20:27 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140129 14:20:27 InnoDB: Completed initialization of buffer pool
140129 14:20:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140129 14:20:27 [ERROR] Plugin 'InnoDB' init function returned error.
140129 14:20:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140129 14:20:27 [ERROR] Unknown/unsupported storage engine: InnoDB
140129 14:20:27 [ERROR] Aborting

140129 14:20:27 [Note] /usr/sbin/mysqld: Shutdown complete

140129 14:20:27 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140129 14:20:27 [Note] Plugin 'FEDERATED' is disabled.
140129 14:20:27 InnoDB: The InnoDB memory heap is disabled
140129 14:20:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140129 14:20:27 InnoDB: Compressed tables use zlib 1.2.3.4
140129 14:20:27 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140129 14:20:27 InnoDB: Completed initialization of buffer pool
140129 14:20:27 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140129 14:20:27 [ERROR] Plugin 'InnoDB' init function returned error.
140129 14:20:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140129 14:20:27 [ERROR] Unknown/unsupported storage engine: InnoDB
140129 14:20:27 [ERROR] Aborting

140129 14:20:27 [Note] /usr/sbin/mysqld: Shutdown complete

140129 18:38:00 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140129 18:38:00 [Note] Plugin 'FEDERATED' is disabled.
140129 18:38:00 InnoDB: The InnoDB memory heap is disabled
140129 18:38:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140129 18:38:00 InnoDB: Compressed tables use zlib 1.2.3.4
140129 18:38:00 InnoDB: Initializing buffer pool, size = 128.0M
140129 18:38:00 InnoDB: Completed initialization of buffer pool
140129 18:38:00 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140129 18:38:00 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140129 18:38:00 InnoDB: Waiting for the background threads to start
140129 18:38:01 InnoDB: 5.5.34 started; log sequence number 1602741
140129 18:38:01 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140129 18:38:01 [Note] - '127.0.0.1' resolves to '127.0.0.1';
140129 18:38:01 [Note] Server socket created on IP: '127.0.0.1'.
140129 18:38:02 [Note] Event Scheduler: Loaded 0 events
140129 18:38:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.34-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
140129 18:38:03 [ERROR] /usr/sbin/mysqld: Table './shop/wa_app_settings' is marked as crashed and should be repaired
140129 18:38:03 [Warning] Checking table: './shop/wa_app_settings'
140129 18:38:03 [ERROR] /usr/sbin/mysqld: Table './shop/shop_cart_items' is marked as crashed and should be repaired
140129 18:38:03 [Warning] Checking table: './shop/shop_cart_items'
140129 18:38:03 [ERROR] /usr/sbin/mysqld: Table './shop/shop_category' is marked as crashed and should be repaired
140129 18:38:03 [Warning] Checking table: './shop/shop_category'
140129 18:38:03 [ERROR] /usr/sbin/mysqld: Table './shop/shop_category_images' is marked as crashed and should be repaired
140129 18:38:03 [Warning] Checking table: './shop/shop_category_images'
140129 18:38:03 [ERROR] /usr/sbin/mysqld: Table './shop/shop_category_products' is marked as crashed and should be repaired
140129 18:38:03 [Warning] Checking table: './shop/shop_category_products'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_checkout_flow' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_checkout_flow'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_customer' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_customer'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_order' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_order'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_order_items' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_order_items'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_order_log' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_order_log'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_order_log_params' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_order_log_params'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_order_params' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_order_params'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_plugin' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_plugin'
140129 18:38:04 [ERROR] /usr/sbin/mysqld: Table './shop/shop_product' is marked as crashed and should be repaired
140129 18:38:04 [Warning] Checking table: './shop/shop_product'
140129 18:38:06 [ERROR] /usr/sbin/mysqld: Table './shop/shop_product_features' is marked as crashed and should be repaired
140129 18:38:06 [Warning] Checking table: './shop/shop_product_features'
140129 18:38:06 [ERROR] /usr/sbin/mysqld: Table './shop/shop_product_images' is marked as crashed and should be repaired
140129 18:38:06 [Warning] Checking table: './shop/shop_product_images'
140129 18:38:06 [ERROR] /usr/sbin/mysqld: Table './shop/shop_product_skus' is marked as crashed and should be repaired
140129 18:38:06 [Warning] Checking table: './shop/shop_product_skus'
140129 18:38:06 [ERROR] /usr/sbin/mysqld: Table './shop/shop_search_index' is marked as crashed and should be repaired
140129 18:38:06 [Warning] Checking table: './shop/shop_search_index'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/shop_search_word' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/shop_search_word'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/shop_type' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/shop_type'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_contact' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_contact'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_contact_categories' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_contact_categories'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_contact_data' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_contact_data'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_contact_emails' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_contact_emails'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_contact_settings' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_contact_settings'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './shop/wa_login_log' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './shop/wa_login_log'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './tuning_center/tcvsavto_news' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './tuning_center/tcvsavto_news'
140129 18:38:07 [ERROR] /usr/sbin/mysqld: Table './vsavto/SC_categories' is marked as crashed and should be repaired
140129 18:38:07 [Warning] Checking table: './vsavto/SC_categories'
0
Similar
Эксперт
41792 / 34177 / 6122
Регистрация: 12.04.2006
Сообщений: 57,940
03.02.2014, 08:35
Ответы с готовыми решениями:

Падает Mysql
Добрый день! Помогите пожалуйста проанализировать логи mysql. Особенно интересует центральная...

Не могу понять почему падает MySQL
Приветствую всех. С недавнего момента на сайте стала падать база с ошибкой: "Can't connect to...

MySQL Падает при попытке изменения конфига
Доброй, чего-то я в корне недопонимаю. Есть VPS, на нём: # uname -a Linux...

Буду признателен за анализ логов - падает база
Здравствуйте, подскажите в чем может быть проблема (логи вложил...

Периодически падает postgres
Здравствуйте. Недавно появилась такая проблема. Пользователи работают с 1с, база на posgtgresql....

0
MoreAnswers
Эксперт
37091 / 29110 / 5898
Регистрация: 17.06.2006
Сообщений: 43,301
03.02.2014, 08:35

Периодически падает интернет
Я пользуюсь Win 7 (макс. 32bit), так же использую Kis 2011 (настройки по умолчанию пока стоят) и...

Периодически Падает Lotus
Есть база автомобилей, есть форма - entry и в ней поле Number, чуть ниже формы есть элемент дизайна...

Mint 15 периодически падает KWin
Добрый день всем. У меня такая проблема - примерно пару месяцев назад окончательно переехал с...


Искать еще темы с ответами

Или воспользуйтесь поиском по форуму:
1
Ответ Создать тему
Опции темы

КиберФорум - форум программистов, компьютерный форум, программирование
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Рейтинг@Mail.ru