После апгрейда с 3.0.4 на 3.2 все ODBC-проверки (Oracle) стали возвращать такое:
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_UNDOTBS,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_INDEXES,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_MAIL_ATTACH,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TOOLS,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_TRN,{$DSN1}]" became not supported: Received value [x?Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_TRN_I,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_LOB,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
Вместо числового значения ??Y5 или другая похожая ерунда.
Item-ы проверялись как zabbix-server-ом, так и zabbix-proxy. При откате на 3.0.4 проверки снова возвращают нормальные значения.
Zabbix стоит на RHEL7, прокси на RH7 и RH6. ODBC системный, драйвер Oracle от официального instantclient.
При запросе через isql значения возвращаются нормально.
Куда копать, есть идеи?
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_UNDOTBS,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_INDEXES,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_MAIL_ATTACH,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TOOLS,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_TRN,{$DSN1}]" became not supported: Received value [x?Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_TRN_I,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
10079:20160915:110310.666 item "database01:db.odbc.select[tbs_freesize_TS_LOB,{$DSN1}]" became not supported: Received value [??Y5] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
Вместо числового значения ??Y5 или другая похожая ерунда.
Item-ы проверялись как zabbix-server-ом, так и zabbix-proxy. При откате на 3.0.4 проверки снова возвращают нормальные значения.
Zabbix стоит на RHEL7, прокси на RH7 и RH6. ODBC системный, драйвер Oracle от официального instantclient.
При запросе через isql значения возвращаются нормально.
Куда копать, есть идеи?
Comment