# Gladys Plus Catering

**URL:** <https://community.gladysassistant.com/t/restauration-gladys-plus/9082>\
**Category:** Configuration\
**Created:** [September 13, 2024, 8:06am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082 "2024-09-13T08:06:11Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\
**Post date:** [September 13, 2024, 8:06am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/1 "2024-09-13T08:06:11Z")

</div>

hello @pierre-g

---

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [September 13, 2024, 8:15am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/2 "2024-09-13T08:15:31Z")

</div>

> [@Einstein8854](#):
>
> this started last night around 11pm and is still running, is it normal for it to take so long?

it depends on your network but that seems huge to me!  
Have you checked the status of the container?

Edit: I moved this thread into a separate post

---

<div class="post-metadata">

**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\
**Post date:** [September 13, 2024, 8:54am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/3 "2024-09-13T08:54:33Z")

</div>

my network : outdoors : fiber optic  
en indoors : wifi from Livebox 6 from Orange

state of the containers : with a docker ps -a, my 3 containers (gladys, watchtower and nodered) have been active for 12 h including since 10 PM last night when I reinstalled.  
in the server tree under /var/lib/gladys the sqlite dbs seem to be there (15.3 GB of database) but not completely reinstalled  
db and duckdb files are dated 13/9 at 00:35 so they haven’t moved since.  
should I try doing a stop/start of gladys ?

---

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [September 13, 2024, 8:59am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/4 "2024-09-13T08:59:11Z")

</div>

And what do the logs of the gladys container say?

Did you launch Gladys with the command on the site ( [Installation avec Docker | Gladys Assistant](https://gladysassistant.com/fr/docs/installation/docker/) ) including the `--restart=always`? During the restore, Gladys automatically stops at the end and relies on Docker to restart the container

---

<div class="post-metadata">

**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\
**Post date:** [September 13, 2024, 9:31am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/5 "2024-09-13T09:31:02Z")

</div>

Excerpt from the Gladys log :

```auto
2024-09-13T11:23:31+0200 \u003cerror\u003e index.js:16 (process.\u003canonymous\u003e) Error: ConnectionManager.getConnection was called after the connection manager was closed!
    at ConnectionManager.getConnection (/src/server/node_modules/sequelize/src/dialects/abstract/connection-manager.js:113:13)
    at /src/server/node_modules/sequelize/src/sequelize.js:637:111
    at /src/server/node_modules/retry-as-promised/index.js:64:21
    at new Promise (\u003canonymous\u003e)
    at retryAsPromised (/src/server/node_modules/retry-as-promised/index.js:54:10)
    at Sequelize.query (/src/server/node_modules/sequelize/src/sequelize.js:630:12)
    at SQLiteQueryInterface.select (/src/server/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:33)
    at Function.findAll (/src/server/node_modules/sequelize/src/model.js:1816:47)
    at Function.findOne (/src/server/node_modules/sequelize/src/model.js:1982:12)
    at DeviceManager.get (/src/server/lib/device/device.get.js:97:21)
    at LANManager.scanPresence (/src/server/services/lan-manager/lib/lan-manager.scanPresence.js:11:19)
2024-09-13T11:24:00+0200 \u003cinfo\u003e scene.checkCalendarTriggers.js:25 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Fri, 13 Sep 2024 09:24:00 GMT
2024-09-13T11:25:00+0200 \u003cinfo\u003e scene.checkCalendarTriggers.js:25 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Fri, 13 Sep 2024 09:25:00 GMT
2024-09-13T11:25:31+0200 \u003cerror\u003e index.js:15 (process.\u003canonymous\u003e) unhandledRejection catched: Promise {
  \u003crejected\u003e Error: ConnectionManager.getConnection was called after the connection manager was closed!
      at ConnectionManager.getConnection (/src/server/node_modules/sequelize/src/dialects/abstract/connection-manager.js:113:13)
      at /src/server/node_modules/sequelize/src/sequelize.js:637:111
      at /src/server/node_modules/retry-as-promised/index.js:64:21
      at new Promise (\u003canonymous\u003e)
      at retryAsPromised (/src/server/node_modules/retry-as-promised/index.js:54:10)
      at Sequelize.query (/src/server/node_modules/sequelize/src/sequelize.js:630:12)
      at SQLiteQueryInterface.select (/src/server/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:33)
      at Function.findAll (/src/server/node_modules/sequelize/src/model.js:1816:47)
      at Function.findOne (/src/server/node_modules/sequelize/src/model.js:1982:12)
      at DeviceManager.get (/src/server/lib/device/device.get.js:97:21)
      at LANManager.scanPresence (/src/server/services/lan-manager/lib/lan-manager.scanPresence.js:11:19)
}
2024-09-13T11:25:31+0200 \u003cerror\u003e index.js:16 (process.\u003canonymous\u003e) Error: ConnectionManager.getConnection was called after the connection manager was closed!
    at ConnectionManager.getConnection (/src/server/node_modules/sequelize/src/dialects/abstract/connection-manager.js:113:13)
    at /src/server/node_modules/sequelize/src/sequelize.js:637:111
    at /src/server/node_modules/retry-as-promised/index.js:64:21
    at new Promise (\u003canonymous\u003e)
    at retryAsPromised (/src/server/node_modules/retry-as-promised/index.js:54:10)
    at Sequelize.query (/src/server/node_modules/sequelize/src/sequelize.js:630:12)
    at SQLiteQueryInterface.select (/src/server/node_modules/sequelize/src/dialects/abstract/query-interface.js:1001:33)
    at Function.findAll (/src/server/node_modules/sequelize/src/model.js:1816:47)
    at Function.findOne (/src/server/node_modules/sequelize/src/model.js:1982:12)
    at DeviceManager.get (/src/server/lib/device/device.get.js:97:21)
    at LANManager.scanPresence (/src/server/services/lan-manager/lib/lan-manager.scanPresence.js:11:19)
2024-09-13T11:26:00+0200 \u003cinfo\u003e scene.checkCalendarTriggers.js:25 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Fri, 13 Sep 2024 09:26:00 GMT
2024-09-13T11:27:00+0200 \u003cinfo\u003e scene.checkCalendarTriggers.js:25 (SceneManager.checkCalendarTriggers) Checking calendar triggers at Fri, 13 Sep 2024 09:27:00 GMT

```

Yes, the installation was performed by strictly following the commands you had posted on the site.  
Including the Node-RED installation commands from your presentation on YouTube.

---

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [September 13, 2024, 9:38am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/6 "2024-09-13T09:38:40Z")

</div>

Ok! Try restarting Gladys, I think the restore worked but it didn’t restart

docker restart gladys

---

<div class="post-metadata">

**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\
**Post date:** [September 13, 2024, 10:14am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/7 "2024-09-13T10:14:20Z")

</div>

re,  
ok apparently the restart seems to have worked, I can find my dashboards, objects, conversations … I just need to recover my Node-RED flows to integrate my weather station via MQTT.  
par contre quick question, shouldn’t I rerun the duck migration that was supposed to be incomplete during the Ubuntu crash? I have more than 3

---

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [September 13, 2024, 10:25am UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/8 "2024-09-13T10:25:41Z")

</div>

Indeed, I recommend that you restart the migration!

---

<div class="post-metadata">

**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\
**Post date:** [September 16, 2024, 4:38pm UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/9 "2024-09-16T16:38:58Z")

</div>

hello @pierre-gilles,  
quick update after my server crash.  
server reinstalled with Ubuntu 24.04.  
Gladys reinstalled using the standard script  
Node-RED reinstalled too (outside Gladys)  
database restoration from a GladysPlus backup (long and slowing the server, missing screens showing progress)  
duck migration restarted, SQLite state purge performed and apparently effective.  
SQLite database cleanup run twice but the database remains surprisingly large (13.5 GB).  
I still need to redo my Node-RED flows for my weather station and my EDF meter (using Pitinfo and Wemos, which is ideal when I see all the headaches with the Enedis API and/or Lixee).  
upgraded to the new Gladys version this morning without any issues.

---

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [September 16, 2024, 5:08pm UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/10 "2024-09-16T17:08:26Z")

</div>

Great, thanks for the feedback!

> [@Einstein8854](#):
>
> SQLite database cleanup restarted twice but the database remains surprisingly large (13.5 GB).

Are you sending a lot of messages in your scenes? Your «&nbsp;message&nbsp;» table is probably full; there is a cleanup task that was introduced in v4.45.1 — it will run

---

<div class="post-metadata">

**Author:** ![Will\_71](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/will_71/32/9582_2.png) [@Will\_71](https://community.gladysassistant.com/u/Will_71)\
**Post date:** [September 16, 2024, 5:24pm UTC](https://community.gladysassistant.com/t/restauration-gladys-plus/9082/11 "2024-09-16T17:24:55Z")

</div>

@Einstein8854 Have you restarted your machine after the cleanup?

> [@pierre-gilles](#):
>
> If you don’t reboot after the cleanup, the SQLite file keeps its original size, you have to do it yourself 🙂
