We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


What does transaction_id is 0 means? — Vertica Forum

What does transaction_id is 0 means?

We observed there are a lot of sessions are having transaction_id = 0. What does it means? Active of inactive sessions?

Comments

  • Greetings.

     

    Where are you seeing the transaction_id value of 0? You are running a query to view database and session status, I assume?

     

    - Derrick

  • I'm seeing this from the v_monitor.resource_rejection_details table.
    Quite a huge amount of memory >100GB being rejected by transaction 0
    How do I interpret this?

  • Bryan_HBryan_H Vertica Employee Administrator

    In resource_rejection_details, I see transaction ID = 0 along with request_id = 0 and statement_id = -1 for requests where the initial resource request failed (usually for reserving too much memory in a small resource pool). I think this means that the SQL errored out immediately so no transaction was ever opened.
    What is the resource rejection message? You might also be able to correlate this with the session_id and timestamp in query_requests to find the query and see if it errored out.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file