[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