Hello. When I execute update_stats I obtain:
bin/update_stats --update_users 2013-01-24 18:37:02.6281 Starting Query = update user set expavg_credit=0.089743, expavg_time=1359049022.632601 where id=117542 Database error: Binary logging not possible. Message: Transaction level 'READ-UNCOMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' query=update user set expavg_credit=0.089743, expavg_time=1359049022.632601 where id=117542 2013-01-24 18:37:02.6846 [CRITICAL] Can't update user 117542 2013-01-24 18:37:02.6846 [CRITICAL] update_users failed: Error 1 But, in the database: mysql> SELECT @@global.tx_isolation, @@session.tx_isolation; +-----------------------+------------------------+ | @@global.tx_isolation | @@session.tx_isolation | +-----------------------+------------------------+ | REPEATABLE-READ | REPEATABLE-READ | +-----------------------+------------------------+ 1 row in set (0.00 sec) I know that I solve the problem using binlog mode ROW, but I don't understan why I obtain "Transaction level 'READ-UNCOMMITTED' in InnoDB" when the database is in REPEATABLE-READ best regards. Francisco _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
