人大金仓CKP02-服务器配置_[2024-02-03 13:10:11][root][info]:preprocess dynam-优快云博客

本文链接：https://blog.youkuaiyun.com/hezuijiudexiaobai/article/details/135989213

博客围绕Kingbase数据库参数展开，介绍了主参数kingbase.conf和辅助参数kingbase.auto.conf，后者优先级最高。提及参数分类，如segment_size等，还说明了修改参数的方法，像alter database等，粒度越细优先级越高，最后给出部分参数说明。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

kingbase.conf --主参数

include

后引用优先级高
在这里插入图片描述

kingbase.auto.conf --辅助参数优先级最高

在这里插入图片描述

参数分类

select category,count(*) from pg_settings group by category order by 2;

在这里插入图片描述

select source,count(*) from pg_settings group by 1 order by 2;

在这里插入图片描述

select context,count(*) from pg_settings group by 1 order by 2;

select name,setting from pg_catalog.pg_settings where context = 'internal';

在这里插入图片描述

segment_size
在这里插入图片描述

show all

在这里插入图片描述

???
在这里插入图片描述

---
2024-02-02 03:47:13.753 UTC,"rdsadmin","kingbase",2539509,"[local]",65bc6568.26bff5,1,"SHOW",2024-02-02 03:45:44 UTC,9/2600,0,LOG,00000,"kingbase ran into a problem it couldn't handle,it needs to be shutdown to prevent damage to your data",,,,,,"show all;",,,"ksql"
2024-02-02 03:47:13.770 UTC,"rdsadmin","kingbase",2539509,"[local]",65bc6568.26bff5,2,"SHOW",2024-02-02 03:45:44 UTC,9/2600,0,WARNING,01000,"
ERROR:  -----------------------stack error start-----------------------
ERROR:  TIME: 2024-02-02 11:47:13.753623+08
ERROR:  1 2539509 0x7f24bb59b5a5 debug_backtrace (backtrace.so)
ERROR:  2 2539509 0x7f24bb59b64a <symbol not found> (backtrace.so)
ERROR:  3 2539509 0x7f24c1ab76d0 <symbol not found> (libpthread.so.0)
ERROR:  4 2539509 0x7f24bffbfff1 <symbol not found> (libc.so.6)
ERROR:  5 2539509 0x914f99 cstring_to_text + 0x914f99
ERROR:  6 2539509 0x95e8ab GetPGVariable + 0x95e8ab
ERROR:  7 2539509 0x81b5d6 standard_ProcessUtility + 0x81b5d6
ERROR:  8 2539509 0x7f24bd2f879b <symbol not found> (synonym.so)
ERROR:  9 2539509 0x7f24bd07e8b1 <symbol not found> (plsql.so)
ERROR:  10 2539509 0x7f24bce5616a <symbol not found> (force_view.so)
ERROR:  11 2539509 0x7f24bcc48747 <symbol not found> (kdb_flashback.so)
ERROR:  12 2539509 0x7f24bb7a3e1a <symbol not found> (sys_stat_statements.so)
ERROR:  13 2539509 0x8183e9 PortalRunUtility + 0x8183e9
ERROR:  14 2539509 0x819482 FillPortalStore + 0x819482
ERROR:  15 2539509 0x819f38 PortalRun + 0x819f38
ERROR:  16 2539509 0x814489 exec_simple_query + 0x814489
ERROR:  17 2539509 0x816e2a PostgresMain + 0x816e2a
ERROR:  18 2539509 0x79f20c PostmasterMain + 0x79f20c
ERROR:  19 2539509 0x4b34fd main + 0x4b34fd
ERROR:  20 2539509 0x7f24bfe73445 __libc_start_main (libc.so.6)
ERROR:  21 2539509 0x4b359b _start + 0x4064024b
",,,,,,,,,"ksql"
2024-02-02 03:48:20.279 UTC,,,2533389,,65bc6318.26a80d,7,,2024-02-02 03:35:52 UTC,,0,LOG,00000,"server process (PID 2539509) was terminated by signal 11: Segmentation fault","Failed process was running: show all;",,,,,,,,""
2024-02-02 03:48:20.279 UTC,,,2533389,,65bc6318.26a80d,8,,2024-02-02 03:35:52 UTC,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,""
2024-02-02 03:48:20.279 UTC,"esrep","",2534117,"245.0.1.24:49684",65bc635a.26aae5,4,"streaming 0/15010FE8",2024-02-02 03:36:58 UTC,11/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"replica0"
2024-02-02 03:48:20.279 UTC,"rdsadmin","kingbase",2533940,"[local]",65bc634b.26aa34,1,"idle",2024-02-02 03:36:43 UTC,10/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"ksql"
2024-02-02 03:48:20.279 UTC,"esrep","esrep",2533409,"245.0.2.44:36790",65bc631b.26a821,1,"idle",2024-02-02 03:35:55 UTC,5/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"repmgr"
2024-02-02 03:48:20.279 UTC,"rdsadmin","test",2533842,"::1:25504",65bc6343.26a9d2,1,"idle",2024-02-02 03:36:35 UTC,8/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,""
2024-02-02 03:48:20.279 UTC,,,2533395,,65bc6318.26a813,1,,2024-02-02 03:35:52 UTC,1/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,""
2024-02-02 03:48:20.279 UTC,"esrep","esrep",2533411,"245.0.1.24:41578",65bc631b.26a823,1,"idle",2024-02-02 03:35:55 UTC,6/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"repmgr"
2024-02-02 03:48:20.279 UTC,"esrep","esrep",2533407,"245.0.0.101:46168",65bc631b.26a81f,1,"idle",2024-02-02 03:35:55 UTC,4/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"repmgr"
2024-02-02 03:48:20.279 UTC,"esrep","esrep",2533413,"245.0.2.44:36898",65bc631b.26a825,1,"idle",2024-02-02 03:35:55 UTC,7/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The kingbase has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,"repmgr"
2024-02-02 03:48:20.281 UTC,,,2533389,,65bc6318.26a80d,9,,2024-02-02 03:35:52 UTC,,0,LOG,00000,"archiver process (PID 2533396) exited with exit code 1",,,,,,,,,""
2024-02-02 03:48:20.283 UTC,,,2533389,,65bc6318.26a80d,10,,2024-02-02 03:35:52 UTC,,0,LOG,00000,"all server processes terminated; reinitializing",,,,,,,,,""
2024-02-02 03:48:20.554 UTC,,,2541111,,65bc6604.26c637,1,,2024-02-02 03:48:20 UTC,,0,LOG,00000,"database system was interrupted; last known up at 2024-02-02 03:40:56 UTC",,,,,,,,,""
2024-02-02 03:48:20.554 UTC,"esrep","",2541112,"245.0.1.24:24304",65bc6604.26c638,1,"",2024-02-02 03:48:20 UTC,,0,FATAL,57P03,"the database system is in recovery mode",,,,,,,,,""
2024-02-02 03:48:20.597 UTC,,,2541111,,65bc6604.26c637,2,,2024-02-02 03:48:20 UTC,,0,LOG,00000,"database system was not properly shut down; automatic reco