<div dir="ltr"><div class="gmail_default" style="font-size:small;color:rgb(0,0,0)">Hi everyone !</div><div class="gmail_default" style="font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style="font-size:small;color:rgb(0,0,0)">After I upgraded kea 0.9.0 to kea 1.0.0. I updated lease version and saw errors as bellows :</div><div class="gmail_default" style="font-size:small;color:rgb(0,0,0)"><br></div><div class="gmail_default" style=""><div class="gmail_default" style=""><font color="#000000">root@VNGHCMAPP01:/opt/kea/sbin# ./kea-admin lease-upgrade mysql -u sqluser -p *********** -n dhcp_management</font></div><div class="gmail_default" style=""><font color="#000000">Lease DB version reported before upgrade: 3.0</font></div><div class="gmail_default" style=""><font color="#000000"><br></font></div><div class="gmail_default" style=""><font color="#000000">Processing /opt/kea/share/kea/scripts/mysql/<a href="http://upgrade_1.0_to_2.0.sh">upgrade_1.0_to_2.0.sh</a> file...</font></div><div class="gmail_default" style=""><font color="#000000">This script upgrades 1.0 to 2.0. Reported version is 3.0. Skipping upgrade.</font></div><div class="gmail_default" style=""><font color="#000000">Processing /opt/kea/share/kea/scripts/mysql/<a href="http://upgrade_2.0_to_3.0.sh">upgrade_2.0_to_3.0.sh</a> file...</font></div><div class="gmail_default" style=""><font color="#000000">This script upgrades 2.0 to 3.0. Reported version is 3.0. Skipping upgrade.</font></div><div class="gmail_default" style=""><font color="#000000">Processing /opt/kea/share/kea/scripts/mysql/<a href="http://upgrade_3.0_to_4.0.sh">upgrade_3.0_to_4.0.sh</a> file...</font></div><div class="gmail_default" style=""><font color="#000000">ERROR 1060 (42S21) at line 2: Duplicate column name 'state'</font></div><div class="gmail_default" style=""><font color="#000000">Processing /opt/kea/share/kea/scripts/mysql/<a href="http://upgrade_4.0_to_4.1.sh">upgrade_4.0_to_4.1.sh</a> file...</font></div><div class="gmail_default" style=""><font color="#000000">This script upgrades 4.0 to 4.1. Reported version is 3.0. Skipping upgrade.</font></div><div class="gmail_default" style=""><font color="#000000">Lease DB version reported after upgrade: 3.0</font></div><div class="gmail_default" style=""><font color="#000000"><br></font></div><div class="gmail_default" style=""><font color="#000000">Please help me.</font></div><div style="color:rgb(0,0,0);font-size:small"><br></div></div><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div>Thanks and Best Regards,<br></div><div>Quang Trieu<br></div></div></div></div></div></div></div>
</div>