API Endpoint clearMetricsCache : column "metricname" does not exist

[luddaniel]

Hello Dataverse Team,

We wanted to share a discovered bug using this API :

curl -X DELETE http://localhost:8080/api/admin/clearMetricsCache/downloadsToMonth_2022-10

Log output says Caused by: org.postgresql.util.PSQLException: ERROR: column "metricname" does not exist
Java code is https://github.com/IQSS/dataverse/blob/develop/src/main/java/edu/harvard/iq/dataverse/api/Admin.java#L1971
SQL Query is :

DELETE FROM metric where metricname = ?

metricname column has be renammed in upgrade_v4.10.1_to_v4.11.sql

ALTER TABLE metric RENAME COLUMN metricName TO name;

Maybe there are some other uses of the previous column name.
Regards :)

[pdurbin]

@luddaniel thanks for the bug report and for tracking down where we renamed the database column!

I'm going to give this a size of 3 since it's straightforward:

• it's just changing metricname to name in that query. It's the only instance I can find with the old name.
• add a test to MetricsIT to exercise the delete endpoint