Skip to content

Mobile app creates many conflicting copies and inflates project size #4583

Description

@xkello

Description

The mobile app is creating many conflicting copies on tracking layer of files during normal use in the production environment.

From the logs, we discovered that the database is being locked. This may be related to file locking or concurrent access on mobile. The following issue could be relevant for the investigation/fix: #4577, which proposes enabling WAL mode for GeoPackages to help with "Database is locked" problems.

The exact workflow that leads to these conflicting copies is currently unknown. The customer has been asked to provide more details about how they use the app, which may help identify the reproduction steps.

Environment

PROD

Current behavior

Many conflicting copies of files are created while the customer is using the mobile app. Logs indicate that the database is being locked.

This causes the project size to grow significantly, so far in the range of approximately 10–20x the expected size.

Expected behavior

The mobile app should handle file access/sync in a way that does not create conflicting copies during normal use and does not cause the project size to grow unexpectedly.

Additional information

  • Exact reproduction steps are not known yet.
  • Customer was asked to provide more information about their workflow.
  • Logs can be provided by me: @xkello.
  • The related Odoo ticket can also be provided if needed.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions