2014년 10월 10일 금요일

CHECK SUNDB


SYSTEM CHECKUP


HOSTNAME


[sunje@symphony ~]$ hostname      
symphony
[sunje@symphony ~]$



OS


[sunje@symphony ~]$ cat /etc/issue      
CentOS release 6.5 (Final)
Kernel \r on an \m



KERNEL


[sunje@symphony ~]$ uname -a
Linux symphony 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
[sunje@symphony ~]$



CPU


[sunje@symphony ~]$ lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit    
Byte Order: Little Endian
CPU(s): 2
On-line CPU(s) list: 0,1
Thread(s) per core: 1
Core(s) per socket: 2
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 42
Stepping: 7
CPU MHz: 2397.152
BogoMIPS: 4794.30
L1d cache: 32K
L1d cache: 32K
L2d cache: 6144K
NUMA node0 CPU(s): 0,1



MEMORY


[sunje@symphony ~]$ cat /proc/meminfo      
MemTotal: 1922324 kB
MemFree: 1372368 kB
Buffers: 76384 kB
Cached: 185260 kB
SwapCached: 0 kB
Active: 241640 kB
Inactive: 173424 kB
Active(anon): 153492 kB
Inactive(anon): 2700 kB
Active(file): 88148 kB
Inactive(file): 170724 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 1675256 kB
SwapFree: 1675256 kB
Dirty: 56 kB
Writeback: 0 kB
AnonPages: 153540 kB
Mapped: 59124 kB
Shmem: 2776 kB
Slab: 78764 kB
SReclaimable: 20044 kB
SUnreclaim: 58720 kB
KernelStack: 2224 kB
PageTables: 26764 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 2636416 kB
Committed_AS: 835708 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 32280 kB
VmallocChunk: 34359690232 kB
HardwareCorrupted: 0 kB
AnonHugePages: 45056 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 10176 kB
DirectMap2M: 2086912 kB
[sunje@symphony ~]$



DISK


[sunje@symphony ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_symphony-lv_root 14G 12G 2.0G 85% /
tmpfs 939M 228K 939M 1% /dev/shm
/dev/sda1 485M 39M 421M 9% /boot
share 141G 114G 28G 81% /media/sf_share
/dev/sr0 56M 56M 0 100% /media/VBOXADDITIONS_4.3.24_98716
[sunje@symphony ~]$




SUNDB CHECKUP


SUNDB VERSION


[sunje@symphony ~]$ gsql --version

Copyright (c) 2010, 2014, SUNJESOFT Inc. All rights reserved.
Release Trunk.2.2.0 revision(14545)

[sunje@symphony ~]$



DATABASE CATALOG


gSQL> SELECT * FROM CATALOG_NAME;
CATALOG_ID CATALOG_NAME CHARACTER_SET_ID CHARACTER_SET_NAME CHAR_LENGTH_UNITS_ID CHAR_LENGTH_UNITS TIME_ZONE_INTERVAL DEFAULT_DATA_TABLESPACE_ID DEFAULT_TEMP_TABLESPACE_ID CREATED_TIME MODIFIED_TIME COMMENTS
---------- ------------ ---------------- ------------------ -------------------- ----------------- ------------------ -------------------------- -------------------------- -------------------------- -------------------------- --------------
1 sundb 1 UTF8 2 OCTETS +00 09:00:00 2 3 2015-03-05 20:30:38.330000 2015-03-05 20:30:38.330000 sundb database

1 row selected.

gSQL>



DATABASE USER List


gSQL> SELECT AUTHORIZATION_NAME, CREATED_TIME FROM AUTHORIZATIONS WHERE AUTHORIZATION_TYPE='USER';

AUTHORIZATION_NAME CREATED_TIME
------------------ --------------------------
SYS 2015-03-05 20:30:38.330000
TEST 2015-03-05 20:30:38.330000

2 rows selected.

gSQL>



Session상태


gSQL> select * from x$session;

ID SERIAL TRANS_ID TOP_LAYER CONNECTION USER_ID STATUS WATCH SERVER CLIENT_PROCESS SERVER_PROCESS LOGON_TIME PROGRAM ADDRESS PORT
-- ------ -------- --------- ---------- ------- --------- ----- --------- -------------- -------------- -------------------------- ------------------------- ------- ----
1 1 -1 10 DA 2 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:35.970020 gmaster null 0
2 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:35.972789 gmaster: timer null 0
3 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:35.973192 gmaster: cleanup null 0
4 1 -1 12 DA 2 CONNECTED ENTER DEDICATED 2652 2652 2015-03-12 16:24:35.995136 gsql null 0
5 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.399563 gmaster: checkpoint null 0
6 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.400047 gmaster: log writer null 0
7 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.400464 gmaster: database writer null 0
8 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.403502 gmaster: i/o slave null 0
9 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.403896 gmaster: ager null 0
10 1 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:36.404192 gmaster: archiver null 0
11 3 -1 10 DA 0 CONNECTED LEAVE DEDICATED 2662 2662 2015-03-12 16:24:39.477579 gmaster: shared null 0
12 1 -1 11 DA 0 CONNECTED LEAVE DEDICATED 2674 2674 2015-03-12 16:24:39.521951 balancer null 0
13 1 -1 11 DA 0 CONNECTED LEAVE DEDICATED 2676 2676 2015-03-12 16:24:39.571898 dispatcher null 0
14 1 -1 11 DA 0 CONNECTED LEAVE DEDICATED 2676 2676 2015-03-12 16:24:39.575571 dispatcher(send thread) null 0
15 1 -1 11 DA 0 CONNECTED LEAVE DEDICATED 2679 2679 2015-03-12 16:24:39.579171 dispatcher null 0
16 1 -1 11 DA 0 CONNECTED LEAVE DEDICATED 2679 2679 2015-03-12 16:24:39.583847 dispatcher(send thread) null 0
17 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2682 2682 2015-03-12 16:24:39.629330 shared server null 0
18 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2684 2684 2015-03-12 16:24:39.638892 shared server null 0
19 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2686 2686 2015-03-12 16:24:39.645811 shared server null 0
20 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2688 2688 2015-03-12 16:24:39.654617 shared server null 0

ID SERIAL TRANS_ID TOP_LAYER CONNECTION USER_ID STATUS WATCH SERVER CLIENT_PROCESS SERVER_PROCESS LOGON_TIME PROGRAM ADDRESS PORT
-- ------ -------- --------- ---------- ------- --------- ----- --------- -------------- -------------- -------------------------- ------------- ------- ----
21 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2690 2690 2015-03-12 16:24:39.662582 shared server null 0
22 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2692 2692 2015-03-12 16:24:39.670353 shared server null 0
23 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2694 2694 2015-03-12 16:24:39.678869 shared server null 0
24 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2696 2696 2015-03-12 16:24:39.688124 shared server null 0
25 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2698 2698 2015-03-12 16:24:39.693535 shared server null 0
26 1 -1 11 DA 0 CONNECTED ENTER DEDICATED 2700 2700 2015-03-12 16:24:39.701097 shared server null 0

26 rows selected.

gSQL>



Lock상태


gSQL> select * from x$lock_wait;     

no rows selected.

gSQL>



Datafile 상태


gSQL> select * from x$datafile;

TABLESPACE_ID PATH STATE DATAFILE_ID SIZE CREATION_TIME CHECKPOINT_LSN SHM_SEGMENT_ID SHM_STATE
------------- ------------------------------------------------------------- ------- ----------- --------- -------------------------- -------------- -------------- ---------
0 /home/sunje/sundb/sundb_mercury/sundb_data/db/system_dict.dbf CREATED 0 134209536 2015-03-05 20:30:36.132638 1003222 2 PCH_INIT
1 /home/sunje/sundb/sundb_mercury/sundb_data/db/system_undo.dbf CREATED 0 33546240 2015-03-05 20:30:36.879397 1003222 3 PCH_INIT
2 /home/sunje/sundb/sundb_mercury/sundb_data/db/system_data.dbf CREATED 0 209707008 2015-03-05 20:30:37.132600 1003222 4 PCH_INIT
3 system_temp CREATED 0 209707008 2015-03-12 16:24:36.075338 -1 1 PCH_INIT

4 rows selected.

gSQL>



Tablespace List


gSQL> select * from x$tablespace;

NAME ID ATTR LOGGING ONLINE SCAN_ONLINE STATE OFFLINE_STATE PENDING_RELATION_ID EXTSIZE NEW_DATAFILE_ID DATAFILE_COUNT PAGE_SIZE
-------------- -- ------------------------------ ------- ------ ----------- ------- ------------- ------------------- ------- --------------- -------------- ---------
DICTIONARY_TBS 0 MEMORY | PERSISTENT | DICT TRUE TRUE TRUE CREATED null 0 65536 1 1 8192
MEM_UNDO_TBS 1 MEMORY | PERSISTENT | UNDO TRUE TRUE TRUE CREATED null 0 65536 1 1 8192
MEM_DATA_TBS 2 MEMORY | PERSISTENT | DATA TRUE TRUE TRUE CREATED null 4007204487168 262144 1 1 8192
MEM_TEMP_TBS 3 MEMORY | TEMPORARY | TEMPORARY FALSE TRUE TRUE CREATED null 0 262144 1 1 8192

4 rows selected.

gSQL>



Tablespace 용량


gSQL> select count(*) * 262144 from d$tablespace_extent('MEM_DATA_TBS') ;      

COUNT(*) * 262144
-----------------
209190912

1 row selected.

gSQL>



Tablespace 사용된 용량


gSQL> select count(*) * 262144 from d$tablespace_extent('MEM_DATA_TBS') where state = 'U';

COUNT(*) * 262144
-----------------
9699328

1 row selected.

gSQL>



Tablespace Free 용량


gSQL> select count(*) * 262144 from d$tablespace_extent('MEM_DATA_TBS') where state = 'F';

COUNT(*) * 262144
-----------------
199491584

1 row selected.

gSQL>



REDO LOG (Log Stream) 상태


gSQL> select * from x$log_stream;

STATE BLOCK_SIZE FILE_SEQ_NO GROUP_COUNT FLUSH_COUNT FLUSH_TRY_COUNT WAIT_COUNT_BY_BUFFER_FULL WAIT_COUNT_FOR_SYNC BLOCKED_LOGGING_COUNT
------ ---------- ----------- ----------- ----------- --------------- ------------------------- ------------------- ---------------------
ACTIVE 512 1 4 3 3 0 1 0

1 row selected.

gSQL>



REDO LOG (Log Group) 상태


gSQL> select * from x$log_group;

GROUP_ID STATE FILE_SEQ_NO FILE_SIZE PREV_LSN SWITCHING_SBSN MEMBER_COUNT
-------- -------- ----------- --------- -------- -------------- ------------
0 INACTIVE 0 104857600 -1 -1 1
1 CURRENT 1 104857600 583608 -1 1
2 UNUSED -1 104857600 -1 -1 1
3 UNUSED -1 104857600 -1 -1 1

4 rows selected.

gSQL>



SQL STMT 상태


gSQL> select * from X$SQL_SYSTEM_STAT_EXEC_STMT;

STMT_TYPE STMT_TYPE_ID EXECUTE_COUNT
-------------------------------------- ------------ -------------
ALTER SYSTEM { MOUNT | OPEN } DATABASE 20 2
ALTER SYSTEM CHECKPOINT 23 2
ALTER SYSTEM FLUSH LOG 25 2
CREATE SEQUENCE 84 13278
DELETE FROM 96 1948
DROP SEQUENCE 115 13278
INSERT INTO 134 1230683599
SELECT 154 169617508
SELECT .. FOR UPDATE 155 61991978
TRUNCATE TABLE 171 2989
UPDATE 172 79687200

11 rows selected.



Ager 상태


gSQL> select * from x$sm_system_info;

NAME VALUE CATEGORY COMMENTS
------------------------- -------------- -------- --------------------------------------
SYSTEM_LSN 1003228 0 system lsn
RECOVERED_LSN 1003221 0 last recovered lsn
RECOVERED_LPSN 0 0 last recovered lpsn
RECOVERED_TRANS_ID 12579964321819 0 last recovered transaction identifier
RECOVERED_SEGMENT_ID 309237645312 0 last recovered segment identifier
CHECKPOINT_LSN 1003222 0 checkpoint lsn
CHECKPOINT_STATE 0 0 checkpoint state( 0:idle, 1:progress )
SYSTEM_SCN 289922 0 system scn
MIN_TRANS_VIEW_SCN 289922 0 minimum transaction view scn
AGABLE_SCN 289922 0 agable scn
AGABLE_STMT_SCN 289922 0 agable statement scn
AGABLE_VIEW_SCN 289922 0 agable view scn
TRY_STEAL_UNDO_PAGE_COUNT 0 0 try steal undp page count
DATA_STORE_MODE 2 0 data store mode
TRANSACTION_TABLE_SIZE 1024 0 transaction table size
UNDO_RELATION_COUNT 128 0 undo relation count
AGER_ENV_ID 8 0 ager environment identifier
CLEANUP_ENV_ID 2 0 cleanup environment identifier
PAGE_FLUSHER_ENV_ID 6 0 page flusher environment identifier
CHECKPOINTER_ENV_ID 4 0 checkpointer environment identifier

NAME VALUE CATEGORY COMMENTS
----------------------------- ------- -------- --------------------------------------------------
ARCHIVE_LOGGER_ENV_ID 9 0 archive logger environment identifier
STABLE_LSN 1003221 0 stable lsn
PAGE_FLUSHING_TIME 0 0 The time(ms) it takes to flush all dirty pages
TOTAL_FLUSHED_PAGE_COUNT 0 0 total flushed page count
VERSION_CONFLICT_COUNT 0 0 version conflict count
DATA_ACCESS_MODE 2 0 data access mode( 0: read only, 1: read write )
FLUSHED_TBS_ID 2 0 last flushed tablespace
FLUSHED_PAGE_ID 1 0 last flushed page
FLUSHED_PAGE_COUNT 1024 0 flushed page count
PAGE_IO_COUNT 9 0 io count
LOG_FLUSHING_STATE 0 0 log flushing state( 0 : enabled, 1 >= : disabled )
OPEN_PHASE_MEMORY_TOTAL_SIZE 1048664 11 used memory size at open phase
MOUNT_PHASE_MEMORY_TOTAL_SIZE 1048664 11 used memory size at mount phase
LOG_MIRROR_SYNC_STATE 0 0 logmirror sync state( 0 : sync, 1 : blocked )
LOCK_TABLE_SIZE 1024 0 lock table size
LOCK_WAIT_TABLE_SIZE 1025 0 lock wait table size
LOCK_HASH_TABLE_SIZE 65519 0 lock hash table size

37 rows selected.

gSQL>



SEQUENCE 상태


gSQL> select * from X$SEQUENCE;

PHYSICAL_ID START_WITH INCREMENT_BY MAXVALUE MINVALUE CACHE_SIZE NEXT_VALUE CURR_VALUE RESTART_VALUE CYCLE CACHE_COUNT
------------ ---------- ------------ ------------------- -------- ---------- ---------- ---------- ------------- ----- -----------
115964116992 1 1 9223372036854775807 1 20 272 272 272 FALSE 0
120259084288 1 1 9223372036854775807 1 20 25 25 25 FALSE 0
124554051584 1 1 9223372036854775807 1 20 235 235 235 FALSE 0
133143986176 1 1 9223372036854775807 1 20 2746 2746 2746 FALSE 0
137438953472 1 1 9223372036854775807 1 20 1 1 1 FALSE 0
141733920768 1 1 9223372036854775807 1 20 25 25 25 FALSE 0
146028888064 1 1 9223372036854775807 1 20 269 269 269 FALSE 0

7 rows selected.

gSQL>



Property 설정 상태


gSQL> select property_name, value from x$property order by 1;  

PROPERTY_NAME VALUE
--------------------- ------------------------------------
AGING_INTERVAL 10
ARCHIVELOG_DIR /hw05/gliese/db_home/archive_log
ARCHIVELOG_FILE archive
ARCHIVELOG_MODE 0
BLOCK_READ_COUNT 20
CACHE_ALIGNED_SIZE 64
CLIENT_MAX_COUNT 1024
CONTROL_FILE /hw05/gliese/db_home/wal/control.ctl
DATABASE_ACCESS_MODE 1
DATABASE_FILE_IO 0
DATA_STORE_MODE 2
DB_NAME GlieseDB
DDL_LOCK_TIMEOUT 0
DEFAULT_INDEX_LOGGING YES
DEFAULT_INITRANS 4
DEFAULT_MAXTRANS 8
DEFAULT_PCTFREE 10
DEFAULT_PCTUSED 60
DEFAULT_TABLE_LOCKING YES
DEVELOPMENT_OPTION 0

PROPERTY_NAME VALUE
------------------------------------- ------------------------
GENERATE_CORE_DUMP YES
IDLE_TIMEOUT 0
INDEX_BUILD_DIRECTION 1
INDEX_BUILD_PARALLEL_FACTOR 0
INDEX_ROOT_MIRRORING_DEPTH 3
INST_TABLE_FIXED_COL_MAX_LEN 64
INST_TABLE_FIXED_ROW_MAX_LEN 1000
INST_TABLE_INDEX_NODE_COUNT_PER_BLOCK 64
INST_TABLE_INST_MEM_MAX 4
INST_TABLE_MAX_KEY_LEN_FOR_LSD_RADIX 20
INST_TABLE_SORT_METHOD 1
INST_TABLE_SORT_RUN_COUNT 32
INST_TABLE_VAR_COL_PIECE_MIN_LEN 32
LOCK_HASH_TABLE_SIZE 65519
LOG_BLOCK_SIZE 512
LOG_BUFFER_SIZE 524288000
LOG_DIR /hw05/gliese/db_home/wal
LOG_FILE_IO 0
LOG_FILE_SIZE 1073741824
LOG_GROUP_COUNT 8

PROPERTY_NAME VALUE
----------------------------- -----------------------
LOG_SYNC_INTERVAL 3
MAXIMUM_CONCURRENT_ACTIVITIES 2048
MAXIMUM_FLUSH_LOG_BLOCK_COUNT 100000
MAXIMUM_FLUSH_PAGE_COUNT 1024
MEMORY_MERGE_RUN_COUNT 32
MEMORY_SORT_RUN_SIZE 8192
MINIMUM_UNDO_PAGE_COUNT 16
NET_BUFFER_SIZE 32768
PARALLEL_IO_FACTOR 1
PARALLEL_IO_GROUP_1 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_10 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_11 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_12 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_13 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_14 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_15 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_16 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_2 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_3 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_4 /hw05/gliese/db_home/db

PROPERTY_NAME VALUE
-------------------------- -----------------------
PARALLEL_IO_GROUP_5 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_6 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_7 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_8 /hw05/gliese/db_home/db
PARALLEL_IO_GROUP_9 /hw05/gliese/db_home/db
PARALLEL_LOAD_FACTOR 1
PENDING_LOG_BUFFER_COUNT 4
PORT_NO 29323
PRIVATE_STATIC_AREA_SIZE 104857600
PROCESS_MAX_COUNT 1024
QUERY_TIMEOUT 0
REFINE_RELATION YES
SESSION_DATE_FORMAT YYYY-MM-DD
SESSION_PROPAGATE_REDO_LOG YES
SESSION_TIME_ZONE 32400
SHARED_MEMORY_ADDRESS 1610612736
SHARED_MEMORY_STATIC_KEY 542353
SHARED_MEMORY_STATIC_NAME _STATIC
SHARED_MEMORY_STATIC_SIZE 1572864000
SHOW_CALLSTACK NO

PROPERTY_NAME VALUE
---------------------------------- ------------------------
SPIN_COUNT 1000
SUPPLEMENTAL_LOG_DATA_PRIMARY_KEY NO
SYSTEM_LOGGER_DIR /hw05/gliese/db_home/trc
SYSTEM_MEMORY_DATA_TABLESPACE_SIZE 3221225472
SYSTEM_MEMORY_DICT_TABLESPACE_SIZE 134217728
SYSTEM_MEMORY_TEMP_TABLESPACE_SIZE 2147483648
SYSTEM_MEMORY_UNDO_TABLESPACE_SIZE 2147483648
SYSTEM_TABLESPACE_DIR /hw05/gliese/db_home/db
TIMER_INTERVAL 10
TRACE_DDL NO
TRANSACTION_COMMIT_WRITE_MODE 0
TRANSACTION_TABLE_SIZE 1024
UNDO_RELATION_COUNT 128
USER_MEMORY_DATA_TABLESPACE_SIZE 33554432
USER_MEMORY_TEMP_TABLESPACE_SIZE 33554432
USE_INSERTABLE_PAGE_HINT YES
USE_LARGE_PAGES NO

97 rows selected.

gSQL>



Trace Log 상태


[sunje@symphony ~]$ cat $SUNDB_DATA/trc/system.trc

[2014-06-30 23:32:35.525361 THREAD(3617,140294835951360)] [FATAL]
[SESSION INFORMATION]
---- Process env id : 24
---- Session id : 18
---- Program :
---- Latest SQL text: N/A

[2014-06-30 23:32:35.525417 THREAD(3617,140294835951360)] [FATAL]
[SQL PROCESSOR INFORMATION]
---- executed SQL phrase information
---- function call information
---- CALL_COUNT(PARSE) : 0
---- CALL_COUNT(VALIDATE) : 0
---- CALL_COUNT(OPTIMIZE) : 0
---- CALL_COUNT(EXECUTE) : 0
---- CALL_COUNT(FETCH) : 0
---- CALL_COUNT(RECOMPILE) : 0

[2014-06-30 23:32:35.525446 THREAD(3617,140294835951360)] [FATAL]
[EXECUTION LIBRARY INFORMATION]
---- AUTHORIZATION_ID(0)

[2014-06-30 23:32:35.536023 THREAD(3617,140294835951360)] [FATAL]
[SESSION FATAL] ENV(24), SESSION(18), THREAD(3617,140294835951360), CAUSE("SIGNAL(11) recieved")
=================================================
CALL STACK [Release 2012.2.1.0 revision(9156)]
=================================================
gsql(stlPushFatalErrorCallstack+0xcf)[0x74d58f]
gsql(kniFatalHandler+0x76)[0x6e5306]
gsql(qlgFatalHandler+0x5a)[0x511c7a]
gsql(ssgFatalHandler+0x62)[0x50cfe2]
gsql(steFatalHandler+0x41)[0x751161]
/lib64/libpthread.so.0[0x3259a0f500]
gsql(eldcFindHashElement+0x27)[0x6275d7]
gsql(eldcGetAuthHandleByID+0x62)[0x616892]
gsql(ellGetAuthDictHandleByID+0x47)[0x5f16b7]
gsql(qllLogin+0xa5)[0x510ad5]
gsql(sscAuthenticateUser+0x9)[0x50bd99]
gsql(sslConnect+0x1e2)[0x5064d2]
gsql(zlacConnect+0x2da)[0x4dacaa]
gsql(SQLConnect+0x1a1)[0x4bc7f1]
gsql(ztqSQLConnect+0x5a)[0x4a8d5a]
gsql(ztqOpenDatabase+0x126)[0x4a0386]
gsql(main+0x219)[0x4ab169]
/lib64/libc.so.6(__libc_start_main+0xfd)[0x3258e1ecdd]
gsql[0x49eb39]

[2014-06-30 23:32:35.542341 THREAD(3051,140326178125568)] [INFORMATION]
[AGER] cleaning session - env(24), session(18), transaction(FFFFFFFFFFFFFFFF), pid(3617), thread(140294835951360)
[2014-06-30 23:32:35.542503 THREAD(3051,140326178125568)] [INFORMATION]
[AGER] cleaning up 1 sessions