Question Re: Error: e87_create_diag_fifo when starting SAPdb in Technology Q&A

Error: e87_create_diag_fifo when starting SAPdb

Former Member — Mon, 02 Aug 2010 10:01:35 GMT

Greetings, I've just installed Content Server and SAPdb along with Apache.

We're on AIX 5.3 . By SAPDB is showing as "offline"

when I attempt to start I'm getting the following error:

sap01dad:/sapdb/programs/bin/> dbmcli -d CSD -u control,control db_start

ERR

-24994,ERR_RTE: runtime environment error

1,Check knldiag! Kernel died before reaching COLD state

The following Erors are in /sapdb/data/wrk/CSD/knldiag.err

2010-08-02 05:57:39 1 ERR 11309 IPC create_fifo: '/usr/spool/sql/fifo//pipecheck_CSD' chown error, Not owner

2010-08-02 05:57:39 1 ERR 11101 PIPE_IO Creating pipe /usr/spool/sql/fifo//pipecheck_CSD failed:Not owner

2010-08-02 05:57:39 1 ERR 11270 console e87_create_diag_fifo: chown error, Not owner

I've cleaned up semaphores, checked permissions, read posts until I'm blue in the face,,, Any ideas ?

I'm new to MAXdb/SAPDb, any help you can provide would be appricated.

Re: Error: e87_create_diag_fifo when starting SAPdb

lbreddemann — Mon, 02 Aug 2010 17:45:19 GMT

Hi there,

just a shot into the blue ... but could it be that the filesystem you installed the MaxDB software to does not support the SUID flag?

Like NFS or something?

If so, then this could explain the issue.

regards,

Lars

Re: Error: e87_create_diag_fifo when starting SAPdb

former_member229109 — Mon, 02 Aug 2010 20:37:45 GMT

Hello,

-> Did you already reported this issue in SAP message 0000628679/2010?

-> Please post the output of the commands:

ls u2013l /sapdb/CSD/db/pgm

ls u2013l /usr/spool/sql

ls u2013l /sapdb/data

dbmcli inst_enum

dbmcli db_enum

Regards, Natalia Khlopina

Re: Error: e87_create_diag_fifo when starting SAPdb

Former Member — Mon, 02 Aug 2010 20:55:49 GMT

Lars,,, Thanks for the reply. Not sure how to check that, but there's other files in the directory

that seem to be created via Pipe. Here's the permissions of the directory:

sap01dad:/var/spool/sql/> ls -l

total 0

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:14 config

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 dbspeed

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 diag

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 fifo

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:14 ini

drwxrwxrwx 4 sqdcsd sapsys 256 Aug 02 11:20 ipc

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:16 pid

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 ppid

sap01dad:/var/spool/sql/fifo/> ls -l

total 0

-rwxrwxrwx 1 csdcs sapsys 0 Aug 02 04:31 ckeckdone_CSD

prw-r----- 1 csdcs sapsys 0 Aug 02 05:41 xserver_logger

prw-r----- 1 csdcs sapsys 0 Aug 02 04:26 xserver_update

Re: Error: e87_create_diag_fifo when starting SAPdb

former_member229109 — Mon, 02 Aug 2010 21:00:27 GMT

-> Please post the output of the commands:

ls u2013l /sapdb/CSD/db/pgm

dbmcli inst_enum

dbmcli db_enum

Regards, Natalia Khlopina

Re: Error: e87_create_diag_fifo when starting SAPdb

Former Member — Mon, 02 Aug 2010 21:00:59 GMT

ls -l /sapdb/CSD/db/pgm

total 99016

-rwxrwxr-x 1 sqdcsd sapsys 452497 Aug 05 2003 backup

-rwxrwxr-x 1 sqdcsd sapsys 176985 Aug 05 2003 clr_kernel

-rwxrwxr-x 1 sqdcsd sapsys 301486 Aug 05 2003 console

-r-sr-sr-x 1 sqdcsd sapsys 2897407 Aug 05 2003 dbmsrv

-rwxrwxr-x 1 sqdcsd sapsys 2014090 Aug 05 2003 diagnose

-rwxrwxr-x 1 sqdcsd sapsys 7865228 Aug 05 2003 kernel

-rwxrwxr-x 1 sqdcsd sapsys 2312801 Aug 05 2003 load

-r-sr-x--- 1 sqdcsd sapsys 4235769 Aug 05 2003 lserver

-rwxrwxr-x 1 sqdcsd sapsys 1621257 Aug 05 2003 pu

-rwxrwxr-x 1 sqdcsd sapsys 1223250 Aug 05 2003 python

-rwxrwxr-x 1 sqdcsd sapsys 9143032 Aug 05 2003 quickknl

-rwxrwxr-x 1 sqdcsd sapsys 47864 Aug 05 2003 regcomp

-rwxrwxr-x 1 sqdcsd sapsys 14734685 Aug 05 2003 slowknl

-rwxrwxr-x 1 sqdcsd sapsys 1612928 Aug 05 2003 sqlfilter

-rwxrwxr-x 1 sqdcsd sapsys 33315 Aug 05 2003 sysrc

-rwxrwxr-x 1 sqdcsd sapsys 72871 Aug 05 2003 tracesort

-rwxrwxr-x 1 sqdcsd sapsys 1802446 Aug 05 2003 wizard

-rwxrwxr-x 1 sqdcsd sapsys 106862 Aug 05 2003 wiztrc

sap01dad:/usr/spool/sql/> ls -l

total 0

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:14 config

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 dbspeed

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 diag

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 fifo

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:14 ini

drwxrwxrwx 4 sqdcsd sapsys 256 Aug 02 11:20 ipc

drwxrwxrwx 2 sqdcsd sapsys 256 Jul 21 05:16 pid

drwxrwxrwx 2 sqdcsd sapsys 256 Aug 02 11:20 ppid

sap01dad:/usr/spool/sql/> ls -l /sapdb/data

total 16

drwxrwxr-x 3 sqdcsd sapsys 4096 Aug 02 16:11 config

drwxrwxr-x 7 sqdcsd sapsys 4096 Aug 02 05:41 wrk

sap01dad:/sapdb/programs/bin/> dbmcli inst_enum

7.3.0.42 /sapdb/CSD/db

sap01dad:/sapdb/programs/bin/> dbmcli db_enum

CSD /sapdb/CSD/db 7.3.0.42 fast offline

CSD /sapdb/CSD/db 7.3.0.42 slow offline

CSD /sapdb/CSD/db 7.3.0.42 quick offline

Re: Error: e87_create_diag_fifo when starting SAPdb

former_member229109 — Mon, 02 Aug 2010 21:57:25 GMT

Hello,

You posted:

ls -l /sapdb/CSD/db/pgm

...

-r-sr-sr-x 1 sqdcsd sapsys 2897407 Aug 05 2003 dbmsrv

...

-r-sr-x--- 1 sqdcsd sapsys 4235769 Aug 05 2003 lserver

...

==>

Run first:

cd /sapdb/CSD/db/pgm

chown root dbmsrv

chown root lserver

chmod 4755 dbmsrv

chmod 4755 lserver

After that try :

dbmcli -d CSD -u control,control db_warm

Regards, Natalia Khlopina

Re: Error: e87_create_diag_fifo when starting SAPdb

Former Member — Tue, 03 Aug 2010 07:46:02 GMT

THANK YOU, THANK YOU, THANK YOU.

I don't know why the Content Server Install didn't set the permissions to these programs properly,

but your permissions suggestions worked... Here's my status now.

sap01dad:/sapdb/programs/bin/> dbmcli -d CSD -u control,control db_state

State

WARM

sap01dad:/sapdb/programs/bin/> dbmcli -d CSD -u control,control db_enum

CSD /sapdb/CSD/db 7.3.0.42 fast running

CSD /sapdb/CSD/db 7.3.0.42 slow offline

CSD /sapdb/CSD/db 7.3.0.42 quick offline

I assume these Kernel states are ok ? I'm now able to connect my Conten Repository in SAP.