From: | Janning Vygen <vygen(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | i'm really desperate: invalid memory alloc request size 0 |
Date: | 2004-10-01 07:49:45 |
Message-ID: | 200410010949.46075.vygen@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
tonight my database got corruppted. before it worked fine.
since two days i do the following tasks every night
psql -c 'CLUSTER;' $DBNAME
psql -c 'VACUUM FULL ANALYZE;' $DBNAME
before these opertaions i stop all web access. The last months i only did a
"VACUUM ANALYZE" each night and didn't get any failures.
in the morning some sql queries failed. it seems only one table was affected.
i stopped all web access and tried to backup the current database:
pg_dump: ERROR: invalid memory alloc request size 0
pg_dump: SQL command to dump the contents of table "fragentipps" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc request size
0
pg_dump: The command was: COPY public.fragentipps (tr_kurzname, mg_name,
fr_id, aw_antworttext) TO stdout;
so i did:
/etc/init.d/postgresql stop
cp -rp /home/postgres/data /home/postgres/datafailure
and i tried to recover from backup which was made just before clustering but i
got
ERROR: index row requires 77768 bytes, maximum size is 8191
is there any chance to get my database keep going again?
pg version is 7.4.2
kind regards
janning
From | Date | Subject | |
---|---|---|---|
Next Message | Janning Vygen | 2004-10-01 08:06:10 | Re: i'm really desperate: invalid memory alloc request size 0 |
Previous Message | Russell Smith | 2004-10-01 07:32:42 | Repeated VACUUM reports same number of deleted rows |