Skip to main content
๐Ÿ““ Tibero Online Manual Click here ๐Ÿ““

Search

Welcome to Tibero GTS!

Control File Related Errors When Starting DB

Document Type | Troubleshooting 

Category | Monitoring/Inspection

Applicable Product Versions | 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS

Error Codes | 24001, 24003, 24004, 24006

Document Number | TMOTS016

 

Issue

The following are the symptoms of control file related errors occurring when starting the DB.
 

ERROR_TCCF_OPEN_FAILED(-24001) Error Symptoms

[2024-02-05T16:20:57.224968] [CLC-107] [I] CF open failed : '/dev/raw/raw1' (Permission denied)

[2024-02-05T16:20:57.224974] [CLC-107] [I] CF open retry: 0/1 opened, 0 retried

[2024-02-05T16:20:57.235057] [CFD-107] [I] open (stat) failed (errno=13, Permission denied) (flag=010002) (filename=/dev/raw/raw1)

[2024-02-05T16:20:57.235105] [FRM-107] [I] THROW. ec=ERROR_TCCF_OPEN_FAILED(-24001) [ Unable to open control file.] (csr_id:4294967295) [cf.c:260:cf_open]

[2024-02-05T16:20:57.235128] [FRM-107] [I]

********************************************************

* Critical Warning : Raise svmode failed. The reason is

*   TBR-24001 :  Unable to open control file.

*   Current server mode is NOMOUNT.

********************************************************

 

ERROR_TCCF_READ_FAILED(-24003) Error Symptoms

[2025-03-16T12:37:38.710990] [FRM-1075] [I] THROW. ec=ERROR_CACHE_FILE_READ_FAILED(-1004) [ Unable to read file .   ] (csr_id:3763) [tc_blkio.c:358:read_dev]

[2025-03-16T12:37:38.772764] [FRM-1036] [I] THROW. ec=ERROR_CACHE_FILE_READ_FAILED(-1004) [ Unable to read file .   ] (csr_id:12575) [tc_blkio.c:358:read_dev]

[2025-03-16T12:37:38.817994] [FRM-1052] [I] THROW. ec=ERROR_CACHE_FILE_READ_FAILED(-1004) [ Unable to read file .   ] (csr_id:10215) [tc_blkio.c:358:read_dev]

[2025-03-16T12:37:38.843079] [CLC-137] [I] control file read failed : '/tibero_data01/PDKC2HMA/control/c1.ctl' (blkno=1) (Input/output error)

[2025-03-16T12:37:38.844347] [CLC-137] [I] control file read failed : '/tibero_data01/PDKC2HMA/control/c2.ctl' (blkno=1) (Input/output error)

[2025-03-16T12:37:38.851249] [FRM-1044] [I] THROW. ec=ERROR_CACHE_FILE_READ_FAILED(-1004) [ Unable to read file .   ] (csr_id:8889) [tc_blkio.c:358:read_dev]

[2025-03-16T12:37:38.865331] [FRM-137] [I] THROW. ec=ERROR_TCCF_READ_FAILED(-24003) [ Unable to read control file.   ] (csr_id:4294967295) [cf.c:355:read_cfblk]

[2025-03-16T12:37:38.872163] [COM-137] [I] Internal Error with condition '!"error"' (tc.c:344) (pid=10627, sessid=137, tid=137, os_thr_id=10697)

 

ERROR_TCCF_WRITE_FAILED(-24004) Error Symptoms

[05-25T12:24:09.612000] [FRM-41] [W] [aio_write] WriteFileEx failed(length=16384, offset=16384, err=21)

[05-25T12:24:09.612000] [CLC-41] [I] control file write failed: 'F:\tbdata\c1.ctl'

[05-25T12:24:09.612000] [FRM-41] [I] THROW. ec=ERROR_TCCF_WRITE_FAILED(-24004) [ Unable to write to control file.   ] (csr_id:4294967295) [cf.c:458:cf_write_blk]

 

ERROR_TCCF_LOAD_FAILED(-24006) Error Symptoms

[05-25T17:43:48.709000] [FRM-00] [I] MONP(tbsvr) is ready : tid(0), ospid(1576)

[05-25T17:43:48.711000] [FRM-29] [I] SEQ: CUR_SVRMOD[2]

[05-25T17:43:48.713000] [CLC-65] [I] RV slave 0 received LOCK_MGMT job

[05-25T17:43:48.716000] [FRM-31] [I] NTFC: CUR_SVRMOD[2]

[05-25T17:43:48.718000] [NTF-31] [I] ntf_coord is ready.

[05-25T17:43:48.719000] [NTF-32] [I] ntf_sender is ready.

[05-25T17:43:48.727000] [FRM-35] [I] resource manager thread initialized

[05-25T17:43:49.137000] [RVP-28] [I] RV master received RAISE_SVRMODE request

[05-25T17:43:49.137000] [CLC-66] [I] RV slave 1 received RAISE_SVRMODE job

[05-25T17:43:49.138000] [RV-66] [I] HDR: block size mismatch: 0 (cf block size: 16384)

[05-25T17:43:49.138000] [FRM-66] [I] THROW. ec=ERROR_TCCF_LOAD_FAILED(-24006) [ Unable to load controlfile controlfile block size mismatch.   ] (csr_id:4294967295) [cf.c:2168:cf_load]

[05-25T17:43:49.138000] [FRM-66] [I]

********************************************************

* Critical Warning : Raise svmode failed. The reason is

*   TBR-24006 :  Unable to load controlfile controlfile block size mismatch.  

*   Current server mode is NOMOUNT.

********************************************************

 

Cause

The causes for each of the above error codes are as follows.
  • ERROR_TCCF_OPEN_FAILED(-24001): This error code occurs due to permission issues on the directory or control file.
  • ERROR_TCCF_READ_FAILED(-24003): This error code occurs when there is a problem with the volume where the control file is located, preventing the file from being read. Such errors can cause the DB to shut down voluntarily due to a fatal error triggered by failure to read the control file.
  • ERROR_TCCF_WRITE_FAILED(-24004): This error code occurs when the control file is corrupted after an OS forced shutdown and Tibero is restarted.
  • ERROR_TCCF_LOAD_FAILED(-24006): This error code occurs when the control file is corrupted after the volume has been unmounted and then remounted, followed by a Tibero restart.
 
 

Solutions

1. Grant permissions to the relevant path or control file.

chmod 644 or chown tibero:dba

2. Verify directory creation and path mounting.

3. For raw devices, check the control file path set in the Tip.

4. If the control file is corrupted, it needs to be recreated.

5. Check for any issues with the disk and volume, and review the OS logs.

 
 
 

Related to