search

withmoney / withmoney-api

A Server Restfull in express to financial control.
https://withmoney.me
8 stars 2 forks source link

raises an error when try apply migration. #76

Closed wasnio closed 5 years ago

wasnio commented 5 years ago

database: postgres (PostgreSQL) 10.5

Error:


sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators node_modules/sequelize/lib/sequelize.js:242:13
== 20180601120737-add_email_to_user: migrating =======

ERROR: Migration 20180601120737-add_email_to_user.js (or wrapper) didn't return a promise

error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.```
wasnio commented 5 years ago 

api_1  | == 20180331224058-create-users: migrating =======
api_1  | == 20180331224058-create-users: migrated (0.349s)
api_1  |
api_1  | == 20180331224356-create-accounts: migrating =======
api_1  | == 20180331224356-create-accounts: migrated (0.139s)
api_1  |
api_1  | == 20180401132632-create-transations: migrating =======
api_1  | == 20180401132632-create-transations: migrated (0.117s)
api_1  |
api_1  | == 20180404224317-create-transfers: migrating =======
api_1  | == 20180404224317-create-transfers: migrated (0.173s)
api_1  |
api_1  | == 20180601120737-add_email_to_user: migrating =======
api_1  |
api_1  | ERROR: Migration 20180601120737-add_email_to_user.js (or wrapper) didn't return a promise
api_1  |
api_1  | npm ERR! code ELIFECYCLE
api_1  | npm ERR! errno 1
api_1  | npm ERR! api-withmoney@1.0.0 sequelize: `node -r dotenv/config ./node_modules/.bin/sequelize "db:migrate"`
api_1  | npm ERR! Exit status 1
api_1  | npm ERR!
api_1  | npm ERR! Failed at the api-withmoney@1.0.0 sequelize script.
api_1  | npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
api_1  |
api_1  | npm ERR! A complete log of this run can be found in:
api_1  | npm ERR!     /root/.npm/_logs/2019-01-28T16_22_07_382Z-debug.log
db_1   | 2019-01-28T16:22:07.393983Z 4 [Note] Aborted connection 4 to db: 'mymoney_test' user: 'root' host: '172.20.0.3' (Got an error reading communication packets)
api_1  |
api_1  | > api-withmoney@1.0.0 truncate /usr/src/app
api_1  | > babel-node ./config/clean.js
api_1  |
api_1  | Mon, 28 Jan 2019 16:22:09 GMT sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators at node_modules/sequelize/lib/sequelize.js:242:13
api_1  | Executing (default): DELETE FROM `Accounts`
api_1  | Executing (default): DELETE FROM `Categories`
api_1  | Executing (default): DELETE FROM `Journals`
api_1  | Executing (default): DELETE FROM `Transactions`
api_1  | Executing (default): DELETE FROM `Users`
api_1  | { SequelizeDatabaseError: Table 'mymoney_test.Categories' doesn't exist
api_1  |     at Query.formatError (/usr/src/app/node_modules/sequelize/lib/dialects/mysql/query.js:247:16)
api_1  |     at Query.handler [as onResult] (/usr/src/app/node_modules/sequelize/lib/dialects/mysql/query.js:68:23)
api_1  |     at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:30:14)
api_1  |     at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/connection.js:455:32)
api_1  |     at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/connection.js:73:18)
api_1  |     at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
api_1  |     at Socket.<anonymous> (/usr/src/app/node_modules/mysql2/lib/connection.js:80:31)
api_1  |     at Socket.emit (events.js:182:13)
api_1  |     at Socket.EventEmitter.emit (domain.js:441:20)
api_1  |     at addChunk (_stream_readable.js:283:12)
api_1  |     at readableAddChunk (_stream_readable.js:264:11)
api_1  |     at Socket.Readable.push (_stream_readable.js:219:10)
api_1  |     at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
api_1  |   name: 'SequelizeDatabaseError',
api_1  |   parent:
api_1  |    { Error: Table 'mymoney_test.Categories' doesn't exist
api_1  |        at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:684:17)
api_1  |        at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:28:26)
api_1  |        at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/connection.js:455:32)
api_1  |        at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/connection.js:73:18)
api_1  |        at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
api_1  |        at Socket.<anonymous> (/usr/src/app/node_modules/mysql2/lib/connection.js:80:31)
api_1  |        at Socket.emit (events.js:182:13)
api_1  |        at Socket.EventEmitter.emit (domain.js:441:20)
api_1  |        at addChunk (_stream_readable.js:283:12)
api_1  |        at readableAddChunk (_stream_readable.js:264:11)
api_1  |        at Socket.Readable.push (_stream_readable.js:219:10)
api_1  |        at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
api_1  |      code: 'ER_NO_SUCH_TABLE',
api_1  |      errno: 1146,
api_1  |      sqlState: '42S02',
api_1  |      sqlMessage: 'Table \'mymoney_test.Categories\' doesn\'t exist',
api_1  |      sql: 'DELETE FROM `Categories`' },
api_1  |   original:
api_1  |    { Error: Table 'mymoney_test.Categories' doesn't exist
api_1  |        at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:684:17)
api_1  |        at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:28:26)
api_1  |        at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/connection.js:455:32)
api_1  |        at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/connection.js:73:18)
api_1  |        at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16)
api_1  |        at Socket.<anonymous> (/usr/src/app/node_modules/mysql2/lib/connection.js:80:31)
api_1  |        at Socket.emit (events.js:182:13)
api_1  |        at Socket.EventEmitter.emit (domain.js:441:20)
api_1  |        at addChunk (_stream_readable.js:283:12)
api_1  |        at readableAddChunk (_stream_readable.js:264:11)
api_1  |        at Socket.Readable.push (_stream_readable.js:219:10)
api_1  |        at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
api_1  |      code: 'ER_NO_SUCH_TABLE',
api_1  |      errno: 1146,
api_1  |      sqlState: '42S02',
api_1  |      sqlMessage: 'Table \'mymoney_test.Categories\' doesn\'t exist',
api_1  |      sql: 'DELETE FROM `Categories`' },
api_1  |   sql: 'DELETE FROM `Categories`' }```
davidcostadev commented 5 years ago

Hello @wallysslima thank you for reporting this to me. I fix this on this #78 pull request.