pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBackend crash
8+ messages / 4 participants
[nested] [flat]
* Backend crash
@ 2000-01-24 16:14 Mark Volpe <volpe.mark@epamail.epa.gov>
0 siblings, 0 replies; 8+ messages in thread
From: Mark Volpe @ 2000-01-24 16:14 UTC (permalink / raw)
To: pgsql-sql
The following sequence causes PostgreSQL to
crash on my Linux box:
-- Any example table here will do
CREATE TABLE numbers ( value int );
INSERT INTO numbers VALUES(1);
INSERT INTO numbers VALUES(2);
INSERT INTO numbers VALUES(3);
INSERT INTO numbers VALUES(4);
-- Now the crash sequence
BEGIN;
SELECT * INTO TEMP numbers2 FROM numbers;
SELECT * FROM numbers2;
-- Bang!!! --
Can anybody reproduce this?
Thanks,
Mark
^ permalink raw reply [nested|flat] 8+ messages in thread
* Backend crash
@ 2000-01-24 16:25 Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 17:16 ` Re: [SQL] Backend crash Tom Lane <tgl@sss.pgh.pa.us>
2000-01-24 17:17 ` Re: [SQL] Backend crash Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 2 replies; 8+ messages in thread
From: Mark Volpe @ 2000-01-24 16:25 UTC (permalink / raw)
To: pgsql-sql
The following sequence causes PostgreSQL to
crash on my Linux box:
-- Any example table here will do
CREATE TABLE numbers ( value int );
INSERT INTO numbers VALUES(1);
INSERT INTO numbers VALUES(2);
INSERT INTO numbers VALUES(3);
INSERT INTO numbers VALUES(4);
-- Now the crash sequence
BEGIN;
SELECT * INTO TEMP numbers2 FROM numbers;
SELECT * FROM numbers2;
-- Bang!!! --
Can anybody reproduce this?
Thanks,
Mark
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
2000-01-24 16:25 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
@ 2000-01-24 17:16 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-01-24 18:58 ` Re: [SQL] Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
1 sibling, 1 reply; 8+ messages in thread
From: Tom Lane @ 2000-01-24 17:16 UTC (permalink / raw)
To: Mark Volpe <volpe.mark@epamail.epa.gov>; +Cc: pgsql-sql
Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> BEGIN;
> SELECT * INTO TEMP numbers2 FROM numbers;
> SELECT * FROM numbers2;
> -- Bang!!! --
> Can anybody reproduce this?
Yah :-(. There are several nasty bugs in 6.5.*'s support for TEMP
tables. We believe they are all fixed for 7.0, but the changes are
intertwined with a lot of other stuff, and so back-patching the fixes
didn't look very practical.
The only good news is that 7.0 goes beta next week...
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
2000-01-24 16:25 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 17:16 ` Re: [SQL] Backend crash Tom Lane <tgl@sss.pgh.pa.us>
@ 2000-01-24 18:58 ` Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 19:08 ` Re: [SQL] Backend crash Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Mark Volpe @ 2000-01-24 18:58 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
Thanks, guys!
SELECT * INTO <good-old-unique-name-based-on-process-id> ...
works just fine for me :-)
Tom Lane wrote:
>
> Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> > BEGIN;
> > SELECT * INTO TEMP numbers2 FROM numbers;
> > SELECT * FROM numbers2;
> > -- Bang!!! --
> > Can anybody reproduce this?
>
> Yah :-(. There are several nasty bugs in 6.5.*'s support for TEMP
> tables. We believe they are all fixed for 7.0, but the changes are
> intertwined with a lot of other stuff, and so back-patching the fixes
> didn't look very practical.
>
> The only good news is that 7.0 goes beta next week...
>
> regards, tom lane
>
> ************
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
2000-01-24 16:25 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 17:16 ` Re: [SQL] Backend crash Tom Lane <tgl@sss.pgh.pa.us>
2000-01-24 18:58 ` Re: [SQL] Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
@ 2000-01-24 19:08 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Bruce Momjian @ 2000-01-24 19:08 UTC (permalink / raw)
To: Mark Volpe <volpe.mark@epamail.epa.gov>; +Cc: pgsql-sql
> Thanks, guys!
>
> SELECT * INTO <good-old-unique-name-based-on-process-id> ...
> works just fine for me :-)
There is a section in my book about it.
>
> Tom Lane wrote:
> >
> > Mark Volpe <volpe.mark@epamail.epa.gov> writes:
> > > BEGIN;
> > > SELECT * INTO TEMP numbers2 FROM numbers;
> > > SELECT * FROM numbers2;
> > > -- Bang!!! --
> > > Can anybody reproduce this?
> >
> > Yah :-(. There are several nasty bugs in 6.5.*'s support for TEMP
> > tables. We believe they are all fixed for 7.0, but the changes are
> > intertwined with a lot of other stuff, and so back-patching the fixes
> > didn't look very practical.
> >
> > The only good news is that 7.0 goes beta next week...
> >
> > regards, tom lane
> >
> > ************
>
> ************
>
>
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
2000-01-24 16:25 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
@ 2000-01-24 17:17 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 8+ messages in thread
From: Bruce Momjian @ 2000-01-24 17:17 UTC (permalink / raw)
To: Mark Volpe <volpe.mark@epamail.epa.gov>; +Cc: pgsql-sql
> The following sequence causes PostgreSQL to
> crash on my Linux box:
>
> -- Any example table here will do
>
> CREATE TABLE numbers ( value int );
> INSERT INTO numbers VALUES(1);
> INSERT INTO numbers VALUES(2);
> INSERT INTO numbers VALUES(3);
> INSERT INTO numbers VALUES(4);
>
> -- Now the crash sequence
>
> BEGIN;
> SELECT * INTO TEMP numbers2 FROM numbers;
> SELECT * FROM numbers2;
>
> -- Bang!!! --
>
> Can anybody reproduce this?
Fixed in current source tree. We had some problems with temp tables
created inside transactions. Next release will fix this.
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
@ 2000-01-24 20:58 Alain TESIO <alain_tesio@yahoo.com>
2000-01-24 22:31 ` Re: [SQL] Backend crash Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Alain TESIO @ 2000-01-24 20:58 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql
> Fixed in current source tree. We had some problems with temp
> tables created inside transactions. Next release will fix this.
Will this be allowed ? It's forbidden in Sybase for example.
Will a rollback delete the table ? Maybe if modification of
system tables are logged too ?
Alain
=====
signoff
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [SQL] Backend crash
2000-01-24 20:58 Re: [SQL] Backend crash Alain TESIO <alain_tesio@yahoo.com>
@ 2000-01-24 22:31 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Bruce Momjian @ 2000-01-24 22:31 UTC (permalink / raw)
To: tesio@easynet.fr; +Cc: pgsql-sql
> > Fixed in current source tree. We had some problems with temp
> > tables created inside transactions. Next release will fix this.
>
> Will this be allowed ? It's forbidden in Sybase for example.
> Will a rollback delete the table ? Maybe if modification of
> system tables are logged too ?
Good question:
test=> BEGIN;
BEGIN
test=> CREATE TEMP TABLE test(x int);
CREATE
test=> INSERT INTO test VALUES (1);
INSERT 18729 1
test=> ABORT;
ABORT
test=> SELECT * FROM test;
ERROR: Relation 'test' does not exist
Man, are we good, or what?
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2000-01-24 22:31 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-24 16:14 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 16:25 Backend crash Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 17:16 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-01-24 18:58 ` Mark Volpe <volpe.mark@epamail.epa.gov>
2000-01-24 19:08 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-01-24 17:17 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-01-24 20:58 Re: [SQL] Backend crash Alain TESIO <alain_tesio@yahoo.com>
2000-01-24 22:31 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox