Re: server crash in very big transaction [postgresql 8.0beta1]

--- Alvaro Herrera <alvherre@dcc.uchile.cl> wrote:

> On Sun, Aug 22, 2004 at 09:39:07AM +0800, ??????
> wrote:
> > BEGIN;
> > ...
> > ...
> > ...
> > END;
> >
> > PANIC:  invalid xlog record length 236052
>
> Huh, so what kind of operations did you execute
> within the transaction?
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> Voy a acabar con todos los humanos / con los humanos
> yo acabar?> voy a acabar con todos / con todos los
humanos
> acabar?(Bender)
>
>

-------------------example 1--------------------
$ echo "BEGIN;" > backup.sql
$ pg_dump -o >> backup.sql
$ echo "END;" >> backup.sql
...
$ psql -f backup.sql

PANIC:  invalid xlog record length 236052


----------------example 2 ------------------------

There are 1600 tables in database 'db1', I wrote a
pl/pgsql function "update_tables" like

"
FOR table IN SELECT relname FROM pg_class
LOOP
    ...
    DROP INDEX ON ... ;
    ALTER TABLE DROP CONSTRAINT ...;
    ...
    CREATE INDEX xxx ON TABLE xxx;
    ...
    ALTER TABLE xxx ADD PRIMARY KEY...
    ALTER TABLE xxx ADD ...
    ...
END LOOP
...
"

$ select update_tables();

PANIC:  invalid xlog record length 236052




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail