( rattila | 2023. 01. 25., sze – 12:48 )

Talán a log legérdekesebb része:

2022-12-25 04:53:05.612 CET [208569] zabbix@zabbix FATAL:  the database system is in recovery mode
2022-12-25 04:53:05.718 CET [208542] LOG:  invalid record length at 10EA/9340AA8: wanted 24, got 0
2022-12-25 04:53:05.718 CET [208542] LOG:  redo done at 10EA/9340A58
2022-12-25 04:53:05.718 CET [208542] LOG:  last completed transaction was at log time 2022-12-25 04:53:02.294891+01
2022-12-25 04:53:06.632 CET [208572] zabbix@zabbix FATAL:  the database system is in recovery mode
2022-12-25 04:53:06.632 CET [208573] zabbix@zabbix FATAL:  the database system is in recovery mode
2022-12-25 04:53:06.638 CET [208574] zabbix@zabbix FATAL:  the database system is in recovery mode
2022-12-25 04:53:06.639 CET [208575] zabbix@zabbix FATAL:  the database system is in recovery mode
2022-12-25 04:53:08.371 CET [1407] LOG:  database system is ready to accept connections
2022-12-25 04:53:14.741 CET [208598] zabbix@zabbix ERROR:  out of shared memory
2022-12-25 04:53:14.741 CET [208598] zabbix@zabbix HINT:  You might need to increase max_locks_per_transaction.
2022-12-25 04:53:14.741 CET [208598] zabbix@zabbix STATEMENT:  select clock,ns,value from history_str where itemid=24790 and clock<=1671940389 and clock>1671936789 order by clock desc limit 2
2022-12-25 05:05:56.493 CET [208595] zabbix@zabbix ERROR:  index key does not match expected index column
2022-12-25 05:05:56.493 CET [208595] zabbix@zabbix STATEMENT:  delete from history where itemid=47247 and clock<1671334529
2022-12-25 07:37:29.874 CET [1407] LOG:  server process (PID 223159) was terminated by signal 9: Kilőve
2022-12-25 07:37:29.874 CET [1407] DETAIL:  Failed process was running: delete from history where itemid=26046 and clock<1671345070
2022-12-25 07:37:29.874 CET [1407] LOG:  terminating any other active server processes
2022-12-25 07:37:29.875 CET [213846] zabbix@zabbix WARNING:  terminating connection because of crash of another server process
2022-12-25 07:37:29.875 CET [213846] zabbix@zabbix DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared me
2022-12-25 07:37:29.875 CET [213846] zabbix@zabbix HINT:  In a moment you should be able to reconnect to the database and repeat your command.

...

A syslog már sajnos kishiftelődött. :-(

 

Úgy látom, kifogyott a shared memory-ból.