Connection to postgres DBMS leaking

[Andrei Aiordachioaie]

It seems that every rasql query executes opens up a new postgresql connection, and never closes it before exiting. After a couple of hundreds of queries, the postgres DBMS decides to halt because the maximum number of connections has been reached.

Tested with the git repository version of rasdaman (8.1), on 2009-11-09.

Attached is a script that executes lots of rasql queries.

[Andrei Aiordachioaie]

Executes lots of rasql queries

[Even Rouault <even.rouault@…>]

I can confirm the bug that I also see when using the new GDAL rasdaman driver.

At each run of gdalinfo "rasdaman:query='select a[\$x_lo:\$x_hi,\$y_lo:\$y_hi] from rgb as a'", a new PG connection is left idle. So if I run the above command 11 times, I get :

postgres  4864  1332  0 09:41 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4877  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4883  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4886  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4889  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4892  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4895  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4898  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4901  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4904  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle                                                                                      
postgres  4907  1332  0 09:42 ?        00:00:00 postgres: even RASBASE [local] idle

After about 96 attempts, I get the following errors :

ERROR 1: Serialisable exception r_Ebase_dbms: error in base DBMS.

and the next attempt :

ERROR 1: RasManager Error: Write transaction in progress, please retry again later.

After that, the only way to connect again is ./stop_rasdaman.sh && ./start_rasdaman.sh

My configuration : Ubuntu 10.04 64bit, postgresql-8.4 (8.4.4-0ubuntu10.04) and a rasdaman git tree pulled on the 2010-09-03

[Peter Baumann]

fixed by patch to reladminif/database.pgc.