recurring 10 min invalid query dialog box from google contact sync

[jim galley]

Binary package hint: evolution

Address book:
Name: first last
checked:
 use in birthday & anniversaries calendar
 copy book content locally for offline operation
 autocomplete with this address book

Server
 username - <email address hidden>
  use ssl checked
 refresh 100 minutes

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: evolution 2.32.2-0ubuntu7
ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2
Uname: Linux 2.6.38-8-generic x86_64
NonfreeKernelModules: fglrx
Architecture: amd64
Date: Fri Apr 15 16:56:58 2011
EcryptfsInUse: Yes
ExecutablePath: /usr/bin/evolution
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
ProcEnviron:
 SHELL=/bin/bash
 LANGUAGE=en_US:en
 LANG=en_US.UTF-8
SourcePackage: evolution
UpgradeStatus: Upgraded to natty on 2011-04-11 (4 days ago)

[jim galley (jim-galley)]

Also throws 2 dialog boxes "unable to perform search. The backend for this address book was unable to parse this query. Invalid query [ok]" when composing email.

[jim galley (jim-galley)]

And this one.
"Unable to perform search.
This query did not complete successfully. Cannot connect to the service's server. [ok]"

[jim galley (jim-galley)]

Really? No response to this problem? I have evo running on 10.10 32bit ubuntu laptop connecting to the SAME google account without problems. This bug is making it difficult to use evo since the (2/4) dialog boxes stop everything.

[Mathieu Trudel-Lapierre (cyphermox)]

By now all you should be getting for error messages should be "Cannot connect to service's server", if it shows up. Is Evolution marked as working online? (Make sure the Work Offline checkbox is unchecked in the File menu).

Past that, we'll need to completely stop evolution (In a terminal: evolution --force-shutdown ; killall -9 e-addressbook-factory), then start the addressbook factory in debug mode (again, in a terminal):

LIBGDATA_DEBUG=1 /usr/lib/evolution/e-addressbook-factory --debug

And start evolution again.

Carefully check the messages that show up in the terminal window running e-addressbook-factory, the last message or so (or one before a big bunch of data), should contain the reason why the addressbook fails to start properly.

[jim galley (jim-galley)]

Thanks for responding.

Evolution is marked as working online.

Current error when going to the google address book (click contacts, click google address book) is:
====
Unable to open address book
This address book cannot be opened. This either means that an incorrect URI was entered, or the server is unreachable.
Detailed error message: Cannot authenticate user: Invalid query
====

Not many messages returned with debug enabled.

shutdown evolution & followed instructions:
=======
jimg@box:~$ evolution --force-shutdown ; killall -9 e-addressbook-factory
Could not find Evolution's process ID
jimg@box:~$ LIBGDATA_DEBUG=1 /usr/lib/evolution/e-addressbook-factory --debug
e-data-server-Message: adding type `EBookBackendWebdavFactory'
e-data-server-Message: adding type `EBookBackendCouchDBFactory'
e-data-server-Message: adding type `EBookBackendLDAPFactory'
e-data-server-Message: adding type `EBookBackendGroupwiseFactory'
e-data-server-Message: adding type `EBookBackendGoogleFactory'
e-data-server-Message: adding type `EBookBackendGalFactory'
e-data-server-Message: adding type `EBookBackendExchangeFactory'
e-data-server-Message: adding type `EBookBackendVCFFactory'
e-data-server-Message: adding type `EBookBackendFileFactory'
Server is up and running...
** (e-addressbook-factory:29722): DEBUG: Creating cache at /home/jimg/.cache/evolution/addressbook/couchdb___127.0.0.1/http://127.0.0.1:49374/cache.xml
book_view file uref
============
Couldn't find evo's ID since I already closed it. confirmed on top.
opened evo, navigated to contacts, got the google error as described above.
navigated to two other phonebooks - no problems.

Deleted the google book
Recreated google book
created account WITHOUT a period in username (was <email address hidden>, tried <email address hidden>)
got an auth screen (haven't seen that for a while) entered password, then got same error.
Also removed SSL to try (no luck)

[Mathieu Trudel-Lapierre (cyphermox)]

Ah, oops. I actually meant "LIBGDATA_DEBUG=3", not 1.

Again, you need to fully stop evolution and e-addressbook-factory first, then start the factory with LIBGDATA_DEBUG=3; then start evolution. The logs there (which will also contain private data, so be careful), would contain the cause for the crash. Normally you'd only need to paste here the last few messages.

Note: your account name needs to match exactly with what you'd enter to log in to Google, so if there is a dot, you need to have it there too; otherwise it's a different account, and it won't work ;)

[jim galley (jim-galley)]

ok - ran with Debug = 3:

Got the dialog box
====
Unable to open address book

This address book cannot be opened. This either means that an incorrect URI was entered, or the server is unreachable.

Detailed error message: Cannot authenticate user: Invalid query
====
ok - here's the debug info - much of it contact info.

Relevant snips.
login setup
--------------------------------
(e-addressbook-factory:32433): libgdata-DEBUG: > POST /accounts/ClientLogin HTTP/1.1
(e-addressbook-factory:32433): libgdata-DEBUG: > Soup-Debug-Timestamp: 1303847148
(e-addressbook-factory:32433): libgdata-DEBUG: > Soup-Debug: SoupSessionSync 1 (0x1184030), SoupMessage 1 (0x1191050), SoupSocket 1 (0x11555a0)
(e-addressbook-factory:32433): libgdata-DEBUG: > Host: www.google.com
(e-addressbook-factory:32433): libgdata-DEBUG: > Content-Type: application/x-www-form-urlencoded
(e-addressbook-factory:32433): libgdata-DEBUG: >
(e-addressbook-factory:32433): libgdata-DEBUG: > accountType=HOSTED%5FOR%5FGOOGLE&Email=FIRSTNAME%2ELASTNAME%40gmail%2Ecom&Passwd=SOMETHING-GOES-HERE&service=cp&source=evolution%2Dclient%2D0%2E1%2E0
(e-addressbook-factory:32433): libgdata-DEBUG:
(e-addressbook-factory:32433): libgdata-DEBUG: < HTTP/1.1 200 OK
(e-addressbook-factory:32433): libgdata-DEBUG: < Soup-Debug-Timestamp: 1303847148
(e-addressbook-factory:32433): libgdata-DEBUG: < Soup-Debug: SoupMessage 1 (0x1191050)
(e-addressbook-factory:32433): libgdata-DEBUG: < Content-Type: text/plain
(e-addressbook-factory:32433): libgdata-DEBUG: < Cache-control: no-cache, no-store
(e-addressbook-factory:32433): libgdata-DEBUG: < Pragma: no-cache
(e-addressbook-factory:32433): libgdata-DEBUG: < Expires: Mon, 01-Jan-1990 00:00:00 GMT
(e-addressbook-factory:32433): libgdata-DEBUG: < Date: Tue, 26 Apr 2011 19:45:45 GMT
(e-addressbook-factory:32433): libgdata-DEBUG: < X-Content-Type-Options: nosniff
(e-addressbook-factory:32433): libgdata-DEBUG: < X-XSS-Protection: 1; mode=block
(e-addressbook-factory:32433): libgdata-DEBUG: < Content-Length: 881
(e-addressbook-factory:32433): libgdata-DEBUG: < Server: GSE
(e-addressbook-factory:32433): libgdata-DEBUG: <
(e-addressbook-factory:32433): libgdata-DEBUG: < SID=DQAAAMgAAADu90nSXqegA68boqKvUeHqTMg9emY1CVpkgmNrwJHdlX67O_SxwocNl_6wXiltmY3FWeMZhk9YMYPUYrw5eYuCkuPi2eNMDYn9ERZPhzfl9ECgIfCsUpHNpzIT3S8JRv89jUQw49wp7SS1EzGMbnVCbwb9hRUkAT2NDLKGQzw1cSmbs4uu1EAl_xexVhghNsRXPGkSVKnXBAx8BTnyDdprDvm8YVk-O-Mm3A_ktvRY9G2I_0ayfUf4IbBqs7ynwGbabuTJyOhDhvtpz6v5gqbB
(e-addressbook-factory:32433): libgdata-DEBUG: < LSID=DQAAAMsAAAAKoKvNYWQf-aDTObY4q1Xq3jCXP4Az2pvMKTYfheUsuWIe5zBQssEvutRWc2aigq87xjYavTg9eJZcf_cI7MSpdGQPx8zkLxS0X359FqrWA7h1kwPmO9vUgdVtJ3wFXVljmPPJwzBDZIe2EOgq0fD3UHK3YR2giIkXynjw6L8LkhRCTHw7wDHFswy539CspUJrKGY9uKWIQuMXLWzqfqxHFf9qQLXlzP_l5UjlbFlp0C0icXIM3u6OSc8E-LxkaCxoQ6set8NUh8KTGK37fs0l
(e-addressbook-factory:32433): libgdata-DEBUG: < Auth=DQAAAMIAAACfuyCSSpnU3hFEjotuaIOf2z3pw2MPTC0gKiUQ7Dopm01juY-cU4xz2Bw3bP_7OZ4GgAypXMf-KkygeoQctieEdNwuv4sG0NHh0FhQuarGcsXlAKUm52fwD1gpzUAIdA8A63te92RwIE_63_HSptaojx8CdGsffn4cY-IF65YdZBwzh2szu-5f63-HpByR7J_R6Bqwmd-g5oDOwMEhpfjAoUqtMNGdvAEGVUAZS8yPUyjjwaqNm--wMiyB_6jm8VXgQ5MokTE6y7KXK5-_t0SU
(e-addressbook-factory:32433): libgda...

[jim galley (jim-galley)]

are we anywhere with this? any other info i can provide?

I've now upgraded 2 other boxes (portables - both 32bit) that didn't have a problem syncing contacts with google before AND now do.

[Gil Ramirez (gramirez)]

I'm having the exact same problem. Ran the same debug and got essentially the same output. Perhaps it has something to do with the number of contacts?

As an aside, I own two android devices and both sync fine.

[BeowulfOF (beowulfof)]

Thats odd, my android device does not sync with evolution contacts correctly. Changes made on my android phone are synced to evolution, but a new contact in evolution is not synced to my android device.

[iMac (imac-netstatz)]

The error messages described above are consistent with this bug, https://bugs.launchpad.net/ubuntu/+source/evolution-data-server/+bug/755043

[philinux (philcb)]

Same here. Natty clean 64 bit install.

Unable to perform search.

This query did not complete successfully. Cannot connect to the service's server.

Calendar and contacts do appear to be syncing though. Contacts seems more variable.

[iMac (imac-netstatz)]

With my "temporary" small address book that is my workaround for the query/timeout error in #755043 I periodically get the attached message "Unable to perform search". I consider this a separate bug, but possibly related.

[Michael Seifert (michseif)]

Following this tracker for a while, I know have found a solution that works for me. I found the problem using the libgdata debug described above, but with Evolution 3 and libgdata 0.8.1. Thus, Evolution it put a more conclusive error message which led me to this:

https://bugzilla.gnome.org/show_bug.cgi?id=648058

Maybe that's also your problem. As described there, you could either wait for libgdata 0.8.2 being released. As a workaround, you could instead delete or label all user-defined fields in your Google contacts.

I did not know which of my contacts have such fields, and using the Google web interface to find it out is obviously very inconvenient. Instead, I started libgdata in debug mode (see above), wrote stdout to a logfile and searched this file for the term "user". With this method, I quickly found all the contacts containing user-defined fields and deleted those fields (if unlabeled). After that, syncing works well again (also with Evo 2.32 and libgdata 0.8.0 as installed with Natty).

[iMac (imac-netstatz)]

Michael's comment lead me to resolve this by removing the custom fields with empty labels. https://bugs.launchpad.net/ubuntu/+source/evolution-data-server/+bug/755043/comments/16.

This resolved all of the other error messages except for this one: https://bugs.launchpad.net/ubuntu/+source/evolution/+bug/762187/+attachment/2127045/+files/Unable_To_Search.png

Unable to perform search.
This query did not complete successfully. Cannot connect to the service's server.

I am currently using libgdata11 0.8.1-1 from oneiric and experiencing this issue.

[Chronos (chronos00)]

Why was this bug report marked as incomplete?
What information is it missing?

I can also reproduce this problem. What information can I provide?

[iMac (imac-netstatz)]

This is resolved for me in current 12.04 Beta 3.2.3ubuntu3 EDS

[Jörg Frings-Fürst (jff-de)]

11.04 is not longer supported
change status to invalid