asked on
MySQL error
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.a
Please advise.
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.a
Please advise.
MySQL ServerLinuxDatabases
Last Comment
gheist
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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)I guess the workaround is to 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.
ASKER
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?
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?
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
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Please find Mysql version
5.6.11-ndb-7.3.2-cluster-g
Please advise on above error.
5.6.11-ndb-7.3.2-cluster-g
Please advise on above error.
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.
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.
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?