Skip to main content
Question

Why query_request 'SET' is giving error in error_messages table.

  • Nov 8, 2019 5:45 AM UTC
  • 1 reply
  • 7 views

hsaxena20
Forum|alt.badge.img+1

Why this error is coming many times?
set session autocommit to off 0 ERROR Syntax error at or near ")"
Anyone, please suggest.

1 reply

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • Nov 8, 2019 7:33 AM UTC

Given that the SET command syntax is accurate, try to track the command with the syntax error before.

    cat find_error.sql 
    \! rm -f suspected_queries.txt
    \o suspected_queries.txt
    select distinct(request) from dc_requests_issued
    where transaction_id in ( SELECT transaction_id  FROM error_messages WHERE message ilike '%Syntax error%' );