Is their a limit to the number of TV shows?

That command is to be run from a command line on the Pi. Log in via ssh (like you would to provide logs)

Getting somewhere.

osmc@rasp1:~$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 172M 0 172M 0% /dev
tmpfs 177M 4.5M 172M 3% /run
/dev/mmcblk0p2 15G 2.6G 11G 19% /
tmpfs 177M 0 177M 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 177M 0 177M 0% /sys/fs/cgroup
/dev/mmcblk0p1 240M 38M 202M 16% /boot
tmpfs 36M 0 36M 0% /run/user/1000

That looks ok, so now also at command line run grab-logs -A

I don’t think anyone has asked this. Is the mysql server on the Pi, or elsewhere?

https://paste.osmc.tv/baradariza

It is on a separate server networked to the Pi.

Then check if there is enough free space on the mysql server.

If we are talking about physical drive space there is 5,598.4GB free.

So let’s once more try it.
Login to phpmyadmin with the rasp1 user and execute
select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10; against MyVideos107

It’s time to focus on the mysql server, not the Pi. Start off with this:

Thanks. It will take me a while to go through that. I’ll let you know how I go.

#126 - Incorrect key file for table ‘/tmp/#sql_b26_0.MYI’; try to repair it

Just go to the database, select all tables and press repair table at the bottom

What type of server is the database on? If linux based can you run the df -h command on it?

Linux based - did df -h about 4 answers ago.

The only df -h I see was from your Pi, not the database server.

So from phpmyadmin, what do you get if you try this SQL query:

SELECT count(idepisode) FROM episode

4947

-bash-4.3# df -h
Filesystem Size Used Available Use% Mounted on
rootfs 9.7M 5.7M 3.5M 62% /
/dev/root 9.7M 5.7M 3.5M 62% /
mdev 248.9M 0 248.9M 0% /dev
/dev/loop0 43.8M 43.8M 0 100% /usr/local/modules
/dev/mtdblock5 5.0M 448.0k 4.6M 9% /usr/local/config
/dev/sda4 959.9M 84.1M 875.8M 9% /mnt/HD_a4
/dev/sdb4 959.9M 33.3M 926.6M 3% /mnt/HD_b4
/dev/sdc4 959.9M 33.3M 926.6M 3% /mnt/HD_c4
/dev/sdd4 959.9M 33.3M 926.6M 3% /mnt/HD_d4
/dev/md1 8.1T 2.6T 5.5T 33% /mnt/HD/HD_a2
/dev/md1 8.1T 2.6T 5.5T 33% /mnt/HD/HD_a2/Nas_Prog/elfinder/web/php/HD/Volume_1
/dev/md1 8.1T 2.6T 5.5T 33% /home/root/.ssh
-bash-4.3#

Did you try this yet then?

If this doesn’t do it, then I think that you have a badly corrupted database, and need to just start over with a new database.

Or… I’m guessing that the database is on a NAS? (It would have helped if you had told us where the database was to begin with) It could be that the NAS is running out of memory.

Sorry, I thought I had.

From you said earlier, delete the troublesome database - MyVideos107 - and re-scrape through Kodi to get a new one?

Yes, try that. (or using pypmyadmin rename the original database)

Just so I am clear, MyVideos107 - rename to (eg) MyVideos107BAK and re-scrape?