Error: e87_create_diag_fifo when starting SAPdb

[Former Member]

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.

[former_member229109 · Accepted solution]

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

[Former Member · Accepted solution]

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

OK

7.3.0.42 /sapdb/CSD/db

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

OK

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

[former_member229109 · Accepted solution]

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

[Former Member · Accepted solution]

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

OK

State

WARM

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

OK

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.