mariadb-10.6 installation fails

[jasimon9]

Some background: every few months, my mariadb-10.6-server refuses to run. I am using that version because it is the version installed on our company servers.

The normal workaround is as follows:

• sudo port install mariadb-10.6-server
• this installation always fails
• however mysqld is now running as seen in the process list using ps aux|grep mysqld

As I said this happens every few months, without any change to my system that I can see a pattern.

This time is cannot get past the issue because it has occurred after updating to macOS 13.6.9. After that installation, mariadb has been removed from the system, as indicated by not showing up in port installed.

I have tried to re-install mariadb-10.6 server several times after performing the following steps:

• upgrade MacPorts
• sudo port upgrade outdated
• sudo port clean mariadb-10.6
• sudo port clean mariadb-10.6-server

I get the error message and log details that are posted in the comment.

[jasimon9]

Here is the console error message:

--->  Building mariadb-10.6
Error: Failed to build mariadb-10.6: command execution failed
Error: See /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.6/mariadb-10.6/main.log for details.
Error: Follow https://guide.macports.org/#project.tickets if you believe there
is a bug.
Error: Processing of port mariadb-10.6 failed
iMac3:mariadb jas$ cd /opt/local/var/macp

Here is the tail of the log reference above:

Command failed:  cd "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.6/mariadb-10.6/work/build" && /usr/bin/make -j4 -w all VERBOSE=ON 
:info:build Exit code: 2
:error:build Failed to build mariadb-10.6: command execution failed
:debug:build Error code: CHILDSTATUS 793 2
:debug:build Backtrace: command execution failed
:debug:build     while executing
:debug:build "system {*}$notty {*}$callback {*}$nice $fullcmdstring"
:debug:build     invoked from within
:debug:build "command_exec -callback portprogress::target_progress_callback build"
:debug:build     (procedure "portbuild::build_main" line 10)
:debug:build     invoked from within
:debug:build "$procedure $targetname"
:error:build See /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.6/mariadb-10.6/main.log for details.

[ryandesign (Ryan Carsten Schmidt)]

We need to see the main.log file to be able to speculate what went wrong. Please attach it.

[jasimon9]

I attached the log. I could try the install again with the -d option if you want more debugging info.

[jmroot (Joshua Root)]

:info:build /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mariadb-10.6/mariadb-10.6/work/server-mariadb-10.6.11/storage/connect/libdoc.cpp:368:22: error: assigning to 'xmlErrorPtr' (aka '_xmlError *') from 'const xmlError *' (aka 'const _xmlError *') discards qualifiers
:info:build   } else if ((Xerr = xmlGetLastError()))
:info:build                      ^~~~~~~~~~~~~~~~~

Duplicate of #69428.

[jasimon9]

What is the plan for a workaround to this issue? Abandon mariadb from Macports?