Форум программистов, компьютерный форум, киберфорум
Наши страницы

MySQL

Войти
Регистрация
Восстановить пароль
 
tdmitriiv
9 / 9 / 0
Регистрация: 22.12.2010
Сообщений: 39
#1

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

03.02.2014, 08:35. Просмотров 805. Ответов 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
Добрый день! Помогите пожалуйста проанализировать логи mysql. Особенно интересует центральная часть. На сервере установлено...

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

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

Периодически падает скорость инета - Спутниковая связь
Добрый день) Недавно поменяла комп и мой старый верный xp пришлось заменить на win7 (64-bit, максимальная)... и тут началось... ...

Wi-fi периодически падает на Sony VAIO - Wi-Fi
Проблема такая. На новом (купили около месяца назад) ноутбуке Sony VAIO Fit 15 (SVF152C29V) после обновления до Windows 8.1 начал падать...

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

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

Периодически по странным причинам падает сеть - Сети
Всем здравствуйте. Есть простая домашняя сеть: роутер (Asus RT-N15U), 1 проводное и несколько беспроводных устройств. ...

Скорость интернета по WiFi периодически падает - Спутниковая связь
добрый вечер. обращаюсь за практически экстренной помощью в моей проблеме. итак, в последний ~ месяц скорость ВайФай соединения у меня в...

Периодически падает линк на всех устройствах - Сетевое оборудование
Имеем 3 устройства: 1.Роутер D-Link Dir-300(какой то там китайской модификации,3 месяца жизни,живой,без характера), 2. Ноутбук...

Периодически падает FPS независимо от нагрузки на видео - Видеокарты
такая проблема: в некоторых играх, таких как дб3, mafia 2, gta 4, немного в HL 2, и еще нескольких периодически падает фпс. независимо от...


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

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

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