Bug 43441 - MySQL package is not up-to-date in UCS 4.2
MySQL package is not up-to-date in UCS 4.2
Status: CLOSED FIXED
Product: UCS
Classification: Unclassified
Component: MySQL
UCS 4.2
Other Linux
: P5 normal (vote)
: UCS 4.2
Assigned To: Philipp Hahn
Erik Damrose
: interim-1
Depends on: 40530
Blocks: 43436
  Show dependency treegraph
 
Reported: 2017-01-30 07:32 CET by Stefan Gohmann
Modified: 2017-04-04 18:30 CEST (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Gohmann univentionstaff 2017-01-30 07:32:43 CET
In Debian Jessie 5.5.54-0+deb8u1 is used. In UCS 4.2-0 5.5.50-0+deb8u is imported.

I think the patches need to be migrated.


--------------------------------------------------------------------------
https://packages.debian.org/search?suite=default&section=all&arch=any&searchon=sourcenames&keywords=mysql-5.5

Source Package mysql-5.5
    wheezy (misc): 5.5.54-0+deb7u1 [security]
    Binary packages: [show 12 binary packages]
    jessie (misc): 5.5.54-0+deb8u1 [security]
    Binary packages: [show 13 binary packages]
--------------------------------------------------------------------------

--------------------------------------------------------------------------
root@master211:~# apt-cache policy libmysqlclient-dev
libmysqlclient-dev:
  Installed: (none)
  Candidate: 5.5.52-0.25.201609281418
  Version table:
     5.5.52-0.25.201609281418 0
        500 https://updates-test.software-univention.de/4.1/maintained/ 4.1-4/amd64/ Packages
     5.5.50-0+deb8u1 0
        500 https://updates-test.software-univention.de/4.2/maintained/ 4.2-0/amd64/ Packages
     5.5.46-0.17.201512141630 0
        500 https://updates-test.software-univention.de/4.1/maintained/ 4.1-1/amd64/ Packages
     5.5.46-0.16.201512141629 0
        500 https://updates-test.software-univention.de/4.0/maintained/ 4.0-5/amd64/ Packages
     5.5.44-0.15.201508042121 0
        500 https://updates-test.software-univention.de/4.0/unmaintained/ 4.0-3/amd64/ Packages
     5.5.40-0.14.201502051002 0
        500 https://updates-test.software-univention.de/4.0/unmaintained/ 4.0-1/amd64/ Packages
     5.5.40-0.11.201411010605 0
        500 https://updates-test.software-univention.de/4.0/unmaintained/ 4.0-0/amd64/ Packages
root@master211:~# 
--------------------------------------------------------------------------
Comment 1 Arvid Requate univentionstaff 2017-01-30 12:27:55 CET
Hmm, 5.5.54-0+deb8u1 build finally aborts for yet unknown reason:

logs/ucs_4.2-0-0/mysql-5.5_5.5.54-0.A~4.2.0.201701301216.log.bz2 says:
======================================================================
[100%] Built target mysqlserver
make[3]: Leaving directory '/var/build/temp/tmp.PF9ANLGRUS/mysql-5.5-5.5.54/builddir-pic'
/usr/bin/cmake -E cmake_progress_start /var/build/temp/tmp.PF9ANLGRUS/mysql-5.5-5.5.54/builddir-pic/CMakeFiles 0
make[2]: Leaving directory '/var/build/temp/tmp.PF9ANLGRUS/mysql-5.5-5.5.54/builddir-pic/libmysqld'
touch build-pic-stamp
make[1]: Leaving directory '/var/build/temp/tmp.PF9ANLGRUS/mysql-5.5-5.5.54'
debian/rules:245: recipe for target 'build' failed
make: *** [build] Error 2
======================================================================
Comment 2 Stefan Gohmann univentionstaff 2017-01-31 08:35:52 CET
(In reply to Arvid Requate from comment #1)
> Hmm, 5.5.54-0+deb8u1 build finally aborts for yet unknown reason:

I guess it fails if you start a parallel build. Maybe it was activated some time ago in repo-ng.

Anyway, it worked after building it in the following way:
 build-package-ng -r 4.2-0-0 -P ucs -j 1 -p mysql-5.5
and on ladda:
 build-package-architecture-ng -r 4.2-0-0 -P ucs -j 1 -p mysql-5.5
Comment 3 Arvid Requate univentionstaff 2017-01-31 20:34:42 CET
Ok, the package is installable and mysql-testsuite runs.

I assume a changelog entry is not required for this interim package update.
Comment 4 Erik Damrose univentionstaff 2017-02-01 14:47:13 CET
OK: mysql 5.5.54-0+deb8u1A~4.2.0.201701310741
OK: patches applied
OK: /etc/mysql.secret is correctly created upon package installation
OK: ucr mysql/autostart works
OK: tested: connect as root user, install wordpress docker container on mysqlDB
OK: no separate changelog entry required

Verified
Comment 5 Philipp Hahn univentionstaff 2017-03-07 17:25:44 CET
(In reply to Arvid Requate from comment #3)
> Ok, the package is installable and mysql-testsuite runs.

How can the test suite run if it is disabled by "disable-testsuite.patch"?
Time to drop that patch now as <https://bugs.mysql.com/bug.php?id=46029> is fixed.

r17370 | Bug #43441: mysql-5.5
 Fix FTBFS-jX; Debian bts:857059, re-enable test-suite

And the version is wrong; see Bug #41931:
# SELECT DISTINCT srcpkg,srcver,site,major,minor FROM binpkg WHERE site='apt' AND major=4 AND srcpkg='mysql-5.5' ORDER BY srcver;
  srcpkg   |               srcver                | site | major | minor 
-----------+-------------------------------------+------+-------+-------
 mysql-5.5 | 5.5.40-0.11.201411010605            | apt  |     4 |     0
 mysql-5.5 | 5.5.40-0.14.201502051002            | apt  |     4 |     0
 mysql-5.5 | 5.5.44-0.15.201508042121            | apt  |     4 |     0
 mysql-5.5 | 5.5.46-0.16.201512141629            | apt  |     4 |     0
 mysql-5.5 | 5.5.46-0.17.201512141630            | apt  |     4 |     1
 mysql-5.5 | 5.5.52-0.25.201609281418            | apt  |     4 |     1
 mysql-5.5 | 5.5.54-0+deb8u1A~4.2.0.201701310741 | apt  |     4 |     2
 mysql-5.5 | 5.5.54-0.27.201701251948            | apt  |     4 |     1

build-package-ng -r 4.2 -p mysql-5.5 "5.5.54-0.A~4.2.0.$(date +%Y%m%d%H%M)"
Comment 6 Arvid Requate univentionstaff 2017-03-07 22:22:32 CET
> How can the test suite run if it is disabled by "disable-testsuite.patch"?

Guess what, I've started it manually. That patch disabled dh_autotest.

Apparently you have rebuilt the package, so it's your bug now.
Comment 7 Erik Damrose univentionstaff 2017-03-08 12:03:03 CET
OK: rebuild with higher version
OK: package version is now higher than in ucs 4.1: 5.5.54-0.A~4.2.0.201703071716
Comment 8 Stefan Gohmann univentionstaff 2017-04-04 18:30:04 CEST
UCS 4.2 has been released:
 https://docs.software-univention.de/release-notes-4.2-0-en.html
 https://docs.software-univention.de/release-notes-4.2-0-de.html

If this error occurs again, please use "Clone This Bug".