> For the complete documentation index, see [llms.txt](https://developer.harness.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.harness.io/continuous-delivery/troubleshooting-and-resources/armory/general/clouddriver-logs-show-slow-sql-warnings.md).

# Clouddriver Logs Show Slow SQL Warnings

### Issue <a href="#issue" id="issue"></a>

Clouddriver logs SQL calls as Slow SQL. An example of such logs can be found below.

```
2021-09-16 12:18:14.692  WARN 1 --- [gentScheduler-0] c.n.s.k.s.telemetry.JooqSlowQueryLogger  : Slow SQL (1800ms):
insert into cats_agent_locks (
  agent_name, 
  owner_id, 
  lock_acquired, 
  lock_expiry
)
values (
  'some-agent-running/KubernetesUnregisteredCustomResourceCachingAgent[1/1]', 
  'spin-clouddriver-123453678:1@spin-clouddriver-123453678', 
  12345678, 
  12345678
)
```

### Cause <a href="#cause" id="cause"></a>

The exact cause of this issue is unclear as we are continuing research on this topic however, we have concluded that this seems to be an issue with the SQL agent scheduler.
