Re: "No response from the backend" error while connecting to postgres db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org, "Gaurav Katiyar" <gaurav(dot)katiyar(at)globallogic(dot)com>
Subject: Re: "No response from the backend" error while connecting to postgres db
Date: 2009-09-17 14:14:29
Message-ID: 10190.1253196869@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

"tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com> writes:
> pg_log file logs the below messages :
> GMT FATAL: semop(id=1310723) failed: Invalid argument
> GMT FATAL: semctl(1310723, 7, SETVAL, 0) failed: Invalid argument
> GMT LOG: semctl(1245185, 0, IPC_RMID, ...) failed: Invalid argument
> GMT LOG: shmctl(2097152, 0, 0) failed: Invalid argument

It sure looks like something tried to kill off all your SysV resources
(semaphores and shared memory). Look around and find out if anyone
was doing something with ipcrm, and take away their root privileges
if so.

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ken Sell 2009-09-17 17:44:26 Re: Not able to connect from Informatica
Previous Message the6campbells 2009-09-17 12:10:01 SQLNumResultCol set to 0 for query using common table expression