SQL*Backtrack, semaphores, and 7264's

From: Wiegand, Kurt <Kurt.Wiegand_at_CWUSA.COM>
Date: Mon, 21 Jan 2002 08:13:59 -0800
Message-ID: <F001.003F5E67.20020121073548@fatcity.com>

Has anyone seen anything similar to the following:

After Installing SQL*Backtrack on a Solaris 2.6 box, one of the databases on that box started coming down with 7264 errors a couple of times a week. This is an 8.0.5.2.1 database and it is not the database being accessed by SQL*Backtrack.

In an effort to debug, we issued an ipcs command prior to and after executing
an export via sql*backtrack. After the export of database A, the semaphore set for database B was gone, and it came tumbling down with the 7264 error

Mon Jan 21 04:05:52 2002
DBW0: terminating instance due to error 7264

07264, 00000, "spwat: semop error, unable to decrement semaphore." // *Cause: Semop system call returned an error. Semaphore set may not exist.

// *Action: Check errno. Semaphore ID is returned in sercose[0]. Verify 
//          semaphore set exists. A possible cause for this error is that a
//          "shutdown abort" was done while this process was running.

we ran the export at 4:00 and it finished at 4:01

cobra:/var/adm/sa> sar -m -f sa21

SunOS cobra 5.6 Generic_105181-29 sun4u 01/21/02

00:00:01   msg/s  sema/s
03:00:01    0.00   10.20
03:15:00    0.00   13.46
03:30:00    0.00   10.05
03:45:00    0.00   10.05
04:00:00    0.00   10.03
04:15:00    0.00 16116.36
04:30:00    0.00    9.94
04:45:01    0.00   69.34
05:00:00    0.00   14.37
05:15:00    0.00    9.97
05:30:00    0.00    9.97
05:45:01    0.00    9.97

Thanks

Kurt Wiegand

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Wiegand, Kurt
INET: Kurt.Wiegand_at_CWUSA.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 21 2002 - 10:13:59 CST