davis
davis copied to clipboard
tchapi
Android DAVx5 -> Davis, syncing one event triggers Postgres error
Hej,
as Davis is now running I moved all my calendar entries from my old Baikal CalDAV server to Davis CalDAV within my Calendar app and synced the account to Davis with DAVx5. Once entry is giving me trouble and I do see an error within the Docker stack.
For my limited programmer knowledge this looks like a variable out of bounds of missing a default...
Docker stack ("unnamed portal parameter $9")
postgresql | 2025-04-08 06:50:27.364 UTC [28] LOG: checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.812 s, sync=0.005 s, total=1.825 s; sync files=15, longest=0.003 s, average=0.001 s; distance=2 kB, estimate=30 kB; lsn=0/1A37B18, redo lsn=0/1A37AE0
postgresql | 2025-04-08 06:57:56.712 UTC [3410] ERROR: value "2160158400" is out of range for type integer
postgresql | 2025-04-08 06:57:56.712 UTC [3410] CONTEXT: unnamed portal parameter $9 = '...'
postgresql | 2025-04-08 06:57:56.712 UTC [3410] STATEMENT: INSERT INTO calendarobjects (calendarid, uri, calendardata, lastmodified, etag, size, componenttype, firstoccurence, lastoccurence, uid) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10)
postgresql | 2025-04-08 07:00:25.503 UTC [28] LOG: checkpoint starting: time
postgresql | 2025-04-08 07:00:26.223 UTC [28] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.707 s, sync=0.005 s, total=0.720 s; sync files=8, longest=0.003 s, average=0.001 s; distance=15 kB, estimate=29 kB; lsn=0/1A3B840, redo lsn=0/1A3B808
DAVx5 Debug info
--- BEGIN DEBUG INFO ---
NOTIFICATION TIME
Local time: 2025-04-08T11:08:00+02:00
UTC: 2025-04-08T09:08:00Z
SYNCHRONIZATION INFO
Account: Account {name=<REDACTED> Davies, type=bitfire.at.davdroid}
Authority: com.android.calendar
LOCAL RESOURCE
AndroidEvent(calendar=at.bitfire.davdroid.resource.LocalCalendar@7c30ed6, id=1888, event=Event(uid=6d6f52ef-d8c3-4534-83ed-23956fdab944, sequence=0, userAgents=[com.tech149.android.apps.live], recurrenceId=null, summary=[Private] Meike besuchen / Blumen, location=<REDACTED>, url=null, description=null, color=null, dtStart=DTSTART;TZID=Europe/Berlin:20230614T160000
, dtEnd=DTEND;TZID=Europe/Berlin:20230614T220000
, duration=null, rRules=[RRULE:FREQ=YEARLY;COUNT=20;BYMONTH=6;BYMONTHDAY=14
], exRules=[], rDates=[], exDates=[], exceptions=[], classification=null, status=null, opaque=true, organizer=null, attendees=[], alarms=[BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:[Private] Meike besuchen / Blumen
END:VALARM
], lastModified=null, categories=[], unknownProperties=[]))
REMOTE RESOURCE
https://cards-cal.intern.<REDACTED>/dav/calendars/os/default/6d6f52ef-d8c3-4534-83ed-23956fdab944.ics
SOFTWARE INFORMATION
┌───────────────────────────────────┬─────────────────────────────────────────────────┬────────────┬─────────────────────┬───────┐
│ Package │ Version │ Code │ Installer │ Notes │
├───────────────────────────────────┼─────────────────────────────────────────────────┼────────────┼─────────────────────┼───────┤
│ at.bitfire.davdroid │ 4.4.8-gplay │ 404080001 │ com.android.vending │ │
│ com.android.providers.contacts │ 15 │ 35 │ — │ │
│ com.android.providers.calendar │ 15 │ 35 │ — │ │
│ com.google.android.calendar │ 2025.11.0-737427633-release │ 2017713841 │ com.android.vending │ │
│ com.tech149.android.apps.live │ 3.80.0 │ 166 │ com.android.vending │ │
│ com.google.android.apps.messaging │ messages.android_20250319_02_RC00.phone_dynamic │ 273718063 │ com.android.vending │ │
└───────────────────────────────────┴─────────────────────────────────────────────────┴────────────┴─────────────────────┴───────┘
SYSTEM INFORMATION
Android version: 15 (BP1A.250305.019)
Device: Google Pixel 8 Pro (husky)
Locale(s): [de_DE,en_DE]
Time zone: Europe/Berlin
Internal memory (/data): 37,45 GB free of 118 GB
App standby bucket: exempted (very good)
App exempted from power saving: yes (good)
System in power-save mode: no
System-wide synchronization: automatically
CONNECTIVITY
[...]
CONFIGURATION
Notifications:
- sync isBlocked=false
* syncProblems: importance=3
* syncIoErrors: importance=1
* syncWarnings: importance=2
- status: importance=2
- general: importance=3
- debug: importance=4
Permissions:
- ACCESS_NETWORK_STATE: granted
- ACCESS_WIFI_STATE: granted
- INTERNET: granted
- POST_NOTIFICATIONS: granted
- READ_SYNC_SETTINGS: granted
- READ_SYNC_STATS: granted
- WRITE_SYNC_SETTINGS: granted
- RECEIVE_BOOT_COMPLETED: granted
- REQUEST_IGNORE_BATTERY_OPTIMIZATIONS: granted
- READ_CONTACTS: granted
- WRITE_CONTACTS: granted
- READ_CALENDAR: granted
- WRITE_CALENDAR: granted
- ACCESS_COARSE_LOCATION: denied
- ACCESS_FINE_LOCATION: denied
- ACCESS_BACKGROUND_LOCATION: denied
- com.android.vending.BILLING: granted
- WAKE_LOCK: granted
- FOREGROUND_SERVICE: granted
- org.dmfs.permission.READ_TASKS: denied
- org.dmfs.permission.WRITE_TASKS: denied
- org.tasks.permission.READ_TASKS: denied
- org.tasks.permission.WRITE_TASKS: denied
- at.techbee.jtx.permission.READ: denied
- at.techbee.jtx.permission.WRITE: denied
- at.bitfire.davdroid.DYNAMIC_RECEIVER_NOT_EXPORTED_PERMISSION: granted
ACCOUNTS
- Account: <REDACTED> Davies
┌─────────────────────────┬────────────┬──────────────────────┬───────────────────────────────────┐
│ Authority │ isSyncable │ syncsOnContentChange │ Entries │
├─────────────────────────┼────────────┼──────────────────────┼───────────────────────────────────┤
│ com.android.calendar │ true │ true │ 153 event(s) │
│ at.techbee.jtx.provider │ false │ false │ — │
│ org.dmfs.tasks │ false │ false │ — │
│ org.tasks.opentasks │ false │ false │ — │
│ com.android.contacts │ false │ false │ 0 wrongly assigned raw contact(s) │
└─────────────────────────┴────────────┴──────────────────────┴───────────────────────────────────┘
Authentication: user name, password
WiFi only: false
Contact group method: GROUP_VCARDS
Time range (past days): 365
Default alarm (min before): null
Manage calendar colors: true
Use event colors: true
Sync workers:
┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬───────────┬──────────────────┬──────────────┬─────────┬────────────┬───────────────┐
│ Tags │ Data Type │ State │ Next run │ Retries │ Generation │ Periodicity │
├──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────┼──────────────────┼──────────────┼─────────┼────────────┼───────────────┤
│ [sync-TASKS bitfire.at.davdroid/<REDACTED> Davies, onetime-sync TASKS bitfire.at.davdroid/<REDACTED> Davies, .sync.worker.OneTimeSyncWorker] │ TASKS │ FAILED (-256) │ — │ 1 │ 0 │ not periodic │
│ [onetime-sync CONTACTS bitfire.at.davdroid/<REDACTED> Davies, .sync.worker.OneTimeSyncWorker, sync-CONTACTS bitfire.at.davdroid/<REDACTED> Davies] │ CONTACTS │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
│ [periodic-sync CONTACTS bitfire.at.davdroid/<REDACTED> Davies, sync-CONTACTS bitfire.at.davdroid/<REDACTED> Davies, .sync.worker.PeriodicSyncWorker] │ CONTACTS │ ENQUEUED (-256) │ In 3 Stunden │ 0 │ 0 │ every 240 min │
│ [onetime-sync EVENTS bitfire.at.davdroid/<REDACTED> Davies, .sync.worker.OneTimeSyncWorker, sync-EVENTS bitfire.at.davdroid/<REDACTED> Davies] │ EVENTS │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
│ [periodic-sync EVENTS bitfire.at.davdroid/<REDACTED>Davies, .sync.worker.PeriodicSyncWorker, sync-EVENTS bitfire.at.davdroid/<REDACTED> Davies] │ EVENTS │ ENQUEUED (-256) │ In 3 Stunden │ 0 │ 0 │ every 240 min │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴───────────┴──────────────────┴──────────────┴─────────┴────────────┴───────────────┘
- Account: ALT
┌─────────────────────────┬────────────┬──────────────────────┬───────────────────────────────────┐
│ Authority │ isSyncable │ syncsOnContentChange │ Entries │
├─────────────────────────┼────────────┼──────────────────────┼───────────────────────────────────┤
│ com.android.calendar │ true │ false │ 0 event(s) │
│ at.techbee.jtx.provider │ false │ false │ — │
│ org.dmfs.tasks │ false │ false │ — │
│ org.tasks.opentasks │ false │ false │ — │
│ com.android.contacts │ false │ false │ 0 wrongly assigned raw contact(s) │
└─────────────────────────┴────────────┴──────────────────────┴───────────────────────────────────┘
Authentication: user name, password
WiFi only: false
Contact group method: GROUP_VCARDS
Time range (past days): 365
Default alarm (min before): null
Manage calendar colors: true
Use event colors: true
Sync workers:
┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬───────────┬──────────────────┬──────────┬─────────┬────────────┬──────────────┐
│ Tags │ Data Type │ State │ Next run │ Retries │ Generation │ Periodicity │
├────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────┼──────────────────┼──────────┼─────────┼────────────┼──────────────┤
│ [.sync.worker.OneTimeSyncWorker, onetime-sync CONTACTS bitfire.at.davdroid/ALT, sync-CONTACTS bitfire.at.davdroid/ALT] │ CONTACTS │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
│ [onetime-sync EVENTS bitfire.at.davdroid/ALT, sync-EVENTS bitfire.at.davdroid/ALT, .sync.worker.OneTimeSyncWorker] │ EVENTS │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
│ [onetime-sync TASKS bitfire.at.davdroid/ALT, .sync.worker.OneTimeSyncWorker, sync-TASKS bitfire.at.davdroid/ALT] │ TASKS │ FAILED (-256) │ — │ 1 │ 0 │ not periodic │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴───────────┴──────────────────┴──────────┴─────────┴────────────┴──────────────┘
ADDRESS BOOK ACCOUNTS
* Address book: Default Address Book (<REDACTED> Davies) #13
┌──────────────────────┬────────────┬──────────────────────┬───────────────────┐
│ Authority │ isSyncable │ syncsOnContentChange │ Entries │
├──────────────────────┼────────────┼──────────────────────┼───────────────────┤
│ com.android.contacts │ true │ true │ 12 raw contact(s) │
└──────────────────────┴────────────┴──────────────────────┴───────────────────┘
Collection ID: 13
Read-only: 0
* Address book: Default Address Book (ALT) #12
┌──────────────────────┬────────────┬──────────────────────┬───────────────────┐
│ Authority │ isSyncable │ syncsOnContentChange │ Entries │
├──────────────────────┼────────────┼──────────────────────┼───────────────────┤
│ com.android.contacts │ true │ true │ 87 raw contact(s) │
└──────────────────────┴────────────┴──────────────────────┴───────────────────┘
Collection ID: 12
Read-only: 0
OTHER WORKERS
┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬──────────────────┬───────────────┬─────────┬────────────┬────────────────┐
│ Tags │ State │ Next run │ Retries │ Generation │ Periodicity │
├────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼──────────────────┼───────────────┼─────────┼────────────┼────────────────┤
│ [.sync.account.AccountsCleanupWorker] │ ENQUEUED (-256) │ In 12 Stunden │ 0 │ 516 │ every 1440 min │
│ [sync-CONTACTS bitfire.at.davdroid/<REDACTED>, periodic-sync CONTACTS bitfire.at.davdroid/<REDACTED>, .sync.worker.PeriodicSyncWorker] │ CANCELLED (-256) │ — │ 0 │ 1 │ every 240 min │
│ [sync-EVENTS bitfire.at.davdroid/<REDACTED>, periodic-sync EVENTS bitfire.at.davdroid/<REDACTED>, .sync.worker.PeriodicSyncWorker] │ CANCELLED (-256) │ — │ 0 │ 0 │ every 240 min │
│ [sync-TASKS bitfire.at.davdroid/<REDACTED>, .sync.worker.OneTimeSyncWorker, onetime-sync TASKS bitfire.at.davdroid/<REDACTED>] │ FAILED (-256) │ — │ 1 │ 0 │ not periodic │
│ [sync-CONTACTS bitfire.at.davdroid/<REDACTED>, onetime-sync CONTACTS bitfire.at.davdroid/<REDACTED>, .sync.worker.OneTimeSyncWorker] │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
│ [onetime-sync EVENTS bitfire.at.davdroid/<REDACTED>, sync-EVENTS bitfire.at.davdroid/<REDACTED>, .sync.worker.OneTimeSyncWorker] │ SUCCEEDED (-256) │ — │ 1 │ 0 │ not periodic │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴──────────────────┴───────────────┴─────────┴────────────┴────────────────┘
DATABASE DUMP
android_metadata
┌────────┐
│ locale │
├────────┤
│ de_DE │
└────────┘
service
┌────┬───────────────────────────────┬─────────┬─────────────────────────────────────────────────────────────┐
│ id │ accountName │ type │ principal │
├────┼───────────────────────────────┼─────────┼─────────────────────────────────────────────────────────────┤
│ 11 │ ALT │ carddav │ https://caldav.intern.<REDACTED>/dav.php/principals/os/ │
│ 12 │ ALT │ caldav │ https://caldav.intern.<REDACTED>/dav.php/principals/os/ │
│ 13 │ <REDACTED> Davies │ carddav │ https://cards-cal.<REDACTED>/dav/principals/os/ │
│ 14 │ <REDACTED> Davies │ caldav │ https://cards-cal.<REDACTED>/dav/principals/os/ │
└────┴───────────────────────────────┴─────────┴─────────────────────────────────────────────────────────────┘
sqlite_sequence
┌─────────────────┬──────┐
│ name │ seq │
├─────────────────┼──────┤
│ service │ 14 │
│ homeset │ 14 │
│ principal │ 14 │
│ syncstats │ 6204 │
│ webdav_document │ 0 │
│ collection │ 14 │
└─────────────────┴──────┘
homeset
┌────┬───────────┬──────────┬───────────────────────────────────────────────────────────────┬──────────┬─────────────┐
│ id │ serviceId │ personal │ url │ privBind │ displayName │
├────┼───────────┼──────────┼───────────────────────────────────────────────────────────────┼──────────┼─────────────┤
│ 11 │ 11 │ 1 │ https://caldav.<REDACTED>/dav.php/addressbooks/os/ │ 1 │ — │
│ 12 │ 12 │ 1 │ https://caldav.<REDACTED>/dav.php/calendars/os/ │ 1 │ — │
│ 13 │ 14 │ 1 │ https://cards-cal.<REDACTED>/dav/calendars/os/ │ 1 │ — │
│ 14 │ 13 │ 1 │ https://cards-cal.<REDACTED>/dav/addressbooks/os/ │ 1 │ — │
└────┴───────────┴──────────┴───────────────────────────────────────────────────────────────┴──────────┴─────────────┘
principal
┌────┬───────────┬────────────────────────────────────────────────────────────┬───────────────┐
│ id │ serviceId │ url │ displayName │
├────┼───────────┼────────────────────────────────────────────────────────────┼───────────────┤
│ 11 │ 11 │ https://caldav.<REDACTED>/dav.php/principals/os │ Oliver Schade │
│ 12 │ 12 │ https://caldav.<REDACTED>/dav.php/principals/os │ Oliver Schade │
│ 13 │ 13 │ https://cards-cal.<REDACTED>/dav/principals/os │ Oliver Schade │
│ 14 │ 14 │ https://cards-cal.<REDACTED>/dav/principals/os │ Oliver Schade │
└────┴───────────┴────────────────────────────────────────────────────────────┴───────────────┘
syncstats
┌──────┬──────────────┬──────────────────────┬───────────────┐
│ id │ collectionId │ authority │ lastSync │
├──────┼──────────────┼──────────────────────┼───────────────┤
│ 6196 │ 11 │ com.android.calendar │ 1744095168979 │
│ 6202 │ 12 │ com.android.contacts │ 1744097824983 │
│ 6203 │ 14 │ com.android.calendar │ 1744103273125 │
│ 6204 │ 13 │ com.android.contacts │ 1744103280297 │
└──────┴──────────────┴──────────────────────┴───────────────┘
webdav_mount
┌────┬──────┬─────┐
│ id │ name │ url │
├────┼──────┼─────┤
└────┴──────┴─────┘
room_master_table
┌────┬──────────────────────────────────┐
│ id │ identity_hash │
├────┼──────────────────────────────────┤
│ 42 │ 2ff7560d957e03a78b4b7de88aa9593b │
└────┴──────────────────────────────────┘
webdav_document: 0 row(s), data not listed here
collection
┌────┬───────────┬───────────┬─────────┬──────────────┬───────────────────────────────────────────────────────────────────────┬──────────────────┬────────────┬───────────────┬──────────────────────┬────────────────────────────────────────┬─────────┬───────────────┬────────────────┬───────────────┬──────────────────┬────────┬──────┬───────────┬─────────────────┬──────────────────┬─────────────────────────┬─────────────────────────┐
│ id │ serviceId │ homeSetId │ ownerId │ type │ url │ privWriteContent │ privUnbind │ forceReadOnly │ displayName │ description │ color │ timezoneId │ supportsVEVENT │ supportsVTODO │ supportsVJOURNAL │ source │ sync │ pushTopic │ supportsWebPush │ pushSubscription │ pushSubscriptionExpires │ pushSubscriptionCreated │
├────┼───────────┼───────────┼─────────┼──────────────┼───────────────────────────────────────────────────────────────────────┼──────────────────┼────────────┼───────────────┼──────────────────────┼────────────────────────────────────────┼─────────┼───────────────┼────────────────┼───────────────┼──────────────────┼────────┼──────┼───────────┼─────────────────┼──────────────────┼─────────────────────────┼─────────────────────────┤
│ 11 │ 12 │ 12 │ 12 │ CALENDAR │ https://caldav.<REDACTED>e/dav.php/calendars/os/default/ │ 1 │ 1 │ 1 │ Default calendar │ Default calendar │ -635136 │ Europe/Berlin │ 1 │ 1 │ 0 │ — │ 0 │ — │ 0 │ — │ — │ — │
│ 12 │ 11 │ 11 │ 11 │ ADDRESS_BOOK │ https://caldav.<REDACTED>/dav.php/addressbooks/os/default/ │ 1 │ 1 │ 0 │ Default Address Book │ Default Address Book for <REDACTED> │ — │ — │ — │ — │ — │ — │ 1 │ — │ 0 │ — │ — │ — │
│ 13 │ 13 │ 14 │ 13 │ ADDRESS_BOOK │ https://cards-cal.<REDACTED>/dav/addressbooks/os/default/ │ 1 │ 1 │ 0 │ Default Address Book │ Default Address Book for <REDACTED> │ — │ — │ — │ — │ — │ — │ 1 │ — │ 0 │ — │ — │ — │
│ 14 │ 14 │ 13 │ 14 │ CALENDAR │ https://cards-cal.<REDACTED>/dav/calendars/os/default/ │ 1 │ 1 │ 0 │ Default Calendar │ Default Calendar for <REDACTED> │ — │ — │ 1 │ 0 │ 0 │ — │ 1 │ — │ 0 │ — │ — │ — │
└────┴───────────┴───────────┴─────────┴──────────────┴───────────────────────────────────────────────────────────────────────┴──────────────────┴────────────┴───────────────┴──────────────────────┴────────────────────────────────────────┴─────────┴───────────────┴────────────────┴───────────────┴──────────────────┴────────┴──────┴───────────┴─────────────────┴──────────────────┴─────────────────────────┴─────────────────────────┘
APP SETTINGS
1. SharedPreferencesProvider canWrite=true
┌────────────────────────────┬───────┐
│ Setting │ Value │
├────────────────────────────┼───────┤
│ battery_optimization │ true │
│ distrust_system_certs │ false │
│ foreground_service │ false │
│ hint_OpenTasksNotInstalled │ false │
└────────────────────────────┴───────┘
2. DefaultsProvider canWrite=false
┌────────────────────────────────┬────────────────────────────────────────────────┐
│ Setting │ Value │
├────────────────────────────────┼────────────────────────────────────────────────┤
│ default_sync_interval │ 14400 │
│ distrust_system_certs │ false │
│ force_read_only_addressbooks │ false │
│ ignore_vpns │ true │
│ preselect_collections │ 0 │
│ preselect_collections_excluded │ /z-app-generated--contactsinteraction--recent/ │
│ proxy_host │ localhost │
│ proxy_port │ 9050 │
│ proxy_type │ -1 │
└────────────────────────────────┴────────────────────────────────────────────────┘
--- END DEBUG INFO ---
Hi @JarlMorgennebel
This is interesting. The client sends a lastoccurence id that is out of the integer bounds that the calendar table can manage. Basically, it's too far in the future (It's the "Year 2038 problem") :)
I'll issue a fix soon
Could you try to checkout https://github.com/tchapi/davis/pull/186, do the migrate, and see if it solves your problem?
Hej @tchapi,
I am using the prebuilt images only, as they work fine with DockGE as Docker Management together. I have never tested DockGE with Docker built commands... This may require some time...
Hi @JarlMorgennebel
I just launched an edge build with this branch, so you can test it →
docker pull ghcr.io/tchapi/davis-standalone:edge@sha256:da81316e1badf3a5d29782890093cb87ec019612139e86466abea0b21efb2bc7
I'll close this down now as stale, and since 5.1.3 will be released soon, containing the very probable fix.