You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by "KuasarCloud (via GitHub)" <gi...@apache.org> on 2025/09/02 21:01:27 UTC
[I] Recurrent insert errors in database on vm schedules [cloudstack]
KuasarCloud opened a new issue, #11564:
URL: https://github.com/apache/cloudstack/issues/11564
### problem
After creating a schedule to start/stop vm_instances, a recurrent error appears in logs
025-07-17 11:29:19,383 ERROR [o.a.c.v.s.d.VMScheduledJobDaoImpl] (VMSchedulerPollTask:[ctx-d11d1302]) (logid:c3157b08) DB Exception on: HikariProxyPreparedStatement@614529765 wrapping com.mysql.cj.jdbc.ServerPreparedStatement[6379]: INSERT INTO vm_scheduled_job (vm_scheduled_job.uuid, vm_scheduled_job.vm_id, vm_scheduled_job.vm_schedule_id, vm_scheduled_job.async_job_id, vm_scheduled_job.action, vm_scheduled_job.scheduled_timestamp) VALUES (x'65396330306236652d626463622d346430612d396162332d663466636136343536356130', 293, 120, NULL, 'STOP', '2025-07-18 04:00:00') java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '120-2025-07-18 04:00:00' for key 'vm_schedule_id'
I have two management host running with ACS 4.20.1 with KVM Hypervisors. Any clue what is trying to insert it again in the database?
### versions
Version
======
ACS 4.20.1
KVM Hyps
Ceph Storage
VPC Tiers
### The steps to reproduce the bug
1. Have 2 ACS management server running
2. Create a VM
3. Schedule START / STOP
### What to do about it?
It appears to be a race condition error caused by multiple scheduler instances running concurrently. We have two ACS Server Manager nodes, and when a scheduled task is created on one node, the other node throws an error — and the same happens in reverse.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Recurrent insert errors in database on vm schedules [cloudstack]
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #11564:
URL: https://github.com/apache/cloudstack/issues/11564#issuecomment-3784430053
fixed by #12428
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Recurrent insert errors in database on vm schedules [cloudstack]
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #11564:
URL: https://github.com/apache/cloudstack/issues/11564#issuecomment-3248586955
also see #11238
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Recurrent insert errors in database on vm schedules [cloudstack]
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland closed issue #11564: Recurrent insert errors in database on vm schedules
URL: https://github.com/apache/cloudstack/issues/11564
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org