The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Query end timestamp is NULL - is this a bug?

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

Comments

  • Jim_KnicelyJim_Knicely Administrator

    Hi,

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

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

  • Jim_KnicelyJim_Knicely Administrator

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

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.