RDS Production Errors

[sid88in]

at Connection._handleConnectTimeout (/var/task/node_modules/mysql/lib/Connection.js:419:13)
at Socket.g (events.js:292:16)
at emitNone (events.js:86:13)
at Socket.emit (events.js:185:7)
at Socket._onTimeout (net.js:338:8)
at ontimeout (timers.js:386:14)
at tryOnTimeout (timers.js:250:5)
at Timer.listOnTimeout (timers.js:214:5)
--------------------
at Protocol._enqueue (/var/task/node_modules/mysql/lib/protocol/Protocol.js:145:48)
at Protocol.handshake (/var/task/node_modules/mysql/lib/protocol/Protocol.js:52:23)
at Connection.connect (/var/task/node_modules/mysql/lib/Connection.js:130:18)
at /var/task/node_modules/knex/lib/dialects/mysql/index.js:106:18
at Promise._execute (/var/task/node_modules/bluebird/js/release/debuggability.js:303:9)
at Promise._resolveFromExecutor (/var/task/node_modules/bluebird/js/release/promise.js:483:18)
at new Promise (/var/task/node_modules/bluebird/js/release/promise.js:79:10)
at Client_MySQL.acquireRawConnection (/var/task/node_modules/knex/lib/dialects/mysql/index.js:104:12)
at Object.create (/var/task/node_modules/knex/lib/client.js:283:25)
at Pool._createResource (/var/task/node_modules/generic-pool/lib/Pool.js:304:42)
at Pool._ensureMinimum (/var/task/node_modules/generic-pool/lib/Pool.js:334:12)
at Pool.start (/var/task/node_modules/generic-pool/lib/Pool.js:408:10)
at new Pool (/var/task/node_modules/generic-pool/lib/Pool.js:127:12)
at Object.createPool (/var/task/node_modules/generic-pool/index.js:11:12)
at Client_MySQL.initializePool (/var/task/node_modules/knex/lib/client.js:336:29)
at Client_MySQL.Client (/var/task/node_modules/knex/lib/client.js:129:12)
originalMessage: 'select * from `users` where `screen_name` = \'LeoDiCaprio\' - connect ETIMEDOUT',
message: 'Error in resolver Query.getTwitterFeed\nselect * from `users` where `screen_name` = \'LeoDiCaprio\' - connect ETIMEDOUT' }```

[sid88in]

Might be happening because of :

client: process.env.DATABASE_TYPE === 'pg' ? 'pg' : 'mysql',

when we hardcode this to 'pg' I don't get 500

[justinram22]

Just ran into this issue myself -- did you by chance end up keeping the double quotes in your config file? Once I removed the double quotes it worked correctly:

DATABASE_TYPE=pg

(And same goes for DATABASE_URL)

[sid88in]

@justinram22 interesting. Have to check again, but the above errors were intermediate.