---
title: 租户查询触发器报错 Incorrect value-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于 租户查询触发器报错 Incorrect value相关的常见问题和使用技巧，帮助您快速解决 租户查询触发器报错 Incorrect value的难题。
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

划线反馈

# 租户查询触发器报错 Incorrect value

更新时间：2026-03-03 03:46

适用版本： V4.0.x、V4.1.x、V4.2.x、V4.3.x 内容类型：Troubleshoot  

## 问题现象

在通过 `show trigeers like '%触发器名称%'` 查询触发器时出现报错如下：

![undefined](https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/doc/img/knowledge-base/database/sql-1/dml/sellect/tenant-query-trigger-error-incorrect-value/11.png)

查看 observer 日志，发现存在如下报错信息，关注 `errcode=-5167，char type length is too long(max_accuracy_len=64, trunc_len_char=65)`

```shell
[2025-08-18 18:22:29.015023] WDIAG [SQL] string_length_check (ob_datum_cast.cpp:11940) [1474206][T1206_L0_G0][T1206][YB42C0A8B43C-00063B9F705EB986-0-0] [lt=13][errcode=-5167] char type length is too long(max_accuracy_len=64, trunc_len_char=65)

[2025-08-18 18:22:29.015071] WDIAG [STORAGE] get_next_row (ob_multiple_merge.cpp:358) [1474206][T1206_L0_G0][T1206][YB42C0A8B43C-00063B9F705EB986-0-0] [lt=2][errcode=-5222] get row from fuse failed(ret=-5222, unprojected_row_={row_flag:{flag:"INSERT", flag_type:0}, trans_id:{txid:0}, scan_index:0, mvcc_row_flag:{first:0, uncommitted:0, shadow:0, compact:0, ghost:0, last:0, reserved:0, flag:0}, snapshot_version:0, fast_filter_skipped:false, have_uncommited_row:false, group_idx:0, count:5, datum_buffer:{capacity:32, datums:0x7f05e7f62810, local_datums:0x7f05e7f62810}, datums:[col_id=0:{len: 8, flag: 0, null: 0, ptr: 0x7f05e7f62820, hex: 0000000000000000, int: 0},col_id=1:{len: 8, flag: 0, null: 0, ptr: 0x7f05e7f62858, hex: F735080000000000, int: 538103},col_id=2:{len: 8, flag: 0, null: 0, ptr: 0x7f05e7f62890, hex: 0000000000000000, int: 0},col_id=3:{len: 65, flag: 0, null: 0, ptr: 0x7f0dab99c70b, hex: 5F5F6964785F3533383130305F6964785F745F706F696E745F616363745F62616C616E63655F736F757263655F6566666563746976655F626567696E5F74696D65, cstr: __idx_538100_idx_t_point_acct_balance_source_effective_begin_time},col_id=4:{len: 8, flag: 0, null: 0, ptr: 0x7f05e7f62900, hex: 0000000000000000, int: 0},]})

```

## 问题原因

OceanBase 在创建索引时，索引名会加上 OceanBase 自带的前缀，导致索引名超过 64 字节的限制，因此在 `show trigger where/like` 时会报错 Incorrect value。

## 适用版本

OceanBase 数据库 V4.x 版本。

## 解决方法及规避方式

查看日志，找到日志中打印的日志中存在长度超限的索引名，例如 `__idx_538100_idx_t_point_acct_balance_source_effective_begin_time`。

查看索引信息和判断是否有其他名称超长的索引，修改索引名到正常长度。

```shell
obclient> select * from CDB_OB_TABLE_LOCATIONS where table_name='__idx_538100_idx_t_point_acct_balance_source_effective_begin_time';

obclient> select length('__idx_538100_idx_t_point_acct_balance_source_effective_begin_time');

obclient> select length(table_name) from CDB_OB_TABLE_LOCATIONS where TABLE_TYPE='index'

```

上一篇

[OceanBase 不支持 SELECT ... FOR UPDATE 的 SKIP LOCKED 子句的解决方法](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000000186)

下一篇

[带有 case when 的查询语句执行报错 -4016 的原因和解决方法](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000001925113) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线