ShahriyarR / MySQL-AutoXtraBackup

MySQL-AutoXtraBackup commandline tool written in Python 3 based on Percona XtraBackup
https://autoxtrabackup.azepug.az/
MIT License
139 stars 79 forks source link

why mysql getting crashed while completing the restore option #378

Closed bimith closed 4 years ago

bimith commented 4 years ago

200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/RMSBlockHist.frm to /else/datastore_1/OmNet/RMSBlockHist.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/RMSExclusionMrv.frm to /else/datastore_1/OmNet/RMSExclusionMrv.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/RMSExclusionHist.frm to /else/datastore_1/OmNet/RMSExclusionHist.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/RMSCategoriesMrv.frm to /else/datastore_1/OmNet/RMSCategoriesMrv.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/PostOrderRej.frm to /else/datastore_1/OmNet/PostOrderRej.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/ExtUserAccessFlags.frm to /else/datastore_1/OmNet/ExtUserAccessFlags.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/EmailLogs.frm to /else/datastore_1/OmNet/EmailLogs.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/PortTomMsgHist4L.frm to /else/datastore_1/OmNet/PortTomMsgHist4L.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/PortTomMsgMrv4L.frm to /else/datastore_1/OmNet/PortTomMsgMrv4L.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/TomMsgHist4L.frm to /else/datastore_1/OmNet/TomMsgHist4L.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./OmNet/TomMsgMrv4L.frm to /else/datastore_1/OmNet/TomMsgMrv4L.frm 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./ib_buffer_pool to /else/datastore_1/ib_buffer_pool 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./xtrabackup_master_key_id to /else/datastore_1/xtrabackup_master_key_id 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./xtrabackup_info to /else/datastore_1/xtrabackup_info 200213 15:28:15 [01] ...done 200213 15:28:15 [01] Copying ./ibtmp1 to /else/datastore_1/ibtmp1 200213 15:28:15 [01] ...done 200213 15:28:15 completed OK! 2020-02-13 15:28:15 DEBUG Data copied back successfully! 2020-02-13 15:28:15 DEBUG New copied-back data now owned by specified user! 2020-02-13 15:28:15 DEBUG Starting MySQL server: 2020-02-13 15:28:15 ERROR Error occurred while starting MySQL! 2020-02-13 15:28:15 ERROR Job for mysql_1.service failed because the control process exited with error code. See "systemctl status mysql_1.service" and "journalctl -xe" for details. 2020-02-13 15:28:15 ERROR RuntimeError: Error occurred while starting MySQL! 2020-02-13 15:28:15 DEBUG <pid.PidFile object at 0x7fa032dbd5c8> closing pidfile: /tmp/autoxtrabackup.pid 2020-02-13 15:28:15 DEBUG <pid.PidFile object at 0x7fa032dbd5c8> closing pidfile: /tmp/autoxtrabackup.pid

am adding the configuration also please check if anything i missed please suggest me

mysql=/usr/bin/mysql mycnf=/etc/my_1.cnf mysqladmin=/usr/bin/mysqladmin mysql_user=root mysql_password=Mysql@123

Set either mysql_socket or host and post. If both are set socket is used

mysql_socket=/else/datastore_1/mysql.sock mysql_host=localhost mysql_port=4417 datadir=/else/datastore_1

[Logging]

[debug,info,warning,error,critical]

log = DEBUG log_file_max_bytes = 1073741824 log_file_backup_count = 7

[Backup]

Optional: set pid directory

pid_dir=/new/MySQL-AutoXtraBackup

tmp_dir=/else/xb_test/mysql_datadirs

Optional: set warning if pid of backup us running for longer than X

pid_runtime_warning=2 Hours

backup_dir=/else/xb_test/backup_dir backup_tool=/usr/bin/xtrabackup

Optional: specify different path/version of xtrabackup here for prepare

prepare_tool=

xtra_prepare=--apply-log-only

Optional: pass additional options for backup stage

xtra_backup=--backup

Optional: pass additional options for prepare stage

xtra_prepare_options=--rebuild-indexes

Optional: pass general additional options; it will go to both for backup and prepare

xtra_options=--binlog-info=ON --galera-info

xtra_options=--no-version-check

Optional: set archive and rotation

archive_dir=/else/xb_test/backup_archives full_backup_interval=1 day

max_archive_size=100GiB

max_archive_duration=4 Days

Optional WARNING(Enable this if you want to take partial backups). Specify database names or table names.

partial_list=OmNet