Re: [Nagios-db-devel] Segfaults with the postgres ned

[Ben <be...@si...>]

On Jan 20, 2005, at 8:26 AM, Tim Verhoeven wrote:
> Enabling some extensive logging helped. I've found a couple of issues 
> in the stored procedures. One in host.sql is already fixed in CVS. 
> This is the other :
>
> diff -u -r1.3 restart.sql
> --- restart.sql 16 Jan 2005 20:21:43 -0000      1.3
> +++ restart.sql 20 Jan 2005 16:23:32 -0000
> @@ -28,7 +28,7 @@
>                 thisHostID      int;
>         BEGIN
>          -- get the host id. If this is a new host, insert the host 
> and get the id
> -        select into thisHostID id FROM host WHERE name = thisHostName;
> +        select into thisHostID id FROM host WHERE name = hostName;
>
>                 if thisHostID is not null
>                 then
>

Doh! Good catch. I wonder why I was never bit by this.....

Well, regardless, the fix is now in CVS and I bet the reason you're 
crashing is because I've been too lazy and have not added error 
checking to the neb module. That's gonna change as soon as I get into 
work (assuming no fires... haha). But after you fixed this stored proc 
are you still crashing?