The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

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

Answers

  • moshegmosheg Employee
    edited November 8

    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%' );
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.