Sep 142022
 

The Libreoffice homepages seem wrong.

dev and test do not show a homepage for arabic/libreoffice, but stage and prod do. Could this be a commit which corrected something after dev and test were corrected?

I think so. I think this commit did that.

Let’s check from the command line.

I’m doing this in my empty jail, which has nothing else in it. I first check out the commit before the one in question. I am using arabic/libreoffice as a reference point.

[empty dan /usr/ports] % sudo git fetch
remote: Enumerating objects: 491805, done.
remote: Counting objects: 100% (99085/99085), done.
remote: Compressing objects: 100% (504/504), done.
remote: Total 491805 (delta 99007), reused 98584 (delta 98581), pack-reused 392720
Receiving objects: 100% (491805/491805), 194.33 MiB | 25.76 MiB/s, done.
Resolving deltas: 100% (285529/285529), completed with 43639 local objects.
From https://git.FreeBSD.org/ports
   e66f56f4af6a..0a071f436dd3  main       -> origin/main
   85e1f363d213..5d6eb9d394c1  2021Q3     -> origin/2021Q3
 * [new branch]                2021Q4     -> origin/2021Q4
 * [new branch]                2022Q1     -> origin/2022Q1
 * [new branch]                2022Q2     -> origin/2022Q2
 * [new branch]                2022Q3     -> origin/2022Q3
 * [new tag]                   11-eol         -> 11-eol
 * [new tag]                   release/12.3.0 -> release/12.3.0
 * [new tag]                   release/13.1.0 -> release/13.1.0
[empty dan /usr/ports] % sudo git checkout 1e0832c71eb3ab4d2a548c5cd799da66013481d2
Updating files: 100% (93162/93162), done.
Note: switching to '1e0832c71eb3ab4d2a548c5cd799da66013481d2'.

You are in 'detached HEAD' state. You can look around, make experimental
changes and commit them, and you can discard any commits you make in this
state without impacting any branches by switching back to a branch.

If you want to create a new branch to retain commits you create, you may
do so (now or later) by using -c with the switch command. Example:

  git switch -c 

Or undo this operation with:

  git switch -

Turn off this advice by setting config variable advice.detachedHead to false

HEAD is now at 1e0832c71eb3 x11-themes/flat-remix-gtk-themes: Update to 20220627
[empty dan /usr/ports] % cd arabic/libreoffice
[empty dan /usr/ports/arabic/libreoffice] % make -V WWW

[empty dan /usr/ports/arabic/libreoffice] % 

Nothing. Let’s try the commit which fixed it.

[empty dan /usr/ports/arabic/libreoffice] % sudo git checkout 9dea2f5dedeb0ef7ce184c85bb97927ed3a8822d
Previous HEAD position was 1e0832c71eb3 x11-themes/flat-remix-gtk-themes: Update to 20220627
HEAD is now at 9dea2f5dedeb editors/libreoffice: pass WWW line to i18n packages too
[empty dan /usr/ports/arabic/libreoffice] % make -V WWW
https://www.libreoffice.org/

Yes, that’s it.

Now, let’s compare this commit against the timing of the correction scripts.

The test correction script finished at about 10:04 AM on Sep 11, 2022. The commit in question was at 2022-09-11 16:42:15 +0000 (or about 12:42 AM). That’s why dev and test are wrong. They didn’t have the fix when the correction script ran.

Your next question might be: why didn’t this get fixed when FreshPorts processed the commit?

There is no standard connection between the commit and the ports it affects. If this was a primary/secondary relationship, as detected by standard methods, for example:

[empty dan /usr/ports/sysutils/bacula13-client] % make -V MASTER_PORT
sysutils/bacula13-server
[empty dan /usr/ports/sysutils/bacula13-client] % 

Rather, the Makefile for arabic/libreoffice is rather brief:

[empty dan /usr/ports/arabic/libreoffice] % cat Makefile
CATEGORIES=	arabic
LO_I18N=	ar
LO_HAS_HELPPACK=	yes

.include "${.CURDIR}/../../editors/libreoffice/Makefile.i18n"

.include 

This is an eloquent solution for a large number of ports. However, the cost to FreshPorts is not knowing to refresh the dependent ports when the primary port is updated.

However, it should be easy to modify my correction script. Let’s try this SQL:

freshports.devgit=#      
  SELECT PA.id,
         PA.category,
         PA.name,
         EP.pathname as port_pathname, homepage
    FROM ports_active PA JOIN element_pathname EP on PA.element_id = EP.element_id
   WHERE EP.pathname like '/ports/head/%/libreoffice%'
ORDER BY category, name;
  id   |  category  |          name           |                port_pathname                |           homepage           
-------+------------+-------------------------+---------------------------------------------+------------------------------
 30905 | arabic     | libreoffice             | /ports/head/arabic/libreoffice              | 
 30897 | chinese    | libreoffice-zh_CN       | /ports/head/chinese/libreoffice-zh_CN       | 
 30884 | chinese    | libreoffice-zh_TW       | /ports/head/chinese/libreoffice-zh_TW       | 
 28193 | editors    | libreoffice             | /ports/head/editors/libreoffice             | https://www.libreoffice.org/
 30881 | editors    | libreoffice-af          | /ports/head/editors/libreoffice-af          | 
 32344 | editors    | libreoffice-am          | /ports/head/editors/libreoffice-am          | 
 30817 | editors    | libreoffice-as          | /ports/head/editors/libreoffice-as          | 
 31480 | editors    | libreoffice-ast         | /ports/head/editors/libreoffice-ast         | 
 30861 | editors    | libreoffice-be          | /ports/head/editors/libreoffice-be          | 
 30831 | editors    | libreoffice-bg          | /ports/head/editors/libreoffice-bg          | 
 30908 | editors    | libreoffice-bn          | /ports/head/editors/libreoffice-bn          | 
 32343 | editors    | libreoffice-bn_IN       | /ports/head/editors/libreoffice-bn_IN       | 
 31478 | editors    | libreoffice-bo          | /ports/head/editors/libreoffice-bo          | 
 30832 | editors    | libreoffice-br          | /ports/head/editors/libreoffice-br          | 
 30855 | editors    | libreoffice-brx         | /ports/head/editors/libreoffice-brx         | 
 30839 | editors    | libreoffice-bs          | /ports/head/editors/libreoffice-bs          | 
 30837 | editors    | libreoffice-ca          | /ports/head/editors/libreoffice-ca          | 
 34763 | editors    | libreoffice-ca_valencia | /ports/head/editors/libreoffice-ca_valencia | 
 59798 | editors    | libreoffice-ckb         | /ports/head/editors/libreoffice-ckb         | 
 30891 | editors    | libreoffice-cs          | /ports/head/editors/libreoffice-cs          | 
 30904 | editors    | libreoffice-cy          | /ports/head/editors/libreoffice-cy          | 
 30875 | editors    | libreoffice-da          | /ports/head/editors/libreoffice-da          | 
 30911 | editors    | libreoffice-dgo         | /ports/head/editors/libreoffice-dgo         | 
 52543 | editors    | libreoffice-dsb         | /ports/head/editors/libreoffice-dsb         | 
 30894 | editors    | libreoffice-dz          | /ports/head/editors/libreoffice-dz          | 
 30880 | editors    | libreoffice-el          | /ports/head/editors/libreoffice-el          | 
 30863 | editors    | libreoffice-en_GB       | /ports/head/editors/libreoffice-en_GB       | 
 30850 | editors    | libreoffice-en_ZA       | /ports/head/editors/libreoffice-en_ZA       | 
 30907 | editors    | libreoffice-eo          | /ports/head/editors/libreoffice-eo          | 
 30840 | editors    | libreoffice-es          | /ports/head/editors/libreoffice-es          | 
 30912 | editors    | libreoffice-et          | /ports/head/editors/libreoffice-et          | 
 30900 | editors    | libreoffice-eu          | /ports/head/editors/libreoffice-eu          | 
 30866 | editors    | libreoffice-fa          | /ports/head/editors/libreoffice-fa          | 
 30877 | editors    | libreoffice-fi          | /ports/head/editors/libreoffice-fi          | 
 59799 | editors    | libreoffice-fur         | /ports/head/editors/libreoffice-fur         | 
 49014 | editors    | libreoffice-fy          | /ports/head/editors/libreoffice-fy          | 
 30892 | editors    | libreoffice-ga          | /ports/head/editors/libreoffice-ga          | 
 30853 | editors    | libreoffice-gd          | /ports/head/editors/libreoffice-gd          | 
 30830 | editors    | libreoffice-gl          | /ports/head/editors/libreoffice-gl          | 
 30899 | editors    | libreoffice-gu          | /ports/head/editors/libreoffice-gu          | 
 37232 | editors    | libreoffice-gug         | /ports/head/editors/libreoffice-gug         | 
 30829 | editors    | libreoffice-hi          | /ports/head/editors/libreoffice-hi          | 
 30815 | editors    | libreoffice-hr          | /ports/head/editors/libreoffice-hr          | 
 47506 | editors    | libreoffice-hsb         | /ports/head/editors/libreoffice-hsb         | 
 30864 | editors    | libreoffice-i18n        | /ports/head/editors/libreoffice-i18n        | https://www.libreoffice.org/
 30826 | editors    | libreoffice-id          | /ports/head/editors/libreoffice-id          | 
 30842 | editors    | libreoffice-is          | /ports/head/editors/libreoffice-is          | 
 30854 | editors    | libreoffice-it          | /ports/head/editors/libreoffice-it          | 
 30841 | editors    | libreoffice-ka          | /ports/head/editors/libreoffice-ka          | 
 52544 | editors    | libreoffice-kab         | /ports/head/editors/libreoffice-kab         | 
 30914 | editors    | libreoffice-kk          | /ports/head/editors/libreoffice-kk          | 
 30889 | editors    | libreoffice-km          | /ports/head/editors/libreoffice-km          | 
 34762 | editors    | libreoffice-kmr_Latn    | /ports/head/editors/libreoffice-kmr_Latn    | 
 31479 | editors    | libreoffice-kn          | /ports/head/editors/libreoffice-kn          | 
 30903 | editors    | libreoffice-kok         | /ports/head/editors/libreoffice-kok         | 
 30836 | editors    | libreoffice-ks          | /ports/head/editors/libreoffice-ks          | 
 31476 | editors    | libreoffice-lb          | /ports/head/editors/libreoffice-lb          | 
 30868 | editors    | libreoffice-lo          | /ports/head/editors/libreoffice-lo          | 
 30902 | editors    | libreoffice-lt          | /ports/head/editors/libreoffice-lt          | 
 30852 | editors    | libreoffice-lv          | /ports/head/editors/libreoffice-lv          | 
 30828 | editors    | libreoffice-mai         | /ports/head/editors/libreoffice-mai         | 
 30827 | editors    | libreoffice-mk          | /ports/head/editors/libreoffice-mk          | 
 30824 | editors    | libreoffice-ml          | /ports/head/editors/libreoffice-ml          | 
 30893 | editors    | libreoffice-mn          | /ports/head/editors/libreoffice-mn          | 
 30872 | editors    | libreoffice-mni         | /ports/head/editors/libreoffice-mni         | 
 30846 | editors    | libreoffice-mr          | /ports/head/editors/libreoffice-mr          | 
 30874 | editors    | libreoffice-my          | /ports/head/editors/libreoffice-my          | 
 30888 | editors    | libreoffice-nb          | /ports/head/editors/libreoffice-nb          | 
 30885 | editors    | libreoffice-ne          | /ports/head/editors/libreoffice-ne          | 
 30849 | editors    | libreoffice-nl          | /ports/head/editors/libreoffice-nl          | 
 30876 | editors    | libreoffice-nn          | /ports/head/editors/libreoffice-nn          | 
 30865 | editors    | libreoffice-nr          | /ports/head/editors/libreoffice-nr          | 
 30896 | editors    | libreoffice-nso         | /ports/head/editors/libreoffice-nso         | 
 30822 | editors    | libreoffice-oc          | /ports/head/editors/libreoffice-oc          | 
 30895 | editors    | libreoffice-om          | /ports/head/editors/libreoffice-om          | 
 30909 | editors    | libreoffice-or          | /ports/head/editors/libreoffice-or          | 
 30823 | editors    | libreoffice-pa_IN       | /ports/head/editors/libreoffice-pa_IN       | 
 30856 | editors    | libreoffice-ro          | /ports/head/editors/libreoffice-ro          | 
 30857 | editors    | libreoffice-rw          | /ports/head/editors/libreoffice-rw          | 
 30901 | editors    | libreoffice-sa_IN       | /ports/head/editors/libreoffice-sa_IN       | 
 30847 | editors    | libreoffice-sat         | /ports/head/editors/libreoffice-sat         | 
 30890 | editors    | libreoffice-sd          | /ports/head/editors/libreoffice-sd          | 
 30860 | editors    | libreoffice-si          | /ports/head/editors/libreoffice-si          | 
 32520 | editors    | libreoffice-sid         | /ports/head/editors/libreoffice-sid         | 
 30818 | editors    | libreoffice-sk          | /ports/head/editors/libreoffice-sk          | 
 30862 | editors    | libreoffice-sl          | /ports/head/editors/libreoffice-sl          | 
 30870 | editors    | libreoffice-sq          | /ports/head/editors/libreoffice-sq          | 
 30883 | editors    | libreoffice-sr          | /ports/head/editors/libreoffice-sr          | 
 34764 | editors    | libreoffice-sr_Latn     | /ports/head/editors/libreoffice-sr_Latn     | 
 30886 | editors    | libreoffice-ss          | /ports/head/editors/libreoffice-ss          | 
 30843 | editors    | libreoffice-st          | /ports/head/editors/libreoffice-st          | 
 30859 | editors    | libreoffice-sv          | /ports/head/editors/libreoffice-sv          | 
 30835 | editors    | libreoffice-sw_TZ       | /ports/head/editors/libreoffice-sw_TZ       | 
 54774 | editors    | libreoffice-szl         | /ports/head/editors/libreoffice-szl         | 
 30825 | editors    | libreoffice-ta          | /ports/head/editors/libreoffice-ta          | 
 30913 | editors    | libreoffice-te          | /ports/head/editors/libreoffice-te          | 
 30858 | editors    | libreoffice-tg          | /ports/head/editors/libreoffice-tg          | 
 30845 | editors    | libreoffice-th          | /ports/head/editors/libreoffice-th          | 
 30816 | editors    | libreoffice-tn          | /ports/head/editors/libreoffice-tn          | 
 30851 | editors    | libreoffice-tr          | /ports/head/editors/libreoffice-tr          | 
 30844 | editors    | libreoffice-ts          | /ports/head/editors/libreoffice-ts          | 
 31481 | editors    | libreoffice-tt          | /ports/head/editors/libreoffice-tt          | 
 31477 | editors    | libreoffice-ug          | /ports/head/editors/libreoffice-ug          | 
 30873 | editors    | libreoffice-uz          | /ports/head/editors/libreoffice-uz          | 
 30834 | editors    | libreoffice-ve          | /ports/head/editors/libreoffice-ve          | 
 40201 | editors    | libreoffice-vec         | /ports/head/editors/libreoffice-vec         | 
 30879 | editors    | libreoffice-xh          | /ports/head/editors/libreoffice-xh          | 
 30867 | editors    | libreoffice-zu          | /ports/head/editors/libreoffice-zu          | 
 30878 | french     | libreoffice             | /ports/head/french/libreoffice              | 
 30898 | german     | libreoffice             | /ports/head/german/libreoffice              | 
 30819 | hebrew     | libreoffice             | /ports/head/hebrew/libreoffice              | 
 30910 | hungarian  | libreoffice             | /ports/head/hungarian/libreoffice           | 
 30820 | japanese   | libreoffice             | /ports/head/japanese/libreoffice            | 
 30838 | korean     | libreoffice             | /ports/head/korean/libreoffice              | 
 30848 | polish     | libreoffice             | /ports/head/polish/libreoffice              | 
 30906 | portuguese | libreoffice             | /ports/head/portuguese/libreoffice          | 
 30869 | portuguese | libreoffice-pt_BR       | /ports/head/portuguese/libreoffice-pt_BR    | 
 30833 | russian    | libreoffice             | /ports/head/russian/libreoffice             | 
 30821 | ukrainian  | libreoffice             | /ports/head/ukrainian/libreoffice           | 
 30814 | vietnamese | libreoffice             | /ports/head/vietnamese/libreoffice          | 
(120 rows)
freshports.devgit=#     

After running the correction script again, this time only upon Librenms ports, dev and stage match.

Similarly, running the fix on test resulted in identical results on both dev, test, and stage.

Now it’s just lang/linux-dotnet11-sdk which differs. This also seems to be a case of bad timing. This commit seems to have changed that port

Running a refresh on that one port (lang/linux-dotnet11-sdk) on each of dev, test, and stage results in a match amongst all four websites.

Done.

Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive