免费注册 查看新帖 |

Chinaunix

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

大家帮忙看看这段日志文件有什么问题!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-09-06 15:21 |只看该作者 |倒序浏览
00:00000:00000:2005/09/06 14:26:37.92 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2005/09/06 14:26:38.18 kernel  Using config area from primary master device.
00:00000:00000:2005/09/06 14:26:38.20 kernel  Warning: Using default file 'd:\Sybase\SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2005/09/06 14:26:40.79 kernel  NT operating system error 87 in module 'e:\ase1251\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 参数错误。

.
00:00000:00000:2005/09/06 14:26:40.81 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kbcreate: couldn't create server region 7.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kistartup: could not create shared memory
00:00000:00000:2005/09/06 14:26:40.81 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00000:2005/09/06 14:26:40.82 kernel  FATAL: NULL Pss on STACK_OVERFLOW

论坛徽章:
0
2 [报告]
发表于 2005-09-06 15:39 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

你的共享内存分配的有问题啊!

论坛徽章:
0
3 [报告]
发表于 2005-09-06 15:44 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

00:00000:00000:2005/09/06 14:26:40.79 kernel  NT operating system error 87 in module 'e:\ase1251\porttree\svr\sql\nt386\ksource\blkmem\osmntmmap.c' at line 467: 参数错误。

.
00:00000:00000:2005/09/06 14:26:40.81 kernel  os_create_region: Failed to get virtual memory information.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kbcreate: couldn't create server region 7.
00:00000:00000:2005/09/06 14:26:40.81 kernel  kistartup: could not create shared memory

的确共享内存在日志里面显示不能分配,但是服务一直是正常使用的。只是今天才出现问题。

能解释一下参数错误的那个提示的含义吗?

论坛徽章:
0
4 [报告]
发表于 2005-09-06 16:02 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

一般来讲,启动dataserver的时候不能创建共享内存 其结果应该是不能启动阿,但是你的服务却是一直可以正常使用!看你是今天下午14:26启动的,检查一下你的配置看看!

论坛徽章:
0
5 [报告]
发表于 2005-09-06 16:29 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

不知道你注意到这个提示没有:00:00000:00000:2005/09/06 14:26:40.82 kernel  FATAL: NULL Pss on STACK_OVERFLOW
我在一篇文章里面看到这段文字:
======================================

   Following is a list of fixes which are cumulative to this release.  Each
   fix is listed along with the EBF in which it was first released and the
   description of the problem. The list is sorted by the EBFID column.

   The list of fixes represent changes included after the 12.0 ASE Release.
   For product changes up to 12.0, please refer to the CPR and SPR files
   included in the /install/SPR directory in the 12.0 release directory.
EBFID 8954
BugID 206851

ASE may exit with a 1608 error and a message in
                    the error log, "kernel FATAL: NULL Pss on
                    STACK_OVERFLOW".

论坛徽章:
4
2015年亚洲杯之阿联酋
日期:2015-03-10 10:32:022015年亚洲杯之阿曼
日期:2015-03-10 14:53:222015亚冠之水原三星
日期:2015-07-18 15:40:262015亚冠之塔什干棉农
日期:2015-07-27 20:52:05
6 [报告]
发表于 2005-09-06 17:30 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

从日志上看好象是启动没有成功,并且share memory没有成功建立。在windows平台上好象没有明显的share memory调整,但是否需要观察一下内存使用情况与sybase内存配置情况。最好能贴出服务器硬件配置与sybase的memory与engine配置。至于日志中最后一句,我也不太懂,只是我觉得如果服务没有起来,好象还到不了pss和stack这一步吧,也许首先需要看看share memory是否正常。
btw:最好能贴出OS版本与sybase具体版本,是ASE 12.5.1 for NT吗?EBF呢?

论坛徽章:
0
7 [报告]
发表于 2005-09-07 16:31 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

启动过程中出现不能分配shared memory,检查配置,是否配置了启动时申请shared memory以及分配给SYBASE的最大内存是多少,是否低于与实际的物理内存,当然要为OS留点内存。

Windows平台上的确是没有明显的shared memory调整,但对ASE 32位而言,应该是无限制的。另外,就我所注意到的,WINDOWS2003的共享内存在安全策略上可能有所调整,但不会导致你这样的问题。

论坛徽章:
0
8 [报告]
发表于 2005-09-08 15:23 |只看该作者

大家帮忙看看这段日志文件有什么问题!!!

的确是内存调整的问题,我将sybase.cfg所有参数全部置为default,数据库可以成功启动。然后重新进行调优,分配了比原来少的max memory.然后,就可以了。
最开始的时候是因为数据库日志跟操作系统事件日志都满了,一般这种问题不会很严重的,但是最后发展到严重的地步,数据库服务不能启动。
但是的确很奇怪,原来一直能正常使用的sybase.cfg种的参数,现在却不能使用。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP