Processed: Re: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-25 Thread Debian Bug Tracking System
Processing control commands: > severity -1 normal Bug #996028 [mariadb-server] InnoDB: corrupted TRX_NO after upgrading to 10.3.31 Severity set to 'normal' from 'grave' -- 996028: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=996028 Debian Bug Tracking System Contact ow...@bugs.debian.org

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-25 Thread Otto Kekäläinen
Control: severity -1 normal On Thu, Oct 21, 2021 at 9:24 PM Marc Gallet wrote: > I've been brought to this bug by apt-listbugs while doing upgrades > on my buster install, warning me of a grave bug. We have two users who have experienced a potentially corrupted database (out of hundreds of

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-24 Thread Jan Korbel
Hello. I agree. I'm still waiting for fix and don't want to dump/drop/import data. JK On Sun, 24 Oct 2021 00:51:08 +0800 Marc Gallet wrote: > Am I to understand that the expected path forward with what is > supposed to be a minor update offered on oldstable is that everyone > shall dump their

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-24 Thread Yves-Alexis Perez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On Sun, 2021-10-24 at 00:51 +0800, Marc Gallet wrote: > Am I to understand that the expected path forward with what is supposed to be > a minor update offered on oldstable is that everyone shall dump their > databases, > delete the data folder,

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-23 Thread Marc Gallet
> With 10.3.29 running, I've dumped all databases (mysqldump --all-databases -p > >mysql.dump), > then dropped all databases, stopped mariadb and deleted /var/lib/mysql/ib*. > Then restarted mariadb, restored databases (source mysql.dump) and finally > upgraded to 10.3.31. > > So my problem is

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-22 Thread Yves-Alexis Perez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On Fri, 2021-10-22 at 02:13 +0800, Marc Gallet wrote: > > Am I correct to assume this issue is still relevant for buster and that > for now, I should simply defer the upgrade (marking the packages to be > held back) and simply wait for this bug to

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-21 Thread Marc Gallet
Package: mariadb-server Followup-For: Bug #996028 Hi, I've been brought to this bug by apt-listbugs while doing upgrades on my buster install, warning me of a grave bug. I have not attempted the upgrade yet, since, after reading this bug, I see a risk of data corruption and I would like to

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-13 Thread Yves-Alexis Perez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On Tue, 2021-10-12 at 21:58 +0200, Ondrej Zary wrote: > > One thing you could also try is to start the server with 10.3.29 and > > ensure that you have a clean shutdown (SET GLOBAL > > innodb_fast_shutdown=0; SHUTDOWN) and only after that start with

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-12 Thread Ondrej Zary
On Sunday 10 October 2021 23:58:12 Otto Kekäläinen wrote: > > The problem is in the ibdata1 file (about 450MB). Deleted other database > > directories and it still crashes, deleted ibdata1 and it runs. > > > > How to bisect mariadb from git? Tried: > > $ git bisect good mariadb-10.3.29 > > $ git

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Otto Kekäläinen
> The problem is in the ibdata1 file (about 450MB). Deleted other database > directories and it still crashes, deleted ibdata1 and it runs. > > How to bisect mariadb from git? Tried: > $ git bisect good mariadb-10.3.29 > $ git bisect bad mariadb-10.3.31 > the build process showed version 10.2 so

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Ondrej Zary
On Sunday 10 October 2021 16:55:45 Otto Kekäläinen wrote: > Hello! > > Thanks for reporting. Could you please check if this has been reported > upstream at jira.mariadb.org? > > There isn't much we can do about InnoDB internals in Debian packaging. > The problem is in the ibdata1 file (about

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Yves-Alexis Perez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 control: subscribe -1 On Sun, 10 Oct 2021 16:13:29 +0200 Ondrej Zary wrote: > Package: mariadb-server > Version: 1:10.3.31-0+deb10u1 > Severity: grave > Justification: causes non-serious data loss > > Dear Maintainer, > upgrading mariadb-server

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Ondrej Zary
Haven't found this exact problem. This seems to be closest but the error messages are different: https://jira.mariadb.org/browse/MDEV-25981 I'm going to copy the datadir to another machine and debug it further. On Sunday 10 October 2021 16:55:45 Otto Kekäläinen wrote: > Hello! > > Thanks for

Bug#996028: [debian-mysql] Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Otto Kekäläinen
Hello! Thanks for reporting. Could you please check if this has been reported upstream at jira.mariadb.org? There isn't much we can do about InnoDB internals in Debian packaging.

Bug#996028: InnoDB: corrupted TRX_NO after upgrading to 10.3.31

2021-10-10 Thread Ondrej Zary
Package: mariadb-server Version: 1:10.3.31-0+deb10u1 Severity: grave Justification: causes non-serious data loss Dear Maintainer, upgrading mariadb-server from 1:10.3.29-0+deb10u1 to 1:10.3.31-0+deb10u1 failed because mariadb failed to start. /var/log/mysql/error.log: 2021-10-10 15:12:49 0