[Evergreen-dev] 3.10.4 & 3.11.2 Releases

[Blake Graham-Henderson]

All,

Oh boy, ok, so it was the enhanced concerto load that worked. The old 
concerto is still throwing the same error. Sorry for throwing in more 
confusion. My automated builds were all setup to use the enhanced and I 
didn't notice until now.

-Blake-
Conducting Magic
Will consume any data format
MOBIUS

On 12/14/2023 1:49 PM, Jason Boyer wrote:
> So here's what happened: When I added the new trigger for LP 2023314 I 
> used the Pg11+ FOR EACH ROW EXECUTE FUNCTION syntax rather than the pg 
> <= 10 FOR EACH ROW EXECUTE PROCEDURE so creating a db on pg10 will 
> fail for all releases from yesterday, 3.10.4, 3.11.2, and 3.12.0, and 
> main.
>
> ALL POINT RELEASE UPGRADES WILL ALSO FAIL ON PG 10.
>
> Until the last point release of the last branch that supports Postgres 
> 10 we need to continue to use the EXECUTE PROCEDURE syntax. As 
> Postgres is slow to *remove* syntax support this will likely continue 
> to work for a very long time. (Both syntaxes are still supported in pg 
> 15 and current.)
>
> Since we have the branches for the point releases I'll correct them 
> and rebuild the tarballs because we support pg10 even in main, so this 
> needs to work everywhere.
>
> Jason
>
> -- 
> Jason Boyer
> Senior System Administrator
> Equinox Open Library Initiative
> JBoyer at equinoxOLI.org
> +1 (877) Open-ILS (673-6457)
> https://equinoxOLI.org/
>
>> On Dec 14, 2023, at 12:56 PM, Jason Boyer <JBoyer at equinoxOLI.org> wrote:
>>
>> Ah, what combination was broken wasn't entirely clear. I'll check on 
>> rel_3_10 and pg 10 because I believe it's supported there so it needs 
>> to work.
>>
>> Jason
>>
>> -- 
>> Jason Boyer
>> Senior System Administrator
>> Equinox Open Library Initiative
>> JBoyer at equinoxOLI.org
>> +1 (877) Open-ILS (673-6457)
>> https://equinoxOLI.org/
>>
>>> On Dec 14, 2023, at 12:42 PM, Blake Graham-Henderson 
>>> <blake at mobiusconsortium.org> wrote:
>>>
>>> Jason,
>>>
>>> Thanks for taking a look! A couple of clarifications:
>>>
>>> - It's rel_3_11
>>> - My test machine used PG 10:
>>>
>>> make -f Open-ILS/src/extras/Makefile.install 
>>> postgres-server-ubuntu-focal-10
>>>
>>> Could be something going on in my environment. If you've tested it 
>>> and it's working for you then I'm sure I've got something amiss over 
>>> here.
>>> -Blake-
>>> Conducting Magic
>>> Will consume any data format
>>> MOBIUS
>>>
>>> On 12/14/2023 11:32 AM, Jason Boyer wrote:
>>>> Galen and I have done a little research on this and it looks like 
>>>> the rel_3_10 branch can't be used to setup a new database on 
>>>> Postgres 15. Just going back to pg 14 a new db + concerto works 
>>>> just fine. Since no one is expected to install a fresh 3.10 system 
>>>> on pg15 this is fine.
>>>>
>>>> Jason
>>>>
>>>> -- 
>>>> Jason Boyer
>>>> Senior System Administrator
>>>> Equinox Open Library Initiative
>>>> JBoyer at equinoxOLI.org
>>>> +1 (877) Open-ILS (673-6457)
>>>> https://equinoxOLI.org/
>>>>
>>>>> On Dec 14, 2023, at 9:37 AM, Blake Graham-Henderson via 
>>>>> Evergreen-dev <evergreen-dev at list.evergreen-ils.org> wrote:
>>>>>
>>>>> Jason,
>>>>>
>>>>> I created the tarball, tested it, and uploaded it to the site. I 
>>>>> also updated the downloads page. Maybe that was a bit hasty. I'll 
>>>>> revert that if needs be. One thing that was concerning was the 
>>>>> installation of the concerto set threw this error:
>>>>>
>>>>>  psql:assets_concerto.sql:58: ERROR:  update or delete on table 
>>>>> "record_entry" violates foreign key constraint 
>>>>> "browse_entry_def_map_source_fkey" on table "browse_entry_def_map"
>>>>>
>>>>> -Blake-
>>>>> Conducting Magic
>>>>> Will consume any data format
>>>>> MOBIUS
>>>>> 573-234-4513
>>>>> 877-312-3517
>>>>>
>>>>> On 12/14/2023 7:15 AM, Jason Stephenson via Evergreen-dev wrote:
>>>>>> Hi, all.
>>>>>>
>>>>>> I'm going to release 3.10.4 sometime today or tomorrow. I've got 
>>>>>> personal stuff to do, and I'm working on a summary of the release 
>>>>>> discussion. It's a lot of information to digest and summarize.
>>>>>>
>>>>>> Blake, are you ready to release 3.11.2?
>>>>>>
>>>>>> I'm not hanging out in IRC today, but I might pop in tomorrow. I 
>>>>>> have less going on then.
>>>>>>
>>>>>> Jason Stephenson
>>>>>> _______________________________________________
>>>>>> Evergreen-dev mailing list
>>>>>> Evergreen-dev at list.evergreen-ils.org
>>>>>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
>>>>>
>>>>> _______________________________________________
>>>>> Evergreen-dev mailing list
>>>>> Evergreen-dev at list.evergreen-ils.org
>>>>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20231214/e5d67b46/attachment.htm>