Обсуждение: PostgreSQL 7.1 (current release) - frequent errno:55 (buffer space error)
Hello, I am running PostgreSQL on a FreeBSD machine with 1 Gig of ram, and dual P3-733mhz CPUs. This server also runs Apache and is a production/web server. I frequently run into the errno:55 on my site, if I simply click refresh it goes away. Anyone have any ideas what is causing this, or how to fix it ? my shared_buffers are set to 4000, and max_connections to 300. I run postmaster with this command line: ./postmaster -Si -o -F -D /usr/local/pgsql/data/ Any help would be MUCH appreciated. Thanks, Keith Bussey kbussey@wisol.com
Keith Bussey <kbussey@wisol.com> writes: > I am running PostgreSQL on a FreeBSD machine with 1 Gig of ram, and dual > P3-733mhz CPUs. This server also runs Apache and is a production/web server. > I frequently run into the errno:55 on my site, if I simply click refresh it > goes away. Anyone have any ideas what is causing this, or how to fix it ? AFAIK there is no part of Postgres that would report something like "errno:55"; we prefer textual error messages ;-). No do I have the foggiest idea what you mean by "click refresh". I suspect your problem does not lie with Postgres but with some other software --- Apache maybe? regards, tom lane
* Tom Lane <tgl@sss.pgh.pa.us> [010511 00:13]: > Keith Bussey <kbussey@wisol.com> writes: > > I am running PostgreSQL on a FreeBSD machine with 1 Gig of ram, and dual > > P3-733mhz CPUs. This server also runs Apache and is a production/web server. > > > I frequently run into the errno:55 on my site, if I simply click refresh it > > goes away. Anyone have any ideas what is causing this, or how to fix it ? > It's a system error, I quote from man 2 intro --------------------------------------------------- 55 ENOBUFS No buffer space available. An operation on a socket or pipe was not performed because the system lacked sufficient buffer space or because a queue was full. --------------------------------------------------- which sounds like you're running low on system resources, is the box thrashing itself ot death when you get this error? (Take this off-list if you want as it sounds system related, not application-specific) > AFAIK there is no part of Postgres that would report something like > "errno:55"; we prefer textual error messages ;-). No do I have the > foggiest idea what you mean by "click refresh". I suspect your problem > does not lie with Postgres but with some other software --- Apache maybe? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl -- Alexander Graham Bell is alive and well in New York, and still waiting for a dial tone. Rasputin :: Jack of All Trades - Master of Nuns ::
I know pgaccess is one of the nicest interfaces? for those converting over from say msaccess use but are there utilities that will convert? a msaccess database for use in pgaccess..if not is it much of a chore to do so.... have fairly large database of clients/invoices so i'm wondering 'how much' will convert... thx lee -==
Lee, > I know pgaccess is one of the nicest interfaces? for those converting > over from say > msaccess use but are there utilities that will convert? a msaccess > database for use > in pgaccess..if not is it much of a chore to do so.... PgAccess's interface building tools are not complete at this time, nor are likely to be anytime soon that I know of. Further, it's pretty much impossible to convert an MSAccess interace directly into anything else. Database Creations makes a tool that converts MSAccess to Visual Basic, but not even that works 100% of the the time. The reccomended course of action, if you have an established MS Access application, is to convert your data to a PostgreSQL database, and keep your forms and interface code in MS Access, accessing PostgreSQL via ODBC. -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco