Greg Stark [2009-08-23 03:44]:
> 2009/8/22 Radoslaw Zielinski :
>> $ seq 11 | xargs -ti psql bug -c "select {}, (x).* from (select
>> bt_page_items('promocje_pkey',{}) as x ) as y"
>> [...]
>> psql bug -c select 11, (x).* from (select bt
Greg Stark [2009-08-23 03:40]:
> 2009/8/22 Radoslaw Zielinski :
>> bug=# select length(opis_szczeg) from promocje where id = 4300;
>> ERROR: missing chunk number 0 for toast value 120741 in pg_toast_29644
> Sorry, what datatype is this again? And what encoding?
tex
Tom Lane [2009-08-21 20:35]:
> Radoslaw Zielinski writes:
>> Greg Stark [2009-08-21 18:55]:
>>> Is this, perchance, new hardware? Did you test the memory in it?
>> It's a "virtual private server"; the hosting provider is swearing
>> everything&#x
Greg Stark [2009-08-21 20:30]:
[...]
> Actually I mean the key for the toast table.
> Let me ask firstly do you get anything if you just do select * from
> pg_toast.pg_toast_29644 where chunk_id = 120741 ?
0 rows.
> And secondly, what do you get if you do "select length(htmlblob) from
> tab whe
Greg Stark [2009-08-21 18:38]:
[...]
> the toast table. Not unless you can dump the whole index and find
> pointers in there or can find the details in the wal log.
You mean the primary key index? How do I dump it?
--
Radosław Zieliński
pgpdIiosOzpYQ.pgp
Description: PGP signature
Greg Stark [2009-08-21 18:55]:
[...]
> Is this, perchance, new hardware? Did you test the memory in it?
It's a "virtual private server"; the hosting provider is swearing
everything's fine. I can't vouch for it myself, obviously.
> Do you have other records that have "disappeared"?
I haven't fo
Greg Stark [2009-08-21 18:12]:
[...]
> Or alternatively do you have all the wal logs and could you run
> xlogdump on them looking for transaction id 6179?
Nope, I don't have the wal logs.
--
Radosław Zieliński
pgpO5wPiNs71J.pgp
Description: PGP signature
Greg Stark [2009-08-21 18:03]:
> On Fri, Aug 21, 2009 at 4:04 PM, Radoslaw Zielinski
> wrote:
>> This particular row currently has last_modified="2009-08-11", but table_log
>> says it has been updated on "2009-08-12" -- so, data loss.
> These are all v
Hello,
8.4.0 installation on i686 modern Linux, a simple production app with ~4
users entering data; normalised, no weird stuff happening there. Recently:
ERROR: missing chunk number 0 for toast value 120741 in pg_toast_29644
This table has table_log and a "before update" trigger setting
"NE
