hi
nagios seem to be crashing if it fails to insert a row (or more) to the=20
servicecomments table in postgres. the postgres acls should be right. che=
ck=20
logs below for more info
database acl:
nagios=3D# \z
Access privileges for database "nagios"
Table | Access privileges
---------------------------------+-------------------------------------
hostcomments | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
hostcomments_hostcomment_id_seq |
hostdowntime | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
hostdowntime_hostdowntime_i_seq |
hostextinfo | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
hostretention | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
hoststatus | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
programretention | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
programstatus | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
servicecommen_servicecommen_seq |
servicecomments | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
servicedownti_servicedownti_seq |
servicedowntime | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
serviceextinfo | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
serviceretention | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
servicestatus | {=3D,postgres=3DarwdRxt,nagios=3DarwdR=
xt}
(16 rows)
crash 1:
[1046684575] Error: Could not insert record for service comment in table=20
'servicecomments' of database 'nagios'
[1046684575] SERVICE ALERT: display00;NT_USEDDISKSPACE_S;OK;HARD;1;s:\ -=20
total: 46.44 Gb - used: 38.80 Gb (84%) - free 7.64 Gb
(16%)
[1046684575] SERVICE FLAPPING ALERT: display00;NT_USEDDISKSPACE_S;STARTED=
;=20
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=20
'servicecomments' of database 'nagios'
[1047222719] Caught SIGSEGV, shutting down...
--=20
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 post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]