Bug fixes – Page 3 – FreshPorts News

Mail sending failures

1 Comment / Bug fixes, Reports / Dan Langille

After enabling the report notifications yesterday, they failed to go out. Why? A hardcoded hostname in a Perl module. Here are the errors I found this morning. from=’FreshPorts Watch Daemon <FreshPorts-Watch@FreshPorts.org>’ to=’dvl@example.org’ subject=’FreshPorts daily new ports’ could not open Email::Sender. from=’FreshPorts Watch Daemon <FreshPorts-Watch@FreshPorts.org>’ to=’dvl@example.org’ subject=’FreshPorts daily new ports’ errorcode=’unable to establish SMTP connection to […]

Mail sending failures Read More »

procedure OK under 10.6 but starts acting up under 11.1

Leave a Comment / Bug fixes, Development, Functions, PostgreSQL, Stored procedures, Trigger / Dan Langille

I originally documented this so I would have a reference while tracking down the problem. I have since solved the issue and you can jump to the bottom of this post to find the solution. What I do not know is why this was not an issue under PostgreSQL 10.6 but was under PostgreSQL 11.1.

procedure OK under 10.6 but starts acting up under 11.1 Read More »

Sudden sanity test failures

Leave a Comment / Bug fixes, Forensics / Dan Langille

Today, FreshPorts broke. No commits were being processed. nullfs mounts were disappearing. No idea why. Let’s follow the clues. All times are local to me (Philadelphia). 12:46 pm Rene contacted me on IRC, presumably about a failed sanity test I had seen earlier in the day: You can look at Rene’s commit. Looking back, Rene’s

Sudden sanity test failures Read More »

Duplicate dependency issues – avoiding duplicate rows

Leave a Comment / Bug fixes, Dependencies, PostgreSQL / Dan Langille

Databases use relational integrity to enforce expected situations. A common scenario is duplicates. Case in point, I present the port_dependencies table: For those not familiar with FreeBSD ports, each port (you could also refer to them as a package or application) can have zero or more dependencies. The FreshPorts database extracts and lists these dependencies

Duplicate dependency issues – avoiding duplicate rows Read More »

Details of the vuxml processing problem

Leave a Comment / Bug fixes, Development, vuxml / Dan Langille

For several weeks, FreshPorts had a vuxml processing problem. In this blog post, I will share what I found. Introduction Incoming events for FreshPorts are handled by a small Python script which checks for flags and incoming commits. This ensures that work is carried out serially because parallel work can have unintended consequences. After each

Details of the vuxml processing problem Read More »

Where is en-aspell?

Leave a Comment / Branches, Bug fixes, PostgreSQL / Dan Langille

Tonight, I was contacted by jrm on IRC, who told me that FreshPorts was missing something on a search. Yep. It was not in there. I looked on dev and I saw the same thing. Finding the cause I started by enabling debug on dev. I found this SQL: I started by removing one LEFT

Where is en-aspell? Read More »

Committing to a branch when there are slave ports

Leave a Comment / Branches, Bug fixes, Development / Dan Langille

Committing to a branch (e.g. 2016Q4) when the port in question has slave ports is getting tricky, especially if the port was added after the branch was created. Case in point, www/linux-c7-flashplugin11 was added to the tree on 19 Oct 2016. The 2016Q4 branch was created on 3 Oct, and therefore that port does not

Committing to a branch when there are slave ports Read More »

New function for creating a port

Leave a Comment / Branches, Bug fixes / Dan Langille

About two weeks ago, I wrote a function for creating a port. This will take the port from head and copy it to a branch. This is vital because of the reasons discussed here: creating a new port and copying a port from head to a branch. This function worked and was useful, but it

New function for creating a port Read More »

Improving the home page query

Leave a Comment / Bug fixes, Development, PostgreSQL / Dan Langille

See the issue raised here. On 1 April 2016, we had some large commits (you can see them all here). This ground the front page to a halt. But as you can see, that link above loads rather quickly. Why? At first, I thought it was because the date-based page was caching the results. I

Improving the home page query Read More »

Display the updated dependencies when a dependent port updates

Leave a Comment / Bug fixes, Caching / Dan Langille

A great feature of FreshPorts is the ability to see all the ports which are dependent upon a given port. For example, it allows you to see what ports depend upon security/polarssl. This list is stored in a the port_dependencies table, which looks like this: This information is gathered when a port is updated. The

Display the updated dependencies when a dependent port updates Read More »