Today I updated the test ingress node of FreshPorts. Not long after, I was told by Nagios monitoring: I had a similar message comparing test to stage. Soon after, I saw this error in the logs: Oct 19 12:18:04 test-ingress01 dvl[12403]: FATAL eror with git-to-freshports-xml.py result: 1 – check git-delta.sh logs for more detail Looking […]
This post is mostly me putting thoughts down as I work through this problem. As part of fixing a recent issue, I want to manually trigger the importing of a new package repo into FreshPorts. The check for new repos is performed by this periodic script: Aug 17 01:00:06 dvl-ingress01 FreshPorts[80429]: into /usr/local/etc/periodic/hourly/900.freshports-check-repos-for-new-builds That shell
Manually triggering a package import Read More »
Here are the updates installed late last night. This was into stage.freshports.org. Why? Because they were waiting. I usually prefer to get things installed instead of delaying. Other hosts, but not all, were also updated. Why not all? I didn’t want to. ;) Of note, this goes from Perl 5.36 to Perl 5.38. I updated
Update some packages – nothing [seems to have] broke! Read More »
I went to work on a brilliant new idea for a FreshPorts feature and I immediately hit a snag on my dev system. I noticed that the package importing system had not run anything recently. The reason why was in the logs: In this post: FreeBSD 14.0 PostgresQL 16.1 py39-psycopg2-2.9.9 Python 3.9.18 First, why did
could not open certificate file “/root/.postgresql/postgresql.crt”: Permission denied Read More »
Overnight, these messages appeared in the dev.freshports logs. This is not the first time this has happened. EDIT: 2024-02-18 – it was ZFS snapshot related. These directories each have a ZFS file system behind them. The cache is cleared by zfs rollback. My solution: destroy the snapshot I was rolling back to, change the permissions,
cache permissions are wrong; they were correct Read More »
There is no solution here. I’m documenting for future such events. From time to time, I’ve been seeing this message in the logs: Today, I decided to look into why. In /var/log/freshports/freshports.log, I found: OK, so those are the repos which it thinks needs importing. Let’s pick one ABI and research FreeBSD:12:aarch64. Above that entry,
No repos need importing. How did this happen? This should never happen. Read More »
Today, the UI on the website was updated. The primary changes are to the home page and the date pages (i.e. lists of commits). I have purposely not cleared the cache. This should help you see the before and after images. For comparison, see today’s commits and the commits from Dec 16. This latest work
My thanks go out the AWS team who deal with the credits for open source projects. FreshPorts hit a big problem in Sep/Oct and I thought the project was going to have a non-trivial bill to pay. The main FreshPorts nodes are hosted on AWS – there are other nodes. Despite my own shortcomings (see
This was originally written in September 2018, but never published (for unknown reasons). I found it in the drafts section of the website today. In this post, you will see me change approach and not use a secondary table in one instance, but use multiple secondary tables in another. In one case, you will also
Using triggers to update a table with calculated values Read More »
I’m so very happy about recent changes to the website. It’s been a great day. I was volunteering at a flu shot clinic. A new coffee shop has opened up, and I was there before the clinic. After the clinic, it was walking the dog, then some serious changes to the the PostgreSQL queries which
Great changes to the websites Read More »