[Babase] Re: repstats rebuild error
Niki Learn
nlearn at princeton.edu
Fri Mar 5 11:54:21 EST 2010
Okay, strike that. I did do something to PAT - I censored her. So this is
another weird fruity error like those neighbors ones that is popping up from
that. How do these cycgaps tables work and interact with the state &
statdate?
This could have occurred with a number of other females too since the
females that got censored were all from groups that we stopped monitoring at
some point and they were usually monitored sort of sporadically for a while
before all monitoring stopped so all of those females are probably in
cycgaps...
-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Niki Learn
Sent: Friday, March 05, 2010 11:47 AM
To: 'The Baboon Database Project'
Subject: RE: [Babase] Re: repstats rebuild error
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
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list