[RESOLVED] Kolibri can't sync, update or download content from Kolibri Studio

Support Kolibri
1

If you have a specific technical inquiry, construct your post with the following:

Summary

Since updating to 0.17.0 a few weeks ago, I had not checked this, but today discovered that Kolibri can’t sync, update or download content from Kolibri Studio. When requesting a download of new content, the task window only shows “Waiting” as the task status and never starts the actual download. Also, there are existing channels in our local Kolibri library that have version updates, but those won’t load either.

Technical details

Version: 0.17.0
OS: Linux-6.1.21-v8±aarch64-with-glibc2.31
Python: 3.9.2
Installer: deb kolibri-server - 0.5.0-0ubuntu1
Server: nginx/1.18.0
Database: /home/pi/.kolibri/db.sqlite3
Free disk space: 625 GB
Server time: Fri Aug 16 2024 11:08:53 GMT+0100 (West Africa Standard Time)
Server timezone: Africa/Douala
Device ID: 86a460380dbbc8ff95b31688d3694024

2

Hi @cjackson, we are sorry for the issues you are experiencing.

According to our dev team, the task status only showing “Waiting” seems to indicate it’s a task processing issue within Kolibri. Did you try to reboot Kolibri and the device?

If the issue persists, we would ask you to provide the db.sqlite3 and job_storage.sqlite3 files for further inspection. Stop Kolibri, compress both as a ZIP file, and try to send them as attachment at support@learningequality.org. In case it’s too big to go through the email, we’ll work to provide a direct upload option.

3

@RadinaMatic Thanks for your follow up. Rebooting did not solve the problem.

I am sending an email with download links for the requested files to the support address you provided.

Thanks

4

Thank you @cjackson, we received both files :+1:t4:
One of our developers with reply with recommendations or further steps after they have reviewed the logs. Thank you for your patience! :pray:t4:

5

Hi @cjackson
Looking at your databases the problem seems to be in the execution of tasks in your server. I see jobs have been queued for days and never started to be executed.

As you’re running kolibri-server it seems it has not started correctly.
Can you try, in a terminal, this command:
sudo systemctl restart kolibri-server
and check if data begins to download?

Regards
josé

6

@jredrejo Thanks for your response and directions on what to try. I’ll do that once I’m back there. I’m away for ~another week.

However, I have in fact done what you indicated before sending in the files and nothing changed.

Chris

7

ok, if, after trying that command the problem persists, please do send us the files at the logs folder in the same folder where you got the database files.

Regards
José

8

@jredrejo : I’m sending an email to support@learningequality.org with a link to download the logs folder.

Thanks!

9

hello @cjackson
looking at the logs they were complaining of a p roblem in one row in your database.

I’m writting here the instructions to manually fix your db but, as you already sent it to us, I can send it you back fixed if you prefer it over doing this procedure.

Here we go (all the steps to be done in a terminal in your linux server):

  • Ensure you’ve stopped all kolibri processes:
  sudo systemctl stop kolibri-server 
  sudo killall kolibri
  1. Move to the folder where your kolibri files are (it’ll be something like this, but it can depend on your linux installation)
  • cd ~/.kolibri/
  1. Start the database tool (if it complains with something like ‘command does not exist’, do first apt install sqlite3 )

sqlite3 db.sqlite3

  1. Execute these three commands:
  delete from content_channelmetadata_included_languages where id=16;
  vacuum;
  .quit
  1. Now you can start kolibri-server again
    sudo systemctl start kolibri-server

Please, let me know if this works or if you prefer me to send you your db

Regards
José

10

José: that did the trick! It’s working again.

Thanks so much.

Chris