Обсуждение: 8.5devel: unexpected and illogical error during transaction, but transaction don't rolled back
8.5devel: unexpected and illogical error during transaction, but transaction don't rolled back
От
"A. Kretschmer"
Дата:
Hi all, I'm playing with 8.5devel aka 9.0 and got that: test=# with a as (insert into table_a select s, md5(s::text) from generate_series(0,250000) s returning *), b as (insert into table_b select id, md5(value) from a where substring(value,1,1) between '0' and '9') select true; bool ------ t (1 row) Time: 4167,579 ms test=*# analyse table_a; ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "test.public.table_a" ANALYZE Time: 1235,600 ms I think, that's not an ERROR, just a NOTICE for me. And yes, the transaction isn't rolled back, so it isn't an error. Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
On Wed, Feb 10, 2010 at 6:59 AM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote: > test=*# analyse table_a; > ERROR: canceling autovacuum task > CONTEXT: automatic vacuum of table "test.public.table_a" > ANALYZE > Time: 1235,600 ms > > > I think, that's not an ERROR, just a NOTICE for me. And yes, the > transaction isn't rolled back, so it isn't an error. Did you start the server from the same terminal? I think the ERROR and CONTEXT line come from the server, not psql and are expected behaviour. -- greg
Re: 8.5devel: unexpected and illogical error during transaction, but transaction don't rolled back
От
"A. Kretschmer"
Дата:
In response to Greg Stark : > On Wed, Feb 10, 2010 at 6:59 AM, A. Kretschmer > <andreas.kretschmer@schollglas.com> wrote: > > test=*# analyse table_a; > > ERROR: canceling autovacuum task > > CONTEXT: automatic vacuum of table "test.public.table_a" > > ANALYZE > > Time: 1235,600 ms > > > > > > I think, that's not an ERROR, just a NOTICE for me. And yes, the > > transaction isn't rolled back, so it isn't an error. > > Did you start the server from the same terminal? I think the ERROR and > CONTEXT line come from the server, not psql and are expected > behaviour. Hi Greg, back from FOSDEM? Yes, I started the server from the same terminal. It's my private PC @home, I'm remote there. First, i have started the Server manually in the background, then i called psql. So it is my fault, a typically layer-8 - error. Thank you ;-) Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99