[Babase] Re: repstats rebuild error
Niki Learn
nlearn at princeton.edu
Fri Mar 5 11:47:05 EST 2010
I don't think I've ever even heard of PAT. I'm sure I didn't change
anything about her. I will take a look at her records and see if I can find
anything fishy looking.
-----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:41 AM
To: The Baboon Database Project
Subject: Re: [Babase] Re: repstats rebuild error
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
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list