From: | "Thilo Hille" <thilo(at)resourcery(dot)de> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: MemoryContextAlloc: invalid request size 1969649011 |
Date: | 2002-08-08 09:38:20 |
Message-ID: | 005301c23ebf$54e89700$0b00a8c0@resourcery.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi tom,
> > sometimes drops this error:
> > DBD::Pg::st execute failed: ERROR: MemoryContextAlloc: invalid request
size
> > 1969649011
>
> This looks to me like a corrupted-data issue --- specifically, the
> length word of some data value in the table has gotten clobbered and
> now appears ridiculously large.
>
> You should try to determine exactly which row(s) contain bad data.
the error only occurs sometimes. if some rows had been corrupted shouldnt it
be reproduceable?
anyway, i try a dump/restore. it should fail when the table has corrupted
rows...
regards
Thilo Hille
thilo(at)resourcery(dot)de
----- Original Message -----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thilo Hille <thilo(at)resourcery(dot)de>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, August 08, 2002 4:25 AM
Subject: Re: [NOVICE] MemoryContextAlloc: invalid request size 1969649011
> "Thilo Hille" <thilo(at)resourcery(dot)de> writes:
> > this query...:
>
> > my $tsql = qq{ insert into user_month (select '$currentmonth'::date as
> > month,'*nopleid*',count(distinct uuid) from user_log where
day<=now()::date
> > and day>(now()-interval '30 days')::date) };
> > my $tsth = $tdbh->prepare( $tsql );
> > $tsth->execute();
>
> > sometimes drops this error:
> > DBD::Pg::st execute failed: ERROR: MemoryContextAlloc: invalid request
size
> > 1969649011
>
> This looks to me like a corrupted-data issue --- specifically, the
> length word of some data value in the table has gotten clobbered and
> now appears ridiculously large.
>
> You should try to determine exactly which row(s) contain bad data.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | eric soroos | 2002-08-08 16:18:21 | Re: Effective limit on size of text type? |
Previous Message | sdeel | 2002-08-08 03:52:56 | Re: Permissions problem on new install |