symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/libtracker-data.so.0: undefined symbol: sqlite3_bind_pointer

[Karl Kastner]

Just completed a do-release-ugrade from artful to bionic. Now nautilus does not launch any more. Following error message is displayed:

symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/libtracker-data.so.0: undefined symbol: sqlite3_bind_pointer

ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: nautilus 1:3.26.3-0ubuntu4
Uname: Linux 4.15.0-041500rc6-generic x86_64
ApportVersion: 2.20.9-0ubuntu7
Architecture: amd64
CurrentDesktop: GNOME
Date: Thu May 24 17:46:39 2018
InstallationDate: Installed on 2015-11-05 (931 days ago)
InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805)
SourcePackage: nautilus
UpgradeStatus: Upgraded to bionic on 2018-05-24 (0 days ago)
usr_lib_nautilus: dropbox 2015.10.28

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[ME (poyenok)]

I had to uninstall sqlite-autoconf to solve the problem.

[Karl Kastner (kastner-karl)]

The bug still persists. sqlite-autoconf is neither installed on my machine nor contained in the repository. Purging and reinstalling natilus, sqlite and libtracker did not help.

[Sebastien Bacher (seb128)]

Thank you for your bug report, could you give the output of those commands?
- ldd -r /usr/lib/x86_64-linux-gnu/tracker-2.0/libtracker-data.so.0
- dpkg -l | grep sqlite

[Karl Kastner (kastner-karl)]

Output of ldd and dpkg is attached

[Sebastien Bacher (seb128)]

Thanks, the missing symbol is explained by the ldd output

 libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x00007f1d4eca0000)

There is a /usr/local installation which is taking over the Ubuntu one and probably incompatible. Those are usually the result of a manual build/make install. If you clean that file (and maybe others in the same directory) nautilus should work again

[Karl Kastner (kastner-karl)]

Ah, thanks, Nautilus works again after removing /usr/local/lib/libsqlite3.so.0. Wonder where the file in /usr/local/lib came from. It's also strange that the files in /usr/lib and /usr/local lib were identical according to diff.

[Sebastien Bacher (seb128)]

the files were probably not identical, diff works on text content, not on binaries

[Karl Kastner (kastner-karl)]

The file in /usr/lib and /usr/local/lib are both identical. I kept the old one in a separate folder and it has the same sha1sum. But the file in /usr/lib seems to be spurious as well, since it is not associated with any package and variants with newer timestamp of libsqlite3.so.0 persists in /usr/lib/x86_64-linux-gnu/ and /usr/lib/i386-linux-gnu/, Nautilus still works after having moved /usr/lib/ libsqlite3.so.0 into quarantaine as well as well.

diff by the way also works also on binaries, it only echos "binary files differ" for files that differ, instead of printing the actual difference on screen.

Anyway, thanks for the tip to resolve the problem.

[Sebastien Bacher (seb128)]

Oh, right, looks like the one in /usr/lib was also one you installed, as you wrote the package one is being shipped in /usr/lib/x86_64-linux-gnu/