Overview

This document contains information on how users new to Tibero can check the causes of error codes and take action through commands. For detailed information on functions, please refer to the manual.

Method

Error Check

1) TBR-<number> Error Code

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.;
 */

2) BUG - Internal Error

If the TBR-2131 / JDBC-90603 error code is detected on the Client side, check the Tibero Server Log to see if there are error logs occurring at the same time. If server error logs occurring simultaneously are found, it is highly likely a Tibero Bug.

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/tibero7/instance/tac1> ls -tlr
drwxr-xr-x. 2 tibero dba   4096 Oct 10 09:53 audit
drwxr-xr-x. 5 tibero dba   4096 Oct 24 09:20 dump
-rw-------. 1 tibero dba      0 Oct 27 09:14 lsnr.out.3314
drwxr-xr-x. 2 tibero dba   4096 Oct 27 09:14 path
drwxr-xr-x. 8 tibero dba   4096 Oct 28 00:33 log
-rw-------. 1 tibero dba   5374 Oct 28 00:33 tbsvr.callstack.3316
-rw-------. 1 tibero dba    863 Oct 28 00:33 tbsvr.out.3313

tibero@edu1[tac1]:/home/tibero/tibero7/instance/tac1> cat tbsvr.out.3313
[118] 2025/10/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 : [2025/10/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] *** 2025/10/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/tibero7/instance/tac1> cat tbsvr.callstack.3316

[118] *** 2025/10/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

Log Collection

To analyze the cause of the problem, $TB_HOME/instance and below log information are required.

Example

tibero@edu1[tac1]:/home/tibero> cd $TB_HOME/instance
tibero@edu1[tac1]:/home/tibero/tibero7/instance> ls -tlr
total 12
drwxr-xr-x. 3 tibero dba 4096 Oct 12 17:51 cm1
drwxr-xr-x. 6 tibero dba 4096 Oct 27 09:14 tas1
drwxr-xr-x. 6 tibero dba 4096 Oct 28 00:33 tac1
tibero@edu1[tac1]:/home/tibero/tibero7/instance>

tibero@edu1[tac1]:/home/tibero/tibero7/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/tibero7/instance> ls -tlr
total 19896
drwxr-xr-x. 3 tibero dba     4096 Oct 12 17:51 cm1
drwxr-xr-x. 6 tibero dba     4096 Oct 27 09:14 tas1
drwxr-xr-x. 6 tibero dba     4096 Oct 28 00:33 tac1
-rw-r--r--. 1 tibero dba 20359175 Oct 28 23:26 instance.tar.gz