xuanyuanaosheng commented on issue #7358:
URL: https://github.com/apache/cloudstack/issues/7358#issuecomment-1612633415
@weizhouapache @DaanHoogland @cc20110101 @mail2lawi @kiwiflyer
I did the test as your guide, But cloudstack new error is
```
2023-06-29 16:29:48,085 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.volumes', 'passphrase_id', 'bigint
unsigned DEFAULT NULL COMMENT "encryption passphrase id" ')
2023-06-29 16:29:48,088 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.volumes', 'passphrase', 'id')
2023-06-29 16:29:48,249 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.volumes',
'passphrase', 'id')
2023-06-29 16:29:48,250 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect
datetime value: '0014-10-00 00:00:00' for column 'created' at row 1
2023-06-29 16:29:48,253 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect
datetime value: '0014-10-00 00:00:00' for column 'created' at row 1
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
```
how to fix this issue?
--
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]
