Ubuntu 14.04 проблема з mySQL

MACCEN · 31 Липня, 2014 в 17:13

Питання до гуру, настроїв я сервер, все працює, але раз в день вилітає така помилка

2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Рестарт мускула вирішує цю проблему, і знову до цього падіння, може хто що підкаже, в неті шукав нічого путнього не найшов.

з лінуксами на ви, але сайти не сильно й грузять память, і вінт взагалі свобідний на 90 відсотків

сервер:

1 Core/1GB/30GB SSD

Natik · 31 Липня, 2014 в 17:51

не знаю як там в ubuntu, але, що в логах пише MySQL (error log)?

MACCEN · 2 Серпня, 2014 в 11:27

140802 7:24:05 [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.

140802 7:24:05 [Note] Plugin 'FEDERATED' is disabled.

140802 7:24:05 InnoDB: The InnoDB memory heap is disabled

140802 7:24:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140802 7:24:05 InnoDB: Compressed tables use zlib 1.2.8

140802 7:24:05 InnoDB: Using Linux native AIO

140802 7:24:05 InnoDB: Initializing buffer pool, size = 128.0M

140802 7:24:05 InnoDB: Completed initialization of buffer pool

140802 7:24:05 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!

140802 7:24:05 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...

140802 7:24:05 InnoDB: Waiting for the background threads to start

140802 7:24:06 InnoDB: 5.5.38 started; log sequence number 25593382

140802 7:24:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306

140802 7:24:06 [Note] - '127.0.0.1' resolves to '127.0.0.1';

140802 7:24:06 [Note] Server socket created on IP: '127.0.0.1'.

140802 7:24:06 [Note] Event Scheduler: Loaded 0 events

140802 7:24:06 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.5.38-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

140802 7:24:07 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired

140802 7:24:07 [Warning] Checking table: './eco_mylife/wp_options'

140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired

140802 7:24:08 [Warning] Checking table: './elutsk/board_boarditem'

140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired

140802 7:24:08 [Warning] Checking table: './elutsk/captcha_captcha'

140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired

140802 7:24:08 [Warning] Checking table: './elutsk/open_viewsstat'

140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired

140802 7:24:08 [Warning] Checking table: './elutsk/profiles_userprofile'

140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired

140802 7:24:08 [Warning] Checking table: './patriot/django_session'

BkSeo · 2 Серпня, 2014 в 16:51

я можу помилятись, тобто не впевнений,що тут саме в тому причина, але в мене так колись вінт глючив... було теж саме, і кожного разу приходилось з бекапа доставати бд, потім деякий час працювало нормально

UPD: СТОП, це часом не на хостінгу така трабла?

LSD · 2 Серпня, 2014 в 17:13

Робити чек заліза ... якщо там все ок, то я думаю варто проаналізувати лог чи при кожному вильоті бються ті самі талиці :

140802 7:24:07 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140802 7:24:07 [Warning] Checking table: './eco_mylife/wp_options'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/board_boarditem'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/captcha_captcha'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/open_viewsstat'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/profiles_userprofile'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './patriot/django_session'

Якщо так то десь якісь модуля конфліктують ... або сам сайт "геніально" задіює якийсь функціонал ...

По назвам таблиць трабла десь на системі аутентифікації ... але то припущення

MACCEN · 2 Серпня, 2014 в 17:28

то vps на digitalocean тому в плані перевірки вінта і так далі, то врятлі вийде.

BkSeo · 2 Серпня, 2014 в 18:12

а пробував - "mysqlcheck", "repair" і т.п. ?

Natik · 3 Серпня, 2014 в 07:06

Треба кусок лога з крахом служби, а це вже лог рестарта.

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

MACCEN · 3 Серпня, 2014 в 08:37

а де глянути цей лог рестарта?

Natik · 3 Серпня, 2014 в 09:15

лог помилок:

/var/log/mysql/mysql.err

а взагалі шлях прописаний в my.cnf

[mysqld]

.....

log-error=/var/log/mysql.err

..

П.С. почитайте тут про логи: http://habrahabr.ru/sandbox/22772/

MACCEN · 3 Серпня, 2014 в 09:42


140802 7:24:05 [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.
140802 7:24:05 [Note] Plugin 'FEDERATED' is disabled.
140802 7:24:05 InnoDB: The InnoDB memory heap is disabled
140802 7:24:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140802 7:24:05 InnoDB: Compressed tables use zlib 1.2.8
140802 7:24:05 InnoDB: Using Linux native AIO
140802 7:24:05 InnoDB: Initializing buffer pool, size = 128.0M
140802 7:24:05 InnoDB: Completed initialization of buffer pool
140802 7:24:05 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!
140802 7:24:05 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...
140802 7:24:05 InnoDB: Waiting for the background threads to start
140802 7:24:06 InnoDB: 5.5.38 started; log sequence number 25593382
140802 7:24:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140802 7:24:06 [Note] - '127.0.0.1' resolves to '127.0.0.1';
140802 7:24:06 [Note] Server socket created on IP: '127.0.0.1'.
140802 7:24:06 [Note] Event Scheduler: Loaded 0 events
140802 7:24:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
140802 7:24:07 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140802 7:24:07 [Warning] Checking table: './eco_mylife/wp_options'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/board_boarditem'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/captcha_captcha'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/open_viewsstat'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './elutsk/profiles_userprofile'
140802 7:24:08 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140802 7:24:08 [Warning] Checking table: './patriot/django_session'
140802 23:46: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.
140802 23:46:28 [Note] Plugin 'FEDERATED' is disabled.
140802 23:46:28 InnoDB: The InnoDB memory heap is disabled
140802 23:46:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140802 23:46:28 InnoDB: Compressed tables use zlib 1.2.8
140802 23:46:28 InnoDB: Using Linux native AIO
140802 23:46:28 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140802 23:46:28 InnoDB: Completed initialization of buffer pool
140802 23:46:28 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140802 23:46:28 [ERROR] Plugin 'InnoDB' init function returned error.
140802 23:46:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140802 23:46:28 [ERROR] Unknown/unsupported storage engine: InnoDB
140802 23:46:28 [ERROR] Aborting
140802 23:46:28 [Note] /usr/sbin/mysqld: Shutdown complete
140802 23:46:28 [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.
140802 23:46:28 [Note] Plugin 'FEDERATED' is disabled.
140802 23:46:28 InnoDB: The InnoDB memory heap is disabled
140802 23:46:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140802 23:46:28 InnoDB: Compressed tables use zlib 1.2.8
140802 23:46:28 InnoDB: Using Linux native AIO
140802 23:46:29 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140802 23:46:29 InnoDB: Completed initialization of buffer pool
140802 23:46:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140802 23:46:29 [ERROR] Plugin 'InnoDB' init function returned error.
140802 23:46:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140802 23:46:29 [ERROR] Unknown/unsupported storage engine: InnoDB
140802 23:46:29 [ERROR] Aborting
140802 23:46:29 [Note] /usr/sbin/mysqld: Shutdown complete
140803 4:36:40 [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.
140803 4:36:40 [Note] Plugin 'FEDERATED' is disabled.
140803 4:36:40 InnoDB: The InnoDB memory heap is disabled
140803 4:36:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140803 4:36:40 InnoDB: Compressed tables use zlib 1.2.8
140803 4:36:40 InnoDB: Using Linux native AIO
140803 4:36:40 InnoDB: Initializing buffer pool, size = 128.0M
140803 4:36:40 InnoDB: Completed initialization of buffer pool
140803 4:36:40 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!
140803 4:36:40 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...
140803 4:36:40 InnoDB: Waiting for the background threads to start
140803 4:36:41 InnoDB: 5.5.38 started; log sequence number 25654535
140803 4:36:41 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140803 4:36:41 [Note] - '127.0.0.1' resolves to '127.0.0.1';
140803 4:36:41 [Note] Server socket created on IP: '127.0.0.1'.
140803 4:36:41 [Note] Event Scheduler: Loaded 0 events
140803 4:36:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
140803 4:36:42 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140803 4:36:42 [Warning] Checking table: './eco_mylife/wp_options'
140803 4:36:43 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140803 4:36:43 [Warning] Checking table: './elutsk/board_boarditem'
140803 4:36:43 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140803 4:36:43 [Warning] Checking table: './elutsk/captcha_captcha'
140803 4:36:43 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140803 4:36:43 [Warning] Checking table: './elutsk/open_viewsstat'
140803 4:36:43 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140803 4:36:43 [Warning] Checking table: './elutsk/profiles_userprofile'
140803 4:36:43 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140803 4:36:43 [Warning] Checking table: './patriot/django_session'
140803 4:36:44 [ERROR] /usr/sbin/mysqld: Table './patriot/open_subscriber' is marked as crashed and should be repaired
140803 4:36:44 [Warning] Checking table: './patriot/open_subscriber'

Natik · 3 Серпня, 2014 в 10:52

судячи по логу - не вистачає пам'яті на сервері. Спробуй зменшити параметр:

[mysqld]

innodb_buffer_pool_size = 12M

(у тебе зараз 128)

MACCEN · 3 Серпня, 2014 в 11:04

щось в /etc/mysql/my.cnf

параметра innodb_buffer_pool_size не знаходжу, чи треба добавити його в тег [mysqld] ?

Natik · 3 Серпня, 2014 в 11:25

знайди файл конфіга сервера Mysql (в вінді в параметрах служби прописано його місцезнаходження, в Ubuntu - не знаю). якщо нема - докинь innodb_buffer_pool_size = 12M в [mysqld].

Рестарт Mysql.

ferryman · 3 Серпня, 2014 в 11:47

десь зверху писали.

Треба спробувати http://stackoverflow...y-on-ec2-server

MACCEN · 3 Серпня, 2014 в 13:49

спробую!

MACCEN · 5 Серпня, 2014 в 12:00

після порад вроді як перестала база лягати, на тому ж самому залізі, дякую...

MACCEN · 12 Серпня, 2014 в 06:35

база знову лягла через тиждень напевно, може хто є гуру, підкажіть що може бути не так... а то вже що тільки не робив

Natik · 13 Серпня, 2014 в 12:03

знову дивишся mysql.err. І частину з помилкою сюди

часто допомагає переустановка MySQL з вигрузкою-загрузкою дампа

MACCEN · 16 Серпня, 2014 в 07:26

Переставновити якось стрьомно, купа сайтів крутиться, а досвіду аж токого немає, логі:


140815  9:37:30 [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.
140815  9:37:30 [Note] Plugin 'FEDERATED' is disabled.
140815  9:37:30 InnoDB: The InnoDB memory heap is disabled
140815  9:37:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140815  9:37:30 InnoDB: Compressed tables use zlib 1.2.8
140815  9:37:30 InnoDB: Using Linux native AIO
140815  9:37:30 InnoDB: Initializing buffer pool, size = 12.0M
140815  9:37:30 InnoDB: Completed initialization of buffer pool
140815  9:37:30 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!
140815  9:37:30  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...
140815  9:37:31  InnoDB: Waiting for the background threads to start
140815  9:37:32 InnoDB: 5.5.38 started; log sequence number 26514305
140815  9:37:32 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140815  9:37:32 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
140815  9:37:32 [Note] Server socket created on IP: '127.0.0.1'.
140815  9:37:32 [Note] Event Scheduler: Loaded 0 events
140815  9:37:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140815  9:37:32 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140815  9:37:32 [Warning] Checking table:   './eco_mylife/wp_options'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './elutsk/board_boarditem'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './elutsk/captcha_captcha'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './elutsk/open_viewsstat'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './elutsk/profiles_userprofile'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './patriot/auth_user' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './patriot/auth_user'
140815  9:37:33 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140815  9:37:33 [Warning] Checking table:   './patriot/django_session'
140815  9:37:34 [ERROR] /usr/sbin/mysqld: Table './patriot/open_item' is marked as crashed and should be repaired
140815  9:37:34 [Warning] Checking table:   './patriot/open_item'
140815  9:37:34 [ERROR] /usr/sbin/mysqld: Table './patriot/open_itemdates' is marked as crashed and should be repaired
140815  9:37:34 [Warning] Checking table:   './patriot/open_itemdates'
140815 16:45:32 [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.
140815 16:45:32 [Note] Plugin 'FEDERATED' is disabled.
140815 16:45:32 InnoDB: The InnoDB memory heap is disabled
140815 16:45:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140815 16:45:32 InnoDB: Compressed tables use zlib 1.2.8
140815 16:45:32 InnoDB: Using Linux native AIO
140815 16:45:32 InnoDB: Initializing buffer pool, size = 12.0M
140815 16:45:32 InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 11
140815 17:06:32 [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.
140815 17:06:32 [Note] Plugin 'FEDERATED' is disabled.
140815 17:06:32 InnoDB: The InnoDB memory heap is disabled
140815 17:06:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140815 17:06:32 InnoDB: Compressed tables use zlib 1.2.8
140815 17:06:32 InnoDB: Using Linux native AIO
140815 17:06:32 InnoDB: Initializing buffer pool, size = 12.0M
140815 17:06:32 InnoDB: Completed initialization of buffer pool
140815 17:06:32 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!
140815 17:06:32  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...
140815 17:06:32  InnoDB: Waiting for the background threads to start
140815 17:06:33 InnoDB: 5.5.38 started; log sequence number 26564291
140815 17:06:33 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140815 17:06:33 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
140815 17:06:33 [Note] Server socket created on IP: '127.0.0.1'.
140815 17:06:33 [Note] Event Scheduler: Loaded 0 events
140815 17:06:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './eco_mylife/wp_options'
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './elutsk/auth_user' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './elutsk/auth_user'
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './elutsk/board_boarditem'
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './elutsk/captcha_captcha'
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './elutsk/django_session' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './elutsk/django_session'
140815 17:06:34 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140815 17:06:34 [Warning] Checking table:   './elutsk/open_viewsstat'
140815 17:06:35 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140815 17:06:35 [Warning] Checking table:   './elutsk/profiles_userprofile'
140815 17:06:35 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140815 17:06:35 [Warning] Checking table:   './patriot/django_session'
140815 23:27:52 [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.
140815 23:27:52 [Note] Plugin 'FEDERATED' is disabled.
140815 23:27:52 InnoDB: The InnoDB memory heap is disabled
140815 23:27:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140815 23:27:52 InnoDB: Compressed tables use zlib 1.2.8
140815 23:27:52 InnoDB: Using Linux native AIO
140815 23:27:52 InnoDB: Initializing buffer pool, size = 12.0M
140815 23:27:52 InnoDB: Completed initialization of buffer pool
140815 23:27:52 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!
140815 23:27:52  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...
140815 23:27:52  InnoDB: Waiting for the background threads to start
140815 23:27:53 InnoDB: 5.5.38 started; log sequence number 26587002
140815 23:27:53 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140815 23:27:53 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
140815 23:27:53 [Note] Server socket created on IP: '127.0.0.1'.
140815 23:27:53 [ERROR] /usr/sbin/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
140815 23:27:53 [ERROR] Can't start server: can't create PID file: No space left on device
140815 23:27:54 [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.
140815 23:27:54 [Note] Plugin 'FEDERATED' is disabled.
140815 23:27:54 InnoDB: The InnoDB memory heap is disabled
140815 23:27:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140815 23:27:54 InnoDB: Compressed tables use zlib 1.2.8
140815 23:27:54 InnoDB: Using Linux native AIO
140815 23:27:54 InnoDB: Initializing buffer pool, size = 12.0M
140815 23:27:54 InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 11
140816  3:23:56 [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.
140816  3:23:56 [Note] Plugin 'FEDERATED' is disabled.
140816  3:23:56 InnoDB: The InnoDB memory heap is disabled
140816  3:23:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140816  3:23:56 InnoDB: Compressed tables use zlib 1.2.8
140816  3:23:56 InnoDB: Using Linux native AIO
140816  3:23:56 InnoDB: Initializing buffer pool, size = 12.0M
140816  3:23:56 InnoDB: Completed initialization of buffer pool
140816  3:23:56 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!
140816  3:23:56  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...
140816  3:23:56  InnoDB: Waiting for the background threads to start
140816  3:23:57 InnoDB: 5.5.38 started; log sequence number 26587002
140816  3:23:57 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140816  3:23:57 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
140816  3:23:57 [Note] Server socket created on IP: '127.0.0.1'.
140816  3:23:57 [Note] Event Scheduler: Loaded 0 events
140816  3:23:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140816  3:23:58 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_options' is marked as crashed and should be repaired
140816  3:23:58 [Warning] Checking table:   './eco_mylife/wp_options'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './eco_mylife/wp_postmeta' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './eco_mylife/wp_postmeta'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './elutsk/board_boarditem' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './elutsk/board_boarditem'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './elutsk/captcha_captcha' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './elutsk/captcha_captcha'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './elutsk/open_viewsstat' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './elutsk/open_viewsstat'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './elutsk/profiles_userprofile' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './elutsk/profiles_userprofile'
140816  3:23:59 [ERROR] /usr/sbin/mysqld: Table './patriot/django_session' is marked as crashed and should be repaired
140816  3:23:59 [Warning] Checking table:   './patriot/django_session'

MACCEN · 16 Серпня, 2014 в 19:33

і ще якось дивно взагалі лягає сервер так, що виручає тільки відкат з бекапа

може хто більш шарить підкажіть, або скільки така допомога буде коштувати?

MACCEN · 24 Серпня, 2014 в 14:06

хтось зможе допомогти, щоб не похоронити те що є?

Zevs_Isver · 24 Серпня, 2014 в 14:08

хтось зможе допомогти, щоб не похоронити те що є?

а найняти СпеціальноНавченуЛюдину?

yurra · 24 Серпня, 2014 в 14:51

Або почати читати логи:

140815 23:27:53 [ERROR] /usr/sbin/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)

140815 23:27:53 [ERROR] Can't start server: can't create PID file: No space left on device

В консолі: df -h і все має стати ясно

Увійти

Ubuntu 14.04 проблема з mySQL

Рекомендовані повідомлення

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Посилання на коментар

Поділитись на інші сайти

Заархівовано

Останні відвідувачі 0 користувачів онлайн

Теми

Ваш акаунт

Підтримка board.lutsk.ua

Інформація