Shulou(Shulou.com)06/01 Report--

1: Missing libaio package, libaio is an asynchronous non-blocking interface for reading and writing files under Linux.

[root@12 MySQL]# ./ scripts/mysql_install_db --user=mysql --datadir=/data/mysqlInstalling MySQL system tables..../ bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

Solution: Install ↓

Solution：yum -y install libaio-devel

2: Missing openssl package

[root@12 mysql]# ./ scripts/mysql_install_db --user=mysqlInstalling MySQL system tables..../ bin/mysqld: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory

Solution: First check all $PATH directories to see if they contain libssl* link library, if yes, you can make soft links to change the name, if not, install ↓

Solution：yum -y install openssl-devel

[root@12 mysql]# cd /usr/lib[root@12 lib]# ls libssl.solibssl.so[root@12 lib]# ln -s libssl.so libssl.so.6[root@12 lib]#ln -s libcrypto.so libcrypto.so.6

3: During installation, check configuration file for errors

[root@12 mysql]# ./ scripts/mysql_install_db --defaults-file=my_wresp.cnf --user=mysqlInstalling MySQL system tables... 131213 17:13:28 [ERROR] WSREP: Query cache is not supported (size=67108864 type=1)131213 17:13:28 [ERROR] Aborting

Solution: During the test process, you can modify it according to the error message. As for the reason, you can calculate it afterwards.

Solution: Remove all query cache related configuration options

[root@12 ]# cat /etc/my.cnf | grep queyr_cachequery_cache_size = 64Mquery_cache_limit = 2M

4: Same treatment as above

131213 18:03:21 [ERROR] WSREP: Parallel applying (wsrep_slave_threads > 1) requires innodb_autoinc_lock_mode = 2.131213 18:03:21 [ERROR] Abortingadd in my_wsrep.cnf：innodb_autoinc_lock_mode=2

5: Lack of relevant modules

131215 0:15:31 [Note] WSREP: Requesting state transfer: success, donor: 0tar: This does not look like a tar archivetar: Exiting with failure status due to previous errorsWSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 0 2 (20131215 00:15:34.320)WSREP_SST: [ERROR] Cleanup after exit with status:32 (20131215 00:15:34.332)WSREP_SST: [INFO] Removing the sst_in_progress file (20131215 00:15:34.349)131215 0:15:34 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.1.46' --auth '' --datadir '/usr/local/mysql/var/' --defaults-file '/etc/my.cnf' --parent '2714': 32 (Broken pipe)131215 0:15:34 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.131215 0:15:34 [ERROR] WSREP: SST failed: 32 (Broken pipe)131215 0:15:34 [ERROR] Aborting

Solution :

#yum install perl-Time-HiRes#yum -y install perl-DBD-MySQL.x86_64#yum -y install libaio*

6. Port occupied

WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | tar xfi - --recursive-unlink -h; RC=( ${PIPESTATUS[@]} ) (20140128 15:35:07.478)2014/01/28 15:35:07 socat[10521.3077941584] E bind(11, {AF=2 0.0.0.0:4444}, 16): Address already in usetar: This does not look like a tar archivetar: Exiting with failure status due to previous errors

Solution, find the program occupying the port, kill (more violent, you can also change the port, but the initial installation is simple, violent)

Solution：

[root@12 ~]# lsof -i :4444 lsof: no pwd entry for UID 503 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME lsof: no pwd entry for UID 503 socat 5256 503 11u IPv4 13450 0t0 TCP *:krb524 (LISTEN) [root@12 ~]# kill -9 5256 [root@12 ~]# lsof -i :4444 [root@12 ~]# lsof -i :4444

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.