I’m unable to sync my Baikal (0.6.1) caldav calendar. The carddav works, and both caldav and carddav are able to sync to my local machine. See debug below.
Any tips?
Thanks.
--- BEGIN DEBUG INFO ---
SYNCHRONIZATION INFO
Account name: email@server.com
Authority: com.android.calendar
EXCEPTION:
android.database.sqlite.SQLiteException: no such column: isPrimary (code 1 SQLITE_ERROR): , while compiling: SELECT originalAllDay, account_type, exrule, mutators, originalInstanceTime, allDay, allowedReminders, rrule, canOrganizerRespond, lastDate, visible, calendar_id, hasExtendedProperties, calendar_access_level, selfAttendeeStatus, allowedAvailability, eventColor_index, isOrganizer, _sync_id, calendar_color_index, _id, guestsCanInviteOthers, allowedAttendeeTypes, dtstart, guestsCanSeeGuests, sync_data9, sync_data8, exdate, sync_data7, sync_data6, sync_data1, description, eventTimezone, availability, title, ownerAccount, sync_data5, sync_data4, sync_data3, sync_data2, duration, lastSynced, guestsCanModify, cal_sync3, rdate, cal_sync2, maxReminders, COALESCE(isPrimary, ownerAccount = account_name) AS isPrimary, cal_sync1, cal_sync10, account_name, cal_sync7, cal_sync6, cal_sync5, cal_sync4, calendar_color, cal_sync9, cal_sync8, dirty, calendar_timezone, accessLevel, eventLocation, hasAlarm, uid2445, deleted, eventColor, organizer, eventStatus, customAppUri, canModifyTimeZone, eventEndTimezone, customAppPackage, original_sync_id, hasAttendeeData, displayColor, dtend, original_id, sync_data10, created_from, calendar_displayName FROM view_events WHERE (account_name='email@server.com' AND account_type='bitfire.at.davdroid' AND ((deleted AND original_id IS NULL) AND calendar_id=?))
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:184)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
at android.content.ContentProviderClient.query(ContentProviderClient.java:195)
at android.content.ContentProviderClient.query(ContentProviderClient.java:177)
at android.content.ContentProviderClient.query(ContentProviderClient.java:167)
at at.bitfire.ical4android.AndroidCalendar.queryEvents(AndroidCalendar.kt:186)
at at.bitfire.davdroid.resource.LocalCalendar.findDeleted(LocalCalendar.kt:110)
at at.bitfire.davdroid.syncadapter.SyncManager.processLocallyDeleted(SyncManager.kt:283)
at at.bitfire.davdroid.syncadapter.SyncManager$performSync$1.invoke(SyncManager.kt:129)
at at.bitfire.davdroid.syncadapter.SyncManager$performSync$1.invoke(SyncManager.kt:57)
at at.bitfire.davdroid.syncadapter.SyncManager.unwrapExceptions(SyncManager.kt:854)
at at.bitfire.davdroid.syncadapter.SyncManager.performSync(SyncManager.kt:116)
at at.bitfire.davdroid.syncadapter.CalendarsSyncAdapterService$CalendarsSyncAdapter.sync(CalendarsSyncAdapterService.kt:61)
at at.bitfire.davdroid.syncadapter.SyncAdapterService$SyncAdapter.onPerformSync(SyncAdapterService.kt:122)
at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:334)
SOFTWARE INFORMATION
* at.bitfire.davdroid 2.6.4-ose (331) from org.fdroid.fdroid
* com.android.providers.contacts 3.3.0 (3003000)
* com.android.providers.calendar 3.2.0 (0)
* com.android.contacts 3.3.0 (3003000)
* com.google.android.calendar 2020.08.4-301138406-release (2016531522) from com.android.vending
* org.wikipedia 2.7.50309-r-2020-01-08 (50309) from com.android.vending
CONNECTIVITY (at the moment)
- [ Transports: WIFI Capabilities: NOT_METERED&INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VPN&VALIDATED&NOT_ROAMING&FOREGROUND&NOT_CONGESTED&NOT_SUSPENDED LinkUpBandwidth>=1048576Kbps LinkDnBandwidth>=1048576Kbps SignalStrength: -30]
CONFIGURATION
Power saving disabled: yes
Notifications (not blocked):
[group] sync isBlocked=false
syncProblems: importance=3
syncIoErrors: importance=1
syncWarnings: importance=2
general: importance=3
debug: importance=4
Permissions:
READ_CONTACTS: granted
WRITE_CONTACTS: granted
READ_CALENDAR: granted
WRITE_CALENDAR: granted
READ_TASKS: denied
WRITE_TASKS: denied
ACCESS_COARSE_LOCATION: denied
System-wide synchronization: automatically
ACCOUNTS
Account: email@server.com
Address book sync. interval: 240 min
Calendar sync. interval: 240 min
OpenTasks sync. interval: —
WiFi only: false
[CardDAV] Contact group method: GROUP_VCARDS
[CalDAV] Time range (past days): 90
Manage calendar colors: true
Use event colors: false
Address book account: Default Address Book (email@server.com Ig)
Main account: Account {name=email@server.com, type=bitfire.at.davdroid}
URL: http://dav.server.com/dav.php/addressbooks/xx/default/
Sync automatically: true
SQLITE DUMP
android_metadata
| locale |
| en_US |
----------
service
| id | accountName | type | principal |
| 3 | email@server.com | carddav | http://dav.server.com/dav.php/principals/xx/ |
| 4 | email@server.com | caldav | http://dav.server.com/dav.php/principals/xx/ |
----------
sqlite_sequence
| name | seq |
| service | 4 |
| homeset | 4 |
| collection | 4 |
----------
homeset
| id | serviceId | url | privBind | displayName |
| 3 | 3 | http://dav.server.com/dav.php/addressbooks/xx/ | 1 | <null> |
| 4 | 4 | http://dav.server.com/dav.php/calendars/xx/ | 1 | <null> |
----------
collection
| id | serviceId | type | url | privWriteContent | privUnbind | forceReadOnly | displayName | description | color | timezone | supportsVEVENT | supportsVTODO | supportsVJOURNAL | source | sync |
| 3 | 3 | ADDRESS_BOOK | http://dav.server.com/dav.php/addressbooks/xx/default/ | 1 | 1 | 0 | Default Address Book | Default Address Book for XX | <null> | <null> | <null> | <null> | <null> | <null> | 1 |
| 4 | 4 | CALENDAR | http://dav.server.com/dav.php/calendars/xx/default/ | 1 | 1 | 0 | dav.balibari | dav.balibari | <null> | <null> | 1 | 1 | 0 | <null> | 1 |
----------
room_master_table
| id | identity_hash |
| 42 | a7554d1ebc5ecfe0c7aefe271485d63c |
----------
SYSTEM INFORMATION
Android version: 10 (RMX1931EX_11_C.23)
Device: realme RMX1931 (RMX1931L1)
--- END DEBUG INFO ---
Hi,
Looks like the Android calendar database is corrupt. Can you try Android settings / Apps / System apps / Calendar storage provider / Clear data (will delete all local events on the Android device) and then sync again?
That did it! Thanks!
