mysql upgrade -> qt connection problems

tikis · 2009-06-16 23:19:50

Hi there!

Today I did a system update and something went wrong. I develop Qt application and the SQL connection doesn't work as it should anymore. Here are the symptoms:

- Connection looks good, never ever a query error.
- Some columns are filled with '0' on UPDATE queries, but not all of them.
- Some special characters doesn't show up right (UTF8 problem?).
- But all of these problems occur only if I try it through my Qt app, if I use the mysql console, all is working.

What happened?

Upgrade mysql from 5.1.34 to 5.1.35 and several other packages... see the log:

[2009-06-16 09:47] synchronizing package lists
[2009-06-16 09:47] starting full system upgrade
[2009-06-16 09:58] upgraded dialog (1.1_20080819-1 -> 1.1_20080819-2)
[2009-06-16 09:58] upgraded alsa-utils (1.0.20-1 -> 1.0.20-2)
[2009-06-16 09:58] upgraded chmlib (0.39-1 -> 0.40-1)
[2009-06-16 09:58] upgraded cln (1.2.2-1 -> 1.2.2-2)
[2009-06-16 09:58] upgraded e2fsprogs (1.41.5-2 -> 1.41.6-1)
[2009-06-16 09:58] upgraded tcp_wrappers (7.6-9 -> 7.6-10)
[2009-06-16 09:58] upgraded portmap (6.0-3 -> 6.0-4)
[2009-06-16 09:58] upgraded fam (2.7.0-11 -> 2.7.0-12)
[2009-06-16 09:58] upgraded mozilla-common (1.3-1 -> 1.4-1)
[2009-06-16 09:58] upgraded nspr (4.7.4-1 -> 4.8-1)
[2009-06-16 09:58] installed mime-types (1.0-2)
[2009-06-16 09:58] upgraded xulrunner (1.9.0.10-1 -> 1.9.0.11-1)
[2009-06-16 09:58] upgraded firefox (3.0.10-1 -> 3.0.11-1)
[2009-06-16 09:58] upgraded firefox-i18n (3.0.10-1 -> 3.0.11-1)
[2009-06-16 09:58] upgraded gconf (2.26.2-1 -> 2.26.2-2)
[2009-06-16 09:58] upgraded glib2 (2.20.2-1 -> 2.20.3-1)
[2009-06-16 09:58] upgraded icu (4.0-2 -> 4.2-1)
[2009-06-16 09:58] upgraded ktorrent (3.2.2-1 -> 3.2.2.1-1)
[2009-06-16 09:58] upgraded lapack (3.2-2 -> 3.2.1-1)
[2009-06-16 09:58] installed xz-utils (4.999.8beta-3)
[2009-06-16 09:58] upgraded libarchive (2.7.0-1 -> 2.7.0-2)
[2009-06-16 09:58] upgraded libdjvu (3.5.21-1 -> 3.5.22-1)
[2009-06-16 09:58] upgraded libidn (1.14-1 -> 1.15-1)
[2009-06-16 09:58] upgraded libmal (0.44-1 -> 0.44.1-1)
[2009-06-16 09:58] upgraded libmsn (4.0beta4-2 -> 4.0beta5-1)
[2009-06-16 09:58] upgraded libmysqlclient (5.1.34-1 -> 5.1.35-1)
[2009-06-16 09:58] upgraded libsasl (2.1.22-8 -> 2.1.23-1)
[2009-06-16 09:58] upgraded libv4l (0.5.9-1 -> 0.5.99-1)
[2009-06-16 09:58] upgraded lua (5.1.4-2 -> 5.1.4-3)
[2009-06-16 09:58] upgraded mysql-clients (5.1.34-1 -> 5.1.35-1)
[2009-06-16 09:58] upgraded mysql (5.1.34-1 -> 5.1.35-1)
[2009-06-16 09:58] * relogin or source /etc/profile.d/openoffice.sh
[2009-06-16 09:58] * see http://wiki.archlinux.org/index.php/Openoffice
[2009-06-16 09:58] how to use extensions, e.g. for spell checking
[2009-06-16 09:58] see /opt/openoffice/share/extension/install what
[2009-06-16 09:58] is shipped with this package
[2009-06-16 09:58] upgraded openoffice-base (3.1.0-1 -> 3.1.0-2)
[2009-06-16 09:58] upgraded pyxml (0.8.4-5 -> 0.8.4-6)
[2009-06-16 10:15] installed dosemu (1.4.0-2)
[2009-06-16 11:01] installed gnome-keyring (2.26.1-1)
[2009-06-16 11:01] installed libgnomeui (2.24.1-1)
[2009-06-16 11:01] installed libgnomecups (0.2.3-4)
[2009-06-16 11:01] installed libgnomeprint (2.18.6-1)
[2009-06-16 11:01] installed perlxml (2.36-1)
[2009-06-16 11:01] installed perl-xml-simple (2.18-2)
[2009-06-16 11:01] installed icon-naming-utils (0.8.90-1)
[2009-06-16 11:01] installed gnome-icon-theme (2.26.0-1)
[2009-06-16 11:01] installed libgnomeprintui (2.18.4-1)
[2009-06-16 11:01] installed ghex (2.22.0-1)

What was I trying?

Remove mysql, libmysqlclient, qt, re-download, re-install, re-compile my software.

On mysql: clean start, rm -rf /var/lib/mysql/*, mysql_install_db --user=mysql, and kick in mysql. Default charset on UTF8, import my test tables from a dump.

Connection looks good, in my app:

query.exec("SHOW VARIABLES LIKE 'character_set%'");

"character_set_client" "utf8" 
"character_set_connection" "utf8" 
"character_set_database" "utf8" 
"character_set_filesystem" "binary" 
"character_set_results" "utf8" 
"character_set_server" "utf8" 
"character_set_system" "utf8" 
"character_sets_dir" "/usr/share/mysql/charsets/"

All looks UTF8 right? But the result are not like that.

Got no clue where to look... all was fine before the upgrade.
Where could be the problem?

Last edited by tikis (2009-06-18 07:54:26)

tikis · 2009-06-17 20:37:27

Some update:

I tried to compile Qt 4.5.1 with support myself, thought maybe something is wrong with the qt-sql connector, but didn't helped.

So, I finally I downgraded to mysql 5.1.34, and also libmysqlclient and mysql-clients. It helped. Note: the UTF problem was my fault, but the other symptoms are there with mysql 5.1.35 and vanished with the downgrade to 5.1.34.

Got no clue if it's libmysqlclient, mysql or mysql-client problem, package or upstream, so I don't fill a bugreport now, maybe some other come up with some problem too.

Last edited by tikis (2009-06-17 20:39:44)

zeb · 2009-06-19 12:37:39

I ran into the same problem. MythTV (which uses Qt) was unable to run any database queries when I upgraded to the 5.1.35-versions of the mysql packages. Downgrading got MythTV working again.

Arch Linux

#1 2009-06-16 23:19:50

mysql upgrade -> qt connection problems

#2 2009-06-17 20:37:27

Re: mysql upgrade -> qt connection problems

#3 2009-06-19 12:37:39

Re: mysql upgrade -> qt connection problems

Board footer