[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: | ZBXNEXT-970 Provide more details in DB down message.pdf zbxnext-970.patch | ||||||||||||
Issue Links: |
|
||||||||||||
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 - 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 natalja.cernohajeva: corresponding page has been updated with the required info for all supported versions: <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. 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. |
Comment by Xavier Schneider [ 2017 Jan 31 ] |
Hi |
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 ? |
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. |
Comment by Viktors Tjarve [ 2017 Dec 08 ] |
Released in:
|
Comment by Vladislavs Sokurenko [ 2017 Dec 14 ] |
Released in:
|