Missing Map Site not working

[whatevergeek]

Hi Team,

We have a missing map event tomorrow.
Currently, the main leaderboard site is not working:
http://www.missingmaps.org/leaderboards/#/missingmaps

It would be great if someone can check the issue or suggest a workaround.

[mojodna]

It's back up now.

The underlying problem appears to be that Azure Web Apps sometimes lose connectivity to PostgreSQL:

Knex:Error Pool2 - Error: connect ETIMEDOUT 40.121.<redacted>.<redacted>:5432

I restarted the service on Azure multiple times until it worked; when it doesn't, it's because it's unable to connect to Postgres and the Knex connection pool gets destroyed (and no attempts are made to recreate it).

2018-05-04T17:14:29.445871588Z GET /group-summaries/missingmaps
2018-05-04T17:14:29.446058996Z Error: Pool is destroyed
2018-05-04T17:14:29.446072596Z     at Pool.acquire (/opt/app/node_modules/pool2/lib/pool.js:162:12)
2018-05-04T17:14:29.446080997Z     at /opt/app/node_modules/knex/lib/client.js:204:19
2018-05-04T17:14:29.446089197Z     at tryCatcher (/opt/app/node_modules/knex/node_modules/bluebird/js/main/util.js:26:23)
2018-05-04T17:14:29.446106898Z     at Promise._resolveFromResolver (/opt/app/node_modules/knex/node_modules/bluebird/js/main/promise.js:483:31)
2018-05-04T17:14:29.446115498Z     at new Promise (/opt/app/node_modules/knex/node_modules/bluebird/js/main/promise.js:71:37)
2018-05-04T17:14:29.446123698Z     at Client.acquireConnection (/opt/app/node_modules/knex/lib/client.js:200:12)
2018-05-04T17:14:29.446131799Z     at /opt/app/node_modules/knex/lib/runner.js:136:49
2018-05-04T17:14:29.446139599Z     at tryCatcher (/opt/app/node_modules/knex/node_modules/bluebird/js/main/util.js:26:23)
2018-05-04T17:14:29.446147399Z     at Function.Promise.attempt.Promise.try (/opt/app/node_modules/knex/node_modules/bluebird/js/main/method.js:31:24)
2018-05-04T17:14:29.446155300Z     at Runner.ensureConnection (/opt/app/node_modules/knex/lib/runner.js:135:26)
2018-05-04T17:14:29.446163400Z     at Runner.run (/opt/app/node_modules/knex/lib/runner.js:30:31)
2018-05-04T17:14:29.446171100Z     at QueryBuilder.Target.then (/opt/app/node_modules/knex/lib/interface.js:27:43)
2018-05-04T17:14:29.446179001Z     at process._tickDomainCallback (internal/process/next_tick.js:228:7)

[whatevergeek]

Cool! Thanks a lot for helping @mojodna
It's working now!
The attendees will have a great mapping time on this! :-)

[whatevergeek]

Hi,

There hasn't been an update in the leaderboard for 15hrs. Is there a service somewhere to restart?
You can check the link here:
http://www.missingmaps.org/leaderboards/#/may5map

There are new buildings traced today. But, leaderboard doesn't seem to be in sync.