rhtyd opened a new issue #5564: URL: https://github.com/apache/cloudstack/issues/5564
I was trying to upgrade qa.cloudstack.cloud from 4.15.2.0 to 4.16.0.0-snapshot and hit this: ``` 2021-10-11 10:33:14,196 DEBUG [c.c.u.d.Upgrade41520to41600] (main:null) (logid:) Generating uuid for existing ssh key-pairs 2021-10-11 10:33:14,198 DEBUG [c.c.u.d.Upgrade41520to41600] (main:null) (logid:) Successfully generated uuid for existing ssh key-pairs 2021-10-11 10:33:14,229 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Cleanup upgrade Upgrade41520to41600 to upgrade from 4.15.2.0-4.16.0.0 to 4.16.0.0 2021-10-11 10:33:14,233 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one 2021-10-11 10:33:14,233 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing, 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License. 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade cleanup from 4.15.2.0 to 4.16.0.0 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2021-10-11 10:33:14,234 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`ssh_keypairs` MODIFY COLUMN `uuid` varchar(40) NOT NULL UNIQUE 2021-10-11 10:33:14,304 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER TABLE `cloud`.`ssh_keypairs` MODIFY COLUMN `uuid` varchar(40) NOT NULL UNIQUE 2021-10-11 10:33:14,305 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Invalid use of NULL value 2021-10-11 10:33:14,308 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Invalid use of NULL value at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185) at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87) ``` ALTER TABLE `cloud`.`ssh_keypairs` MODIFY COLUMN `uuid` varchar(40) NOT NULL UNIQUE; ##### ISSUE TYPE <!-- Pick one below and delete the rest --> * Bug Report * ##### COMPONENT NAME <!-- Categorize the issue, e.g. API, VR, VPN, UI, etc. --> ~~~ DB, MySQL ~~~ ##### CLOUDSTACK VERSION <!-- New line separated list of affected versions, commit ID for issues on main branch. --> ~~~ 4.16/main ~~~ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
