| From: | Ashok kumar Mani <amani(at)accelaero(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | PostgreSQL DB checkpoint error! |
| Date: | 2020-04-28 06:13:31 |
| Message-ID: | AM0P191MB0708F469BBF80C9386F50DD2AEAC0@AM0P191MB0708.EURP191.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Classification: External
Hi Admin,
Database is getting hung every day at 5AM. I found the below message from log file , Could you please help me , should I need to increase the max_wal_size value ?
Why it say "incomplete startup packet" in the log.
Please someone help on this ?
020-04-28 01:45:12.494 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:45:26.860 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 01:45:26.860 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:45:53.230 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 01:45:53.230 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:46:01.630 GMT [16213] LOG: incomplete startup packet
2020-04-28 01:46:08.006 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:46:08.006 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:46:33.860 GMT [2389] LOG: checkpoints are occurring too frequently (25 seconds apart)
2020-04-28 01:46:33.860 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:46:48.472 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:46:48.472 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:47:01.661 GMT [16374] LOG: incomplete startup packet
2020-04-28 01:47:14.653 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 01:47:14.653 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:47:28.988 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 01:47:28.988 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:47:54.815 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 01:47:54.815 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:48:01.692 GMT [16544] LOG: incomplete startup packet
2020-04-28 01:48:09.459 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:48:09.459 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:48:35.780 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 01:48:35.780 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:48:50.154 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:48:50.154 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:49:01.726 GMT [16715] LOG: incomplete startup packet
2020-04-28 01:49:18.163 GMT [2389] LOG: checkpoints are occurring too frequently (28 seconds apart)
2020-04-28 01:49:18.163 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:49:32.931 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 01:49:32.931 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:49:58.932 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 01:49:58.932 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:50:01.770 GMT [16882] LOG: incomplete startup packet
2020-04-28 01:50:13.198 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:50:13.198 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:50:38.503 GMT [2389] LOG: checkpoints are occurring too frequently (25 seconds apart)
2020-04-28 01:50:38.503 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:50:53.422 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 01:50:53.422 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:51:01.800 GMT [17049] LOG: incomplete startup packet
2020-04-28 01:51:18.791 GMT [2389] LOG: checkpoints are occurring too frequently (25 seconds apart)
2020-04-28 01:51:18.791 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:51:32.977 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 01:51:32.977 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:51:50.522 GMT [2389] LOG: checkpoints are occurring too frequently (18 seconds apart)
2020-04-28 01:51:50.522 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 01:52:01.829 GMT [17213] LOG: incomplete startup packet
2020-04-28 01:53:01.868 GMT [17380] LOG: incomplete startup packet
2020-04-28 01:54:01.905 GMT [17532] LOG: incomplete startup packet
2020-04-28 01:55:01.948 GMT [17698] LOG: incomplete startup packet
2020-04-28 01:56:01.979 GMT [17853] LOG: incomplete startup packet
2020-04-28 01:57:02.011 GMT [18013] LOG: incomplete startup packet
2020-04-28 01:58:01.040 GMT [18174] LOG: incomplete startup packet
2020-04-28 01:59:01.070 GMT [18331] LOG: incomplete startup packet
2020-04-28 02:00:01.102 GMT [18492] LOG: incomplete startup packet
2020-04-28 02:01:01.149 GMT [18662] LOG: incomplete startup packet
2020-04-28 02:02:01.179 GMT [18841] LOG: incomplete startup packet
2020-04-28 02:03:01.207 GMT [18996] LOG: incomplete startup packet
2020-04-28 02:04:01.234 GMT [19158] LOG: incomplete startup packet
2020-04-28 02:05:01.266 GMT [19318] LOG: incomplete startup packet
2020-04-28 02:06:01.294 GMT [19472] LOG: incomplete startup packet
2020-04-28 02:07:01.323 GMT [19630] LOG: incomplete startup packet
2020-04-28 02:08:01.353 GMT [19787] LOG: incomplete startup packet
2020-04-28 02:08:19.310 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 02:08:19.310 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:08:34.374 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 02:08:34.374 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:09:00.597 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 02:09:00.597 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:09:01.394 GMT [19950] LOG: incomplete startup packet
2020-04-28 02:09:15.417 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 02:09:15.417 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:09:40.970 GMT [2389] LOG: checkpoints are occurring too frequently (25 seconds apart)
2020-04-28 02:09:40.970 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:09:55.793 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 02:09:55.793 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:10:01.584 GMT [20189] LOG: incomplete startup packet
2020-04-28 02:10:21.860 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 02:10:21.860 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:10:36.599 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 02:10:36.599 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:11:01.299 GMT [20353] LOG: incomplete startup packet
2020-04-28 02:11:03.194 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 02:11:03.194 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:11:17.932 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:11:17.932 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:11:44.487 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 02:11:44.487 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:11:58.902 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:11:58.902 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:12:01.328 GMT [20507] LOG: incomplete startup packet
2020-04-28 02:12:25.409 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 02:12:25.409 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:12:39.800 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:12:39.800 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:13:01.358 GMT [20668] LOG: incomplete startup packet
2020-04-28 02:13:05.808 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 02:13:05.808 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:13:20.788 GMT [2389] LOG: checkpoints are occurring too frequently (15 seconds apart)
2020-04-28 02:13:20.788 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:13:47.007 GMT [2389] LOG: checkpoints are occurring too frequently (27 seconds apart)
2020-04-28 02:13:47.007 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:14:01.387 GMT [20827] LOG: incomplete startup packet
2020-04-28 02:14:01.686 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:14:01.686 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:14:27.337 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 02:14:27.337 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:14:41.546 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:14:41.546 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:15:01.415 GMT [20985] LOG: incomplete startup packet
2020-04-28 02:15:07.280 GMT [2389] LOG: checkpoints are occurring too frequently (26 seconds apart)
2020-04-28 02:15:07.280 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:15:21.654 GMT [2389] LOG: checkpoints are occurring too frequently (14 seconds apart)
2020-04-28 02:15:21.654 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
2020-04-28 02:15:40.239 GMT [2389] LOG: checkpoints are occurring too frequently (19 seconds apart)
2020-04-28 02:15:40.239 GMT [2389] HINT: Consider increasing the configuration parameter "max_wal_size".
Best Wishes,
Ashokkumar Mani
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-04-28 06:26:57 | Re: PostgreSQL DB checkpoint error! |
| Previous Message | Laurenz Albe | 2020-04-28 05:19:16 | Re: Partitions and planner |