mysql/upgrade_7.0_to_8.0.sh script failure on debian8
Error:
test@debian8-64-1-dhcp:~/jenkins_lab/var/area_A/sbin$ ./kea-admin lease-upgrade mysql -u kea -p kea -n kea
Lease DB version reported before upgrade: 7.0
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_1.0_to_2.0.sh file...
This script upgrades 1.0 to 2.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_2.0_to_3.0.sh file...
This script upgrades 2.0 to 3.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_3.0_to_4.0.sh file...
This script upgrades 3.0 to 4.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_4.0_to_4.1.sh file...
This script upgrades 4.0 to 4.1. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_4.1_to_5.0.sh file...
This script upgrades 4.1 to 5.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_5.0_to_5.1.sh file...
This script upgrades 5.0 to 5.1. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_5.1_to_5.2.sh file...
This script upgrades 5.1 to 5.2. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_5.2_to_6.0.sh file...
This script upgrades 5.2 to 6.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_6.0_to_7.0.sh file...
This script upgrades 6.0 to 7.0. Reported version is 7.0. Skipping upgrade.
Processing /home/test/jenkins_lab/var/area_A/share/kea/scripts/mysql/upgrade_7.0_to_8.0.sh file...
ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL' at line 2
Lease DB version reported after upgrade: 7.0
Versions installed
test@debian8-64-1-dhcp:~/jenkins_lab/var/area_A/sbin$ ./kea-dhcp6 -V
1.5.0-git
git f72bb0f7a221a422a7f03cfd04e0c21df8d33b0e
linked with:
log4cplus 1.0.4
Botan 1.10.8 (released 20140410, revision mtn:3e5da04321de05a3ae1f7177e0dd2191e598dca7, distribution unspecified)
database:
MySQL backend 8.0, library 5.5.62
PostgreSQL backend 5.0, library 90420
Memfile backend 2.1
MySQL:
MYSQL_VERSION: 5.5.62
MYSQL_CPPFLAGS: -I/usr/include/mysql -DBIG_JOINS=1 -fno-strict-aliasing -g -DNDEBUG
MYSQL_LIBS: -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -ldl
OS:
test@debian8-64-1-dhcp:~/jenkins_lab/var/area_A/sbin$ cat /etc/os-release
PRETTY_NAME="Debian GNU/Linux 8 (jessie)"
NAME="Debian GNU/Linux"
VERSION_ID="8"
VERSION="8 (jessie)"
ID=debian
HOME_URL="http://www.debian.org/"
SUPPORT_URL="http://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"