(2019-07-06, 20:16)wizardknight Wrote: Here is a video clip of the issue in action. (Captured on a Win10 box running stock Kodi other than the skin, MariaDB 10.4.6 hosted by Ubuntu 18.04).
1. First time entering Movies.
2. Back out.
3. Re-enter Movies
4. Note the showing of items marked as watched.

See this video showing Kodi working fine with just my tiny, 15 movie, 4K movie collection.
As soon as I add and scrape my 1800+ HD/SD movie collection I see the odd behavior.

After this you have to do something like marking something as watched or going to TV shows to force a reload of the database.

I have tried MariaDB 10.3 and 10.4 (ARM and x86). I have also tried standard Mysql (5.7 I think).
I have tried kodi on Ubuntu 18.04 (X86), 19.04(X86), windows 10 (X86), Librelec (x86), Coreeelc (ARM).
I can reproduce the issue on all of them.
My NAS is currently a SMB share running on Ubuntu 18.04. (I was able to reproduce the issue using NFS on the NAS as well.)

I took my win10 box, and rolled back to kodi-18.0-Leia_beta1-x64, and I was not able to reproduce the issue.
Upgraded to kodi-18.0-Leia_beta3-x64, no issues.
Upgraded to kodi-18.0-Leia_beta4-x64, no issues.
Upgraded to kodi-18.0-Leia_beta5-x64, no issues.

I then tried kodi-18.0-Leia_rc1-x64, and I was able to see the issue again.
So something happened between beta 5, and RC1 that causes this issue.
I can produce this issue on Kodi 18.1, 18.2, 18.3, and 19.

I don't see anyplace that has nightly from that time, so I can't narrow it down anymore.

Log files from one of my devices.

My current network configuration
192.168.15.0/24 network IP configuration.
Netgear R6300v2 Gigabit/Wireless AC

2 A95x boxes running Coreelec
1 wired 10/100
1 Wireless N

1 PC running Win10/Ubuntu 19.04 & Kodi 18.3
Wireless AC 866 (also tested wired gigabit)

NAS/Mysql server - Rock64 running Ubuntu 18.04
Wired gigabit
(I did test using a PC with ubuntu 18.04 as the NAS/Mysql server. No change)

I can reproduce this issue all day long with clean fresh builds on all of these devices.

My Advancedsettings.xml file

Code:

<advancedsettings>
<videodatabase>
<type>mysql</type>
<compression>true</compression>
<host>192.168.15.2</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<cache>
<memorysize>536870912</memorysize>
<readfactor>10</readfactor>
<buffermode>1</buffermode>
</cache>
</advancedsettings>

I have no watched/hidden issues if I use the local sqlite database, but then I can't share the watched state between multiple devices obviously.

Not sure what else I can provide that would be useful for troubleshooting.