Skip to main content

2 entries for same insert stmt in query_request table

  • October 21, 2021
  • 4 replies
  • 8 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
  • October 21, 2021

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
  • October 22, 2021

Here are the details


Sathya
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 22, 2021

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


mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • October 23, 2021

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.