Skip to content

Instantly share code, notes, and snippets.

@begriffs

begriffs/rep.csv

Created February 8, 2016 21:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save begriffs/e463dfb52af25a86f088 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save begriffs/e463dfb52af25a86f088 to your computer and use it in GitHub Desktop.
Download ZIP
deadlock with return=representation, pool=3, clients=3
Raw
rep.csv
2016-02-08 13:47:45.472 PST j demo1 90926 ::1:49581 56b90d00.1632e 1 idle 2016-02-08 13:47:44 PST 2/88 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 13:47:45.972 PST j demo1 90926 ::1:49581 56b90d00.1632e 2 idle 2016-02-08 13:47:44 PST 2/89 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 13:47:47.979 PST j demo1 90927 ::1:49586 56b90d02.1632f 1 idle 2016-02-08 13:47:46 PST 3/16 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 13:47:48.479 PST j demo1 90927 ::1:49586 56b90d02.1632f 2 idle 2016-02-08 13:47:46 PST 3/17 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 13:47:50.485 PST j demo1 90928 ::1:49587 56b90d05.16330 1 idle 2016-02-08 13:47:49 PST 4/89 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2016-02-08 13:47:50.985 PST j demo1 90926 ::1:49581 56b90d00.1632e 3 idle in transaction 2016-02-08 13:47:44 PST 2/89 0 LOG 00000 statement: set local role 'j';
2016-02-08 13:47:51.486 PST j demo1 90927 ::1:49586 56b90d02.1632f 3 idle in transaction 2016-02-08 13:47:46 PST 3/17 0 LOG 00000 statement: set local role 'j';
2016-02-08 13:47:51.987 PST j demo1 90928 ::1:49587 56b90d05.16330 2 idle 2016-02-08 13:47:49 PST 4/90 0 LOG 00000 statement: begin ISOLATION LEVEL READ COMMITTED;
2016-02-08 13:47:52.487 PST j demo1 90928 ::1:49587 56b90d05.16330 3 idle in transaction 2016-02-08 13:47:49 PST 4/90 0 LOG 00000 statement: set local role 'j';
2016-02-08 13:47:54.502 PST j demo1 90927 ::1:49586 56b90d02.1632f 4 SELECT 2016-02-08 13:47:46 PST 3/17 0 LOG 00000 execute 0: WITH pg_source AS (UPDATE "public"."film" SET "rating"='1'::unknown WHERE "public"."film"."id" = '1'::unknown RETURNING "public"."film".*) SELECT '' AS total_result_set, pg_catalog.count(t) AS page_total, '' AS header, coalesce(array_to_json(array_agg(row_to_json(t))), '[]')::character varying AS body FROM (SELECT "pg_source".* FROM "pg_source" ) t parameters: $1 = '[{"rating":1.0}]'
2016-02-08 13:47:55.005 PST j demo1 90926 ::1:49581 56b90d00.1632e 4 SELECT 2016-02-08 13:47:44 PST 2/89 0 LOG 00000 execute 0: WITH pg_source AS (UPDATE "public"."film" SET "rating"='1'::unknown WHERE "public"."film"."id" = '1'::unknown RETURNING "public"."film".*) SELECT '' AS total_result_set, pg_catalog.count(t) AS page_total, '' AS header, coalesce(array_to_json(array_agg(row_to_json(t))), '[]')::character varying AS body FROM (SELECT "pg_source".* FROM "pg_source" ) t parameters: $1 = '[{"rating":1.0}]'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment