I have an issue where our database is receiving ~1000 updates a minute, and often we get an error response: <pre class="prettyprint"><code>TAF: 1297 (HY000) at line 1: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER </code></pre> which appears in our application to our customer. Is there any way to suppress these errors at the MySQL level? As I am not the developer of this application, I am not sure what language is performing the updates, but I presume either shell script or a C program. I am using MySQL: 5.1.44-ndb-7.1.3-cluster-log (2 cluster nodes and 1 cluster mgmt node)

Have you tried using the 'IGNORE' clause in your SQL statements, the documentation for this is here Using the IGNORE clause will downgrade errors to warnings, these warnings are displayed using the 'SHOW WARNINGS;' command

How do I suppress MySQL errors?

Tags:

mysql

I have an issue where our database is receiving ~1000 updates a 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 customer.

Is there any way to suppress these errors at the MySQL level? As I am not the developer of this application, I am not sure what language is performing the updates, but I presume either shell script or a C program.

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

773

asked Jun 06 '12 19:06

Ben Ashton

1 Answers

Have you tried using the 'IGNORE' clause in your SQL statements, the documentation for this is here

Using the IGNORE clause will downgrade errors to warnings, these warnings are displayed using the 'SHOW WARNINGS;' command

answered Oct 05 '22 11:10

Parsa

Related questions
                            
                                Doctrine 1.2 hydration fails with HYDRATION_RECORD, but works with HYDRATION_ARRAY
                            
                                Rails DB rake tasks run but never exit
                            
                                Is there a GUI tool for MYSQL with query builder feature? [closed]
                            
                                Selecting column using REGEXP in MySQL
                            
                                NamedQueries problem with Hibernate
                            
                                MySQL returns all rows with empty string as where clause
                            
                                MySQL function for checking similarity percentage between two texts
                            
                                MY-SQL query to export data in excel file
                            
                                how to create a database schema for storing product search filters
                            
                                Mysql upper limit for count(*)
                            
                                MySQL Query doesn't update rows [closed]
                            
                                I can't read mysql binary log
                            
                                How to load JSON data with jQuery, PHP and MySQL
                            
                                Insert file into mysql Blob
                            
                                Still confused by Java Timestamps etc with MySQL
                            
                                ALTER TABLE with PDO and parameters?
                            
                                Php mysql, pdo and query: why multiple 'query' don't work (in this case)?
                            
                                Simple PHP Voting System
                            
                                Selecting with UNION but limiting every subquery and receiving distinct values
                            
                                Avoid dead lock by ordering explicitly

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With