Re: [GENERAL] Warning "TupleDesc reference leak"

[Marek Lewczuk]

Marek Lewczuk pisze:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING:  TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x4203d908 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fdc410 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fbb568 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x42044bf0 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x42038e60 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41feebc0 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fa0018 (16425,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fd9c30 (16425,-1) 
still referenced

Hello again,
after suggestions that I should postgres update to the latest (currently 
I have 8.2.3) I thought that my problem will be solved. But no, it is 
not - postgres still throws warnings:
WARNING:  TupleDesc reference leak: TupleDesc 0x41fd7018 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41f42490 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fc3490 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x4200c880 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x42023400 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41f48728 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x4201d728 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41ffd8b0 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41fe8370 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x420329e8 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x420026b0 (16427,-1) 
still referenced
WARNING:  TupleDesc reference leak: TupleDesc 0x41f8de78 (16427,-1) 
still referenced

What does it mean ? Thanks in advance for help.

ML



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend