# SQL Error

## post by roland.asmann on Sep 30, 2025

I see this error a couple of times per day in my logs. Seeing it’s an error, I assume that nothing happens on the DB and it will keep filling up the table. Can someone look at this and fix it in the next release?

```yaml
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "LIMIT"
  Position: 151
### The error may exist in com/sonatype/nexus/pro/systemchecks/heartbeat/internal/NodeHeartbeatDAO.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: DELETE FROM node_info_data      WHERE heartbeat_id NOT IN (SELECT DISTINCT heartbeat_id                                    FROM node_heartbeat)       LIMIT 1000 ;
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "LIMIT"
```

## post by hjjuxtr on Oct 3, 2025

I can confirm that it is also present in my installation running nexus OSS 3.83.1-03

## post by laurencet on Oct 3, 2025

There’s a fix planned for 3.85 release 🙂

### New & Unread Topics

| Topic | Replies | Views | Activity |
| --- | --- | --- | --- |
| [Missing column in Settings > Repositories](https://community.sonatype.com/t/missing-column-in-settings-repositories/15680) | [5](https://community.sonatype.com/t/missing-column-in-settings-repositories/15680/1) | 108 | [Oct 2025](https://community.sonatype.com/t/missing-column-in-settings-repositories/15680/6) |
| [Clarification on Request Limits When Upgrading Nexus Repository OSS from v3.37](https://community.sonatype.com/t/clarification-on-request-limits-when-upgrading-nexus-repository-oss-from-v3-37/15682) | [1](https://community.sonatype.com/t/clarification-on-request-limits-when-upgrading-nexus-repository-oss-from-v3-37/15682/1) | 452 | [Oct 2025](https://community.sonatype.com/t/clarification-on-request-limits-when-upgrading-nexus-repository-oss-from-v3-37/15682/2) |
| [Spin up new Nexus instance from scratch - Task Execute Data Repair Plan stops after 0 seconds](https://community.sonatype.com/t/spin-up-new-nexus-instance-from-scratch-task-execute-data-repair-plan-stops-after-0-seconds/15746) | [2](https://community.sonatype.com/t/spin-up-new-nexus-instance-from-scratch-task-execute-data-repair-plan-stops-after-0-seconds/15746/1) | 125 | [Nov 2025](https://community.sonatype.com/t/spin-up-new-nexus-instance-from-scratch-task-execute-data-repair-plan-stops-after-0-seconds/15746/3) |
| [Proxy repo for rhn anyone?](https://community.sonatype.com/t/proxy-repo-for-rhn-anyone/15909) | [3](https://community.sonatype.com/t/proxy-repo-for-rhn-anyone/15909/1) | 117 | [Jan 20](https://community.sonatype.com/t/proxy-repo-for-rhn-anyone/15909/4) |
| [OSS Nexus Helm chart for 3.83.2](https://community.sonatype.com/t/oss-nexus-helm-chart-for-3-83-2/15559) | [1](https://community.sonatype.com/t/oss-nexus-helm-chart-for-3-83-2/15559/1) | 124 | [Sep 2025](https://community.sonatype.com/t/oss-nexus-helm-chart-for-3-83-2/15559/2) |

Topic list, column headers with buttons are sortable.