免费注册 查看新帖 |

ChinaUnix.net

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

數據庫down機了!! [复制链接]

论坛徽章:
0
发表于 2018-06-27 08:55 |显示全部楼层
01:26:34  IBM Informix Dynamic Server Version 9.40.UC6
01:26:34   ¨Ï¥Îaì:Session(267029, AP3092@10.192.30.92, 6496, 0xb47581d
                Thread(269140, sqlexec, a4b0c190, 7)
                File: mtex.c Line: 431
01:26:34   μ2aG: Exception Caught. Type: MT_EX_OS, Context: mem
01:26:34   °ê§@: ½D3qa¾ Informix §T3N¤ä′©3¡aù.
01:26:34  stack trace for pid 15918 written to /tmp/af.1f3c774a
01:26:34   ½D°Ñ¾\: /tmp/af.1f3c774a, shmem.1f3c774a.0

论坛徽章:
0
发表于 2018-06-27 08:56 |显示全部楼层
附上tmp下日誌文件信息
Stack for thread: 269140 sqlexec
base: 0xb512e000
  len:   69632
   pc: 0x085d97b1
  tos: 0xb513d214
state: running
   vp: 7

0x085d97b1 (oninit)mt_system(0xb513d3bc, 0x0, 0x0, 0x0, 0xb513d85c, 0x889ee6f)
0x085f781d (oninit)afhandler(0x3, 0x889ee6f, 0xb513d85c, 0x9f2b0d58, 0x601, 0x1)
0x085f6f81 (oninit)afcrash_interface(0x889ee6f, 0xb513d85c, 0x9f2b0d58, 0x889ee68, 0x1af, 0x88988ed)
0x085facac (oninit)mt_ex_throw_sig(0x1, 0x88988ed, 0x0, 0x85d6a07, 0xddee9020, 0xffffe600)
0x085d12b9 (oninit)afsig_handler(0xb, 0xb513d9a0, 0xb513da20, 0xb, 0x0, 0x1)
0xffffe600 (*nosymtab*)0xffffe600(0xa1b6b350, 0x1, 0x2, 0x8469981, 0xa1b6b328, 0x0)
0x0846956e (oninit)pstread (0xa1b6b350, 0x2, 0x0, 0x0, 0xb513dec4, 0xa1b37734)
0x083c5093 (oninit)pst_rsread(0xa1970f74, 0xa1b37734, 0x2, 0x83c5c0e, 0xa4b0c3a0, 0xa1970d90)
0x083c5c37 (oninit)rsread  (0x7, 0xa1b37734, 0x102, 0xb513e11f, 0xb513e120, 0xa17954a0)
0x0865b0fb (oninit)fmread  (0x7, 0xa1b37734, 0x102, 0xb513e11f, 0xb513e120, 0xa17954a0)
0x0821544f (oninit)sqisread(0x7, 0xa1b37734, 0x102, 0x2, 0xa1b37600, 0x0)
0x0823770b (oninit)readseq (0xa1b37600, 0x100, 0xb513e3e6, 0xa0787fc8, 0x824f254, 0xa1b372b
0x08237061 (oninit)gettupl (0xa1b37600, 0x1, 0x38, 0xa1c167a0, 0x824f254, 0xa1b372b
0x082349c0 (oninit)scan_next(0xa1b37600, 0x8841b96, 0x1, 0x81de228, 0xa19f8590, 0xa1b37250)
0x0824fe93 (oninit)hjoin_open(0xa1b372b8, 0x11368, 0x0, 0x20, 0xa19f8550, 0xa1a4136
0x083885cb (oninit)join_open(0xa1b37250, 0xa1b47020, 0xb513e588, 0x8388393, 0xa19f8570, 0xa1a41300)
0x083885cb (oninit)join_open(0xa1a41368, 0xa1715324, 0xa1715220, 0x83c9981, 0xa19f85b0, 0xa1a41ee
0x083885cb (oninit)join_open(0xa1a41300, 0xa1715324, 0x40000, 0x8240237, 0xa1715324, 0xa1b1f750)
0x083885cb (oninit)join_open(0xa1a41ee8, 0xa1715324, 0xa1a08020, 0x0, 0xa1a0be08, 0xa1a41d30)
0x0823ac9c (oninit)filltemp(0xa1a41d30, 0x1, 0xb513e8d8, 0xf0, 0xa1a0be08, 0xa19f49b0)
0x08234593 (oninit)scan_open(0xa1a41d30, 0xa1a0bf44, 0x6, 0x823c610, 0xa179578c, 0xa19f494
0x0823c70a (oninit)materialize_viewtmp(0xa1795650, 0xa19f49b0, 0x6, 0x823c610, 0xa179578c, 0xa19f4820)
0x0823c760 (oninit)materialize_viewtmp(0xa1795650, 0xa19f4948, 0xa1795650, 0x823c610, 0xa179578c, 0xa1b22940)
0x0823c760 (oninit)materialize_viewtmp(0xa1795650, 0xa19f4820, 0xb513e9d8, 0x823c610, 0xa179578c, 0xffffffff)
0x0823c760 (oninit)materialize_viewtmp(0xa1795650, 0xa1b22940, 0xa6549980, 0x85cef86, 0xb513ecd0, 0xffffffff)
0x0823d6f1 (oninit)prepselect(0xa1795650, 0xb513ec80, 0xb513ec78, 0x85aa017, 0xb513ecd0, 0xf7f38a40)
0x0830849e (oninit)open_cursor(0xa1795650, 0xf7f38a40, 0xb513ecd8, 0x83056ce, 0x3, 0x10048800)
0x08307d3f (oninit)sq_open (0x0, 0xbdeab8a0, 0xb513ed74, 0x0, 0x0, 0x0)
0x083669d3 (oninit)sqmain  (0xa, 0x0, 0x0, 0x0, 0x0, 0x0)
0x08614860 (oninit)listen_verify(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085dbb90 (oninit)startup (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 (*nosymtab*)0x0

论坛徽章:
0
发表于 2018-06-27 08:57 |显示全部楼层
哪位高手給看看
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

基于案例的 SQL 优化实战训练营

讲师:中电福富特级专家梁敬彬,参与本次课程培训,你将收获:
1. 能编写出较为高效的 SQL;
2. 能解决70%以上的数据库常见优化问题;
3. 能得到老师提供的高效的相关工具和解决方案;
4. 能举一反三,收获不仅仅是 SQL 优化。
现在购票享受8.8折优惠!
----------------------------------------
优惠时间:2019年3月20日前

大会官网>>
  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP