If you are using the torque classinc pool, switch to the jdbc2 pool. -------------------------------------------- Quinton McCombs NequalsOne - HealthCare marketing tools mailto:[EMAIL PROTECTED] http://www.NequalsOne.com
> -----Original Message----- > From: Zamek [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 3:32 PM > To: Turbine Users List > Subject: Turbine doesn't close database connection > > > Hi All, > > I am using postgresql in Debian Linux 3.0 (unstable) with : > java version "1.3.0" > Java(TM) 2 Runtime Environment, Standard Edition (build > 1.3.0) Classic VM (build 1.3.0, J2RE 1.3.0 IBM build > cx130-20010925 (JIT enabled: > jitc)) > > When a user session closed (after 30 min) turbine doesn't > close opened > postgres connection: > [EMAIL PROTECTED]:~$ ps aux | grep post > postgres 32474 0.0 0.4 16068 2180 ? S Mar15 0:00 > /usr/lib/postgresql/bin/postmaster > postgres 32475 0.0 0.4 17060 2160 ? S Mar15 > 0:00 postgres: > stats buffer process > postgres 32478 0.0 0.4 16116 2208 ? S Mar15 > 0:00 postgres: > stats collector process > postgres 32486 0.0 0.9 16932 4928 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 32507 0.0 0.8 16908 4380 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 32555 0.0 0.9 16968 4648 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 32576 0.0 0.7 16808 3992 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 32666 0.0 0.9 16940 4764 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 708 0.0 0.8 16816 4188 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 709 0.0 0.9 16932 4640 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 710 0.0 0.8 16908 4308 ? S Mar15 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 2052 0.0 0.8 16840 4256 ? S Mar16 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 5925 0.0 0.9 16940 4804 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 5926 0.0 0.8 16908 4364 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 6162 0.0 0.9 16932 4700 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 6163 0.0 0.7 16816 4084 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 6269 0.0 0.8 16816 4188 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 6604 0.0 0.8 16816 4184 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > postgres 6605 0.0 0.8 16932 4596 ? S Mar18 > 0:00 postgres: > postgres vili 127.0.0.1 idle > > ther are _very_ old connections in idle status. > What do I have to do to close unecessary connections? > Are there any special porperties in TR.properties or > Torque.properties? > > -- > thx, > ---------------------------------------------------- > Zoltan Zidarics programmer > PTE University Pecs, Hungary > icq: 43288694 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
