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