Error with production database #66
Description
I would have loved to give a more specific title, but I don't know what's going on. My script complains, that my SQL is faulty, but that's not the case.
I am running serverless-mysql with Zeit (by recommendation) and mysql2 (because mysql package currently doesn't support MySQL 8 auth strategy).
When I ran my script locally with my local database, it works. Now, that I've plugged in a MySQL database from DigitalOcean, I get the following error (and that's sadly the only concrete debugging info I could find). Strangely enough, my queries still seem to go through, as database records do get inserted and updated.
Error: Unknown column 'Sleep' in 'where clause'
at Packet.asError (/var/task/node_modules/mysql2/lib/packets/packet.js:712:17)
at Query.execute (/var/task/node_modules/mysql2/lib/commands/command.js:28:26)
at Connection.handlePacket (/var/task/node_modules/mysql2/lib/connection.js:417:32)
at PacketParser.onPacket (/var/task/node_modules/mysql2/lib/connection.js:75:12)
at PacketParser.executeStart (/var/task/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/var/task/node_modules/mysql2/lib/connection.js:82:25)
at Socket.emit (events.js:210:5)
at addChunk (_stream_readable.js:308:12)
at readableAddChunk (_stream_readable.js:289:11)
at Socket.Readable.push (_stream_readable.js:223:10) {
code: 'ER_BAD_FIELD_ERROR',
errno: 1054,
sqlState: '42S22',
sqlMessage: "Unknown column 'Sleep' in 'where clause'"
}2020-01-28T10:46:32.481Z c81ad0f9-ffa4-446e-81a9-4bb0d2aa0ed8 ERROR Unhandled Promise Rejection {"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: undefined","reason":{"errorType":"RangeError","errorMessage":"Invalid status code: undefined","code":"ERR_HTTP_INVALID_STATUS_CODE","stack":["RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: undefined"," at ServerResponse.writeHead (_http_server.js:241:11)"," at ServerResponse._implicitHeader (_http_server.js:232:8)"," at write_ (_http_outgoing.js:607:9)"," at ServerResponse.end (_http_outgoing.js:717:5)"," at send (/var/task/___now_helpers.js:812:13)"," at json (/var/task/___now_helpers.js:826:12)"," at ServerResponse.res.json (/var/task/___now_helpers.js:874:36)"," at exports.default (/zeit/5988ca02/api/test/createPaymentIntent.ts:45:35)"," at processTicksAndRejections (internal/process/task_queues.js:93:5)"]},"promise":{},"stack":["Runtime.UnhandledPromiseRejection: RangeError [ERR_HTTP_INVALID_STATUS_CODE]: Invalid status code: undefined"," at process.<anonymous> (/var/runtime/index.js:35:15)"," at process.emit (events.js:215:7)"," at process.emit (/var/task/__sourcemap_support.js:2535:21)"," at processPromiseRejections (internal/process/promises.js:201:33)"," at processTicksAndRejections (internal/process/task_queues.js:94:32)"]}
Unknown application error occurred