Перейти до змісту

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

MACCEN

Автор MACCEN
В Програми / Software / Софт

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

MACCEN

MACCEN

Опубліковано
Опубліковано

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

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

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

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

сервер:

1 Core/1GB/30GB SSD

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано

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

BkSeo

Опубліковано
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
LSD

LSD

Опубліковано
Опубліковано

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

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

MACCEN

Опубліковано
  • Автор
Опубліковано

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

Посилання на коментар
Поділитись на інші сайти
Natik

Natik

Опубліковано
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
Natik

Natik

Опубліковано
Опубліковано

лог помилок:

/var/log/mysql/mysql.err

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

[mysqld]

.....

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

..

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

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано 

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

Natik

Опубліковано
Опубліковано

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

[mysqld]

innodb_buffer_pool_size = 12M

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

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
Natik

Natik

Опубліковано
Опубліковано

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

Рестарт Mysql.

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано

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

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано

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

Посилання на коментар
Поділитись на інші сайти
Natik

Natik

Опубліковано
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
MACCEN

MACCEN

Опубліковано
  • Автор
Опубліковано

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


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

MACCEN

Опубліковано
  • Автор
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
Zevs_Isver

Zevs_Isver

Опубліковано
Опубліковано

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

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

Посилання на коментар
Поділитись на інші сайти
yurra

yurra

Опубліковано
Опубліковано

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

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 і все має стати ясно

Посилання на коментар
Поділитись на інші сайти

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

Ця тема знаходиться в архіві та закрита для подальших відповідей.

Перейти до списку тем


Ваш акаунт

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

 


Monobank

 

Інформація

×
×
  • Створити...