Skip to main content

2 entries for same insert stmt in query_request table

  • Oct 21, 2021 12:22 PM UTC
  • 4 replies
  • 18 views

Sathya
Forum|alt.badge.img+1
  • Participating Frequently

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 ?

4 replies

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 21, 2021 3:25 PM UTC

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?


Sathya
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Oct 22, 2021 5:06 AM UTC

Here are the details


Sathya
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Oct 22, 2021 5:07 AM UTC

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


mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 23, 2021 8:01 AM UTC

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.