Typing something in the search box in Clementine results in nothing happening for about 10 seconds, and then the GUI freezing for about half a minute before the search is performed. This only happens when >=dev-db/sqlite-3.8 is installed. Downgrading to dev-db/sqlite-3.7 fixes the problem and Clementine's search becomes instant again with zero delay. Upstream mentions that this is a packaging bug: https://code.google.com/p/clementine-player/issues/detail?id=3847 Reproducible: Always Steps to Reproduce: 1. Upgrade to >=dev-db/sqlite-3.8 2. Run Clementine and make sure it has a music library configured. 3. Type something in the search box. Actual Results: Big delay, long GUI freeze. Expected Results: Search results should show up instantly without any delay. Portage 2.2.6 (default/linux/amd64/13.0/desktop/kde, gcc-4.7.3, glibc-2.17, 3.10.12-gentoo x86_64) ================================================================= System uname: Linux-3.10.12-gentoo-x86_64-Intel-R-_Core-TM-_i5-2500K_CPU_@_3.30GHz-with-gentoo-2.2 KiB Mem: 16386932 total, 12308876 free KiB Swap: 25166844 total, 25166844 free Timestamp of tree: Tue, 17 Sep 2013 16:45:01 +0000 ld GNU ld (GNU Binutils) 2.23.2 app-shells/bash: 4.2_p45 dev-java/java-config: 2.2.0 dev-lang/python: 2.7.5-r2, 3.2.5-r2, 3.3.2-r2 dev-util/cmake: 2.8.11.2 dev-util/pkgconfig: 0.28 sys-apps/baselayout: 2.2 sys-apps/openrc: 0.12 sys-apps/sandbox: 2.6-r1 sys-devel/autoconf: 2.13, 2.69 sys-devel/automake: 1.11.6, 1.12.6 sys-devel/binutils: 2.23.2 sys-devel/gcc: 4.6.4, 4.7.3, 4.8.1 sys-devel/gcc-config: 1.8 sys-devel/libtool: 2.4.2 sys-devel/make: 3.82-r4 sys-kernel/linux-headers: 3.10 (virtual/os-headers) sys-libs/glibc: 2.17 Repositories: gentoo vmware interactive-fiction steam-overlay Local ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="*" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-pipe -mtune=native -march=native -O2 -fomit-frame-pointer -floop-interchange -floop-strip-mine -floop-block" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/config /usr/share/gnupg/qualified.txt /usr/share/themes/oxygen-gtk/gtk-2.0 /usr/share/themes/oxygen-gtk/gtk-3.0" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-pipe -mtune=native -march=native -O2 -fomit-frame-pointer -floop-interchange -floop-strip-mine -floop-block" DISTDIR="/mnt/Data/portage/distfiles" EMERGE_DEFAULT_OPTS="--quiet-build=n" FCFLAGS="-O2 -pipe" FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync metadata-transfer news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync" FFLAGS="-O2 -pipe" GENTOO_MIRRORS="http://ftp.ntua.gr/pub/linux/gentoo http://mirror.ovh.net/gentoo-distfiles http://distfiles.gentoo.org" LANG="en_US.UTF-8" LDFLAGS="-Wl,--as-needed -Wl,-O1 -Wl,--hash-style=gnu -Wl,--sort-common" MAKEOPTS="-j4" PKGDIR="/mnt/Data/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/var/lib/layman/vmware /var/lib/layman/interactive-fiction /var/lib/layman/steam /usr/local/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="X a52 aac acpi aes-ni alsa amd64 audiofile avx bash-completion branding bzip2 cairo cdr cli consolekit cracklib crypt cxx dbus declarative dri dts dvd dvdr emboss encode exif fam fbcondecor flac gdbm gif gpm gtk iconv ipv6 jpeg kde kipi lcdfilter lcms libnotify libsamplerate lm_sensors mad mmx mmxext mng modules mp3 mp4 mpeg mudflap multilib ncurses nptl nvidia offensive ogg opengl openmp pango pcre pdf pgo phonon plasma png policykit ppds qt4 readline semantic-desktop session spell sse sse2 sse3 sse4 sse4_1 ssl ssse3 startup-notification svg tcpd tiff truetype udev udisks unicode upower usb vdpau vorbis wxwidgets x264 xcb xcomposite xml xv xvid xvmc zlib" ABI_X86="32 64" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" DRACUT_MODULES="plymouth" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="en en_US" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-5" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_2" RUBY_TARGETS="ruby19 ruby18" SANE_BACKENDS="nothing" USERLAND="GNU" VIDEO_CARDS="nvidia" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, USE_PYTHON
Note from Clementine upstream: "Yes - this is a debian packaging bug. They either need to switch STATIC_SQLITE=ON or ensure that the qt4 sqlite plugin is built with all the sqlite3 symbols visible. This is not something we can fix."
Copying the ebuild to my local overlay and changing: -DSTATIC_SQLITE=OFF to: -DSTATIC_SQLITE=ON fixes the problem with sqlite-3.8.
Now the upstream forces STATIC_SQLITE in the lastest code: if(STATIC_SQLITE) message(STATUS "Building static qsqlite plugin") add_subdirectory(3rdparty/qsqlite) include_directories("3rdparty/qsqlite") else() if (NOT I_HATE_MY_USERS) message(FATAL_ERROR "No, really, Clementine needs sqlite to be linked " "statically. If it's not, Clementine won't be able to resolve the " "functions it needs to register full text search support. Search will " "be really slow and users will be unhappy. If you're packaging " "Clementine for a distribution and you really hate your users and want " "them to have a bad time please rerun cmake with -DI_HATE_MY_USERS=ON") else() if (NOT MY_USERS_WILL_SUFFER_BECAUSE_OF_ME) message(FATAL_ERROR "So you really hate your users and you want to " "create a crippled package that doesn't work properly? Please send " "an email to the devs and help us understand why.") endif() endif() endif(STATIC_SQLITE)
Asked clementine devs, would like to know opinions of qt and sqlite package maintainers about missing symbols.
What does "ensure that the qt4 sqlite plugin is built with all the sqlite3 symbols visible" mean? It doesn't make much sense to me... if clementine needs some sqlite3 symbols it should explicitly link against it and use the symbols...
I agree, it sounds like underlinking.
Removing qt@ from CC wrt comment #5 and #6. Please re-add if there's something for us to do.
Upstream moved to github.
I just downgraded my system to 3.7.17 and this fixes things. Wouldn't that be a solution for this problem? Or is there something else that could be done on ebuild level?
(In reply to Richard H. from comment #9) > I just downgraded my system to 3.7.17 and this fixes things. Wouldn't that > be a solution for this problem? Or is there something else that could be > done on ebuild level? This is already fixes in the ebuild. Also, sqlite 3.7.17 isn't even in portage anymore. Are you sure your portage tree is synced and up to date?
(In reply to Nikos Chantziaras from comment #10) > (In reply to Richard H. from comment #9) > > I just downgraded my system to 3.7.17 and this fixes things. Wouldn't that > > be a solution for this problem? Or is there something else that could be > > done on ebuild level? > > This is already fixes in the ebuild. Also, sqlite 3.7.17 isn't even in > portage anymore. Are you sure your portage tree is synced and up to date? Yes, of course :) I pulled the 3.7.17 ebuild from CVS and put it into my overlay. Which ebuild has this fixes? Because the stable 1.1.1 sure does not have them.
(In reply to Richard H. from comment #11) > Yes, of course :) I pulled the 3.7.17 ebuild from CVS and put it into my > overlay. Which ebuild has this fixes? Because the stable 1.1.1 sure does not > have them. 1.2.0, 1.2.1 and 1.2.2 do have the fix.
Confirmed. 1.2.2 does not have this bug anymore (of course only if you don't set system-sqlite USE flag). So maybe the ebuild should get a bump then?
Time to close the bug then, I presume
(In reply to Richard H. from comment #13) > Confirmed. 1.2.2 does not have this bug anymore (of course only if you don't > set system-sqlite USE flag). So maybe the ebuild should get a bump then? If you're not on ~arch, you should file a stable request for 1.2.2. I believe you can do that as a normal user if you need a package from ~arch that fixes a bug.
