Forum OpenACS Development: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1

6: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 5)

Posted by Frank Bergmann on 06/21/20 11:05 AM

Hi,

prohibits

No problem to use the new NaviServer. It's just that ]po[ V5.0 still uses the 4.99.8, and I don't want to tell customers to do yet another upgrade.

PG11

We would have to fix TSearch2 for PG 10/11. That's not difficult, it's just another API. The "surface" between ]po[ and TSearch2 is not very large.
However, as with NaviServer, we will still be using CentOS 7 with PG 9 for a while, so from this side there isn't much pressure to do the migration.

I'd estimate half a day to a day for this. We could do this as part of merging your changes into ]po[ "vanilla"?

Cheers
Frank

7: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 6)

Posted by Maurizio Martignano on 06/21/20 02:09 PM

The following is just for info.

This is ]project-open[ version 5.0.3.0 running on Windows-OpenACS June 2020 version (with the latest of everything).

https://www.spazioit.com/images/project-open/po_5.0.3.0_on_woacs_202006.jpg

Have a wonderful Sunday,
Maurizio

12: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 7)

Posted by Malte Sussdorff on 07/07/20 12:03 PM

Hi Maurizio,

do you have a list of things you needed to do in order to get this working?

Did you use the ]project-open[ dumpfile for this to get started or did you do a fresh install of ]project-open[ on top of your windows system?

I want to update the ]project-open[ docker containers to the latest version, as I do follow your strategy (upgrade to latest packages on a regular basis). Additionally, I'm not entirely sure when e.g. PG9 runs out of maintenance.

Looking forward to your pointers (and if you say "there isn't much to worry about" even the better 😊).

Malte

15: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 12)

Posted by Maurizio Martignano on 07/07/20 05:14 PM

Hello Malte and Frank,
I downloaded around the end of June (29th) the official ]po[ Windows distribution. Then from there I got the DB and the packages.
I put the packages on top of my distribution and used the above DB as starting point.
I run some few upgrades/updates.
To replicate what I did you can get:
1. my distribution: https://www.spazioit.com/software/Windows-OpenACS.exe
Once installed, in /naviserver/software/naviserver-si.zip you can get the naviserver sources I use
2. some material: https://www.spazioit.com/software/po-material.7z
containing the modified ]po[ packages and DB.

It is rough material, but I hope it helps.

Maurizio

8: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 6)

Posted by Gustaf Neumann on 06/21/20 09:13 PM

We would have to fix TSearch2 for PG 10/11.

What do you want to fix? we use it with these versions (with oacs-5-10, but i do not think we had to fix something)

-gn

9: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 8)

Posted by Maurizio Martignano on 06/21/20 09:43 PM

As far as I know, for Tsearch2 in the ]pproject-open[ codebase, the only required modification is to change all calls to "to_tsquery('default', x)" to "to_tsquery(x)"
Tha's it and that's all. A single edit operation.

Maurizio

10: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 9)

Posted by Frank Bergmann on 06/21/20 10:35 PM

Hi Maurizio,

Thanks for posting! I knew it would be something like that, but I didn't even look yet ...

]po[ copies the strings to be indexed into a separate table and applies the TSearch2 full-text index on one column of that table. ..

Cheers
Frank

11: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 10)

Posted by Maurizio Martignano on 06/22/20 07:23 AM

You're welcome Frank.

It's a matter of strategy.

A first strategy corresponds in doing the updates/upgrades every now and then, say every X years. By so doing the number of changes that have to be taken into account is quite considerable. And you have to test all these changes.

Another strategy, the one I've been using for OpenACS, is to always keep up with the developments of the various components/libraries and always make sure that everything works. By so doing, the number of changes that have to be taken into account every single update is very limited (1 or at most 2 at a time). This reduces dramatically the time required to solve the issues related with the change(s).

I might be wrong, but I believe that at the end of the day, the second strategy is cheaper.

Maurizio

13: Re: FYI: Errors upgrading ]po[ from OpenACS 5.9.0 to 5.9.1 (response to 9)

Posted by Malte Sussdorff on 07/07/20 01:23 PM

Hi Maurizio,

yes, you were right. I only had to remove duplications from tsearch2-driver which made it into intranet-search-pg and ammend the queries as per your instructions. Well.. and load an updated im_search_update function into postgresql before running any update (as there are triggers on cr_items which fire with normal openacs upgrades).

(removed ]project-open[ code.. wrong place )