Unable to modify Write Ignore Rules

Overview

Write Ignore is a feature by which a user can instruct ScaleArc not to treat specified queries as Write queries.

ScaleArc users may encounter the following error message while trying to enable or disable Write Ignore Rules:

ERROR: 2281
Failed to update write ignore rule. 501501.

Error_2281.png

Solution

Follow these steps to resolve the issue:

  1. Use the "RESET Configuration Lock" button to reset any unreleased locks on the cluster configuration database.
  2. From the cluster control panel on the ScaleArc UI, identify the cluster-ID of the affected cluster, where Write Ignore rules cannot be modified
  3. Log into ScaleArc instance command-line via SSH
  4. Open the corresponding cluster configuration DB with sqlite3 /system/lb_<cluster_id>.sqlite
  5. Run the following commands for better command line visualization:
    .mod column 
    .headers on
  6. Check the lb_writeignore table for duplicate entries as per the attached screenshot, and delete the duplicate ones with delete from lb_writeignore where id = <id>;​ query.Write_ignore_rules_UI_fix.png
  7. Validate in the UI that the stored procedures can now be enabled and disabled without issues.
  8. Exit SQLite with .quit command.
  9. Exit the SSH session with exit.

Back to top

Comments

0 comments

Please sign in to leave a comment.