免费注册 查看新帖 |

Chinaunix

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

请教怎么数据库一会儿就出错了? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-09-08 09:41 |只看该作者 |倒序浏览
我在AS3上装12.5.3,每次启动几分钟后就报错了:
00:00000:00000:2005/09/08 17:37:49.90 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:37:49.90 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:37:49.90 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
ASE-12_5/install/RUN_CENTER: line 16:  3864 段错误                  /opt/sybase/ASE-12_5/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-12_5/install/CENTER.log -c/opt/sybase/ASE-12_5/CENTER.cfg -M/opt/sybase/ASE-12_5 -sCENTER

请教请教请教,谢谢谢谢谢谢啊!!!

论坛徽章:
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
2 [报告]
发表于 2005-09-08 11:29 |只看该作者

请教怎么数据库一会儿就出错了?

多贴点errorlog吧,另请贴出详细sybase版本

论坛徽章:
0
3 [报告]
发表于 2005-09-08 13:43 |只看该作者

请教怎么数据库一会儿就出错了?

谢谢大天使,详细版本是:se1253esd1xe
也就是这儿下的免费版本:
http://www.yesky.com/422/1928422.shtml
----------------------------------
00:00000:00000:2005/09/08 17:41:51.85 kernel  Adaptive Server Enterprise Express Edition (Limits: 1 Engine, 2GB Memory, 5GB Disk space).
00:00000:00000:2005/09/08 17:41:51.85 kernel  Using config area from primary master device.
00:00000:00000:2005/09/08 17:41:51.87 kernel  os_create_keyfile: Removed old segment /opt/sybase/ASE-12_5/CENTER.krg
00:00000:00000:2005/09/08 17:41:51.87 kernel  Internal run-time model set for Linux  - Native
00:00000:00000:2005/09/08 17:41:51.87 kernel  Using 1024 file descriptors.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Adaptive Server Enterprise/12.5.3/EBF 12406 ESD#1/P/Linux Intel/Enterprise Linux/ase1253/1900/32-bit/OPT-Express-Edition/Mon Jan 24 22:11:33 2005
00:00000:00000:2005/09/08 17:41:51.87 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Copyright 1987, 2005
00:00000:00000:2005/09/08 17:41:51.87 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2005/09/08 17:41:51.87 kernel
00:00000:00000:2005/09/08 17:41:51.87 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2005/09/08 17:41:51.87 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2005/09/08 17:41:51.87 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2005/09/08 17:41:51.87 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/09/08 17:41:51.87 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2005/09/08 17:41:51.87 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2005/09/08 17:41:51.87 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2005/09/08 17:41:51.87 kernel  ASE booted on Linux release 2.4.20-8 version #1 Thu Mar 13 17:54:28 EST 2003.
00:00000:00000:2005/09/08 17:41:51.88 kernel  Using '/opt/sybase/ASE-12_5/CENTER.cfg' for configuration information.
00:00000:00000:2005/09/08 17:41:51.88 kernel  Logging ASE messages in file '/opt/sybase/ASE-12_5/install/CENTER.log'.
00:00000:00000:2005/09/08 17:41:51.92 kernel  Platform TCP network is forced to IPv4-only.
00:00000:00000:2005/09/08 17:41:51.92 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2005/09/08 17:41:51.93 kernel  SSL Plus v3.1.10 security modules loaded successfully.
00:00000:00000:2005/09/08 17:41:51.93 kernel  Network and device connection limit is 1014.
00:00000:00000:2005/09/08 17:41:52.03 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2005/09/08 17:41:52.03 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2005/09/08 17:41:52.06 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2005/09/08 17:41:52.06 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2005/09/08 17:41:52.06 kernel  Enabling (RT) Posix asynchronous disk I/O strategy.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Extended cache size '0' is invalid. Provide the appropriate size value.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'on'.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2005/09/08 17:41:52.06 kernel  Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2005/09/08 17:41:52.07 kernel  engine 0, os pid 3916  online
00:00000:00000:2005/09/08 17:41:52.07 server  No active traceflags
00:00000:00001:2005/09/08 17:41:52.07 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.3/EBF 12339 ESD#1/P/Linux Intel/Enterprise Linux/ase1253/1900/32-bit/OPT/Mon Jan 24 21:41:32 2005'.
00:00000:00001:2005/09/08 17:41:52.07 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF12107 ESD #5/DRV.12.5.1.2/Linux Intel/Linux 2.4.18-18.7.xsmp i686/BUILD1251-038/OPT/Thu Aug 19 01:53:15 2004'
00:00000:00001:2005/09/08 17:41:52.07 server  Opening Master Database ...
00:00000:00001:2005/09/08 17:41:57.22 server  Loading SQL Server's default sort order and character set
00:00000:00001:2005/09/08 17:41:57.62 server  Loaded default Unilib conversion handle.
00:00000:00001:2005/09/08 17:41:57.82 server  Recovering database 'master'.
00:00000:00001:2005/09/08 17:41:58.02 server  Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Database 'master', checkpoint=(2505, 13), first=(2505, 13), last=(2505, 13).
00:00000:00001:2005/09/08 17:41:58.12 server  Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Started ANALYSIS pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Completed ANALYSIS pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.12 server  Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00000:00001:2005/09/08 17:41:58.22 server  Completed REDO pass for database 'master'.
00:00000:00001:2005/09/08 17:41:58.22 server  Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:41:58.22 server  Started recovery checkpoint for database 'master'.
00:00000:00001:2005/09/08 17:41:58.92 server  Completed recovery checkpoint for database 'master'.
00:00000:00001:2005/09/08 17:41:59.32 server  Started filling free space info for database 'master'.
00:00000:00001:2005/09/08 17:41:59.52 server  Completed filling free space info for database 'master'.
00:00000:00001:2005/09/08 17:41:59.92 server  Started cleaning up the default data cache for database 'master'.
00:00000:00001:2005/09/08 17:41:59.92 server  Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2005/09/08 17:42:00.52 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:01.82 server  Database 'master' is now online.
00:00000:00001:2005/09/08 17:42:01.92 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:02.02 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2005/09/08 17:42:02.21 server  server name is 'CENTER'
00:00000:00001:2005/09/08 17:42:02.72 server  Activating disk 'sysprocsdev' of size 122880 KB.
00:00000:00001:2005/09/08 17:42:02.72 kernel  Initializing virtual device 1, '/opt/sybase/data/sysprocs.dat' with dsync 'on'.
00:00000:00001:2005/09/08 17:42:02.72 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2005/09/08 17:42:07.95 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:07.95 server  Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Database 'sybsystemdb', checkpoint=(645, 11), first=(645, 11), last=(645, 16).
00:00000:00001:2005/09/08 17:42:08.05 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.05 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 6.
00:00000:00001:2005/09/08 17:42:08.15 server  Redo pass of recovery has processed 1 committed and 1 aborted transactions.
00:00000:00001:2005/09/08 17:42:08.15 server  Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:08.25 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:08.25 server  Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.24 server  Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.64 server  Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:09.85 server  Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.05 server  Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.05 server  Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2005/09/08 17:42:10.14 server  Boot Count: 7
00:00000:00001:2005/09/08 17:42:11.44 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:11.85 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:12.54 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/09/08 17:42:14.95 server  Recovering database 'model'.
00:00000:00001:2005/09/08 17:42:14.95 server  Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Database 'model', checkpoint=(623, , first=(623, , last=(623, 11).
00:00000:00001:2005/09/08 17:42:15.05 server  Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Started ANALYSIS pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Completed ANALYSIS pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.05 server  Started REDO pass for database 'model'. The total number of log records to process is 4.
00:00000:00001:2005/09/08 17:42:15.15 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2005/09/08 17:42:15.15 server  Completed REDO pass for database 'model'.
00:00000:00001:2005/09/08 17:42:15.25 server  Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:15.25 server  Started recovery checkpoint for database 'model'.
00:00000:00001:2005/09/08 17:42:16.24 server  Completed recovery checkpoint for database 'model'.
00:00000:00001:2005/09/08 17:42:16.64 server  Started filling free space info for database 'model'.
00:00000:00001:2005/09/08 17:42:16.85 server  Completed filling free space info for database 'model'.
00:00000:00001:2005/09/08 17:42:17.05 server  Started cleaning up the default data cache for database 'model'.
00:00000:00001:2005/09/08 17:42:17.05 server  Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2005/09/08 17:42:17.24 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:17.65 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:18.34 server  Database 'model' is now online.
00:00000:00001:2005/09/08 17:42:18.35 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2005/09/08 17:42:18.35 server  0 dump conditions detected at boot time
00:00000:00001:2005/09/08 17:42:18.35 server  Resident Node id: c212ce648def
00:00000:00001:2005/09/08 17:42:18.45 server  Transaction coordinator initialized.
00:00000:00001:2005/09/08 17:42:18.45 server  Clearing temp db
00:00000:00001:2005/09/08 17:42:29.68 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:32.41 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:34.44 server  Database 'tempdb' is now online.
00:00000:00001:2005/09/08 17:42:39.65 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.65 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Database 'sybsystemprocs', checkpoint=(31277, 22), first=(31277, 22), last=(31277, 22).
00:00000:00001:2005/09/08 17:42:39.75 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.75 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2005/09/08 17:42:39.84 server  Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:39.85 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2005/09/08 17:42:39.85 server  Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:40.44 server  Completed recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:40.84 server  Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.05 server  Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.25 server  Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.25 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2005/09/08 17:42:41.44 server  Checking external objects.
00:00000:00001:2005/09/08 17:42:42.05 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:47.40 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2005/09/08 17:42:48.69 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2005/09/08 17:42:52.72 server  Database 'model' is now online.
00:00000:00001:2005/09/08 17:42:56.75 server  Database 'sybsystemdb' is now online.
00:00000:00001:2005/09/08 17:43:00.76 server  Database 'tempdb' is now online.
00:00000:00008:2005/09/08 17:43:00.76 kernel  network name center, interface IPv4, address 127.0.0.1, type tcp, port 5000, filter NONE
00:00000:00001:2005/09/08 17:43:02.16 server  Recovery complete.
00:00000:00001:2005/09/08 17:43:02.16 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2005/09/08 17:43:02.46 server  SQL Server's default sort order is:
00:00000:00001:2005/09/08 17:43:02.46 server    'bin_iso_1' (ID = 50)
00:00000:00001:2005/09/08 17:43:02.46 server  on top of default character set:
00:00000:00001:2005/09/08 17:43:02.46 server    'iso_1' (ID = 1).
00:00000:00001:2005/09/08 17:43:02.46 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00000:2005/09/08 17:45:06.85 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:45:06.86 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:45:06.86 kernel  current process (0x40a0bcc0) infected with 11
00:00000:00000:2005/09/08 17:45:06.86 kernel  Address 0x0x0000000e (), siginfo (code, address) = (2, 0x0x400afcf0)
00:00000:00000:2005/09/08 17:45:06.86 kernel  current process (0x40a0bcc0) infected with 11
。。。。。。。。下面的都一样了

论坛徽章:
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
4 [报告]
发表于 2005-09-08 14:32 |只看该作者

请教怎么数据库一会儿就出错了?

感觉是补丁的问题

论坛徽章:
0
5 [报告]
发表于 2005-09-08 14:59 |只看该作者

请教怎么数据库一会儿就出错了?

是否是在对数据库进行优化后出现的这种情况?如果这样,可以sybase目录下面的sybaseserver.001,sybaseserver.002...的上次的配置文件替换现有配置文件。然后,重启sybase 服务,看sybase是否启动正常。

论坛徽章:
0
6 [报告]
发表于 2005-09-08 18:25 |只看该作者

请教怎么数据库一会儿就出错了?

是刚装好了数据库,第一次运行就开始是这样了

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

请教怎么数据库一会儿就出错了?

贴出来的日志表明显然不是第一次。

00:00000:00001:2005/09/08 17:42:10.14 server  Boot Count: 7

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

请教怎么数据库一会儿就出错了?

是的,反复起了好多次,都是一会儿就报错了,showserver也看不到了

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

请教怎么数据库一会儿就出错了?

感觉是安装包的问题,安装ESD2试试

论坛徽章:
0
10 [报告]
发表于 2005-09-09 13:48 |只看该作者

请教怎么数据库一会儿就出错了?

请问ESD2可以免费下么?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP