Skip to main content

Search

Welcome to Tibero GTS!

TBR-20010: Error -15115 in processing error during statistics collection

Document Type | Troubleshooting

Category | Administration

Applicable Product Version | 6FS06

Error Codes | 15115, 20010

Document Number | TADTS027

 

Issue

This phenomenon occurs as TBR-20010: Error -15115 in processing during statistics collection of a specific table.
Below is an excerpt from the sys.log.
SQL> exec DBMS_STATS.GATHER_TABLE_STATS(OwnName=>'OWNER',TabName=>'TABLE_NAME',ESTIMATE_PERCENT=>10,Method_Opt=>'FOR ALL COLUMNS SIZE 255',No_Invalidate=>FALSE,degree=>4);
TBR-20010: Error -15115 in processing 'OWNER'.'TABLE_NAME' ..
TBR-15163: Unhandled exception at SYS.DBMS_STATS,  line 127.
TBR-15163: Unhandled exception at SYS.DBMS_STATS,  line 4146.
TBR-15163: Unhandled exception at SYS.DBMS_STATS,  line 4199.
TBR-15163: Unhandled exception at  line 1.

 

Cause

During column statistics collection, there is a query inside Build_histogram that retrieves column information.
The issue occurred because this query sometimes retrieves information exceeding the PSM varchar max size of 32,767 characters.
 
 

Solutions

1. Apply the patch. (Patch applied: FS06_315747a)
  • FS06_315747a patch details: When retrieving column information, it is adjusted to retrieve only up to 32,767 characters.

Caution

Apply the patch through technical support provided by Tmax Tibero.
2. Set a temporary workaround to resolve the error.
  • Temporary workaround: Check max(length(column_name)) and if the length of the column value exceeds 32,767 characters, modify the value.
 
 
 

Related to