mass rebuild of mysql packages in F-15

[Marcela Maslanova]

Because many packages in F-15 have broken dependencies there will be needed mass rebuild.

dhorak will build these, which are not rebuild yet. After that will be created
one big update, so please don't file your own updates into bodhi.

List of all dependent packages:
repoquery --whatrequires 'libmysqlclient.so.16()(64bit)' --qf
"%{SOURCERPM}" | sed 's/-[^-]*-[^-]*$//' | sort -u
amarok
apr-util
asterisk
bacula
bind
callweaver
cherokee
collectd
cyrus-sasl
dolphin-connector
dovecot
dspam
EMBOSS
exim
freeradius
gambas2
gammu
gdal
gmyth
gnokii
grass
gstreamer-plugins-bad-free
Io-language
jabberd
koffice
lcgdm
libdbi-drivers
libgda
libnss-mysql
libpreludedb
libzdb
lighttpd
lua-sql
mapserver
mediatomb
mod_auth_mysql
mydns
mysql
mysql++
mysql-connector-c++
mysql-connector-odbc
MySQL-python
mysql-workbench
nagios-plugins
ndoutils
nekovm
ntop
nufw
openscada
openser
opensips
pam_mysql
pdns
perl-DBD-MySQL
php
poco
postfix
proftpd
pure-ftpd
qt
qt3
redland
rekall
root
rsyslog
ruby-mysql
ser
snort
sphinx
sysbench
tcl-mysqltcl
ulogd
UpTools
voms-mysql-plugin
wgrib2
yap
zabbix
zarafa
zoneminder

List of already built packages:
koji list-tagged dist-f15-mysql
MySQL-python-1.2.3-3.fc15 dist-f15-mysql tgl
amarok-2.4.0-4.fc15 dist-f15-mysql rdieter
asterisk-1.8.3.2-2.fc15 dist-f15-mysql jcollie
cyrus-sasl-2.1.23-16.fc15 dist-f15-mysql tmraz
dspam-3.9.0-19.fc15 dist-f15-mysql gnat
libdbi-drivers-0.8.3-8.fc15 dist-f15-mysql tgl
mediatomb-0.12.1-9.fc15 dist-f15-mysql rmattes
mysql++-3.1.0-7.fc15 dist-f15-mysql remi
mysql-5.5.10-1.fc15 dist-f15-mysql tgl
mysql-connector-c++-1.1.0-0.7.bzr895.fc15 dist-f15-mysql remi
mysql-connector-odbc-5.1.8-3.fc15 dist-f15-mysql tgl
nufw-2.4.3-4.fc15.1 dist-f15-mysql tmraz
perl-DBD-MySQL-4.018-4.fc15 dist-f15-mysql mmaslano
perl-DBD-MySQL-4.018-5.fc15 dist-f15-mysql mmaslano
php-5.3.6-2.fc15 dist-f15-mysql remi
proftpd-1.3.4-0.4.rc1.fc15 dist-f15-mysql pghmcfc
qt-4.7.2-4.fc15 dist-f15-mysql rdieter
qt3-3.3.8b-35.fc15 dist-f15-mysql rdieter
redland-1.0.12-3.fc15 dist-f15-mysql rdieter
root-5.28.00b-2.fc15 dist-f15-mysql ellert
zabbix-1.8.4-4.fc15 dist-f15-mysql sharkcz

[Remi Collet]

Post by Marcela Maslanova
dhorak will build these, which are not rebuild yet. After that will be created
mysql-workbench

Please don't build this one which is FTBFS for now (gcc 4.6 issue).

I'm working on it, and should build it ASAP.

Remi.

[Dan Horák]

Post by Remi Collet

Post by Marcela Maslanova
dhorak will build these, which are not rebuild yet. After that will be created
mysql-workbench

Please don't build this one which is FTBFS for now (gcc 4.6 issue).
I'm working on it, and should build it ASAP.

thanks for info, mysql-workbench will be skipped

And I'll wait till 18:00 UTC today for any additional exclusion
requests. Then I'll fire the rebuild script.


Dan

[Remi Collet]

Post by Dan Horák
thanks for info, mysql-workbench will be skipped

mysql-workbench-5.2.33b-1.fc15 tagged in dist-f15-mysql
(and, of course, rawhide)

Remi.

[Tom Lane]

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.

Of course, all these packages need to be rebuilt in rawhide too.
I don't think dhorak is offering to do that, so if you own one of
them, please do launch a rawhide build.

regards, tom lane

[Dan Horák]

Post by Tom Lane

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.

Of course, all these packages need to be rebuilt in rawhide too.
I don't think dhorak is offering to do that, so if you own one of
them, please do launch a rawhide build.

it's few more lines in the script so I can rebuilt the rawhide branch
too


Dan

[Dan Horák]

Post by Dan Horák

Post by Tom Lane

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.

Of course, all these packages need to be rebuilt in rawhide too.
I don't think dhorak is offering to do that, so if you own one of
them, please do launch a rawhide build.

it's few more lines in the script so I can rebuilt the rawhide branch
too

The F-15 and rawhide rebuilds are finished now with some failures

collectd
gmyth
grass (f15 only)
gstreamer-plugins-bad-free
mapserver (f15 only)
pure-ftpd
ser
snort
zoneminder (Jason knows about it)


Dan

[Dennis Gilmore]

Ive not used snort in ages and not really had time to maintain it. im going to
orphan it in pkgdb if no one picks it up in a week ill retire it
it needs a bit of work as its an odd beast

snort

Dennis
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.fedoraproject.org/pipermail/devel/attachments/20110323/3eab6442/attachment.bin

[Tom Lane]

Post by Dan Horák
The F-15 and rawhide rebuilds are finished now with some failures

Thanks for that!

Post by Dan Horák
collectd
gmyth
grass (f15 only)
gstreamer-plugins-bad-free
mapserver (f15 only)
pure-ftpd
ser
snort
zoneminder (Jason knows about it)

I looked through the build logs for these. It appears that the grass,
mapserver, gstreamer-plugins-bad-free, and possibly collectd failures
are just because they had dependencies that needed to be rebuilt first.

ser's problem is
/usr/bin/ld: cannot find -lfl
which looks to me to be a flex incompatibility unrelated to mysql.

pure-ftpd's problem is
libpureftpd.a(libpureftpd_a-log_mysql.o): In function `pw_mysql_check':
/builddir/build/BUILD/pure-ftpd-1.0.29/src/log_mysql.c:454: undefined reference to `make_scrambled_password'

which I'm not sure about --- perhaps it was expecting mysql to export
such a function? We tightened up the exports list some time ago, so
I'd have expected such a problem to be caught already. Did pure-ftpd
get through the F15 mass rebuild successfully?

regards, tom lane

[Dennis Gilmore]

Post by Tom Lane
pure-ftpd's problem is
/builddir/build/BUILD/pure-ftpd-1.0.29/src/log_mysql.c:454: undefined
reference to `make_scrambled_password'
which I'm not sure about --- perhaps it was expecting mysql to export
such a function? We tightened up the exports list some time ago, so
I'd have expected such a problem to be caught already. Did pure-ftpd
get through the F15 mass rebuild successfully?

it failed the mass rebuild

Dennis
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.fedoraproject.org/pipermail/devel/attachments/20110323/a2564a82/attachment.bin

[Kevin Kofler]

Post by Tom Lane
ser's problem is
/usr/bin/ld: cannot find -lfl
which looks to me to be a flex incompatibility unrelated to mysql.

Probably needs BR flex-static.

Kevin Kofler

[Tom Lane]

Post by Kevin Kofler

Post by Tom Lane
ser's problem is
/usr/bin/ld: cannot find -lfl
which looks to me to be a flex incompatibility unrelated to mysql.

Probably needs BR flex-static.

Yup, you're right. It's been FTBFS for awhile:
https://bugzilla.redhat.com/show_bug.cgi?id=660932

regards, tom lane

[Marcela Mašláňová]

Post by Tom Lane

Post by Kevin Kofler

Post by Tom Lane
ser's problem is
/usr/bin/ld: cannot find -lfl
which looks to me to be a flex incompatibility unrelated to mysql.

Probably needs BR flex-static.

https://bugzilla.redhat.com/show_bug.cgi?id=660932
regards, tom lane

I've applied BR and build ser
http://koji.fedoraproject.org/koji/taskinfo?taskID=2940159

regards,
Marcela

[Tom Lane]

Post by Marcela Mašláňová

Post by Kevin Kofler
Probably needs BR flex-static.

I've applied BR and build ser
http://koji.fedoraproject.org/koji/taskinfo?taskID=2940159

Thanks for that. As of now we have 75 packages in dist-f15-mysql,
with the following dependencies having failed to build:

collectd complains about "nut"?
http://koji.fedoraproject.org/koji/getfile?taskID=2937228&name=build.log
gmyth pre-existing FTBFS #564741
gstreamer-plugins-bad-free buildrequires gmyth which FTBFS
pure-ftpd pre-existing FTBFS #690346
snort pre-existing FTBFS, orphaned
zoneminder pre-existing FTBFS #672707

I don't know quite what to make of the collectd failure, but it looks to
me like it's unrelated to the mysql changes.

Do we need to wait around for somebody to fix these stragglers, or can
we go ahead and release dist-f15-mysql into the general f15-testing
pool? If the latter, what's the procedure for that, pester rel-eng?

regards, tom lane

[Jason L Tibbitts III]

TL> Do we need to wait around for somebody to fix these stragglers, or
TL> can we go ahead and release dist-f15-mysql into the general
TL> f15-testing pool?

Please do not wait on zoneminder. It was broken before this due to an
unrelated issue which should be fixed up soon. Unless this Mysql bump
introduces some significant incompatibility problem everything should be
fine when I get the latest snapshot packaged up.

- J<

[Tom Lane]

Post by Jason L Tibbitts III
Please do not wait on zoneminder. It was broken before this due to an
unrelated issue which should be fixed up soon. Unless this Mysql bump
introduces some significant incompatibility problem everything should be
fine when I get the latest snapshot packaged up.

If it was working against mysql 5.5.8 (which went into rawhide a bit
before Christmas) then I'd be pretty surprised if it doesn't work
against 5.5.10. OTOH, if you last tested against mysql 5.1.x, there
might be some compatibility gotchas waiting for you.

regards, tom lane

[Mamoru Tasaka]

Post by Tom Lane

Post by Marcela Mašláňová

Post by Kevin Kofler
Probably needs BR flex-static.

I've applied BR and build ser
http://koji.fedoraproject.org/koji/taskinfo?taskID=2940159

Thanks for that. As of now we have 75 packages in dist-f15-mysql,
collectd complains about "nut"?
http://koji.fedoraproject.org/koji/getfile?taskID=2937228&name=build.log
gmyth pre-existing FTBFS #564741
gstreamer-plugins-bad-free buildrequires gmyth which FTBFS
pure-ftpd pre-existing FTBFS #690346
snort pre-existing FTBFS, orphaned
zoneminder pre-existing FTBFS #672707

gmyth built, now gstreamer-plugins-bad-free is waiting for new-repo
on chain-build.

Regards,
Mamoru

[Tom Lane]

Post by Mamoru Tasaka
gmyth built, now gstreamer-plugins-bad-free is waiting for new-repo
on chain-build.

Thank you, looks like those both went through fine. Meanwhile
I've identified the collectd failure, and it's indeed not related
to mysql (bz #690558).

regards, tom lane

[Sergio Belkin]

Post by Dan Horák

Post by Dan Horák

Post by Tom Lane

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.

Of course, all these packages need to be rebuilt in rawhide too.
I don't think dhorak is offering to do that, so if you own one of
them, please do launch a rawhide build.

it's few more lines in the script so I can rebuilt the rawhide branch
too

The F-15 and rawhide rebuilds are finished now with some failures
collectd
gmyth
grass (f15 only)
gstreamer-plugins-bad-free
mapserver (f15 only)
pure-ftpd
ser
snort
zoneminder (Jason knows about it)

FWIW Should We not my dependant package the rest of packages because
have been already rebuilt?

Thanks in advance!

[Sergio Belkin]

FWIW

I meant FWIU :)

[Tom Lane]

Post by Sergio Belkin
FWIW Should We not my dependant package the rest of packages because
have been already rebuilt?

If you have a package that uses libmysqlclient.so, and it's not already
listed in "koji list-tagged dist-f15-mysql", please go ahead and build
it there with "fedpkg build --target=dist-f15-mysql". But I think we've
gotten everything that doesn't have pre-existing build problems.

regards, tom lane

[Sergio Belkin]

Post by Tom Lane

Post by Sergio Belkin
FWIW Should We not my dependant package the rest of packages because
have been already rebuilt?

If you have a package that uses libmysqlclient.so, and it's not already
listed in "koji list-tagged dist-f15-mysql",

Yes it is listed:

koji list-tagged dist-f15-mysql | grep UpTools
UpTools-8.5.4-12.fc15 dist-f15-mysql sharkcz

Thanks sharkcz :)

[Mattias Ellert]

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.
dhorak will build these, which are not rebuild yet. After that will be created
one big update, so please don't file your own updates into bodhi.

I have rebuilt my two remaining packages so you do not need to do them

Post by Marcela Maslanova
lcgdm
voms-mysql-plugin
root-5.28.00b-2.fc15 dist-f15-mysql ellert

Mattias

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5734 bytes
Desc: not available
Url : http://lists.fedoraproject.org/pipermail/devel/attachments/20110323/2799474d/attachment.bin

[Michal Hlavinka]

Post by Marcela Maslanova
Because many packages in F-15 have broken dependencies there will be needed mass rebuild.
dhorak will build these, which are not rebuild yet.

just note that update script needs some modifications for future usages. It should check whether
update exists git and/or koji, because there is quite "long" time before getting the list of packages
and real update. Checking git last modification should be really easy. Also F15 can be a little behind
of rawhide packages, so using the same list (F15 list for rawhide) is not sufficient (but git check
would fix it). Just my comments so it works better next time and there are no updates like this:

""""""""""""""""""
Package: dovecot-2.0.11-3.fc16
Tag: dist-f16
Started: Wed, 23 Mar 2011 18:14:09 UTC
Changelog:
* Wed Mar 23 2011 Dan Hor??k <dan at danny.cz> - 1:2.0.11-3
- rebuilt for mysql 5.5.10 (soname bump in libmysqlclient)

* Wed Mar 23 2011 Michal Hlavinka <mhlavink at redhat.com> - 1:2.0.11-2
- rebuild because of updated dependencies

""""""""""""""""""""""""""""""""""

Time between first and second rebuild is 5 hours.

Michal