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



  • 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
    

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



  • 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
    


  • 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


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



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



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



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



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



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



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



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


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

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


 

Maybe you're interested in these topics?