View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000305 | My infrastructure | General | public | 2025-07-04 16:52 | 2025-07-06 13:14 |
| Reporter | dvl | Assigned To | dvl | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Summary | 0000305: What is checking the ports_to_refresh table? | ||||
| Description | Where is this coming from in the logs? statement: SELECT count(*) FROM ports_to_refresh WHERE date_added < now() - interval '1 hour'; Not found in ~/scripts or in ~/modules, didn't see it in the database-schema | ||||
| Tags | No tags attached. | ||||
|
|
It's /usr/local/libexec/nagios-custom/check_freshports_ports_to_refresh It is a Nagios check. I wonder if that table is used any more. |
|
|
Commented out this line:[12:56 dvl-ingress01 dvl /usr/local/etc/nrpe.d] % grep -r ports_to_refresh * freshports-ingress.cfg:command[check_freshports_ports_to_refresh] = /usr/local/libexec/nagios-custom/check_freshports_ports_to_refresh Disabled the Nagios check for 1 week |
|
|
Renamed the table.[13:00 pg01 dvl ~/tmp] % psql freshports.dvl psql (18beta1) Type "help" for help. freshports.dvl=# alter table ports_to_refresh rename to delete_me_ports_to_refresh freshports.dvl-# ; ALTER TABLE freshports.dvl=# |
