[Babase] Re: repstats rebuild error

Niki Learn nlearn at princeton.edu
Fri Mar 5 12:08:47 EST 2010


June 25th?  Her censordate is June 23rd.  The last census record is for June
11 but she has a wounds sheet that lists her as healed on 23 June, which is
the only reason her statdate isn't set to June 11.  Probably there are later
census records too but I have not yet seen the census backfill Lacey and the
Duke student employees have been working on so I would have to look those up
in the notebooks if we need to know them now.

Her last cycgapday is listed as June 24th.  Her last cycgap record has her
with a code P (pregnant?) and state S as of 15 Jan 1993.

I guess the question now is, should I delete cycgapdays that appear after
the statdates?  (That would stop the error, yes?  I'm not sure how these
records are generated...)  Or do I need to uncensor any females with this
problem until we have the rest of the census records in since that might
change everything anyway?

-----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:54 AM
To: 'The Baboon Database Project'
Subject: RE: [Babase] Re: repstats rebuild error

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

_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list