We help IT Professionals succeed at work.

MySQL error

sqldba2013
sqldba2013 asked
on
1,294 Views
Last Modified: 2014-09-10
Hi Experts,

We are getting below error while performing Bulk Insert operation on MySQL DB. Please suggest how to fix below error.

MySQL version : 5.1
NDB version: 7.3.2

Error:
[com.ericsson.reflection.app.dto.TxTaskTagRel]; uncategorized SQLException for SQL [insert into TX_TASK_TAG_REL (ACTIVE, APPEARANCE_MANDATORY, ENTRY_STATE, GUI_COLUMN, GUI_DISPLAY_ORDER, GUI_ROW, INPUT_MANDATORY, OTHER_VALUE, TAG_ID, TAG_LABEL, TAG_VALUE, TX_TASK_ID, VALUE_GROUP_ID, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1297]; Got temporary error 899 'Rowid already allocated' from NDBCLUSTER; nested exception is java.sql.BatchUpdateException: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER"

Please advise.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
We are getting above error when we execute Bulk insert command.

We are not getting error when we insert single row data using insert command
ex:
[insert into TX_TASK_TAG_REL (ACTIVE, APPEARANCE_MANDATORY, ENTRY_STATE, GUI_COLUMN, GUI_DISPLAY_ORDER, GUI_ROW, INPUT_MANDATORY, OTHER_VALUE, TAG_ID, TAG_LABEL, TAG_VALUE, TX_TASK_ID, VALUE_GROUP_ID, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)];

is this error is related to Bug in mysql?
CERTIFIED EXPERT
Top Expert 2013

Commented:
According to the closing comments for the bug report:
- Error code 899 is considered a TEMPORARY error, clients should retry (potentially after a small delay) on encountering it (like with all temp errors)
- Error code 899 may be returned on INSERT operations during node recovery.
- Error code 899 may be returned on INSERT operations on DD tables in 6.3
- All other known causes of error 899 are fixed, but may still be present in older versions
- There may be currently unknown causes of error 899.
I guess the workaround is to retry (potentially after a small delay) on encountering it (like with all temp errors)

Author

Commented:
Once again Thanks for your suggestion.

We are facing below issue from past one month on prod server. Few days back we have retried and its successful and today again we got above error.

We need to fix this error permanently.  Can you share permanent solution for above error?
CERTIFIED EXPERT
Top Expert 2013

Commented:
They say that they fixed it:
We fixed a couple of cases for 899 in 7.2.14. This maintenance version should come out any day from now. I'll be closing this bug now. If you still encounter 899 after the update then we are highly interested to hear from you.
Looks like it still exists. I recommend you contacting the MySQL team directly by logging the bug into their system. You can use the Bug #69938 as a reference to your log
Top Expert 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Please find Mysql version

5.6.11-ndb-7.3.2-cluster-gpl

Please advise on above error.
Top Expert 2015

Commented:
As spotted by other experts before - you should retry if 899 is returned
Also spotted that some 899 is fixed - so upgrade to 7.3.7 may help to avoid 899 but not in all cases
Choose action which is easiest for you.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.