[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> 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>
Sent: Sunday, August 6, 2023 8:01 PM
To: Raj, Rahul <Rahul.Raj@amd.com>; 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
To unsubscribe send an email to discuss-leave@lists.mariadb.org