Re: warning message in standby

On Mon, Jun 14, 2010 at 13:11, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Magnus Hagander wrote:
>> >> Seems like we need something like WARNING that doesn't cause the process
>> >> to die, but more alarming like ERROR/FATAL/PANIC. Or maybe just adding a
>> >> hint to the warning will do. How about
>> >>
>> >> WARNING: ?invalid record length at 0/4005330
>> >> HINT: An invalid record was streamed from master. That can be a sign of
>> >> corruption in the master, or inconsistency between master and standby
>> >> state. The record will be re-fetched, but that is unlikely to fix the
>> >> problem. You may have to restore standby from base backup.
>> >
>> > I am thinking about log monitoring tools like Nagios. ?I am afraid
>> > they are never going to pick up something tagged WARNING, no matter
>>
>> If they are properly configured, I imagine they would. And if they're
>> not, well, there's not much for us to do.
>
> What does that mean?

It means that we can't prevent people from configuring their tools to
ignore important warning. We can't prevent them rom ignoring ERROR or
FATAL either...

>> (What would be more usful then would be to separate "user-warnings"
>> like warnings about cast from actual system-warnings like this, but
>> that's a whole different story)
>>
>> > what the wording is. ?Crazy idea, but can we force a fatal error line
>> > into the logs with something like "WARNING ...\nFATAL: ...".
>>
>> That's way too crazy :P And btw, randomly sticking newlines into that
>> will mess up *most* log displayers and I bet a lot of the log
>> monitoring tools as well...
>
> Yeah, it would mess up CSV log output, for example?

Possibly. And your general syslog output would become pretty hard to
read once this kind of stuff shows up.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/