[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 <[email protected]> Sent: Thursday, August 10, 2023 3:08 PM To: Raj, Rahul <[email protected]> Cc: [email protected]; [email protected] 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> Sent: Sunday, August 6, 2023 8:01 PM To: Raj, Rahul <[email protected]<mailto:[email protected]>>; [email protected]<mailto:[email protected]> 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 -- [email protected]<mailto:[email protected]> To unsubscribe send an email to [email protected]<mailto:[email protected]>
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
