search

18F / standup-slack-bot

A Slack bot to streamline team standup without disturbing the overall flow of conversation
https://standup-slack-bot.app.cloud.gov/
Other
87 stars 31 forks source link

Issue with sequelize & pg 7.3.0 #153

Open radnor opened 7 years ago

radnor commented 7 years ago

After updating pg to 7.3.0 (via #143), I've noticed the bot has trouble when trying to do things with the database, such as schedule a standup and save responses. 

standup-bot_1  | [23 Oct 2017 16:29:07] 📢  verbose create standup Heard a request to create a standup:
standup-bot_1  | schedule standup for 10:30am M W
standup-bot_1  | Unhandled rejection TypeError: Cannot read property '0' of undefined
standup-bot_1  |   at query.catch.then.then.queryResult (/app/node_modules/sequelize/lib/dialects/postgres/query.js:112:17)
standup-bot_1  |   at tryCatcher (/app/node_modules/bluebird/js/release/util.js:16:23)
standup-bot_1  |   at Promise._settlePromiseFromHandler (/app/node_modules/bluebird/js/release/promise.js:510:31)
standup-bot_1  |   at Promise._settlePromise (/app/node_modules/bluebird/js/release/promise.js:567:18)
standup-bot_1  |   at Promise._settlePromise0 (/app/node_modules/bluebird/js/release/promise.js:612:10)
standup-bot_1  |   at Promise._settlePromises (/app/node_modules/bluebird/js/release/promise.js:691:18)                                                                                                                                                       standup-bot_1  |   at Async._drainQueue (/app/node_modules/bluebird/js/release/async.js:133:16)
standup-bot_1  |   at Async._drainQueues (/app/node_modules/bluebird/js/release/async.js:143:10)             
standup-bot_1  |   at Immediate.Async.drainQueues (/app/node_modules/bluebird/js/release/async.js:17:14)
standup-bot_1  |   at runCallback (timers.js:781:20)
standup-bot_1  |   at tryOnImmediate (timers.js:743:5)                                                 
standup-bot_1  |   at processImmediate [as _immediateCallback] (timers.js:714:5)
standup-bot_1  |

Sequelize has an outstanding issue for this: https://github.com/sequelize/sequelize/issues/8043. I've moved pg back to 6.4.2 with my standup bot and it has fixed the error for me.