NOTICE:HTFS:NO SPACE ON DEV HD (1/42)

guojing219

很急啊!请各位大侠帮我看看!
我的我在虚拟机里面装的
系统是sco openserver 5.0.6
数据库是sybase 11.0.3

硬盘是设的20G,里面的数据库暂时只有2个G,(做了很多次，都不能一次建立10个G)

# # # # dfspace
/         :     Disk space: 281.50 MB of 19958.78 MB available ( 1.41%).
/stand    :     Disk space:   5.20 MB of  14.99 MB available (34.67%).

Total Disk Space: 286.70 MB of 19973.78 MB available ( 1.44%).

出现以下错误:
1> alter database hssbdb
2> on hssb02dev=1000000
3> go
Extending database by 999936 pages on disk hssb02dev
Msg 3225, Level 21, State 1:
Line 1:
I/O failed while attempting to clear pages starting at page 0 of disk number 4.
The SQL Server is terminating this process.
/usr/sybbcs>isql -Usa -P
1> alter database hssbdb
2> on hssb02dev=999000
3> go
Extending database by 999936 pages on disk hssb02dev
Msg 3225, Level 21, State 1:
Line 1:
I/O failed while attempting to clear pages starting at page 0 of disk number 4.
The SQL Server is terminating this process.
/usr/sybbcs>


错误日志:
00:10/03/14 15:14:02.43 kernel  ueshutdown: exiting
00:10/03/14 16:14:13.32 kernel  Using config area from primary master device.
00:10/03/14 16:14:13.42 kernel  Warning: Using default file '/u/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/14 16:14:13.51 kernel  Using 110 file descriptors.
00:10/03/14 16:14:13.52 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/14 16:14:13.52 kernel  Confidential property of Sybase, Inc.
00:10/03/14 16:14:13.52 kernel  (c) Copyright Sybase Inc., 1987, 1997.
00:10/03/14 16:14:13.52 kernel  All rights reserved.
00:10/03/14 16:14:13.52 kernel   
00:10/03/14 16:14:13.53 kernel  Use, duplication, or disclosure by the United States Government
00:10/03/14 16:14:13.53 kernel  is subject to restrictions as set forth in FAR subparagraphs
00:10/03/14 16:14:13.53 kernel  52.227-19(a)-(d) for civilian agency contracts and DFARS
00:10/03/14 16:14:13.53 kernel  252.227-7013(c) (1) (ii) for Department of Defense contracts.
00:10/03/14 16:14:13.53 kernel  Sybase reserves all unpublished rights under the copyright
00:10/03/14 16:14:13.53 kernel  laws of the United States.
00:10/03/14 16:14:13.53 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA.
00:10/03/14 16:14:13.53 kernel  Using '/u/sybase/SYBASE.cfg' for configuration information.
00:10/03/14 16:14:13.53 kernel  Logging SQL Server messages in file '/u/sybase/install/errorlog'
.
00:10/03/14 16:14:13.64 kernel  Network and device connection limit is 100.
00:10/03/14 16:14:13.68 server  Number of proc buffers allocated: 324.
00:10/03/14 16:14:13.75 server  Number of blocks left for proc headers: 373.
00:10/03/14 16:14:13.75 server  Memory allocated for the default data cache cache: 2414 Kb
00:10/03/14 16:14:13.76 server  Size of the 2K memory pool: 2414 Kb
00:10/03/14 16:14:13.76 kernel  Initializing virtual device 0, '/u/sybase/master.dat'
00:10/03/14 16:14:13.77 kernel  Virtual device 0 started using standard unix i/o.
00:10/03/14 16:14:13.83 server  No active traceflags
00:10/03/14 16:14:14.07 server  Opening Master Database ...
00:10/03/14 16:14:14.72 server  Loading SQL Server's default sort order and character set
00:10/03/14 16:14:14.78 kernel  ninit:0: listener type: master
00:10/03/14 16:14:14.78 kernel  ninit:0: listener endpoint: /dev/tcp
00:10/03/14 16:14:14.78 kernel  ninit:0: listener raw address: \x00021a0ac0a800020000000000000000
00:10/03/14 16:14:14.78 kernel  ninit:0: transport provider: T_COTS_ORD
00:10/03/14 16:14:14.81 server  Recovering database 'master'
00:10/03/14 16:14:15.03 server  Recovery dbid 1 ckpt (2069,15)
00:10/03/14 16:14:15.07 server  Recovery no active transactions before ckpt.
00:10/03/14 16:14:15.77 server  Database 'master' is now online.
00:10/03/14 16:14:15.78 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:10/03/14 16:14:15.92 server  server is unnamed
00:10/03/14 16:14:15.99 server  Activating disk 'hssb01dev'.
00:10/03/14 16:14:15.99 kernel  Initializing virtual device 3, '/u/sybase/userdata/hssb01dev.dat'
00:10/03/14 16:14:16.01 kernel  Virtual device 3 started using standard unix i/o.
00:10/03/14 16:14:16.01 server  Activating disk 'loghssb01dev'.
00:10/03/14 16:14:16.01 kernel  Initializing virtual device 7, '/u/sybase/userdata/loghssb01.dat'
00:10/03/14 16:14:16.01 kernel  Virtual device 7 started using standard unix i/o.
00:10/03/14 16:14:16.01 server  Activating disk 'sysprocsdev'.
00:10/03/14 16:14:16.01 kernel  Initializing virtual device 1, '/u/sybase/sybprocs.dat'
00:10/03/14 16:14:16.01 kernel  Virtual device 1 started using standard unix i/o.
00:10/03/14 16:14:16.32 server  Recovering database 'model'.
00:10/03/14 16:14:16.34 server  Recovery dbid 3 ckpt (437,15)
00:10/03/14 16:14:16.34 server  Recovery no active transactions before ckpt.
00:10/03/14 16:14:16.43 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:10/03/14 16:14:16.43 server  Database 'model' is now online.
00:10/03/14 16:14:16.46 server  Clearing temp db
00:10/03/14 16:14:17.70 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:10/03/14 16:14:17.84 server  Database 'tempdb' is now online.
00:10/03/14 16:14:19.94 server  Recovering database 'sybsystemprocs'.
00:10/03/14 16:14:19.99 server  Recovery dbid 4 ckpt (7560,19)
00:10/03/14 16:14:19.99 server  Recovery no active transactions before ckpt.
00:10/03/14 16:14:20.28 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:10/03/14 16:14:20.28 server  Database 'sybsystemprocs' is now online.
00:10/03/14 16:14:20.39 server  Recovering database 'hssbdb'.
00:10/03/14 16:14:20.43 server  Recovery dbid 5 ckpt (1024364,24)
00:10/03/14 16:14:20.43 server  Recovery no active transactions before ckpt.
00:10/03/14 16:15:02.74 server  The transaction log in the database 'hssbdb' will use I/O size of 2 Kb.
00:10/03/14 16:15:02.74 server  Database 'hssbdb' is now online.
00:10/03/14 16:15:02.76 server  Recovery complete.
00:10/03/14 16:15:02.76 server  SQL Server's default sort order is:
00:10/03/14 16:15:02.76 server          'bin_iso_1' (ID = 50)
00:10/03/14 16:15:02.76 server  on top of default character set:
00:10/03/14 16:15:02.76 server          'iso_1' (ID = 1).
00:10/03/14 16:15:54.63 kernel  Initializing virtual device 4, '/u/sybase/userdata/hssb02dev.dat'
00:10/03/14 16:15:54.64 kernel  Virtual device 4 started using standard unix i/o.
00:10/03/14 16:20:25.52 kernel  sddone: write error on virtual disk 4 block 138520:
00:10/03/14 16:20:25.52 kernel  sddone: 16384 bytes passed, 0 returned on write for virt disk 4 block 138520
00:10/03/14 16:20:25.52 server  Error: 3225, Severity: 21, State: 1
00:10/03/14 16:20:25.52 server  I/O failed while attempting to clear pages starting at page 0 of disk number 4.
00:10/03/14 16:20:25.52 kernel  ************************************
00:10/03/14 16:20:25.52 kernel  SQL causing error : alter database hssbdb
on hssb02dev=1000000

00:10/03/14 16:20:25.52 kernel  curdb = 5 pstat = 0x10000 lasterror = 3225
00:10/03/14 16:20:25.52 kernel  preverror = 0 transtate = 0
00:10/03

guojing219

重新建立了一个 40G的硬盘，数据库正确建立！
看来还是硬盘小了的原因

hobbylu

呵呵，SCO系统的，确实比较麻烦一点。