5 replies

Runtime Error with MYSQL8 After Migrating from @sqlfx/sql-mysql to @effect/sql-mysql2

FYI: after migrating from

@sqlfx/sql-mysql

@sqlfx/sql-mysql

(the mariadb implementation) to

@effect/sql-mysql2

@effect/sql-mysql2

, I've noticed a runtime error when using MYSQL8. When using MYSQL5.7, the issue was not present. The error reads:

SqlError: ER_WRONG_ARGUMENTS: Incorrect arguments to mysqld_stmt_execute
    at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Execute.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnect...

SqlError: ER_WRONG_ARGUMENTS: Incorrect arguments to mysqld_stmt_execute
    at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Execute.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnect...

You can read more about why this is happening in this mysql2 issue. My hotfix was to run

yarn patch mysql2

yarn patch mysql2

and then make the change described here. This fix works for both versions of MYSQL.

Effect Community•2y ago•

5 replies

attila

Runtime Error with MYSQL8 After Migrating from @sqlfx/sql-mysql to @effect/sql-mysql2

FYI: after migrating from

@sqlfx/sql-mysql

@sqlfx/sql-mysql

(the mariadb implementation) to

@effect/sql-mysql2

@effect/sql-mysql2

, I've noticed a runtime error when using MYSQL8. When using MYSQL5.7, the issue was not present. The error reads:

SqlError: ER_WRONG_ARGUMENTS: Incorrect arguments to mysqld_stmt_execute
    at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Execute.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnect...

SqlError: ER_WRONG_ARGUMENTS: Incorrect arguments to mysqld_stmt_execute
    at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
    at Execute.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnect...

You can read more about why this is happening in this mysql2 issue. My hotfix was to run

yarn patch mysql2

yarn patch mysql2

and then make the change described here. This fix works for both versions of MYSQL.

Runtime Error with MYSQL8 After Migrating from @sqlfx/sql-mysql to @effect/sql-mysql2

Similar Threads

Runtime Error with MYSQL8 After Migrating from @sqlfx/sql-mysql to @effect/sql-mysql2

Similar Threads

Similar Threads

Similar Threads