hello again @jredrejo
Thank you for the instructions. The process did not go so well.
I followed your instructions and this is terminal from the session
Last login: Fri Apr 5 08:40:18 2024 from 10.10.30.1
kolibri@kol-oa:~$ sudo systemctl stop kolibri
[sudo] password for kolibri:
kolibri@kol-oa:~$ sudo apt install sqlite3
Reading package lists… Done
Building dependency tree
Reading state information… Done
Suggested packages:
sqlite3-doc
The following NEW packages will be installed:
sqlite3
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 860 kB of archives.
After this operation, 2803 kB of additional disk space will be used.
Get:1 Index of /ubuntu focal-updates/main amd64 sqlite3 amd64 3.31.1-4ubuntu0.6 [860 kB]
Fetched 860 kB in 7s (119 kB/s)
Selecting previously unselected package sqlite3.
(Reading database … 121955 files and directories currently installed.)
Preparing to unpack …/sqlite3_3.31.1-4ubuntu0.6_amd64.deb …
Unpacking sqlite3 (3.31.1-4ubuntu0.6) …
Setting up sqlite3 (3.31.1-4ubuntu0.6) …
Processing triggers for man-db (2.9.1-1) …
kolibri@kol-oa:~$ cd /home/kolibri/.kolibri/
kolibri@kol-oa:~/.kolibri$ cp db.sqlite3 db.sqlite3.bak
kolibri@kol-oa:~/.kolibri$ pwd
/home/kolibri/.kolibri
kolibri@kol-oa:~/.kolibri$ ls
backups logs process_cache
content networklocation.sqlite3 sessions
databases nginx.conf static
db.sqlite3 notifications.sqlite3 syncqueue.sqlite3
db.sqlite3.bak options.ini temp
job_storage.sqlite3 options.ini.kolibri-server-backup
log_export plugins.json
kolibri@kol-oa:~/.kolibri$ sqlite3 db.sqlite3
SQLite version 3.31.1 2020-01-27 19:55:54
Enter “.help” for usage hints.
sqlite> vacuum
…>
Afte entering the vacuum command the prompt immediately went to …> and sat with no change as above …>
In my inexperience of the sqlite tool, I did not know how long I had to wait or what the prompt (…>) will look like when finished vacuum. I waited 10 minutes (using stopwatch) and no change.
I wanted to compare how the sqlite3 tool worked on kolibri server with very small database. Then in my hopes of seeing something different in small database, I performed the same steps on local kolibri server with 150kb database.
The response was the same, after giving vacuum command the prompt immediately went to …> and just sat there with no change
The time elapsed on vacuum command in the ObAnggen (OA) server was now closing in on 15 minutes. I perhaps gave up too early.
I then tried to exit the vacuum command tool with the .quit command but that did not work on either server. I looked up exiting sqlite3 and found the CTRL-D option and this worked to exit the vacuum tool.
After exit of sqlite3 tool with CTRL-D, I tried to restart kolibri service in the OA server and was unable to start the service. I was able to restart kolibri service in the local server.
I chose to reboot the OA server and this is status of kolibri service
lines 1-21/21 (END)
● kolibri.service - LSB: kolibri daemon, an offline education platform
Loaded: loaded (/etc/init.d/kolibri; enabled; vendor preset: enabled)
Active: activating (start) since Sat 2024-04-06 20:57:52 WIT; 1min 42s ago
Cntrl PID: 845 (kolibri)
Tasks: 3 (limit: 19088)
Memory: 2.4G
CGroup: /system.slice/kolibri.service
├─845 /bin/sh /etc/init.d/kolibri start
├─873 runuser kolibri -c kolibri start
└─887 /usr/bin/python3 /bin/kolibri start
Apr 06 20:57:52 kol-oa systemd[1]: Starting LSB: kolibri daemon, an offline education platform…
Apr 06 20:57:52 kol-oa runuser[873]: pam_unix(runuser:session): session opened for user kolibri by (uid=0)
Apr 06 20:57:53 kol-oa kolibri[887]: WARNING 2024-04-06 20:57:53,837 Option CHERRYPY_START in section [Server] is deprecate>
Apr 06 20:57:53 kol-oa kolibri[887]: INFO 2024-04-06 20:57:53,839 Option DEBUG in section [Server] being overridden by e>
Apr 06 20:57:53 kol-oa kolibri[887]: INFO 2024-04-06 20:57:53,839 Option DEBUG_LOG_DATABASE in section [Server] being ov>
Apr 06 20:57:54 kol-oa kolibri[887]: /usr/lib/python3/dist-packages/kolibri/dist/rest_framework/utils/serializer_helpers.py:>
Apr 06 20:57:54 kol-oa kolibri[887]: if value is None or value is ‘’:
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,425 Running Kolibri with the following settings: kolibri.d>
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,463 Configuring Redis: maxmemory-policy allkeys-lru
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,463 Configuring Redis: maxmemory 1516069683
I then took a look at the db files and no change

As far as I can tell the OA server is functioning OK. Will know for sure when school start on Monday.
This is journalctl for kolibri service for past day
kolibri@kol-oa:~$ sudo journalctl -u kolibri.service --since “1 day ago”
[sudo] password for kolibri:
– Logs begin at Sun 2022-02-20 04:14:03 WIT, end at Sun 2024-04-07 03:34:04 WIT. –
Apr 06 20:55:22 kol-oa systemd[1]: Starting LSB: kolibri daemon, an offline education platform…
Apr 06 20:55:22 kol-oa runuser[4443]: pam_unix(runuser:session): session opened for user kolibri by (uid=0)
Apr 06 20:55:23 kol-oa kolibri[4444]: WARNING 2024-04-06 20:55:23,666 Option CHERRYPY_START in section [Server] is deprecat>
Apr 06 20:55:23 kol-oa kolibri[4444]: INFO 2024-04-06 20:55:23,669 Option DEBUG in section [Server] being overridden by >
Apr 06 20:55:23 kol-oa kolibri[4444]: INFO 2024-04-06 20:55:23,669 Option DEBUG_LOG_DATABASE in section [Server] being o>
Apr 06 20:55:24 kol-oa kolibri[4444]: /usr/lib/python3/dist-packages/kolibri/dist/rest_framework/utils/serializer_helpers.py>
Apr 06 20:55:24 kol-oa kolibri[4444]: if value is None or value is ‘’:
Apr 06 20:55:24 kol-oa kolibri[4444]: INFO 2024-04-06 20:55:24,257 Running Kolibri with the following settings: kolibri.>
– Reboot –
Apr 06 20:57:52 kol-oa systemd[1]: Starting LSB: kolibri daemon, an offline education platform…
Apr 06 20:57:52 kol-oa runuser[873]: pam_unix(runuser:session): session opened for user kolibri by (uid=0)
Apr 06 20:57:53 kol-oa kolibri[887]: WARNING 2024-04-06 20:57:53,837 Option CHERRYPY_START in section [Server] is deprecate>
Apr 06 20:57:53 kol-oa kolibri[887]: INFO 2024-04-06 20:57:53,839 Option DEBUG in section [Server] being overridden by e>
Apr 06 20:57:53 kol-oa kolibri[887]: INFO 2024-04-06 20:57:53,839 Option DEBUG_LOG_DATABASE in section [Server] being ov>
Apr 06 20:57:54 kol-oa kolibri[887]: /usr/lib/python3/dist-packages/kolibri/dist/rest_framework/utils/serializer_helpers.py:>
Apr 06 20:57:54 kol-oa kolibri[887]: if value is None or value is ‘’:
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,425 Running Kolibri with the following settings: kolibri.d>
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,463 Configuring Redis: maxmemory-policy allkeys-lru
Apr 06 20:57:54 kol-oa kolibri[887]: INFO 2024-04-06 20:57:54,463 Configuring Redis: maxmemory 1516069683
Apr 06 21:03:20 kol-oa kolibri[887]: INFO 2024-04-06 21:03:20,766 Backed up database to: /home/kolibri/.kolibri/backups/>
Apr 06 21:03:20 kol-oa kolibri[887]: INFO 2024-04-06 21:03:20,767 Version was 0.14.7, new version: 0.15.12
Apr 06 21:03:20 kol-oa kolibri[887]: INFO 2024-04-06 21:03:20,767 Running update routines for new version…
Apr 06 21:03:21 kol-oa kolibri[887]: Operations to perform:
Apr 06 21:03:21 kol-oa kolibri[887]: Apply all migrations: admin, analytics, auth, bookmarks, content, contenttypes, devic>
Apr 06 21:03:21 kol-oa kolibri[887]: Running migrations:
Apr 06 21:03:21 kol-oa kolibri[887]: No migrations to apply.
Apr 06 21:03:21 kol-oa kolibri[887]: Operations to perform:
Apr 06 21:03:21 kol-oa kolibri[887]: Apply all migrations: admin, analytics, auth, bookmarks, content, contenttypes, devic>
Apr 06 21:03:21 kol-oa kolibri[887]: Running migrations:
Apr 06 21:03:21 kol-oa kolibri[887]: No migrations to apply.
Apr 06 21:03:21 kol-oa kolibri[887]: Operations to perform:
Apr 06 21:03:21 kol-oa kolibri[887]: Apply all migrations: admin, analytics, auth, bookmarks, content, contenttypes, devic>
Apr 06 21:03:21 kol-oa kolibri[887]: Running migrations:
Apr 06 21:03:21 kol-oa kolibri[887]: No migrations to apply.
Apr 06 21:04:02 kol-oa kolibri[887]: Operations to perform:
Apr 06 21:04:02 kol-oa kolibri[887]: Apply all migrations: admin, analytics, auth, bookmarks, content, contenttypes, devic>
Apr 06 21:04:02 kol-oa kolibri[887]: Running migrations:
Apr 06 21:04:02 kol-oa kolibri[887]: No migrations to apply.
Apr 06 21:04:02 kol-oa kolibri[887]: Installed 2 object(s) from 1 fixture(s)
Apr 06 21:04:22 kol-oa kolibri[887]: Error: Traceback (most recent call last):
Apr 06 21:04:22 kol-oa kolibri[887]: File “/usr/lib/python3/dist-packages/kolibri/dist/django/db/backends/utils.py”, line >
Apr 06 21:04:22 kol-oa kolibri[887]: return self.cursor.execute(sql, params)
During the process I certainly was confused by my inexperience with sqlite3 tool and the .quit command not working while still in vacuum command.
I made a Snapshot of the OA server VM before starting the vacuum process, so I can rollback if problems arise on Monday.
My questions are:
Did I enter the wrong command for vacuum? Perhaps I needed a statement after the vacuum command?
Do you know how the sqlite3 prompt is supposed to act during a vacuum?
Do you think the 15 minute time period was sufficient? or did I exit too early?
Are there other reports you would like to see from the OA server to help troubleshoot the failed vacuum process?
Thank you for your help and apologies for my inexperience/impatience in the vacuum process.
Kind regards,
David