[debian-mysql] Bug#711254: mysql-server-5.5: Some inserts and updates with strange effects (missing results)

[Karsten Malcher]

Package: mysql-server-5.5
Version: 5.5.31+dfsg-0+wheezy1
Severity: important

Hello,

after my last update i have very strange effects on my webserver regarding mySQL.
One example with an installed wikimedia.

I can't use or update the user public.
The user exists - i can see it with

select * from user WHERE user_name = 'public'

but when i try to update the users password with

UPDATE user SET user_password = CONCAT(':A:', MD5('public')) WHERE user_name = 'public'

no rows are affected.


The user is not found by the wiki when you try to login.
It's the same with the updatescript from wikimedia:

# php changePassword.php --user=public --password=public
No such user: public

There are also strange effects in other software like an phpbb forum.
I can add a thread but the title is missing and empty.
When i try to edit it sometimes a title is accepted and updated and sometimes it is empty again.

Everything else seems to work without problems.


I open this bug in hope that someone have the same problems.
Is it possible to roll back the last package updates only for mysql?

Best regards
Karsten


-- System Information:
Debian Release: 7.0
   APT prefers stable
   APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-4-486
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.49
ii  initscripts            2.88dsf-41
ii  libc6                  2.13-38
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.2-5
ii  libstdc++6             4.7.2-5
ii  lsb-base               4.1+Debian8
ii  mysql-client-5.5       5.5.31+dfsg-0+wheezy1
ii  mysql-common           5.5.31+dfsg-0+wheezy1
ii  mysql-server-core-5.5  5.5.31+dfsg-0+wheezy1
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.14.2-21
ii  psmisc                 22.19-1+deb7u1
ii  zlib1g                 1:1.2.7.dfsg-13

Versions of packages mysql-server-5.5 recommends:
ii  bsd-mailx [mailx]      8.1.2-0.20111106cvs-1
ii  libhtml-template-perl  2.91-1

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- debconf information:
* mysql-server/root_password_again: (password omitted)
* mysql-server/root_password: (password omitted)
   mysql-server/error_setting_password:
   mysql-server-5.5/postrm_remove_databases: false
   mysql-server-5.5/nis_warning:
   mysql-server-5.5/really_downgrade: false
   mysql-server-5.5/start_on_boot: true
   mysql-server/password_mismatch:
   mysql-server/no_upgrade_when_using_ndb: