[ZBXNEXT-970] provide more information in "database is down" message (Z4) Created: 2011 Sep 14  Updated: 2024 Apr 10  Resolved: 2017 Dec 16

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Server (S)
Affects Version/s: None
Fix Version/s: 4.0.0alpha1, 4.0 (plan)

Type: Change Request Priority: Trivial
Reporter: richlv Assignee: Viktors Tjarve
Resolution: Fixed Votes: 11
Labels: database, dbwatchdog, usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PDF File ZBXNEXT-970 Provide more details in DB down message.pdf     Text File zbxnext-970.patch    
Issue Links:
Duplicate
is duplicated by ZBXNEXT-1422 Improvement for "Zabbix database is d... Closed
Sub-task
Team: Team A
Team: Team A
Sprint: Sprint 18, Sprint 19, Sprint 20, Sprint 21, Sprint 22, Sprint 23
Story Points: 4

 Description   

when there's some problem with database (can't connect, timeout, permission issue...) zabbix server may send a message. currently this message just says "database is down" - would be nice to include actual error there as well



 Comments   
Comment by P Sorensen [ 2012 Mar 22 ]

Please also provide the Zabbix servername that is reporting this issue - so that those who may receive this message, but are not aware exactly which server Zabbix is running on, can quickly find out which server to look at and fix.

Comment by Alexei Vladishev [ 2012 Nov 08 ]

Initial draft of the specification is available at http://www.zabbix.org/wiki/Docs/specs/ZBXNEXT-970

Comment by Oleksii Zagorskyi [ 2013 Feb 27 ]

just a note - ZBX-6305 will add possibility to specify email of sender in format "Name <email>" (of course specifying just email like before works too).

This should help for cases mentioned by P Sorensen above.

Comment by richlv [ 2013 Feb 27 ]

note that "server name" we can see in the upper right corner can not be obtained by the server, as it is only in the frontend config file

Comment by Backoffice Team [ 2015 May 29 ]

richlv i guess that the server could send its hostname or ip address at least.

Telling what error is it, more details on database (address/database) would be ideal as well.

Comment by Oleksii Zagorskyi [ 2015 Jun 11 ]

(1) Documentation
It would worth to add more technical details to documentation https://www.zabbix.com/documentation/2.4/manual/web_interface/frontend_sections/administration/general
According to source code, add something like:
Every 60 seconds the watchdog tries to establish a new connection to the database.
If the database is still down - the watchdog repeats alerts sending, but not often than every 15 minutes.

natalja.cernohajeva: corresponding page has been updated with the required info for all supported versions:
2.2;
3.0;
3.4;
4.0.
RESOLVED

<viktors.tjarve> CLOSED

Comment by Oleksii Zagorskyi [ 2015 Jun 11 ]

Another use case is a DNS name for DBHost server config parameter and temporary not available DNS server.
Of course it's related to ZBXNEXT-1002

Would be nice for such cases if extended "database is down" message would include a hint that problem is in hostname resolution.

Although, in such case zabbix server continue to be working with database, but in the same time it sends alerts that "db is down" - so it may mislead.
Not sure how it could be resolved technically.

Comment by Xavier Schneider [ 2017 Jan 31 ]

Hi
I've made a simple code for 3.2 to specify an accurate subject and message. I've tried to specify what was written in the specification, but it's difficult to know exactly what is the error message and the database type.

Comment by Rostislav Palivoda [ 2017 Oct 19 ]

Is it really secure to show such information?

vjaceslavs If we call adding log entry "showing", then yes, no problem with that.

Comment by richlv [ 2017 Nov 01 ]

curious, what is the added "Z4" in the summary ?
palivoda dont worry. just a marker for manager.

Comment by richlv [ 2017 Nov 01 ]

palivoda, to clarify, this is about the email that is sent out[1], not about any messages in the frontend. the message is sent only to a predefined list of users, "zabbix administrators" by default.

[1] http://www.zabbix.org/wiki/Docs/specs/ZBXNEXT-970

palivoda Yes, check ZBXNEXT-970 Provide more details in DB down message.pdf

Comment by Volker Fröhlich [ 2017 Nov 15 ]

Thank you for publishing the specification!

I can imagine a situation where it is not obvious which instance of Zabbix server a database belongs to. Some kind of identifier (which does not exist yet) could be useful. Or you could argue people should name their databases accordingly.

viktors.tjarve We had a discussion about such identifier for Zabbix server. Unfortunately it was decided that for this development it is out of scope.

Comment by richlv [ 2017 Nov 15 ]

why not include server hostname ? that should be good for most of the users without hardcoding it in the "from" address or somewhere else

Comment by Volker Fröhlich [ 2017 Nov 15 ]

What if there is no hostname, the host name is not speaking or multiple servers are running on the same host? I think I would rather have something I can specify myself.

Comment by richlv [ 2017 Nov 15 ]

oh, absolutely a server id/token would be better, but that's out of scope, as mentioned by Viktors. hostname would be a simpler addition that would cover some 90% of the users

Comment by Viktors Tjarve [ 2017 Nov 15 ]

There can be all kinds of complicated infrastructure configurations. The scope of this ZBXNEXT is to cover only the case when it is possible to identify both Zabbix DB and Zabbix server using this DB just from DB parameters.
It is decided that other scenarios can be investigated and solved as a different ZBXNEXT.

Comment by Viktors Tjarve [ 2017 Dec 08 ]

Released in:

  • 4.0.0alpha1 r75597
Comment by Vladislavs Sokurenko [ 2017 Dec 14 ]

Released in:

  • 4.0.0alpha1 r75965
Generated at Fri Apr 19 03:39:48 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.