For some reason none of my google contacts are syncing, and none of them are showing up in Kaddressbook or Kontact. Unfortunately I don't have much debug info here, but I've tried removing and readding my google account in PIM settings, but no dice. Any ideas? I'm running Arch with the most updated versions of KDE.

What the installed version of "libkgapi"? Do you have version 1 or version 2 installed (or both)?

einar wrote:What the installed version of "libkgapi"? Do you have version 1 or version 2 installed (or both)?

2.0.1-1

OK, time for some debugging:

- Run "kdebugdialog" and uncheck "Disable all debug output".
- Click on "Deselect all"
- Search, using the search form at top for "libkgapi" and click on the checkmark for iibkgapi that will appear
- Search again for "akonadi_google_contacts" and activate the checkmark too
- Click on OK
- Open a console window like Konsole or Yakuake and issue "akonadictl restart".
- Paste all the output here (via pastebin if it is too long).

Once you're done debugging, restart kdebugdialog and check again "Disable all debug output".

einar wrote:OK, time for some debugging:

- Run "kdebugdialog" and uncheck "Disable all debug output".
- Click on "Deselect all"
- Search, using the search form at top for "libkgapi" and click on the checkmark for iibkgapi that will appear
- Search again for "akonadi_google_contacts" and activate the checkmark too
- Click on OK
- Open a console window like Konsole or Yakuake and issue "akonadictl restart".
- Paste all the output here (via pastebin if it is too long).

Once you're done debugging, restart kdebugdialog and check again "Disable all debug output".

Sorry about the delay in my response here, I hadn't seen that you replied. Anyway, here is the debug output.

Code: Select all

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[ben@ben ~]$ search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/bin", "/usr/bin/core_perl", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK                                                                 
mysql.user                                         OK                                                                 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)               
search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/bin", "/usr/bin/core_perl")                               
search paths:  ("/home/ben/.kde4/lib/kde4/plugins/", "/usr/lib/kde4/plugins/", "/usr/lib/qt4/plugins", "/usr/bin", "/usr/lib/kde4/plugins", "/home/ben/.kde4/lib/kde4/", "/usr/lib/kde4/")                                                 
search paths:  ("/home/ben/.kde4/lib/kde4/plugins/", "/usr/lib/kde4/plugins/", "/usr/lib/qt4/plugins", "/usr/bin", "/usr/lib/kde4/plugins", "/home/ben/.kde4/lib/kde4/", "/usr/lib/kde4/")                                                 
search paths:  ("/home/ben/.kde4/lib/kde4/plugins/", "/usr/lib/kde4/plugins/", "/usr/lib/qt4/plugins", "/usr/bin", "/usr/lib/kde4/plugins", "/home/ben/.kde4/lib/kde4/", "/usr/lib/kde4/")                                                 
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )                                                                               
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )                                                 
akonadi_googlecontacts_resource_13(21807) GoogleResource::slotAccountManagerReady: true                               
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )                                                             
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )                               
akonadi_nepomuk_feeder(21813) FeederPluginloader::feederPluginsForMimeType: No feeder for type  "text/calendar"  found                                                                                                                     
akonadi_nepomuk_feeder(21813) FeederPluginloader::feederPluginsForMimeType: No feeder for type  "text/x-vnd.akonadi.socialnotification"  found                                                                                             
akonadi_nepomuk_feeder(21813) FeederPluginloader::feederPluginsForMimeType: No feeder for type  "text/x-vnd.akonadi.socialfeeditem"  found                                                                                                 
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )                                                       
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Unauthorized. Access token has expired or is invalid.                                                                                             
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:                                         
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://accounts.google.com/o/oauth2/token" )                                                                                                 
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://accounts.google.com/o/oauth2/token" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Unauthorized. Access token has expired or is invalid.
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecontacts_resource_13(21807) GoogleResource::handleError: KGAPI2::ContactsGroupFetchJob(0x284a910) "Invalid authentication."
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://accounts.google.com/o/oauth2/token" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://accounts.google.com/o/oauth2/token" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://accounts.google.com/o/oauth2/token" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://accounts.google.com/o/oauth2/token" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecontacts_resource_13(21807) GoogleResource::slotAuthJobFinished:
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.google.com/m8/feeds/groups/benjamindaines@gmail.com/full?alt=json" )
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecontacts_resource_13(21807)/LibKGAPI KGAPI2::Job::emitFinished:
Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)" :  "Duplicate entry '293-Starred in Android' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/calendar/v3/users/me/calendarList" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/tasks/v1/users/@me/lists" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/tasks/v1/users/@me/lists" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/tasks/v1/users/@me/lists" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/calendar/v3/calendars/8kteu84flo9msauvu9vdtnob4k@group.calendar.google.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/calendar/v3/calendars/8kteu84flo9msauvu9vdtnob4k@group.calendar.google.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/calendar/v3/calendars/8kteu84flo9msauvu9vdtnob4k@group.calendar.google.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MDow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MDow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MDow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MTE4ODYyMDMzODow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MTE4ODYyMDMzODow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/tasks/v1/lists/MDI5MzkyMTYzMzMwOTI4NjIwMzQ6MTE4ODYyMDMzODow/tasks?showDeleted=true&showCompleted=true&updatedMin=2013-12-03T08:42:01Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://www.googleapis.com/calendar/v3/calendars/benjamindaines@gmail.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_dispatchTimeout: Dispatching request to  QUrl( "https://www.googleapis.com/calendar/v3/calendars/benjamindaines@gmail.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.googleapis.com/calendar/v3/calendars/benjamindaines@gmail.com/events?maxResults=20&showDeleted=true&updatedMin=2013-12-03T08:42:01Z&timeMin=2010-01-01T05:00:00Z" )
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: 0 requests in requestQueue.
akonadi_googlecalendar_resource_4(21806)/LibKGAPI KGAPI2::Job::emitFinished:


I'm seeing a bunch of tokens expired with the contacts, but I have removed and readded the account in PIM settings (gone though the google login screen), but hasn't changed anything. Is there a local config file I should nuke?

EDIT:
I deleted and readded the resource again, but this time noticed "Akonadi Google Contacts Resource" (hadn't seen it in the list before) and it works. However, the calendar version doesn't work. Calendars only work from the entry with the google logo. Here's what I mean:

It looks like you have two different resources installed. Can you check through your package manager if you have something like "akonadi-googledata" installed?

Hi and sorry to hijack this topic,

I have the same problem since a few days or week), I tried to troubleshoot it and it seems we have the same problems. I think the root of the problem is :

Code: Select all

Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6)" :  "Duplicate entry '394-Starred in Android' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"

(this comes to my own debug output, but there is the same message in the previous post).

I looked in the akonadi console DB Browser and in collection table I cannot find the entry '394-Starred in Android'. Even if I could find it, how can i delete it?

In the debug output, some other strange things is that the google contacts resources is number 7 and I get this :

Code: Select all

akonadi_googlecontacts_resource_7(2378)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Received reply from  QUrl( "https://www.google.com/m8/feeds/groups/XXXXXX@gmail.com/full?alt=json" )
akonadi_googlecontacts_resource_7(2378)/LibKGAPI KGAPI2::Job::Private::_k_replyReceived: Unauthorized. Access token has expired or is invalid.
akonadi_googlecontacts_resource_7(2378)/LibKGAPI KGAPI2::Job::emitFinished:
akonadi_googlecontacts_resource_7(2378) GoogleResource::handleError: KGAPI2::ContactsGroupFetchJob(0x1758080) "Invalid authentication."
akonadi_googlecontacts_resource_7(2378)/LibKGAPI KGAPI2::Job::enqueueRequest: Queued  QUrl( "https://accounts.google.com/o/oauth2/token" )

Am I not authentified? How can I reset the authentication, I will try to forget it on google, but calendars are working...

Thanks for any help, and I hope it is the same problem as the other user and that it will solve both our problem.