Upgrade to Rails 6 causes SQLite dependency error on CentOS

Question

We recently upgraded to Rails 6 and am seeing the following SQLite error when trying to migrate the database or run tests

rails aborted!
Your version of SQLite (3.7.17) is too old. Active Record supports SQLite >= 3.8.

I tried doing a yum updateto update the SQLite drivers etc, but the version of SQLite remained the same at 3.7.17.

How can I upgrade the SQLite packages to make this work with Rails 6?

Answer 1

Unfortunately, the latest version of SQLite packages available in yum is 3.7.17. You will need to download the latest SQLite RPM's manually and yum install them yourself.

wget https://kojipkgs.fedoraproject.org//packages/sqlite/3.8.11/1.fc21/x86_64/sqlite-devel-3.8.11-1.fc21.x86_64.rpm
wget https://kojipkgs.fedoraproject.org//packages/sqlite/3.8.11/1.fc21/x86_64/sqlite-3.8.11-1.fc21.x86_64.rpm

yum install sqlite-3.8.11-1.fc21.x86_64.rpm sqlite-devel-3.8.11-1.fc21.x86_64.rpm

Then you can verify the installed sqlite version with:

sqlite3 --version