Home>
Assumptions

When migrating (rails db: migrate) using mysql (mariaDB) in rails, the following error message was issued.
How can you make migration possible? .

Error message
rails aborted!
ActiveRecord :: StatementInvalid: Mysql2 :: Error: Illegal parameter data type bigint for operation 'get_lock': SELECT GET_LOCK (1234567890, 0)
Caused by:
Mysql2 :: Error: Illegal parameter data type bigint for operation 'get_lock'
Tried

Gugu found the following,
I can't find a file to fix,
https://github.com/rails/rails/commit/429b2a2d3af74cdbe058baa29efebe5ef58c4bef

Supplemental information

Rails 5.1.4
10.3.8-MariaDB

  • Answer # 1

    Because the file is activerecord, it is in the path specified bybundle installfirst.

    Specify installation path when installing bundle with rails

    Fixed if the tag is visible in the red frame of the revision commit and v5.2.1 or higher.

Related articles