Hi It's looks like memory leak
ErrorContext: 8192 total in 1 blocks; 7928 free (5 chunks); 264 used > Grand total: 1456224 bytes in 195 blocks; 378824 free (165 chunks); > 1077400 used > 2022-07-02 14:48:07 CEST [3930]: [3-1] user=,db=,host=,app= ERROR: out of > memory > 2022-07-02 14:48:07 CEST [3930]: [4-1] user=,db=,host=,app= DETAIL: > Failed on request of size 152094068 in memory context > "TopTransactionContext". > 2022-07-02 14:48:07 CEST [3930]: [5-1] user=,db=,host=,app= CONTEXT: > automatic vacuum of table "prematch.replication.tab_queue_tmp" > > 2022-07-02 14:48:47 CEST [4476]: [42-1] user=,db=,host=,app= LOG: could > not fork worker process: Cannot allocate memory > 2022-07-02 14:48:47 CEST [4476]: [43-1] user=,db=,host=,app= LOG: could > not fork worker process: Cannot allocate memory > terminate called after throwing an instance of 'std::bad_alloc' > what(): std::bad_alloc > 2022-07-02 14:48:47 CEST [4476]: [44-1] user=,db=,host=,app= LOG: > background worker "parallel worker" (PID 4303) was terminated by signal 6: > Aborted > > But what you see is probably just side effect. Do you use some extension in C++? This is C++ message. This process kills Postgres. It can be related to some operation over prematch.replication.tab_queue_tmp because in both cases an atovacuum was started. > > > 132 hba parser context: 25600 total in 6 blocks; 4464 free (8 chunks); > 21136 used > 133 ErrorContext: 8192 total in 1 blocks; 7928 free (5 chunks); 264 used > 134Grand total: 1456224 bytes in 195 blocks; 378824 free (165 chunks); > 1077400 used > 1352022-07-02 14:48:07 CEST [3930]: [3-1] user=,db=,host=,app= ERROR: out > of memory > 1362022-07-02 14:48:07 CEST [3930]: [4-1] user=,db=,host=,app= DETAIL: > Failed on request of size 152094068 in memory context > "TopTransactionContext". > 1372022-07-02 14:48:07 CEST [3930]: [5-1] user=,db=,host=,app= CONTEXT: > automatic vacuum of table "prematch.replication.tab_queue_tmp" > I am not sure, but it looks like corrupted table prematch.replication.tab_queue_tmp > And a few days later again: > 2022-07-08 14:54:22 CEST [4791]: [81186-1] > user=app_evaluation,db=prematch,host=172.25.0.80,app=Evaluation_STS_UAT > DETAIL: parameters: $1 = '1', $2 = '1748010445', $3 = '0', $4 = '1000' > terminate > called after throwing an instance of 'std::bad_alloc' terminate called > after throwing an instance of 'std::bad_alloc' what(): what(): > std::bad_allocstd::bad_alloc 2022-07-08 14:54:23 CEST [4476]: [49-1] > user=,db=,host=,app= LOG: background worker "parallel worker" (PID 25251) > was terminated by signal 6: Aborted > 2022-07-08 14:54:23 CEST [4476]: [51-1] user=,db=,host=,app= LOG: > terminating any other active server processes > > > Thanks Ales Zeleny >
