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

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

BTW, it looks like the reason this never bit me was because I fixed it and 
simply failed it check it in.

Well, at least that's one mystery solved.

On Thu, 20 Jan 2005, Ben wrote:

> 
> 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?
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
>