230608 11:57:17 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 230608 11:57:17 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'root' (using password: YES). 230608 11:57:17 version_check Connected to MySQL server 230608 11:57:17 version_check Executing a version check against the server... 230608 11:57:17 version_check Done. 230608 11:57:17 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/mysql/mysql.sock Error: Unsupported server version: '5.7.42-log'. Please report a bug at https://bugs.launchpad.net/percona-xtrabackup
时间: 2024-04-07 16:29:47 浏览: 256
根据你提供的信息,innobackupex 在执行备份时出现了错误。错误信息中提到了 "Unsupported server version: '5.7.42-log'",这意味着你的 MySQL 服务器版本不被支持。
你需要升级 innobackupex 或降低 MySQL 服务器版本以解决这个问题。另外,备份完成后请务必检查备份运行是否成功,innobackupex 应该会在备份成功后输出 "completed OK!"。
相关问题
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql xtrabackup: recognized client arguments: 230609 18:37:44 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 230609 18:37:44 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'ser=root' (using password: YES). Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','ser=root',...) failed: Access denied for user 'ser=root'@'localhost' (using password: YES) at - line 1314. 230609 18:37:44 Connecting to MySQL server host: localhost, user: ser=root, password: set, port: not set, socket: not set Failed to connect to MySQL server: Access denied for user 'ser=root'@'localhost' (using password: YES).
这个错误提示显示在使用xtrabackup工具备份MySQL数据库时出现了连接MySQL服务器的错误,无法连接到MySQL服务器。
错误提示中指出连接MySQL服务器失败的原因是访问被拒绝,可能原因包括:
1. 用户名或密码错误。
2. MySQL服务器拒绝了该用户的连接请求。
3. 防火墙或网络设置阻止了MySQL服务器的访问。
您可以检查备份命令中MySQL服务器的用户名和密码是否正确,并确保该用户有足够的权限连接和备份MySQL服务器。如果用户信息正确,请检查MySQL服务器的日志以获取更多信息,或者检查网络和防火墙设置以确保MySQL服务器的访问被允许。
The scheduler inside the job manager keeps track of the state and history of each vertex in the graph. At present if the job manager’s computer fails the job is terminated, though the vertex scheduler could employ checkpointing or replication to avoid this. A vertex may be executed multiple times over the length of the job due to failures, and more than one instance of a given vertex may be executing at any given time. Each execution of the vertex has a version number and a corresponding “execution record” that contains the state of that execution and the versions of the predecessor vertices from which its inputs are derived. Each execution names its file-based output channels uniquely using its version number to avoid conflicts among versions. If the entire job completes successfully then each vertex selects a successful execution and renames its output files to their correct final forms.请理解这些话
这段话是在描述一个作业管理器(job manager)的调度器(scheduler)如何管理和跟踪图中每个顶点(vertex)的状态和历史记录。该调度器可以使用检查点(checkpointing)或复制(replication)等方式避免作业在作业管理器计算机出现故障时被终止。
在作业执行过程中,某一顶点可能由于失败而被执行多次,而且同一顶点的多个实例可能同时在执行。每个顶点的每次执行都有一个版本号,相应的“执行记录”包含该执行的状态以及其输入来自前驱顶点的版本。为了避免版本之间的冲突,每个执行使用其版本号唯一地命名基于文件的输出通道。如果整个作业成功完成,则每个顶点将选择一个成功的执行,并将其输出文件重命名为其正确的最终形式。
总之,这段话描述了一个作业管理器调度器的工作流程和一些相关的概念,如检查点、复制、版本号、执行记录等。通过这样的方式,作业管理器可以在计算机故障等情况下提供容错机制,确保作业能够成功完成。
阅读全文