PQExec returns null question

Donald Carlile <[email protected]> Mon, 20 Oct 2014 09:53:20 -0700
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <[email protected]>
Our OS X application uses PostgreSQL as a back end through pqlib. Some of o=
ur customers are reporting occasional PGRES_FATAL_ERRORs, but PQresultError=
Message returns a blank string. I have looked at the sources, and as far as=
 I can tell, this condition can only occur when PQExec returns a null. The =
docs say that this shouldn=92t happen except in out of memory conditions. I=
 am not using any Copy actions.

I have two broad questions. 1) What can I do to prevent this from happening=
? 2) If it does happen, how can I remedy it?

I have increased the shared memory, and that seems to have helped somewhat,=
 but it still occurs. In our experience, once this starts happening, it con=
tinues for every subsequent query.  WE have found that restarting the machi=
ne will remedy it for a time, but is there a less drastic action we can tak=
e that will also remedy it? Perhaps stopping and starting PostgreSQL? Or ar=
e system resources being consumed to the level that a system restart is req=
uired?

Many Thanks,
Don Carlile

--=20
Sent via pgsql-interfaces mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces