Hi All,

3.0.2 (hp2.us5/109) on hp 11i

We changed some parameters in CBF and I am wondering it caused
pthread_create() failed .

Starting the Recovery Server...
II_DBMS_SERVER = 59046
Starting the Archiver Process...
Starting DBMS Server (default)...

Ingres cannot continue starting other processes.

errlog.log:
Cannot open iiuser table.
pthread_create() failed with operating system error 12 (Not enough space


Any suggestion would be highly appreciated.

Thanks.

Frank Fan wrote:
> 3.0.2 (hp2.us5/109) on hp 11i
>
> We changed some parameters in CBF and I am wondering it caused
> pthread_create() failed .
>
> Starting the Recovery Server...
> II_DBMS_SERVER = 59046
> Starting the Archiver Process...
> Starting DBMS Server (default)...
>
> Ingres cannot continue starting other processes.
>
> errlog.log:
> Cannot open iiuser table.
> pthread_create() failed with operating system error 12 (Not enough space

Look up O/S error 12. Perhaps something to do with swap or maximum
process size. Perhaps there are O/S logs to look at, too.

On 6/3/05, Frank Fan <jun_fan4@agilent.com> wrote:
> Hi All,
>
> 3.0.2 (hp2.us5/109) on hp 11i
>
> We changed some parameters in CBF and I am wondering it caused
> pthread_create() failed .
>
> Starting the Recovery Server...
> II_DBMS_SERVER = 59046
> Starting the Archiver Process...
> Starting DBMS Server (default)...
>
> Ingres cannot continue starting other processes.
>
> errlog.log:
> Cannot open iiuser table.
> pthread_create() failed with operating system error 12 (Not enough space
>
>

Which parameters did you change?

pthread_create is trying to create a new thread and OS error 12 means
it's hitting some kind of limit. Probably a per-user or per-process
thread limit.

I suspect your CBF changes either directly or indirectly increased the
number of threads Ingres tries to create. Did you increase the number
of log_writers?

--
Paul Mason