• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Generated SQL failing to execute cleanly with PostgreSQL: a fix
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Generated SQL failing to execute cleanly with PostgreSQL: a fix


  • Subject: Generated SQL failing to execute cleanly with PostgreSQL: a fix
  • From: Paul Hoadley <email@hidden>
  • Date: Wed, 14 May 2008 20:36:27 +0930

Hello,

[This post is merely to document a fix. A search for '"connection limit exceeded for non-superusers" site:lists.apple.com' yielded nothing, so here's a solution for the list archive.]

I'm using WOLips 5165, WO 5.4, and PostgreSQL 8.2.5. I first noticed this problem when I upgraded to WOLips 5047, and I had hoped going to 5165 today would fix it, but it persisted.

When I generated SQL from an EO model and hit "Execute SQL" from within Entity Modeler, it regularly failed with the following error: "FATAL: connection limit exceeded for non-superusers." (I couldn't determine if there was a pattern to where or when it was failing, but on some models, it would never execute to completion without this error.) This can be fixed by increasing 'max_connections' in postgresql.conf. In my installation, that parameter was originally 30, and I increased it to 50. I had to also _decrease_ 'shared_buffers' (from 2400kB to 1200kB), or PostgreSQL would not start, failing to get a large enough shared memory segment from the OS. In any case, 1200kB still exceeded the recommended minimum as noted in that file ("min 128kB or max_connections*16kB").

As an aside, could anyone suggest why this error would occur? Is Entity Modeler (or more likely, I suppose, the JDBC layer) executing some of these generated SQL statements concurrently, and hence exceeding 30 connections?


-- Paul.

w  http://logicsquad.net/
h  http://paul.hoadley.name/


_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
      • From: Mike Schrag <email@hidden>
  • Prev by Date: Servlet Deployment Problem on Tomcat
  • Next by Date: Re: takeFormValuesFromRequest problem
  • Previous by thread: Re: Servlet Deployment Problem on Tomcat [SOLVED]
  • Next by thread: Re: Generated SQL failing to execute cleanly with PostgreSQL: a fix
  • Index(es):
    • Date
    • Thread