Re: 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches
От | Heikki Linnakangas |
---|---|
Тема | Re: 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches |
Дата | |
Msg-id | 457E9A4F.8090501@enterprisedb.com обсуждение исходный текст |
Ответ на | 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches pgAdmin) (Dave Page <dpage@postgresql.org>) |
Ответы |
Re: 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-bugs |
This bug seems to be introduced by this recent change to avoid memory leakage: > Log Message: > ----------- > Prevent intratransaction memory leak when a subtransaction is aborted > in the middle of executing a SPI query. This doesn't entirely fix the > problem of memory leakage in plpgsql exception handling, but it should > get rid of the lion's share of leakage. > > Modified Files: > -------------- > pgsql/src/backend/executor: > spi.c (r1.164 -> r1.165) > (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/spi.c.diff?r1=1.164&r2=1.165 I don't know that code too well, but somehow the tuptable memory context gets messed up / not free'd properly etc. Dave Page wrote: > The issue below was reported to us as a pgAdmin bug - it can be > recreated in psql on 8.2.0, and results in: > > 2006-12-12 09:06:50 LOG: server process (PID 4588) exited with exit > code -1073741819 > 2006-12-12 09:06:50 LOG: terminating any other active server processes > 2006-12-12 09:06:50 WARNING: terminating connection because of crash of > another server process > 2006-12-12 09:06:50 DETAIL: The postmaster has commanded this server > process to roll back the current transaction and exit, because another > server process exited abnormally and possibly corrupted shared memory. > 2006-12-12 09:06:50 HINT: In a moment you should be able to reconnect > to the database and repeat your command. > > In 8.1.5, it works as expected (ie. without crashing). > > Regards, Dave. > > -------- Original Message -------- > Subject: [pgadmin-support] Error craches pgAdmin > Date: Mon, 11 Dec 2006 20:11:39 +0100 > From: Paolo Saudin <paolo@ecometer.it> > To: <pgadmin-support@postgresql.org> > > Hi, > > I found a different pgAdmin behavior if I use it against Postgres > 8.1.15 or 8.2.0. Here to try it out > > I have a table filled with dates : > > CREATE TABLE _master_h24 ( > fulldate timestamp without time zone NOT NULL, > CONSTRAINT _master_h24_pkey PRIMARY KEY (fulldate) > ) WITHOUT OIDS; > > I have a function to fulfill it with dates : > > CREATE OR REPLACE FUNCTION fillmastertable_h24() > RETURNS timestamp without time zone AS > $BODY$ > declare > dt_now timestamp; > dt_last timestamp; > max_loops INTEGER; > v INTEGER; > BEGIN > > -- gets the last update > SELECT fulldate INTO dt_last FROM _master_h24 ORDER BY fulldate DESC > LIMIT 1; > > --RAISE NOTICE 'last : % ', dt_last; > -- gets the gmt - 1 hour date time > dt_now := to_timestamp(TIMEZONE('WAT',CURRENT_TIMESTAMP), > 'YYYY-MM-DD'); > > --RAISE NOTICE 'dt_now : % ', dt_now; > max_loops := 100; > v := 0; > > WHILE dt_last < dt_now AND v < max_loops loop > v := v + 1; > dt_last := dt_last + '24 HOUR'::INTERVAL; > > /* execute query */ > BEGIN > RAISE NOTICE 'Dt : % ', dt_last; > insert into _master_24 (fulldate) VALUES > (dt_last); /* Ã <- HERE IS THE TABLE MISSPELLING > (_master_24 ) */ > > /* errors check */ > EXCEPTION > /* in case of any error */ > WHEN OTHERS THEN RAISE NOTICE 'ERROR in fillmastertable_h24'; > END; > END loop; > return dt_last; > END; > $BODY$ > LANGUAGE 'plpgsql' VOLATILE; > > ALTER FUNCTION fillmastertable_h24() OWNER TO postgres; > > I then insert the first date to begin with : > > insert into _master_h24 (fulldate) VALUES ('2006-12-01'); -> OK > > I run the script : > > SELECT fillmastertable_h24(); > > And on Postgres 8.1.15 I get back âERROR: ârelation _master_24â does not > exist -> OK > > While on Postgres 8.2.0 I get back only â:â and pgAdmin craches loosing > the connection to the server. If I click on the server node I get the > following message box : > > An error has occurred: > > Server closed the connection unexpectedly > > This probably means the server terminated abnormally before or while > processing the request > > I donât know if depends on pgAdmin or the server itself. > > > Thanks, > > Paolo Saudin -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Dave PageДата:
Сообщение: 8.2 pl/pgsql crash bug (WAS: [pgadmin-support] Error craches pgAdmin)
Следующее
От: Alvaro HerreraДата:
Сообщение: Re: SPI_getvalue calls output function w/o pushing existing SPI connection + 2 extra issues