Ever since the new server went into production, sometime in 2017, the notification emails, which tell you what has changed, have been coming from the old server. I never did that changeover. The old server was still processing incoming commits, so the notifications were accurate. However, new accounts would not get notifications and changes to […]
Moving the email notifications to the new server Read More »
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 »
This post serves two goals: document the CONFLICTS implementation within FreshPorts show how you can use triggers to update a secondary table The FreeBSD ports tree / package collection has a method for resolving conflicts. This feature allows a port maintainer to specify what, if any, packages conflict with a given port. The reasons why
Adding and populating CONFLICTS Read More »
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 »
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 »
FreshPorts uses a cache for every port page (e.g. https://www.freshports.org/sysutils/bacula-server/). When an update to a port occurs, we must clear the cache for that port. This sounds simple, and it is. The various ways in which updates occur complicates the situation. This post is all about fixing one edge case: the addition or removal of
When dependencies change, both ports need to be updated Read More »
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 »
I noticed the server load was high. I saw that several instances of search by date where still running. Looking at the query in question: The analysis for this query is available at http://explain.depesz.com/s/uCT I redesigned the query to make use of explicit JOINs: The analysis for that query is at http://explain.depesz.com/s/p3wn. I’ll let readers
Improving date search Read More »
Yesterday, I wrote about some great progress on getting FreshPorts to work with multiple repositories to cater for the branches of the FreeBSD ports tree. At the end of that post, I talked briefly about wanting global settings or variables for my stored procedures. Shortly after posting that, I found a solution in the form
Session variables! Almost. Not quite. Read More »
Today I managed to make quite a bit of progress trying to incorporate multiple ports trees into the commit processing. The diff is about 985 lines long. It’s not as complex as it sounds. I just have to pass $CommitBranch around to various functions. The result: I have the commits going into the database, but
Multiple repos – good progress Read More »