Emergency

Error: failed to execute query Lost connection to MySQL server during query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error: failed to execute query Lost connection to MySQL server during query

    PXC:use docker image "perconalab/percona-xtrabackup:latest"


    Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
    171113 01:21:28 Connecting to MySQL server host: 172.0.0.40, user: root, password: set, port: 3306, socket: /var/run/mysqld/mysqld.sock
    Using server version 5.6.28-76.1-56-log
    xtrabackup version 2.4.6 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 8ec05b7)
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /var/lib/mysql
    xtrabackup: open files limit requested 0, set to 1048576
    xtrabackup: using the following InnoDB configuration:
    xtrabackup: innodb_data_home_dir = .
    xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
    xtrabackup: innodb_log_group_home_dir = ./
    xtrabackup: innodb_log_files_in_group = 2
    xtrabackup: innodb_log_file_size = 134217728
    InnoDB: Number of pools: 1
    171113 01:21:28 >> log scanned up to (15911923062)
    xtrabackup: Generating a list of tablespaces
    InnoDB: Allocated tablespace ID 2723 for management/HzsInsertUserInfoTemp, old maximum was 0
    171113 01:21:28 [01] Copying ./ibdata1 to /xtrabackup_backupfiles/ibdata1
    171113 01:21:29 >> log scanned up to (15911923062)
    171113 01:21:29 [01] ...done
    171113 01:21:29 [01] Copying ./management/HzsInsertUserInfoTemp.ibd to /xtrabackup_backupfiles/management/HzsInsertUserInfoTemp.ibd
    171113 01:21:30 [01] ...done
    171113 01:21:30 [01] Copying ./mysql/slave_relay_log_info.ibd to /xtrabackup_backupfiles/mysql/slave_relay_log_info.ibd
    171113 01:21:30 [01] ...done
    171113 01:21:30 [01] Copying ./mysql/slave_worker_info.ibd to /xtrabackup_backupfiles/mysql/slave_worker_info.ibd
    171113 01:21:30 [01] ...done
    171113 01:21:30 [01] Copying ./mysql/innodb_index_stats.ibd to /xtrabackup_backupfiles/mysql/innodb_index_stats.ibd
    171113 01:21:30 >> log scanned up to (15911923062)
    ......
    .....
    ......
    171113 01:22:18 [01] Copying ./prod_wso2ids/SP_FEDERATED_IDP.ibd to /xtrabackup_backupfiles/prod_wso2ids/SP_FEDERATED_IDP.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./prod_wso2ids/WF_WORKFLOW_REQUEST_RELATION.ibd to /xtrabackup_backupfiles/prod_wso2ids/WF_WORKFLOW_REQUEST_RELATION.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./prod_wso2ids/IDN_CLAIM.ibd to /xtrabackup_backupfiles/prod_wso2ids/IDN_CLAIM.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./prod_wso2ids/SP_AUTH_STEP.ibd to /xtrabackup_backupfiles/prod_wso2ids/SP_AUTH_STEP.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./prod_wso2ids/SP_METADATA.ibd to /xtrabackup_backupfiles/prod_wso2ids/SP_METADATA.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./prod_wso2ids/UM_PERMISSION.ibd to /xtrabackup_backupfiles/prod_wso2ids/UM_PERMISSION.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./activity/HzsOrderInfoLog.ibd to /xtrabackup_backupfiles/activity/HzsOrderInfoLog.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./activity/HzsHomeworkTeacherShare.ibd to /xtrabackup_backupfiles/activity/HzsHomeworkTeacherShare.ibd
    171113 01:22:18 [01] ...done
    171113 01:22:18 [01] Copying ./activity/t_haoduan.ibd to /xtrabackup_backupfiles/activity/t_haoduan.ibd
    171113 01:22:18 >> log scanned up to (15912075483)
    171113 01:22:18 [01] ...done
    171113 01:22:19 [01] Copying ./activity/HzsMobileDataOrderTemp.ibd to /xtrabackup_backupfiles/activity/HzsMobileDataOrderTemp.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./activity/HzsHomeworkActivity.ibd to /xtrabackup_backupfiles/activity/HzsHomeworkActivity.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./activity/HzsMobileDataOrder.ibd to /xtrabackup_backupfiles/activity/HzsMobileDataOrder.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./activity/HzsHomeworkTelBind.ibd to /xtrabackup_backupfiles/activity/HzsHomeworkTelBind.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./zhishinet/HzsActiveUserTemp.ibd to /xtrabackup_backupfiles/zhishinet/HzsActiveUserTemp.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./zhishinet/HzsErrorUserTextBook.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorUserTextBook.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 >> log scanned up to (15912076211)
    171113 01:22:19 [01] Copying ./zhishinet/HzsErrorHomeworkTextBook.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorHomeworkTextBook.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./zhishinet/HzsErrorKnowledge.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorKnowledge.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./zhishinet/HzsErrorImportLog.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorImportLog.ibd
    171113 01:22:19 [01] ...done
    171113 01:22:19 [01] Copying ./zhishinet/HzsErrorPractice.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorPractice.ibd
    171113 01:22:20 >> log scanned up to (15912076837)
    171113 01:22:21 >> log scanned up to (15912076893)
    171113 01:22:22 [01] ...done
    171113 01:22:22 >> log scanned up to (15912076893)
    171113 01:22:22 [01] Copying ./zhishinet/HzsErrorUserKnowledge.ibd to /xtrabackup_backupfiles/zhishinet/HzsErrorUserKnowledge.ibd
    171113 01:22:23 >> log scanned up to (15912076893)
    171113 01:22:24 >> log scanned up to (15912101279)
    171113 01:22:25 [01] ...done
    171113 01:22:25 [01] Copying ./burypoint/LoginDateBuryingPoint.ibd to /xtrabackup_backupfiles/burypoint/LoginDateBuryingPoint.ibd
    171113 01:22:25 >> log scanned up to (15912101279)
    171113 01:22:26 >> log scanned up to (15912101677)
    171113 01:22:27 >> log scanned up to (15912101677)
    171113 01:22:28 >> log scanned up to (15912144162)
    171113 01:22:29 >> log scanned up to (15912144245)
    171113 01:22:30 >> log scanned up to (15912144245)
    171113 01:22:30 [01] ...done
    171113 01:22:31 >> log scanned up to (15912144703)
    Error: failed to execute query SET SESSION lock_wait_timeout=31536000: Lost connection to MySQL server during query
    There is the backup log, but the backup works well at yesterday, what is wrong? Mysql is:5.6.28 xtrabackup is:2.4.6 Unrecognized character \x01; marked by <-- HERE after <-- HERE near colu...

  • #2
    Did you checked mysql error log to verify MySQL server is up and running right after 171113 01:22:31 ? It could be MySQL server stopped and not running at that moment you had error.

    Comment

    Working...
    X