免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 4795 | 回复: 15
打印 上一主题 下一主题

sybase 增加新的设备在新的裸设备,高手请进,帮我看下错误原因啊? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-07-03 10:42 |只看该作者 |倒序浏览
sybase在sco unix  5.0.6下安装成功后,在数据库下面需要增加新的设备在新的裸设备上面。小妹请高手们多多请指点!
我这样建立的啊?怎么报错啊?
我将裸设备划分在第一个区,空间4G应该是够的啊?vdevno=4,4也没有占用啊?到底是什么原因啊?
rsyb_hssb的权限和组我都更改了!列在下面。
我的操作:
1> disk init
2> name='hssb01',
3> physname='/dev/rsyb_hssb',
4> vdevno=4,size=256000
5> go
Msg 5115, Level 16, State 1:
Line 1:
I/O error during disk initialization.  PHYSNAME '/dev/rsyb_hssb' may be
incorrect or 255999 (VSTART + SIZE) may exceed the size of the device.  Please
consult the SQL Server error log for more details.

1>


+-------------------+------------+--------+---+-------------+------------+
| Name              | Type       | New FS | # | First Block | Last Block |
+-------------------+------------+--------+---+-------------+------------+
| syb_hssb          | NON FS     |  no    | 0 |            0|     4120199|
|                   | NOT USED   |  no    | 1 |            -|           -|
|                   | NOT USED   |  no    | 2 |            -|           -|
|                   | NOT USED   |  no    | 3 |            -|           -|
|                   | NOT USED   |  no    | 4 |            -|           -|
|                   | NOT USED   |  no    | 5 |            -|           -|
|                   | NOT USED   |  no    | 6 |            -|           -|
| hd1a              | WHOLE DISK |  no    | 7 |            0|   143334463|
+-------------------+------------+--------+---+-------------+------------+
143330400 1K blocks for divisions, 4064 1K blocks reserved for the system
n[ame]       Name or rename a division.
c[reate]     Create a new file system on this division.
d[elete]     Delete a file system on this division.
t[ype]       Select or change filesystem type on new filesystems.
p[revent]    Prevent a new file system from being created on this division.
s[tart]      Start a division on a different block.
e[nd]        End a division on a different block.
r[estore]    Restore the original division table.
# l -l rsyb*
crwxrwxrwx   1 sybase   sybase     1,104 Jul  7 09:57 rsyb_hssb


错误日志如下:
00:09/07/07 10:22:11.10 kernel  Initializing virtual device 4, '/dev/rsyb_hssb'
00:09/07/07 10:22:11.10 kernel  Virtual device 4 started using asynchronous i/o.
00:09/07/07 10:22:11.10 kernel  sddone: write error on virtual disk 4 block 0:
00:09/07/07 10:22:11.10 kernel  sddone: No such device or address
00:09/07/07 10:22:11.10 kernel  Deactivating virtual device 4, '/dev/rsyb_hssb'



[ 本帖最后由 guojing219 于 2009-7-7 10:30 编辑 ]

论坛徽章:
1
2017金鸡报晓
日期:2017-01-10 15:19:56
2 [报告]
发表于 2009-07-03 11:19 |只看该作者
要看报的是什么错误

论坛徽章:
34
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
3 [报告]
发表于 2009-07-03 11:20 |只看该作者
能否把报错贴出来?

论坛徽章:
0
4 [报告]
发表于 2009-07-03 11:33 |只看该作者
有没有关于在裸设备上建立设备的例子?或者文档呢?数据库装在第一个硬盘,

[ 本帖最后由 guojing219 于 2009-7-7 10:20 编辑 ]

论坛徽章:
0
5 [报告]
发表于 2009-07-03 14:50 |只看该作者
如上

[ 本帖最后由 guojing219 于 2009-7-7 10:21 编辑 ]

论坛徽章:
0
6 [报告]
发表于 2009-07-03 17:37 |只看该作者
size=10240试试,如果不成功再加参数vstart=4096试试

论坛徽章:
34
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
7 [报告]
发表于 2009-07-03 19:55 |只看该作者
以下是SYBASE官方网站的,你可以看看,具体情况具体分析!看看有用没!

Disk Errors
This section contains error messages pertaining to disk activation and system administrator disk commands.




--------------------------------------------------------------------------------

Error 5115
Severity
16


Message text
I/O error during disk initialization.  PHYSNAME '%.*s' may be incorrect or %ld (VSTART + SIZE) may exceed the size of the device.  Please consult the SQL Server error log for more details.


This error may be caused by a hardware problem.

Explanation
This error occurs when a disk init command fails. It can occur for the following reasons:

Incorrect physical device name

Incorrect size

Virtual device number not unique

Permission problem

UNIX kernel not configured for asynchronous I/O.


Action
Check the Adaptive Server error log for information that might help determine the cause of the error.

If necessary, check the items mentioned in the sections below.

Make any needed changes and then run the command again.




Incorrect Device Name
Make sure you have the correct physical device name. Refer to the Adaptive Server installation and configuration guide or the System Administration Guide for instructions.



Incorrect Size
The size parameter of the disk init command must be specified in units of 2K blocks in version 12.0.x and earlier ; or Kilobytes (k or K), Megabytes(m or M), or Gigabytes (g or G) in 12.5 and later.

Sizing 2K units

There are 512 2K blocks in 1MB. Use the formula:

#_of_Megabytes * #_of_data_pages_per_Megabyte = #_of_2K_blocks


For example, to initialize a 10MB Sybase device, specify 5120 for the size:

10MB * 512 = 5120


To determine the number of 2K blocks to use for a raw partition on a UNIX system, convert the size of the partition, in sectors, to 2K blocks. The size of a sector varies on different UNIX systems. For example, it is 512 bytes on Sun, so use sectors/4 for the size parameter. It is 1024 bytes on HP, so use sectors/2. Also, see the information below about virtual device numbers. You must restart Adaptive Server or use a different virtual device number when you reissue the disk init command.

Refer to the Adaptive Server installation and configuration guide for more information about Sybase and your operating system's partitions.

Not all operating systems have partitions as described above.



Virtual Device Number
The vdevno parameter of the disk init command must be unique. Also, if a disk init command fails, Adaptive Server saves the vdevno used, even though the disk init command failed. To make the vdevno available again, restart Adaptive Server. Use sp_helpdevice to determine which virtual device numbers have been used.

The available number of virtual devices is equal to the number of configured devices minus one. For example, if the number of devices configuration parameter is set to 10, then there are 9 available devices, 1 through 9.



Permission Problem
If Adaptive Server was started by the “sybase” account, it must have permission to write to the raw partition or to create a file in the directory specified by disk init. Raw partitions used by Sybase should always be owned by the “sybase” account. Correct the permissions problem and execute the command again, using a different vdevno. Refer to “Virtual Device Number” for more information.



UNIX Kernel
If the UNIX kernel (on SunOS 4.x/Sun Solaris 1.x systems only) is not configured for asynchronous I/O, the 5115 error occurs only if your master device is on a UNIX file, and you are trying to do a disk init on a raw partition. Have your UNIX administrator rebuild the kernel to allow for asynchronous I/O. Refer to Error 823 for more information.

Versions in which this error is raised
All versions

论坛徽章:
0
8 [报告]
发表于 2009-07-07 10:20 |只看该作者
原帖由 camham 于 2009-7-3 17:37 发表
size=10240试试,如果不成功再加参数vstart=4096试试

试过了,还是不行。报的是同样的错误!

论坛徽章:
0
9 [报告]
发表于 2009-07-07 14:26 |只看该作者
你的目标是建一个512M的库,是吧。
给你几条思路
1、确定这个设备上是否有其他的数据库使用这块设备
2、将该设备重建,大小不超过2GB

论坛徽章:
0
10 [报告]
发表于 2009-07-07 16:33 |只看该作者

回复 #9 hobbylu 的帖子

我把裸设备全部删除了,重新建立的,现在还没有建立任何数据库,因为系统是我刚装起来的
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP