0 Replies Latest reply on Jul 6, 2004 3:29 AM by s_raghavan

    postgresql/jboss - out of memory problem

    s_raghavan

      we are using postgresql 7.3 and jboss 3.2.3 to deploy ejbs(bmp)
      while running some(big) queries connection is lost with the following error message on the jboss server:


      C:\Program Files\PostgreSQL\bin>
      LOG: database system was shut down at 2004-07-0
      2 18:10:42 IST
      LOG: checkpoint record is at 0/CD924D0
      LOG: redo record is at 0/CD924D0; undo record is at 0/0; shutdown TRUE
      LOG: next transaction id: 115962; next oid: 223462
      LOG: database system is ready
      FATAL: unsupported frontend protocol
      LOG: server process (pid 1720) was terminated by signal 11
      LOG: terminating any other active server processes
      LOG: all server processes terminated; reinitializing shared memory and semaphores
      IpcMemoryCreate: shmget(key=5432001, size=1007616, 03600) failed: Not enough core

      This error usually means that PostgreSQL's request for a shared
      memory segment exceeded available memory or swap space.
      To reduce the request size (currently 1007616 bytes), reduce
      PostgreSQL's shared_buffers parameter (currently 64) and/or
      its max_connections parameter (currently 5).

      The PostgreSQL Administrator's Guide contains more information about
      shared memory configuration.

      tried changing max connections and buffers parameter, no use. what to do