VPS client and server should not use different database copies

syd711 / vpin-studio

Competition, table, and player management for VPins.

MIT License

28 stars 2 forks source link

VPS client and server should not use different database copies #255

Closed ThePrintz closed 3 months ago

ThePrintz commented 4 months ago

VPS updates no longer showing. Something broke the update indicators. Everything is selected in preferences but no markers in Studio.

syd711 commented 4 months ago

Right, I see the bot posted the updated so you should have a marker. I'll take a look this week.

syd711 commented 4 months ago

All options in the UI settings are enabled for this? I just tried to reproduce if there are issues, but the RollerCoaster update did work and I see the indicator. Are there any errors in the log saying something about VPS?

ThePrintz commented 3 months ago

Hi, I was hoping the new matching system would fix this issue, but unfortunately no. I can not find out why... Here I am sending you the log-files. Maybe you can find something. The log files are from a time I know there are updates. See also enclosed screen dump. Screenshot (7)

vpin-studio-logs.zip

syd711 commented 3 months ago

Thanks for the data, that helps. I'll take a look.

syd711 commented 3 months ago

Do you leave your cabinet running? Was the cabinet restarted after the Leathal Weapon updates came out today? ~4pm Central European Time (CET)

ThePrintz commented 3 months ago

Hi. My cabinet runs 24/7. Only restart when absolutely necessary. At least 5 days since last restart. I exit out of pinup popper whenever I need to update something. Vpin Studio (not server) is manually opened and closes randomly when updating games. Hope this helps.

syd711 commented 3 months ago

Yep, I think that is the issue. The server and the client have their own copies of the VPS database. That why the client shows the updated version in the VPS section while the table itself only knows about the older version. I rename this ticket to address the original problem/bug. Did the update marker appear after a server restart?

ThePrintz commented 3 months ago

I will try to restart the computer, but I have done all updates you have released (with server stop/start) without luck. Will post back as soon as cabinet restart.

ThePrintz commented 3 months ago

Just restarted, and still not working correctly. Is it a way to reset and rescan update/version status or is done everytime I scan the tables? Here is updated screenshot and logs

vpin-studio-logs (1).zip

syd711 commented 3 months ago

No, not yet. But at least now I am aware of this synchronization issue and can fix this. When fixing this, I will check again why the update flag is not set. I assume it's a side-affect of this. In any case: thank you for your feedback and provided data.

ThePrintz commented 3 months ago

Just at thought. Could this be a language issue. Maybe it has something to do with how different languages handle commas and full stops?

syd711 commented 3 months ago

We have moved the VPS database completely to the server, so the client and server are always working on the same data. We hope this fixes the issues and close this ticket for now.

Fixed with 2.20.1.