Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 09 Aug 2019 06:25:21 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 239732] databases/mariadb103-server: Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'
Message-ID:  <bug-239732-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D239732

            Bug ID: 239732
           Summary: databases/mariadb103-server: Variable
                    'innodb_compression_algorithm' can't be set to the
                    value of 'lz4'
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: zhoutao@laocius.org
             Flags: maintainer-feedback?(brnrd@freebsd.org)
          Assignee: brnrd@freebsd.org

lz4 support is missing event if I selected ticked it in poudriere options.
It also shows 'on' in `pkg info`.

```
mariadb103-server-10.3.16_1
Name           : mariadb103-server
Version        : 10.3.16_1
Installed on   : Fri Aug  9 15:17:15 2019 AEST
Origin         : databases/mariadb103-server
Architecture   : FreeBSD:11:amd64
Prefix         : /usr/local
Categories     : databases ipv6
Licenses       : GPLv2
Maintainer     : brnrd@FreeBSD.org
WWW            : https://mariadb.org/
Comment        : Multithreaded SQL database (server)
Options        :
        CONNECT_EXTRA  : on
        DOCS           : on
        GSSAPI_BASE    : off
        GSSAPI_HEIMDAL : on
        GSSAPI_MIT     : off
        GSSAPI_NONE    : off
        INNOBASE       : on
        LZ4            : on
        LZO            : off
        MROONGA        : off
        MSGPACK        : off
        OQGRAPH        : off
        ROCKSDB        : off
        SNAPPY         : off
        SPHINX         : on
        SPIDER         : on
        TOKUDB         : off
        WSREP          : on
        ZMQ            : off
        ZSTD           : off

```

I could see 'liblz4' from ldd output.
```
~ # ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
        liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x80181b000)
        libbz2.so.4 =3D> /usr/lib/libbz2.so.4 (0x801a44000)
        libz.so.6 =3D> /lib/libz.so.6 (0x801c58000)
        libm.so.5 =3D> /lib/libm.so.5 (0x801e70000)
        libexecinfo.so.1 =3D> /usr/lib/libexecinfo.so.1 (0x80209d000)
        libwrap.so.6 =3D> /usr/lib/libwrap.so.6 (0x8022a0000)
        libcrypt.so.5 =3D> /lib/libcrypt.so.5 (0x8024a9000)
        libssl.so.11 =3D> /usr/local/lib/libssl.so.11 (0x8026c8000)
        libcrypto.so.11 =3D> /usr/local/lib/libcrypto.so.11 (0x802a00000)
        libc++.so.1 =3D> /usr/lib/libc++.so.1 (0x802eec000)
        libcxxrt.so.1 =3D> /lib/libcxxrt.so.1 (0x8031ba000)
        libgcc_s.so.1 =3D> /lib/libgcc_s.so.1 (0x8033d9000)
        libthr.so.3 =3D> /lib/libthr.so.3 (0x8035e8000)
        libc.so.7 =3D> /lib/libc.so.7 (0x803810000)
        libelf.so.2 =3D> /lib/libelf.so.2 (0x803bcc000)
```

According to this link
https://mariadb.com/kb/en/library/compression/+comments/2002, the
CMakeCache.txt should contain

```
WITH_INNODB_LZ4:STRING=3DAUTO
HAVE_LZ4_H:INTERNAL=3D1
HAVE_LZ4_SHARED_LIB:INTERNAL=3D1
```
But when I looked at CMakeCache.txt in poudriere, it only had
```
WITH_INNODB_LZ4:BOOL=3Dtrue
```
I think this might be the problem.

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-239732-7788>