Error: e87_create_diag_fifo when starting SAPdb

[#1]

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.

[lbreddemann]

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

[Former Member]

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

[former_member229109]

-> Please post the output of the commands:

ls u2013l /sapdb/CSD/db/pgm

dbmcli inst_enum

dbmcli db_enum

Regards, Natalia Khlopina