[RHEL5] Invalid MySQL binary log is generated

Issue

• Steps to Reproduce

     1. Enable binary log option
  
       ---- /etc/my.cnf ----
       [mysqld]
       log-bin
       ---------------------
  
     2. Start mysql server
  
       # /etc/init.d/mysqld start
  
     3. Run mysql command
  
       # mysql -u root test < issue.sql
  
     4. Run mysqladmin command
  
       # mysqladmin flush-logs
  
     5. Run php srcript 
  
       # php issue.php
  
     6. Confirm value of serial table
  
       # mysql test
       mysql> select * from serial;
       +----+--------+------------+
       | id | active | utime      |
       +----+--------+------------+
       |  1 |      0 | 1271842640 | 
       +----+--------+------------+
       1 row in set (0.00 sec)
       mysql> quit
  
     7. Restore serial table from binary log
  
       # mysqladmin flush-logs
       # lsof | grep mysqld-bin.00
       mysqld    4759 mysql   11w      REG      253,0       98    663144 /var/lib/mysql/mysqld-bin.000003
       # php issue.php
       # mysqlbinlog --disable-log-bin /var/lib/mysql/mysqld-bin.000003 > mysql-dump.sql
       # mysql -u root test < mysql-dump.sql
  
     8. Confirm value of serial table again
  
       # mysql test
       mysql> select * from serial;
  
     Observed behavior:
  
       mysql> select * from serial;
       +----+--------+------------+
       | id | active | utime      |
       +----+--------+------------+
       |  1 |     48 | 2147483647 | 
       +----+--------+------------+
       1 row in set (0.01 sec)
  
     Desired behavior:
  
       mysql> select * from serial;
       +----+--------+------------+
       | id | active | utime      |
       +----+--------+------------+
       |  1 |      0 | 1271842640 | 
       +----+--------+------------+
       1 row in set (0.00 sec)