Re: [Nagios-devel] nagios crashing...
Posted: Tue Mar 11, 2003 12:23 pm
hi
anyone that knows more about this?
roy
On Monday, Mar 10, 2003, at 11:43 Europe/Oslo, Roy Sigurd Karlsbakk
wrote:
> hi
>
> nagios seem to be crashing if it fails to insert a row (or more) to the
> servicecomments table in postgres. the postgres acls should be right.
> check
> logs below for more info
>
> database acl:
>
> nagios=# \z
> Access privileges for database "nagios"
> Table | Access privileges
> ---------------------------------+-------------------------------------
> hostcomments | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostcomments_hostcomment_id_seq |
> hostdowntime | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostdowntime_hostdowntime_i_seq |
> hostextinfo | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> hoststatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> programretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> programstatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicecommen_servicecommen_seq |
> servicecomments | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicedownti_servicedownti_seq |
> servicedowntime | {=,postgres=arwdRxt,nagios=arwdRxt}
> serviceextinfo | {=,postgres=arwdRxt,nagios=arwdRxt}
> serviceretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicestatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> (16 rows)
>
>
> crash 1:
>
> [1046684575] Error: Could not insert record for service comment in
> table
> 'servicecomments' of database 'nagios'
> [1046684575] SERVICE ALERT: display00;NT_USEDDISKSPACE_S;OK;HARD;1;s:\
> -
> total: 46.44 Gb - used: 38.80 Gb (84%) - free 7.64 Gb
> (16%)
> [1046684575] SERVICE FLAPPING ALERT:
> display00;NT_USEDDISKSPACE_S;STARTED;
> Service appears to have started flapping (21.7% chan
> ge > 20.0% threshold)
> [1046684575] Caught SIGSEGV, shutting down...
>
>
> crash 2:
>
> [1047222569] Error: Could not insert record for service comment in
> table
> 'servicecomments' of database 'nagios'
> [1047222719] Caught SIGSEGV, shutting down...
>
>
> --
> Roy Sigurd Karlsbakk, Datavaktmester
> ProntoTV AS - http://www.pronto.tv/
> Tel: +47 9801 3356
>
> Computers are like air conditioners.
> They stop working when you open Windows.
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-devel
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
anyone that knows more about this?
roy
On Monday, Mar 10, 2003, at 11:43 Europe/Oslo, Roy Sigurd Karlsbakk
wrote:
> hi
>
> nagios seem to be crashing if it fails to insert a row (or more) to the
> servicecomments table in postgres. the postgres acls should be right.
> check
> logs below for more info
>
> database acl:
>
> nagios=# \z
> Access privileges for database "nagios"
> Table | Access privileges
> ---------------------------------+-------------------------------------
> hostcomments | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostcomments_hostcomment_id_seq |
> hostdowntime | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostdowntime_hostdowntime_i_seq |
> hostextinfo | {=,postgres=arwdRxt,nagios=arwdRxt}
> hostretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> hoststatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> programretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> programstatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicecommen_servicecommen_seq |
> servicecomments | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicedownti_servicedownti_seq |
> servicedowntime | {=,postgres=arwdRxt,nagios=arwdRxt}
> serviceextinfo | {=,postgres=arwdRxt,nagios=arwdRxt}
> serviceretention | {=,postgres=arwdRxt,nagios=arwdRxt}
> servicestatus | {=,postgres=arwdRxt,nagios=arwdRxt}
> (16 rows)
>
>
> crash 1:
>
> [1046684575] Error: Could not insert record for service comment in
> table
> 'servicecomments' of database 'nagios'
> [1046684575] SERVICE ALERT: display00;NT_USEDDISKSPACE_S;OK;HARD;1;s:\
> -
> total: 46.44 Gb - used: 38.80 Gb (84%) - free 7.64 Gb
> (16%)
> [1046684575] SERVICE FLAPPING ALERT:
> display00;NT_USEDDISKSPACE_S;STARTED;
> Service appears to have started flapping (21.7% chan
> ge > 20.0% threshold)
> [1046684575] Caught SIGSEGV, shutting down...
>
>
> crash 2:
>
> [1047222569] Error: Could not insert record for service comment in
> table
> 'servicecomments' of database 'nagios'
> [1047222719] Caught SIGSEGV, shutting down...
>
>
> --
> Roy Sigurd Karlsbakk, Datavaktmester
> ProntoTV AS - http://www.pronto.tv/
> Tel: +47 9801 3356
>
> Computers are like air conditioners.
> They stop working when you open Windows.
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-devel
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]