| // Licensed to the Apache Software Foundation (ASF) under one | |
| // or more contributor license agreements. See the NOTICE file | |
| // distributed with this work for additional information | |
| // regarding copyright ownership. The ASF licenses this file | |
| // to you under the Apache License, Version 2.0 (the | |
| // "License"); you may not use this file except in compliance | |
| // with the License. You may obtain a copy of the License at | |
| // | |
| // http://www.apache.org/licenses/LICENSE-2.0 | |
| // | |
| // Unless required by applicable law or agreed to in writing, | |
| // software distributed under the License is distributed on an | |
| // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| // KIND, either express or implied. See the License for the | |
| // specific language governing permissions and limitations | |
| // under the License. | |
| package com.cloud.upgrade.dao; | |
| import java.io.File; | |
| import java.sql.Connection; | |
| import java.sql.PreparedStatement; | |
| import java.sql.ResultSet; | |
| import java.sql.SQLException; | |
| import java.util.UUID; | |
| import org.apache.log4j.Logger; | |
| import com.cloud.utils.exception.CloudRuntimeException; | |
| import com.cloud.utils.script.Script; | |
| public class Upgrade410to420 implements DbUpgrade { | |
| final static Logger s_logger = Logger.getLogger(Upgrade410to420.class); | |
| @Override | |
| public String[] getUpgradableVersionRange() { | |
| return new String[] { "4.1.0", "4.2.0" }; | |
| } | |
| @Override | |
| public String getUpgradedVersion() { | |
| return "4.2.0"; | |
| } | |
| @Override | |
| public boolean supportsRollingUpgrade() { | |
| return false; | |
| } | |
| @Override | |
| public File[] getPrepareScripts() { | |
| String script = Script.findScript("", "db/schema-410to420.sql"); | |
| if (script == null) { | |
| throw new CloudRuntimeException("Unable to find db/schema-410to420.sql"); | |
| } | |
| return new File[] { new File(script) }; | |
| } | |
| @Override | |
| public void performDataMigration(Connection conn) { | |
| upgradeVmwareLabels(conn); | |
| createPlaceHolderNics(conn); | |
| updateRemoteAccessVpn(conn); | |
| updateSystemVmTemplates(conn); | |
| updateCluster_details(conn); | |
| updatePrimaryStore(conn); | |
| } | |
| private void updateSystemVmTemplates(Connection conn) { | |
| PreparedStatement sql = null; | |
| try { | |
| sql = conn.prepareStatement("update vm_template set image_data_store_id = 1 where type = 'SYSTEM' or type = 'BUILTIN'"); | |
| sql.executeUpdate(); | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Failed to upgrade vm template data store uuid: " + e.toString()); | |
| } finally { | |
| if (sql != null) { | |
| try { | |
| sql.close(); | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| } | |
| private void updatePrimaryStore(Connection conn) { | |
| PreparedStatement sql = null; | |
| PreparedStatement sql2 = null; | |
| try { | |
| sql = conn.prepareStatement("update storage_pool set storage_provider_name = ? , scope = ? where pool_type = 'Filesystem' or pool_type = 'LVM'"); | |
| sql.setString(1, "ancient primary data store provider"); | |
| sql.setString(2, "HOST"); | |
| sql.executeUpdate(); | |
| sql2 = conn.prepareStatement("update storage_pool set storage_provider_name = ? , scope = ? where pool_type != 'Filesystem' and pool_type != 'LVM'"); | |
| sql2.setString(1, "ancient primary data store provider"); | |
| sql2.setString(2, "CLUSTER"); | |
| sql2.executeUpdate(); | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Failed to upgrade vm template data store uuid: " + e.toString()); | |
| } finally { | |
| if (sql != null) { | |
| try { | |
| sql.close(); | |
| } catch (SQLException e) { | |
| } | |
| } | |
| if (sql2 != null) { | |
| try { | |
| sql2.close(); | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| } | |
| //update the cluster_details table with default overcommit ratios. | |
| private void updateCluster_details(Connection conn) { | |
| PreparedStatement pstmt = null; | |
| PreparedStatement pstmt1 = null; | |
| PreparedStatement pstmt2 =null; | |
| ResultSet rs = null; | |
| try { | |
| pstmt = conn.prepareStatement("select id from `cloud`.`cluster`"); | |
| pstmt1=conn.prepareStatement("INSERT INTO `cloud`.`cluster_details` (cluster_id, name, value) VALUES(?, 'cpuOvercommitRatio', '1')"); | |
| pstmt2=conn.prepareStatement("INSERT INTO `cloud`.`cluster_details` (cluster_id, name, value) VALUES(?, 'memoryOvercommitRatio', '1')"); | |
| rs = pstmt.executeQuery(); | |
| while (rs.next()) { | |
| long id = rs.getLong(1); | |
| //update cluster_details table with the default overcommit ratios. | |
| pstmt1.setLong(1,id); | |
| pstmt1.execute(); | |
| pstmt2.setLong(1,id); | |
| pstmt2.execute(); | |
| } | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Unable to update cluster_details with default overcommit ratios.", e); | |
| } finally { | |
| try { | |
| if (rs != null) { | |
| rs.close(); | |
| } | |
| if (pstmt != null) { | |
| pstmt.close(); | |
| } | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| @Override | |
| public File[] getCleanupScripts() { | |
| String script = Script.findScript("", "db/schema-410to420-cleanup.sql"); | |
| if (script == null) { | |
| throw new CloudRuntimeException("Unable to find db/schema-410to420-cleanup.sql"); | |
| } | |
| return new File[] { new File(script) }; | |
| } | |
| private String getNewLabel(ResultSet rs, String oldParamValue) { | |
| int separatorIndex; | |
| String oldGuestLabel; | |
| String newGuestLabel = oldParamValue; | |
| try { | |
| // No need to iterate because the global param setting applies to all physical networks irrespective of traffic type | |
| if (rs.next()) { | |
| oldGuestLabel = rs.getString("vmware_network_label"); | |
| // guestLabel is in format [[<VSWITCHNAME>],VLANID] | |
| separatorIndex = oldGuestLabel.indexOf(","); | |
| if(separatorIndex > -1) { | |
| newGuestLabel += oldGuestLabel.substring(separatorIndex); | |
| } | |
| } | |
| } catch (SQLException e) { | |
| s_logger.error(new CloudRuntimeException("Failed to read vmware_network_label : " + e)); | |
| } finally { | |
| try { | |
| if (rs != null) { | |
| rs.close(); | |
| } | |
| } catch (SQLException e) { | |
| } | |
| } | |
| return newGuestLabel; | |
| } | |
| private void upgradeVmwareLabels(Connection conn) { | |
| PreparedStatement pstmt = null; | |
| ResultSet rsParams = null; | |
| ResultSet rsLabel = null; | |
| String newLabel; | |
| String trafficType = null; | |
| String trafficTypeVswitchParam; | |
| String trafficTypeVswitchParamValue; | |
| try { | |
| // update the existing vmware traffic labels | |
| pstmt = conn.prepareStatement("select name,value from `cloud`.`configuration` where category='Hidden' and value is not NULL and name REGEXP 'vmware\\.*\\.vswitch';"); | |
| rsParams = pstmt.executeQuery(); | |
| while (rsParams.next()) { | |
| trafficTypeVswitchParam = rsParams.getString("name"); | |
| trafficTypeVswitchParamValue = rsParams.getString("value"); | |
| // When upgraded from 4.0 to 4.1 update physical network traffic label with trafficTypeVswitchParam | |
| if (trafficTypeVswitchParam.equals("vmware.private.vswitch")) { | |
| trafficType = "Management"; //TODO(sateesh): Ignore storage traffic, as required physical network already implemented, anything else tobe done? | |
| } else if (trafficTypeVswitchParam.equals("vmware.public.vswitch")) { | |
| trafficType = "Public"; | |
| } else if (trafficTypeVswitchParam.equals("vmware.guest.vswitch")) { | |
| trafficType = "Guest"; | |
| } | |
| s_logger.debug("Updating vmware label for " + trafficType + " traffic. Update SQL statement is " + pstmt); | |
| pstmt = conn.prepareStatement("select physical_network_id, traffic_type, vmware_network_label from physical_network_traffic_types where vmware_network_label is not NULL and traffic_type='" + trafficType + "';"); | |
| rsLabel = pstmt.executeQuery(); | |
| newLabel = getNewLabel(rsLabel, trafficTypeVswitchParamValue); | |
| pstmt = conn.prepareStatement("update physical_network_traffic_types set vmware_network_label = " + newLabel + " where traffic_type = '" + trafficType + "' and vmware_network_label is not NULL;"); | |
| pstmt.executeUpdate(); | |
| } | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Unable to set vmware traffic labels ", e); | |
| } finally { | |
| try { | |
| if (rsParams != null) { | |
| rsParams.close(); | |
| } | |
| if (pstmt != null) { | |
| pstmt.close(); | |
| } | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| private void createPlaceHolderNics(Connection conn) { | |
| PreparedStatement pstmt = null; | |
| ResultSet rs = null; | |
| try { | |
| pstmt = conn.prepareStatement("SELECT network_id, gateway, ip4_address FROM `cloud`.`nics` WHERE reserver_name IN ('DirectNetworkGuru','DirectPodBasedNetworkGuru') and vm_type='DomainRouter' AND removed IS null"); | |
| rs = pstmt.executeQuery(); | |
| while (rs.next()) { | |
| Long networkId = rs.getLong(1); | |
| String gateway = rs.getString(2); | |
| String ip = rs.getString(3); | |
| String uuid = UUID.randomUUID().toString(); | |
| //Insert placeholder nic for each Domain router nic in Shared network | |
| pstmt = conn.prepareStatement("INSERT INTO `cloud`.`nics` (uuid, ip4_address, gateway, network_id, state, strategy, vm_type) VALUES (?, ?, ?, ?, 'Reserved', 'PlaceHolder', 'DomainRouter')"); | |
| pstmt.setString(1, uuid); | |
| pstmt.setString(2, ip); | |
| pstmt.setString(3, gateway); | |
| pstmt.setLong(4, networkId); | |
| pstmt.executeUpdate(); | |
| s_logger.debug("Created placeholder nic for the ipAddress " + ip); | |
| } | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Unable to create placeholder nics", e); | |
| } finally { | |
| try { | |
| if (rs != null) { | |
| rs.close(); | |
| } | |
| if (pstmt != null) { | |
| pstmt.close(); | |
| } | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| private void updateRemoteAccessVpn(Connection conn) { | |
| PreparedStatement pstmt = null; | |
| ResultSet rs = null; | |
| try { | |
| pstmt = conn.prepareStatement("SELECT vpn_server_addr_id FROM `cloud`.`remote_access_vpn`"); | |
| rs = pstmt.executeQuery(); | |
| long id=1; | |
| while (rs.next()) { | |
| String uuid = UUID.randomUUID().toString(); | |
| Long ipId = rs.getLong(1); | |
| pstmt = conn.prepareStatement("UPDATE `cloud`.`remote_access_vpn` set uuid=?, id=? where vpn_server_addr_id=?"); | |
| pstmt.setString(1, uuid); | |
| pstmt.setLong(2, id); | |
| pstmt.setLong(3, ipId); | |
| pstmt.executeUpdate(); | |
| id++; | |
| } | |
| } catch (SQLException e) { | |
| throw new CloudRuntimeException("Unable to update id/uuid of remote_access_vpn table", e); | |
| } finally { | |
| try { | |
| if (rs != null) { | |
| rs.close(); | |
| } | |
| if (pstmt != null) { | |
| pstmt.close(); | |
| } | |
| } catch (SQLException e) { | |
| } | |
| } | |
| } | |
| } |