MySQL Error Logs

akia

Well-known member
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.
 

Earl

Active member
Hi, Im getting this error while im importing vb 3.8 db to xf
Here is my full error log file: http://pastebin.com/DgekSMpE

Running
# rpm -qa mysql*
mysql-5.5.35-1.el6.remi.x86_64

on centos 6.3

any idea????
Edit:
http://xenforo.com/community/threads/mysql-error-when-importing.66386/

Did you do a MySQL upgrade recently?
@digitalpoint Who's the avatar girl. :giggle:
@Floren
She is a Brazilian model named Alessandra Ambrosio
Watch this <3 :p


:p
 
Last edited:
Top