· 6 years ago · Jul 24, 2019, 02:10 PM
12019-07-24T14:03:13.403985+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
22019-07-24T14:03:13.413500+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=1bf31091-e386-4540-8773-243ee124aed1 fwd="84.84.90.151" dyno=web.1 connect=0ms service=59860ms status=499 bytes= protocol=https
32019-07-24T14:03:13.414972+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=be6c618c-e736-43fd-93d5-17a1e3494398 fwd="84.84.90.151" dyno=web.1 connect=1ms service=49862ms status=499 bytes= protocol=https
42019-07-24T14:03:16.982436+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
52019-07-24T14:03:16.994679+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
62019-07-24T14:03:18.786937+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
72019-07-24T14:03:18.797027+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
82019-07-24T14:03:50.417567+00:00 heroku[router]: at=info method=OPTIONS path="/users" host=salty-shelf-72145.herokuapp.com request_id=4364d3ce-e836-4f46-a34e-4cd25fb0c3f4 fwd="84.84.90.151" dyno=web.1 connect=2ms service=2ms status=204 bytes=301 protocol=https
92019-07-24T14:03:50.558547+00:00 heroku[router]: at=info method=POST path="/users" host=salty-shelf-72145.herokuapp.com request_id=ff9a4950-21cd-4dac-88db-e1e0922f8d5e fwd="84.84.90.151" dyno=web.1 connect=2ms service=41ms status=201 bytes=298 protocol=https
102019-07-24T14:03:50.547632+00:00 app[web.1]: Executing (default): INSERT INTO "users" ("id","user_username") VALUES (DEFAULT,$1) RETURNING *;
112019-07-24T14:03:50.729985+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
122019-07-24T14:03:50.745664+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=40b9e092-a6b1-4e8d-92e7-7c906db9d2f5 fwd="84.84.90.151" dyno=web.1 connect=1ms service=31955ms status=499 bytes= protocol=https
132019-07-24T14:03:50.746018+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=f49b1a8b-f714-4255-903b-d011bae21f04 fwd="84.84.90.151" dyno=web.1 connect=1ms service=37345ms status=499 bytes= protocol=https
142019-07-24T14:03:50.742724+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=9c6db215-e21c-45fd-820d-ffd16c4ae9d0 fwd="84.84.90.151" dyno=web.1 connect=1ms service=33768ms status=499 bytes= protocol=https
152019-07-24T14:03:50.745909+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=333b5c34-0be2-4c6e-b086-b4e6e24c1f2f fwd="84.84.90.151" dyno=web.1 connect=1ms service=31964ms status=499 bytes= protocol=https
162019-07-24T14:03:50.745894+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=62079e5b-79cc-4195-bbd2-dd10a19cc91e fwd="84.84.90.151" dyno=web.1 connect=1ms service=33758ms status=499 bytes= protocol=https
172019-07-24T14:03:57.072365+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
182019-07-24T14:03:57.085266+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
192019-07-24T14:04:10.014085+00:00 heroku[router]: at=info method=OPTIONS path="/users" host=salty-shelf-72145.herokuapp.com request_id=54093647-8c4d-4828-8d78-319617258794 fwd="84.84.90.151" dyno=web.1 connect=1ms service=2ms status=204 bytes=301 protocol=https
202019-07-24T14:04:10.337589+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=390d2c9a-2626-4377-b1bd-d31a95a42196 fwd="84.84.90.151" dyno=web.1 connect=1ms service=13268ms status=499 bytes= protocol=https
212019-07-24T14:04:10.167865+00:00 app[web.1]: Executing (default): INSERT INTO "users" ("id","user_username") VALUES (DEFAULT,$1) RETURNING *;
222019-07-24T14:04:10.328765+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
232019-07-24T14:04:10.337354+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=d44e2f46-cf9a-4cbc-97c5-44a273d06492 fwd="84.84.90.151" dyno=web.1 connect=0ms service=13262ms status=499 bytes= protocol=https
242019-07-24T14:04:10.177334+00:00 heroku[router]: at=info method=POST path="/users" host=salty-shelf-72145.herokuapp.com request_id=3630c328-1a72-4149-a916-e37575fca5a5 fwd="84.84.90.151" dyno=web.1 connect=1ms service=60ms status=201 bytes=298 protocol=https
252019-07-24T14:04:10.337458+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=2fd90091-1e0b-466d-bba3-7f976c9574af fwd="84.84.90.151" dyno=web.1 connect=1ms service=19611ms status=499 bytes= protocol=https
262019-07-24T14:04:13.263761+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
272019-07-24T14:04:13.276809+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
282019-07-24T14:05:08.299334+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=44500aa2-8f59-4d13-8858-ae87aed5f39f fwd="84.84.90.151" dyno=web.1 connect=0ms service=55027ms status=503 bytes= protocol=https
292019-07-24T14:05:08.293434+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=207f3a90-3717-47f2-92a1-b39470d398f5 fwd="84.84.90.151" dyno=web.1 connect=1ms service=55034ms status=503 bytes= protocol=https
302019-07-24T14:05:08.297350+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=f37bf54e-f1c7-4e47-b47c-e61cd3ede8dc fwd="31.21.20.114" dyno=web.1 connect=1ms service=306896ms status=503 bytes= protocol=https
312019-07-24T14:05:08.299830+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=f8d4dd86-474b-4e50-a5da-d1775dba42a4 fwd="31.21.20.114" dyno=web.1 connect=0ms service=306891ms status=503 bytes= protocol=https
322019-07-24T14:05:08.293578+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=38ff1720-629b-4300-abdd-518f7a98830b fwd="92.110.13.28" dyno=web.1 connect=1ms service=197057ms status=503 bytes= protocol=https
332019-07-24T14:05:08.289265+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=95247cf7-b2cc-4f16-b47e-91f55b18f766 fwd="31.21.20.114" dyno=web.1 connect=0ms service=306895ms status=503 bytes= protocol=https
342019-07-24T14:05:08.293080+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=d20d104f-319f-4389-98a6-57886e555587 fwd="84.84.90.151" dyno=web.1 connect=1ms service=57968ms status=503 bytes= protocol=https
352019-07-24T14:05:08.291871+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=25246914-eb00-4388-9b24-27ef50cf09c3 fwd="84.107.226.55" dyno=web.1 connect=1ms service=306825ms status=503 bytes= protocol=https
362019-07-24T14:05:11.694266+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
372019-07-24T14:05:11.698009+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
382019-07-24T14:05:11.699132+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
392019-07-24T14:05:11.757081+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
402019-07-24T14:05:11.757273+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
412019-07-24T14:05:11.771232+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
422019-07-24T14:05:11.772533+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
432019-07-24T14:05:11.997226+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
442019-07-24T14:05:52.000000+00:00 app[api]: Build started by user marten_bonnema@hotmail.com
452019-07-24T14:06:06.168813+00:00 app[api]: Deploy aff54871 by user marten_bonnema@hotmail.com
462019-07-24T14:06:06.168813+00:00 app[api]: Release v10 created by user marten_bonnema@hotmail.com
472019-07-24T14:06:06.536018+00:00 heroku[web.1]: Restarting
482019-07-24T14:06:06.547354+00:00 heroku[web.1]: State changed from up to starting
492019-07-24T14:06:07.011055+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=7e019e6d-88fe-45c5-ad17-687de3b77f76 fwd="31.21.20.114" dyno=web.1 connect=0ms service=55346ms status=503 bytes= protocol=https
502019-07-24T14:06:07.011721+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=74cf787d-79d4-4e50-8dce-295919a154d4 fwd="84.107.226.55" dyno=web.1 connect=1ms service=55257ms status=503 bytes= protocol=https
512019-07-24T14:06:07.009720+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=628dc300-38d1-4f7d-8e45-a044f6bde44a fwd="84.84.90.151" dyno=web.1 connect=1ms service=55262ms status=503 bytes= protocol=https
522019-07-24T14:06:07.013136+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=da43506c-5f85-4a2a-9eac-d0299911ed37 fwd="92.110.13.28" dyno=web.1 connect=0ms service=55018ms status=503 bytes= protocol=https
532019-07-24T14:06:07.007766+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=aa0ad361-a6a8-42e4-921b-f72dea0d09d7 fwd="84.84.90.151" dyno=web.1 connect=0ms service=55263ms status=503 bytes= protocol=https
542019-07-24T14:06:07.009880+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=2007d3f8-bc54-4105-9792-203c9211089f fwd="84.84.90.151" dyno=web.1 connect=0ms service=55263ms status=503 bytes= protocol=https
552019-07-24T14:06:07.010221+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=edbb55cf-b0bd-4118-9c9a-ab666c723dfc fwd="31.21.20.114" dyno=web.1 connect=0ms service=55349ms status=503 bytes= protocol=https
562019-07-24T14:06:07.013460+00:00 heroku[router]: at=error code=H15 desc="Idle connection" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=be99cd62-72de-4438-a4cc-dbe59f699227 fwd="31.21.20.114" dyno=web.1 connect=1ms service=55357ms status=503 bytes= protocol=https
572019-07-24T14:06:06.000000+00:00 app[api]: Build succeeded
582019-07-24T14:06:07.688005+00:00 heroku[web.1]: Stopping all processes with SIGTERM
592019-07-24T14:06:07.785610+00:00 heroku[web.1]: Process exited with status 143
602019-07-24T14:06:09.787291+00:00 heroku[web.1]: Starting process with command `npm start`
612019-07-24T14:06:13.407062+00:00 app[web.1]:
622019-07-24T14:06:13.407083+00:00 app[web.1]: > lookbackr-server@1.0.0 start /app
632019-07-24T14:06:13.407085+00:00 app[web.1]: > node index.js
642019-07-24T14:06:13.407087+00:00 app[web.1]:
652019-07-24T14:06:14.376527+00:00 app[web.1]: Listening on port: 52328
662019-07-24T14:06:14.584870+00:00 app[web.1]: Executing (default): CREATE TABLE IF NOT EXISTS "retros" ("id" SERIAL , "name" VARCHAR(255) NOT NULL, "description" TEXT NOT NULL, "active" BOOLEAN NOT NULL DEFAULT true, PRIMARY KEY ("id"));
672019-07-24T14:06:14.593798+00:00 app[web.1]: Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'retros' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
682019-07-24T14:06:14.623364+00:00 app[web.1]: Executing (default): CREATE TABLE IF NOT EXISTS "users" ("id" SERIAL , "user_username" VARCHAR(255) NOT NULL, "retroId" INTEGER REFERENCES "retros" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
692019-07-24T14:06:14.630165+00:00 app[web.1]: Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'users' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
702019-07-24T14:06:14.642012+00:00 app[web.1]: Executing (default): CREATE TABLE IF NOT EXISTS "cards" ("id" SERIAL , "text" TEXT NOT NULL, "type" VARCHAR(255) NOT NULL, "userId" INTEGER REFERENCES "users" ("id") ON DELETE SET NULL ON UPDATE CASCADE, "retroId" INTEGER REFERENCES "retros" ("id") ON DELETE SET NULL ON UPDATE CASCADE, PRIMARY KEY ("id"));
712019-07-24T14:06:14.645080+00:00 app[web.1]: Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'cards' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
722019-07-24T14:06:14.663250+00:00 app[web.1]: Database schema has been updated
732019-07-24T14:06:15.045426+00:00 heroku[web.1]: State changed from starting to up
742019-07-24T14:06:15.415969+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
752019-07-24T14:06:15.438863+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
762019-07-24T14:06:16.286090+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
772019-07-24T14:06:16.328239+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
782019-07-24T14:06:16.328640+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
792019-07-24T14:06:16.410517+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
802019-07-24T14:06:16.411091+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
812019-07-24T14:06:16.532966+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
822019-07-24T14:06:17.165125+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
832019-07-24T14:06:28.758506+00:00 heroku[router]: at=info method=OPTIONS path="/rooms" host=salty-shelf-72145.herokuapp.com request_id=06f3a024-00cb-4097-93d7-3f0bc45438fc fwd="84.107.226.55" dyno=web.1 connect=0ms service=4ms status=204 bytes=301 protocol=https
842019-07-24T14:06:28.746502+00:00 heroku[router]: at=info method=OPTIONS path="/rooms/15" host=salty-shelf-72145.herokuapp.com request_id=b5160607-83af-46cd-88ff-14e0d5de2f0b fwd="84.107.226.55" dyno=web.1 connect=1ms service=9ms status=204 bytes=301 protocol=https
852019-07-24T14:06:29.053699+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=f8b206cc-6ca4-43f7-bc11-5aca8e15e023 fwd="84.84.90.151" dyno=web.1 connect=0ms service=13681ms status=499 bytes= protocol=https
862019-07-24T14:06:28.896972+00:00 app[web.1]: REQUEST BODY????????????? { user: { id: 133 } }
872019-07-24T14:06:28.989856+00:00 app[web.1]: Executing (default): SELECT "id", "user_username" AS "username", "retroId" FROM "users" AS "user" WHERE "user"."id" = 133;
882019-07-24T14:06:28.994321+00:00 app[web.1]: Executing (default): INSERT INTO "retros" ("id","name","description","active") VALUES (DEFAULT,$1,$2,$3) RETURNING *;
892019-07-24T14:06:29.029426+00:00 app[web.1]: Executing (default): UPDATE "users" SET "retroId"=$1 WHERE "id" = $2
902019-07-24T14:06:29.034359+00:00 app[web.1]: Executing (default): SELECT "id", "name", "description", "active" FROM "retros" AS "retro";
912019-07-24T14:06:29.053424+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=29c49060-0a87-4836-b8b7-e22433eeabac fwd="84.84.90.151" dyno=web.1 connect=1ms service=12684ms status=499 bytes= protocol=https
922019-07-24T14:06:29.053583+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=727d98d3-b5ab-4aba-8c80-daac98add17b fwd="84.84.90.151" dyno=web.1 connect=1ms service=13682ms status=499 bytes= protocol=https
932019-07-24T14:06:29.059897+00:00 heroku[router]: at=info method=PUT path="/rooms/15" host=salty-shelf-72145.herokuapp.com request_id=a291d83b-4928-4792-a575-4dded036d228 fwd="84.107.226.55" dyno=web.1 connect=1ms service=199ms status=200 bytes=289 protocol=https
942019-07-24T14:06:29.054394+00:00 heroku[router]: at=info method=POST path="/rooms" host=salty-shelf-72145.herokuapp.com request_id=68855934-1463-4f63-8a4a-7e54287fd97a fwd="84.107.226.55" dyno=web.1 connect=0ms service=184ms status=200 bytes=337 protocol=https
952019-07-24T14:06:32.931991+00:00 heroku[router]: at=info method=OPTIONS path="/users" host=salty-shelf-72145.herokuapp.com request_id=6b3d2bc0-9245-470a-b5ce-1ebe27f7be4f fwd="84.84.90.151" dyno=web.1 connect=1ms service=4ms status=204 bytes=301 protocol=https
962019-07-24T14:06:33.067053+00:00 heroku[router]: at=info method=POST path="/users" host=salty-shelf-72145.herokuapp.com request_id=2fb7ecc1-939a-488f-8b5b-a7cdaf6193c9 fwd="84.84.90.151" dyno=web.1 connect=0ms service=31ms status=201 bytes=298 protocol=https
972019-07-24T14:06:33.041719+00:00 app[web.1]: Executing (default): INSERT INTO "users" ("id","user_username") VALUES (DEFAULT,$1) RETURNING *;
982019-07-24T14:06:33.245151+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";
992019-07-24T14:06:35.986743+00:00 heroku[router]: sock=client at=warning code=H27 desc="Client Request Interrupted" method=GET path="/stream" host=salty-shelf-72145.herokuapp.com request_id=0bee8198-1b39-4e56-8087-982ea63941b0 fwd="92.110.13.28" dyno=web.1 connect=0ms service=19476ms status=499 bytes= protocol=https
1002019-07-24T14:06:35.971007+00:00 app[web.1]: Executing (default): SELECT "retro"."id", "retro"."name", "retro"."description", "retro"."active", "users"."id" AS "users.id", "users"."user_username" AS "users.username", "users"."retroId" AS "users.retroId", "cards"."id" AS "cards.id", "cards"."text" AS "cards.text", "cards"."type" AS "cards.type", "cards"."userId" AS "cards.userId", "cards"."retroId" AS "cards.retroId" FROM "retros" AS "retro" LEFT OUTER JOIN "users" AS "users" ON "retro"."id" = "users"."retroId" LEFT OUTER JOIN "cards" AS "cards" ON "retro"."id" = "cards"."retroId";