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

2022-03-29 Thread Johnny A. Solbu
On Sunday 20 February 2022 02:23, Otto Kekäläinen wrote: > Is the issue https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=996028 > still affecting people? We just hit it again on our server aftre4r upgrading just now, and I am not sure why. We had to resort to enableing «innodb_force_recovery =

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

2022-02-19 Thread Otto Kekäläinen
Control: reassign -1 mariadb-server-10.3 Control: tags moreinfo Hello! Is the issue https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=996028 still affecting people? Did anybody figure out the root cause or what upstream issue it was, or what version it was fixed in?

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

2021-10-25 Thread Zertrin
On 2021-10-25 19:37, Otto Kekäläinen wrote: We have two users who have experienced a potentially corrupted database (out of hundreds of thousands or even potentially millions of users, depending how one wants to extrapolate the popcon data). A bug report has been filed and it is kept open in

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

2021-10-25 Thread Otto Kekäläinen
Hello Ondrej! I sent the below message on Oct 10th but I am not sure if you read it. The gist is: > I recommend that you file a bug about this upstream, and try to attach > relevant info from the error log, maybe a strace output etc. Upstream > devs will guide you on what to debug next. The bug

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: [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: [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.