Has anyone seen this behavior?  It's corrupted a production database.


ERROR:  heap_mark4update: (am)invalid tid
WARNING:  Error occurred while executing PL/pgSQL function issuewomaterial
WARNING:  line 40 at SQL statement


Mon, 27 Jan 2003 11:04:58 -0500
"Ned Lilly" <ned@nedscape.com>
urgent: db corruption - invalid TIDs?
ps - this is on 7.3.1.  It never happened on 7.2.3...



----- Original Message ----- 
From: "Ned Lilly" <ned@nedscape.com>
To: "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
Sent: Monday, January 27, 2003 11:04 AM
Subject: [HACKERS] urgent: db corruption - invalid TIDs?


Has anyone seen this behavior?  It's corrupted a production database.


ERROR:  heap_mark4update: (am)invalid tid
WARNING:  Error occurred while executing PL/pgSQL function issuewomaterial
WARNING:  line 40 at SQL statement



Mon, 27 Jan 2003 11:06:26 -0500
"Ned Lilly" <ned@nedscape.com>
Re: urgent: db corruption - invalid TIDs?
Ned Lilly wrote:
> Has anyone seen this behavior?  It's corrupted a production database.

Hi Ned,

Just as information filler, which version of PostgreSQL, and which 
operating system?

:-)

Regards and best wishes,

Justin Clift

> ERROR:  heap_mark4update: (am)invalid tid
> WARNING:  Error occurred while executing PL/pgSQL function issuewomaterial
> WARNING:  line 40 at SQL statement


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


Tue, 28 Jan 2003 02:37:52 +1030
Justin Clift <justin@postgresql.org>
Re: urgent: db corruption - invalid TIDs?
I don't know if this is terribly helpful, but the message was around in
7.2.x, look at src/backend/access/heap/heapam.c around line 1808 (or
1823 in the 7.3.x code)

That said, I've not seen it before, perhaps you can expand upon what
your function is doing?

Robert Treat

On Mon, 2003-01-27 at 11:06, Ned Lilly wrote:
> ps - this is on 7.3.1.  It never happened on 7.2.3...
> 
> 
> 
> ----- Original Message ----- 
> From: "Ned Lilly" <ned@nedscape.com>
> To: "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
> Sent: Monday, January 27, 2003 11:04 AM
> Subject: [HACKERS] urgent: db corruption - invalid TIDs?
> 
> 
> Has anyone seen this behavior?  It's corrupted a production database.
> 
> 
> ERROR:  heap_mark4update: (am)invalid tid
> WARNING:  Error occurred while executing PL/pgSQL function issuewomaterial
> WARNING:  line 40 at SQL statement
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




27 Jan 2003 11:32:33 -0500
Robert Treat <xzilla@users.sourceforge.net>
Re: urgent: db corruption - invalid TIDs?