Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏：（零和博弈）/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界，因为，这个世界从没有变，它只是越来越趋近于它本来的模样。
官方网站：
www.haproxy.org
源码包下载地址：
http://download.openpkg.org/components/cache/haproxy/
https://src.fedoraproject.org/repo/pkgs/haproxy/
安装HAProxy的方法很多，比方说：
在R[……]
Adamhuan
错误发生在使用Python的模块包【pymysql】连接MySQL数据库的时候，具体的错误信息如下：
发生这个问题的时候，代码内容如下：
解决方法：
安装Python的模块包：cryptography
安装完成后，再次执行，就没问题了：
[……]
Adamhuan
在MySQL中，通过select的into outfile子句将结果集导出到一个文本文件的时候，你可能会遇到如题所示的错误。
关于该错误具体的现象如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
先查看下我的目标表： mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | lean_code | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.05 sec) mysql> use lean_code Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +---------------------+ | Tables_in_lean_code | +---------------------+ | department | | employee | +---------------------+ 2 rows in set (0.00 sec) mysql> mysql> select * from employee; +------+-------+--------+--------------+ | id | name | salary | departmentid | +------+-------+--------+--------------+ | 1 | joe | 70000 | 1 | | 2 | henry | 80000 | 2 | | 3 | sam | 60000 | 2 | | 4 | max | 90000 | 1 | | 5 | jim | 90000 | 1 | +------+-------+--------+--------------+ 5 rows in set (0.00 sec) mysql> 执行【select .. into outfile ...】 mysql> select * from employee into outfile 'table_employee'; ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement mysql> |
可以看到，报错了。
让我们看看报错提示里面的选项【opt[……]
Adamhuan
如题所示的错误发生在Percona的PXC的非正常关库的时候，具体如下：
报错内容：
|
1 2 3 |
[root@percona-mysql-01 mysql]# systemctl start mysql@bootstrap.service Job for mysql@bootstrap.service failed because the control process exited with error code. See "systemctl status mysql@bootstrap.service" and "journalctl -xe" for details. [root@percona-mysql-01 mysql]# |
日志的内容：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
2020-04-08T17:25:30.561290Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-04-08T17:25:30.563500Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.28-31-57-log) starting as process 19499 ... 2020-04-08T17:25:30.567587Z 0 [Note] WSREP: Setting wsrep_ready to false 2020-04-08T17:25:30.567619Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2020-04-08T17:25:30.567637Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so' 2020-04-08T17:25:30.570609Z 0 [Note] WSREP: wsrep_load(): Galera 3.41(rb3295e6) by Codership Oy <info @codership.com> loaded successfully. 2020-04-08T17:25:30.570848Z 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-04-08T17:25:30.571685Z 0 [Note] WSREP: Found saved state: f0ae4bd5-78c7-11ea-a173-6a64eeb13518:12, safe_to_bootstrap: 0 2020-04-08T17:25:30.573689Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.72.21; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 9; socket.checksum = 2; socket.recv_buf_size = 212992; 2020-04-08T17:25:30.589323Z 0 [Note] WSREP: GCache history reset: f0ae4bd5-78c7-11ea-a173-6a64eeb13518:0 -> f0ae4bd5-78c7-11ea-a173-6a64eeb13518:12 2020-04-08T17:25:30.589940Z 0 [Note] WSREP: Assign initial position for certification: 12, protocol version: -1 2020-04-08T17:25:30.589978Z 0 [Note] WSREP: Preparing to initiate SST/IST 2020-04-08T17:25:30.589989Z 0 [Note] WSREP: Starting replication 2020-04-08T17:25:30.590021Z 0 [Note] WSREP: Setting initial position to f0ae4bd5-78c7-11ea-a173-6a64eeb13518:12 2020-04-08T17:25:30.590043Z 0 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates. To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1 . 2020-04-08T17:25:30.590053Z 0 [ERROR] WSREP: Provider/Node (gcomm://192.168.72.21,192.168.72.22,192.168.72.23) failed to establish connection with cluster (reason: 7) 2020-04-08T17:25:30.590059Z 0 [ERROR] Aborting 2020-04-08T17:25:30.590086Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-04-08T17:25:30.590114Z 0 [Note] WSREP: Waiting for active wsrep applier to exit 2020-04-08T17:25:30.590126Z 0 [Note] WSREP: Service disconnected. 2020-04-08T17:25:30.590153Z 0 [Note] WSREP: Waiting to close threads...... 2020-04-08T17:25:35.593634Z 0 [Note] WSREP: Some threads may fail to exit. 2020-04-08T17:25:35.593770Z 0 [Note] Binlog end 2020-04-08T17:25:35.593988Z 0 [Note] /usr/sbin/mysqld: Shutdown complete </info> |
解法：
[crayon-5f98[……]
Adamhuan