Avatar

Level 3

Recently, the database cleanup workflow always get failed every day. I checked the cleanup.log, There is an error "

PGS-220000 PostgreSQL error: could not receive data from server: Connection timed out\n (iRc=-2006)" after VACUUM ANALYZE, I suppose is there any connection timeout configrates between Adobe campaign server and the postgresql. Is there anyone know the reason of the issue?

 

2021-06-16 14:04:21.959+08      00004CF1        00004CF1          1     info    wdbc    Get: [57381216] SELECT GetDate(), iOptionId, iDataType, sStringValue, iLongValue, dDoubleValue, tsTimeStampValue, mMemoValue FROM XtkOption WHERE sName=:#(1)#

2021-06-16 14:04:21.959+08      00004CF1        00004CF1          2     info    wdbc      Param(0)=XtkCleanup_NoStats

2021-06-16 14:04:21.960+08      00004CF1        00004CF1          1     info    wdbc    ExecDirect: [27786272] VACUUM ANALYZE

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     error   log     PGS-220000 PostgreSQL error: could not receive data from server: Connection timed out\n (iRc=-2006)

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     error   log     WDB-200001 SQL statement 'VACUUM ANALYZE' could not be executed. (iRc=-2006)

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     warning log     Failed to update RDBMS statistics.

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     info    wdbc    Get: [57381216] SELECT Count(iTrackingUrlId) FROM NmsTrackingUrl WHERE iType = 2

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     error   log     PGS-220000 PostgreSQL error: server closed the connection unexpectedly\n    This probably means the server terminated abnormally\n    before or while processing the request.\n (iRc=-2006)

2021-06-16 16:15:39.224+08      00004CF1        00004CF1          1     error   log     WDB-200001 SQL statement 'SELECT Count(iTrackingUrlId) FROM NmsTrackingUrl WHERE iType = 2' could not be executed. (iRc=-2006)

2021-06-16 16:15:39.228+08      00004CF1        00004CF1          1     info    wdbc    WDBC pool (nms:extAccount:PCDEXT7 prod): 1 connection(s) released, 0 left