One 5.12.01(ce): [SQL_Error]Unknown column 'last_poll' in 'field list'

Hi All!

I’ve upgraded OpenNebula from v. 5.10.5 to 5.12.0.1 by this manual

the tool “fsck” didn’t find any errors:

oneadmin@csor:~$ onedb fsck -S localhost -u one_db_user -d opennebula
MySQL Password: 
MySQL dump stored in /var/lib/one/mysql_localhost_opennebula_2020-8-23_15:55:7.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file



Total errors found: 0
Total errors repaired: 0
Total errors unrepaired: 0
A copy of this output was stored in /var/log/one/onedb-fsck.log

I do created HA-RAFT by this manual:

  1. Configuration of the initial leader
  2. changed from -1 to 0 (as 0 is the server id)
  3. Start OpenNebula.
  4. Check the zone. The server is now the leader and has the floating IP.
    It’s OK

But:

When executing any command is nothing happen:
for example:

oneadmin@FN1:~$ onehost list -f ID=182
  ID NAME                                                    CLUSTER    TVM      ALLOCATED_CPU      ALLOCATED_MEM STAT
 182 XX.YY.ZZ.AA                                           clst1         0      0 / 3200 (0%)   0K / 503.4G (0%) off
oneadmin@FN1:~$ onehost enable 182
oneadmin@FN1:~$ onehost list -f ID=182
  ID NAME                                                    CLUSTER    TVM      ALLOCATED_CPU      ALLOCATED_MEM STAT
 182 XX.YY.ZZ.AA                                          clst1         0      0 / 3200 (0%)   0K / 503.4G (0%) off

or

oneadmin@FN1:~$ onetemplate delete 1850
[one.template.delete] Cannot delete virtual machine template. SQL DB error

etc.

there is often goes an error in the log (oned.log):
Sun Aug 23 16:37:17 2020 [Z0][ONE][E]: SQL command was: UPDATE vm_pool SET name = ‘cloud-snova’, body = ‘82523 …
…’ WHERE oid = 82523, error 1054 : Unknown column ‘last_poll’ in ‘field list’

If to change Status of FN from “leader” to “solo” (I mean: changed from 0 to -1 ) is everything working well.
And oned.log isn’t contained the error.

Tried to add two followers also. But problem is still existed.

oned.conf:

..
FEDERATION=MASTER_ONED=,MODE=STANDALONE,SERVER_ID=0,ZONE_ID=0
...
LISTEN_ADDRESS=0.0.0.0
..
RAFT=BROADCAST_TIMEOUT_MS=500,ELECTION_TIMEOUT_MS=5000,LIMIT_PURGE=100000,LOG_PURGE_TIMEOUT=60,LOG_RETENTION=250000,XMLRPC_TIMEOUT_MS=1000

For while debug iptables on FN’s has been disabled


Versions of the related components and OS (frontend, hypervisors, VMs):
[root@vm221-219 ~]# cat /etc/*release
CentOS Linux release 7.8.2003 (Core)

[root@FN1 ~]# rpm -qa | grep opennebula
opennebula-gate-5.12.0.1-1.ce.el7.noarch
opennebula-ruby-5.12.0.1-1.ce.el7.noarch
opennebula-sunstone-5.12.0.1-1.ce.el7.noarch
opennebula-rubygems-5.12.0.1-1.ce.el7.x86_64
opennebula-server-5.12.0.1-1.ce.el7.x86_64
opennebula-migration-community-5.12.0-2.ee.el7.noarch
opennebula-common-onescape-5.12.0.1-1.ce.el7.noarch
opennebula-5.12.0.1-1.ce.el7.x86_64
opennebula-flow-5.12.0.1-1.ce.el7.noarch
opennebula-common-5.12.0.1-1.ce.el7.noarch

[root@FN1 ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.65-1.el7.x86_64
mariadb-server-5.5.65-1.el7.x86_64
mariadb-devel-5.5.65-1.el7.x86_64
mariadb-5.5.65-1.el7.x86_64

Steps to reproduce:

Current results:

Expected results:

1 Like

Hi @telecast, I seeing the same problem in my setup.
Have you found any solution?

Not sure, but it seems

DELETE from logdb;

solves the problem