Zabbix unixODBC check bringing down server

[cfnz]

Hi,

Just checking out Zabbix, so a newbie in all things Zabbix.

I have configured a unixODBC datasource to connect to one of our FirebirdSQL databases and run a quick count query. I can run my query in unixODBC isql and it all works, so the unixODBC side of things seems all good.

I have configured a Database monitor item connecting to the datasource.

When looking at the Monitoring - Latest data web page, I see my database item has an error as follows:

Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]|

However, the datasource name is fine (and works in isql).

Shortly after the Zabbix server process stops.

Looking at the Zabbix server log, I get the following:

  1073:20160928:114550.650 [file:odbc.c,line:318] zbx_malloc: out of memory. Requested 140454020513802 bytes.
  1017:20160928:114550.663 One child process died (PID:1073,exitcode/signal:1). Exiting ...
  1017:20160928:114552.671 syncing history data...
  1017:20160928:114552.671 syncing history data done
  1017:20160928:114552.671 syncing trend data...
  1017:20160928:114552.763 syncing trend data done
  1017:20160928:114552.763 Zabbix Server stopped. Zabbix 3.2.0 (revision 62485).

That seems to be one mightily large memory request coming from odbc.c...

My first assumption was that there was something funny with the unixODBC side of things, but as mentioned, I can use isql and run queries against the datasource name just fine.

So it seems something in Zabbix and odbc put together, and that something can stop the Zabbix server from running.

My Zabbix install is from the appliance CD install running against a Postgres DB... haven't done much to it other than installing the FirebirdSQL unixODBC drivers... maybe that is the culprit? (But as mentioned, isql runs fine.)

Not sure where to head next, happy to try some more debugging options.

Thanks
Colin

[colloque]

Hello,

Do you have apply the last Patch:

Maybe that your probelm is that

https://svn.zabbix.com/secure/attachment/44984/ZBX-11213.patch

You have to modfiy the odbc.c file then to recompile the source and restart zabbix_server.

Best Regards

[cfnz]

Thanks for that, no, I have not tried this patch. It does sound like it might fix the issue.

I shall look into what is involved in building from source (currently I am evaluating Zabbix and have taken the simpler route of installing from the appliance image... I shall keep an eye out for any updates to the appliance installation image too).

There is also the option of just using a script, and checking the DB from there, which is the way I am heading...

However, if I do build and apply the patch, I shall report back.

Thanks for your time :-)
Regards
Colin