[Zope-DB] Psycopg & refreshing products

Federico Di Gregorio fog@initd.org
29 Jan 2003 15:52:27 +0100


--=-4x1YT0bj5emySQvlULYD
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Il mer, 2003-01-29 alle 15:28, Andrew Veitch ha scritto:
> OK, I've upgraded to psycopg-1.0.14 (I was on 1.0.13), I'm using Postgres
> 7.3.1 and Zope 2.6.0 and I'm still getting it. Sorry dumb of me to miss o=
ut
> the version numbers from a bug report.
>=20
> I do a select * from pg_stat_activity; after each refresh and I can see
> another connection has been created till I hit 20 when it fails.

mm.. how many threads in your zope? you get a different connection
object in every thread -> a new connection to the db on every refresh
until the maximum number of threads is reached.

--=20
/federico


--=-4x1YT0bj5emySQvlULYD
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQA+N+qrvcCgrgZGjesRAl/5AKCtEOj29FR8c37TFEuDw+QT4sj3oACfcw8T
/tV9H9ehrJ8GicvdEcoYpMg=
=zIhp
-----END PGP SIGNATURE-----

--=-4x1YT0bj5emySQvlULYD--