db-migrate / db-migrate/node-db-migrate

Error: Encoding not recognized: 'undefined' (searched as: 'undefined')

Open
#760 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
2.3k
Forks
361
PR merge metrics
No merged PRs in 30d

Description

## Error: Encoding not recognized: 'undefined' (searched as: 'undefined')

## Current behavior
```
db-migrate up -v --env=prod
```
```
[INFO] Detected and using the projects local version of db-migrate. '/usr/src/app/node_modules/db-migrate/index.js'
[INFO] require: db-migrate-mysql
[INFO] connecting
Ignoring invalid configuration option passed to Connection: driver. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection
[INFO] connected
[INFO] creating table: migrations
[SQL] CREATE TABLE IF NOT EXISTS `migrations` (`id` INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, `name` VARCHAR (255) NOT NULL, `run_on` DATETIME NOT NULL)
[INFO] migration table created
[INFO] loading migrations from dir /usr/src/app/packages/private-service/migrations
[INFO] loading migrations from database
[SQL] SELECT * FROM `migrations` ORDER BY run_on DESC, name DESC
[ERROR] Error: Encoding not recognized: 'undefined' (searched as: 'undefined')
at Object.getCodec (/usr/src/app/node_modules/mysql2/node_modules/iconv-lite/lib/index.js:104:23)
at Object.getEncoder (/usr/src/app/node_modules/mysql2/node_modules/iconv-lite/lib/index.js:115:23)
at Object.exports.encode (/usr/src/app/node_modules/mysql2/lib/parsers/string.js:23:25)
at Query.toPacket (/usr/src/app/node_modules/mysql2/lib/packets/query.js:16:30)
at Query.start (/usr/src/app/node_modules/mysql2/lib/commands/query.js:60:38)
at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:40:22)
at Connection.handlePacket (/usr/src/app/node_modules/mysql2/lib/connection.js:456:32)
at Connection.addCommand (/usr/src/app/node_modules/mysql2/lib/connection.js:478:12)
at Connection.query (/usr/src/app/node_modules/mysql2/lib/connection.js:546:17)
at Class.all (/usr/src/app/node_modules/db-migrate-mysql/index.js:479:34)
at Class.allLoadedMigrations (/usr/src/app/node_modules/db-migrate-base/index.js:726:17)
at Function.Migration.loadFromDatabase (/usr/src/app/node_modules/db-migrate/lib/migration.js:350:12)
at /usr/src/app/node_modules/db-migrate/lib/migrator.js:195:17
at /usr/src/app/node_modules/db-migrate/lib/migration.js:341:5
at FSReqCallback.oncomplete (fs.js:156:23)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
```

## Expected behavior
Migration should be applied

## Minimal reproduction of the problem with instructions
when I run `db-migrate up -v --env=prod`

## Environment
db-migrate 0.11.11
db-migrate-mysql: ^2.1.1
mysql version 8.0.23

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.