免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 4891 | 回复: 5

onmode -ky停止数据库是否不能清空共享内存 [复制链接]

论坛徽章:
0
发表于 2012-03-23 16:56 |显示全部楼层
数据库安装完成后,oninit -ivy一直不成功,报共享内存问题,后来修改相关参数后,成功了,onstat -m查看,发现有两个系统表没有建立成功,后来onmode -ky了,结果在onstat -i就又报shared memory not initialized for INFORMIXSERVER “XXX"问题。
是否停止数据库后没有清空共享内存呀。
后来再试着onclean
Do you wish to continue (y/n)? y
- Looking for semaphore ID: 10682396
- Looking for the shmem key: 52564801
- Looking for the shmem key: 52564802
好像没有清空,因为还是报
oninit: Fatal error in shared memory initialization。

有遇到过的帮忙响应一下,ths>

论坛徽章:
0
发表于 2012-03-25 20:59 |显示全部楼层
用root用户ipcrm删除掉共享内存

论坛徽章:
0
发表于 2012-03-26 15:06 |显示全部楼层
oninit -v时,出现如下内容,是啥意思呀:
Illegal log buffer size 262100, changed to 65534
oninit: Fatal error in shared memory creation
Reading configuration file '/home/informix/etc/onconfig.online'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...FAILED

WARNING: server initialization failed, or possibly timed out (if -w was used).
Check the message log, online.log, for errors.

论坛徽章:
0
发表于 2012-03-26 16:47 |显示全部楼层
Illegal log buffer size 262100, changed to 65534
发下日志看下。。

论坛徽章:
0
发表于 2012-03-27 16:39 |显示全部楼层
12:50:37  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

13:05:38  Checkpoint Completed:  duration was 0 seconds.
13:05:38  Tue Mar 27 - loguniq 2, logpos 0xf82018, timestamp: 0x29786 Interval: 376

13:05:38  Maximum server connections 1
13:05:38  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

13:20:39  Checkpoint Completed:  duration was 0 seconds.
13:20:39  Tue Mar 27 - loguniq 2, logpos 0xf84018, timestamp: 0x29790 Interval: 377

13:20:39  Maximum server connections 1
13:20:39  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

13:35:40  Checkpoint Completed:  duration was 0 seconds.
13:35:40  Tue Mar 27 - loguniq 2, logpos 0xf86018, timestamp: 0x2979a Interval: 378

13:35:40  Maximum server connections 1
13:35:40  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

13:50:41  Checkpoint Completed:  duration was 0 seconds.
13:50:41  Tue Mar 27 - loguniq 2, logpos 0xf88018, timestamp: 0x297a4 Interval: 379

13:50:41  Maximum server connections 1
13:50:41  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

14:05:42  Checkpoint Completed:  duration was 0 seconds.
14:05:42  Tue Mar 27 - loguniq 2, logpos 0xf8a018, timestamp: 0x297ae Interval: 380

14:05:42  Maximum server connections 1
14:05:42  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

14:20:43  Checkpoint Completed:  duration was 0 seconds.
14:20:43  Tue Mar 27 - loguniq 2, logpos 0xf8c018, timestamp: 0x297b8 Interval: 381

14:20:43  Maximum server connections 1
14:20:43  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

14:35:44  Checkpoint Completed:  duration was 0 seconds.
14:35:44  Tue Mar 27 - loguniq 2, logpos 0xf8e018, timestamp: 0x297c2 Interval: 382

14:35:44  Maximum server connections 1
14:35:44  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

14:50:45  Checkpoint Completed:  duration was 0 seconds.
14:50:45  Tue Mar 27 - loguniq 2, logpos 0xf90018, timestamp: 0x297cc Interval: 383

14:50:45  Maximum server connections 1
14:50:45  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

15:05:46  Checkpoint Completed:  duration was 0 seconds.
15:05:46  Tue Mar 27 - loguniq 2, logpos 0xf92018, timestamp: 0x297d6 Interval: 384

15:05:46  Maximum server connections 1
15:05:46  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

15:20:47  Checkpoint Completed:  duration was 0 seconds.
15:20:47  Tue Mar 27 - loguniq 2, logpos 0xf94018, timestamp: 0x297e0 Interval: 385

15:20:47  Maximum server connections 1
15:20:47  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

15:35:48  Checkpoint Completed:  duration was 0 seconds.
15:35:48  Tue Mar 27 - loguniq 2, logpos 0xf96018, timestamp: 0x297ea Interval: 386

15:35:48  Maximum server connections 1
15:35:48  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

15:50:49  Checkpoint Completed:  duration was 0 seconds.
15:50:49  Tue Mar 27 - loguniq 2, logpos 0xf98018, timestamp: 0x297f4 Interval: 387

15:50:49  Maximum server connections 1
15:50:49  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

16:05:50  Checkpoint Completed:  duration was 0 seconds.
16:05:50  Tue Mar 27 - loguniq 2, logpos 0xf9a018, timestamp: 0x297fe Interval: 388

16:05:50  Maximum server connections 1
16:05:50  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

16:20:51  Checkpoint Completed:  duration was 0 seconds.
16:20:51  Tue Mar 27 - loguniq 2, logpos 0xf9c018, timestamp: 0x29808 Interval: 389

16:20:51  Maximum server connections 1
16:20:51  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

16:35:52  Checkpoint Completed:  duration was 0 seconds.
16:35:52  Tue Mar 27 - loguniq 2, logpos 0xf9e018, timestamp: 0x29812 Interval: 390

16:35:52  Maximum server connections 1
16:35:52  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2

16:35:55  IBM Informix Dynamic Server Started.
16:35:55  Warning: The IBM IDS Innovator-C Edition license restriction limits
16:35:55  the total shared memory size for this server to 2097152 KB.
16:35:55  The maximum allowable shared memory was reset to this size to start the database server.
16:35:55  shmget: [EEXIST][17]: key 52564801: shared memory already exists
16:35:55  mt_shm_init: can't create resident segment

论坛徽章:
0
发表于 2012-03-28 19:02 |显示全部楼层
ipcm -m看一下,共享内存被占用了
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP