Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 779385 - dev-db/mysql-8.0.23 failed start mysqld after install
Summary: dev-db/mysql-8.0.23 failed start mysqld after install
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: AMD64 Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-30 14:17 UTC by Jan Baklo
Modified: 2021-04-12 13:48 UTC (History)
1 user (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 Jan Baklo 2021-03-30 14:17:08 UTC
The package dev-db/mysql-8.0.23 has been installed successfully.

an attempt to start this service "/etc/init.d/mysql start" displays console errors:
 * Checking mysqld configuration for mysql ...
/usr/sbin/mysqld: error while loading shared libraries: libevent_core-2.1.so.6: cannot open shared object file: No such file or directory
 * mysql config check failed                                                                                                           * ERROR: mysql failed to start

After manually creating a link to the required library:

ln -s /usr/lib64/libevent_core-2.1.so.6.0.0 /usr/lib64/libevent_core-2.1.so.6, 

the next run throws the same error but with another lib: libevent_pthreads-2.1.so.6, after the same manual creating soft link:

ln -s /usr/lib64/libevent_pthreads-2.1.so.6.0.0 /usr/lib64/libevent_pthreads-2.1.so.6, 

next try give the blocked issue:
/usr/sbin/mysqld: error while loading shared libraries: libcrypto.so.1.0.0: cannot open shared object file: No such file or directory

the library libcrypto.so.1.0.0 does not installed, but installed libcrypto.so.1.1.


Reproducible: Always
Comment 1 Thomas Deutschmann (RETIRED) gentoo-dev 2021-04-11 17:57:18 UTC
Please check your system. Looks like a lot of packages are broken.

Re-emerge all dev-db/mysql deps...
Comment 2 Thomas Deutschmann (RETIRED) gentoo-dev 2021-04-11 18:00:18 UTC
PS: dev-libs/libevent-2.1.11::gentoo is *.so.7.0.0 -- not *.so.6.0.0. Time for a world upgrade?
Comment 3 Jan Baklo 2021-04-11 19:14:35 UTC
(In reply to Thomas Deutschmann from comment #1 #2)
> Please check your system. Looks like a lot of packages are broken.
> Re-emerge all dev-db/mysql deps...
> PS: dev-libs/libevent-2.1.11::gentoo is *.so.7.0.0 -- not *.so.6.0.0. Time
> for a world upgrade?


when I installed mysql, there were no conflicts when updating the world, and a full update was made a few hours before installing mysql.

some of the library packages on the system are indeed manually installed and it looks like mysql was built with older versions, but --depclean finds nothing to clean up and mysql rebuilding doesn't change anything. 

ldd /usr/sbin/mysqld
	libevent_core-2.1.so.6 => /usr/lib64/libevent_core-2.1.so.6 (0x00007fe6ab02e000)
	libevent_pthreads-2.1.so.6 => /usr/lib64/libevent_pthreads-2.1.so.6 	libssl.so.1.1 => /usr/lib64/libssl.so.1.1 (0x00007fe6aacce000)
        .... cuted ....
	libcrypto.so.1.1 => /usr/lib64/libcrypto.so.1.1 (0x00007fe6aaa10000)
	libcrypto.so.1.0.0 => not found
	libcrypto.so.1.0.0 => not found

notice the output of ldd on the last two lines. why?
Comment 4 Thomas Deutschmann (RETIRED) gentoo-dev 2021-04-11 20:03:38 UTC
Well, your system seems to be broken/in frankenstein state. It's not a problem in dev-db/mysql package. I can only recommend to cleanup and upgrade entire world to get in sync with ::gentoo repository.

If you believe this is a problem in dev-db/mysql package, please describe how to reproduce the problem using a clean stage3 image.
Comment 5 Jan Baklo 2021-04-12 05:45:39 UTC
(In reply to Thomas Deutschmann from comment #4)
> Well, your system seems to be broken/in frankenstein state. It's not a
> problem in dev-db/mysql package. I can only recommend to cleanup and upgrade
> entire world to get in sync with ::gentoo repository.

not such a big mess as you imagined, everything "superfluous" is in a specially places:

revdep-rebuild

 !!! Broken orphaned files: No installed package was found for the following:
	* /usr/local/lib64/libevent_pthreads-2.1.so.6.0.0
	* /usr/local/lib64/libevent-2.1.so.6.0.0
	* /usr/local/lib64/libevent_openssl-2.1.so.6.0.0
	* /usr/local/lib64/libwinpr-tools2.so.2.0.0
	* /usr/local/lib64/libwinpr2.so.2.0.0
	* /usr/local/lib64/libevent_core-2.1.so.6.0.0
	* /usr/local/lib64/libevent_extra-2.1.so.6.0.0

emerge did not report any conflicts

> If you believe this is a problem in dev-db/mysql package, please describe
> how to reproduce the problem using a clean stage3 image.

i have fixed the issue by temporary renames this folders: /usr/local/lib && /usr/local/lib64 before start rebuilding of mysql package.
now i understand that it was my personal issue, and if during building system packages is considered as normal to include libraries from /usr/local, then the bug can be closed.

Thank you for the hints.
Comment 6 Thomas Deutschmann (RETIRED) gentoo-dev 2021-04-12 13:48:49 UTC
Glad you found the solution. Thank you for the feedback.

I am closing issue as INVALID because problem wasn't in dev-db/mysql package.