Обсуждение: Getting::message type 0x43 arrived from server while idle

Hi All,

I am using the postgres database in one of my project.
 I am getting "message type 0x43 arrived from server while idle"  messages
 while querying the database and getting erroneous results.

I am using libpq library for querying database.
I am having two different processes accessing the same database.

I am hoping to read soon.

Regards,
Rashid

Mohammed Rashid <mail4rashid@gmail.com> writes:
>  I am getting "message type 0x43 arrived from server while idle"  messages
>  while querying the database and getting erroneous results.

> I am using libpq library for querying database.
> I am having two different processes accessing the same database.

I'll bet what you're really doing is using two different threads within
the same process, and trying to have those threads concurrently issue
commands through the same connection (same PGconn object).  This does
not work.  Give each thread its own connection.  Also read
http://www.postgresql.org/docs/8.4/static/libpq-threading.html

            regards, tom lane

Mohammed Rashid <mail4rashid@gmail.com> wrote:

> I am getting "message type 0x43 arrived from server while idle"
> messages while querying the database and getting erroneous
> results.
>
> I am using libpq library for querying database.
> I am having two different processes accessing the same database.

More details would help.  For some ideas on what might enable us to
help you, please check the "Things you need to mention" section at:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

On Dec 23, 2009, at 7:36 AM, Mohammed Rashid wrote:

> I am using the postgres database in one of my project.
>  I am getting "message type 0x43 arrived from server while idle"  messages
>  while querying the database and getting erroneous results.
>
> I am using libpq library for querying database.
> I am having two different processes accessing the same database.

Are you using a different connection for each process?




John DeSoi, Ph.D.