Skip to content

Instantly share code, notes, and snippets.

@nmattam
Created September 14, 2017 16:45
Show Gist options
  • Save nmattam/2daa5f8f71b3290abf1a23a4dcfc8451 to your computer and use it in GitHub Desktop.
Save nmattam/2daa5f8f71b3290abf1a23a4dcfc8451 to your computer and use it in GitHub Desktop.
[vagrant@bootstrap-chef ~]$ cat /var/log/opscode/postgresql/9.2/current
2017-09-11_18:11:41.45145 LOG: database system was shut down at 2017-09-11 18:11:39 GMT
2017-09-11_18:11:41.46421 LOG: database system is ready to accept connections
2017-09-11_18:11:41.46435 LOG: autovacuum launcher started
2017-09-11_18:11:41.48142 received TERM from runit, sending INT instead to force quit connections
2017-09-11_18:11:41.48225 LOG: received fast shutdown request
2017-09-11_18:11:41.48225 LOG: aborting any active transactions
2017-09-11_18:11:41.48285 LOG: autovacuum launcher shutting down
2017-09-11_18:11:41.48296 LOG: shutting down
2017-09-11_18:11:41.48685 LOG: database system is shut down
2017-09-11_18:11:42.70137 LOG: database system was shut down at 2017-09-11 18:11:41 GMT
2017-09-11_18:11:42.70784 LOG: database system is ready to accept connections
2017-09-11_18:11:42.71040 LOG: autovacuum launcher started
2017-09-11_18:11:46.38487 ERROR: relation "changes" does not exist at character 50
2017-09-11_18:11:46.41704 STATEMENT:
2017-09-11_18:11:46.41705 SELECT change_id
2017-09-11_18:11:46.41705 FROM changes
2017-09-11_18:11:46.41705 WHERE project = $1
2017-09-11_18:11:46.41706 ORDER BY committed_at DESC
2017-09-11_18:11:46.41706 LIMIT 1
2017-09-11_18:11:46.41706 OFFSET COALESCE($2, 0)
2017-09-11_18:11:46.41706
2017-09-11_18:11:50.74806 ERROR: relation "changes" does not exist at character 50
2017-09-11_18:11:50.74808 STATEMENT:
2017-09-11_18:11:50.74808 SELECT change_id
2017-09-11_18:11:50.74808 FROM changes
2017-09-11_18:11:50.74808 WHERE project = $1
2017-09-11_18:11:50.74808 ORDER BY committed_at DESC
2017-09-11_18:11:50.74808 LIMIT 1
2017-09-11_18:11:50.74809 OFFSET COALESCE($2, 0)
2017-09-11_18:11:50.74809
2017-09-11_18:17:54.58523 received TERM from runit, sending INT instead to force quit connections
2017-09-11_18:17:54.70160 LOG: received fast shutdown request
2017-09-11_18:17:54.70333 LOG: aborting any active transactions
2017-09-11_18:17:54.70758 LOG: autovacuum launcher shutting down
2017-09-11_18:17:54.71392 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71400 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71401 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71402 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71822 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71823 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71824 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71824 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71824 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.71824 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.72730 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.72821 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.72984 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75298 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75320 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75423 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75460 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75461 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75467 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75708 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75709 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75716 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75771 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.75771 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.77619 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.77725 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.77887 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98640 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98649 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98650 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98650 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98650 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98650 FATAL: terminating connection due to administrator command
2017-09-11_18:17:54.98650 FATAL: terminating connection due to administrator command
2017-09-11_18:17:55.39628 LOG: shutting down
2017-09-11_18:17:55.67896 LOG: database system is shut down
2017-09-11_18:17:56.08212 FATAL: the database system is starting up
2017-09-11_18:17:56.08273 FATAL: the database system is starting up
2017-09-11_18:17:56.08689 LOG: database system was shut down at 2017-09-11 18:17:55 GMT
2017-09-11_18:17:56.16415 FATAL: the database system is starting up
2017-09-11_18:17:56.20572 LOG: database system is ready to accept connections
2017-09-11_18:17:56.20642 FATAL: the database system is starting up
2017-09-11_18:17:56.22964 LOG: autovacuum launcher started
2017-09-11_18:18:18.93840 received TERM from runit, sending INT instead to force quit connections
2017-09-11_18:18:18.94198 LOG: received fast shutdown request
2017-09-11_18:18:18.94539 LOG: aborting any active transactions
2017-09-11_18:18:18.94540 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94540 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94540 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94540 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94540 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94541 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94541 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94541 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94541 FATAL: terminating connection due to administrator command
2017-09-11_18:18:18.94541 LOG: autovacuum launcher shutting down
2017-09-11_18:18:19.53777 FATAL: the database system is shutting down
2017-09-11_18:18:19.53927 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53927 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53927 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53928 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53928 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53928 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53929 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53929 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53929 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53929 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53929 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53929 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53929 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53929 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53930 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53930 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53930 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53930 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53935 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53935 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.53939 FATAL: terminating connection due to administrator command
2017-09-11_18:18:19.53939 STATEMENT: SELECT 'pong' as ping LIMIT 1
2017-09-11_18:18:19.60193 FATAL: the database system is shutting down
2017-09-11_18:18:19.60534 FATAL: the database system is shutting down
2017-09-11_18:18:19.60856 FATAL: the database system is shutting down
2017-09-11_18:18:19.61496 FATAL: the database system is shutting down
2017-09-11_18:18:19.61827 FATAL: the database system is shutting down
2017-09-11_18:18:19.62129 FATAL: the database system is shutting down
2017-09-11_18:18:19.63244 FATAL: the database system is shutting down
2017-09-11_18:18:19.65309 LOG: shutting down
2017-09-11_18:18:19.69699 FATAL: the database system is shutting down
2017-09-11_18:18:19.72599 FATAL: the database system is shutting down
2017-09-11_18:18:19.74825 FATAL: the database system is shutting down
2017-09-11_18:18:19.76894 FATAL: the database system is shutting down
2017-09-11_18:18:19.79264 LOG: database system is shut down
2017-09-11_18:20:09.02547 LOG: database system was shut down at 2017-09-11 18:18:19 GMT
2017-09-11_18:20:09.05166 LOG: database system is ready to accept connections
2017-09-11_18:20:09.05308 LOG: autovacuum launcher started
2017-09-11_18:22:16.03969 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:22:16.04043 DETAIL: Key (parent, child)=(5, 1) already exists.
2017-09-11_18:22:16.04048 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:22:16.04049 values (actor_id($1), group_id($2))
2017-09-11_18:22:16.12748 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:22:16.12750 DETAIL: Key (parent, child)=(2, 1) already exists.
2017-09-11_18:22:16.12750 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:22:16.12750 values (actor_id($1), group_id($2))
2017-09-11_18:22:53.15335 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:22:53.15377 DETAIL: Key (parent, child)=(12, 1) already exists.
2017-09-11_18:22:53.15377 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:22:53.15377 values (actor_id($1), group_id($2))
2017-09-11_18:23:15.91733 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:23:15.91775 DETAIL: Key (parent, child)=(9, 1) already exists.
2017-09-11_18:23:15.91776 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:23:15.91776 values (actor_id($1), group_id($2))
2017-09-11_18:23:40.23380 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:23:40.23431 DETAIL: Key (parent, child)=(19, 1) already exists.
2017-09-11_18:23:40.23431 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:23:40.23431 values (actor_id($1), group_id($2))
2017-09-11_18:23:49.75297 ERROR: duplicate key value violates unique constraint "group_actor_relations_pkey"
2017-09-11_18:23:49.75327 DETAIL: Key (parent, child)=(16, 1) already exists.
2017-09-11_18:23:49.75327 STATEMENT: INSERT INTO group_actor_relations(child, parent)
2017-09-11_18:23:49.75327 values (actor_id($1), group_id($2))
2017-09-11_18:25:09.32192 ERROR: relation "changes" does not exist at character 50
2017-09-11_18:25:09.32322 STATEMENT:
2017-09-11_18:25:09.32322 SELECT change_id
2017-09-11_18:25:09.32323 FROM changes
2017-09-11_18:25:09.32323 WHERE project = $1
2017-09-11_18:25:09.32323 ORDER BY committed_at DESC
2017-09-11_18:25:09.32323 LIMIT 1
2017-09-11_18:25:09.32323 OFFSET COALESCE($2, 0)
2017-09-11_18:25:09.32323
2017-09-11_18:25:24.39777 ERROR: relation "changes" does not exist at character 50
2017-09-11_18:25:24.39834 STATEMENT:
2017-09-11_18:25:24.39835 SELECT change_id
2017-09-11_18:25:24.39835 FROM changes
2017-09-11_18:25:24.39836 WHERE project = $1
2017-09-11_18:25:24.39836 ORDER BY committed_at DESC
2017-09-11_18:25:24.39836 LIMIT 1
2017-09-11_18:25:24.39836 OFFSET COALESCE($2, 0)
2017-09-11_18:25:24.39836
2017-09-11_18:37:07.55504 received TERM from runit, sending INT instead to force quit connections
2017-09-11_18:37:07.56602 LOG: received fast shutdown request
2017-09-11_18:37:07.56603 LOG: aborting any active transactions
2017-09-11_18:37:07.56603 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56603 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56604 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56604 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56610 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56610 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56610 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56611 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56612 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56612 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56612 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56612 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56613 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56613 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56613 FATAL: terminating connection due to administrator command
2017-09-11_18:37:07.56613 LOG: autovacuum launcher shutting down
2017-09-11_18:37:07.56613 FATAL: terminating connection due to administrator command
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment