Overview

There are cases where an error message in the following form can be found in the tracelog or slog log of the Tibero engine.

This guide explains how to identify which object is related to this.

ERROR_CACHE_BLOCK_DBA_ERROR [ Unable to read afferent DBA block: file# 33776968, block# 16 ]

If the object is an index, the error can be resolved by rebuilding or recreating it.

Method

Using the file# and block# values identified in the error message, you can query the object containing the block with the following query.

select *
from dba_extents
where file_id=<file#> and <block#> between block_id and (block_id + blocks -1);

Enter the file# and block# values as they appear in the error message.

Note
The file# and block# values in the error message correspond to the FILE_ID and BLOCK_ID values in the DBA_EXTENTS view.

Related to