标题: 有没有兄弟在linux的ramdisk里建过sybase数据库设备? [打印本页] 作者: yaledu 时间: 2006-07-29 15:17 标题: 有没有兄弟在linux的ramdisk里建过sybase数据库设备? 我在做测试,Sybase 12.5.3 for linux X86_64 EBF 13339 +RedHat Enterprise Linux 4U2 AS X86_64
两种方式,即文件方式与裸设备:
1.Linux建 450M的ramdisk
然后:
mke2fs /dev/ram0
mkdir /tmp/ram0
mount /dev/ram0 /tmp/ram0
chown -R sybase:sybase /tmp/ram0
然后把设备tempdev建立在/tmp/ram0上
从客户端看到设备已经建立成功,但是后台log是:
01:00000:00022:2006/07/29 14:44:56.19 kernel Initializing virtual device 2, '/t mp/ram0/tempdev.dat' with dsync 'on'.
01:00000:00022:2006/07/29 14:44:56.19 kernel Virtual device 2 started using asy nchronous i/o.
01:00000:00022:2006/07/29 14:44:56.19 kernel Initializing device /tmp/ram0/temp dev.dat from offset 0 with zeros.
01:00000:00022:2006/07/29 14:44:57.40 kernel udzero_out: attempt to write page 204671 on device '/tmp/ram0/tempdev.dat' failed, system error is: Success
注意最后那句既成功又失败的莫明奇妙的话.
继续在tempdev上建立新数据库test:
create database test on tempdev=400
go
前台错误提示:
CREATE DATABASE: allocating 204800 logical pages (400.0 megabytes) on disk
'tempdev'.
Msg 3225, Level 21, State 1:
Server 'emt64', Line 1:
I/O failed while attempting to clear pages starting at page 0 of disk number 2.
再看log:
00:00000:00000:2006/07/29 14:55:17.28 kernel sddone: write error on virtual disk 2 block 204544:
00:00000:00000:2006/07/29 14:55:17.28 kernel sddone: 524288 bytes passed, 0 returned on write for virt disk 2 block 204544
00:00000:00011:2006/07/29 14:55:17.29 server Error: 3225, Severity: 21, State: 1
00:00000:00011:2006/07/29 14:55:17.29 server I/O failed while attempting to clear pages starting at page 0 of disk number 2.
00:00000:00000:2006/07/29 14:57:08.08 kernel sddone: write error on virtual disk 2 block 204544:
00:00000:00000:2006/07/29 14:57:08.08 kernel sddone: 524288 bytes passed, 0 returned on write for virt disk 2 block 204544
00:00000:00012:2006/07/29 14:57:08.08 server Error: 3225, Severity: 21, State: 1
00:00000:00012:2006/07/29 14:57:08.08 server I/O failed while attempting to clear pages starting at page 0 of disk number 2.
创建数据库失败!
再用裸设备方式
umount /dev/ram0
raw /dev/raw/raw1 /dev/ram0
chown -R sybase:sybase /dev/raw/raw1
chown -R sybase:sybase /dev/ram0
然后在裸设备/dev/raw/raw1上建数据库设备
前台提示创建数据库设备错误,看后台log:
01:00000:00022:2006/07/29 14:59:06.58 kernel Deactivating virtual device 2, '/tmp/ram0/tempdev.dat'.
01:00000:00022:2006/07/29 15:04:21.70 kernel basis_dsizecheck: attempt to open device '/dev/raw/raw1' failed, system error is: Invalid argument