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

2004-08-28 Thread Bruce Momjian
Is this fixed? --- Tom Lane wrote: > "ÿceÿac" "ÿbdÿaa" <[EMAIL PROTECTED]> writes: > > --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: > >> Huh, so what kind of operations did you execute > >> within the transa

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

2004-08-25 Thread Tom Lane
"ÿceÿac" "ÿbdÿaa" <[EMAIL PROTECTED]> writes: > --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: >> Huh, so what kind of operations did you execute >> within the transaction? > There are 1600 tables in database 'db1', I wrote a > pl/pgsql function "update_tables" like > " > FOR tabl

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

2004-08-25 Thread ÿffffceÿffffac
--- Alvaro Herrera <[EMAIL PROTECTED]> 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

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

2004-08-24 Thread Alvaro Herrera
On Tue, Aug 24, 2004 at 06:10:40PM -0400, Tom Lane wrote: > WARNING: out of shared memory > ERROR: out of shared memory > HINT: You may need to increase max_locks_per_transaction. > WARNING: StartAbortedSubTransaction while in START state > ERROR: current transaction is aborted, commands igno

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

2004-08-24 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Sun, Aug 22, 2004 at 09:39:07AM +0800, ?? wrote: >> PANIC: invalid xlog record length 236052 > Huh, so what kind of operations did you execute within the transaction? I found one possible explanation, though I don't know if it's the submitter's

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

2004-08-24 Thread Alvaro Herrera
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 () Voy a acabar con todos los humanos / con los humanos yo acabaré vo

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

2004-08-24 Thread Tom Lane
=?UTF-8?Q?=E5=A7=9C?= =?UTF-8?Q?=E7=BB=B4?= <[EMAIL PROTECTED]> writes: > BEGIN; > ... > ... > ... > END; > PANIC: invalid xlog record length 236052 > server closed the connection unexpectedly This is quite unhelpful, if you're not going to show us what you did to cause it.