Buster, mariadb 10.3 (migrated) [ERROR] Can't start server : Bind on unix socket: No such file or directory

Alle weiteren Dienste, die nicht in die drei oberen Foren gehören.
Antworten
floogy
Beiträge: 118
Registriert: 19.04.2006 22:43:15

Buster, mariadb 10.3 (migrated) [ERROR] Can't start server : Bind on unix socket: No such file or directory

Beitrag von floogy » 27.07.2020 16:19:45

Hi,

ich habe ein Problem nach dem Upgrade von i386 stretch auf buster i386 auf buster amd64 mariadb (von mysql migriert) zu starten.

https://bugs.debian.org/cgi-bin/bugrepo ... bug=859800
https://bugs.debian.org/cgi-bin/bugrepo ... =926231#58
https://salsa.debian.org/mariadb-team/m ... 4dd5da3e89
https://debian-bugs-dist.debian.narkive ... pace#post1

Hier ein paar Infos.

Code: Alles auswählen

buster:~~# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 10 (buster)
Release:        10
Codename:       buster
buster:~~# apt install mariadb-server-10.3
Paketlisten werden gelesen... Fertig
Abh□ngigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Paket mariadb-server-10.3 ist nicht verf□gbar, wird aber von einem anderen Paket
referenziert. Das kann hei□en, dass das Paket fehlt, dass es abgel□st
wurde oder nur aus einer anderen Quelle verf□gbar ist.
Doch die folgenden Pakete ersetzen es:
  mariadb-server-core-10.3:i386 mariadb-server-core-10.3

E: F□r Paket □mariadb-server-10.3□ existiert kein Installationskandidat.
buster:~~# ps axu | egrep 'mysql|maria'
root      7301  0.0  0.1   7352  2064 pts/0    S+   16:09   0:00 grep -E mysql|maria
buster:~~# dpkg -l maria*|grep ^ii
ii  mariadb-client-10.3        1:10.3.22-0+deb10u1 amd64        MariaDB database client binaries
ii  mariadb-client-core-10.3   1:10.3.22-0+deb10u1 amd64        MariaDB database core client binaries
ii  mariadb-common             1:10.3.22-0+deb10u1 all          MariaDB common metapackage
ii  mariadb-server-core-10.3   1:10.3.22-0+deb10u1 amd64        MariaDB database core server files
buster:~~# dpkg -l mysql*|grep ^ii
ii  mysql-client                5.5.9999+default  amd64        MySQL database client binaries [transitional]
ii  mysql-common                5.8+1.0.5         all          MySQL database common files, e.g. /etc/mysql/my.cnf
buster:~~# egrep -v '#|^ *$' /etc/mysql/mariadb.conf.d/50-server.cnf
[server]
[mysqld]
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
bind-address            = 127.0.0.1
key_buffer_size         = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam_recover_options  = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size   = 100M
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
[embedded]
[mariadb]
[mariadb-10.1]
buster:~~# egrep -v '#|^ *$' /etc/mysql/conf.d/mysql.cnf
[mysql]
buster:~~# egrep -v '#|^ *$' /etc/mysql/conf.d/mysqld_safe_syslog.cnf
[mysqld_safe]
syslog
buster:~~# egrep -v '#|^ *$' /etc/mysql/conf.d/mysqldump.cnf
[mysqldump]
quick
quote-names
max_allowed_packet      = 16M
buster:~~# egrep -v '#|^ *$' /etc/mysql/mariadb.conf.d/50-client.cnf
[client]
default-character-set = utf8mb4
socket = /var/run/mysqld/mysqld.sock
[client-mariadb]
buster:~~# egrep -v '#|^ *$' /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf
[mysql]
default-character-set = utf8mb4
[mysql_upgrade]
[mysqladmin]
[mysqlbinlog]
[mysqlcheck]
[mysqldump]
[mysqlimport]
[mysqlshow]
[mysqlslap]
buster:~~# journalctl --unit=mariadb
-- Logs begin at Sun 2020-07-26 23:56:43 CEST, end at Mon 2020-07-27 16:10:35 CEST. --
-- No entries --
buster:~~# journalctl --unit=mysql
-- Logs begin at Sun 2020-07-26 23:56:43 CEST, end at Mon 2020-07-27 16:10:35 CEST. --
-- No entries --
buster:~~# /usr/sbin/mysqld &
[1] 8665
buster:~~# 2020-07-27 16:12:41 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 8665 ...
2020-07-27 16:12:41 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2020-07-27 16:12:41 0 [Note] InnoDB: Using Linux native AIO
2020-07-27 16:12:41 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-07-27 16:12:41 0 [Note] InnoDB: Uses event mutexes
2020-07-27 16:12:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-27 16:12:41 0 [Note] InnoDB: Number of pools: 1
2020-07-27 16:12:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-27 16:12:41 0 [Note] InnoDB: Initializing buffer pool, total size = 40M, instances = 1, chunk size = 40M
2020-07-27 16:12:41 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-27 16:12:41 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-07-27 16:12:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-27 16:12:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-27 16:12:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-27 16:12:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-07-27 16:12:42 0 [Note] InnoDB: Waiting for purge to start
2020-07-27 16:12:42 0 [Note] InnoDB: 10.3.22 started; log sequence number 1710143858; transaction id 72059793521077869
2020-07-27 16:12:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-07-27 16:12:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-27 16:12:42 0 [Note] InnoDB: Buffer pool(s) load completed at 200727 16:12:42
2020-07-27 16:12:42 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-07-27 16:12:42 0 [ERROR] Can't start server : Bind on unix socket: No such file or directory
2020-07-27 16:12:42 0 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
2020-07-27 16:12:42 0 [ERROR] Aborting


[1]+  Exit 1                  /usr/sbin/mysqld

floogy
Beiträge: 118
Registriert: 19.04.2006 22:43:15

Re: Buster, mariadb 10.3 (migrated) [ERROR] Can't start server : Bind on unix socket: No such file or directory

Beitrag von floogy » 27.07.2020 20:47:01

Okay. Ich habe die installierten Pakete gelöscht und nach der folgenden Anleitung die mariadb version 10.4 installiert.
Dann wurde auch mariadb-server-10.4 (mariadb-server-10.3 ging zuvor ja nicht).

Code: Alles auswählen

pv10:~~# dpkg -l mariadb* mysql* |grep ^ii
ii  mariadb-client              1:10.4.13+maria~buster all          MariaDB database client (metapackage depending on the latest version)
ii  mariadb-client-10.4         1:10.4.13+maria~buster amd64        MariaDB database client binaries
ii  mariadb-client-core-10.4    1:10.4.13+maria~buster amd64        MariaDB database core client binaries
ii  mariadb-common              1:10.4.13+maria~buster all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mariadb-server              1:10.4.13+maria~buster all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.4         1:10.4.13+maria~buster amd64        MariaDB database server binaries
ii  mariadb-server-core-10.4    1:10.4.13+maria~buster amd64        MariaDB database core server files
ii  mariadb-test                1:10.4.13+maria~buster amd64        MariaDB database regression test suite
ii  mariadb-test-data           1:10.4.13+maria~buster all          MariaDB database regression test suite - data files
ii  mysql-common                1:10.4.13+maria~buster all          MariaDB database common files (e.g. /etc/mysql/my.cnf)
https://computingforgeeks.com/how-to-in ... on-debian/

Die Datenbanken wurden alle übernommen.

Antworten