Upgrading sqlite from 4.5.80 to 4.11.80

Community Support
1

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:

http://stackoverflow.com/questions/24746558/ruby-sequel-insert-ignore-returns-undefined-method

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

Can some one help out ?

Cheers,
Rui

2

Hi,

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

3

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 ?

4

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,
Rui