can't sync Baikal calendar [solved]

[EJ van Lanen]

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 ---

[rfc2822]

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?

[EJ van Lanen]

That did it! Thanks!