SQL Error

Sonatype Nexus Repository
1

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?

### 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"
2

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

3

There’s a fix planned for 3.85 release :slightly_smiling_face: