Created
April 14, 2016 17:22
-
-
Save kevinburkeshyp/f1a4f73f8933e027aebbc53283acced2 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2016-04-14 00:46:35.538 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-32] 00000 ubuntu@circle_test LOG: duration: 3.028 ms | |
2016-04-14 00:46:35.546 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1976] 00000 ubuntu@circle_test LOG: statement: -- clearDB: encodes a numeric input | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:35.549 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1977] 00000 ubuntu@circle_test LOG: duration: 3.060 ms | |
2016-04-14 00:46:35.557 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1964] 00000 ubuntu@circle_test LOG: statement: -- clearDB: returns the string if its length is shorter than the `numCharsVisible` | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:35.560 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1965] 00000 ubuntu@circle_test LOG: duration: 3.200 ms | |
2016-04-14 00:46:35.568 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-36] 00000 ubuntu@circle_test LOG: statement: -- clearDB: returns true if the user name is valid | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:35.571 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-37] 00000 ubuntu@circle_test LOG: duration: 3.064 ms | |
2016-04-14 00:46:35.580 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-974] 00000 ubuntu@circle_test LOG: statement: -- clearDB: rejects with an InvalidDataError when a user object is not provided | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:35.583 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-975] 00000 ubuntu@circle_test LOG: duration: 3.153 ms | |
2016-04-14 00:46:35.591 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-33] 00000 ubuntu@circle_test LOG: statement: -- clearDB: resolves with an empty array if the user does not qualify for any discounts | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:35.594 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-34] 00000 ubuntu@circle_test LOG: duration: 2.945 ms | |
2016-04-14 00:46:35.613 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1978] 00000 ubuntu@circle_test LOG: duration: 0.148 ms | |
2016-04-14 00:46:35.613 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1979] 00000 ubuntu@circle_test LOG: duration: 0.122 ms | |
2016-04-14 00:46:35.613 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1980] 00000 ubuntu@circle_test LOG: execute <unnamed>: INSERT INTO "users" ("email", "id", "isPrivate", "phoneNumberVerified", "referralCode", "completedPickupCount", "isDriver", "isPacker", "isOps", "isAdmin", "paymentStatus", "volumeTier", "volumeTierOverride", "createdAt", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING * | |
2016-04-14 00:46:35.613 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1981] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'test239@example.com', $2 = 'usr_92a6e156-526a-49ea-aab4-3b4e3a33795c', $3 = 'f', $4 = 'f', $5 = 'TEAMJAMES_6c699ece-75c2-4c35-b1ed-3fef749ded47', $6 = '0', $7 = 'f', $8 = 'f', $9 = 'f', $10 = 'f', $11 = 'NONE', $12 = 'NONE', $13 = 'NONE', $14 = '2016-04-14 00:46:35.596+00', $15 = '2016-04-14 00:46:35.596+00' | |
2016-04-14 00:46:53.627 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1966] 00000 ubuntu@circle_test LOG: statement: -- clearDB: resolves with an array of discounts if the user qualifies for multiple discounts | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... snip ... | |
DELETE FROM warehouses; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
ALTER SEQUENCE "verificationcodes_autoId_seq" RESTART WITH 1;; COMMIT; | |
2016-04-14 00:46:53.630 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1967] 00000 ubuntu@circle_test LOG: duration: 3.317 ms | |
2016-04-14 00:46:53.648 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-38] 00000 ubuntu@circle_test LOG: duration: 0.135 ms | |
2016-04-14 00:46:53.648 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-39] 00000 ubuntu@circle_test LOG: duration: 0.138 ms | |
2016-04-14 00:46:53.648 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-40] 00000 ubuntu@circle_test LOG: execute <unnamed>: INSERT INTO "users" ("email", "id", "isPrivate", "phoneNumberVerified", "referralCode", "completedPickupCount", "isDriver", "isPacker", "isOps", "isAdmin", "paymentStatus", "volumeTier", "volumeTierOverride", "createdAt", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING * | |
2016-04-14 00:46:53.648 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-41] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'person@example.com', $2 = 'usr_010a3fc7-c178-44a3-ab37-229c994e37d8', $3 = 'f', $4 = 'f', $5 = 'TEAMJAMES_d3945b76-cefa-4915-bc38-4b40e1281c64', $6 = '0', $7 = 'f', $8 = 'f', $9 = 'f', $10 = 'f', $11 = 'NONE', $12 = 'NONE', $13 = 'NONE', $14 = '2016-04-14 00:46:53.632+00', $15 = '2016-04-14 00:46:53.632+00' | |
2016-04-14 00:46:54.649 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-42] 00000 ubuntu@circle_test LOG: process 14308 still waiting for ExclusiveLock on extension of relation 17215 of database 16387 after 1000.104 ms | |
2016-04-14 00:46:54.649 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-43] 00000 ubuntu@circle_test DETAIL: Process holding the lock: 14260. Wait queue: 14308. | |
2016-04-14 00:46:54.649 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-44] 00000 ubuntu@circle_test STATEMENT: INSERT INTO "users" ("email", "id", "isPrivate", "phoneNumberVerified", "referralCode", "completedPickupCount", "isDriver", "isPacker", "isOps", "isAdmin", "paymentStatus", "volumeTier", "volumeTierOverride", "createdAt", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING * | |
2016-04-14 00:46:58.979 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-45] 00000 ubuntu@circle_test LOG: process 14308 acquired ExclusiveLock on extension of relation 17215 of database 16387 after 5330.117 ms | |
2016-04-14 00:46:58.979 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-46] 00000 ubuntu@circle_test STATEMENT: INSERT INTO "users" ("email", "id", "isPrivate", "phoneNumberVerified", "referralCode", "completedPickupCount", "isDriver", "isPacker", "isOps", "isAdmin", "paymentStatus", "volumeTier", "volumeTierOverride", "createdAt", "updatedAt") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING * | |
2016-04-14 00:46:58.979 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-47] 00000 ubuntu@circle_test LOG: duration: 5330.732 ms | |
2016-04-14 00:46:58.979 UTC 2016-04-14 00:45:45 UTC [14260-570ee839.37b4-1982] 00000 ubuntu@circle_test LOG: duration: 23365.739 ms | |
2016-04-14 00:46:59.005 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-976] 00000 ubuntu@circle_test LOG: duration: 0.127 ms | |
2016-04-14 00:46:59.005 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-977] 00000 ubuntu@circle_test LOG: duration: 0.114 ms | |
2016-04-14 00:46:59.005 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-978] 00000 ubuntu@circle_test LOG: execute <unnamed>: INSERT INTO "domaindiscounts" ("domain", "type", "isDeleted", "id", "createdAt", "updatedAt") values ($1, $2, $3, $4, $5, $6) RETURNING * | |
2016-04-14 00:46:59.005 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-979] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'example.com', $2 = 'FREE_PICKUP', $3 = 'f', $4 = 'ddisc_ab15cae1-d53d-46a8-9bf3-f09cebde6058', $5 = '2016-04-14 00:46:58.987+00', $6 = '2016-04-14 00:46:58.987+00' | |
2016-04-14 00:46:59.006 UTC 2016-04-14 00:46:23 UTC [14304-570ee85f.37e0-980] 00000 ubuntu@circle_test LOG: duration: 0.241 ms | |
2016-04-14 00:46:59.027 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-35] 00000 ubuntu@circle_test LOG: duration: 0.290 ms | |
2016-04-14 00:46:59.027 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-36] 00000 ubuntu@circle_test LOG: duration: 0.128 ms | |
2016-04-14 00:46:59.027 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-37] 00000 ubuntu@circle_test LOG: execute <unnamed>: SELECT "domaindiscounts"."id", "domaindiscounts"."domain", "domaindiscounts"."type", "domaindiscounts"."isDeleted", "domaindiscounts"."createdAt", "domaindiscounts"."updatedAt" FROM "domaindiscounts" AS "domaindiscounts" WHERE LOWER("domaindiscounts"."domain") = $1 AND "domaindiscounts"."isDeleted" = $2 | |
2016-04-14 00:46:59.027 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-38] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'example.com', $2 = 'f' | |
2016-04-14 00:46:59.027 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-39] 00000 ubuntu@circle_test LOG: duration: 0.042 ms | |
2016-04-14 00:46:59.045 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1968] 00000 ubuntu@circle_test LOG: duration: 0.184 ms | |
2016-04-14 00:46:59.045 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1969] 00000 ubuntu@circle_test LOG: duration: 0.110 ms | |
2016-04-14 00:46:59.045 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1970] 00000 ubuntu@circle_test LOG: execute <unnamed>: SELECT "userdiscounts"."id", "userdiscounts"."userId", "userdiscounts"."type", "userdiscounts"."isDeleted", "userdiscounts"."createdAt", "userdiscounts"."updatedAt" FROM "userdiscounts" AS "userdiscounts" WHERE LOWER("userdiscounts"."userId") = $1 AND "userdiscounts"."isDeleted" = $2 | |
2016-04-14 00:46:59.045 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1971] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'usr_92a6e156-526a-49ea-aab4-3b4e3a33795c', $2 = 'f' | |
2016-04-14 00:46:59.045 UTC 2016-04-14 00:45:45 UTC [14262-570ee839.37b6-1972] 00000 ubuntu@circle_test LOG: duration: 0.037 ms | |
2016-04-14 00:46:59.066 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-48] 00000 ubuntu@circle_test LOG: duration: 0.192 ms | |
2016-04-14 00:46:59.067 UTC 2016-04-14 00:46:34 UTC [14308-570ee86a.37e4-49] 00000 ubuntu@circle_test LOG: duration: 0.142 ms | |
2016-04-14 00:46:59.138 UTC 2016-04-14 00:46:34 UTC [14309-570ee86a.37e5-40] 00000 ubuntu@circle_test LOG: statement: -- clearDB: rejects with an InvalidDataError when a user ID is not specified | |
BEGIN; SET CONSTRAINTS ALL DEFERRED; DELETE FROM accesstokens; | |
DELETE FROM addresses; | |
... |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment