[ZBX-4165] Sqlite database insert failures Created: 2011 Sep 22 Updated: 2017 May 30 Resolved: 2011 Sep 29 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Proxy (P) |
Affects Version/s: | 1.9.6 (beta) |
Fix Version/s: | 1.9.7 (beta) |
Type: | Incident report | Priority: | Blocker |
Reporter: | Corey Shaw | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | proxy, sqlite | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
RHEL5 x64 |
Description |
I'm running Zabbix 1.9.6 (compiled on my own) on RHEL5. My setup is that I have a main Zabbix server (16 CPU, 64GB RAM) that runs just fine. Along with that I have an active Zabbix proxy server (2CPU, 6GB RAM) that is having issues with its SQLite3 database. I have a discovery rule for the proxy that is having issues inserting data into the SQLite database. Every time the proxy tries to write to the database the following error shows up in the logs: [Z3005] query failed: [0] proxy_dhistory.dcheckid may not be NULL [insert into proxy_dhistory (clock,druleid,type,ip,dns,status) values (1316636599,2,-1,'ip.add.xxx.xxx','server.fqdn.com',1)] I have tried recompiling to account for any oddities that could've showed up, but it didn't make any difference. Now here's the real kicker: I have this exact same setup in another environment. That other environment works great without any problems. In fact, the scripts I use to do all the compilation/configuring/install were used in both environments. I have compared the configuration in the non-working environment to the working environment and both are identical (with the exception of server names of course). I have already verified that permissions on the file system were correct for the zabbix user to be able to write to the database. Everything checks out there. |
Comments |
Comment by Corey Shaw [ 2011 Sep 22 ] |
I forgot to mention that the proxy has not been upgraded (it is a clean install) and the schema for the sqlite database is the latest as created by the proxy itself. |
Comment by Rudolfs Kreicbergs [ 2011 Sep 28 ] |
Fixed/available in dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4165 |
Comment by Aleksandrs Saveljevs [ 2011 Sep 29 ] |
Fixed in pre-1.9.7 in r22034. Corey, please note that in order to install the fix, you have to do "make dbschema", recompile both Zabbix server and Zabbix proxy, and let Zabbix proxy recreate its database from scratch. |
Comment by Corey Shaw [ 2011 Oct 03 ] |
Awesome! Thanks for the quick fix. I'll give it a test sometime this week. It could be a few days though. |
Comment by Aleksandrs Saveljevs [ 2011 Oct 04 ] |
Additional fixes to proxy_dhistory upgrade patches available in pre-1.9.7 in r22110. |