Skip to main content

Search

Welcome to Tibero GTS!

Issue of session termination when executing user password expire (Error 12001)

Document Type | Troubleshooting

Category | Administration

Applicable Product Version | 7FS02

Document Number | TADTS018

 

Issue 

When executing the create user ~ password expire statement in tbsql, the interactive utility provided by Tibero for processing SQL statements, the message โ€˜TBR-12001: Session has been closedโ€™ appears and the session is terminated.
 
  • Execution process: create user - password expire - enter new password - session closed
-- TEST Scenario 1 (Executed with create user statement)

SQL> create user test02 identified by 'test02' password expire; User 'TEST02' created. 

SQL> grant create session to test02; Granted. 


SQL> conn test02/test02 


TBR-17002: Password has expired. 


Enter new password: 


Confirm new password: 


TBR-12001: Session has been closed. No longer connected to server. 
-- TEST Scenario 2 (Executed with alter user statement)

SQL> create user test03 identified by 'test03'; User 'TEST02' created. 

SQL> alter user test03 password expire; 


SQL> grant create session to test03; 


Granted. 


SQL> conn test03/test03 


TBR-17002: Password has expired. 


Enter new password: 


Confirm new password: 


TBR-12001: Session has been closed. No longer connected to server.
Note
The same error occurs when executing the alter user ~ password expire statement.
(Segmentation Fault (SIGSEGV) occurs after entering the new password)
 
 

Cause

Inside the logic, when searching user information, it refers to the dd csr during the dd search process, but since this value is NULL, a SIGSEGV error occurs. 
 
 
 

Solutions

Apply the patch to resolve the issue. (Applied patch: FS02_279897a)
Caution
Apply the patch through technical support provided by Tmax Tibero. 
 
 
 
 
 
 

 

Related to