[ZBX-15612] Zabbix dbconfig ERROR [file:dbconfig.c,line:9730] Created: 2019 Feb 07  Updated: 2024 Apr 10  Resolved: 2019 Feb 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 4.0.3
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Andrzej Assignee: Vladislavs Sokurenko
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Team: Team A
Sprint: Sprint 49 (Feb 2019)
Story Points: 0.25

 Description   

Hi

I have a problem after upgrade Zabbix ver. 3.2.3 to 4.0.3.

Compilation and Upgrade without errors.

Zabbix server and prox start and work.

I have 270GB database Oracle.

Something impossible has just happened <- What happend?

Sample Code on the proxy:
zabbix_proxy [12851]: ERROR file:dbconfig.c,line:9730 Something impossible has just happened.
12851:20190205:073140.771 === Backtrace: ===
12851:20190205:073140.772 11: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](zbx_backtrace+0x2b) [0x48793b]
12851:20190205:073140.772 10: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values]() [0x4681cc]
12851:20190205:073140.772 9: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](DCget_item_count+0x19) [0x471b69]
12851:20190205:073140.772 8: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](get_value_internal+0xa7) [0x42b787]
12851:20190205:073140.772 7: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values]() [0x42b428]
12851:20190205:073140.772 6: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](poller_thread+0xd5) [0x42b565]
12851:20190205:073140.772 5: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](zbx_thread_start+0x3e) [0x4885ee]
12851:20190205:073140.772 4: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](MAIN_ZABBIX_ENTRY+0x649) [0x41e859]
12851:20190205:073140.772 3: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](daemon_start+0x1a5) [0x487455]
12851:20190205:073140.772 2: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values](main+0x506) [0x41d966]
12851:20190205:073140.772 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f9df16dbb15]
12851:20190205:073140.772 0: ./zabbix_proxy: poller #1 [got 0 values in 0.000015 sec, getting values]() [0x41de41]

 Comments   
Comment by Vladislavs Sokurenko [ 2019 Feb 07 ]

Could you please show output of following query ?

select status from items where status not in (0,1);
Comment by Andrzej [ 2019 Feb 07 ]

The query returned 271 lines in the number 3

Comment by Vladislavs Sokurenko [ 2019 Feb 07 ]

Where do those items come from ? It's invalid status

Comment by Andrzej [ 2019 Feb 07 ]

This item from my Zabbix database.

Database have 270GB. I have 90k items and 3k host. 790 vps.

How do I find the ID of these incorrect items?

How to check the condition of the database after upgrade?

Thank you for the quick reply.

Comment by Vladislavs Sokurenko [ 2019 Feb 08 ]

You can try:

select itemid,status from items where status not in (0,1);
Comment by Andrzej [ 2019 Feb 08 ]

Oki. I have all Items with status 3 (name, itemid, hostid, key) use API Zabbix.

Example for one host.

Items 88 => Enabled 63 (Status =>0)
=> Disabled 12 (Status =>1)
=> ??? 13 (Status =>3) on the Dashboard this items are Disabled. (filter status = all).

In Dashboard I see all items if filter status is all and only 12 items if filter is Disabled.

Database Oracle is this same on ver. Zabbix 2.4 - up to Zabbix 3.2 - up to Zabbix 4.0.3

Item have various key on other host with status 3.

Maybe it's enough to change (update on the database) the status Item in 3 to 1.

I do not know where in the database the status was 3.

Item and host add only by dashboard.

Comment by Vladislavs Sokurenko [ 2019 Feb 08 ]

Surely you can simply change:

update items set status=0 where status=3;

It's hard to say why they have such status if created via frontend, can you reproduce the issue ?

Some long time ago there was such status in database that indicated unsupported items but it was version 2.0 did you use 2.0 ?

Comment by Andrzej [ 2019 Feb 08 ]

In our company we started with zabbix ver. 1.8 and all time we upgrade Zabbix.

thx for help.

Comment by Vladislavs Sokurenko [ 2019 Feb 08 ]

Thanks ! Closed as Won't Fix, currently it's unclear why they are in unsupported state, I could guess that it's related to ZBX-15593. Feel free to reopen if issue happens again on newer version.

Generated at Fri Apr 26 15:34:25 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.