Отвалился mysql ERROR 2002 (HY000)

[ogost]

покажите содержимое /etc/mysql/my.cnf
/etc/passwd (здесь не всё, а только строчку с mysql)
проинспектируйте содержимое /var/log/mysql.err, /var/log/mysql.log, /var/log/syslog на предмет ошибок, относящихся к mysql и выложите сюда.

[alsoijw]

Сделал апгрейд ни чего не поменялось.

В apt не придусмотрена возможность даунгрейда. Если смешана старая и новая версия то переходить имеет смысл только на новый. Я когда-то пробовал откатится к старым версиям подменив в source.list на старые версии. Апт не смог переустановить пакет, так как упорно искал версию новее чем в репозитории.

[ogost]

если я правильно понял ТС, то он именно так и сделал

[kuznets]

/etc/mysql/my.cnf

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP

/etc/passwd

Код Выделить Развернуть

mysql:x:105:107:MySQL Server,,,:/nonexistent:/bin/false

/var/log/mysql.err его нет
/var/log/mysql.log его нет
/var/log/syslog

Код Выделить Развернуть


Feb 22 06:56:34 1sttech mysqld_safe[12425]: 2016-02-22 06:56:34 0 [Warning] Using unique option prefix key_buffer instead of $
Feb 22 06:56:34 1sttech mysqld_safe[12425]: 2016-02-22 06:56:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecat$
Feb 22 06:56:34 1sttech mysqld_safe[12425]: 2016-02-22 06:56:34 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-1~dotdeb+7.1) starti$
Feb 22 06:56:43 1sttech mysqld_safe[12468]: 2016-02-22 06:56:43 0 [Warning] Using unique option prefix key_buffer instead of $
Feb 22 06:56:43 1sttech mysqld_safe[12468]: 2016-02-22 06:56:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecat$
Feb 22 06:56:43 1sttech mysqld_safe[12468]: 2016-02-22 06:56:43 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-1~dotdeb+7.1) starti$
Feb 22 06:56:45 1sttech mysqld_safe[12493]: 2016-02-22 06:56:45 0 [Warning] Using unique option prefix key_buffer instead of $
Feb 22 06:56:45 1sttech mysqld_safe[12493]: 2016-02-22 06:56:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecat$
Feb 22 06:56:45 1sttech mysqld_safe[12493]: 2016-02-22 06:56:45 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-1~dotdeb+7.1) starti$
Feb 22 06:56:50 1sttech kernel: [4404707.594387] Out of memory in UB 2077: OOM killed process 12912 (mysqld) score 0 vm:28565$
Feb 22 06:57:19 1sttech /etc/init.d/mysql[13193]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debia$
Feb 22 06:57:19 1sttech /etc/init.d/mysql[13193]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Feb 22 06:57:19 1sttech /etc/init.d/mysql[13193]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld$
Feb 22 06:57:19 1sttech /etc/init.d/mysql[13193]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.s$
Feb 22 06:57:19 1sttech /etc/init.d/mysql[13193]:


если я правильно понял ТС, то он именно так и сделал

Да апгрейдился на Jessie.

[ogost]

apt-get dist-upgrade делали? У меня такое ощущение, что не все пакеты обновились.

[kuznets]

Нет, сейчас сделаю.
Cообщение объединено 23 февраля 2016, 07:58:51
apt-get dist-upgrade сделал.

Код Выделить Развернуть


# mysqladmin -p status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq                                                  ld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'                                                   exists!


#nano  /var/log/mysql/error.log

Код Выделить Развернуть


2016-02-23 06:51:35 16488 [Note] InnoDB: FTS optimize thread exiting.
2016-02-23 06:51:35 16488 [Note] InnoDB: Starting shutdown...
2016-02-23 06:51:38 16488 [Note] InnoDB: Shutdown completed; log sequence number 94409384
2016-02-23 06:51:38 16513 [Note] Plugin 'FEDERATED' is disabled.
2016-02-23 06:51:38 16513 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-23 06:51:38 16513 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-23 06:51:38 16513 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-02-23 06:51:38 16513 [Note] InnoDB: Memory barrier is not used
2016-02-23 06:51:38 16513 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-02-23 06:51:38 16513 [Note] InnoDB: Using Linux native AIO
2016-02-23 06:51:38 16513 [Note] InnoDB: Not using CPU crc32 instructions
2016-02-23 06:51:38 16513 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-23 06:51:38 16513 [Note] InnoDB: Completed initialization of buffer pool
2016-02-23 06:51:38 16513 [Note] InnoDB: Highest supported file format is Barracuda.
2016-02-23 06:51:38 16513 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-23 06:51:38 16513 [Note] InnoDB: Waiting for purge to start
2016-02-23 06:51:38 16513 [Note] InnoDB: 5.6.25 started; log sequence number 94409384
ERROR: 1062  Duplicate entry 'innodb' for key 'PRIMARY'
2016-02-23 06:51:38 16513 [ERROR] Aborting
2016-02-23 06:51:38 16513 [Note] Binlog end
2016-02-23 06:51:38 16513 [Note] InnoDB: FTS optimize thread exiting.
2016-02-23 06:51:38 16513 [Note] InnoDB: Starting shutdown...
2016-02-23 06:51:40 16513 [Note] InnoDB: Shutdown completed; log sequence number 94409394
2016-02-23 06:51:40 16513 [Note] /usr/sbin/mysqld: Shutdown complete

160223 06:51:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160223 06:51:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


Код Выделить Развернуть

# dpkg-reconfigure mysql-server
/usr/sbin/dpkg-reconfigure: mysql-server is broken or not fully installed