Upgrading sqlite from 4.5.80 to 4.11.80

Hi there,

I’m trying to upgrade opennebula for 4.12 and when i run the DB upgrade script i get this error

onedb upgrade -v --sqlite /var/lib/one/one.db

Error connecting to DB: undefined method `integer_booleans=' for #<Sequel::SQLite::Database: "sqlite://var/lib/one/one.db">

oned.log states the following info:

Tue May 26 11:30:15 2015 [Z0][ONE][E]: Database version mismatch ( local_db_versioning). Installed OpenNebula 4.12.1 needs DB version '4.11.80', and existing DB version is '4.5.80'.

It’s installed in a CentOS env with yum and i have the following versions:

# oned -v
Copyright 2002-2015, OpenNebula Project (OpenNebula.org), C12G Labs
OpenNebula 4.12.1 is distributed and licensed for use under the terms of the
Apache License, Version 2.0 (http://www.apache.org/licenses/LICENSE-2.0).

# ruby -v
ruby 1.8.7 (2013-06-27 patchlevel 374) [x86_64-linux]

I also found a thread with a similiar issue at:


But i’m not sure where to look at, for the DB conversion scripts ?

Can some one help out ?



My guess is that it has to do with the sequel gem version. What are the version for the sequel and sqlite3 gems?

Hi Carlos,

Thanks on the quick feedback.

The gem versions are the following:

sequel (3.30.0)
sqlite3 (1.3.5)
sqlite3-ruby (1.2.4)

Any thoughts ?

Hi Carlos,

You just it the pot :smile:
I’ve updated the gems and re-run without problems.

gem update

onedb upgrade -v --sqlite /var/lib/one/one.db

Thanks for the help,