Bug 709624 – =dev-db/mysql-{5.7.29,8.0.19-r1} stabilization

• Product: Gentoo Linux
• Status: RESOLVED OBSOLETE

[Description Thomas Deutschmann (RETIRED) 2020-02-14 16:12:24 UTC]

@ arches,

please test and mark stable:

=dev-db/mysql-5.7.29 amd64 arm arm64 ia64 ppc ppc64 x86
=dev-db/mysql-8.0.19-r1 amd64 arm arm64 ia64 ppc ppc64 x86


# Official test instructions:
ulimit -n 16500 && \
USE='perl server' \
FEATURES='test userpriv -usersandbox' \
ebuild mysql-X.X.XX.ebuild \
digest clean package

Note: <mysql-8 will need USE=latin1 for tests!

[Comment 1 Mikle Kolyada (RETIRED) 2020-02-15 12:13:16 UTC]

amd64 stable

[Comment 2 Manfred Knick 2020-02-16 14:22:27 UTC]

(In reply to Mikle Kolyada from comment #1)

Missing `/var/run/mysqld/mysql.pid'

DETECTED by follow-up-error (akonadi fails to start)

$ cd /usr/portage/dev-db/mysql

$ ulimit -n 16500 && USE='perl server' FEATURES='test userpriv -usersandbox' ebuild mysql-8.0.19-r1.ebuild digest clean package

RESULT:

Unit tests: 100% tests passed, 0 tests failed out of 19

Completed: Failed 7/4779 tests, 99.85% were successful.

Failing test(s): 
main.type_timestamp_myisam main.events_1 main.loaddata_special main.with_recursive main.log_options_cmdline main.myisam_explain_json_non_select_none main.myisam_explain_json_non_select_all

BUT:

# /etc/init.d/mysql start --verbose

 * Executing: /lib/rc/sh/openrc-run.sh /lib/rc/sh/openrc-run.sh /etc/init.d/mysql start

 * Checking mysqld configuration for mysql ...                                                                                                                                                                                                                                                         [ ok ]

 * Starting mysql ...

 * start-stop-daemon: fopen `/var/run/mysqld/mysql.pid':  <-------------- ! 
                      No such file or directory           <-------------- !

 * Detaching to start `/usr/sbin/mysqld' ...

 *   start-stop-daemon: /usr/sbin/mysqld died                                                                                                                                                                                                                                                          [ !! ]

 * ERROR: mysql failed to start


#   cat /var/log/mysql/mysqld.err

... 0 [System] [] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 23080
... 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
... 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
... 1 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
... 1 [ERROR] [MY-012646] [InnoDB] File ./ibdata1: 'open' returned OS error 71. Cannot continue operation
... 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.


# lla /var/run/mysqld/
insgesamt 0
drwxr-xr-x  2 mysql mysql   40 16. Feb 11:39 .
drwxr-xr-x 26 root  root  1,1K 16. Feb 11:39 ..

Please, let mw know if you need the log files from the test run,
or whatever might be more helpful. Thanks.

[Comment 3 Manfred Knick 2020-02-16 15:18:58 UTC]

Cross-Reference: Bug 709812

[Comment 4 Thomas Deutschmann (RETIRED) 2020-02-16 15:20:08 UTC]

@Manfred: Please file an own bug for your problem. Keep in mind that you cannot just install dev-db/mysql and start it. You will have to use `emerge --config dev-db/mysql` first to initialize data dir.

[Comment 5 Manfred Knick 2020-02-16 15:37:58 UTC]

(In reply to Thomas Deutschmann from comment #4)

This is not a new install, but a problem induced along the upgrade.

In consequence,

# emerge --config dev-db/mysql     correctly fails with

...
 * Looks like your data directory '/var/lib/mysql' is already initialized! <---!
...

[Comment 6 Thomas Deutschmann (RETIRED) 2020-02-16 21:15:31 UTC]

x86 stable

[Comment 7 Agostino Sarubbo 2020-02-17 15:24:02 UTC]

ppc64 stable

[Comment 8 Agostino Sarubbo 2020-03-05 11:08:50 UTC]

arm stable

[Comment 9 Agostino Sarubbo 2020-03-31 12:36:07 UTC]

ia64 will pass. See https://archives.gentoo.org/gentoo-dev/message/edaadc85d7423810dd6ecfeda29cc85f

[Comment 10 Sam James 2020-04-22 22:01:12 UTC]

@arm64, @ppc: ping

[Comment 11 Thomas Deutschmann (RETIRED) 2020-05-02 12:14:39 UTC]

Superseded by bug 717628.