6. Trouble Shooting
6.1. Error Check
6.1.1. TBR- Error Code
명령어를 통해 코드의 원인 및 오류 사항 조치 방법 등을 안내합니다.
| Command |
| $ tberr <code number> |
Example
tibero@edu1[tac1]:/home/tibero> tberr 5074
/*
* err: -5074
* name: ERROR_NUMBER_INVALID_NUMBER
* desc: Given string does not represent a number in proper format.
* cause: The given string does not represent a proper number.
* action: Check the type of string.;
*/
6.1.2. BUG – Internal Error
Client에서 TBR-2131 / JDBC-90603 에러코드가 확인되면 Tibero Server Log에서도 동시간 발생한 에러로그가 있는지 확인합니다.
만약 동시간 발생한 서버 에러 로그가 확인된다면 Tibero Bug일 가능성이 높습니다.
| Step | Command |
| Client Side : Error Code | • TBR-2131: Generic I/O error• JDBC-90603:Invalid operation_disconnected from the server. |
| Server Side : Files | Location : cd $TB_HOME/instance/$TB_SID/File : tbsvr.out. <pid>tbsvr.callstack.<pid>Location : cd $TB_HOME/instance/$TB_SID/log/slogFile : sys.log |
| Server Log Error Patterns | • Internal Error with condition …• Signal 11 (SIGSEGV) caught … |
Example
# Client Side
SQL> select distinct c1 from T1
where 1=1
and c1 not in (select c1 from T1)
and c2 in (’01’)
and c1 in (select c3 from T2 where c4 = ‘6’);
TBR-2131: Generic I/O error.
# Server Side
tibero@edu1[tac1]:/home/tibero/tibero6/instance/tac1> ls -tlr
drwxr-xr-x. 2 tibero dba 4096 Dec 10 09:53 audit
drwxr-xr-x. 5 tibero dba 4096 Dec 24 09:20 dump
-rw——-. 1 tibero dba 0 Dec 27 09:14 lsnr.out.3314
drwxr-xr-x. 2 tibero dba 4096 Dec 27 09:14 path
drwxr-xr-x. 8 tibero dba 4096 Dec 28 00:33 log
-rw——-. 1 tibero dba 5374 Dec 28 00:33 tbsvr.callstack.3316
-rw——-. 1 tibero dba 863 Dec 28 00:33 tbsvr.out.3313
tibero@edu1[tac1]:/home/tibero/tibero6/instance/tac1> cat tbsvr.out.3313
[118] 2018/12/28 00:33:26.909 Internal Error with condition ‘semi->join_type ==
JOIN_SEMI’ (join_elim.c:818) (pid=3316, sessid=118, tid=118, os_thr_id=3423)
[118] client : ip [192.168.56.101] process [tbsql] logon time : [2018/12/28 00:32:38]
[118] prev sql : “select distinct c1 from T1
where 1=1
and c1 not in (select c1 from T1)
and c2 in (’01’)
and c1 in (select c3 from T2 where c4 = ‘6’)”
[118] current sql : “select distinct c1 from T1
where 1=1
and c1 not in (select c1 from T1)
and c2 in (’01’)
and c1 in (select c3 from T2 where c4 = ‘6’)”
[118] *** 2018/12/28 00:33:26.911 ***
[118] callstack dump from tbsvr_FGWP000 for [WTHR, 118, 3423/3316]
[118] SEE DUMP tbsvr.callstack.3316 (lwpid 3423) BY PSTACK
tibero@edu1[tac1]:/home/tibero/tibero6/instance/tac1> cat tbsvr.callstack.3316
[118] *** 2018/12/28 00:33:26.921 ***
CALL STACK DUMP BY PSTACK (from 118:3423)
Thread 11 (Thread 0x7f1877cc4700 (LWP 3423)):
#0 0x0000003aa82acc4d in nanosleep () from /lib64/libc.so.6
#1 0x0000003aa82acac0 in sleep () from /lib64/libc.so.6
#2 0x0000000000dc90a5 in callstack_dump_internal ()
#3 0x0000000000dc9559 in callstack_dump_ex ()
#4 0x0000000000dc7959 in tb_tracedump ()
#5 0x0000000000dc80f7 in tb_assert_msg ()
#6 0x0000000001a73b4a in try_eliminate_child ()
#7 0x0000000001a75112 in trans_rule_join_elimination ()
#8 0x0000000001a5eb18 in lpn_iter__internal ()
#9 0x0000000001a6d139 in trans_apply_rule_new ()
#10 0x0000000001a69540 in transform ()
#11 0x0000000001258ecb in dml_frame_parse ()
#12 0x00000000005bda4b in tbsvr_sql_try_dml ()
#13 0x00000000005b64c8 in sql_hardparsing ()
#14 0x00000000005ba523 in tbsvr_sql_process ()
#15 0x00000000005acd35 in tbsvr_msg_sql_common ()
#16 0x000000000057c06f in tbsvr_handle_msg_internal ()
#17 0x000000000057f35f in tbsvr_wthr_request_from_cl_conn ()
#18 0x000000000058a03a in thread_main_chk_bitmask ()
#19 0x000000000059bf18 in svr_wthr_main_internal ()
#20 0x0000000000daab70 in wthr_init ()
#21 0x0000003aa8607aa1 in start_thread () from /lib64/libpthread.so.0
#22 0x0000003aa82e8bcd in clone () from /lib64/libc.so.6
6.2. Log Collection
$TB_HOME/instance 이하 Log 정보들을 문제 발생 시 원인분석에 사용합니다.
| Step | Command |
| Location | $ cd $TB_HOME/instance |
| Compression | $ tar -cvzf instance.tar.gz * |
| Report | 엔지니어에게 로그 전달 |
Example
tibero@edu1[tac1]:/home/tibero> cd $TB_HOME/instance
tibero@edu1[tac1]:/home/tibero/tibero6/instance> ls -tlr
total 12
drwxr-xr-x. 3 tibero dba 4096 Dec 12 17:51 cm1
drwxr-xr-x. 6 tibero dba 4096 Dec 27 09:14 tas1
drwxr-xr-x. 6 tibero dba 4096 Dec 28 00:33 tac1
tibero@edu1[tac1]:/home/tibero/tibero6/instance>
tibero@edu1[tac1]:/home/tibero/tibero6/instance> tar -cvzf instance.tar.gz *
cm1/
cm1/log/
cm1/log/trace_cm.log
cm1/log/out/ cm1/log/out/cm.out.2596
…
tibero@edu1[tac1]:/home/tibero/tibero6/instance> ls -tlr
total 19896
drwxr-xr-x. 3 tibero dba 4096 Dec 12 17:51 cm1
drwxr-xr-x. 6 tibero dba 4096 Dec 27 09:14 tas1
drwxr-xr-x. 6 tibero dba 4096 Dec 28 00:33 tac1
-rw-r–r–. 1 tibero dba 20359175 Dec 28 23:26 instance.tar.gz
