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

MySQL Error Logs

Discussion in 'Server Configuration and Hosting' started by akia, Jun 9, 2013.

  1. akia

    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.
     
  2. akia

    akia Well-Known Member

    Anyone?
     
  3. digitalpoint

    digitalpoint Well-Known Member

    Edit your my.cnf file, and change your binlog format to mixed.

    Code:
    binlog-format = MIXED
     
    Lee Burnett likes this.
  4. Floren

    Floren Well-Known Member

    Did you do a MySQL upgrade recently?
    @digitalpoint Who's the avatar girl. :giggle:
     
  5. Earl

    Earl Member

    Last edited: Jan 10, 2014
    Floren and fEaRz like this.

Share This Page