[Bug 1166781] New: mysql / mariadb database broken after update from 15.1 to 15.2 beta
http://bugzilla.opensuse.org/show_bug.cgi?id=1166781 Bug ID: 1166781 Summary: mysql / mariadb database broken after update from 15.1 to 15.2 beta Classification: openSUSE Product: openSUSE Distribution Version: Leap 15.2 Hardware: Other OS: Other Status: NEW Severity: Normal Priority: P5 - None Component: Basesystem Assignee: screening-team-bugs@suse.de Reporter: seife@novell.slipkontur.de QA Contact: qa-bugs@suse.de CC: crrodriguez@opensuse.org, kstreitova@suse.com Found By: --- Blocker: --- yesterday I updated my Leap 15.1 server running owncloud-files-10.4.0 on mariadb After the update, no access to the DB was possible. version before update was mysql command did return "access denied to root (using password: YES)" (from memory, I have no exact records). mariadb version before update was mariadb-10.2.31-lp151.2.12.1.x86_64 mariadb version after update is mariadb-10.4.12-lp152.2.1.x86_64 I tried to restore the dump which I had taken before, but this did not go through (will open a separate bug for that) Finally I stopped mariadb, restored /var/lib/mysql from the filesystem backup I had (lucky me!) taken before the update, restarted mysql and it seems to work fine now. Cristian reported similar issues on Tumbleweed. I still have the "broken" data dir (old /var/lib/mysql) in case it is useful for testing. I am a total amateur when it comes to databases, so please speak in easy words ;-) -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1166781 http://bugzilla.opensuse.org/show_bug.cgi?id=1166781#c1 --- Comment #1 from Stefan Seyfried <seife@novell.slipkontur.de> --- I can reproduce it with my test data set uploaded here: https://drive.google.com/file/d/1optsli8AWCqeNnDheRitrXC537vOOf1d/view?usp=s... (contains /var/lib/mysql, user root@localhost, passwd mysql) * install 15.1 minimal server system with online repos (updates already installed) * zypper in mariadb * rm -rf /var/lib/mysql * untar above tarball in /var/lib * systemctl start mariadb * mysql -u root -pmysql => works, "show databases;" * zypper --releasever 15.2 ref * zypper --releasever 15.2 -v dup --no-recommends * mysql -u root -pmysql => ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Now comes the interesting part: * systemctl stop mariadb.service * rm -rf /var/lib/mysql * untar tarball again * systemctl start mariadb.service * mysql -u root -pmysql => works. To break it again: * touch /var/lib/misc/.mariadb_run_update * echo -n 10.2 /var/lib/misc/mariadb_upgrade_info * systemctl restart mariadb => broken So it is the update routine in [Service] ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade ExecStart=/usr/lib/mysql/mysql-systemd-helper start that does kill the DB users table. -- You are receiving this mail because: You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com