Debian Bug report logs - #711254
mysql-server-5.5: Some inserts and updates with strange effects (missing results)

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Karsten Malcher <debian@dct.mine.nu>

To: submit@bugs.debian.org

Subject: mysql-server-5.5: Some inserts and updates with strange effects (missing results)

Date: Wed, 05 Jun 2013 23:58:32 +0200

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:

Message #10 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Karsten Malcher <debian@dct.mine.nu>

To: 711254@bugs.debian.org

Subject: Bug reported to MySQL

Date: Fri, 07 Jun 2013 23:50:07 +0200

Please refer to the bug at mySQL:
http://bugs.mysql.com/bug.php?id=69430

I have done an additional test now.
Up to now i used phpmyadmin to talk to mysql.


Now i tried to use the shell command instead.

mysql -u username -ppassword dbname -e "UPDATE user SET user_password = CONCAT(':A:', MD5('public')) WHERE user_name = 
'public'"

This seems to work.

mysql -u username -ppassword dbname -e"select * from user WHERE user_name = 'public'"
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+
| user_id | user_name | user_real_name | user_password                       | 
user_newpassword                             | user_newpass_time | user_email          | user_touched   | 
user_token                       | user_email_authenticated | user_email_token | user_email_token_expires | 
user_registration | user_editcount |
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+
|       2 | public    | Public         | :A:4c9184f37cff01bcdc32dc486ec36961 | 
:B:b50fb7bb:e5fcb263a54546d423589c83cc5b1263 | 20130605082126    | wiki@dct.mine.nu | 20130605082131 | 
6cddefa506a7c33b9a7372af70c69604 | NULL                     | NULL             | NULL                     | 
20071015111247    |           1132 |
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+

So maybe the problem is caused by PHP?

Message #19 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Karsten Malcher <debian@dct.mine.nu>

To: 711254@bugs.debian.org

Subject: It's a problem of PHP and not MySQL

Date: Mon, 10 Jun 2013 00:09:21 +0200

I activated the general log in MySQL and proofed what SQL is send to the server in the problematic updates.

In case of wikimedia no clear update command is send, but in phpbb i could see that the update is blank instead of the 
content.

1339 Query     UPDATE phpbb_topics SET topic_title = '', topic_type = 0  WHERE topic_id = 1066

The topic_title should contain a text.

Something goes wrong in PHP5.

Message #22 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Bob Proulx <bob@proulx.com>

To: debian@dct.mine.nu, 711254@bugs.debian.org

Subject: Re: Bug#711254: It's a problem of PHP and not MySQL

Date: Sun, 9 Jun 2013 18:30:26 -0600

[Message part 1 (text/plain, inline)]

reassign 711254 php5
tag 711254 + moreinfo
thanks

Karsten Malcher wrote:
> In case of wikimedia no clear update command is send, but in phpbb i
> could see that the update is blank instead of the content.
> 1339 Query     UPDATE phpbb_topics SET topic_title = '', topic_type = 0  WHERE topic_id = 1066
> The topic_title should contain a text.
> Something goes wrong in PHP5.

Thank you for the bug report.  However this is very little to go
upon.  From what you have said so far there isn't enough information
to know what might be happening.  At this point the problem could be
anything.

Because php has been updated to 5.5.0 it is most likely that your
wikimedia and phpbb applications are not updated to work with the
changes in php 5.5.  I think that is the most likely problem.  If it
didn't work at all then there would be many reports.  Therefore this
is probably simply an incompatibility with the recent updates and
changes in upstream php 5.5.

Since you have the problem, and no one else is seeing the problem so
far, and you have been making progress debugging it then it would be
most helpful if you could keep going and get to the bottom of the
problem.

Thanks,
Bob

[signature.asc (application/pgp-signature, inline)]

Message #31 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: "711254@bugs.debian.org" <711254@bugs.debian.org>

Cc: "debian@dct.mine.nu" <debian@dct.mine.nu>

Subject: Re: [php-maint] Bug#711254: It's a problem of PHP and not MySQL

Date: Mon, 10 Jun 2013 09:00:44 +0200

Please provide your php5 versions (dpkg -l '*php5*').

Ondřej Surý

On 10. 6. 2013, at 2:30, Bob Proulx <bob@proulx.com> wrote:

> reassign 711254 php5
> tag 711254 + moreinfo
> thanks
> 
> Karsten Malcher wrote:
>> In case of wikimedia no clear update command is send, but in phpbb i
>> could see that the update is blank instead of the content.
>> 1339 Query     UPDATE phpbb_topics SET topic_title = '', topic_type = 0  WHERE topic_id = 1066
>> The topic_title should contain a text.
>> Something goes wrong in PHP5.
> 
> Thank you for the bug report.  However this is very little to go
> upon.  From what you have said so far there isn't enough information
> to know what might be happening.  At this point the problem could be
> anything.
> 
> Because php has been updated to 5.5.0 it is most likely that your
> wikimedia and phpbb applications are not updated to work with the
> changes in php 5.5.  I think that is the most likely problem.  If it
> didn't work at all then there would be many reports.  Therefore this
> is probably simply an incompatibility with the recent updates and
> changes in upstream php 5.5.
> 
> Since you have the problem, and no one else is seeing the problem so
> far, and you have been making progress debugging it then it would be
> most helpful if you could keep going and get to the bottom of the
> problem.
> 
> Thanks,
> Bob
> _______________________________________________
> pkg-php-maint mailing list
> pkg-php-maint@lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-php-maint

Message #36 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Karsten Malcher <debian@dct.mine.nu>

To: Bob Proulx <bob@proulx.com>

Cc: 711254@bugs.debian.org

Subject: Re: Bug#711254: It's a problem of PHP and not MySQL

Date: Mon, 10 Jun 2013 09:58:29 +0200

Hello Bob,

Am 10.06.2013 02:30, schrieb Bob Proulx:
> Thank you for the bug report. However this is very little to go upon. From what you have said so far there isn't 
> enough information to know what might be happening. At this point the problem could be anything.

Yes - i have the same problem at this time.
But most of the applications are to complex for a simply debug.

> Because php has been updated to 5.5.0 it is most likely that your wikimedia and phpbb applications are not updated to 
> work with the changes in php 5.5. I think that is the most likely problem.

The server installation is complete new (no upgrade) with wheezy from beginning of may.
I installed most of the applications new to the latest stable releases.
So wikimedia is V 1.20.4.
The migration of the previous version seems not make problems.
What can i do more than to install the actual version?

There is other software that has no newer versions.
E.g. http://www.phpmyedit.org/
Here i have the problem that the software is doing nearly nothing.
There is no error message in the apache2 logs and links and buttons are not working.
But this error is consistent.

What i cannot understand is why an update is empty depending of the content (always simple text)?

> If it didn't work at all then there would be many reports.

Yes - i wonder about this also .
And i thought that PHP is more downwards compatible.
Hopefully someone will answer with the same problem.

> Therefore this is probably simply an incompatibility with the recent updates and changes in upstream php 5.5.

Up to now i can't find similar problem descriptions.

> Since you have the problem, and no one else is seeing the problem so far, and you have been making progress debugging 
> it then it would be most helpful if you could keep going and get to the bottom of the problem. Thanks, Bob 

I must find out how to increase the debug information of php5?


Here the installed packages:

ii  libapache2-mod-php5                  5.4.4-14                           i386         server-side, HTML-embedded 
scripting language (Apache 2 module)
ii  php5                                 5.4.4-14                           all          server-side, HTML-embedded 
scripting language (metapackage)
ii  php5-cli                             5.4.4-14                           i386         command-line interpreter for 
the php5 scripting language
ii  php5-common                          5.4.4-14                           i386         Common files for packages built 
from the php5 source
ii  php5-curl                            5.4.4-14                           i386         CURL module for php5
ii  php5-exactimage                      0.8.5-5                            i386         fast image manipulation library 
(PHP bindings)
ii  php5-gd                              5.4.4-14                           i386         GD module for php5
ii  php5-geoip                           1.0.7-8                            i386         GeoIP module for php5
ii  php5-imagick                         3.1.0~rc1-1+b2                     i386         ImageMagick module for php5
ii  php5-imap                            5.4.4-14                           i386         IMAP module for php5
ii  php5-intl                            5.4.4-14                           i386         internationalisation module for 
php5
ii  php5-mcrypt                          5.4.4-14                           i386         MCrypt module for php5
ii  php5-mysql                           5.4.4-14                           i386         MySQL module for php5
ii  php5-pspell                          5.4.4-14                           i386         pspell module for php5
ii  php5-recode                          5.4.4-14                           i386         recode module for php5
ii  php5-sqlite                          5.4.4-14                           i386         SQLite module for php5

Cheers
Karsten

Message #41 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@debian.org>

To: debian@dct.mine.nu, 711254@bugs.debian.org

Cc: Bob Proulx <bob@proulx.com>

Subject: Re: [php-maint] Bug#711254: It's a problem of PHP and not MySQL

Date: Mon, 10 Jun 2013 10:42:17 +0200

[Message part 1 (text/plain, inline)]

On Mon, Jun 10, 2013 at 9:58 AM, Karsten Malcher <debian@dct.mine.nu> wrote:

> The server installation is complete new (no upgrade) with wheezy from
> beginning of may.
> I installed most of the applications new to the latest stable releases.
> So wikimedia is V 1.20.4.
>

There was something related to the upgrade of mediawiki in Debian:

http://anonscm.debian.org/viewvc/pkg-mediawiki/mediawiki/trunk/debian/NEWS?view=markup

But I am not sure if this is related to your installation.

Does the affected applications use some common (could be PEAR or PECL or
just some PHP files somewhere) library which you have installed by hand?

Ondrej
-- 
Ondřej Surý <ondrej@sury.org>

[Message part 2 (text/html, inline)]

Message #46 received at 711254@bugs.debian.org (full text, mbox, reply):

From: Karsten Malcher <debian@dct.mine.nu>

To: Ondřej Surý <ondrej@debian.org>

Cc: 711254@bugs.debian.org, Bob Proulx <bob@proulx.com>

Subject: Re: [php-maint] Bug#711254: It's a problem of PHP and not MySQL

Date: Mon, 10 Jun 2013 10:49:49 +0200

Hello,

Am 10.06.2013 10:42, schrieb Ondřej Surý:
> On Mon, Jun 10, 2013 at 9:58 AM, Karsten Malcher <debian@dct.mine.nu <mailto:debian@dct.mine.nu>> wrote:
>
>     The server installation is complete new (no upgrade) with wheezy from beginning of may.
>     I installed most of the applications new to the latest stable releases.
>     So wikimedia is V 1.20.4.
>
>
> There was something related to the upgrade of mediawiki in Debian:
>
> http://anonscm.debian.org/viewvc/pkg-mediawiki/mediawiki/trunk/debian/NEWS?view=markup
>
> But I am not sure if this is related to your installation.

The user has all rights for the DB.
There is a good and comfatable installer for mediawiki.
Every checkes and migration works without problem.
I have the reported problems with the user.
For this i will ask the mediawiki team.

>
> Does the affected applications use some common (could be PEAR or PECL or just some PHP files somewhere) library which 
> you have installed by hand?

No - i only downloaded the installation file and unpacked it.

Thank you for help.
Karsten

>
> Ondrej
> -- 
> Ondřej Surý <ondrej@sury.org <mailto:ondrej@sury.org>>

Message #51 received at 711254-done@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: 683476-done@bugs.debian.org, 711254-done@bugs.debian.org

Subject: Closing the non-security bugs against PHP in Debian wheezy (old-stable)

Date: Wed, 27 Jan 2016 12:46:21 +0100

Version: php5/5.6.0+dfsg-1

Feel free to reopen the bugs, if you can reproduce those against current
Debian stable PHP version (5.6.17+).

Cheers,
-- 
Ondřej Surý <ondrej@sury.org>
Knot DNS (https://www.knot-dns.cz/) – a high-performance DNS server

Send a report that this bug log contains spam.