Development

What’s in the pipeline, how it works, how it’s made…

DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version.

Shortly after moving the jail dvl-ingress01 from Python 3.11 to Python 3.12, I started seeing these messages: The code in question ( link to source) is This should be easy enough to replace, knowing python. First, reproduce the problem With any change to fix a problem, I must first be able to reproduce the problem. […]

DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Read More »

How FreshPorts processes vuxml entries

One of my favorite FreeBSD features is security/vuxml – from it we get these great tools (provided by pkg): * pkg audit (what installed packages contain known vulnerabilities?) * /usr/local/etc/periodic/security/410.pkg-audit – pkg-audit for host and jails * /usr/local/etc/periodic/security/405.pkg-base-audit – same as above, but for base system I use the latter two command within my monitoring

How FreshPorts processes vuxml entries Read More »

Time to clear out the distfiles

It’s time to clear old distfiles. Based on Moving distfiles to a new filesystem & deleting unused distfiles, I did the following on the aws-1-ingress01 jail. In short: fetch index list DISTFILES used by index remove DISTFILES not used by index The commands: root@freshports:/usr/ports # make fetchindex /usr/bin/env fetch -am -o /usr/ports/INDEX-14.xz https://download.FreeBSD.org/ports/index/INDEX-14.xz /usr/ports/INDEX-14.xz 1864

Time to clear out the distfiles Read More »

Moving distfiles to a new filesystem & deleting unused distfiles

FreshPorts pulls down a lot of distfiles (the file distributed by the software author which contains the software). Much more than your average user. Every distfile for every commit is fetched. Let’s look at my private FreshPorts development instance: [13:18 dvl-ingress01 dvl /jails/freshports/usr/ports] % du -ch -d 0 distfiles 125G distfiles 125G total That’s 125GB.

Moving distfiles to a new filesystem & deleting unused distfiles Read More »

devel/py-pygit2: AttributeError: ‘_pygit2.Commit’ object has no attribute ‘oid’. Did you mean: ‘id’?

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

devel/py-pygit2: AttributeError: ‘_pygit2.Commit’ object has no attribute ‘oid’. Did you mean: ‘id’? Read More »

Using triggers to update a table with calculated values

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 »

Scroll to Top