Memory leak detected

Started by Diego Zuccatoover 23 years ago2 messagesbugs
Jump to latest
#1Diego Zuccato
diego@otello.alma.unibo.it

Hello.

I found that strange behaviour:

gsbusb=# select g.cod, (select count(*) from scatt where grotta=g.cod)
as att, count(*) from grotte g, immagine i, scatt a where
i.scattata_in=g.cod group by g.cod, att;
NOTICE: PortalHeapMemoryFree: 0x0x8233790 not in alloc set!
NOTICE: Buffer Leak: [056] (freeNext=-3, freePrev=-3, relname=scatt,
blockNum=0, flags=0x4, refcount=-2 -1)
cod | att | count
-----+-----+-------
3 | 1 | 2
140 | 0 | 36
187 | 0 | 32
270 | 0 | 2
271 | 0 | 34
272 | 0 | 18
273 | 0 | 26
(7 rows)

Hope it's useful info. If you need more, please mail me (I'm not
subscribed).

Tks for the wonderful product!

BYtE,
Diego.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Diego Zuccato (#1)
Re: Memory leak detected

Diego Zuccato <diego@otello.alma.unibo.it> writes:

NOTICE: PortalHeapMemoryFree: 0x0x8233790 not in alloc set!

I'd suggest updating to a newer version of Postgres. That's got to be
7.0 or older.

regards, tom lane