[AMD Official Use Only - General] Thank You Vicentiu!!! It worked. Mysql/lib-03.err contains: 230810 11:49:22 mysqld_safe mysqld from pid file /mysql_data/mysql/lib-daytonax-03.pid ended 230810 11:49:39 mysqld_safe Starting mariadbd daemon with databases from /mysql_data/mysql 2023-08-10 11:49:39 0 [Note] Starting MariaDB 10.11.3-MariaDB source revision 0bb31039f54bd6a0dc8f0fc7d40e6b58a51998b0 as process 3271335 2023-08-10 11:49:39 0 [Warning] option 'table_open_cache_instances': unsigned value 128 adjusted to 64 2023-08-10 11:49:40 0 [ERROR] mariadbd: Can't open shared library '/home/MYSQL/mariadb-10.11.3/maria_bin/lib/plugin/provider_lz4.so' (errno: 2, liblz4.so: cannot open shared object file: No such file or directory) 2023-08-10 11:49:40 0 [ERROR] Couldn't load plugins from 'provider_lz4.so'. 2023-08-10 11:49:40 0 [Warning] mariadbd: Couldn't allocate 130023424 bytes (Large/HugeTLB memory page size 2097152); errno 12; continuing to smaller size 2023-08-10 11:49:40 0 [ERROR] mariadbd: InnoDB: compression algorithm lz4 (2) is not available. Please, load the corresponding provider plugin. 2023-08-10 11:49:40 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-08-10 11:49:40 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-08-10 11:49:40 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-08-10 11:49:40 0 [Warning] 'default-authentication-plugin' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions. 2023-08-10 11:49:40 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2023-08-10 11:49:40 0 [Warning] 'innodb-thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2023-08-10 11:49:40 0 [ERROR] /home/MYSQL/mariadb-10.11.3/maria_bin/bin/mariadbd: unknown variable 'provider_lz4=force_plus_permanent' 2023-08-10 11:49:40 0 [ERROR] Aborting 230810 11:49:40 mysqld_safe mysqld from pid file /mysql_data/mysql/lib-daytonax-03.pid ended It worked with: #sudo LD_LIBRARY_PATH=<path-to-liblz4> ./mysql.server start --user=mysql Thank you again for all your inputs. General question: Is there a way that can used instead of setting LD_LIBRARY_PATH each time when using it form different location. I mean to say one-time setting. In above case I have to use LD_LIBRARY_PATH for each run of scripts. Regards Rahul Raj From: Vicențiu Ciorbaru <vicentiu@mariadb.org> Sent: Thursday, August 10, 2023 3:08 PM To: Raj, Rahul <Rahul.Raj@amd.com> Cc: axel@askmonty.org; discuss@lists.mariadb.org Subject: Re: [MariaDB discuss] Re: Query on Building Maria DB for different Compression Algorithm Caution: This message originated from an External Source. Use proper caution when opening attachments, clicking links, or responding. What are the contents of mysql/lib-03.err? I suspect you need to add LD_LIBRARY_PATH to the script. Also, Based on how you created the datadir, you may have to run mariadbd as root: LD_LIBRARY_PATH=<path-to-liblz4> ./mysql.server start --user=root On Thu, 10 Aug 2023 at 11:54, Raj, Rahul via discuss <discuss@lists.mariadb.org<mailto:discuss@lists.mariadb.org>> wrote: [AMD Official Use Only - General] Hi Axel, I followed your suggestion, and all the error has resolved but it didn't launch the Mariadb server. It throws below error: #sudo ./support-files/mysql.server start Starting MariaDB .230810 08:15:40 mysqld_safe Logging to '/mysql_data/mysql/lib-03.err'. 230810 08:15:40 mysqld_safe Starting mariadbd daemon with databases from /mysql_data/mysql ./support-files/mysql.server: 264: kill: No such process ERROR! Thanks Rahul Raj -----Original Message----- From: Axel Schwenke <axel@askmonty.org<mailto:axel@askmonty.org>> Sent: Sunday, August 6, 2023 8:01 PM To: Raj, Rahul <Rahul.Raj@amd.com<mailto:Rahul.Raj@amd.com>>; discuss@lists.mariadb.org<mailto:discuss@lists.mariadb.org> Subject: Re: [MariaDB discuss] Re: Query on Building Maria DB for different Compression Algorithm Caution: This message originated from an External Source. Use proper caution when opening attachments, clicking links, or responding. On 04.08.2023 11:57, Raj, Rahul via discuss wrote:
1. Can I stop building zlib algorithm? which is building by default, even after passing different plugin like LZ4, snappy etc.,. Any argument in cmake that can be passed to stop compiling ZLIB algorithm.
No. ZLIB is used internally, for example the COMPRESS() SQL function and the compressed client-server protocol. If no zlib is installed, the bundled (with MariaDB source) library is used.
2. Getting below error when linking 3rd party LZ4 library: In the below scenario build compilation is successfully. When trying to run below command to populate data folder to start server, it is throwing error.
*2023-08-02 17:56:58 0 [ERROR] mariadbd: Can't open shared library '/home/mariadb-10.11.3/maria_bin/lib/plugin/provider_lz4.so' (errno: 2, liblz4.so: cannot open shared object file: No such file or directory)*
The error message (from the MariaDB error log) says that liblz4.so could not be loaded by the mariadbd process. Where is it?
I have tried loading LD_LIBRARY_PATH, even that also produce the same result.
LD_LIBRARY_PATH is the right solution if liblz4.so is not in standard path. It must however be set in the environment from which the mariadbd process is started. Try this: #sudo LD_LIBRARY_PATH=/path/to/liblz4 ./scripts/mariadb-install-db --srcdir=/home/mariadb-10.11.3 --plugin-dir=/home/mariadb-10.11.3/maria_bin/lib/plugin --user=mysql It is probably easier to add the path containing liblz4.so to the standard search path for the dynamic linker. This would be in /etc/ld.so.conf or - depending on your Linux distribution - /etc/ld.so.conf.d/. _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org<mailto:discuss@lists.mariadb.org> To unsubscribe send an email to discuss-leave@lists.mariadb.org<mailto:discuss-leave@lists.mariadb.org>