Skip to main content
Question

Duplicate Query is exists in the query_requests system table

  • September 1, 2020
  • 3 replies
  • 11 views

HyeontaeJu
Forum|alt.badge.img+2

hello, These days, we are using vertica db and make a system.
today, i'm testing the vertica db, and i found something wrong in the query_requests.
Almost 90% of queries have different transaction IDs, which occur twice in the query_requests.

Why Almost 90% of queries occur twice in the query_requests.
Example

3 replies

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • September 10, 2020

Check if the queries are retrying (maybe a join spill). If so, one of the queries will have success=true and the other will not.


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 14, 2020

@Hibiki but,, the query is select query in the screenshot.


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 15, 2020

@Hibiki
Sorry. I'm busy yesterday, so I'll send you a late reply.
Oh, sorry, I'm confused. The program calls the query twice.