Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 251565 - dev-db/mysql and dev-db/mysql-community block each other preventing install
Summary: dev-db/mysql and dev-db/mysql-community block each other preventing install
Status: RESOLVED WORKSFORME
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-18 22:43 UTC by Paul Dlug
Modified: 2009-05-04 06:18 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Paul Dlug 2008-12-18 22:43:37 UTC
The mysql.eclass seems to make it impossible to install mysql-community on an empty system. It introduces a dependency on DBD-mysql which relies on virtual/mysql, which excludes mysql-community. I'm not sure what the right way to patch this is. It does work if you install virtual/mysql then just remove dev-db/mysql and install dev-db/mysql-community -- clearly not desirable.

> emerge -vp =mysql-community-5.0.67

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild  N    ] dev-db/mysql-5.0.72-r1  USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 0 kB 
[ebuild  N    ] virtual/mysql-5.0  0 kB [1]
[ebuild  N    ] dev-perl/DBD-mysql-4.00.5  0 kB [1]
[ebuild  N    ] dev-db/mysql-community-5.0.67  USE="berkdb perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 0 kB 
[blocks B     ] dev-db/mysql (is blocking dev-db/mysql-community-5.0.67)
[blocks B     ] dev-db/mysql-community (is blocking dev-db/mysql-5.0.72-r1)



Reproducible: Always
Comment 1 Petteri Räty (RETIRED) gentoo-dev 2008-12-18 23:03:59 UTC
Better workaround is to disable the perl use flag. mysql maintainers should probably consider turning it off by default so that emerging works out of the box with the default use flags.
Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2008-12-19 01:28:44 UTC
This should vanish with portage-2.1.6/2.2 that has better blocker resolution. Please test that, and reopen if it doesn't, there's no other option really.

You really do want to have the Perl stuff for mysql, as lots of the scripts it installs (including the mysql_install_db for emerge --config) need it. It's only optional because we used to get lots of complaints that it wasn't.

If you absolutely need a workaround in the meantime, just add "dev-db/mysql" to your local package.mask, emerge mysql-community, and then take it out of the package.mask.
Comment 3 Paul Dlug 2008-12-20 15:03:46 UTC
Thanks, updating to portage-2.1.6.1 worked for me.
Comment 4 HIGHGuY 2009-04-14 17:13:34 UTC
This bug is still present using:

Portage 2.1.6.7 (default/linux/amd64/2008.0/developer, gcc-4.3.2, glibc-2.8_p20080602-r1, 2.6.29-gentoo-r1 x86_64)
=================================================================
System uname: Linux-2.6.29-gentoo-r1-x86_64-Intel-R-_Core-TM-2_Quad_CPU_Q6600_@_2.40GHz-with-glibc2.2.5
Timestamp of tree: Tue, 14 Apr 2009 13:45:01 +0000
ccache version 2.4 [disabled]
app-shells/bash:     3.2_p39
dev-java/java-config: 1.3.7-r1, 2.1.7
dev-lang/python:     2.5.2-r7
dev-util/ccache:     2.4-r7
dev-util/cmake:      2.6.2-r1
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.9
sys-devel/autoconf:  2.13, 2.63
sys-devel/automake:  1.10.2
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.27-r2
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O3 -march=core2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/config"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/udev/rules.d"
CXXFLAGS="-O3 -march=core2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="collision-protect confcache cvs digest distlocks fixpackages metadata-transfer multilib-strict parallel-fetch protect-owned sandbox sfperms sign splitdebug strict unmerge-orphans userfetch userpriv usersandbox"
GENTOO_MIRRORS="http://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ ftp://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ http://ftp.snt.utwente.nl/pub/os/linux/gentoo ftp://ftp.snt.utwente.nl/pub/os/linux/gentoo ftp://mirror.scarlet-internet.nl/pub/gentoo http://gentoo.tiscali.nl/ ftp://gentoo.tiscali.nl/pub/mirror/gentoo/ http://mirror.muntinternet.net/pub/gentoo/ ftp://mirror.muntinternet.net/pub/gentoo/ http://gentoo.virginmedia.com/ ftp://gentoo.virginmedia.com/sites/gentoo http://www.mirrorservice.org/sites/www.ibiblio.org/gentoo/ ftp://ftp.mirrorservice.org/sites/www.ibiblio.org/gentoo/ http://mirror.qubenet.net/mirror/gentoo/ ftp://mirror.qubenet.net/mirror/gentoo/ "
LDFLAGS="-Wl,-O1"
LINGUAS="en_GB nl"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac aalib acl acpi alsa amd64 arts audiofile bash-completion berkdb bluetooth bzip2 cairo cdda cdr clamav cli cracklib crypt cscope ctype dbus dri dts dvb dvd dvdr dvdread eds emboss encode esd evo exif fam ffmpeg firefox flac fuse gdbm ggi gif glitz gpm gstreamer gtk gtk2 hal iconv ipv6 isdnlog jack java jpeg jpeg2k kde libnotify lm_sensors logitech-mouse logrotate mad mailwrapper matroska midi mikmod mmx mng mod mono mp3 mp4 mpeg msn mudflap multilib musepack ncurses nls nptl nptlonly ogg openal opengl openmp oss pam paste64 pcre pdf perl png ppds pppd python qt3 qt3support qt4 quicktime rdesktop readline reflection rss rtsp samba sdl sensord session skins smp sockets speex spell spl sse sse2 ssl startup-notification stream svg sysfs tao tcpd theora threads tiff tk toolbar true-type truetype unicode usb v4l vcd vim-syntax visualization vorbis wmf wxwindows x264 xcomposite xinerama xml xorg xosd xulrunner xv xvid zlib" ALSA_CARDS="hda_intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CAMERAS="canon lg_gsm" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_GB nl" USERLAND="GNU" VIDEO_CARDS="nvidia vga"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

Using command:
ACCEPT_KEYWORDS="~amd64" emerge --pretend --verbose --tree amarok

These are the packages that would be merged, in reverse order:

Calculating dependencies... done!
[ebuild  N    ] media-sound/amarok-2.0.2-r1  USE="mp4 opengl semantic-desktop -cdaudio -daap -debug -ifp -ipod -mp3tunes -mtp -njb" LINGUAS="nl -ar -be -bg -ca -cs -csb -da -de -el -eo -es -et -eu -fi -fr -ga -gl -he -is -it -ja -km -ko -ku -lt -lv -nb -nds -ne -nn -oc -pa -pl -pt -pt_BR -ro -ru -se -si -sk -sl -sv -th -tr -uk -zh_CN -zh_TW" 4,864 kB
[nomerge      ]  dev-db/mysql-5.0.76-r1  USE="berkdb embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static"
[ebuild  N    ]   dev-db/mysql-community-5.0.77-r1  USE="berkdb embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 33,892 kB
[ebuild  N    ]    dev-perl/DBD-mysql-4.01.0  123 kB
[ebuild  N    ]     virtual/mysql-5.0  0 kB
[ebuild  N    ]      dev-db/mysql-5.0.76-r1  USE="berkdb embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 33,859 kB
[ebuild  N    ]     dev-perl/DBI-1.607  493 kB
[ebuild  N    ]      dev-perl/PlRPC-0.2020-r1  18 kB
[ebuild  N    ]       virtual/perl-Storable-2.18  0 kB
[ebuild  N    ]       dev-perl/Net-Daemon-0.43  28 kB
[ebuild  N    ]      virtual/perl-Sys-Syslog-0.27  0 kB
[nomerge      ] virtual/perl-Storable-2.18
[ebuild  N    ]  perl-core/Storable-2.18  174 kB
[nomerge      ] virtual/perl-Sys-Syslog-0.27
[ebuild  N    ]  perl-core/Sys-Syslog-0.27  75 kB
[nomerge      ] dev-db/mysql-community-5.0.77-r1  USE="berkdb embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static"
[ebuild  N    ]  dev-db/mysql-init-scripts-1.2  0 kB
[blocks B     ] dev-db/mysql ("dev-db/mysql" is blocking dev-db/mysql-community-5.0.77-r1)
[blocks B     ] dev-db/mysql-community ("dev-db/mysql-community" is blocking dev-db/mysql-5.0.76-r1)

Total: 13 packages (13 new), Size of downloads: 73,523 kB
Conflict: 2 blocks (2 unsatisfied)

 * Error: The above package list contains packages which cannot be
 * installed at the same time on the same system.

  ('ebuild', '/', 'dev-db/mysql-5.0.76-r1', 'merge') pulled in by
    >=dev-db/mysql-5.0[embedded,-minimal] required by ('ebuild', '/', 'media-sound/amarok-2.0.2-r1', 'merge')
    =dev-db/mysql-5.0* required by ('ebuild', '/', 'dev-perl/DBD-mysql-4.01.0', 'merge')
    =dev-db/mysql-5.0* required by ('ebuild', '/', 'dev-db/mysql-community-5.0.77-r1', 'merge')
    (and 1 more)
Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2009-04-14 18:58:24 UTC
portage/zmedico:
users are still complaining that 2.1.6.x is broken.

mysql.eclass contains:
 72 PDEPEND="perl? ( >=dev-perl/DBD-mysql-2.9004 )"
 75 PDEPEND="${PDEPEND} =virtual/mysql-$(get_version_component_range 1-2 ${PV})"

virtual/mysql-5.0.ebuild contains:
 14 DEPEND=""
 15 RDEPEND="|| (
 16     =dev-db/mysql-${PV}*
 17     =dev-db/mysql-community-${PV}*
 18 )"

The correct merge order is quite simple:
1. dev-db/mysql || dev-db/mysql-community
2. dev-perl/DBD-mysql
2. virtual/mysql

Both of the last items are numbered #2, because they have no interdependencies, and can be built in parallel.
Comment 6 Zac Medico gentoo-dev 2009-04-14 19:08:06 UTC
It's fixed in 2.1.6.11 which is scheduled to go stable in about 2 weeks.
Comment 7 Andrew Szeto 2009-05-04 00:33:37 UTC
Confirmed that problem still exists with Portage 2.1.6.12.

emerge --info:
Portage 2.1.6.12 (default/linux/x86/2008.0/desktop, gcc-4.3.3, glibc-2.9_p20081201-r2, 2.6.28-gentoo-r3 i686)
=================================================================
System uname: Linux-2.6.28-gentoo-r3-i686-Intel-R-_Core-TM-_i7_CPU_920_@_2.67GHz-with-gentoo-2.0.0
Timestamp of tree: Sun, 03 May 2009 06:45:01 +0000
ccache version 2.4 [disabled]
app-shells/bash:     4.0_p17-r1
dev-java/java-config: 2.1.7
dev-lang/python:     2.4.4-r13, 2.5.4-r2, 2.6.2
dev-python/pycrypto: 2.0.1-r8
dev-util/ccache:     2.4-r8
dev-util/cmake:      2.6.4
sys-apps/baselayout: 2.0.0
sys-apps/openrc:     0.4.3-r2
sys-apps/sandbox:    1.9
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.5, 1.9.6-r2, 1.10.2
sys-devel/binutils:  2.19.1-r1
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6a
virtual/os-headers:  2.6.28-r1
ACCEPT_KEYWORDS="x86 ~x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -march=native -msse4 -pipe -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT=""
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/udev/rules.d"
CXXFLAGS="-O3 -march=native -msse4 -pipe -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks fixpackages nostrip parallel-fetch protect-owned sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://osmirrors.cerias.purdue.edu/pub/gentoo/ http://gentoo.mirrors.tera-byte.com/ http://gentoo.osuosl.org/ http://gentoo.netnitco.net/"
LANG="C"
LDFLAGS="-Wl,-O1"
MAKEOPTS="-j9"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X a52 aac acl acpi alsa audiofile avi berkdb bluetooth branding bzip2 cairo caps cdr cgi cli cracklib crypt cups dbus dri dvd dvdr dvdread eds emboss encode evo exif expat fam fastcgi ffmpeg fftw firefox flac fortran ftp gdbm gif glitz gnome gpm gstreamer gtk gtkhtml gyroscopic hal iconv imlib ipv6 isdnlog java jpeg lcms libnotify lm_sensors mad matroska midi mikmod mmx motif mp3 mp4 mpeg mudflap mysql nautilus ncurses nls nptl nptlonly nsplugin ogg opengl openmp oss pam pcre pdf perl php png posix ppds pppd python qt3support quicktime readline reflection samba sdl session sndfile spell spl sse sse2 sse3 sse4 ssl startup-notification svg symlink sysfs tcpd theora tiff truetype unicode usb vcd vim-syntax vorbis win32codecs wmf x264 x86 xcb xml xorg xulrunner xv xvid xvmc zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="evdev mouse keyboard" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="fglrx"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 8 Zac Medico gentoo-dev 2009-05-04 06:05:26 UTC
(In reply to comment #7)
> Confirmed that problem still exists with Portage 2.1.6.12.

You must have a slightly different problem because it work for me here:

$ emerge -pv dev-db/mysql

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild  N    ] dev-db/mysql-init-scripts-1.2  0 kB
[ebuild  N    ] perl-core/Storable-2.18  0 kB
[ebuild  N    ] dev-perl/Net-Daemon-0.43  0 kB
[ebuild  N    ] virtual/perl-Storable-2.18  0 kB
[ebuild  N    ] dev-perl/PlRPC-0.2020-r1  0 kB
[ebuild  N    ] dev-perl/DBI-1.607  0 kB
[ebuild  N    ] dev-db/mysql-5.0.76-r1  USE="perl ssl -berkdb -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal (-selinux) -static" 0 kB
[ebuild  N    ] virtual/mysql-5.0  0 kB
[ebuild  N    ] dev-perl/DBD-mysql-4.01.0  0 kB

Total: 9 packages (9 new), Size of downloads: 0 kB
Comment 9 Zac Medico gentoo-dev 2009-05-04 06:08:38 UTC
If you have problems then try masking whichever package you don't want in /etc/portage/package.mask:

 echo dev-db/mysql >> /etc/portage/package.mask

or

 echo dev-db/mysql-community >> /etc/portage/package.mask
Comment 10 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2009-05-04 06:18:45 UTC
Andrew Szeto: please add yourself to CC if you expect to read responses.
zmedico responded to you.

If you still get the error, please include the full output, so we can review it.