Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Backup problem with encrypt db

Description

Hi we see problem when we try backup database. In the finaly stage we see error 
2022-05-06T15:41:22.146487+03:00 3 [Note] [MY-011825] [Xtrabackup] Writing /mnt/mysql_replica/percona/db.opt
2022-05-06T15:41:22.146523+03:00 3 [Note] [MY-011825] [Xtrabackup] Done: Writing file /mnt/mysql_replica/percona/db.opt
2022-05-06T15:41:22.208852+03:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2022-05-06T15:41:22.208889+03:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2022-05-06T15:41:22.230158+03:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2022-05-06T15:41:22.242654+03:00 0 [Note] [MY-011825] [Xtrabackup] Copying /var/log/mysql/mysql-bin.000221 to /mnt/mysql_replica/mysql-bin.000221 up to position 5613
2022-05-06T15:41:22.242932+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /var/log/mysql/mysql-bin.000221 to /mnt/mysql_replica/mysql-bin.000221
2022-05-06T15:41:22.266119+03:00 0 [Note] [MY-011825] [Xtrabackup] Writing /mnt/mysql_replica/mysql-bin.index
2022-05-06T15:41:22.266216+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /mnt/mysql_replica/mysql-bin.index
2022-05-06T15:41:22.290495+03:00 0 [Note] [MY-011825] [Xtrabackup] Writing /mnt/mysql_replica/xtrabackup_binlog_info
2022-05-06T15:41:22.290598+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /mnt/mysql_replica/xtrabackup_binlog_info
2022-05-06T15:41:22.299260+03:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2022-05-06T15:41:22.302361+03:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '405388739660'
2022-05-06T15:41:22.302388+03:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 405622008716
2022-05-06T15:41:22.305298+03:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (405622026791)
2022-05-06T15:41:23.353447+03:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK TABLES
2022-05-06T15:41:23.353575+03:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2022-05-06T15:41:23.367568+03:00 0 [Note] [MY-011825] [Xtrabackup] Copying ib_buffer_pool to /mnt/mysql_replica/ib_buffer_pool
2022-05-06T15:41:23.368564+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ib_buffer_pool to /mnt/mysql_replica/ib_buffer_pool
2022-05-06T15:41:23.378231+03:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/mnt/mysql_replica/'
2022-05-06T15:41:23.378260+03:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000221', position '5101', GTID of the last change '57cfb4bf-cb8b-11ec-9fa1-d00d5e944392:1-5353432,73480b20-e1bb-11eb-9192-d00d1b37ffcc:1-15058116239,f82a3a2d-2d6a-11ea-9d4c-901b0ee0d853:1-6428724080'
2022-05-06T15:41:23.389088+03:00 0 [Note] [MY-011825] [Xtrabackup] Writing /mnt/mysql_replica/backup-my.cnf
2022-05-06T15:41:23.389185+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /mnt/mysql_replica/backup-my.cnf
2022-05-06T15:41:23.412315+03:00 0 [Note] [MY-011825] [Xtrabackup] Writing /mnt/mysql_replica/xtrabackup_info
2022-05-06T15:41:23.412425+03:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /mnt/mysql_replica/xtrabackup_info
2022-05-06T15:41:24.444779+03:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (405060119384) to (405622312840) was copied.
2022-05-06T15:41:24.657960+03:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'keyring_file'
2022-05-06T15:41:24.658026+03:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
12:41:24 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
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 = 0 thread_stack 0x100000
xtrabackup(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x5627902bba51]
xtrabackup(print_fatal_signal(int)+0x2f3) [0x56278ef2f373]
xtrabackup(handle_fatal_signal+0xa5) [0x56278ef2f425]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x143c0) [0x7f6a1015e3c0]
xtrabackup(Redo_Log_Data_Manager::~Redo_Log_Data_Manager()+0x7b) [0x56278e9f1efb]
xtrabackup(xtrabackup_backup_func()+0x1f92) [0x56278e9968f2]
xtrabackup(main+0x2052) [0x56278e945a72]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f6a0f7060b3]
xtrabackup(_start+0x2e) [0x56278e9773ce]

Please report a bug at
https://jira.percona.com/projects/PXB

Environment

No LSB modules are available.No LSB modules are available.Distributor ID: UbuntuDescription: Ubuntu 20.04.4 LTSRelease: 20.04Codename: focal

Attachments

2

Smart Checklist

Activity

Илья Каратаев August 30, 2022 at 5:32 AM

it's repeated all the time that i created ticket.I think you have all information that you need. Just set up percona mysql 8 with data at rest and try to do backup with xtrabackup.

We have 2 server  with data at rest and it had the same problem. In our backup script we just return true to have zero status code. Backup is working. But when xtrabackup do it and near bu done in the last step it have problem.

i just run

 

 

 

Aaditya Dubey August 29, 2022 at 11:19 AM

Hi  ,

Thank you for the updates.
Please let me know if issue is repeating consistently if yes then please share full reproducible steps to further debug the issue. 

Илья Каратаев August 29, 2022 at 11:10 AM

Try to do one db backup today, one more time see error).

11:06:55 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
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 = 0 thread_stack 0x100000
xtrabackup(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x5651f69a7621]
xtrabackup(print_fatal_signal(int)+0x2f3) [0x5651f561af43]
xtrabackup(handle_fatal_signal+0xa5) [0x5651f561aff5]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x14420) [0x7f98a3c97420]
xtrabackup(Redo_Log_Data_Manager::~Redo_Log_Data_Manager()+0x7b) [0x5651f50dd3bb]
xtrabackup(xtrabackup_backup_func()+0x2012) [0x5651f50851b2]
xtrabackup(main+0x1422) [0x5651f50358f2]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f98a323f083]
xtrabackup(_start+0x2e) [0x5651f5066b7e]

Please report a bug at https://jira.percona.com/projects/PXB

 

Илья Каратаев August 29, 2022 at 10:58 AM

Илья Каратаев August 29, 2022 at 10:57 AM

Hi I have problem with Jira website, didn't see my previous message.

We see problem in server where we use data a rest.

Details

Assignee

Reporter

Priority

Smart Checklist

Created May 6, 2022 at 3:01 PM
Updated August 30, 2022 at 8:35 AM