Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

AIRIOT智慧系统搭建平台经验交流

  1. Home
  2. 其他功能
  3. 如何进行数据库管理

如何进行数据库管理

Scheduled Pinned Locked Moved 其他功能
Posts Posters Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by
    #28

    看一下dump的接口

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #29

    微信截图_20250411195636.png

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by 核桃酥
    #30

    后台任务管理是什么状态,如果有外网可以发我一下地址我看看
    image.png

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #31

    微信截图_20250414133818.png

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by 核桃酥
    #32

    重新点击一次备份后,导出一下tsdb-backup 得日志 linux服务器日志导出:在安装目录app下面执行指令:docker logs 驱动/服务名字 > 驱动/服务名字.log (例如:docker logs live > live.log)
    windows服务器日志导出:在安装目录例如D:\AIRIOT-4.0\operation\log\windows-logger\live 目录下文件拷贝出 (live为服务名)

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #33

    2025/04/14 13:59:37 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.87/gormdb/gorm.go:180 ERROR: relation "67513c53cd86643f98b04454.tsdb_backup_cyclic" does not exist (SQLSTATE 42P01)
    [0.295ms] [rows:0] SELECT * FROM "67513c53cd86643f98b04454"."tsdb_backup_cyclic" WHERE "disable" = false
    {"time":"2025-04-14T13:59:37.776433064+08:00","level":"INFO","msg":"周期任务管理: 未查询到周期任务, 清空该项目的所有周期任务","logType":"syslog","service":"tsdb-backup","module":"周期任务管理","projectId":"67513c53cd86643f98b04454"}
    {"time":"2025-04-14T14:00:21.919195479+08:00","level":"INFO","msg":"start check the registered service list."}

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by
    #34

    需要按我说的导出来文件,可以通过奶牛快传发我文件。这个日志太少了看不出来

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #35

    https://cowtransfer.com/s/c060d9d700dc4a 点击链接查看 [ tsdb-backup.log ] ,或访问奶牛快传 cowtransfer.com 输入传输口令 rr6sfv 查看;

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by
    #36

    是linux部署的吗?需要改一下配置文件,可以发个远程我帮你改一下

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #37

    不好意思刚看到,明天下午三点可以吗?是Linux系统。
    竹尹邀请您进行远程控制
    ToDesk设备代码:254 473 560
    临时密码:528epdz5
    点击链接直接进行远程控制:
    https://wechat.todesk.com/invite-page?id=YlWKgSVhjLsAqNXvfhmJa

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by 核桃酥
    #38

    好的@ylyandy

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by
    #39

    现在你设备不在线@ylyandy

    1 Reply Last reply
    0
  • Y Offline
    Y Offline
    ylyandy
    wrote on last edited by
    #40

    不好意思,临时有事,忘了跟您说,现在可以了

    1 Reply Last reply
    0
  • 核 Offline
    核 Offline
    核桃酥
    wrote on last edited by
    #41

    改好了可以备份了
    image.png

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups