Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • Kea Kea
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 562
    • Issues 562
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 69
    • Merge requests 69
  • Deployments
    • Deployments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • ISC Open Source ProjectsISC Open Source Projects
  • KeaKea
  • Issues
  • #444
Closed
Open
Issue created Feb 04, 2019 by Wlodzimierz Wencel@wlodekMaintainer

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/"
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking