Unanswered: ASE 12.5.1 SQL Server system exception
I am running into the following error after my system (windows 200 advanced server) got powered down unexpectedly. This error is being written to the C:\sybase\ASE-12_5\init\logs\log0616.001 file.
06/16/04 00:14:09 AM SyBatch/12.5.1/P/PC INTEL/Windows NT 4.0/4/OPT
06/16/04 00:14:09 AM Confidential property of Sybase, Inc.
Copyright Sybase Inc., 1996 - 2003.
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws
This software contains confidential and trade secret
information of Sybase, Inc. Use, duplication, or diclosure
of the software and documentation by the U.S. Government
is subject to restrictions as set forth in a license
between the Government and Sybase,Inc. or other written
agreement specifying the Government's rights to use the
software and any applicable FAR provisions, for example,
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA.
06/16/04 00:14:09 AM BEGIN ENVIRONMENT INFORMATION
current directory: C:\Program Files\SybaseASE12.5.1
character set: iso_1
auditinit release directory: C:\sybase
working release directory: C:\sybase
06/16/04 00:14:09 AM END ENVIRONMENT INFORMATION
06/16/04 00:14:10 AM Using resource file 'C:\sybase\ASE-12_5\sqlsrv.res' for
06/16/04 00:14:10 AM Running task: update Sybase Server entry in interfaces
06/16/04 00:14:10 AM Task succeeded: update Sybase Server entry in interfaces
06/16/04 00:14:10 AM Running task: create the master device.
06/16/04 00:14:11 AM Calling the shell with 'C:\sybase\ASE-12_5\bin\sqlsrvr.exe
-dC:\sybase\data\master.dat -b30M -z2048
06/16/04 00:14:21 AM Calling the shell with '1 = return code.'.
06/16/04 00:14:21 AM Done
06/16/04 00:14:21 AM Begin output from 'sqlsrvr':
00:00000:00000:2004/06/16 00:14:12.25 kernel Registry keys for event logging are missing.
00:00000:00000:2004/06/16 00:14:12.49 kernel Checked out license ASE_DEV
00:00000:00000:2004/06/16 00:14:12.53 kernel Adaptive Server Enterprise Developer Edition.
00:00000:00000:2004/06/16 00:14:17.26 kernel Using config area from primary master device.
00:00000:00000:2004/06/16 00:14:17.41 server Configuration Error: Configuration file, 'C:\sybase\FLASHPOINT.cfg', does not exist.
00:00000:00000:2004/06/16 00:14:17.60 kernel Warning: A configuration file was not specified and the default file 'C:\sybase\FLASHPOINT.cfg' does not exist. SQL Server creates the default file with the default configuration.
00:00000:00000:2004/06/16 00:14:17.72 kernel Warning: Using default file 'C:\sybase\FLASHPOINT.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/06/16 00:14:18.35 kernel Using 100000 file descriptors.
00:00000:00000:2004/06/16 00:14:18.50 kernel Adaptive Server Enterprise/12.5.1/EBF 11522/P/NT (IX86)/OS 4.0/ase1251/1824/32-bit/OPT/Mon Sep 29 21:41:30 2003
00:00000:00000:2004/06/16 00:14:18.50 kernel Confidential property of Sybase, Inc.
00:00000:00000:2004/06/16 00:14:18.50 kernel Copyright 1987, 2003
00:00000:00000:2004/06/16 00:14:18.50 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2004/06/16 00:14:18.50 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/06/16 00:14:18.50 kernel
00:00000:00000:2004/06/16 00:14:18.50 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/06/16 00:14:18.50 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2004/06/16 00:14:18.50 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2004/06/16 00:14:18.50 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2004/06/16 00:14:18.50 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2004/06/16 00:14:18.50 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/06/16 00:14:18.50 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2004/06/16 00:14:18.50 kernel Using 'C:\sybase\FLASHPOINT.cfg' for configuration information.
00:00000:00000:2004/06/16 00:14:18.50 kernel Logging ASE messages in file 'C:\sybase\ASE-12_5\install\FLASHPOINT.log'.
00:00000:00000:2004/06/16 00:14:18.55 kernel Initializing MSDTC Connection
00:00000:00000:2004/06/16 00:14:19.06 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
This access violation message repeats 65 times then I get the following:
sqlsrvr.exe: master device size for this server: 30.0 Mb
sqlsrvr.exe: master database size for this server: 6.0 Mb
sqlsrvr.exe: model database size for this server: 2.0 Mb
06/16/04 00:14:21 AM End output from 'sqlsrvr'.
06/16/04 00:14:21 AM Task failed: create the master device. Terminating
06/16/04 00:14:21 AM Configuration failed.
06/16/04 00:14:21 AM Exiting.
06/16/04 00:14:21 AM The log file for this session is
06/16/04 00:14:21 AM Log close.
Things I have tried:
1. I have tried using the server config utility to reconfigure the server with no success.
2. I have deinstalled the product, deleted the C:\sybase directory and even gone into the registry and removed the keys there. I then do a clean installation of sybase 12.5.1, but I always end up right back where I started with the above problem.
3. I have rebooted amny times between deinstalling and reinstalling, but always end up with the same error as above.
As you can see I my system is now down, so if you can please help as soon as you can.