This is an automated email from the ASF dual-hosted git repository.
casion pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-linkis-website.git
The following commit(s) were added to refs/heads/dev by this push:
new 857495eb0c fix: add 1.1.1 DDL error prompt (#456)
857495eb0c is described below
commit 857495eb0c0717a62af1c347cb102568866ac67d
Author: ruY <[email protected]>
AuthorDate: Fri Jul 22 10:02:28 2022 +0800
fix: add 1.1.1 DDL error prompt (#456)
fix: add 1.1.1 DDL error prompt
---
docs/upgrade/upgrade_guide.md | 11 ++++++++---
.../current/upgrade/upgrade_guide.md | 11 ++++++++---
.../version-1.1.1/upgrade/upgrade_guide.md | 9 +++++++--
.../version-1.1.2/upgrade/upgrade_guide.md | 11 ++++++++---
versioned_docs/version-1.1.1/upgrade/upgrade_guide.md | 11 ++++++++---
versioned_docs/version-1.1.2/upgrade/upgrade_guide.md | 11 ++++++++---
6 files changed, 47 insertions(+), 17 deletions(-)
diff --git a/docs/upgrade/upgrade_guide.md b/docs/upgrade/upgrade_guide.md
index 5a26609071..eaa72e78a3 100644
--- a/docs/upgrade/upgrade_guide.md
+++ b/docs/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 Service upgrade installation
Press [Deployment guide document](../deployment/quick_deploy) (the
installation of the management console in the document can be skipped) to
install the new version.
-
+
When installing the service, if the historical data is retained, please retain
the historical data, if you do not need to retain the data, just reinstall it
directly
```shell script
Do you want to clear Linkis table information in the database?
@@ -32,12 +32,17 @@ Please input the choice: ## choice 1
## 3. Database table upgrade
>After the service installation is completed, the database structure needs to
>be modified, including table structure changes and table data changes
-
+
Find the corresponding version `db/upgrade/x.x.x-schema/` sql change file
-
+
If it is executed across multiple versions, please execute them in the order
of versions,
If some versions do not have x.x.x_schema (after the linkis>=1.1.0 version, as
long as the adjustment of the database table is involved, there will be a
corresponding version of the schema file), it means that there is no change in
the data table in this version
+
+:::caution notice
+Execute upgrade_1.1.1 under DDL upgrade script in schema, such as if it is
executed to linkis_ cg_ rm_ resource_ action_ Record related error, please
check whether the statement creating the table is missing engine=innodb default
charset=utf8; If it is missing, please add it before execution
+:::
+
```shell script
├── linkis_ddl.sql # The current version of the full ddl database definition
language table building statement
├── linkis_dml.sql # The current version of the full dml data manipulation
language data additions and changes
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/upgrade/upgrade_guide.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/upgrade/upgrade_guide.md
index a39412dfe3..978d8a581a 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/upgrade/upgrade_guide.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 服务升级安装
按[部署指引文档](../deployment/quick_deploy)（文档中关于管理台的安装可以跳过），进行新版本的安装。
-
+
安装服务时，如果历史数据保留，请保留历史数据，如果无需保留数据，直接重装即可，也无需关注升级流程
```shell script
Do you want to clear Linkis table information in the database?
@@ -32,12 +32,17 @@ Please input the choice: ## choice 1
## 3. 数据库表升级
>服务安装完成后，需要对数据库进行结构修改，包括进行表结构变更和表数据变更
-
+
找到对应的版本`db/upgrade/x.x.x-schema/` sql变动文件
-
+
如果是跨多个版本执行，请按版本顺序，依次执行，
如果某些版本没有x.x.x_schema(linkis>=1.1.0版本后，只要涉及到数据库表的调整，都会有对应版本的schema文件),则表示该版本没有数据表的变化
+
+:::caution 注意
+执行upgrade下的1.1.1_schema中的ddl升级脚本,如若执行到linkis_cg_rm_resource_action_record相关的错误,请检查创建该表的语句是否缺少ENGINE=InnoDB
DEFAULT CHARSET=utf8; 如果缺少,请加上再执行
+:::
+
```shell script
├── linkis_ddl.sql # 当前版本的全量ddl 数据库定义语言 建表语句
├── linkis_dml.sql # 当前版本的全量dml 数据操纵语言 数据的增改
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.1/upgrade/upgrade_guide.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.1/upgrade/upgrade_guide.md
index 58b7d9dcc4..ffa8a437b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.1/upgrade/upgrade_guide.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.1/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 服务升级安装
按[部署指引文档](../deployment/quick_deploy)（文档中关于管理台的安装可以跳过），进行新版本的安装。
-
+
安装服务时，如果历史数据保留，请保留历史数据，如果无需保留数据，直接重装即可，也无需关注升级流程
```shell script
Do you want to clear Linkis table information in the database?
@@ -35,9 +35,14 @@ Please input the choice: ## choice 1
3
找到对应的版本`db/upgrade/x.x.x-schema/` sql变动文件
-
+
如果是跨多个版本执行，请按版本顺序，依次执行，
如果某些版本没有x.x.x_schema(linkis>=1.1.0版本后，只要涉及到数据库表的调整，都会有对应版本的schema文件),则表示该版本没有数据表的变化
+
+:::caution 注意
+执行upgrade下的1.1.1_schema中的ddl升级脚本,如若执行到linkis_cg_rm_resource_action_record相关的错误,请检查创建该表的语句是否缺少ENGINE=InnoDB
DEFAULT CHARSET=utf8; 如果缺少,请加上再执行
+:::
+
```shell script
├── linkis_ddl.sql # 当前版本的全量ddl 数据库定义语言 建表语句
├── linkis_dml.sql # 当前版本的全量dml 数据操纵语言 数据的增改
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.2/upgrade/upgrade_guide.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.2/upgrade/upgrade_guide.md
index a39412dfe3..978d8a581a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.2/upgrade/upgrade_guide.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.1.2/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 服务升级安装
按[部署指引文档](../deployment/quick_deploy)（文档中关于管理台的安装可以跳过），进行新版本的安装。
-
+
安装服务时，如果历史数据保留，请保留历史数据，如果无需保留数据，直接重装即可，也无需关注升级流程
```shell script
Do you want to clear Linkis table information in the database?
@@ -32,12 +32,17 @@ Please input the choice: ## choice 1
## 3. 数据库表升级
>服务安装完成后，需要对数据库进行结构修改，包括进行表结构变更和表数据变更
-
+
找到对应的版本`db/upgrade/x.x.x-schema/` sql变动文件
-
+
如果是跨多个版本执行，请按版本顺序，依次执行，
如果某些版本没有x.x.x_schema(linkis>=1.1.0版本后，只要涉及到数据库表的调整，都会有对应版本的schema文件),则表示该版本没有数据表的变化
+
+:::caution 注意
+执行upgrade下的1.1.1_schema中的ddl升级脚本,如若执行到linkis_cg_rm_resource_action_record相关的错误,请检查创建该表的语句是否缺少ENGINE=InnoDB
DEFAULT CHARSET=utf8; 如果缺少,请加上再执行
+:::
+
```shell script
├── linkis_ddl.sql # 当前版本的全量ddl 数据库定义语言 建表语句
├── linkis_dml.sql # 当前版本的全量dml 数据操纵语言 数据的增改
diff --git a/versioned_docs/version-1.1.1/upgrade/upgrade_guide.md
b/versioned_docs/version-1.1.1/upgrade/upgrade_guide.md
index 5a26609071..eaa72e78a3 100644
--- a/versioned_docs/version-1.1.1/upgrade/upgrade_guide.md
+++ b/versioned_docs/version-1.1.1/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 Service upgrade installation
Press [Deployment guide document](../deployment/quick_deploy) (the
installation of the management console in the document can be skipped) to
install the new version.
-
+
When installing the service, if the historical data is retained, please retain
the historical data, if you do not need to retain the data, just reinstall it
directly
```shell script
Do you want to clear Linkis table information in the database?
@@ -32,12 +32,17 @@ Please input the choice: ## choice 1
## 3. Database table upgrade
>After the service installation is completed, the database structure needs to
>be modified, including table structure changes and table data changes
-
+
Find the corresponding version `db/upgrade/x.x.x-schema/` sql change file
-
+
If it is executed across multiple versions, please execute them in the order
of versions,
If some versions do not have x.x.x_schema (after the linkis>=1.1.0 version, as
long as the adjustment of the database table is involved, there will be a
corresponding version of the schema file), it means that there is no change in
the data table in this version
+
+:::caution notice
+Execute upgrade_1.1.1 under DDL upgrade script in schema, such as if it is
executed to linkis_ cg_ rm_ resource_ action_ Record related error, please
check whether the statement creating the table is missing engine=innodb default
charset=utf8; If it is missing, please add it before execution
+:::
+
```shell script
├── linkis_ddl.sql # The current version of the full ddl database definition
language table building statement
├── linkis_dml.sql # The current version of the full dml data manipulation
language data additions and changes
diff --git a/versioned_docs/version-1.1.2/upgrade/upgrade_guide.md
b/versioned_docs/version-1.1.2/upgrade/upgrade_guide.md
index 5a26609071..eaa72e78a3 100644
--- a/versioned_docs/version-1.1.2/upgrade/upgrade_guide.md
+++ b/versioned_docs/version-1.1.2/upgrade/upgrade_guide.md
@@ -19,7 +19,7 @@ sidebar_position: 2
## 2 Service upgrade installation
Press [Deployment guide document](../deployment/quick_deploy) (the
installation of the management console in the document can be skipped) to
install the new version.
-
+
When installing the service, if the historical data is retained, please retain
the historical data, if you do not need to retain the data, just reinstall it
directly
```shell script
Do you want to clear Linkis table information in the database?
@@ -32,12 +32,17 @@ Please input the choice: ## choice 1
## 3. Database table upgrade
>After the service installation is completed, the database structure needs to
>be modified, including table structure changes and table data changes
-
+
Find the corresponding version `db/upgrade/x.x.x-schema/` sql change file
-
+
If it is executed across multiple versions, please execute them in the order
of versions,
If some versions do not have x.x.x_schema (after the linkis>=1.1.0 version, as
long as the adjustment of the database table is involved, there will be a
corresponding version of the schema file), it means that there is no change in
the data table in this version
+
+:::caution notice
+Execute upgrade_1.1.1 under DDL upgrade script in schema, such as if it is
executed to linkis_ cg_ rm_ resource_ action_ Record related error, please
check whether the statement creating the table is missing engine=innodb default
charset=utf8; If it is missing, please add it before execution
+:::
+
```shell script
├── linkis_ddl.sql # The current version of the full ddl database definition
language table building statement
├── linkis_dml.sql # The current version of the full dml data manipulation
language data additions and changes
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
