Stack trace after reload master --- Sybase won't start!!!

Discussion:

(too old to reply)

Luis Porras

2006-08-11 17:21:26 UTC

Hi,

I'm trying to reload master database from a backup and I followed these
steps:
1. Rebuild master using srvbuildres
2. Alter master database to increase size
3. Reboot Sybase
4. load database master (ASE is in single user mode)

After loading finishes, a stack trace is shown in the errorlog. And if I
kill the process and I try to restart the server, the stack trace is shown
again and the server freezes...

Any ideas???

~Luis.

At the isql window after loading this message appears:
All dumped pages have been loaded. SQL Server is now clearing pages above
page
7680, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Message empty.
Execution Time (ms.): 1000 Clock Time (ms.): 11000

BEFORE LOAD:

00:00000:00000:2006/08/11 12:57:39.11 kernel Adaptive Server
Enterprise/12.0/P/RS6000/AIX 4.3.2/1576/32bit/FBO/Thu Nov 4 09:40:01 1999
00:00000:00000:2006/08/11 12:57:39.11 kernel Confidential property of
Sybase, Inc.
00:00000:00000:2006/08/11 12:57:39.11 kernel Copyright 1987, 1999
00:00000:00000:2006/08/11 12:57:39.11 kernel Sybase, Inc. All rights
reserved.
00:00000:00000:2006/08/11 12:57:39.11 kernel Unpublished rights reserved
under U.S. copyright laws.
00:00000:00000:2006/08/11 12:57:39.11 kernel
00:00000:00000:2006/08/11 12:57:39.11 kernel This software contains
confidential and trade secret information of Sybase,
00:00000:00000:2006/08/11 12:57:39.11 kernel Inc. Use, duplication or
disclosure of the software and documentation by
00:00000:00000:2006/08/11 12:57:39.11 kernel the U.S. Government is
subject to restrictions set forth in a license
00:00000:00000:2006/08/11 12:57:39.11 kernel agreement between the
Government and Sybase, Inc. or other written
00:00000:00000:2006/08/11 12:57:39.11 kernel agreement specifying the
Government's rights to use the software and any
00:00000:00000:2006/08/11 12:57:39.11 kernel applicable FAR provisions, for
example, FAR 52.227-19.
00:00000:00000:2006/08/11 12:57:39.11 kernel Sybase, Inc. 6475 Christie
Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/08/11 12:57:39.11 kernel Using
'/usr/grok/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2006/08/11 12:57:39.11 kernel Logging ASE messages in file
'/usr/grok/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2006/08/11 12:57:39.15 kernel Directory Control Layer (DCL)
using directory driver: InterfacesDriver
00:00000:00000:2006/08/11 12:57:39.15 kernel Network and device connection
limit is 1990.
00:00000:00000:2006/08/11 12:57:39.20 server Number of proc buffers
allocated: 6746.
00:00000:00000:2006/08/11 12:57:39.45 server Number of blocks left for proc
headers: 6704.
00:00000:00000:2006/08/11 12:57:39.48 server Proc header memory allocated
3352 pages for each per engine cache
00:00000:00000:2006/08/11 12:57:39.48 server Memory allocated for the
default data cache cachelet 1: 50734 Kb
00:00000:00000:2006/08/11 12:57:39.49 server Size of the 2K memory pool:
50734 Kb
00:00000:00000:2006/08/11 12:57:39.49 kernel Initializing virtual device 0,
'/dev/grokmaster' with dsync 'on'.
00:00000:00000:2006/08/11 12:57:39.49 kernel Virtual device 0 started using
asynchronous i/o.
00:00000:00000:2006/08/11 12:57:39.49 kernel Worker Thread Manager is not
enabled for use in SQL Server.
00:00000:00000:2006/08/11 12:57:39.49 kernel Either the config parameter
'use security services' is set to 0, or ASE does not support use of external
security mechanisms on this platform. The Security Control Layer will not be
initialized. No external security mechanisms will be supported.
00:00000:00000:2006/08/11 12:57:39.49 kernel engine 0, os pid 397444
online
00:00000:00000:2006/08/11 12:57:39.49 server No active traceflags
00:00000:00001:2006/08/11 12:57:39.50 kernel Component Integration Services
loaded; version 'Component Integration Services/12.0/P/RS6000/AIX
4.3.2/1576/32bit/INST/Wed Nov 3 22:09:52 1999'.
00:00000:00001:2006/08/11 12:57:39.50 kernel Component Integration
Services: using 'Sybase Client-Library/12.0/P/rs6000/AIX 4.3.1/1/OPT/Mon Oct
4 13:09:11 1999'
00:00000:00001:2006/08/11 12:57:39.50 server *** WARNING ******************
00:00000:00001:2006/08/11 12:57:39.50 server SQL Server booted single user
mode - updates allowed to system catalogs
00:00000:00001:2006/08/11 12:57:39.50 server *** WARNING ******************
00:00000:00001:2006/08/11 12:57:39.50 server Opening Master Database ...
00:00000:00001:2006/08/11 12:57:39.60 server Loading SQL Server's default
sort order and character set
00:00000:00001:2006/08/11 12:57:39.60 server Loaded default Unilib
conversion handle.
00:00000:00002:2006/08/11 12:57:39.60 kernel network name testpip8, type
ether, port 5050
00:00000:00001:2006/08/11 12:57:39.61 server Recovering database 'master'
00:00000:00001:2006/08/11 12:57:39.74 server Checking external objects.
00:00000:00001:2006/08/11 12:57:39.77 server Database 'master' is now
online.
00:00000:00001:2006/08/11 12:57:39.78 server The transaction log in the
database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:39.79 server 0 dump conditions detected at
boot time
00:00000:00001:2006/08/11 12:57:39.80 server server is unnamed
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk 'sysprocsdev'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 1,
'/dev/sybsystemprocs' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 1 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk 'systemdbdev'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 2,
'/dev/sybsystemdb' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 2 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.98 server Recovering database
'sybsystemdb'.
00:00000:00001:2006/08/11 12:57:40.04 server Boot Count: 5
00:00000:00001:2006/08/11 12:57:40.09 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.10 server The transaction log in the
database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.14 server Database 'sybsystemdb' is now
online.
00:00000:00001:2006/08/11 12:57:40.18 server Recovering database 'model'.
00:00000:00001:2006/08/11 12:57:40.25 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.26 server The transaction log in the
database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.28 server Database 'model' is now
online.
00:00000:00001:2006/08/11 12:57:40.28 server Resident Node id: ad1f315d8428
00:00000:00001:2006/08/11 12:57:40.29 server Transaction coordinator
initialized.
00:00000:00001:2006/08/11 12:57:40.29 server Clearing temp db
00:00000:00001:2006/08/11 12:57:42.98 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.15 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.18 server Database 'tempdb' is now
online.
00:00000:00001:2006/08/11 12:57:43.18 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.24 server Recovering database
'sybsystemprocs'.
00:00000:00001:2006/08/11 12:57:43.33 server Checking external objects.
00:00000:00001:2006/08/11 12:57:43.38 server The transaction log in the
database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.40 server Database 'sybsystemprocs' is
now online.
00:00000:00001:2006/08/11 12:57:43.42 server Recovery complete.
00:00000:00001:2006/08/11 12:57:43.42 server SQL Server's default sort
order is:
00:00000:00001:2006/08/11 12:57:43.42 server 'bin_iso_1' (ID = 50)
00:00000:00001:2006/08/11 12:57:43.42 server on top of default character
set:
00:00000:00001:2006/08/11 12:57:43.42 server 'iso_1' (ID = 1).

DURING LOAD:

00:00000:00001:2006/08/11 13:01:37.78 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.78 server Original error was 806,
severity 21, state 1
00:00000:00001:2006/08/11 13:01:37.78 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel SQL causing error : load
database master from
"/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"

00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 server SQL Text: load database master
from "/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel curdb = 1 pstat = 0x1094000
lasterror = 806
00:00000:00001:2006/08/11 13:01:37.79 kernel preverror = 0 transtate = 0
00:00000:00001:2006/08/11 13:01:37.79 kernel curcmd = 229 program = isql
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017674c
.terminate_process[4]+0x70c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel end of stack trace, spid 1,
kpid 786444, suid 1
00:00000:00001:2006/08/11 13:01:37.79 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.79 server Original error was 1251,
severity 26, state 1
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176114
.terminate_process[4]+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10341178
.getdoerr+0x2c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102b81a4
.lock_psema[3]+0x14c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002ee20
.log__lock[1]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10032a8c
.s_execute[8]+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100cb7cc
.xxs__lr_getmarker[3]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10086464
.xls_sessionid[1]+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1034114c
.getdoerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079010
.xact_beginupdate[1]+0x118()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a91c
.abort__all+0x54()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100794e4
.xact__rollbackxact+0x204()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x102a0628
.cleanerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102a198c
.kill_proc[1]+0x1d8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100b32a8
.terminate_process[1]+0x2fc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.80 kernel end of stack trace, spid 1,
kpid 786444, suid 1

Jason L. Froebe [Team Sybase]

2006-08-12 00:24:49 UTC

Permalink

Hi Luis,

There are two issues:

one, your backup file of the master database is of a corrupted master
database. Go to an earlier backup if possible. If not possible,
contact Sybase TechSupport.

two, you're using the GA version of ASE 12.0. This is known to be
extremely buggy and causes corruption in databases. Please apply the
last of the 12.0 EBFs. Sybase TechSupport can help with this.

--
Jason L. Froebe
http://www.froebe.net/blog
http://jfroebe.livejournal.com
Team Sybase

Mark A. Parsons

2006-08-12 00:50:08 UTC

Permalink

Was your original master device initially created using pre-12.0 software
(eg, built with 11.9 and then upgraded, at some point, to 12.0)?

If so, your problem sounds a good bit like a solved case I found (case #
10941230) - after rebuilding the master device a load of the master
database fails; something having to do with a change to the layout of
sysusages in ASE 12.0. According to the case notes there is a possible
workaround that entails a special procedure for loading the master database.

If this sounds like a possible match to your problem I'd recommend you
contact Sybase TS with your issue ... and ask them to check to see if your
issue is similar to case # 10941230, eh.

Post by Luis Porras
Hi,
I'm trying to reload master database from a backup and I followed these
1. Rebuild master using srvbuildres
2. Alter master database to increase size
3. Reboot Sybase
4. load database master (ASE is in single user mode)
After loading finishes, a stack trace is shown in the errorlog. And if I
kill the process and I try to restart the server, the stack trace is shown
again and the server freezes...
Any ideas???
~Luis.
All dumped pages have been loaded. SQL Server is now clearing pages above
page
7680, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Message empty.
Execution Time (ms.): 1000 Clock Time (ms.): 11000
00:00000:00000:2006/08/11 12:57:39.11 kernel Adaptive Server
Enterprise/12.0/P/RS6000/AIX 4.3.2/1576/32bit/FBO/Thu Nov 4 09:40:01 1999
00:00000:00000:2006/08/11 12:57:39.11 kernel Confidential property of
Sybase, Inc.
00:00000:00000:2006/08/11 12:57:39.11 kernel Copyright 1987, 1999
00:00000:00000:2006/08/11 12:57:39.11 kernel Sybase, Inc. All rights
reserved.
00:00000:00000:2006/08/11 12:57:39.11 kernel Unpublished rights reserved
under U.S. copyright laws.
00:00000:00000:2006/08/11 12:57:39.11 kernel
00:00000:00000:2006/08/11 12:57:39.11 kernel This software contains
confidential and trade secret information of Sybase,
00:00000:00000:2006/08/11 12:57:39.11 kernel Inc. Use, duplication or
disclosure of the software and documentation by
00:00000:00000:2006/08/11 12:57:39.11 kernel the U.S. Government is
subject to restrictions set forth in a license
00:00000:00000:2006/08/11 12:57:39.11 kernel agreement between the
Government and Sybase, Inc. or other written
00:00000:00000:2006/08/11 12:57:39.11 kernel agreement specifying the
Government's rights to use the software and any
00:00000:00000:2006/08/11 12:57:39.11 kernel applicable FAR provisions, for
example, FAR 52.227-19.
00:00000:00000:2006/08/11 12:57:39.11 kernel Sybase, Inc. 6475 Christie
Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/08/11 12:57:39.11 kernel Using
'/usr/grok/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2006/08/11 12:57:39.11 kernel Logging ASE messages in file
'/usr/grok/sybase/ASE-12_0/install/SYBASE.log'.
00:00000:00000:2006/08/11 12:57:39.15 kernel Directory Control Layer (DCL)
using directory driver: InterfacesDriver
00:00000:00000:2006/08/11 12:57:39.15 kernel Network and device connection
limit is 1990.
00:00000:00000:2006/08/11 12:57:39.20 server Number of proc buffers
allocated: 6746.
00:00000:00000:2006/08/11 12:57:39.45 server Number of blocks left for proc
headers: 6704.
00:00000:00000:2006/08/11 12:57:39.48 server Proc header memory allocated
3352 pages for each per engine cache
00:00000:00000:2006/08/11 12:57:39.48 server Memory allocated for the
default data cache cachelet 1: 50734 Kb
50734 Kb
00:00000:00000:2006/08/11 12:57:39.49 kernel Initializing virtual device 0,
'/dev/grokmaster' with dsync 'on'.
00:00000:00000:2006/08/11 12:57:39.49 kernel Virtual device 0 started using
asynchronous i/o.
00:00000:00000:2006/08/11 12:57:39.49 kernel Worker Thread Manager is not
enabled for use in SQL Server.
00:00000:00000:2006/08/11 12:57:39.49 kernel Either the config parameter
'use security services' is set to 0, or ASE does not support use of external
security mechanisms on this platform. The Security Control Layer will not be
initialized. No external security mechanisms will be supported.
00:00000:00000:2006/08/11 12:57:39.49 kernel engine 0, os pid 397444
online
00:00000:00000:2006/08/11 12:57:39.49 server No active traceflags
00:00000:00001:2006/08/11 12:57:39.50 kernel Component Integration Services
loaded; version 'Component Integration Services/12.0/P/RS6000/AIX
4.3.2/1576/32bit/INST/Wed Nov 3 22:09:52 1999'.
00:00000:00001:2006/08/11 12:57:39.50 kernel Component Integration
Services: using 'Sybase Client-Library/12.0/P/rs6000/AIX 4.3.1/1/OPT/Mon Oct
4 13:09:11 1999'
00:00000:00001:2006/08/11 12:57:39.50 server *** WARNING ******************
00:00000:00001:2006/08/11 12:57:39.50 server SQL Server booted single user
mode - updates allowed to system catalogs
00:00000:00001:2006/08/11 12:57:39.50 server *** WARNING ******************
00:00000:00001:2006/08/11 12:57:39.50 server Opening Master Database ...
00:00000:00001:2006/08/11 12:57:39.60 server Loading SQL Server's default
sort order and character set
00:00000:00001:2006/08/11 12:57:39.60 server Loaded default Unilib
conversion handle.
00:00000:00002:2006/08/11 12:57:39.60 kernel network name testpip8, type
ether, port 5050
00:00000:00001:2006/08/11 12:57:39.61 server Recovering database 'master'
00:00000:00001:2006/08/11 12:57:39.74 server Checking external objects.
00:00000:00001:2006/08/11 12:57:39.77 server Database 'master' is now
online.
00:00000:00001:2006/08/11 12:57:39.78 server The transaction log in the
database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:39.79 server 0 dump conditions detected at
boot time
00:00000:00001:2006/08/11 12:57:39.80 server server is unnamed
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk 'sysprocsdev'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 1,
'/dev/sybsystemprocs' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 1 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk 'systemdbdev'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 2,
'/dev/sybsystemdb' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 2 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.98 server Recovering database
'sybsystemdb'.
00:00000:00001:2006/08/11 12:57:40.04 server Boot Count: 5
00:00000:00001:2006/08/11 12:57:40.09 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.10 server The transaction log in the
database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.14 server Database 'sybsystemdb' is now
online.
00:00000:00001:2006/08/11 12:57:40.18 server Recovering database 'model'.
00:00000:00001:2006/08/11 12:57:40.25 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.26 server The transaction log in the
database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.28 server Database 'model' is now
online.
00:00000:00001:2006/08/11 12:57:40.28 server Resident Node id: ad1f315d8428
00:00000:00001:2006/08/11 12:57:40.29 server Transaction coordinator
initialized.
00:00000:00001:2006/08/11 12:57:40.29 server Clearing temp db
00:00000:00001:2006/08/11 12:57:42.98 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.15 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.18 server Database 'tempdb' is now
online.
00:00000:00001:2006/08/11 12:57:43.18 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.24 server Recovering database
'sybsystemprocs'.
00:00000:00001:2006/08/11 12:57:43.33 server Checking external objects.
00:00000:00001:2006/08/11 12:57:43.38 server The transaction log in the
database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.40 server Database 'sybsystemprocs' is
now online.
00:00000:00001:2006/08/11 12:57:43.42 server Recovery complete.
00:00000:00001:2006/08/11 12:57:43.42 server SQL Server's default sort
00:00000:00001:2006/08/11 12:57:43.42 server 'bin_iso_1' (ID = 50)
00:00000:00001:2006/08/11 12:57:43.42 server on top of default character
00:00000:00001:2006/08/11 12:57:43.42 server 'iso_1' (ID = 1).
00:00000:00001:2006/08/11 13:01:37.78 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.78 server Original error was 806,
severity 21, state 1
00:00000:00001:2006/08/11 13:01:37.78 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel SQL causing error : load
database master from
"/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 server SQL Text: load database master
from "/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel curdb = 1 pstat = 0x1094000
lasterror = 806
00:00000:00001:2006/08/11 13:01:37.79 kernel preverror = 0 transtate = 0
00:00000:00001:2006/08/11 13:01:37.79 kernel curcmd = 229 program = isql
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017674c
.terminate_process[4]+0x70c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel end of stack trace, spid 1,
kpid 786444, suid 1
00:00000:00001:2006/08/11 13:01:37.79 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.79 server Original error was 1251,
severity 26, state 1
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176114
.terminate_process[4]+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10341178
.getdoerr+0x2c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102b81a4
.lock_psema[3]+0x14c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002ee20
.log__lock[1]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10032a8c
.s_execute[8]+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100cb7cc
.xxs__lr_getmarker[3]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10086464
.xls_sessionid[1]+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1034114c
.getdoerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079010
.xact_beginupdate[1]+0x118()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a91c
.abort__all+0x54()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100794e4
.xact__rollbackxact+0x204()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x102a0628
.cleanerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102a198c
.kill_proc[1]+0x1d8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100b32a8
.terminate_process[1]+0x2fc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.80 kernel end of stack trace, spid 1,
kpid 786444, suid 1

A.M.

2006-08-13 18:19:12 UTC

Permalink

Post by Luis Porras
I'm trying to reload master database from a backup and I followed these
1. Rebuild master using srvbuildres
2. Alter master database to increase size
3. Reboot Sybase
4. load database master (ASE is in single user mode)
After loading finishes, a stack trace is shown in the errorlog. And if I
kill the process and I try to restart the server, the stack trace is shown
again and the server freezes...
Any ideas???

Can you provide some more information. Like why are you
trying to do this? What happened prior?

Post by Luis Porras
00:00000:00000:2006/08/11 12:57:39.11 kernel Adaptive Server
Enterprise/12.0/P/RS6000/AIX 4.3.2/1576/32bit/FBO/Thu Nov 4 09:40:01 1999

This is very old. Look for later EBFs of 12.0 and install
them.

Post by Luis Porras
00:00000:00001:2006/08/11 13:01:37.78 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.78 server Original error was 806,
severity 21, state 1
00:00000:00001:2006/08/11 13:01:37.78 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel SQL causing error : load
database master from
"/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 server SQL Text: load database master
from "/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel curdb = 1 pstat = 0x1094000
lasterror = 806
00:00000:00001:2006/08/11 13:01:37.79 kernel preverror = 0 transtate = 0
00:00000:00001:2006/08/11 13:01:37.79 kernel curcmd = 229 program = isql
00:00000:00001:2006/08/11 13:01:37.79 server Original error was 1251,
severity 26, state 1

Its not clear exactly what the problem is.

I would suggest loading the dump into a scratch database
instead. If you still get errors, its a problem with the
dump. If not, the errors are due to the ASE version you
are using.

If your reason for loading master is to extract information
like syslogins etc. you can do that by loading into a
scratch database and copying the data into master (exercise
caution when doing this).

-am © MMVI

Luis Porras

2006-08-14 18:22:44 UTC

Permalink

Thanks everybody I solved this problem...

But now I have another one:

I'm trying to perform a downgrade for some testing I'm doing. I'm trying to
load the master (I know is not corrupted) into ASE 12.0 (AIX); but as soon
as I start the server I'm getting this error:

Attempting to change default sortorder ID from 805600516 to 805600532
ueshutdown: exiting

Now, the current master database is in 12.5.3. I tried to use -T3100 but it
doesn't work; also I tried in maintenance mode (-m); and I'm getting the
same error always.

Thanks!

~Luis

******************

Post by Luis Porras
00:00000:00001:2006/08/11 12:57:39.50 server SQL Server booted single user
mode - updates allowed to system catalogs
00:00000:00001:2006/08/11 12:57:39.50 server *** WARNING

******************

Post by Luis Porras
00:00000:00001:2006/08/11 12:57:39.50 server Opening Master Database ...
00:00000:00001:2006/08/11 12:57:39.60 server Loading SQL Server's default
sort order and character set
00:00000:00001:2006/08/11 12:57:39.60 server Loaded default Unilib
conversion handle.
00:00000:00002:2006/08/11 12:57:39.60 kernel network name testpip8, type
ether, port 5050
00:00000:00001:2006/08/11 12:57:39.61 server Recovering database 'master'
00:00000:00001:2006/08/11 12:57:39.74 server Checking external objects.
00:00000:00001:2006/08/11 12:57:39.77 server Database 'master' is now
online.
00:00000:00001:2006/08/11 12:57:39.78 server The transaction log in the
database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:39.79 server 0 dump conditions detected at
boot time
00:00000:00001:2006/08/11 12:57:39.80 server server is unnamed
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk

'sysprocsdev'.

Post by Luis Porras
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 1,
'/dev/sybsystemprocs' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 1 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.81 server Activating disk

'systemdbdev'.

Post by Luis Porras
00:00000:00001:2006/08/11 12:57:39.81 kernel Initializing virtual device 2,
'/dev/sybsystemdb' with dsync 'on'.
00:00000:00001:2006/08/11 12:57:39.81 kernel Virtual device 2 started using
asynchronous i/o.
00:00000:00001:2006/08/11 12:57:39.98 server Recovering database
'sybsystemdb'.
00:00000:00001:2006/08/11 12:57:40.04 server Boot Count: 5
00:00000:00001:2006/08/11 12:57:40.09 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.10 server The transaction log in the
database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.14 server Database 'sybsystemdb' is now
online.
00:00000:00001:2006/08/11 12:57:40.18 server Recovering database 'model'.
00:00000:00001:2006/08/11 12:57:40.25 server Checking external objects.
00:00000:00001:2006/08/11 12:57:40.26 server The transaction log in the
database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:40.28 server Database 'model' is now
online.
00:00000:00001:2006/08/11 12:57:40.28 server Resident Node id: ad1f315d8428
00:00000:00001:2006/08/11 12:57:40.29 server Transaction coordinator
initialized.
00:00000:00001:2006/08/11 12:57:40.29 server Clearing temp db
00:00000:00001:2006/08/11 12:57:42.98 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.15 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.18 server Database 'tempdb' is now
online.
00:00000:00001:2006/08/11 12:57:43.18 server The transaction log in the
database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.24 server Recovering database
'sybsystemprocs'.
00:00000:00001:2006/08/11 12:57:43.33 server Checking external objects.
00:00000:00001:2006/08/11 12:57:43.38 server The transaction log in the
database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/08/11 12:57:43.40 server Database 'sybsystemprocs' is
now online.
00:00000:00001:2006/08/11 12:57:43.42 server Recovery complete.
00:00000:00001:2006/08/11 12:57:43.42 server SQL Server's default sort
00:00000:00001:2006/08/11 12:57:43.42 server 'bin_iso_1' (ID = 50)
00:00000:00001:2006/08/11 12:57:43.42 server on top of default character
00:00000:00001:2006/08/11 12:57:43.42 server 'iso_1' (ID = 1).
00:00000:00001:2006/08/11 13:01:37.78 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.78 server Original error was 806,
severity 21, state 1
00:00000:00001:2006/08/11 13:01:37.78 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel SQL causing error : load
database master from
"/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 server SQL Text: load database master
from "/usr/grok/backup/SYBASE/dbdumps/master_dbdump.07-28-06-171603"
00:00000:00001:2006/08/11 13:01:37.79 kernel curdb = 1 pstat = 0x1094000
lasterror = 806
00:00000:00001:2006/08/11 13:01:37.79 kernel preverror = 0 transtate = 0
00:00000:00001:2006/08/11 13:01:37.79 kernel curcmd = 229 program = isql
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017674c
.terminate_process[4]+0x70c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel end of stack trace, spid 1,
kpid 786444, suid 1
00:00000:00001:2006/08/11 13:01:37.79 server
Error 806 encountered .
00:00000:00001:2006/08/11 13:01:37.79 server Original error was 1251,
severity 26, state 1
00:00000:00001:2006/08/11 13:01:37.79 kernel
************************************
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029dcf8
.pcstkwalk+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029e31c
.ucstkgentrace+0x12c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1029cfbc
.ucbacktrace+0x64()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176114
.terminate_process[4]+0xd4()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10341178
.getdoerr+0x2c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102b81a4
.lock_psema[3]+0x14c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1002ee20
.log__lock[1]+0x14()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10032a8c
.s_execute[8]+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100cb7cc
.xxs__lr_getmarker[3]+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10086464
.xls_sessionid[1]+0x1c()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1034114c
.getdoerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10079010
.xact_beginupdate[1]+0x118()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1009a91c
.abort__all+0x54()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100794e4
.xact__rollbackxact+0x204()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x102a0628
.cleanerr installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102a198c
.kill_proc[1]+0x1d8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x100b32a8
.terminate_process[1]+0x2fc()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10177064
.close_network+0x18()
00:00000:00001:2006/08/11 13:01:37.79 kernel [Handler pc: 0x1017d0b8
.ex_stop_recursion installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1017f330
.ex_print[5]+0x20()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10176e74
.hdl_default+0x3c()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x105a3cc4
.s_handle[1]+0xbd8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.79 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100f1e4c
.plc__flush[8]+0x28()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1008ab68
.xls_startscan[2]+0xdc()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a9d8
.abort__all+0x110()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1009a864
.find_abort_low+0x58()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10079458
.xact__rollbackxact+0x178()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1007928c
.xact__rollback_local+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbd14
.lddb_cleanup+0xd4()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cbb98
.lddb_handle+0xe0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1012a20c
.ex_raise+0x1a8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102f0674
.virtmap[2]+0xa8()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10019834
.bufgrab[1]+0x34()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1001b380
.getpage_with_validation[4]+0x14()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10006088
.getrootpage[1]+0x60()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000d6e8
.xact__commitxact+0x108()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c770
.apl__startscan+0x170()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1000c428
.startscan[1]+0xf0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105ca348
.lddb_update_sysusages+0x158()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x10176d54
.std_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cc364
.lddb_merge_dbmaps+0x330()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x105cbab8
.lddb_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x105cd370
.lddb_main+0x8f0()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x102cfbfc
.s_execute[47]+0x2570()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101205b4
.s_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x1002b51c
.sequencer[1]+0x134()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100c7e8c
.tdsrecv_language[1]+0x10()
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x101534ac
.hdl_backout installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel [Handler pc: 0x1031b39c
.ut_handle installed by the following function:-]
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x10091c80
.conn_hdlr[2]+0x18()
00:00000:00001:2006/08/11 13:01:37.80 kernel pc: 0x100143e8
.kpcoldstart+0x1c()
00:00000:00001:2006/08/11 13:01:37.80 kernel end of stack trace, spid 1,
kpid 786444, suid 1

A.M.

2006-08-14 19:29:53 UTC

Permalink

Post by Luis Porras
Thanks everybody I solved this problem...

For future reference, can you explain what the solution was.

Post by Luis Porras
I'm trying to perform a downgrade for some testing I'm doing.

You cannot downgrade ASE.

Post by Luis Porras
I'm trying to
load the master (I know is not corrupted) into ASE 12.0 (AIX); but as soon
Attempting to change default sortorder ID from 805600516 to 805600532
ueshutdown: exiting
Now, the current master database is in 12.5.3. I tried to use -T3100 but it
doesn't work; also I tried in maintenance mode (-m); and I'm getting the
same error always.

Luis Porras

2006-08-15 13:27:55 UTC

Permalink

Thanks...

Well, the solution for the first problem was to rebuild master from scratch
and bcp into system tables the information from sysdatabases, sysdevices,
sysusages and syslogins...

~Luis.

Post by A.M.

Post by Luis Porras
Thanks everybody I solved this problem...

For future reference, can you explain what the solution was.

Post by Luis Porras
I'm trying to perform a downgrade for some testing I'm doing.

You cannot downgrade ASE.