[Babase] Re: repstats rebuild error

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


On 03/05/2010 10:04:32 AM, Niki Learn wrote:
> Well I didn't do anything to CYCGAPS so I don't know why there would
> be a
> "new" error there then... ?  I guess we'll see what it says when it
> finishes
> running for you.

One of the problems is with PAT on 1993-06-25.  The problem is caused
because CYCGAPDAYS is not in sync with CYCGAPS.   When this happens
there is a bug.   I suspect that PAT's Statdate was changed, and
maybe something else like Status.  If
so it would help to know the old value(s).  Something changed to
trigger the bug.  If I can find out what I can go bug squashing.

Without any clue I can poke around but may not be able to find
the problem.  I'm looking for as much information as possible.

Any clues?

If it would help I can work at finding the row that triggered
the second error.

I can always rebuild CYCGAPDAYS.  The problem won't go away
it will just be hidden until next time.

> 
> -----Original Message-----
> From: babase-bounces at eeblistserv.Princeton.EDU
> [mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl 
> O.
> Pinc
> Sent: Friday, March 05, 2010 11:03 AM
> To: babase at eeblistserv.Princeton.EDU
> Subject: [Babase] Re: repstats rebuild error
> 
> 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
> 
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 
> 




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