Skip to content

Instantly share code, notes, and snippets.

@banagale
Created August 8, 2020 18:06
Show Gist options
  • Save banagale/6c3d0d02220101275080be4a57c861b0 to your computer and use it in GitHub Desktop.
Save banagale/6c3d0d02220101275080be4a57c861b0 to your computer and use it in GitHub Desktop.
Example Postgres Errors due to Nginx passive health check (random 502, intermittent 502)
db_1 | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1 |
db_1 | 2020-08-07 21:04:53.734 UTC [1] LOG: starting PostgreSQL 12.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.3.0) 9.3.0, 64-bit
db_1 | 2020-08-07 21:04:53.734 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
db_1 | 2020-08-07 21:04:53.734 UTC [1] LOG: listening on IPv6 address "::", port 5432
db_1 | 2020-08-07 21:04:53.738 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1 | 2020-08-07 21:04:53.771 UTC [20] LOG: database system was shut down at 2020-08-07 21:04:52 UTC
db_1 | 2020-08-07 21:04:53.775 UTC [1] LOG: database system is ready to accept connections
db_1 | 2020-08-07 21:05:24.660 UTC [30] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:06:16.973 UTC [32] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:06:30.032 UTC [40] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:06:56.972 UTC [42] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:07:09.597 UTC [43] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:07:21.076 UTC [44] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:07:47.031 UTC [46] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:07:58.979 UTC [48] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:08:10.133 UTC [49] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:20:40.926 UTC [75] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:20:53.860 UTC [76] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:25:33.715 UTC [87] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:26:39.045 UTC [91] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:28:47.339 UTC [96] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:28:59.197 UTC [98] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:29:10.996 UTC [99] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:29:22.161 UTC [100] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:34:36.743 UTC [115] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:34:49.026 UTC [116] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:35:11.749 UTC [118] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:35:23.823 UTC [119] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:35:36.519 UTC [121] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:35:48.863 UTC [122] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:36:00.101 UTC [124] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:36:12.190 UTC [125] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:36:24.490 UTC [126] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:36:48.624 UTC [128] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:37:04.006 UTC [133] LOG: invalid length of startup packet
db_1 | 2020-08-07 21:55:54.349 UTC [171] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:43:47.223 UTC [269] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:43:51.173 UTC [272] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:43:53.609 UTC [275] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:43:55.544 UTC [276] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:46:07.101 UTC [282] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:46:08.678 UTC [283] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:46:09.901 UTC [284] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:46:40.624 UTC [286] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:47:11.802 UTC [288] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:12.039 UTC [298] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:13.260 UTC [300] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:14.348 UTC [302] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:17.759 UTC [304] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:19.755 UTC [306] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:20.359 UTC [307] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:21.003 UTC [308] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:22.164 UTC [309] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:23.773 UTC [310] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:26.709 UTC [312] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:29.484 UTC [313] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:31.004 UTC [314] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:32.392 UTC [315] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:51:35.569 UTC [316] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:15.237 UTC [320] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:16.493 UTC [321] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:18.629 UTC [322] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:19.921 UTC [323] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:20.303 UTC [324] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:20.749 UTC [325] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:21.120 UTC [326] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:21.719 UTC [327] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:22.152 UTC [328] LOG: invalid length of startup packet
db_1 | 2020-08-07 22:53:22.527 UTC [329] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:06.127 UTC [348] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:09.867 UTC [349] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:11.109 UTC [350] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:12.526 UTC [351] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:13.850 UTC [352] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:15.058 UTC [353] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:16.402 UTC [354] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:17.650 UTC [355] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:20.419 UTC [356] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:22.403 UTC [357] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:02:24.520 UTC [358] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:03:53.952 UTC [362] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:03:55.668 UTC [363] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:03:57.081 UTC [365] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:03:58.278 UTC [366] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:03:59.416 UTC [367] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:00.547 UTC [368] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:01.708 UTC [369] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:02.812 UTC [370] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:03.988 UTC [371] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:33.437 UTC [373] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:44.886 UTC [374] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:04:55.457 UTC [375] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:33.789 UTC [394] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:36.094 UTC [395] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:38.210 UTC [396] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:40.367 UTC [397] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:42.674 UTC [398] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:45.649 UTC [399] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:47.089 UTC [400] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:13:58.447 UTC [403] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:16:02.932 UTC [409] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:15.520 UTC [474] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:18.284 UTC [475] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:19.380 UTC [476] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:20.362 UTC [477] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:21.280 UTC [478] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:44.899 UTC [480] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:45.986 UTC [481] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:46.654 UTC [482] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:47.346 UTC [483] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:47.962 UTC [484] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:48.575 UTC [485] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:49.197 UTC [486] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:49.807 UTC [487] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:21:50.565 UTC [488] LOG: invalid length of startup packet
db_1 | 2020-08-07 23:22:24.892 UTC [490] LOG: invalid length of startup packet
db_1 | 2020-08-08 08:12:11.780 UTC [1585] FATAL: password authentication failed for user "postgres"
db_1 | 2020-08-08 08:12:11.780 UTC [1585] DETAIL: Role "postgres" does not exist.
db_1 | Connection matched pg_hba.conf line 95: "host all all all md5"
db_1 | 2020-08-08 08:57:32.966 UTC [1674] FATAL: canceling authentication due to timeout
db_1 | 2020-08-08 18:03:32.162 UTC [2770] LOG: invalid length of startup packet
db_1 | 2020-08-08 18:04:45.424 UTC [2773] LOG: invalid length of startup packet
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment