Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4

From: Oisin Glynn <me(at)oisinglynn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4
Date: 2007-01-08 19:33:54
Message-ID: 45A29CA2.8080003@oisinglynn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running postgres on Windows XP and have been for quite a while as

the database engine for our application.

On an ODBC connection the following error has started happening. The gap
in activity is normal for our application. but the connection failing is
a first we have this application live in approx 5 locations some for as
long as 12 months (though only 2 live are on XP)

We did enable the system to check for Windows updates automatically
recently not sure if this could be a factor.
There is another one of our apps connecting through the C++ API which is
not seeing any loss of service. I suspect some sort of tcp-ip issue as
I cannot connect with PgAdminIII locally on the server once the
condition occurs. I have had this 3 times now and it seems to be
happening very 2-3hours of operation. I am not getting any eventvwr or
other Windows errors telling me I am hitting a limit or such? And when
I restarted the Postgresql service I got the following as part of my
log(See attached logs)

2007-01-05 14:38:28 LOG: pgpipe failed to bind: 10055i
2007-01-05 14:38:28 FATAL: could not create pipe for statistics buffer:
No error

I am attaching my postgresql.conf (perhaps I can turn on some more
logging to make things easier to spot) and the log files I have from the
first occurrence. These show my attempts to restart the postgresql
service and the errors I received.

This is a snipit of my applications log file showing the error pop up at
14:11:07

01/05/07 13:58:57.453 2296 DEBUG - Call No: 10131 SELECT SQL =
SELECT * FROM zfunc_access_mailbox_cleanup(10131)
01/05/07 13:58:57.468 2296 DEBUG - Call No: 10131 SELECT Complete
Return Code = $VC1
01/05/07 13:58:57.468 2296 DEBUG - BX_SVR_TRP009 Sent TRP_IVR_ODBCOK
for call no= 10131
01/05/07 13:58:57.484 2296 DEBUG - Call No: 10131 DISCONNECT
01/05/07 13:58:57.484 2296 DEBUG - Call No: 10131 DISCONNECT Free
Statement Handle
01/05/07 13:58:57.484 2296 DEBUG - Call No: 10131DISCONNECT OK Voicemail
01/05/07 13:58:57.484 2296 DEBUG - BX_SVR_TRP009 Sent TRP_IVR_ODBCOK
for call no= 10131
01/05/07 14:11:07.734 2296 DEBUG - Call No: 10132 CONNECT Voicemail
01/05/07 14:11:07.734 2296 DEBUG - Call No: 10132 CONNECT Allocate DBC
Handle Voicemail
01/05/07 14:11:07.734 2296 DEBUG - Call No: 10132 CONNECT Connect
Voicemail
01/05/07 14:11:07.750 2296 DEBUG - Call No: 10132CONNECT SQLConnect
failed 08001 could not connect to server: No buffer space available
(0x00002747/10055)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
Error Message = 165Voicemail

If there is anything I can do to generate better logging I am all ears,

Oisin

Attachment Content-Type Size
postgresql.conf text/plain 13.4 KB
postgresql-2007-01-05_143702.log text/plain 1.1 KB

Browse pgsql-general by date

  From Date Subject
Next Message Matt Miller 2007-01-08 19:34:51 Re: Command "connect by prior" in PostgreSQL ?
Previous Message Ron Mayer 2007-01-08 19:11:05 Re: Advice needed on using postgres in commercial product