Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

kiosk sync: a record that got modified by one dock and deleted by another is never dropped #2945

Closed
urapadmin opened this issue Oct 31, 2024 · 2 comments
Assignees
Labels
kiosk a kiosk issue (not a filemaker issue) synchronization
Milestone

Comments

@urapadmin
Copy link
Collaborator

coming out of #2931:

two docks A and B: A modified a record first, then B deletes it a bit later.
In synchronization the record does not get deleted.

I can't really see why.

@urapadmin urapadmin added new-issue issue needs to be reviewed and labels and projects need to be added. Remove afterwards. kiosk a kiosk issue (not a filemaker issue) synchronization and removed new-issue issue needs to be reviewed and labels and projects need to be added. Remove afterwards. labels Oct 31, 2024
@urapadmin
Copy link
Collaborator Author

Confirmed. The reason is that I have NO time stamp of the deletion. The time stamp of all deletions is the fork time of the dock PLUS arbitrary 2 seconds to make sure it is actually ahead of the main record.

The result is that a modification is ALWAYS ahead of that and will win.

I am actually not that unhappy with it because I think I'd rather keep a record in such a dubious case. I only take issue with the fact that this is a side effect rather than planned behaviour.

@urapadmin
Copy link
Collaborator Author

urapadmin commented Oct 31, 2024

Koisk 1.6.6.4

  • in such a case Kiosk will inform:

Synchronization._sync_deleted_records: X rows got deleted by at least one dock but REMAIN in table XYZ because
they were also modified by at least one dock. Kiosk resolves such peculiarities ALWAYS by keeping rather than losing data.

This is not really a time zone issue, it was exactly like that in older Kiosk versions as well. Can be tested with two devices in the same time zone, too.

@urapadmin urapadmin moved this to done in time zone support Oct 31, 2024
@urapadmin urapadmin added this to the kiosk 1.7 milestone Oct 31, 2024
@github-project-automation github-project-automation bot moved this to Needs triage in testing Oct 31, 2024
@luizaogs luizaogs moved this from Needs triage to single test in testing Oct 31, 2024
@github-project-automation github-project-automation bot moved this from single test to Closed in testing Oct 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kiosk a kiosk issue (not a filemaker issue) synchronization
Projects
Status: Closed
Status: done
Development

No branches or pull requests

2 participants