Archery icon indicating copy to clipboard operation
Archery copied to clipboard

GoInception检测语句报错

Open ferriswang opened this issue 1 year ago • 7 comments

重现步骤

在SQL上线模块,无论提交什么sql,即使是select * from tb1;都会报如下错误: {"errors":"GoInception检测语句报错,错误信息:\n(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 'inception_magic_start;\n inception set session ghost_a' at line 2")"}

预期外的结果

1 2

日志文本

No response

版本

1.11.3

部署方式

Docker

是否还有其他可以辅助定位问题的信息?比如数据库版本等

Mysql:8.0 Browsers: Chrome goInception: latest Docker version 26.1.2 Docker Compose version v2.20.2

ferriswang avatar Dec 25 '24 12:12 ferriswang

SQL上线模块不支持SELECT语句

zmix999 avatar Dec 27 '24 09:12 zmix999

同样的问题,请问解决了吗

RonadoLong avatar Jan 23 '25 09:01 RonadoLong

我也遇到了这个问题,有解决方案吗

Image

goodluck-yan avatar Mar 27 '25 01:03 goodluck-yan

Image 遇到过吗???

Image

cooker avatar Jun 16 '25 06:06 cooker

Image

© Archery (v1.12.0)

lhsaq2009 avatar Jul 29 '25 15:07 lhsaq2009

[2025-07-29 23:53:48,423][MainThread:139991684368192][task_id:default][goinception.py:174][WARNING]- goInception语句执行报错,错误信息Traceback (most recent call last):
  File "/opt/archery/sql/engines/goinception.py", line 163, in query
    effect_row = cursor.execute(sql)
                 ^^^^^^^^^^^^^^^^^^^
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/connections.py", line 280, in query
    _mysql.connection.query(self, query)
MySQLdb.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 'inception_magic_start;\n                            \n                            ' at line 2")

2025-07-29 23:53:48,423 - default - WARNING - goInception语句执行报错,错误信息Traceback (most recent call last):
  File "/opt/archery/sql/engines/goinception.py", line 163, in query
    effect_row = cursor.execute(sql)
                 ^^^^^^^^^^^^^^^^^^^
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/opt/venv4archery/lib/python3.11/site-packages/MySQLdb/connections.py", line 280, in query
    _mysql.connection.query(self, query)
MySQLdb.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 'inception_magic_start;\n                            \n                            ' at line 2")

2025-07-29 23:53:48,459 - django.request - WARNING - Bad Request: /api/v1/workflow/sqlcheck/

lhsaq2009 avatar Jul 29 '25 15:07 lhsaq2009

delete from up_360_cdt_qc_t1 where ID = '309E2DD8-1B42-9E12-3F43-9A5587154FE4' LIMIT 1;


{"errors":"GoInception检测语句报错,错误信息:\n(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 'inception_magic_start;\\n                            \\n                            ' at line 2\")"}

lhsaq2009 avatar Jul 29 '25 16:07 lhsaq2009