You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2021/10/11 10:48:59 UTC
[GitHub] [cloudstack] rhtyd opened a new issue #5564: Upgrade to 4.16.0.0-snapshot fails with MySQL 5.7 on Ubuntu 18.04
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] nvazquez closed issue #5564: Upgrade to 4.16.0.0-snapshot fails with MySQL 5.7 on Ubuntu 18.04
Posted by GitBox <gi...@apache.org>.
nvazquez closed issue #5564:
URL: https://github.com/apache/cloudstack/issues/5564
--
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: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org