Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

2 entries for same insert stmt in query_request table

I see that some of the queries are shown twice in the query_requests table (exactly same stmt.) and both have the success as true.
Was it executed twice or just the entry in the query_requests table ,if so why ?

Comments

  • moshegmosheg Employee

    The combination of TRANSACTION_ID, STATEMENT_ID, and REQUEST_ID uniquely identifies a statement within a session.
    Can you share those values and the node_name?

  • Here are the details

  • Since the request ids are different does that mean the same statement is being executed twice ?

  • moshegmosheg Employee

    Since you have SET SESSION AUTOCOMMIT TO on;
    The STATEMENT_ID is not incremented.
    The incremented REQUEST_ID shows it is probably a different INSERT request.

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.