[MDEV-29859] Got an InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.3.36/extra/mariabackup/xtrabackup.cc line 6045 when try to launch mariabackup --backup Created: 2022-10-24  Updated: 2022-11-23

Status: Open
Project: MariaDB Server
Component/s: mariabackup
Affects Version/s: 10.3.36
Fix Version/s: 10.3

Type: Bug Priority: Major
Reporter: Konstantin SH Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: backup, innodb, mariabackup
Environment:

Ubuntu 18.04.1 LTS (GNU/Linux 5.3.18-3-pve x86_64)


Attachments: PNG File screenshot-1.png     PNG File screenshot-2.png    

 Description   

Hi, when I try to run the mariabackup --backup command I got the error in my terminal:

command is sudo mariabackup --backup --target-dir = /123cluster/mariadb/backups/ --user = root --password = password

And terminal output is:

2022-10-24 10:09:05 0x7f882655c7c0 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.3.36/extra/mariabackup/xtrabackup.cc line 6045
InnoDB: Failing assertion: appended
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
221024 10:09:05 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.3.36-MariaDB-1:10.3.36+maria~ubu1804
key_buffer_size=0
read_buffer_size=131072
max_used_connections=0
max_threads=1
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 5604 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
mariabackup(my_print_stacktrace+0x2e)[0x564f02e2d25e]
mariabackup(handle_fatal_signal+0x515)[0x564f0291f935]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f882434f890]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7f8823f8ae97]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7f8823f8c801]
mariabackup(+0x4d4c31)[0x564f025cfc31]
mariabackup(Z14handle_optionsiPPcPS0_S1+0x460)[0x564f025ee8e0]
mariabackup(main+0x181)[0x564f025d2291]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7)[0x7f8823f6db97]
mariabackup(_start+0x2a)[0x564f025e60ca]
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /123cluster/mariadb/ubuntu_master
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 256207 256207 processes
Max open files 1024 1048576 files
Max locked memory 16777216 16777216 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 256207 256207 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: core

Kernel version: Linux version 5.3.18-3-pve (build@pve) (gcc version 8.3.0 (Debian 8.3.0-6)) #1 SMP PVE 5.3.18-3 (Tue, 17 Mar 2020 16:33:19 +0100)

Aborted

How can I fix this error? Thanks for your help.



 Comments   
Comment by Marko Mäkelä [ 2022-10-24 ]

The crash occurs in the function append_defaults_group(), which is invoked for the start-up parameters defaults-group and login-path. Are these options present in the invocation somehow?

Comment by Konstantin SH [ 2022-10-24 ]

There are no additional options in my command except --user = root and --password = password. This is the correct username and password.

Comment by Marko Mäkelä [ 2022-10-24 ]

Please check if the options could have been parsed from a configuration file.

strace -e open mariabackup --backup …

Comment by Marko Mäkelä [ 2022-10-24 ]

Please check if the options could have been parsed from a configuration file.

strace -e open mariabackup --backup …

Comment by Konstantin SH [ 2022-10-24 ]

Yes, through the
strace -e open mariabackup --backup --target-dir = /123cluster/mariadb/backups/ --user = root --password = password
backup created fine.

But should sudo command work fine too on 10.3x?

Comment by Marko Mäkelä [ 2022-10-24 ]

The purpose of the strace command would have been to find out the location of a configuration file that might have caused the function append_defaults_group() to be invoked.

Comment by Konstantin SH [ 2022-10-25 ]

Well, when I launched strace command again on the same machine I got this error for some reason.

Generated at Thu Feb 08 10:11:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.