Problem with threads in Solaris 8 - Mailing list pgsql-general

From Tomas Berndtsson
Subject Problem with threads in Solaris 8
Date
Msg-id 80k7x399ah.fsf@junk.nocrew.org
Whole thread Raw
List pgsql-general
Hi,

I have a strange problem when using PostgreSQL in my multithreaded
(using pthreads) application under Solaris/SPARC 8. I use PostgreSQL
7.1.3. My program has 7 different threads, each connecting to the same
database in PostgreSQL. It works most of the times, but sometimes,
connecting fails with this:

error=connectDBStart() -- connect() failed: Inappropriate ioctl for device
        Is the postmaster running (with -i) at 'localhost'
        and accepting connections on TCP/IP port 5432?

PostgreSQL is accepting TCP/IP on port 5432, since it does work
sometimes. The errno message (Inappropriate ioctl for device) is not
always the same.

With the same version of PostgreSQL and my program, running in Linux,
everything always works as it should.

I have edited /etc/system to raise the shared memory variables, so
that's not the problem.


Has anyone else seen this in Solaris? I have no idea how I can find
out more about it, or what to do to avoid it.

Please help,


Tomas

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Re: Equate for "describe table" ?
Next
From: "Ian Harding"
Date:
Subject: Re: Probably simple answer