Page MenuHomePhabricator
Paste P3000

labs postgresql logs 2016-04-30
ActivePublic
Actions

Authored by akosiaris on May 4 2016, 5:54 PM.
Tags
Referenced Files
F3966861: labs postgresql logs 2016-04-30
May 4 2016, 5:54 PM
Subscribers
None
2016-04-28 17:07:41 GMT STATEMENT:
INSERT INTO label VALUES
(306657, 46150227, NOW(), '{"goodfaith": true, "damaging": false, "unsure": false}')
RETURNING *
2016-04-28 23:04:33 GMT WARNING: there is already a transaction in progress
2016-04-28 23:05:24 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:35 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:35 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:35 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:35 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:35 GMT WARNING: there is no transaction in progress
2016-04-29 15:29:51 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:51 GMT WARNING: there is already a transaction in progress
2016-04-29 15:29:51 GMT WARNING: there is already a transaction in progress
2016-04-29 15:30:08 GMT WARNING: there is already a transaction in progress
2016-04-29 15:30:21 GMT WARNING: there is already a transaction in progress
2016-04-30 03:34:28 GMT ERROR: duplicate key value violates unique constraint "label_pkey"
2016-04-30 03:34:28 GMT DETAIL: Key (task_id, user_id)=(269447, 3349) already exists.
2016-04-30 03:34:28 GMT STATEMENT:
INSERT INTO label VALUES
(269447, 3349, NOW(), '{"goodfaith": false, "damaging": true, "unsure": false}')
RETURNING *
2016-04-30 03:35:18 GMT ERROR: duplicate key value violates unique constraint "label_pkey"
2016-04-30 03:35:18 GMT DETAIL: Key (task_id, user_id)=(269945, 3349) already exists.
2016-04-30 03:35:18 GMT STATEMENT:
INSERT INTO label VALUES
(269945, 3349, NOW(), '{"goodfaith": true, "damaging": false, "unsure": false}')
RETURNING *
2016-04-30 03:35:54 GMT ERROR: duplicate key value violates unique constraint "label_pkey"
2016-04-30 03:35:54 GMT DETAIL: Key (task_id, user_id)=(270378, 3349) already exists.
2016-04-30 03:35:54 GMT STATEMENT:
INSERT INTO label VALUES
(270378, 3349, NOW(), '{"goodfaith": true, "damaging": false, "unsure": false}')
RETURNING *
2016-04-30 03:37:23 GMT ERROR: duplicate key value violates unique constraint "label_pkey"
2016-04-30 03:37:23 GMT DETAIL: Key (task_id, user_id)=(270797, 3349) already exists.
2016-04-30 03:37:23 GMT STATEMENT:
INSERT INTO label VALUES
(270797, 3349, NOW(), '{"goodfaith": true, "damaging": false, "unsure": false}')
RETURNING *
2016-04-30 03:37:42 GMT ERROR: duplicate key value violates unique constraint "label_pkey"
2016-04-30 03:37:42 GMT DETAIL: Key (task_id, user_id)=(271087, 3349) already exists.
2016-04-30 03:37:42 GMT STATEMENT:
INSERT INTO label VALUES
(271087, 3349, NOW(), '{"goodfaith": true, "damaging": false, "unsure": false}')
RETURNING *
2016-04-30 04:07:53 GMT WARNING: there is already a transaction in progress
2016-04-30 04:07:53 GMT WARNING: there is already a transaction in progress
2016-04-30 04:07:53 GMT WARNING: there is no transaction in progress
2016-04-30 04:07:53 GMT WARNING: there is no transaction in progress
2016-04-30 04:07:53 GMT WARNING: there is already a transaction in progress
2016-04-30 04:07:58 GMT WARNING: there is already a transaction in progress
2016-04-30 04:08:17 GMT WARNING: there is already a transaction in progress
2016-04-30 04:08:17 GMT WARNING: there is no transaction in progress
2016-04-30 04:09:18 GMT WARNING: there is already a transaction in progress
2016-04-30 04:09:18 GMT WARNING: there is already a transaction in progress
2016-04-30 04:09:18 GMT WARNING: there is already a transaction in progress
2016-04-30 04:09:47 GMT WARNING: there is already a transaction in progress
2016-04-30 04:09:48 GMT WARNING: there is already a transaction in progress
2016-04-30 06:19:05 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is no transaction in progress
2016-04-30 07:59:42 GMT WARNING: there is no transaction in progress
2016-04-30 07:59:51 GMT WARNING: there is already a transaction in progress
2016-04-30 07:59:51 GMT WARNING: there is already a transaction in progress
2016-04-30 09:20:12 GMT WARNING: there is already a transaction in progress

Event Timeline

akosiaris created this paste.May 4 2016, 5:54 PM
akosiaris mentioned this in T130872: [Investigate] Intermittent performance issues with wikilabels.May 4 2016, 5:56 PM
akosiaris added a comment.May 5 2016, 7:45 AM

Adding more logs

2016-05-02 02:10:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:10:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:10:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:10:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:10:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:03 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:03 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:14 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:14 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:14 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:16 GMT WARNING: there is no transaction in progress
2016-05-02 02:11:16 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:16 GMT WARNING: there is no transaction in progress
2016-05-02 02:11:20 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:21 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:21 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:21 GMT WARNING: there is no transaction in progress
2016-05-02 02:11:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:11:26 GMT WARNING: there is no transaction in progress
2016-05-02 02:53:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:53:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:53:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:53:26 GMT WARNING: there is no transaction in progress
2016-05-02 02:53:26 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:37 GMT WARNING: there is no transaction in progress
2016-05-02 02:55:41 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:41 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:41 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:45 GMT WARNING: there is no transaction in progress
2016-05-02 02:55:49 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:52 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:52 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:52 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:52 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:52 GMT WARNING: there is no transaction in progress
2016-05-02 02:55:58 GMT WARNING: there is already a transaction in progress
2016-05-02 02:55:59 GMT WARNING: there is no transaction in progress
2016-05-02 02:56:05 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:05 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:05 GMT WARNING: there is no transaction in progress
2016-05-02 02:56:10 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:10 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:10 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:18 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:18 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:18 GMT WARNING: there is no transaction in progress
2016-05-02 02:56:25 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:25 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:28 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:28 GMT WARNING: there is no transaction in progress
2016-05-02 02:56:28 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:28 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:28 GMT WARNING: there is no transaction in progress
2016-05-02 02:56:34 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:34 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:38 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:38 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:38 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:38 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:38 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:51 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:56 GMT WARNING: there is already a transaction in progress
2016-05-02 02:56:56 GMT WARNING: there is no transaction in progress
2016-05-02 02:57:01 GMT WARNING: there is already a transaction in progress
2016-05-02 03:23:56 GMT WARNING: there is already a transaction in progress
2016-05-02 03:44:59 GMT WARNING: there is already a transaction in progress
2016-05-02 04:12:39 GMT WARNING: there is already a transaction in progress
2016-05-02 04:12:39 GMT WARNING: there is already a transaction in progress
2016-05-02 04:12:39 GMT WARNING: there is already a transaction in progress
2016-05-02 15:27:32 GMT WARNING: there is already a transaction in progress
2016-05-02 15:27:32 GMT WARNING: there is already a transaction in progress
2016-05-02 15:28:17 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:08 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:19 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is no transaction in progress
2016-05-02 19:02:22 GMT WARNING: there is no transaction in progress
2016-05-02 19:02:45 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:45 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:47 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:50 GMT WARNING: there is already a transaction in progress
2016-05-02 19:02:50 GMT WARNING: there is already a transaction in progress
2016-05-02 19:03:19 GMT WARNING: there is already a transaction in progress
2016-05-03 17:38:04 GMT WARNING: there is already a transaction in progress
2016-05-03 17:38:37 GMT WARNING: there is no transaction in progress
2016-05-03 17:39:55 GMT WARNING: there is already a transaction in progress
2016-05-03 17:39:55 GMT WARNING: there is no transaction in progress
2016-05-03 17:44:14 GMT WARNING: there is already a transaction in progress
2016-05-03 17:44:14 GMT WARNING: there is already a transaction in progress
2016-05-03 17:45:31 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:12 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:18 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:20 GMT WARNING: there is no transaction in progress
2016-05-04 05:48:20 GMT WARNING: there is already a transaction in progress
2016-05-04 05:48:45 GMT WARNING: there is already a transaction in progress
2016-05-04 05:49:19 GMT WARNING: there is already a transaction in progress
2016-05-04 14:45:27 GMT ERROR: syntax error at or near "(" at character 36
2016-05-04 14:45:27 GMT STATEMENT: CREATE INDEX workset_user_campaign (user_id, campaign_id);
2016-05-04 14:58:21 GMT ERROR: syntax error at or near "ON" at character 25
2016-05-04 14:58:21 GMT STATEMENT: DROP INDEX workset_user ON workset;
2016-05-04 15:02:26 GMT ERROR: canceling statement due to user request
2016-05-04 15:02:26 GMT STATEMENT: DROP INDEX workset_user;
2016-05-04 15:02:44 GMT ERROR: canceling statement due to user request
2016-05-04 15:02:44 GMT STATEMENT: DROP INDEX workset_user;
2016-05-04 15:18:51 GMT WARNING: there is already a transaction in progress
2016-05-04 15:18:51 GMT WARNING: there is no transaction in progress
2016-05-04 15:19:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:16:57 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is already a transaction in progress
2016-05-04 19:17:15 GMT WARNING: there is no transaction in progress
2016-05-04 19:17:24 GMT WARNING: there is already a transaction in progress
2016-05-04 19:19:52 GMT WARNING: there is already a transaction in progress
2016-05-04 19:29:04 GMT WARNING: there is already a transaction in progress
2016-05-04 20:42:35 GMT WARNING: there is already a transaction in progress
2016-05-04 20:42:35 GMT WARNING: there is already a transaction in progress
2016-05-04 20:43:08 GMT WARNING: there is already a transaction in progress
2016-05-05 00:23:54 GMT WARNING: there is already a transaction in progress
2016-05-05 00:23:54 GMT WARNING: there is no transaction in progress
2016-05-05 00:24:03 GMT WARNING: there is already a transaction in progress
2016-05-05 00:24:46 GMT WARNING: there is already a transaction in progress

Liuxinyu970226 subscribed.Dec 29 2016, 2:29 AM
Liuxinyu970226 unsubscribed.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL