Nick Wang

能发下建表语句和几条示例数据么？我这边复现不了问题

> 我的执行 update 语句后，报错如下： Backup: ERROR 1045 (28000): Access denied for user 'user'@'%!'(MISSING) (using password: YES). 帮忙看下是哪里的问题 大概率是权限问题，archery实例和goinception备份库的账号权限给大一点

最新代码不能复现该问题，请更新代码后确认问题是否解决

看oracle报错应该是gvh和gvl有同名字段导致

把两个错误的日志发上来看下 `docker logs archery -f`

> 我的sql是select user_id,uname from user_info where id=1, 但是透传的时候就变成了 select user_id,uname from user_info where id=1 limit -1所以会报错，另外看日志上只读查询为啥还要show slave status，还报错(1227, 'Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT...

> 另外，我点“SQL分析菜单”的时候也报错 [2022-02-23 09:49:42,094][MainThread:139984038930240][task_id:default][exception_logging_middleware.py:11][ERROR]- Traceback (most recent call last): File "/opt/venv4archery/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/opt/venv4archery/lib/python3.8/site-packages/django/contrib/auth/decorators.py", line 20, in _wrapped_view if test_func(request.user): File "/opt/venv4archery/lib/python3.8/site-packages/django/contrib/auth/decorators.py",...

> 上线工单那，工单执行后想看回滚语句报 > > [2022-02-23 10:05:57,390][MainThread:139984038930240][task_id:default][inception.py:226][ERROR]- 获取回滚语句报错，异常信息Traceback (most recent call last): File "/opt/archery/sql/engines/inception.py", line 213, in get_rollback cur.execute(sql_table) File "/opt/venv4archery/lib/python3.8/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/opt/venv4archery/lib/python3.8/site-packages/MySQLdb/cursors.py", line...

> > 上线工单那，工单执行后想看回滚语句报 > > [2022-02-23 10:05:57,390][MainThread:139984038930240][task_id:default][inception.py:226][ERROR]- 获取回滚语句报错，异常信息Traceback (most recent call last): File "/opt/archery/sql/engines/inception.py", line 213, in get_rollback cur.execute(sql_table) File "/opt/venv4archery/lib/python3.8/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/opt/venv4archery/lib/python3.8/site-packages/MySQLdb/cursors.py",...

> 关于mongodb的查询，也是报认证权限错误，但是实际用该账号去库里查没问题，配置的是dba权限用户  > > docker日志报错如下： [2022-02-23 13:47:57,173][MainThread:139984038930240][task_id:default][query.py:169][ERROR]- 查询异常报错，查询语句：db.Order.find() ，错误信息：Traceback (most recent call last): File "/opt/archery/sql/query.py", line 87, in query query_engine.get_connection(db_name=db_name) File "/opt/archery/sql/engines/mongo.py", line 510, in get_connection self.conn[self.db_name].authenticate(self.user, self.password, self.db_name)...