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


Invalid sessions info query_requests table — Vertica Forum

Invalid sessions info query_requests table

Hello Team,

 

I would like to know why some of the old sessions are still showing as executing?

 

I queried query_requests where is_executing='t' i found about 9 invalid sessions as executing. How to clean this data from query_requests table?

 

start_timestamp        session_id
2016-11-07 19:40:52    _xxx_node000-120053:0x4244d
2016-11-07 19:10:05    _xxx_node000-35646:0x67413
2016-11-07 16:08:00    _xxx_node000-120053:0x687bc
2016-11-07 12:48:56    _xxx_node000-444564:0x6409d
2016-11-07 12:42:50    _xxx_node000-120053:0x65d71
2016-11-07 12:06:25    _xxx_node000-120053:0x65146
2016-11-07 09:52:48    _xxx_node002-473437:0x5a891
2016-11-03 03:17:56    _xxx_node000-392874:0x231a95
2016-09-30 17:28:43    _xxx_node001-91238:0x1f3f34

 

I tried to close sessions and interrupt statement also.

It says invaild session id.

 

close_session
---------------------------
Error: Invalid session ID
(1 row)

 

It wont bother me but just curious to know the reason why these still show as executing? And would like to know is their a way to clean these?

 

Thanks

Leave a Comment

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