Getting error with this Mysql version mysql-5.1.73-3

[Blason R]

Hi Guys,

I am facing issue with this particular mysql version
mysql-server-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64


I do have a application which uses mysql as back end.

This application works when mysql version is
mysql-devel-5.1.61-4.el6.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-libs-5.1.61-4.el6.x86_64
mysql-5.1.61-4.el6.x86_64
mysql-server-5.1.61-4.el6.x86_64

but as soon as I upgrade it it starts giving below error. Any idea why?

13:05:13.085 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:200 - Connection failed. Attempting to recover transaction on Thread #86
13:05:13.108 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 100. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:18.127 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 99. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:23.147 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 98. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:28.167 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 97. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:33.189 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 96. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:38.206 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 95. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:43.217 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 94. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:48.242 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 93. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:53.258 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay transaction. Sleeping for 5000ms and trying again. Attempts left: 92. Exception:
java.sql.BatchUpdateException: Table has no partition for value 736045
13:05:58.275 [ERROR] com.jolbox.bonecp.MemorizeTransactionProxy:342 - Failed to replay tr


I googled a lot and found that startup script under /etc/init.d is some how giving this error which might not be compatible with 5.1.73

mysql statistics --user=mxhero --password=mxhero -e "ALTER EVENT drop_stats_parts ON SCHEDULE EVERY 1 DAY; ALTER EVENT drop_records_parts ON SCHEDULE EV
ERY 1 DAY;ALTER EVENT add_stats_parts ON SCHEDULE EVERY 1 DAY; ALTER EVENT add_records_parts ON SCHEDULE EVERY 1 DAY; ALTER EVENT group_all_stats ON SCHEDULE EVERY 5 MINUTE; USE mxhero; ALTER EVENT update_bandwidth_event ON SCHEDULE EVERY 1 DAY;"