[Tibero] Tibero 운영 가이드 for beginner (11)

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/slog File : 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) 로 돌아가기

​