# One 5.12.01(ce): \[SQL\_Error\]Unknown column 'last\_poll' in 'field list'
**URL:** https://forum.opennebula.io/t/one-5-12-01-ce-sql-error-unknown-column-last-poll-in-field-list/8752
**Category:** Product Support
**Created:** [August 23, 2020, 2:04pm UTC](https://forum.opennebula.io/t/one-5-12-01-ce-sql-error-unknown-column-last-poll-in-field-list/8752 "2020-08-23T14:04:19Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@telecast](https://forum.opennebula.io/u/telecast)
#### Post date: [August 23, 2020, 2:04pm UTC](https://forum.opennebula.io/t/one-5-12-01-ce-sql-error-unknown-column-last-poll-in-field-list/8752/1 "2020-08-23T14:04:19Z")
Hi All!
I’ve upgraded OpenNebula from v. 5.10.5 to 5.12.0.1 [by this manual](http://docs.opennebula.io/5.12/intro_release_notes/upgrades/upgrading_single.html#upgrading-single-front-end-deployments)
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](http://docs.opennebula.io/5.12/advanced_components/ha/frontend_ha_setup.html) by this manual:
1. [Configuration of the initial leader](http://docs.opennebula.io/5.12/advanced_components/ha/frontend_ha_setup.html#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:**
---
### Author:  [@kvaps](https://forum.opennebula.io/u/kvaps)
#### Post date: [July 22, 2021, 12:55am UTC](https://forum.opennebula.io/t/one-5-12-01-ce-sql-error-unknown-column-last-poll-in-field-list/8752/2 "2021-07-22T00:55:23Z")
Hi @telecast, I seeing the same problem in my setup.
Have you found any solution?
---
### Author:  [@kvaps](https://forum.opennebula.io/u/kvaps)
#### Post date: [July 22, 2021, 1:20pm UTC](https://forum.opennebula.io/t/one-5-12-01-ce-sql-error-unknown-column-last-poll-in-field-list/8752/3 "2021-07-22T13:20:23Z")
Not sure, but it seems
```auto
DELETE from logdb;
```
solves the problem