"Maximum number of conections exceeded" when connnecting via Postgres ODBC
От | Andy Kelk |
---|---|
Тема | "Maximum number of conections exceeded" when connnecting via Postgres ODBC |
Дата | |
Msg-id | 2BA3903C0E9C284F9AA18B2E123CF5ED2DA29D@VENDAC01.uk.venda обсуждение исходный текст |
Список | pgsql-odbc |
Hi, I have a Windows 2000 Server that is running some queries from an ASP page. It uses the ODBC driver to connect to a Postgres database running on a Linux machine. Most of the time the ASP page works fine but after a while of the machine being live I get the an error connecting complaining about errors in SQLAllocHandle. When I run the commlog I get the following lines: ENVIRON ERROR: func=PGAPI_AllocConnect, desc='', errnum=1, errmsg='Maximum number of connections exceeded.' CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=1209', errnum=205, errmsg='Unknown connect option (Get)' ------------------------------------------------------------ henv=50597728, conn=168672848, status=1, num_stmts=16 sock=50600880, stmts=50600800, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=3028, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=168638632, buffer_out=168642736 buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63 Rebooting the machine solves this problem. At the same time as getting the error above I repeatedly try connecting to the database from the Linux machines and there is no problem. Does anyone have any experience of a similar problem or have any advice? Thanks Andy
В списке pgsql-odbc по дате отправления: