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.
NoteThe 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)
CautionApply the patch through technical support provided by Tmax Tibero.