Vertica log file question (Session ID)

[becky]

Hi guys,

When I look at my Vertica log file I see info like "Session:0x2aaab8e63790".

For instance:

Code: Select all

2012-09-24 09:49:33.486 Init Session:0x2aaab8e63790 <LOG> @v_node0001: 00000/2705: Connection received: host=10.254.7.222 port=37227 

What does the value "Session:0x2aaab8e63790" represent? It does seem to map to a session ID in the sessions table...

Thanks!

[id10t]

Hi!

Check system_sessions table (transaction_id equals to SessionID in log but in log number in hex):

Code: Select all

db=> select * from system_sessions limit 1;
-[ RECORD 1 ]-----------+-------------------------------------------
node_name               | v_db_node0001
user_name               | dbadmin
session_id              | suse.vertica-18311:0x1dac
transaction_id          | 45035996273720756
session_type            | MOVEOUT
runtime_priority        | 
description             | Txn: a0000000003db4 'Moveout: Tuple Mover'
session_start_timestamp | 2012-09-24 22:39:10.014445+02
session_end_timestamp   | 2012-09-24 22:39:10.026718+02
is_active               | f
session_duration_ms     | 0

[becky]

Thanks, sKwa! So in the log file the session ID is the system session ID? Is that a process that Vertica itself is running? So it has nothing to do with the session id in the sessions table?