Skip to main content

Query end timestamp is NULL - is this a bug?

  • Jun 10, 2019 6:49 PM UTC
  • 3 replies
  • 22 views

abtsantosbenten
Forum|alt.badge.img+1

Attached screenshot shows a query that is not executing, but the end timestamp is NULL.
is this a bug?

Vertica: 9.0
From table: V_MONITOR.QUERY_REQUESTS

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Jun 10, 2019 6:51 PM UTC

Hi,

Is it showing up as a CURRENT_STATEMENT in the SESSIONS system table?


abtsantosbenten
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Jun 14, 2019 12:59 PM UTC

I found out that it takes a while for vertica to update the fields when the transaction is done. It was eventually populated.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Jun 14, 2019 1:06 PM UTC

What was the request (i.e. SQL) in the QUERY_REQUESTS table?