[Babase] Re: repstats rebuild error

Karl O. Pinc kop at meme.com
Fri Mar 5 11:02:40 EST 2010


On 03/05/2010 09:54:56 AM, Niki Learn wrote:
> Oh - I bet it's Scenic!  She had an mdate on 11 July and then seems 
> to
> have
> just stopped cycling for two months during the drought.  Her next
> tdate is
> not until 7 Sep.  Would that do it?

Probably not because she has no CYCGAPS rows.

> 
> So would Little and Oasis set off this error too if they have mature
> dates
> but no cycles yet or are they okay?

I would not think that's the problem or it would have come up before.

> 
> I was going to upload a couple other small items to test but that can
> wait
> if needed.  I've got another little project buzzing in my ear at the
> moment
> anyway.  As far as I know nobody else is using it.

Ok.  Thanks.

> 
> Thanks,
> Niki
> 
> -----Original Message-----
> From: Karl O. Pinc [mailto:kop at meme.com] 
> Sent: Friday, March 05, 2010 10:47 AM
> To: Niki Learn; babase at eeblistserv.Princeton.EDU
> Subject: Re: repstats rebuild error
> 
> On 03/05/2010 08:47:47 AM, Niki Learn wrote:
> > Karl,
> > 
> >  
> > 
> > I got this error yesterday and thought it was probably due to two
> > young
> > females who just started cycling in December.  I had entered their
> > maturedates but could not enter their matching cycles because they 
> > did
> > not
> > end until after the statdate.  So I figured they would likely be 
> the
> > culprits since they would seemingly then not be cycling, pregnant,
> or
> > lactating, but I deleted their maturedates and still got the same
> > error.  I
> > will check again to see if there are any others that are fishy.  
> But
> > is
> > there anything else that might cause this error?
> 
> The problem has to do with gaps (CYCGAPS).  I've modified
> the rebuild_repstats() program to report who's having
> the problem on what date and am running it in
> babase_test now.  I'll investigate further....
> 
> P.S.  I also want to restart the database server.
> Is there any reason to be careful because someone's
> using it and needs it constantly?
> 
> > 
> >  
> > 
> > Thanks,
> > 
> > Niki
> > 
> >  
> > 
> > SELECT rebuild_all_repstats();
> > 
> > 
> > SQL error:
> > 
> > ERROR:  null value in column "state" violates not-null constraint
> > 
> > CONTEXT:  SQL statement "INSERT INTO repstats (sname, date, state,
> > dins,
> > pid) VALUES ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
> > 
> > PL/pgSQL function "rebuild_repstats" line 177 at SQL statement
> > 
> > SQL statement "SELECT  rebuild_repstats( $1 )"
> > 
> > PL/pgSQL function "rebuild_all_repstats" line 34 at perform
> > 
> > In statement:
> > SELECT rebuild_all_repstats();
> > 
> >  
> > 
> > Line 1: ERROR: null value in column "state" violates not-null
> > constraint
> > CONTEXT: SQL statement "INSERT INTO repstats (sname, date, state,
> > dins, pid)
> > VALUES ( $1 , $2 , $3 , $4 , $5 )"
> > PL/pgSQL function "rebuild_repstats" line 177 at SQL statement
> > SQL statement "SELECT rebuild_repstats( $1 )"
> > PL/pgSQL function "rebuild_all_repstats" line 34 at perform
> > 
> > Total runtime: 2,902,171.843 ms
> > 
> >  
> > 
> > 
> 
> 
> 
> 
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> 
> 
> 




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list