[MacPorts] #72323: mariadb-10.6: fails to run due to missing dependency on lzo2 (was: mariadb-10.6-server fails to run after migrate due to missing dependency on lzo2)

[MacPorts]

#72323: mariadb-10.6: fails to run due to missing dependency on lzo2
---------------------------+-----------------------
  Reporter:  jasimon9      |      Owner:  michaelld
      Type:  defect        |     Status:  assigned
  Priority:  Normal        |  Milestone:
 Component:  ports         |    Version:
Resolution:                |   Keywords:
      Port:  mariadb-10.6  |
---------------------------+-----------------------

Old description:

> With an assist from ChatGPT, I found this in iMac-tmp.log when attempting
> to start mariadb-10.6-server after a port migrate:
>
> 250410 14:52:34 mysqld_safe Starting mariadbd daemon with databases from
> /opt/local/var/db/mariadb-10.6
> dyld[3693]: Library not loaded: /opt/local/lib/liblzo2.2.dylib
>   Referenced from: <55E2626A-BC78-303A-A67F-90AD03518BBD>
> /opt/local/lib/mariadb-10.6/bin/mariadbd
>   Reason: tried: '/opt/local/lib/liblzo2.2.dylib' (no such file),
> '/System/Volumes/Preboot/Cryptexes/OS/opt/local/lib/liblzo2.2.dylib' (no
> such file), '/opt/local/lib/liblzo2.2.dylib' (no such file)
> 250410 14:52:34 mysqld_safe mysqld from pid file
> /opt/local/var/db/mariadb-10.6/Mac.lan.pid ended
>
> ChatGPT suggested installing the lzo2 port. After doing that,
> mariadb-10.6-server ran correctly.
>
> A few contributing factors:
>
> 1. During the port migrate, I answered "yes" to all cleanup prompts—this
> may have removed lzo2.
>
> 2. port reclaim might have removed it as well.
>
> 3. lzo2 is listed as requested in port echo installed requested, so its
> removal was unexpected.
>
> Notably, sudo port load mariadb-10.6-server would succeed, but the daemon
> would silently fail shortly after startup.
>
> It appears the MariaDB server binary links to liblzo2.2.dylib, but no
> corresponding depends_lib entry exists in the mariadb-10.6 Portfile.
> Suggest adding port:lzo2 as a dependency for both mariadb-10.6 and
> mariadb-10.6-server (and perhaps other versions, if affected).

New description:

 With an assist from ChatGPT, I found this in iMac-tmp.log when attempting
 to start mariadb-10.6-server after a port migrate:

 {{{
 250410 14:52:34 mysqld_safe Starting mariadbd daemon with databases from
 /opt/local/var/db/mariadb-10.6
 dyld[3693]: Library not loaded: /opt/local/lib/liblzo2.2.dylib
   Referenced from: <55E2626A-BC78-303A-A67F-90AD03518BBD>
 /opt/local/lib/mariadb-10.6/bin/mariadbd
   Reason: tried: '/opt/local/lib/liblzo2.2.dylib' (no such file),
 '/System/Volumes/Preboot/Cryptexes/OS/opt/local/lib/liblzo2.2.dylib' (no
 such file), '/opt/local/lib/liblzo2.2.dylib' (no such file)
 250410 14:52:34 mysqld_safe mysqld from pid file
 /opt/local/var/db/mariadb-10.6/Mac.lan.pid ended
 }}}

 ChatGPT suggested installing the lzo2 port. After doing that,
 mariadb-10.6-server ran correctly.

 A few contributing factors:

 1. During the port migrate, I answered "yes" to all cleanup prompts—this
 may have removed lzo2.

 2. port reclaim might have removed it as well.

 3. lzo2 is listed as requested in port echo installed requested, so its
 removal was unexpected.

 Notably, sudo port load mariadb-10.6-server would succeed, but the daemon
 would silently fail shortly after startup.

 It appears the MariaDB server binary links to liblzo2.2.dylib, but no
 corresponding depends_lib entry exists in the mariadb-10.6 Portfile.
 Suggest adding port:lzo2 as a dependency for both mariadb-10.6 and
 mariadb-10.6-server (and perhaps other versions, if affected).

--

Comment (by ryandesign):

 The dependency would belong in mariadb-10.6 not mariadb-10.6-server.

-- 
Ticket URL: <https://trac.macports.org/ticket/72323#comment:2>
MacPorts <https://www.macports.org/>
Ports system for macOS