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

☞ “[Tibero] Tibero 운영 가이드 for beginner (1)”로 돌아가기