Android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)

DAVx⁵
Log in to reply
  • A

    I have (had) a similar issue.
    Running CM 11-20141124-NIGHTLY-ks01lte (Galaxy S4 i9506-ks01lte) as client
    ownCloud 7.0.3 as host.

    This was happening also with previous nightlies, so is not related to this particular ROM version.
    The contact has been created days ago, so it was trying and retrying every time.

    I’ve found out the contact causing the issue, was the one just before the error in the logs.

    Here’s the contact VCF (I’ve removed all the jpeg encoding and replaced data) as in logs:

    D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "BEGIN:VCARD[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "VERSION:3.0[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "UID:177ae5e6-ae0c-4ace-8c53-28564b0d6365[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "FN:Name Surname[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "N:Surname;Name;;;[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "TEL;TYPE=work:111[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "TEL;TYPE=work:+11 111 111 111[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "ORG:XX XXX[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "CATEGORIES:XX XXX[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "PHOTO;ENCODING=b;TYPE=jpeg:/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAgGBgcGBQgHBwcJ[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << " tAEsIBiBNasSjyk/3RWVB/qVrQQny15PQUAf/9k=[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "PRODID:DAVdroid/0.6.7.1 (ez-vcard/0.9.6)[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "REV:2014-11-18T14:02:13+00:00[\r][\n]"
D/ch.boye.httpclientandroidlib.wire( 7161): http-outgoing-0 << "END:VCARD[\r][\n]"

    and here’s the error just after the vcard:

    W/dalvikvm( 7161): VFY: unable to find class referenced in signature (Lorg/jsoup/nodes/Element;)
I/dalvikvm( 7161): Could not find method org.jsoup.nodes.Element.getElementsByTag, referenced from method ezvcard.io.scribe.SoundScribe._parseHtml
W/dalvikvm( 7161): VFY: unable to resolve virtual method 23158: Lorg/jsoup/nodes/Element;.getElementsByTag (Ljava/lang/String;)Lorg/jsoup/select/Elements;
D/dalvikvm( 7161): VFY: replacing opcode 0x6e at 0x002bI/davdroid.SyncManager( 7161): Updating 177ae5e6-ae0c-4ace-8c53-28564b0d6365.vcf
D/davdroid.LocalCollection( 7161): Committing 8 operations
W/ContactsDatabaseHelper( 1030): invalidateAllCache: [ContactsDatabaseHelper]
E/DatabaseUtils( 1030): Writing exception to parcel
E/DatabaseUtils( 1030): android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)
E/DatabaseUtils( 1030): 	at android.database.sqlite.SQLiteConnection.nativeExecute(Native Method)
E/DatabaseUtils( 1030): 	at android.database.sqlite.SQLiteConnection.execute(SQLiteConnection.java:555)
E/DatabaseUtils( 1030): 	at android.database.sqlite.SQLiteSession.execute(SQLiteSession.java:619)
E/DatabaseUtils( 1030): 	at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:44)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.aggregation.ContactAggregator.updatePinned(ContactAggregator.java:2373)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.ContactsProvider2.updateRawContact(ContactsProvider2.java:4596)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.ContactsProvider2.updateRawContacts(ContactsProvider2.java:4504)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.ContactsProvider2.updateInTransaction(ContactsProvider2.java:4157)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.AbstractContactsProvider.update(AbstractContactsProvider.java:166)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.ContactsProvider2.update(ContactsProvider2.java:2320)
E/DatabaseUtils( 1030): 	at android.content.ContentProviderOperation.apply(ContentProviderOperation.java:225)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.AbstractContactsProvider.applyBatch(AbstractContactsProvider.java:237)
E/DatabaseUtils( 1030): 	at com.android.providers.contacts.ContactsProvider2.applyBatch(ContactsProvider2.java:2432)
E/DatabaseUtils( 1030): 	at android.content.ContentProvider$Transport.applyBatch(ContentProvider.java:260)
E/DatabaseUtils( 1030): 	at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:192)
E/DatabaseUtils( 1030): 	at android.os.Binder.execTransact(Binder.java:404)
E/DatabaseUtils( 1030): 	at dalvik.system.NativeStart.run(Native Method)
D/davdroid.DavSyncAdapter( 7161): Server supports VCard version 3.0
W/dalvikvm( 7161): threadid=13: thread exiting with uncaught exception (group=0x419face0)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
E/AndroidRuntime( 7161): FATAL EXCEPTION: SyncAdapterThread-1
E/AndroidRuntime( 7161): Process: at.bitfire.davdroid:sync, PID: 7161
E/AndroidRuntime( 7161): android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)
E/AndroidRuntime( 7161): 	at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:173)
E/AndroidRuntime( 7161): 	at android.database.DatabaseUtils.readExceptionWithOperationApplicationExceptionFromParcel(DatabaseUtils.java:160)
E/AndroidRuntime( 7161): 	at android.content.ContentProviderProxy.applyBatch(ContentProviderNative.java:519)
E/AndroidRuntime( 7161): 	at android.content.ContentProviderClient.applyBatch(ContentProviderClient.java:377)
E/AndroidRuntime( 7161): 	at at.bitfire.davdroid.resource.LocalCollection.commit(LocalCollection.java:311)
E/AndroidRuntime( 7161): 	at at.bitfire.davdroid.resource.LocalAddressBook.commit(LocalAddressBook.java:148)
E/AndroidRuntime( 7161): 	at at.bitfire.davdroid.syncadapter.SyncManager.pullChanged(SyncManager.java:208)
E/AndroidRuntime( 7161): 	at at.bitfire.davdroid.syncadapter.SyncManager.synchronize(SyncManager.java:89)
E/AndroidRuntime( 7161): 	at at.bitfire.davdroid.syncadapter.DavSyncAdapter.onPerformSync(DavSyncAdapter.java:134)
E/AndroidRuntime( 7161): 	at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:259)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
D/davdroid.WebDavResource( 7161): Using preemptive authentication (not compatible with Digest auth)
D/davdroid.DavSyncAdapter( 7161): Closing httpClient

    Edit: Changed ` to ```

    0
  • A

    I removed this contact from the remote server (owncloud), and now the sync works again:

    BEGIN:VCARD
VERSION:3.0
UID:16af2088-313c-4582-b882-052fc4b58535
FN:Wiedenplatzer Keller
N:;Wiedenplatzer Keller;;;
TEL;TYPE=work:0473673280
PHOTO;ENCODING=b;TYPE=jpeg:/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAIBAQEBAQIBAQEC
 AgICAgQDAgICAgUEBAMEBgUGBgYFBgYGBwkIBgcJBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2w
 BDAQICAgICAgUDAwUKBwYHCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoK
 CgoKCgoKCgoKCgr/wAARCABgAGADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAw
 QFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0Kx
 wRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3
 R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW
 19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQ
 oL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAV
 YnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eH
 l6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna
 4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDxn/glf4G1H4x/8E+bXQrbb5lprswtZJ
 ZF2xt5Nv8ALuaRWVdq/L96vkj/AIKy6VdWWm6Ks8ChrfVrhWlC/NJ8g/i7079jHwRq+j/APTPF
 Ev7tLzVb2J/m/wCecdu3+7/y0Wqf/BTG4N98LPC8ySsyx6jMrbV+78h+9XzkqsZ5rSgd2Cw9Wj
 ltecpc3MeV/sdaVDeQXF1NDu3XWzK/eX5a+odA8OwWzzxqjSj7BMuG/wB2vnX9hgL/AGbd7Cxb
 7f8ALtTd/wAs6+qtMk3RG4UdbWZXZl/2a+UzuUaWcSlI+kyXDRq5QzzbTw2gyPNfQyKG7bfl+7
 8tdT8Mvh9o/wAY/ET+EJdbWwkj2lmZN21W3Lu2/wAX/Aam8SafZNoxa5vllZ4l/clf9laofADw
 9pXiT4lr4Tk8mO5ubWSK1uLjbsjk3RsrL/u7d3/AaKNR/Wecqqqn1WUYy5TofFv7NPjXQ7q48H
 WmnQyyabfzTrKrKq3cLNH5c0a7t3zLHu+ba1eQ3GhTRXE2IG3D7o/u7a+nPhdpaN4l/sPWtSjt
 Nc0fVpIFu7V9qmNV/wBdIq/89Nv/AI61eL+N7lNc+IupXemqsVtI7OoU5/u16EPaxpyl9k4qEu
 Z8kjkLazhj0O7mvFbYqtu2p/DtrX8OabDD4Wt5Ujb50arviK0Y+F7lfLyHXbtVfvVpxaSll4ct
 rSBNuIvmrnfvSR6NCi4/CeV/F7wrL4q0ePwtprbJ9UvYbeKRv7zSKvzVtHwxDpvwl0+xY7o0lk
 WLaq/N83zNVT4syyaK+m6jZ6g0E9tfq8cyru2sv8XzV3XiXSFX4LeH53lkaWdbp9sibdu2T5a+
 gwsIqhFnhY6Hsq0pyLv7L1xp2pfsuaXpEiTG9tdcuntf7skbQwq27+637lf++q4P/gpDp8UnwH
 8KX1j9y41m4Z2b5fuqy16b+xXpf2z9neCwlulcw6jM3yn5fux//FVwn/BRjSpdQ+CGjW0G5jb+
 KNkW3/ajkZq5qVaSzCHN9k6qdCUMur/4TyT9iGOeSyvVteWe8RgFHzD93/er6w0gWmq6WDbXO2
 aBGaaNTt3L/la87/Y4/Ya+MHgn4ej4m3+q6fNZ30NveDT7dmaeONl/iVlX/wAdZv8A4r3DVtAh
 s7p4pY4xMtvuV4/4l27vlrwOJqGIpZkp1PdjL4T1OHcRRrZZyQ+KJ5f4se5luQtxb7YvK65rA8
 Kp/ZfjbTtesdZjtLiG9V98iNtXa3zbtv8ADt3V6TrWi6fq8JS4kbbH8qx1nab4W0hNLupJBDJu
 fdtb+H71efSrSpz5melPDwlGUZHZ+PPjH4X8FeG9W8Q+E4rW78U65brFPLYxfLb7WP7yORf7ys
 3y/erwjwle3az7b2DdPKiruk/irsZ5bHRtOkhMCjevJVtu2ubtbXTriZLuym2zQNuy38Ve/hMR
 Sqw5ZfCfP1sPVw9T3S94wcWvh9lmiVN6bv8A0GvQ/CHwO+JHxA+G9x4+8J+FPtel6fZNLdSrOq
 sqqr7vlb5v4Wry34rX00mlATDKqv8ACPlr9Bf2B5/h7pnwQKPrVrNI2nRrLDNIqtukklX+833v
 96vX4ayennGKlGcvhjI8viDOq+UYWFSEfelI/Lz9qK5udNtbC3ht8GS4ZkLPt3LuXbXsnjyG3t
 PgV4eTzsyLa3Tbtn95nb/P1rjP2+fCMlv40nb+xprO1h1y4+ypcRtH92ZvlX/vmuv+KP8Ao/wZ
 0XRycyR2tx2+79+tI0nhKssPU+zIqUvrkI1ZfDKPMaf7D11Lp/7PVqYLVTK2qTM/mL8q/u46y/
 23r3wl4V8HaDqHiKzV7Sz8X2UsiRp/0znZt33ty1e/Yr8TaPrPwyFl4SuLi80/7fI32i8t1jl8
 zau5fLXcu3/aqj+3H8MPF/xn+HaeGvB2jtfXg1y0lMH8Mcax3CszM3yqvzferzqNOSx8P8UT1q
 PJHKq8pfZifSvw7+Knwk8Ofs6DxZoHjXTbzGl72sNnlPCy+Wqx7W+9/rP/AB2vGfB/xO074oXN
 /qNnqCveQ2txb+RtZlX7y/Kv+8v3v4a8R8GaZ8Qfgz8FdF8EeLreW31WDXNVe4jV1lZY/LsFVd
 y/w7vM+WrP7NniC5XUdSvru+khuGRWj3JtZWWb/wDZr1OLarxVZKrHl9nE8PhCP1WjUq0v+Xkj
 1FoPENjqA0+90uYMPl+X5lb71TXtldx2s22BkAdlapbL4n+OYpXt7bxqxR/mljba27/e3LS6f4
 x1yaV21C9t50D7hD5Sq27/AHlr4H2OF9pzcx9xy4v+U5HxFZX7Wjr5eRH8rt/wKue0zT79NzLb
 Nxyh/vLXpfiPxhbS2kyXWg28pl2s8f8Ae2/71crceJrpCbe30S3VW+TbIVb/AL5r14UqVbD8sJ
 Hn1/bxnzSic58VluR4Zjlkl+aRNor0X4GeJfE+j6BrOtaH4mvLa2tNDVjHDLt3f6RCq/w/w5Zv
 +A1wni66vfFemzaHLp2GjRlia3j/ANWyt83y/wDAf4q6r4cQSWPhLWNKmlYOvhybzQw+9tZZP+
 Bfdrtws8RgcValL3uU5a8KGYYeUJx+E8Z/af8Ain4y+JPinRrTW/Ed1eQtKzbLidn+6wbd838W
 77zfxV6l4u1GTU9Ds9NhhkuJIbObz/8AZ+9Xi/xKtLB/HuloWUqnnbo9n3f71epfFRr21sbKS0
 vZkRLeTmP5vvMtd+FqVazjKrL3jzq+DpU6XJS92JmfsE+Ip/DvwPt72GXG2+mWT/vmOvSvEvxb
 i8LWumeK70bLVvEdpBcvIWZVhberfd/4FXcftR/s9fBD9l7V7X4f/A/wdNpOk3Vkt41pNqU123
 nM0qs3mTMzfwr/ABV4v8dtKN78GrkWL+W8Or2zw/7275dtRGbhm9OX96J0YeHtMlxEZfyyO4/b
 D+HkXhHxPbw2XiGHUf7R01dTAjj2+Qtxs8td275m2x14/wDCi6vPCHiLV7U3DPZNEzRecm/+Ld
 8rV6TeaV4l1HwtqM3ijTLqKfQNO0DTYZZl+Wa1h0u9aT5l/i/0Vvl/2l3bax/AGkG+kmuriwUM
 8UjSr/db+Ja9XjFfV8w9vP4ah4nCClWyzkpfFTMvTvibYR3ciRzwsd3zqysu2rkPjW5mnFzCFS
 H+Bo23f+zVR8W6ZbXOpSyR22C3yNt/2azf+EFMWnyXDwMvz7vu18aqdCfuo+zpYuvGXvHQDxfB
 cXnmXU/+r+VP1rtP2bW8MeMNY1PwvrtrbmRYoLqzkki3M3l/LJGv93+9/wABrx3W/CsSKptpVY
 iJXO2Rl+apfhpJ4q8JeIbPxXo+uzLLb3Uc8TKv3WjYsrf8BZVb/gNejljoYPFe0mcWYc9fDyjz
 Hs3x/wDDvhz4ZeIdbsbHUo7bULOXzIo2T5Z4ZFLf+OqytXPeC55rzR/tLTq8mp2F1AP+/cv/AM
 TWd+2PPq3i741aQL7TLy8tfFejaZeR2Gnptl2yQrtjWT/ZZWX/AIDXtPin9g34w/s/aFoHjPVI
 LiLSNV1K0sorDUN32mzmZn+Vvl27ZNu5fmr6vMMpeNq1MXhYx5af/gXLL/8AZPkMtzeOX8mHxU
 veqfD/AIo//tRPi/XbDUbj4t2EDSMy/ZWf/f3bq9g+JmgWggi0uXxAsBiikZI23fN/FXn2pWd1
 pnxzGn+dte1g27f4fmYr/wCgrXafGW/tp9akj01/3KS/KWrwKPuVowifQOpJUZc59Gftot/wk3
 i+1vLmVi4tY1T/AGVaSX5Vrxj4sadNB8OriGNfNe2v7Z4k27vMbzPlVl/75r079onVHn1aPyUb
 K2sbfMn92aSuP8RzQW/hvWdVmgYrbWrXsp+9/q1ZqmemMTLwb5sDKP8ANE3/ANkrX/H3j/8AZy
 8ba9rngDTbrT4dbtryS4W5j2p5nmrcyMzSfK3+rj8v+7My15T8M9XbT2vIbkK7LLt81l+Zm+bd
 u+avD/2MfG/jnS9L8e2uk3EhsF0yJrmJP9Vua5ihVv8Avpvlr1LwNPfWtiiW5bzY0jXa3zN8q7
 f7v+zXpcVYqNbD0Iy+z9o8rhHDyw1XEuPw8x1Ph7S4dT8cfZ5rtY4ZLra0kyblG6uz8SeAjc6b
 e2WpN/Z9zb3kdrA/m7YmZlZvu7f4l27drf7Vdp8CvhveWGo21h4LsLe61bxLapFLFaz+fFG23z
 Gafd81sy/e2/dk27f4a+vfhd8C/h58EvBkb3GlR6jdsqwXeotGsks33l8za33VVv4V27Vr5nhb
 hjOuOJ1K+HnGlQp+77SX8392JzcS8WYPInyyj7Sp/LE/Nn4h/CWfQ9NvNY0/W4buG1dbdTMPIa
 aRceZ5atuZlXd97+KuZ8NRwjT4IUu8zNLtXb/Fu3Lt/wDHq+1v2sv2ZvhlrcV58aPAljHLDZxL
 Lr+jQtI7XCtI+2ZYVbb8v7xmj+7t3N/D83zr8b/D2o6peL4lsrbT4bXb8rWe6NWj3Ff3a/8ALS
 OP7vmfd+b71c+d5RmHC2YQy7Hv2kanNKNT4Y+7/X8x6fD2fYLPsLzw92X2oyGfE/TPDHxNg8I6
 14e8R3EGs6JpC2F7brG3ytHcSzRsrL/daRlX/Zr9FvhF8VvB/wC2v+xrD4h8ZtDaarpsqtdW+7
 d9nvrWR9rKzL/FHHu/2d1fmH8GvHk/hrx5eatb2sd0bOwmlhikbasknzruVq6X9nfSfjTqnxYf
 S/hbYx3Npqs+2Wz+3NH5DfxXDKq/Mq7W/wC+q/VOFM6pRhzTj/Ejy8v/AKSfI8UZHJw9pGX8GU
 ZRl/6UeX+LdLs3/ak8RaV9sxs1GZMK27G2a4+Vf++aPFrXk19JC8ysPN3M38Vd/wDtCfAHxT+z
 5+1/MfFOv6fef24kms2a6fP5jeTM10y+Z/zzb/Z/2lrznxDrkkmtX1naWjIhT7397rXhYqjGnj
 qkPtcx7GFryxGXQn9mUYnsfiT4j6/8RLe51e/8GNpd1YyyWclvJe+fv2/Msit5ca7WZqb441KF
 PhZ4shkeMtL4N1D/AFat97yW+b/x1a7bWtMs9R0S4ezCkGVtzf3m5rzb4tacuj/DHxJI3Wfwze
 R7f+2b/wDxVeZUpwhi7xPoIR9nheU8E/YSS3T4afFDS40U3VxZaYsW35m8v7Yrf+hLH/47/er2
 T9nPwfqnjDXbi2kh+0JYyxy3HlxrujXzPvMu5fl/vV4D+wj4qSxvfGPh2JV+06ppFssEjN8sbL
 fW7bv/AB3/AMer6f8AhLZ618Pob7xTb6lJcX0iKkT2u5Uh+Zvl3RxtuVvl3blrw/EGvUo5ZCNP
 4pR5f+3uY8zIqnsY11/ePsb9i/wJZ+IRqvxF8ReH4ZRHew2diJIvMXdDHG0kkfmbmXczbdu7+G
 vafF/hy61TSQlrOscsNvIhWaNpfN/i+b/gSsu7/ppu/utXP/s5aDeeGPhJoFhq5zeSaXDcXb7f
 laaRfMZvur/E237v8Nd0ZHa2dG+UMu089a/o7gfI8Pw9w1QwFP7MeaUv5pS94/Bc+zJZnm1Su5
 f4f8J5D8Mdc8bW3iS/8H/EjwMtnp2pWUcWk6pCY5YLyONWVvM2rutmZf4W+VvMZfm+avlv4+eC
 rH4da1rnwgm8SeW+lq32O5kmZWu4ZFaaGNtqtu3K2394yqrQsv8Aer7p8PS/2ddXeiXd9zG++F
 tnyrH823/0HbXyr/wVF+Ellc6/oXjnTtcsbFrqKa3uzePjz/LZmj/2d22SvA8R+G6We8Px/npy
 5uY93gXNYYDO/Zv+HKP/AJMfGnw60a5fXvEmrOrGLT9LVp4tm1f3l0se3d/s+Z/C38VdM3jvxH
 8IzZ6/oGp3VnqVt/pEZt5mjaNv4drL/wCPU/RdDPw7tfFNvqjxyR6poyy28tq+5W8u8t5GX/e2
 qzf8Brm/2gtdt9b8Wazd2DsIo08vy/4V2xsvy/8AAt1fmscNLA5dSq/a5j9fwmKhj8XUoTjzR5
 TjdI+NfxC+PHx31L4g/EDX7i9ul8xJZGnZ1jXa+3/ZVaGuWvJLyeC583y/ldkbLVzn7NdtJND4
 k1CS3ydy7Bn/AGnal0XVb19av7GGVUUyrGsjfd/3qdL97iva1Jc0jKtTp0aXsqXuxif/2Q==
PRODID:DAVdroid/0.6.6 (ez-vcard/0.9.6)
REV:2014-11-10T18:42:47+00:00
END:VCARD
    0
  • rfc2822
    developer

    @chiisama: Can you provide steps to reproduce this issue and/or verbose logs? We don’t know whats the reason or how to reproduce it, so we can’t fix the problem.

    0
  • A

    Not easy to know what is the relevant data, but I will try 😄

    V/davdroid.URIUtils(  342): Normalized URL /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/6e4cad71-9eb0-4b74-90a2-da5b422e47a5.vcf -> /owncloud/remo
te.php/carddav/addressbooks/dominik/kontakte/6e4cad71-9eb0-4b74-90a2-da5b422e47a5.vcf
D/davdroid.WebDavResource(  342): Processing multi-status element: https://chii.selfhost.eu/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/6e4cad71-9
eb0-4b74-90a2-da5b422e47a5.vcf
V/davdroid.URIUtils(  342): Normalized URL /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/940b9f55-6690-45c9-9519-53d486edd4d7.vcf -> /owncloud/remo
te.php/carddav/addressbooks/dominik/kontakte/940b9f55-6690-45c9-9519-53d486edd4d7.vcf
D/davdroid.WebDavResource(  342): Processing multi-status element: https://chii.selfhost.eu/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/940b9f55-6
690-45c9-9519-53d486edd4d7.vcf
V/davdroid.URIUtils(  342): Normalized URL /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/d00ef02c-2d3e-4ad8-adfb-303764077bd8.vcf -> /owncloud/remo
te.php/carddav/addressbooks/dominik/kontakte/d00ef02c-2d3e-4ad8-adfb-303764077bd8.vcf
D/davdroid.WebDavResource(  342): Processing multi-status element: https://chii.selfhost.eu/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/d00ef02c-2
d3e-4ad8-adfb-303764077bd8.vcf
D/Wire    (  342): http-outgoing-1 << "[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "0[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "[\r][\n]"
D/HttpClient(  342): Connection [id: 1][route: HttpRoute[{s}->https://chii.selfhost.eu:443]] can be kept alive for 5.0 seconds
D/HttpClient(  342): Connection released: [id: 1][route: HttpRoute[{s}->https://chii.selfhost.eu:443]][total kept alive: 1; route allocated: 1 of 2; total alloc
ated: 1 of 3]
D/dalvikvm( 1838): JIT code cache reset in 0 ms (4096 bytes 2/0)
I/davdroid.SyncManager(  342): Fetching 0 new remote resource(s)
I/davdroid.SyncManager(  342): Fetching 2 updated remote resource(s)
I/davdroid.RemoteCollection(  342): Multi-getting 2 remote resource(s)
D/HttpClient(  342): Connection request: [route: HttpRoute[{s}->https://chii.selfhost.eu:443]][total kept alive: 1; route allocated: 1 of 2; total allocated: 1
of 3]
D/HttpClient(  342): Connection leased: [id: 1][route: HttpRoute[{s}->https://chii.selfhost.eu:443]][total kept alive: 0; route allocated: 1 of 2; total allocat
ed: 1 of 3]
D/HttpClient(  342): Executing request REPORT /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ HTTP/1.1
D/HttpClient(  342): Target auth state: SUCCESS
D/HttpClient(  342): Proxy auth state: UNCHALLENGED
D/Wire    (  342): http-outgoing-1 >> "REPORT /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ HTTP/1.1[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Content-Type: text/xml; charset=UTF-8[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Accept: text/xml[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Depth: 1[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Content-Length: 402[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Host: chii.selfhost.eu[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Connection: Keep-Alive[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "User-Agent: DAVdroid/0.6.12[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "Authorization: Basic ********************=[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "[\r][\n]"
D/Wire    (  342): http-outgoing-1 >> "<CD:addressbook-multiget xmlns:CD="urn:ietf:params:xml:ns:carddav" xmlns="DAV:">[\n]"
D/Wire    (  342): http-outgoing-1 >> "   <prop>[\n]"
D/Wire    (  342): http-outgoing-1 >> "      <CD:address-data/>[\n]"
D/Wire    (  342): http-outgoing-1 >> "      <getetag/>[\n]"
D/Wire    (  342): http-outgoing-1 >> "   </prop>[\n]"
D/Wire    (  342): http-outgoing-1 >> "   <href>/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ad021c2e-04a6-4b6a-9f58-18f270eff72f.vcf</href>[\n]"
D/Wire    (  342): http-outgoing-1 >> "   <href>/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/C60F1998-1D70-0001-6A66-341315401F95.vcf</href>[\n]"
D/Wire    (  342): http-outgoing-1 >> "</CD:addressbook-multiget>"
D/Wire    (  342): http-outgoing-1 << "HTTP/1.1 207 Multi-Status[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Date: Thu, 19 Feb 2015 08:41:52 GMT[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Server: Apache/2.2.22 (Debian)[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "X-Powered-By: PHP/5.4.36-0+deb7u3[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Set-Cookie: oc020f2df3d3=4kh4l1rnd6a3h9rlba57c0bhj2; path=/owncloud; HttpOnly[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Expires: Thu, 19 Nov 1981 08:52:00 GMT[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Cache-Control: private, max-age=10800, pre-check=10800[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Last-Modified: Sat, 07 Feb 2015 02:31:55 GMT[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Strict-Transport-Security: max-age=31536000[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "X-XSS-Protection: 1; mode=block[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "X-Content-Type-Options: nosniff[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "X-Frame-Options: Sameorigin[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Content-Security-Policy: default-src 'self'; script-src 'self' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; frame-src
 *; img-src *; font-src 'self' data:; media-src *; connect-src *[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "X-Robots-Tag: none[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Set-Cookie: oc020f2df3d3=5kqm9bciocuphp5acmg6bv9dc2; path=/owncloud; secure; HttpOnly[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Vary: Brief,Prefer[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Content-Length: 1343[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Keep-Alive: timeout=5, max=99[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Connection: Keep-Alive[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "Content-Type: application/xml; charset=utf-8[\r][\n]"
D/Wire    (  342): http-outgoing-1 << "[\r][\n]"
D/HttpClient(  342): Connection can be kept alive for 5000 MILLISECONDS
D/Wire    (  342): http-outgoing-1 << "<?xml version="1.0" encoding="utf-8"?>[\n]"
D/Wire    (  342): http-outgoing-1 << "<d:multistatus xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns" xmlns:card="urn:ietf:params:xml:ns:carddav"><d:response><d
:href>/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ad021c2e-04a6-4b6a-9f58-18f270eff72f.vcf</d:href><d:propstat><d:prop><card:address-data>BEGIN:V
CARD&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "VERSION:3.0&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "UID:ad021c2e-04a6-4b6a-9f58-18f270eff72f&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "FN:Seetec&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "N:;Seetec;;;&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "TEL;TYPE=home:+49 7251 92900&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "ORG:Seetec AG&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "PRODID:DAVdroid/0.6.10.1 (ez-vcard/0.9.6)&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "REV:2015-01-11T12:32:58+00:00&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "END:VCARD&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "</card:address-data><d:getetag>"cef99d344aa304dc9e2655e17218a6cb"</d:getetag></d:prop><d:status>HTTP/1.1 200 OK</d:status
></d:propstat></d:response><d:response><d:href>/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/C60F1998-1D70-0001-6A66-341315401F95.vcf</d:href><d:pr
opstat><d:prop><card:address-data>BEGIN:VCARD&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "VERSION:3.0&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "X-MOZILLA-HTML:FALSE&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "UID:C60F1998-1F80-0001-18C7-1A4064409470&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "FN:Bengali Ottenau&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "N:;Bengali Ottenau;;;&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "TEL;TYPE=work:0049722574552&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "PRODID:DAVdroid/0.6.10.1 (ez-vcard/0.9.6)&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "REV:2015-01-11T12:32:57+00:00&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "END:VCARD&#13;[\n]"
D/Wire    (  342): http-outgoing-1 << "</card:address-data><d:getetag>"b3e261391d18799d0f505a68cc4b2c88"</d:getetag></d:prop><d:status>HTTP/1.1 200 OK</d:status
></d:propstat></d:response></d:multistatus>[\n]"
V/davdroid.URIUtils(  342): Normalized URL /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ad021c2e-04a6-4b6a-9f58-18f270eff72f.vcf -> /owncloud/remo
te.php/carddav/addressbooks/dominik/kontakte/ad021c2e-04a6-4b6a-9f58-18f270eff72f.vcf
D/davdroid.WebDavResource(  342): Processing multi-status element: https://chii.selfhost.eu/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/ad021c2e-0
4a6-4b6a-9f58-18f270eff72f.vcf
V/davdroid.URIUtils(  342): Normalized URL /owncloud/remote.php/carddav/addressbooks/dominik/kontakte/C60F1998-1D70-0001-6A66-341315401F95.vcf -> /owncloud/remo
te.php/carddav/addressbooks/dominik/kontakte/C60F1998-1D70-0001-6A66-341315401F95.vcf
D/davdroid.WebDavResource(  342): Processing multi-status element: https://chii.selfhost.eu/owncloud/remote.php/carddav/addressbooks/dominik/kontakte/C60F1998-1
D70-0001-6A66-341315401F95.vcf
D/HttpClient(  342): Connection [id: 1][route: HttpRoute[{s}->https://chii.selfhost.eu:443]] can be kept alive for 5.0 seconds
D/HttpClient(  342): Connection released: [id: 1][route: HttpRoute[{s}->https://chii.selfhost.eu:443]][total kept alive: 1; route allocated: 1 of 2; total alloc
ated: 1 of 3]
I/davdroid.SyncManager(  342): Updating ad021c2e-04a6-4b6a-9f58-18f270eff72f.vcf
D/davdroid.LocalCollection(  342): Committing 5 operations
W/ContactsDatabaseHelper( 1838): invalidateAllCache: [ContactsDatabaseHelper]
E/DatabaseUtils( 1838): Writing exception to parcel
E/DatabaseUtils( 1838): android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)
E/DatabaseUtils( 1838):         at android.database.sqlite.SQLiteConnection.nativeExecute(Native Method)
E/DatabaseUtils( 1838):         at android.database.sqlite.SQLiteConnection.execute(SQLiteConnection.java:555)
E/DatabaseUtils( 1838):         at android.database.sqlite.SQLiteSession.execute(SQLiteSession.java:619)
E/DatabaseUtils( 1838):         at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:44)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.aggregation.ContactAggregator.updatePinned(ContactAggregator.java:2373)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.ContactsProvider2.updateRawContact(ContactsProvider2.java:4414)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.ContactsProvider2.updateRawContacts(ContactsProvider2.java:4322)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.ContactsProvider2.updateInTransaction(ContactsProvider2.java:3975)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.AbstractContactsProvider.update(AbstractContactsProvider.java:166)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.ContactsProvider2.update(ContactsProvider2.java:2138)
E/DatabaseUtils( 1838):         at android.content.ContentProviderOperation.apply(ContentProviderOperation.java:225)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.AbstractContactsProvider.applyBatch(AbstractContactsProvider.java:237)
E/DatabaseUtils( 1838):         at com.android.providers.contacts.ContactsProvider2.applyBatch(ContactsProvider2.java:2250)
E/DatabaseUtils( 1838):         at android.content.ContentProvider$Transport.applyBatch(ContentProvider.java:260)
E/DatabaseUtils( 1838):         at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:192)
E/DatabaseUtils( 1838):         at android.os.Binder.execTransact(Binder.java:404)
E/DatabaseUtils( 1838):         at dalvik.system.NativeStart.run(Native Method)
W/dalvikvm(  342): threadid=13: thread exiting with uncaught exception (group=0x41946ce0)
D/davdroid.DavSyncAdapter(  342): Closing httpClient
E/AndroidRuntime(  342): FATAL EXCEPTION: SyncAdapterThread-1
E/AndroidRuntime(  342): Process: at.bitfire.davdroid:sync, PID: 342
E/AndroidRuntime(  342): android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)
E/AndroidRuntime(  342):        at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:173)
E/AndroidRuntime(  342):        at android.database.DatabaseUtils.readExceptionWithOperationApplicationExceptionFromParcel(DatabaseUtils.java:160)
E/AndroidRuntime(  342):        at android.content.ContentProviderProxy.applyBatch(ContentProviderNative.java:519)
E/AndroidRuntime(  342):        at android.content.ContentProviderClient.applyBatch(ContentProviderClient.java:377)
E/AndroidRuntime(  342):        at at.bitfire.davdroid.resource.LocalCollection.commit(LocalCollection.java:312)
E/AndroidRuntime(  342):        at at.bitfire.davdroid.resource.LocalAddressBook.commit(LocalAddressBook.java:148)
E/AndroidRuntime(  342):        at at.bitfire.davdroid.syncadapter.SyncManager.pullChanged(SyncManager.java:210)
E/AndroidRuntime(  342):        at at.bitfire.davdroid.syncadapter.SyncManager.synchronize(SyncManager.java:91)
E/AndroidRuntime(  342):        at at.bitfire.davdroid.syncadapter.DavSyncAdapter.onPerformSync(DavSyncAdapter.java:144)
E/AndroidRuntime(  342):        at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:259)
D/HttpClient(  342): Connection manager is shutting down
D/HttpClient(  342): http-outgoing-1: Close connection
D/HttpClient(  342): http-outgoing-1: Close connection
D/HttpClient(  342): Connection manager shut down
    0
  • A

    Do you need more/other logs ?
    Maybe I can give you access to my smartphone for one or two evenings (ssh/linux, windows teamviewer VM with USB connected smartphone, ) if this can help.

    Greetings

    0
  • rfc2822
    developer

    Still no idea what the reason could be.

    @S2- @chiisama Which exact Android version do you use? The stock version (of which brand)? CyanogenMod?

    At the moment, I guess this is an issue with a few manufacturer-adapted Android versions.

    0
  • A

    i’m on cyanogenmod. latest stable.
    deleting the contact that generated the error and recreating it solved the problem for me. it never happened again.

    0
  • A

    Cyanogenmod last 11-20141115-SNAPSHOT-M12-i9300 (4.4.4)
    S2 - How you now which one cause the error ?

    0
  • A

    @chiisama i watched the logs with adb while syncing, and the last one that appeared before the exception was the guilty one.

    0
  • A

    The last one was Bengali Ottenau in the log above. Deleting this does not help.
    I removed the carddav account in davdroid and readded it. Error gone.
    The only thing that I did that may can corrupt the database is the SDMaid app.
    This app has the option to “optimize” the database. I tried to reproduce the error running sdmaid again but no problem wiht davdroid yet.

    0
  • A

    This bug just hit me and was gone after deleting the affected contact from the server. I believe i triggered the issue by adding the contact first and moving it into a contacts group using the ownCloud webinterface later after syncing.

    0
  • A

    I’m having the same issue with Alcatel 5038D stock rom, DAVdroid 0.7.2.

    0
  • A

    I fixed the problem starring the contact and syncing. Then I can unstar it and it syncs OK from now on.

    0
  • rfc2822
    developer

    And again with 0.7.5 (from Play Store):

    Moto X (ghost) with Android 4.4:

    android.database.sqlite.SQLiteConstraintException: contacts.pinned may not be NULL (code 19)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:173)
at android.database.DatabaseUtils.readExceptionWithOperationApplicationExceptionFromParcel(DatabaseUtils.java:160)
at android.content.ContentProviderProxy.applyBatch(ContentProviderNative.java:512)
at android.content.ContentProviderClient.applyBatch(ContentProviderClient.java:377)
at at.bitfire.davdroid.resource.LocalCollection.commit(LocalCollection.java:327)
at at.bitfire.davdroid.resource.LocalAddressBook.commit(LocalAddressBook.java:156)
at at.bitfire.davdroid.syncadapter.SyncManager.pullChanged(SyncManager.java:210)
at at.bitfire.davdroid.syncadapter.SyncManager.synchronize(SyncManager.java:91)
at at.bitfire.davdroid.syncadapter.DavSyncAdapter.onPerformSync(DavSyncAdapter.java:146)
at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:259)
    0
  • rfc2822
    developer

    According to https://github.com/android/platform_packages_providers_contactsprovider/blob/android-5.1.1_r4/src/com/android/providers/contacts/ContactsDatabaseHelper.java#L1213, the RawContact’s PINNED is always DEFAULT unpinned, so there should be no need to set it explicitly.

    0

Similar topics