• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

MySQL Error Logs

akia

Well-known member
#1
I've just been looking at my error logs and they are full of stuff like:

Code:
Jun  9 21:43:48 server mysqld: #011#011#011#011('585', '2291', '1370799444')
Jun  9 21:43:48 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Jun  9 21:44:18 server mysqld: 130609 21:44:18 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. Statement: REPLACE DELAYED INTO xf_search_index
Jun  9 21:44:18 server mysqld: #011#011#011#011(content_type, content_id,
Jun  9 21:44:18 server mysqld: #011#011#011#011title, message, metadata,
Jun  9 21:44:18 server mysqld: #011#011#011#011item_date, user_id, discussion_id)
Jun  9 21:44:18 server mysqld: #011#011#011VALUES
Jun  9 21:44:18 server mysqld: #011#011#011#011('post', 161654, '', 'Baked potato and onion pierogies with sour cream and salsa', '_md_user_585 _md_content_post _md_node_43 _md_thread_2291', 1370810657, 585, 2291)
Jun  9 21:44:18 server mysqld: 130609 21:44:18 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_thread_read
Jun  9 21:44:18 server mysqld: #011#011#011#011(user_id, thread_id, thread_read_date)
Jun  9 21:44:18 server mysqld: #011#011#011VALUES
Jun  9 21:44:18 server mysqld: #011#011#011#011('585', '2291', '1370810657')
Jun  9 21:44:18 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Jun  9 21:46:13 server mysqld: 130609 21:46:13 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_thread_read
Jun  9 21:46:13 server mysqld: #011#011#011#011(user_id, thread_id, thread_read_date)
Jun  9 21:46:13 server mysqld: #011#011#011VALUES
Jun  9 21:46:13 server mysqld: #011#011#011#011('585', '8762', '1370809612')
Jun  9 21:46:13 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Jun  9 21:47:00 server mysqld: 130609 21:47:00 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_thread_read
Jun  9 21:47:00 server mysqld: #011#011#011#011(user_id, thread_id, thread_read_date)
Jun  9 21:47:00 server mysqld: #011#011#011VALUES
Jun  9 21:47:00 server mysqld: #011#011#011#011('2', '8765', '1370810242')
Jun  9 21:47:00 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Jun  9 21:47:00 server mysqld: 130609 21:47:00 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_forum_read
Jun  9 21:47:00 server mysqld: #011#011#011#011(user_id, node_id, forum_read_date)
Jun  9 21:47:00 server mysqld: #011#011#011VALUES
Jun  9 21:47:00 server mysqld: #011#011#011#011('2', '36', '1370810820')
Jun  9 21:47:00 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE forum_read_date = VALUES(forum_read_date)
Jun  9 21:47:21 server mysqld: 130609 21:47:21 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_thread_read
Jun  9 21:47:21 server mysqld: #011#011#011#011(user_id, thread_id, thread_read_date)
Jun  9 21:47:21 server mysqld: #011#011#011VALUES
Jun  9 21:47:21 server mysqld: #011#011#011#011('2', '8762', '1370809612')
Jun  9 21:47:21 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Jun  9 21:47:21 server mysqld: 130609 21:47:21 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_forum_read
Jun  9 21:47:21 server mysqld: #011#011#011#011(user_id, node_id, forum_read_date)
Jun  9 21:47:21 server mysqld: #011#011#011VALUES
Jun  9 21:47:21 server mysqld: #011#011#011#011('2', '4', '1370810841')
Jun  9 21:47:21 server mysqld: #011#011#011ON DUPLICATE KEY UPDATE forum_read_date = VALUES(forum_read_date)
It seems to be coming from the xenforo install. Is it anything I need to be worried about.
 
#5
Last edited: