It happened again, and it looks like the database is running out of memory every time, as shown in the DB logs:
2022-02-21 20:04:17.312 UTC [1098] FATAL: sorry, too many clients already
2022-02-21 20:04:17.312 UTC [1099] FATAL: sorry, too many clients already
2022-02-21 20:04:17.313 UTC [1096] FATAL: sorry, too many clients already
2022-02-21 20:04:17.314 UTC [1097] FATAL: sorry, too many clients already
2022-02-21 20:04:17.314 UTC [1100] FATAL: sorry, too many clients already
2022-02-21 20:04:17.324 UTC [1101] FATAL: sorry, too many clients already
2022-02-21 20:04:17.332 UTC [1102] FATAL: sorry, too many clients already
2022-02-21 20:04:17.340 UTC [1103] FATAL: sorry, too many clients already
2022-02-21 20:04:17.344 UTC [1104] FATAL: sorry, too many clients already
2022-02-21 20:04:17.368 UTC [1105] FATAL: sorry, too many clients already
2022-02-21 20:04:17.401 UTC [1095] FATAL: sorry, too many clients already
2022-02-21 20:04:17.547 UTC [1107] FATAL: sorry, too many clients already
2022-02-21 20:04:17.612 UTC [1106] FATAL: sorry, too many clients already
2022-02-21 20:04:17.636 UTC [1109] FATAL: sorry, too many clients already
2022-02-21 20:04:17.636 UTC [1108] FATAL: sorry, too many clients already
2022-02-21 20:04:17.637 UTC [1110] FATAL: sorry, too many clients already
2022-02-21 20:04:21.622 UTC [1] LOG: server process (PID 880) was terminated by signal 9: Killed
2022-02-21 20:04:21.622 UTC [1] DETAIL: Failed process was running: SELECT (
SELECT coalesce(array_to_json(array_agg("device.device config variable".*)), '[]') AS "device_config_variable"
FROM (
SELECT "device.device config variable"."name", "device.device config variable"."value"
FROM "device config variable" AS "device.device config variable"
WHERE "device"."id" = "device.device config variable"."device"
ORDER BY "device.device config variable"."name" ASC
) AS "device.device config variable"
) AS "device_config_variable", (
SELECT coalesce(array_to_json(array_agg("device.device environment variable".*)), '[]') AS "device_environment_variable"
FROM (
SELECT "device.device environment variable"."name", "device.device environment variable"."value"
FROM "device environment variable" AS "device.device environment variable"
WHERE "device"."id" = "device.device environment variable"."device"
) AS "device.device environment variable"
) AS "device_environment_variable", (
SELECT coalesce(array_to_json(array_agg("device.should be running-release".*)), '[]') AS "
2022-02-21 20:04:21.624 UTC [1] LOG: terminating any other active server processes
2022-02-21 20:04:21.624 UTC [1092] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.631 UTC [1073] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.631 UTC [1073] 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 memory.
2022-02-21 20:04:21.631 UTC [1073] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.632 UTC [1059] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.632 UTC [1059] 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 memory.
2022-02-21 20:04:21.632 UTC [1059] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.635 UTC [1050] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.635 UTC [1050] 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 memory.
2022-02-21 20:04:21.635 UTC [1050] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.641 UTC [1056] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.641 UTC [1056] 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 memory.
2022-02-21 20:04:21.641 UTC [1056] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.642 UTC [1069] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.642 UTC [1069] 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 memory.
2022-02-21 20:04:21.642 UTC [1069] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.675 UTC [866] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.675 UTC [866] 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 memory.
2022-02-21 20:04:21.675 UTC [866] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.678 UTC [1091] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.678 UTC [1091] 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 memory.
2022-02-21 20:04:21.678 UTC [1091] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.684 UTC [1083] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.684 UTC [1083] 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 memory.
2022-02-21 20:04:21.684 UTC [1083] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.687 UTC [1064] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.687 UTC [1064] 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 memory.
2022-02-21 20:04:21.687 UTC [1064] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.687 UTC [1090] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.687 UTC [1090] 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 memory.
2022-02-21 20:04:21.687 UTC [1090] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.695 UTC [1051] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.695 UTC [1051] 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 memory.
2022-02-21 20:04:21.695 UTC [1051] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.696 UTC [1088] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.696 UTC [1088] 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 memory.
2022-02-21 20:04:21.696 UTC [1088] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.696 UTC [1070] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.696 UTC [1070] 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 memory.
2022-02-21 20:04:21.696 UTC [1070] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.697 UTC [1034] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.697 UTC [1034] 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 memory.
2022-02-21 20:04:21.697 UTC [1034] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.696 UTC [1054] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.696 UTC [1054] 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 memory.
2022-02-21 20:04:21.696 UTC [1054] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.709 UTC [1040] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.709 UTC [1040] 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 memory.
2022-02-21 20:04:21.709 UTC [1040] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.709 UTC [1084] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.709 UTC [1084] 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 memory.
2022-02-21 20:04:21.709 UTC [1084] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.709 UTC [1093] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.709 UTC [1093] 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 memory.
2022-02-21 20:04:21.709 UTC [1093] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.710 UTC [1031] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.710 UTC [1031] 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 memory.
2022-02-21 20:04:21.710 UTC [1031] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.710 UTC [1080] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.710 UTC [1080] 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 memory.
2022-02-21 20:04:21.710 UTC [1080] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.711 UTC [1025] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.711 UTC [1025] 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 memory.
2022-02-21 20:04:21.711 UTC [1025] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.711 UTC [1048] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.711 UTC [1048] 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 memory.
2022-02-21 20:04:21.711 UTC [1048] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.716 UTC [1037] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.716 UTC [1037] 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 memory.
2022-02-21 20:04:21.716 UTC [1037] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.719 UTC [1045] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.719 UTC [1045] 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 memory.
2022-02-21 20:04:21.719 UTC [1045] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.722 UTC [1026] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.722 UTC [1026] 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 memory.
2022-02-21 20:04:21.722 UTC [1026] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.726 UTC [1024] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.726 UTC [1024] 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 memory.
2022-02-21 20:04:21.726 UTC [1024] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.726 UTC [1047] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.726 UTC [1047] 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 memory.
2022-02-21 20:04:21.726 UTC [1047] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.736 UTC [1035] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.736 UTC [1035] 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 memory.
2022-02-21 20:04:21.736 UTC [1035] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.736 UTC [1094] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.736 UTC [1094] 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 memory.
2022-02-21 20:04:21.736 UTC [1094] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.736 UTC [1023] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.736 UTC [1023] 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 memory.
2022-02-21 20:04:21.736 UTC [1023] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.752 UTC [1068] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.752 UTC [1068] 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 memory.
2022-02-21 20:04:21.752 UTC [1068] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.755 UTC [1008] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.755 UTC [1008] 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 memory.
2022-02-21 20:04:21.755 UTC [1008] HINT: In a moment you should be able to reconnect to the database and repeat your command.
postgres: docker resin 10.244.0.182(45418) BIND: malloc.c:2385: sysmalloc: Assertion `(old_top == initial_top (av) && old_size == 0) || ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) && ((unsigned long) old_end & (pagesize - 1)) == 0)' failed.
2022-02-21 20:04:21.742 UTC [1063] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.742 UTC [1063] 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 memory.
2022-02-21 20:04:21.742 UTC [1063] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.754 UTC [1033] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.754 UTC [1033] 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 memory.
2022-02-21 20:04:21.754 UTC [1033] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.760 UTC [1076] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.760 UTC [1076] 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 memory.
2022-02-21 20:04:21.760 UTC [1076] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.762 UTC [1089] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.762 UTC [1089] 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 memory.
2022-02-21 20:04:21.762 UTC [1089] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.909 UTC [1018] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.909 UTC [1018] 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 memory.
2022-02-21 20:04:21.909 UTC [1018] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.913 UTC [1003] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.913 UTC [1003] 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 memory.
2022-02-21 20:04:21.913 UTC [1003] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.921 UTC [1013] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.921 UTC [1013] 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 memory.
2022-02-21 20:04:21.921 UTC [1013] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.922 UTC [1010] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.922 UTC [1010] 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 memory.
2022-02-21 20:04:21.922 UTC [1010] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.926 UTC [1060] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.926 UTC [1060] 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 memory.
2022-02-21 20:04:21.926 UTC [1060] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.935 UTC [1006] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.935 UTC [1006] 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 memory.
2022-02-21 20:04:21.935 UTC [1006] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.947 UTC [1028] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.947 UTC [1028] 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 memory.
2022-02-21 20:04:21.947 UTC [1028] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.947 UTC [993] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.947 UTC [993] 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 memory.
2022-02-21 20:04:21.947 UTC [993] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.956 UTC [1032] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.956 UTC [1032] 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 memory.
2022-02-21 20:04:21.956 UTC [1032] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.963 UTC [1004] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.963 UTC [1004] 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 memory.
2022-02-21 20:04:21.963 UTC [1004] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.969 UTC [953] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.969 UTC [953] 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 memory.
2022-02-21 20:04:21.969 UTC [953] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.969 UTC [1014] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.969 UTC [1014] 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 memory.
2022-02-21 20:04:21.969 UTC [1014] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.973 UTC [1012] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.973 UTC [1012] 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 memory.
2022-02-21 20:04:21.973 UTC [1012] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.974 UTC [1029] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.974 UTC [1029] 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 memory.
2022-02-21 20:04:21.974 UTC [1029] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.982 UTC [1011] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.982 UTC [1011] 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 memory.
2022-02-21 20:04:21.982 UTC [1011] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.993 UTC [999] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.993 UTC [999] 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 memory.
2022-02-21 20:04:21.993 UTC [999] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:21.993 UTC [1015] WARNING: terminating connection because of crash of another server process
2022-02-21 20:04:21.993 UTC [1015] 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 memory.
2022-02-21 20:04:21.993 UTC [1015] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2022-02-21 20:04:22.853 UTC [1] LOG: all server processes terminated; reinitializing
2022-02-21 20:04:23.006 UTC [1111] LOG: database system was interrupted; last known up at 2022-02-21 20:03:45 UTC
2022-02-21 20:04:23.156 UTC [1111] LOG: database system was not properly shut down; automatic recovery in progress
2022-02-21 20:04:23.162 UTC [1111] LOG: redo starts at C/F87D6930
2022-02-21 20:04:23.180 UTC [1111] LOG: invalid record length at C/F88F9E40: wanted 24, got 0
2022-02-21 20:04:23.181 UTC [1111] LOG: redo done at C/F88F9E08
2022-02-21 20:04:23.923 UTC [1] LOG: database system is ready to accept connections
2022-02-21 20:04:28.407 UTC [1118] ERROR: relation "uniq_model_model_type_vocab" already exists
2022-02-21 20:04:28.407 UTC [1118] STATEMENT: CREATE UNIQUE INDEX "uniq_model_model_type_vocab" ON "model" ("is of-vocabulary", "model type");
2022-02-21 20:04:28.635 UTC [1119] ERROR: relation "uniq_model_model_type_vocab" already exists
2022-02-21 20:04:28.635 UTC [1119] STATEMENT: CREATE UNIQUE INDEX "uniq_model_model_type_vocab" ON "model" ("is of-vocabulary", "model type");
2022-02-21 20:07:54.987 UTC [1343] FATAL: sorry, too many clients already
2022-02-21 20:07:54.994 UTC [1344] FATAL: sorry, too many clients already
2022-02-21 20:07:55.009 UTC [1345] FATAL: sorry, too many clients already
2022-02-21 20:07:55.011 UTC [1353] FATAL: sorry, too many clients already
2022-02-21 20:07:55.017 UTC [1354] FATAL: sorry, too many clients already
2022-02-21 20:07:55.018 UTC [1355] FATAL: sorry, too many clients already
2022-02-21 20:07:55.020 UTC [1356] FATAL: sorry, too many clients already
2022-02-21 20:07:55.041 UTC [1346] FATAL: sorry, too many clients already
2022-02-21 20:07:55.052 UTC [1350] FATAL: sorry, too many clients already
Maybe that someone can point out if there are Postgres configurations that have to be changed to take full advantage of the hardware. I’ve seen some posts about shared_buffer on the internet, but I’m not that familiair with Postgres.
Or maybe someone of the Balena team can confirm that updating the stack to the newest version (like in PR #137) will fix these problems?
Thanks in advance!