HomePhorge

Fix infinite growth of the syncroton_relations_state table on Ping

Description

Fix infinite growth of the syncroton_relations_state table on Ping

The scenario was:

  • We had a synckey with an old timestamp because the folder hasn't been synced for a long time.
  • There was no relations state entry with a lower timestamp
  • The folder was still included in ping
  • Each ping thus did not find an entry, but then inserted a new one (with a more recent timestamp, so it was never found)

As mentioned before, we should really attach the state to the synckey
and not a timestamp, but in the meanwhile this will prevent the growth
and cleanup existing tables.

Details

Provenance
mollekopfAuthored on Sat, Oct 26, 10:25 AM
mollekopfPushed on Sat, Oct 26, 10:29 AM
Parents
rS245aec7bbd28: Add missing resync column to the initial.sql
Branches
Unknown
Tags
Unknown
References
HEAD -> master
Build Status
Buildable 50850