sysdatabses表修改不了怎么回事？

asd_boy

我有一个用户库有问题了，我就想通过修改sysdatabases先启动来用户库，然后drop坏的表，但是我改status=-32768后不行，我就想再改成status=0就改不了，像死机没任何反应
现在status的值为-32384
请问是怎么回事？

wfcjz

日志贴出来~

asd_boy

00:10/03/08 10:10:22.42 kernel  Using config area from primary master device.
00:10/03/08 10:10:22.43 kernel  Warning: Using default file '/usr/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:10/03/08 10:10:22.47 kernel  Using 11000 file descriptors.
00:10/03/08 10:10:22.47 kernel  SQL Server/11.0.3/P/SCO/SCO_SV r3.2v5.0.2/2/OPT/Fri Jul 18 19:10:23 PDT 1997
00:10/03/08 10:10:22.47 kernel  Confidential property of Sybase, Inc.
00:10/03/08 10:10:22.47 kernel  (c) Copyright Sybase Inc., 1987, 1997.
00:10/03/08 10:10:22.47 kernel  All rights reserved.
00:10/03/08 10:10:22.47 kernel   
00:10/03/08 10:10:22.47 kernel  Use, duplication, or disclosure by the United States Government
00:10/03/08 10:10:22.47 kernel  is subject to restrictions as set forth in FAR subparagraphs
00:10/03/08 10:10:22.47 kernel  52.227-19(a)-(d) for civilian agency contracts and DFARS
00:10/03/08 10:10:22.47 kernel  252.227-7013(c) (1) (ii) for Department of Defense contracts.
00:10/03/08 10:10:22.47 kernel  Sybase reserves all unpublished rights under the copyright
00:10/03/08 10:10:22.47 kernel  laws of the United States.
00:10/03/08 10:10:22.47 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA.
00:10/03/08 10:10:22.47 kernel  Using '/usr/sybase/SYBASE.cfg' for configuration information.
00:10/03/08 10:10:22.47 kernel  Logging SQL Server messages in file '/usr/sybase/install/errorlog'
.
00:10/03/08 10:10:22.47 kernel  Network and device connection limit is 10990.
00:10/03/08 10:10:22.47 server  Number of proc buffers allocated: 324.
00:10/03/08 10:10:22.48 server  Number of blocks left for proc headers: 373.
00:10/03/08 10:10:22.48 server  Memory allocated for the default data cache cache: 2414 Kb
00:10/03/08 10:10:22.48 server  Size of the 2K memory pool: 2414 Kb
00:10/03/08 10:10:22.48 kernel  Initializing virtual device 0, '/usr/sybase/master.dat'
00:10/03/08 10:10:22.48 kernel  Virtual device 0 started using standard unix i/o.
00:10/03/08 10:10:22.48 server  No active traceflags
00:10/03/08 10:10:22.49 server  Opening Master Database ...
00:10/03/08 10:10:22.49 server  Loading SQL Server's default sort order and character set
00:10/03/08 10:10:22.49 kernel  ninit:0: listener type: master
00:10/03/08 10:10:22.49 kernel  ninit:0: listener endpoint: /dev/tcp
00:10/03/08 10:10:22.49 kernel  ninit:0: listener raw address: \x000222b87f0000010000000000000000
00:10/03/08 10:10:22.49 kernel  ninit:0: transport provider: T_COTS_ORD
00:10/03/08 10:10:22.49 server  Recovering database 'master'
00:10/03/08 10:10:22.50 server  Recovery dbid 1 ckpt (2091,27)
00:10/03/08 10:10:22.50 server  Recovery no active transactions before ckpt.
00:10/03/08 10:10:22.51 server  Database 'master' is now online.
00:10/03/08 10:10:22.51 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:10/03/08 10:10:22.51 server  server is unnamed
00:10/03/08 10:10:22.51 server  Activating disk 'shfh'.
00:10/03/08 10:10:22.51 kernel  Initializing virtual device 7, '/usr/sybase/rshfh'
00:10/03/08 10:10:22.51 kernel  Virtual device 7 started using standard unix i/o.
00:10/03/08 10:10:22.51 server  Activating disk 'shfhlog'.
00:10/03/08 10:10:22.51 kernel  Initializing virtual device 8, '/usr/sybase/rshfhlog'
00:10/03/08 10:10:22.51 kernel  Virtual device 8 started using standard unix i/o.
00:10/03/08 10:10:22.51 server  Activating disk 'sysprocsdev'.
00:10/03/08 10:10:22.51 kernel  Initializing virtual device 1, '/usr/sybase/sybprocs.dat'
00:10/03/08 10:10:22.51 kernel  Virtual device 1 started using standard unix i/o.
00:10/03/08 10:10:22.51 server  Recovering database 'model'.
00:10/03/08 10:10:22.53 server  Recovery dbid 3 ckpt (437,15)
00:10/03/08 10:10:22.53 server  Recovery no active transactions before ckpt.
00:10/03/08 10:10:22.54 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:10/03/08 10:10:22.54 server  Database 'model' is now online.
00:10/03/08 10:10:22.54 server  Clearing temp db
00:10/03/08 10:10:22.55 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:10/03/08 10:10:22.56 server  Database 'tempdb' is now online.
00:10/03/08 10:10:22.56 server  Recovering database 'sybsystemprocs'.
00:10/03/08 10:10:22.56 server  Recovery dbid 4 ckpt (7560,19)
00:10/03/08 10:10:22.56 server  Recovery no active transactions before ckpt.
00:10/03/08 10:10:22.58 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:10/03/08 10:10:22.58 server  Database 'sybsystemprocs' is now online.
00:10/03/08 10:10:22.58 server  
*** Bypassing recovery of database id 5

00:10/03/08 10:10:22.58 server  Error: 614, Severity: 21, State: 1
00:10/03/08 10:10:22.58 server  A row on page 1359004 was accessed that has an illegal length of -17252 in database 'shfh'.
00:10/03/08 10:10:22.58 server  Unable to proceed with the recovery of dbid <5> because of previous errors.  Continuing with the next database.
00:10/03/08 10:10:22.58 server  Recovery complete.
00:10/03/08 10:10:22.58 server  SQL Server's default sort order is:
00:10/03/08 10:10:22.58 server          'bin_iso_1' (ID = 50)
00:10/03/08 10:10:22.58 server  on top of default character set:
00:10/03/08 10:10:22.58 server          'iso_1' (ID = 1).
00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #0 with dbid 1 and objid 30. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #1 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #0 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:10/03/08 10:10:44.16 server  Contact Sybase Technical Support.
00:10/03/08 10:11:29.17 server  Configuration file '/usr/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/usr/sybase/SYBASE.048'.
00:10/03/08 10:11:29.21 server  The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '1'.

asd_boy

00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #0 with dbid 1 and objid 30. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #1 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:10/03/08 10:10:44.16 server  WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #0 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:10/03/08 10:10:44.16 server  Contact Sybase Technical Support.
00:10/03/08 10:11:29.17 server  Configuration file '/usr/sybase/SYBASE.cfg' has been written and the previous version has been renamed to '/usr/sybase/SYBASE.048'.
00:10/03/08 10:11:29.21 server  The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '1'.
这一段是怎么回事？

andkylee

您的数据库够老的了，11.0.3！

看您的日志中有这么一句：
WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #0 with dbid 1 and objid 30. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
其中objid=30表示sysdatabases。估计你不能改的原因在这里。进程结构状态有问题。

重启完之后看看吧！