Comments - Knowledge Base Questions

7 years, 7 months ago Samuel Liang

I had set wsrep_debug=1, than output below log: [Note] WSREP: empty rbr buffer, query: LOAD DATA LOCAL INFILE ... FIELDS TERMINATED BY '\|' OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY '\r\n', affected rows: 1, changed tables: 1, sql_log_bin: 1, wsrep status (3 2 0)

Could you help me?

 
7 years, 7 months ago Samuel Liang

Resolved!

My steps : First, I try open wsrep log via wsrep_debug = 1 on server.cnf Then, from log find "empty rbr buffer" message. Second, I search what is rbr? Its mean is "Row based replication". Next, I find binlog_format have three modes : STATEMENT/ROW/MIXED. Our environment is "STATEMENT", but this mode not support LOAD FILE replication. Must setting to "ROW". So, after testing OK!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.