为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
【操作系统】:linux
【CPU】:
【问题描述】*:
core dump信息:


以下是能获取到得/opt/dmdbms/log/dm_DMSERVER_202412.log日志信息
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 [EID:46]bdta coldata access row 300 beyond size 300
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 [for dem]SYSTEM SHUTDOWN ABORT.
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 bdta coldata access row beyond size
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 code = -1, dm_sys_halt now!!!
2024-12-19 16:23:14.552 [INFO] database P0000000043 T0000000000000000219 total 2 rfil opened!
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 sigterm_handler receive signal 8
2024-12-19 16:23:14.552 [FATAL] database P0000000043 T0000000000000000219 [for dem]SYSTEM SHUTDOWN ABORT.
容器日志
Script start.
file dm.key not found, use default license!
License will expire on 2025-01-02
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: /opt/dmdbms/data/DAMENG/DAMENG01.log
log file path: /opt/dmdbms/data/DAMENG/DAMENG02.log
write to dir [/opt/dmdbms/data/DAMENG].
create dm database success. 2024-12-19 10:50:11
initdb V8
db version: 0x7000c
Init DM success!
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is not running yet...
Dmserver is running.
DM Database is not OK, please wait...
DM Database is not OK, please wait...
DM Database is not OK, please wait...
DM Database is OK
- Starting periodic command scheduler cron
...done.
2023-07-27 19:57:51.680 [INFO] database P0000023431 T0000000000000023435 rfil_close_low set main rfil[../datatest/DAMENG/DAMENG01.log]'s sta to inactive, l_next_seq = 4788, g_next_seq = 4788, clsn = 38842, handle = 7, free=8720896, len=268435456
2023-07-27 19:57:51.681 [INFO] database P0000023431 T0000000000000023435 os_sema2_free, sema_id:3309591, sema_value:1!
2023-07-27 19:57:51.691 [INFO] database P0000023431 T0000000000000023435 shutdown MAL subsystem...
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global inject hint deinit
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global stat cache deinit
2023-07-27 19:57:51.803 [INFO] database P0000023431 T0000000000000023435 fil_sys_destroy
2023-07-27 19:57:52.812 [INFO] database P0000023431 T0000000000000023435 close lsnr socket
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 [for dem]SYSTEM SHUTDOWN SUCCESS.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 DM Database Server shutdown successfully.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 nsvr_notify_exit wakeup main thread to exit
Script start.
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is not running yet...
Dmserver is running.
DM Database is OK
- Starting periodic command scheduler cron
...done.
2023-07-27 19:57:51.680 [INFO] database P0000023431 T0000000000000023435 rfil_close_low set main rfil[../datatest/DAMENG/DAMENG01.log]'s sta to inactive, l_next_seq = 4788, g_next_seq = 4788, clsn = 38842, handle = 7, free=8720896, len=268435456
2023-07-27 19:57:51.681 [INFO] database P0000023431 T0000000000000023435 os_sema2_free, sema_id:3309591, sema_value:1!
2023-07-27 19:57:51.691 [INFO] database P0000023431 T0000000000000023435 shutdown MAL subsystem...
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global inject hint deinit
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global stat cache deinit
2023-07-27 19:57:51.803 [INFO] database P0000023431 T0000000000000023435 fil_sys_destroy
2023-07-27 19:57:52.812 [INFO] database P0000023431 T0000000000000023435 close lsnr socket
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 [for dem]SYSTEM SHUTDOWN SUCCESS.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 DM Database Server shutdown successfully.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 nsvr_notify_exit wakeup main thread to exit
Script start.
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is running.
DM Database is not OK, please wait...
DM Database is OK
- Starting periodic command scheduler cron
...done.
2023-07-27 19:57:51.680 [INFO] database P0000023431 T0000000000000023435 rfil_close_low set main rfil[../datatest/DAMENG/DAMENG01.log]'s sta to inactive, l_next_seq = 4788, g_next_seq = 4788, clsn = 38842, handle = 7, free=8720896, len=268435456
2023-07-27 19:57:51.681 [INFO] database P0000023431 T0000000000000023435 os_sema2_free, sema_id:3309591, sema_value:1!
2023-07-27 19:57:51.691 [INFO] database P0000023431 T0000000000000023435 shutdown MAL subsystem...
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global inject hint deinit
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global stat cache deinit
2023-07-27 19:57:51.803 [INFO] database P0000023431 T0000000000000023435 fil_sys_destroy
2023-07-27 19:57:52.812 [INFO] database P0000023431 T0000000000000023435 close lsnr socket
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 [for dem]SYSTEM SHUTDOWN SUCCESS.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 DM Database Server shutdown successfully.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 nsvr_notify_exit wakeup main thread to exit
Script start.
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is running.
DM Database is not OK, please wait...
DM Database is OK
- Starting periodic command scheduler cron
...done.
2023-07-27 19:57:51.680 [INFO] database P0000023431 T0000000000000023435 rfil_close_low set main rfil[../datatest/DAMENG/DAMENG01.log]'s sta to inactive, l_next_seq = 4788, g_next_seq = 4788, clsn = 38842, handle = 7, free=8720896, len=268435456
2023-07-27 19:57:51.681 [INFO] database P0000023431 T0000000000000023435 os_sema2_free, sema_id:3309591, sema_value:1!
2023-07-27 19:57:51.691 [INFO] database P0000023431 T0000000000000023435 shutdown MAL subsystem...
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global inject hint deinit
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global stat cache deinit
2023-07-27 19:57:51.803 [INFO] database P0000023431 T0000000000000023435 fil_sys_destroy
2023-07-27 19:57:52.812 [INFO] database P0000023431 T0000000000000023435 close lsnr socket
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 [for dem]SYSTEM SHUTDOWN SUCCESS.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 DM Database Server shutdown successfully.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 nsvr_notify_exit wakeup main thread to exit
Script start.
Start DmAPService...
Starting DmAPService: [ OK ]
/opt/dmdbms/conf/dm.ini does not exist, use default dm.ini
Start DMSERVER success!
Dmserver is running.
DM Database is not OK, please wait...
DM Database is OK
- Starting periodic command scheduler cron
...done.
2023-07-27 19:57:51.680 [INFO] database P0000023431 T0000000000000023435 rfil_close_low set main rfil[../datatest/DAMENG/DAMENG01.log]'s sta to inactive, l_next_seq = 4788, g_next_seq = 4788, clsn = 38842, handle = 7, free=8720896, len=268435456
2023-07-27 19:57:51.681 [INFO] database P0000023431 T0000000000000023435 os_sema2_free, sema_id:3309591, sema_value:1!
2023-07-27 19:57:51.691 [INFO] database P0000023431 T0000000000000023435 shutdown MAL subsystem...
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global inject hint deinit
2023-07-27 19:57:51.797 [INFO] database P0000023431 T0000000000000023435 global stat cache deinit
2023-07-27 19:57:51.803 [INFO] database P0000023431 T0000000000000023435 fil_sys_destroy
2023-07-27 19:57:52.812 [INFO] database P0000023431 T0000000000000023435 close lsnr socket
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 [for dem]SYSTEM SHUTDOWN SUCCESS.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 DM Database Server shutdown successfully.
2023-07-27 19:57:52.815 [INFO] database P0000023431 T0000000000000023435 nsvr_notify_exit wakeup main thread to exit
查一下这个参数的值是不是300
SELECT PARA_NAME, PARA_VALUE FROM V$DM_INI WHERE PARA_NAME = 'BDTA_SIZE';
是的话,改大一些,再观察一下还会不会宕机。
修改 SQL-示例:
SP_SET_PARA_VALUE(2, 'BDTA_SIZE', N);--修改为 N
重启数据库生效。