执行sql上线任务,无法提取到回滚信息 #2026
huoshenyingmu
started this conversation in
General
Replies: 1 comment
-
inception做备份的时候,会创建一个ip_库名的数据库,下边的表有$$inception_backup_information$$记录start_binlog_file/end_binlog_file/sql_statement/host/dbname。archery关联inception需要在配置项管理配置后端数据库的信息,其中的账号需要有*.*权限。 @huoshenyingmu |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
[2023-01-10 09:36:33,874][MainThread:140698735875904][task_id:default][mysql.py:357][WARNING]- MySQL语句执行报错,语句:explain show tables;,错误信息Traceback (most recent call last):
File "/opt/archery/sql/engines/mysql.py", line 341, in query
effect_row = cursor.execute(sql)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show tables' at line 1")
[2023-01-10 09:41:18,543][MainThread:140698735875904][task_id:default][goinception.py:263][ERROR]- 获取回滚语句报错,异常信息Traceback (most recent call last):
File "/opt/archery/sql/engines/goinception.py", line 248, in get_rollback
cur.execute(sql_table)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
mysql.connection.query(self, query)
MySQLdb.exceptions.OperationalError: (1142, "SELECT command denied to user 'archery'@'127.0.0.1' for table '$$inception_backup_information$$'")
[2023-01-10 09:41:18,544][MainThread:140698735875904][task_id:default][views.py:281][ERROR]- Traceback (most recent call last):
File "/opt/archery/sql/engines/goinception.py", line 248, in get_rollback
cur.execute(sql_table)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
mysql.connection.query(self, query)
MySQLdb.exceptions.OperationalError: (1142, "SELECT command denied to user 'archery'@'127.0.0.1' for table '$$inception_backup_information$$'")
但是我的数据库不在本地,在云服务器上
Beta Was this translation helpful? Give feedback.
All reactions