Hi Shane Kerr We had a update schema in last week.
All tables and columns as bellow. + tables assets dhcp4_options dhcp6_options hosts ipv6_reservations lease4 lease6 lease6_types lease_hwaddr_source lease_state schema_version subnet user_auth_token + lease 4 address int(10) unsigned NO PRI hwaddr varbinary(20) YES MUL client_id varbinary(128) YES MUL valid_lifetime int(10) unsigned YES expire timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP subnet_id int(10) unsigned YES fqdn_fwd tinyint(1) YES fqdn_rev tinyint(1) YES hostname varchar(255) YES state int(10) unsigned YES MUL 0 + lease6 address varchar(39) NO PRI duid varbinary(128) YES valid_lifetime int(10) unsigned YES expire timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP subnet_id int(10) unsigned YES pref_lifetime int(10) unsigned YES lease_type tinyint(4) YES iaid int(10) unsigned YES MUL prefix_len tinyint(3) unsigned YES fqdn_fwd tinyint(1) YES fqdn_rev tinyint(1) YES hostname varchar(255) YES hwaddr varbinary(20) YES hwtype smallint(5) unsigned YES hwaddr_source int(10) unsigned YES state int(10) unsigned YES MUL 0 + lease6_types lease_type tinyint(4) NO PRI name varchar(5) YES + lease_hwaddr_source hwaddr_source int(11) NO PRI name varchar(40) YES + hosts host_id int(10) unsigned NO PRI auto_increment dhcp_identifier varbinary(128) NO MUL dhcp_identifier_type tinyint(4) NO dhcp4_subnet_id int(10) unsigned YES dhcp6_subnet_id int(10) unsigned YES ipv4_address int(10) unsigned YES hostname varchar(255) YES dhcp4_client_classes varchar(255) YES dhcp6_client_classes varchar(255) YES + ipv6_reservations reservation_id int(11) NO PRI auto_increment address varchar(39) NO prefix_len tinyint(3) unsigned NO 128 type tinyint(4) unsigned NO 0 dhcp6_iaid int(10) unsigned YES host_id int(10) unsigned NO MUL + dhcp4_options option_id int(10) unsigned NO PRI auto_increment code tinyint(3) unsigned NO value blob YES formatted_value text YES space varchar(128) YES persistent tinyint(1) NO 0 dhcp_client_class varchar(128) YES dhcp4_subnet_id int(11) YES host_id int(10) unsigned YES MUL + dhcp6_options option_id int(10) unsigned NO PRI auto_increment code int(10) unsigned NO value blob YES formatted_value text YES space varchar(128) YES persistent tinyint(1) NO 0 dhcp_client_class varchar(128) YES dhcp6_subnet_id int(11) YES host_id int(10) unsigned YES MUL + lease_state; state int(10) unsigned NO PRI name varchar(64) NO Thanks and Best Regards, Quang Trieu On Wed, Jan 6, 2016 at 3:11 AM, Shane Kerr <[email protected]> wrote: > Quang Trieu, > > At 2016-01-05 22:28:02 +0700 > "Quang. Trieu Minh" <[email protected]> wrote: > > > After I upgraded kea 0.9.0 to kea 1.0.0. I updated lease version and saw > > errors as bellows : > > > > root@VNGHCMAPP01:/opt/kea/sbin# ./kea-admin lease-upgrade mysql -u > sqluser > > -p *********** -n dhcp_management > > Lease DB version reported before upgrade: 3.0 > > > > Processing /opt/kea/share/kea/scripts/mysql/upgrade_1.0_to_2.0.sh > file... > > This script upgrades 1.0 to 2.0. Reported version is 3.0. Skipping > upgrade. > > Processing /opt/kea/share/kea/scripts/mysql/upgrade_2.0_to_3.0.sh > file... > > This script upgrades 2.0 to 3.0. Reported version is 3.0. Skipping > upgrade. > > Processing /opt/kea/share/kea/scripts/mysql/upgrade_3.0_to_4.0.sh > file... > > ERROR 1060 (42S21) at line 2: Duplicate column name 'state' > > Processing /opt/kea/share/kea/scripts/mysql/upgrade_4.0_to_4.1.sh > file... > > This script upgrades 4.0 to 4.1. Reported version is 3.0. Skipping > upgrade. > > Lease DB version reported after upgrade: 3.0 > > It looks like the script is complaining about this command: > > # Add state column to the lease4 table. > ALTER TABLE lease4 > ADD COLUMN state INT UNSIGNED DEFAULT 0; > > The error indicates that for some reason the lease4 table already has a > column named 'state'. > > I'm not sure how this could happen. > > Was there an earlier attempt to upgrade the schema that failed? > > You can see the current schema of your database by using the MySQL > command line: > > mysql> show tables > > That will list all the tables, then you can go through each and check > the structure: > > mysql> show columns from lease4; > mysql> show columns from lease6; > mysql> show columns from lease6_type; > mysql> show columns from lease_hwaddr_source; > mysql> show columns from hosts; > mysql> show columns from ipv6_reservations; > mysql> show columns from dhcpv4_options; > mysql> show columns from dhcpv6_options; > mysql> show columns from lease_state; > > I don't know of any other way to see where things are broken. > > Cheers, > > -- > Shane >
_______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
