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