[NFDB-users] Apache problem trying to load NFD in OBSD 4.5

[Jason Dixon]

On Fri, May 08, 2009 at 02:43:11PM +0200, Fernando Alvarez wrote:
> On the database log, I can see the following multiple times:
> 
> ERROR:  Date out of range.  Fix flows_insert_trigger() function.
> STATEMENT:  INSERT INTO flows_template VALUES ($1,now(),$2,$3,$4,$5,$6,
> $7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,
> $25,$26,$27,$28,$29,$30,$31)
> 
> Is that normal? Could it be the root of my problems with nfdb?

I don't believe so.  I think that's a normal consequence of the trigger
design.  You're *supposed* to see some errors in there;  they cause it
to do an UPDATE instead of an INSERT.  This "try to insert... update on
fail" method scales better than "check if this exists, then 
update/insert on our results".

Your last email suggests everything is working correctly as far as
saving flows.  Can you verify this by running some basic queries against
the table?

$ psql -U nfdb_user nfdb    # pass is in index.cgi
[ ... ]
nfdb=> select count(*) from flows;
  count  
---------
 1098448
(1 row)

P.S.  The reason the dev site has no data showing is because I haven't
been sending flows to it for a while.

-- 
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net/