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

В 24.08.2014 в 14:06, MACCEN сказав:
хтось зможе допомогти, щоб не похоронити те що є?

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

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

Інформація