V2.10.2离线安装备份后恢复到另一个新安装的机器上失败

user-fxq3005 · 2024 年12 月 4 日 08:48

问问题请带上 DataEase 版本信息、安装部署方式信息、详细错误信息，减少不必要的来回沟通！
不要重复发帖！
dataease2.10.2，离线安装。成功启动。然后恢复备份失败。然后软件不能启动了

root@fxq-virtual-machine:/home/fxq/dtes# dectl restore dataease-backup-20241204_160032.tar.gz
恢复备份 dataease-backup-20241204_160032.tar.gz
Job for dataease.service failed because the control process exited with error code.
See “systemctl status dataease.service” and “journalctl -xeu dataease.service” for details.
root@fxq-virtual-machine:/home/fxq/dtes# systemctl status dataease.service
× dataease.service - DataEase Service
Loaded: loaded (/etc/systemd/system/dataease.service; enabled; vendor pres>
Active: failed (Result: exit-code) since Wed 2024-12-04 16:33:26 CST; 1min>
Process: 8822 ExecStart=/usr/bin/dectl start (code=exited, status=1/FAILURE)
Main PID: 8822 (code=exited, status=1/FAILURE)
CPU: 114ms

12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container dataease Created
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Starting
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Started
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Waiting
12月 04 16:33:25 fxq-virtual-machine dectl[8838]: Container mysql-de Error
12月 04 16:33:25 fxq-virtual-machine dectl[8838]: dependency failed to start: c>
12月 04 16:33:26 fxq-virtual-machine dectl[8822]: 未找到容器 dataease。
12月 04 16:33:26 fxq-virtual-machine systemd[1]: dataease.service: Main process>
12月 04 16:33:26 fxq-virtual-machine systemd[1]: dataease.service: Failed with >
12月 04 16:33:26 fxq-virtual-machine systemd[1]: Failed to start DataEase Servi>
lines 1-17/17 (END)…skipping…
× dataease.service - DataEase Service
Loaded: loaded (/etc/systemd/system/dataease.service; enabled; vendor pres>
Active: failed (Result: exit-code) since Wed 2024-12-04 16:33:26 CST; 1min>
Process: 8822 ExecStart=/usr/bin/dectl start (code=exited, status=1/FAILURE)
Main PID: 8822 (code=exited, status=1/FAILURE)
CPU: 114ms

12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container dataease Created
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Starting
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Started
12月 04 16:33:23 fxq-virtual-machine dectl[8838]: Container mysql-de Waiting
12月 04 16:33:25 fxq-virtual-machine dectl[8838]: Container mysql-de Error
12月 04 16:33:25 fxq-virtual-machine dectl[8838]: dependency failed to start: c>
12月 04 16:33:26 fxq-virtual-machine dectl[8822]: 未找到容器 dataease。
12月 04 16:33:26 fxq-virtual-machine systemd[1]: dataease.service: Main process>
12月 04 16:33:26 fxq-virtual-machine systemd[1]: dataease.service: Failed with >
12月 04 16:33:26 fxq-virtual-machine systemd[1]: Failed to start DataEase Servi>
~
~
~
~
~
~
lines 1-17/17 (END)
^C
root@fxq-virtual-machine:/home/fxq/dtes# dectl status

DataEase 容器运行状态
WARN[0000] /opt/dataease2.0/docker-compose.yml: the attribute version is obsolete, it will be ignored, please remove it to avoid potential confusion
WARN[0000] /opt/dataease2.0/docker-compose-mysql.yml: the attribute version is obsolete, it will be ignored, please remove it to avoid potential confusion
NAME IMAGE COMMAND SERVICE CREATED STATUS PORTS

Docker 目录及文件大小 :
1.2G /var/lib/docker

Docker 目录所在磁盘使用情况 :
文件系统大小已用可用已用% 挂载点
/dev/sda3 84G 17G 63G 22% /

日志文件大小 :
112K /opt/dataease2.0/logs/dataease
4.0K /opt/dataease2.0/logs/

DataEase 运行目录及文件大小 :
214M /opt

DataEase 运行目录使用情况 :
文件系统大小已用可用已用% 挂载点
/dev/sda3 84G 17G 63G 22% /

未找到容器 dataease。

user-fxq3005 · 2024 年12 月 4 日 08:51

root@fxq-virtual-machine:/home/fxq/dtes# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
9de9df2d34ca registry.cn-qingdao.aliyuncs.com/dataease/dataease:v2.10.2 “/deployments/run-ja…” 17 minutes ago Created dataease
773f64a83b1c registry.cn-qingdao.aliyuncs.com/dataease/mysql:8.4.0 “docker-entrypoint.s…” 17 minutes ago Exited (1) 17 minutes ago mysql-de

lboo · 2024 年12 月 4 日 08:55

已知问题，正在修复中。
restore 之前，先执行 dectl stop，删除安装目录的 data/mysql/ 目录，然后再执行 dectl restore 试试

user-fxq3005 · 2024 年12 月 4 日 09:08

成功恢复了，看板无损，非常感谢

user-fxq3005 · 2024 年12 月 4 日 09:08

root@fxq-virtual-machine:/home/fxq/dtes# docker logs -f mysql-de --tail=300
2024-12-04 08:33:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el8 started.
2024-12-04 08:33:23+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2024-12-04 08:33:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el8 started.
‘/var/lib/mysql/mysql.sock’ → ‘/var/run/mysqld/mysqld.sock’
2024-12-04T08:33:24.063308Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-12-04T08:33:24.329670Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
2024-12-04T08:33:24.331455Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-12-04T08:33:24.336529Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-04T08:33:24.528143Z 1 [ERROR] [MY-013879] [InnoDB] The redo log file ./#innodb_redo/#ib_redo21 comes from other data directory than redo log file ./#innodb_redo/#ib_redo12.
2024-12-04T08:33:24.528191Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-12-04T08:33:24.900268Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-12-04T08:33:24.900839Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-12-04T08:33:24.900883Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-04T08:33:24.902613Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
2024-12-04T08:33:24.902635Z 0 [System] [MY-015016] [Server] MySQL Server - end.

user-fxq3005 · 2024 年12 月 6 日 03:47

新问题：地图无法下钻，自带国家地图和自定义都不可以

qianzhao · 2024 年12 月 6 日 05:36

没有复现这个问题，检查你的配置看看

user-fxq3005 · 2024 年12 月 6 日 06:36

【先执行 dectl stop，删除安装目录的 data/mysql/ 目录，然后再执行 dectl restore 试试】，这里是不是把什么设置删了，新建模板的地图也无反应，点击地图无反应

lboo · 2024 年12 月 6 日 07:15

不会，删除的是数据库，restore 后数据库会恢复为旧版本数据，不会影响地图。确认是否是使用 Chrome 最新版本测试的？试试清空缓存或打开无痕模式好不好用？

user-fxq3005 · 2024 年12 月 6 日 08:59

试了都不行，点击地图无反应，新建了图形和数据集都不可

user-fxq3005 · 2024 年12 月 6 日 09:27

12062

user-fxq3005 · 2024 年12 月 6 日 09:30

2024-12-06 17:06:00.005 INFO — [yncJob_Worker-4] i.dataease.job.schedule.CheckDsStatusJob : Method[execute][Begin to check ds status…]
2024-12-06 17:12:00.006 INFO — [yncJob_Worker-7] i.dataease.job.schedule.CheckDsStatusJob : Method[execute][Begin to check ds status…]
2024-12-06 17:14:12.056 INFO — [ [default]-31] io.dataease.listener.MyCacheListener : ‘CREATED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → 1
2024-12-06 17:15:54.531 INFO — [ [default]-32] io.dataease.listener.MyCacheListener : ‘UPDATED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → 1
2024-12-06 17:16:04.530 INFO — [ [default]-32] io.dataease.listener.MyCacheListener : ‘REMOVED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → null
2024-12-06 17:18:00.006 INFO — [ncJob_Worker-10] i.dataease.job.schedule.CheckDsStatusJob : Method[execute][Begin to check ds status…]
2024-12-06 17:19:10.685 INFO — [ [default]-33] io.dataease.listener.MyCacheListener : ‘CREATED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → 1
2024-12-06 17:19:13.069 INFO — [MessageBroker-7] o.s.w.s.c.WebSocketMessageBrokerStats : WebSocketSession[2 current WS(2)-HttpStream(0)-HttpPoll(0), 25 total, 0 closed abnormally (0 connect failure, 0 send limit, 0 transport error)], stompSubProtocol[processed CONNECT(25)-CONNECTED(25)-DISCONNECT(0)], stompBrokerRelay[null], inboundChannel[unknown], outboundChannel[unknown], sockJsScheduler[pool size = 8, active threads = 1, queued tasks = 3, completed tasks = 5631]
2024-12-06 17:19:20.684 INFO — [ [default]-33] io.dataease.listener.MyCacheListener : ‘REMOVED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → null
2024-12-06 17:24:00.010 INFO — [yncJob_Worker-3] i.dataease.job.schedule.CheckDsStatusJob : Method[execute][Begin to check ds status…]
2024-12-06 17:24:31.087 INFO — [ [default]-34] io.dataease.listener.MyCacheListener : ‘CREATED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → 1
2024-12-06 17:24:41.086 INFO — [ [default]-34] io.dataease.listener.MyCacheListener : ‘REMOVED’ : [1eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1aWQiOjEsIm9pZCI6MX0.UK4jQ8CzyC8nylz_eAFZMa8agK9vCF2zt9GQENwXbV0] → null