Skip to content

In HA failed SQL query block whole OpenNebula #7025

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
3 tasks
paczerny opened this issue Apr 11, 2025 · 0 comments · May be fixed by OpenNebula/docs#3250
Closed
3 tasks

In HA failed SQL query block whole OpenNebula #7025

paczerny opened this issue Apr 11, 2025 · 0 comments · May be fixed by OpenNebula/docs#3250

Comments

@paczerny
Copy link
Member

/!\ To report a security issue please follow this procedure:
[https://github.com/OpenNebula/one/wiki/Vulnerability-Management-Process]

Description
In HA environment. If there is a bug in write SQL query. The query is stored in replication queue, but as it fails, it's never replicated. The oned.log continuously show SQL error. It's not possible to create or modify any other resource.

To Reproduce
Let's use bug #6950, create VM with \t character in name. In HA setup:

onevm create --name a --cpu 1 --memory 128
onevm rename a "	b"     # This command fails as expected due to #6950
oneuser create a a             # This command should be executed normaly, but it fails

The oned.log continuously shows error in SQL query

Expected behavior
OpenNebula should detect failed SQL query on leader and should not replicate it on followers

Details

  • Affected Component: oned, HA
  • Version: master, 7.0

Additional context

Progress Status

  • Code committed
  • Testing - QA
  • Documentation (Release notes - resolved issues, compatibility, known issues)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants