How to suppress MySQL errors?

Question

I have a problem when our database receives ~ 1000 updates per minute, and often we get an error response:

TAF: 1297 (HY000) at line 1: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER 

which appears in our application to our client.

Is there any way to suppress these errors at the MySQL level? Since I am not the developer of this application, I am not sure which language performs the updates, but I assume either a shell script or a C program.

I am using MySQL: 5.1.44-ndb-7.1.3-cluster-log (2 cluster nodes and 1 mgmt node cluster)

Answer 1

You tried to use the IGNORE clause in your SQL statements, the documentation for this is here

Using the IGNORE clause will reduce errors to warnings; these warnings are displayed using "WARNINGS"; Team