Specifying both starttime and endtime values crashes the arp API endpoint

Bug #1619136 reported by Morten Brekkevold
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Network Administration Visualized
Fix Released
Medium
Morten Brekkevold

Bug Description

If attempting to access the API endpoint `arp`, using both a starttime and an endtime value, causes an unhandled PostgreSQL error (NAV's "Ouch" page appears).

The PostgreSQL error looks like this:

ERROR: function pg_catalog.overlaps(timestamp without time zone, timestamp without time zone, unknown, unknown) is not unique at character 59
HINT: Could not choose a best candidate function. You might need to add explicit type casts.

Using both starttime and endtime values produces a query using the PostgreSQL OVERLAPS keyword, but since the timestamps are given as strings, PostgreSQL is having trouble choosing the correct typecasting function to fit with the OVERLAPS keyword.

The strings should explicitly be cast to timestamps to avoid this issue.

Revision history for this message
Morten Brekkevold (mbrekkevold) wrote :
Changed in nav:
status: In Progress → Fix Committed
Changed in nav:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.