316 字
2 分钟
达梦数据页校验错误排查

2025-12-25 10:46:06.973 [ERROR] database P0000013411 T0000000000000013411 Server page check error! ts_id(1) file_id(0) page_no(253003) page_type(0) index_id(0)

2025-12-26 12:34:41.828 [ERROR] database P0000013830 T0000000000000016968 Server page check error! ts_id(1) file_id(0) page_no(205851) page_type(0) index_id(0)

./dmrdc sfile=/dmdata/dmcore/core-dm_sql_thd-10742-5 会生成一个 core-dm_sql_thd-10742-5_tmp文件

gdb dmserver /dmdata/dmcore/core-dm_sql_thd-10742-5 bt

[Current thread is 1 (LWP 11254)]

warning: File “/usr/lib64/libthread_db-1.0.so” auto-loading has been declined by your `auto-load safe-path’ set to “debugdir:debugdir:datadir/auto- load”. To enable execution of this file add add-auto-load-safe-path /usr/lib64/libthread_db-1.0.so line to your configuration file “/home/dmdba/.gdbinit”. To completely disable this security protection add set auto-load safe-path / line to your configuration file “/home/dmdba/.gdbinit”. For more information about this security protection see the “Auto-loading safe path” section in the GDB manual. E.g., run from the shell: info “(gdb)Auto-loading safe path”

warning: Unable to find libthread_db matching inferior’s thread library, thread debugging will not be available.

warning: File “/usr/lib64/libthread_db-1.0.so” auto-loading has been declined by your `auto-load safe-path’ set to “debugdir:debugdir:datadir/auto- load”.

warning: Unable to find libthread_db matching inferior’s thread library, thread debugging will not be available. Core was generated by `/dmdata/dmdata/dmdbms/bin/dmserver path=/dmdata/dmdata/data/DAMENG/dm.ini -noco’. Program terminated with signal SIGTRAP, Trace/breakpoint trap. #0 0x000000000187d1d8 in assert_fun () [Current thread is 1 (LWP 11254)] Missing separate debuginfos, use: dnf debuginfo-install glibc-2.28-36.1.ky10.aarch64 libgcc-7.3.0-20190804.h30.ky10.aarch64 libicu-62.1-5.ky 10.aarch64 libstdc++-7.3.0-20190804.h30.ky10.aarch64 sssd-2.2.2-5.p01.ky10.aarch64 xz-libs-5.2.4-10.ky10.aarch64 zlib-1.2.11-17.

10.aarch64 libstdc++-7.3.0-20190804.h30.ky10.aarch64 sssd-2.2.2-5.p01.ky10.aarch64 xz-libs-5.2.4-10.ky10.aarch64 zlib-1.2.11-17.1.ky10.aarch 64 (gdb) bt #0 0x000000000187d1d8 in assert_fun () #1 0x000000000187d29c in sigterm_handler () #2 #3 0x0000000000b08258 in pseg_page_get_trx_end () #4 0x0000000000b0bb54 in pseg_page_check_valid () #5 0x0000000000ad8e5c in trx4_tuple_sec_get_prev_trx_id () #6 0x0000000000b029c4 in undo_upd () #7 0x0000000000b038e4 in undo_exec_low () #8 0x0000000000b0b04c in pseg_rollback_urec () #9 0x0000000000b0f9e8 in pseg_rollback () #10 0x0000000000af20c0 in trx4_rollback_to_savepnt_low () #11 0x0000000000af25b4 in trx4_rollback_to_savepnt_fun () #12 0x0000000000af0b68 in trx4_rollback () #13 0x00000000018b42b0 in ntsk_process_rollback () #14 0x00000000018ccf14 in ntsk_process_cop () #15 0x00000000017abff8 in uthr_db_main_for_sess () #16 0x0000fffc539a88cc in ?? () from /lib64/libpthread.so.0 #17 0x0000fffc5363a1ec in ?? () from /lib64/libc.so.6 (gdb)

core-dm_sql_thd-10742-5_tmp文件查看(LWP 11254) 定位到sql

修改PSEG_RECV = 0

达梦数据页校验错误排查
https://blog.newworld.help/posts/达梦数据页校验错误排查/
作者
勇敢DBA不怕困难
发布于
2026-01-24
许可协议
CC BY-NC-SA 4.0