Error during Semantic Scholar materialized view creation.
2023-04-04 08:57:31.658 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 08:57:43.451 UTC [706] LOG: checkpoint starting: time
2023-04-04 09:00:16.007 UTC [1826] FATAL: sorry, too many clients already
2023-04-04 09:03:18.157 UTC [706] LOG: checkpoint complete: wrote 27 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=165.729 s, sync=24.490 s, total=302.402 s; sync files=21, longest=5.077 s, average=0.782 s; distance
=120 kB, estimate=120 kB
2023-04-04 09:16:54.829 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:17:44.294 UTC [1860] WARNING: autovacuum worker started without a worker entry
2023-04-04 09:19:29.137 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:22:58.115 UTC [1869] FATAL: sorry, too many clients already
2023-04-04 09:23:26.129 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:24:22.301 UTC [1867] WARNING: autovacuum worker started without a worker entry
2023-04-04 09:26:35.070 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:30:24.202 UTC [1878] FATAL: sorry, too many clients already
2023-04-04 09:31:00.096 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:31:55.491 UTC [1875] WARNING: autovacuum worker started without a worker entry
2023-04-04 09:34:13.343 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:36:20.293 UTC [1882] FATAL: sorry, too many clients already
2023-04-04 09:44:06.133 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:46:19.402 UTC [1890] FATAL: sorry, too many clients already
2023-04-04 09:47:44.289 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:49:14.952 UTC [1891] WARNING: autovacuum worker started without a worker entry
2023-04-04 09:51:26.231 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:53:41.045 UTC [1897] FATAL: sorry, too many clients already
2023-04-04 09:56:09.963 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 09:58:42.839 UTC [1901] FATAL: sorry, too many clients already
2023-04-04 10:05:34.839 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:06:35.229 UTC [1904] WARNING: autovacuum worker started without a worker entry
2023-04-04 10:08:32.486 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:11:17.988 UTC [1911] FATAL: sorry, too many clients already
2023-04-04 10:11:48.181 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:12:29.305 UTC [1907] WARNING: autovacuum worker started without a worker entry
2023-04-04 10:15:40.650 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:19:35.574 UTC [1921] FATAL: sorry, too many clients already
2023-04-04 10:20:06.835 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:21:27.724 UTC [1918] WARNING: autovacuum worker started without a worker entry
2023-04-04 10:23:47.646 UTC [710] WARNING: autovacuum worker took too long to start; canceled
2023-04-04 10:25:59.145 UTC [1927] FATAL: sorry, too many clients already
2023-04-04 10:29:45.625 UTC [660] LOG: server process (PID 1777) was terminated by signal 9: Killed
2023-04-04 10:29:45.625 UTC [660] DETAIL: Failed process was running:
create materialized view if not exists matview_sscitations as
SELECT ssid_in as ssid, crc32id_in as crc32id, COUNT(*) AS count
FROM SSCitations C
GROUP BY ssid, crc32id
HAVING COUNT(*) >= 3
2023-04-04 10:29:45.640 UTC [660] LOG: terminating any other active server processes
2023-04-04 10:29:46.000 UTC [660] LOG: all server processes terminated; reinitializing
2023-04-04 10:29:46.126 UTC [1962] LOG: database system was interrupted; last known up at 2023-04-04 09:01:42 UTC
2023-04-04 10:29:46.189 UTC [1962] LOG: database system was not properly shut down; automatic recovery in progress
2023-04-04 10:29:46.206 UTC [1962] LOG: redo starts at 3CF/66CBA588
2023-04-04 10:29:46.206 UTC [1962] LOG: invalid record length at 3CF/66CBA6D0: wanted 24, got 0
2023-04-04 10:29:46.206 UTC [1962] LOG: redo done at 3CF/66CBA698 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2023-04-04 10:29:46.218 UTC [1963] LOG: checkpoint starting: end-of-recovery immediate wait
Error during Semantic Scholar materialized view creation.