#237 — [Bug]: asyncpg.exceptions.PostgresSyntaxError: syntax error at or near ”.”

Repo: Twill-AI/twill-llm-engine State: closed | Status: done Assignee: meliascosta

Created: 2025-01-17 · Updated: 2025-01-28

Description

Steps to reproduce

Steps to reproduce

Caused by https://twill-network.slack.com/archives/C082X0FL6G1/p1737060918094269

It seems like the LLM engine failed to run a SQL query in production, due to a SQL syntax error. This is the error message that was logged:

To reproduce:

  1. Login with VMGCORP7j0 (VixMedia Group) tenant in production.
  2. Send any prompt to LLM engine.

What was the expected behavior?

LLM engine should generate the response to the user prompt without any error.

Screenshots

Find logs here.

2025-01-16 20:50:32.424|ERROR|VMGCORP7j0|sql_graph:277|syntax error at or near "."
Traceback (most recent call last):
  File "/usr/local/lib/python3.12/site-packages/twill_llm_engine/graphs/sql_graph.py", line 231, in run_and_check_sql_query
    results = awai

## Notes

_Add implementation notes, blockers, and context here_

## Related

_Add wikilinks to related people, meetings, or other tickets_