After mysql upgrade to 5.1.45 akonadi can't start: akonadictl restart outputs many of following errors: [akonadiserver] Database error: Cannot open database. [akonadiserver] Last driver error: "QMYSQL: Unable to connect" [akonadiserver] Last database error: "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/)" [akonadiserver] Character set 'utf8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file because of that many KDE features not work Reproducible: Always Steps to Reproduce: 1. emerge -1av mysql 2. akonadictl restart Actual Results: [akonadiserver] Database error: Cannot open database. [akonadiserver] Last driver error: "QMYSQL: Unable to connect" [akonadiserver] Last database error: "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/)" [akonadiserver] Character set 'utf8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file $ emerge --info dev-db/mysql x11-libs/qt-sql app-office/akonadi-server Portage 2.2_rc67 (default/linux/amd64/10.0/desktop, gcc-4.4.3, glibc-2.11-r1, 2.6.33-zen1 x86_64) ================================================================= System Settings ================================================================= System uname: Linux-2.6.33-zen1-x86_64-Intel-R-_Core-TM-2_Duo_CPU_T5550_@_1.83GHz-with-gentoo-2.0.1 Timestamp of tree: Fri, 26 Mar 2010 12:45:01 +0000 app-shells/bash: 4.1_p2-r1 dev-java/java-config: 2.1.10 dev-lang/python: 2.6.5-r1, 3.1.2-r1 dev-util/cmake: 2.8.1 sys-apps/baselayout: 2.0.1 sys-apps/openrc: 0.6.1-r1 sys-apps/sandbox: 2.2 sys-devel/autoconf: 2.13, 2.65 sys-devel/automake: 1.8.5-r3, 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1 sys-devel/gcc: 4.4.3 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b virtual/os-headers: 2.6.33 ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="* -@EULA PUEL dlj-1.1 skype-eula" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -march=native -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c" CXXFLAGS="-O2 -march=native -pipe" DISTDIR="/var/portage/distfiles" FEATURES="assume-digests collision-protect distlocks fixpackages news nostrip parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://de-mirror.org/distro/gentoo/ http://gentoo.mneisen.org/ http://gentoo.tiscali.nl/" LANG="uk_UA.UTF-8" LDFLAGS="-Wl,-O1,--hash-style=both" LINGUAS="ru uk eo en de" MAKEOPTS="-j2" PKGDIR="/var/portage/packages" PORTAGE_COMPRESS="lzma" PORTAGE_COMPRESS_FLAGS="--best" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/var/portage" PORTDIR_OVERLAY="/var/repositories/mpd /var/repositories/sunrise /var/repositories/qting-edge /var/repositories/kde /var/repositories/emacs /var/repositories/science /var/repositories/otih /var/repositories/rion /var/repositories/my" SYNC="rsync://rsync1.de.gentoo.org/gentoo-portage" USE="X a52 aac acl acpi alsa amd64 apache2 avahi bash-completion berkdb bittorrent bluetooth branding bzip2 cairo cdr cleartype cli consolekit cracklib crypt cups curl cxx dbus djvu dri dts dv dvd dvdr emacs emboss encode evo exif exiv2 expat fam fbcon fbsplash ffmpeg firefox firefox3 flac fontconfig fortran freetype fuse gdbm gif gimp git gnome gnuplot gnutls gphoto2 gpm gstreamer gtk hal iconv inotify ipv6 ipw3945 java java5 java6 jingle joystick jpeg jpeg2k kde kde4 kdehiddenvisibility kerberos kipi kpathsea laptop lastfm latex lcms ldap libnotify lirc lm_sensors lmsensors logrotate lzma lzo mad matroska mikmod mmap mmx mng modules moznopango mp3 mp4 mpeg mudflap multilib musicbrainz nautilus ncurses networkmanager newspr nls nptl nptlonly nsplugin ogg ogm openexr opengl openmp paludis pam pch pcre pdf perl phonon plasma png policykit ppds pppd python qml qt3support qt4 quicktime rcc readline reflection samba sdl semantic-desktop session slp social-desktop spell spl sse sse2 sse3 ssl ssse3 stable-branch startup-notification svg symlink sysfs syslog system-sqlite tcpd tetex threads thumbnail thunar tiff tk truetype udev unicode usb utemper v4l v4l2 vdpau vhosts vim-syntax vorbis webkit wifi wmf x264 xattr xcb xcomposite xft xine xinetd xml xmp xorg xscreensaver xulrunner xv xvid zeroconf zlib" ALSA_CARDS="intel-hda" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="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 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" CAMERAS="canon sony fuji" ELIBC="glibc" INPUT_DEVICES="evdev joystick keyboard mouse synaptics wacom" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="ru uk eo en de" LIRC_DEVICES="wpc8769l" RUBY_TARGETS="ruby18" SANE_BACKENDS="snapscan" USERLAND="GNU" VIDEO_CARDS="v4l vesa nvidia nv nouveau" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_RSYNC_EXTRA_OPTS ================================================================= Package Settings ================================================================= dev-db/mysql-5.1.45-r1 was built with the following: USE="big-tables community extraengine (multilib) perl ssl -cluster -debug -embedded -latin1 -max-idx-128 -minimal -pbxt -profiling (-selinux) -static -test" CFLAGS="-O2 -march=native -pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing" CXXFLAGS="-O2 -march=native -pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing" x11-libs/qt-sql-4.6.2 was built with the following: USE="exceptions iconv (multilib) mysql pch postgres qt3support sqlite (-aqua) -debug (-firebird) -odbc" app-office/akonadi-server-1.3.1 was built with the following: USE="(multilib) mysql postgres sqlite"
Same here: Portage 2.2_rc67 (default/linux/x86/10.0/desktop, gcc-4.4.3, glibc-2.11-r1, 2.6.33.1 i686) ================================================================= System uname: Linux-2.6.33.1-i686-Intel-R-_Core-TM-2_Duo_CPU_P8400_@_2.26GHz-with-gentoo-2.0.1 Timestamp of tree: Tue, 30 Mar 2010 20:30:01 +0000 app-shells/bash: 4.1_p2-r1 dev-java/java-config: 2.1.10 dev-lang/python: 2.6.5, 3.1.2-r1 dev-util/cmake: 2.8.1 sys-apps/baselayout: 2.0.1 sys-apps/openrc: 0.6.1-r1 sys-apps/sandbox: 2.2 sys-devel/autoconf: 2.13, 2.65 sys-devel/automake: 1.8.5-r3, 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1 sys-devel/gcc: 4.4.3 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b virtual/os-headers: 2.6.33 ACCEPT_KEYWORDS="x86 ~x86" ACCEPT_LICENSE="* -@EULA" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=native -mtune=native -O2 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo" CXXFLAGS="-march=native -mtune=native -O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests distlocks fixpackages news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://de-mirror.org/distro/gentoo/ " LANG="it_IT.utf8" LC_ALL="it_IT.utf8" LDFLAGS="-Wl,-O1" LINGUAS="it en" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/overlay" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="3dnow 3dnowext 3dnowprefetch X a52 aac aalib acl acpi aim alsa apache2 ares asf ati audio audiofile avahi bash-completion berkdb bidi bl bluetooth branding bri bzip2 cairo cdda cdparanoia cdr cjk cli consolekit cracklib crypt cups curl cxx dba dbus device-mapper dga directfb divx divx4linux dri dts dv dvb dvd dvdr dvdread edl emboss encode ethereal exif expat faad fam fame fbcon ffmpeg fftw firefox flac force-cgi-redirect fortran ftp garmin gd gdbm gif gimp gmedia gmp gnutls gphoto2 gpm gps gsm gtk h264 h323 hal iconv icq idn ifp ilbc imagemagick imap innodb ipod ipv6 ithreads jabber jack java javascript joystick jpeg kde kontact kvm lastfm lcms ldap libcaca libnotify live lm_sensors lua lzo mad maildir mbox mdnsresponder-compat mhash mikmod mime mjpeg mmap mmx mmxext mng modules mozdevelop mozilla mp3 mp4 mpeg msn mtp mudflap mysql ncurses nepomuk network new-hpcups nfsv4 njb nls nptl nptlonly nsplugin offensive ofx ogg oggvorbis openal openexr opengl openmp oscar pam pango pcre pdf perl phonon php plasma plotutils png ppds pppd python qt3support qt4 readline reflection rtc ruby samba sasl sdl semantic-desktop session sha512 sip slang slp sndfile snmp sox speex spell spl sse sse2 ssh ssl ssse3 startup-notification svg symlink sysfs tcltk tcpd theora threads tiff tk tremor truetype udev unicode usb utempter v4l v4l2 vcd vhosts video videos vim-syntax vorbis wav webkit wifi win32codecs wmf wmp wxwindows x264 x86 xanim xcb xface xft xine xinerama xml xorg xosd xpm xscreensaver xsl xulrunner xv xvid xvmc yahoo zlib zpm" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="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 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" ELIBC="glibc" INPUT_DEVICES="evdev synaptics" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="it en" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="vesa radeonhd radeon" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS mysql: Installed versions: 5.1.45-r1[1](01:33:39 25/03/2010)(community embedded extraengine perl ssl kde-base/akonadi-4.4.1
maybe this issue could be related to the following bugs? http://bugs.kde.org/226960 http://bugs.mysql.com/bug.php?id=45058
Did I understand correctly from MySQL Bugzilla that http://bugs.mysql.com/bug.php?id=45058 was fixed in 5.1.44? While this issue looks like starts from 5.1.45
(In reply to comment #3) > Did I understand correctly from MySQL Bugzilla that > http://bugs.mysql.com/bug.php?id=45058 was fixed in 5.1.44? While this issue > looks like starts from 5.1.45 Indeed it appears they broke it again. I'm masking 5.1.45* on my local system and re-emerging 5.1.44-r3.
Confirmed: downgrading to MySQL 5.1.44-r3 allows Akonadi to work perfectly again.
(In reply to comment #5) > Confirmed: downgrading to MySQL 5.1.44-r3 allows Akonadi to work perfectly > again. > Same problem here, same solution helps.
This affects more than just akonadi. The 5.1.45-r1 upgrade breaks media-tv/mythtv also; the same character set errors are logged in /var/log/mythtv/mythfrontend.log. Downgrading to 5.1.44-r3 resolves the issue. 5.1.45-r1 should be masked. It's broken.
(In reply to comment #6) > (In reply to comment #5) > > Confirmed: downgrading to MySQL 5.1.44-r3 allows Akonadi to work perfectly > > again. > > > > Same problem here, same solution helps. > It's now broke in 5.1.44-r3 too. Maybe the mysql.eclass has been changed to avoid building utf8 character sets??
For me the issue has vanished with the new 5.1.46 mysql that includes the fix ot this bug : http://bugs.mysql.com/bug.php?id=45058
Is this fixed with current stable mysql-5.1.50-r1 ?
(In reply to comment #10) > Is this fixed with current stable mysql-5.1.50-r1 ? Even though the double-checked locking bug may not be completely fixed upstream, all versions of MySQL since 5.1.46 have worked with akonadi-server for me.
OK, declaring this resolved then. Thanks!
