<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><meta http-equiv="content-type" content="text/html; charset=utf-8"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">That EXECUTE FUNCTION syntax will break any attempt to create a new Evergreen 3.10.4, 3.11.2, or 3.12.0 database on Postgres 10 or any attempt to upgrade to one of those versions on Postgres 10. I've got local commits that correct the syntax for all affected branches, and once I push those I'll rebuild the 3.10.4, 3.11.2, and 3.12.0 tarballs unless someone else wants to grab one or some.<div><br></div><div>To be clear, anyone running Pg11 or later will not run into this issue because Postgres 11+ supports both syntaxes.</div><div><br></div><div>As for your specific error, it's possible that with the 800.fkeys.sql file being broken (but the create-db script(s) not checking for errors... something else to fix sometime) the db you were left with was largely complete, but not complete enough to work properly.</div><div><br></div><div>Jason<br id="lineBreakAtBeginningOfMessage"><div>
<meta charset="UTF-8"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div><br>-- <br>Jason Boyer<br>Senior System Administrator<br>Equinox Open Library Initiative<br>JBoyer@equinoxOLI.org<br>+1 (877) Open-ILS (673-6457)<br>https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>On Dec 14, 2023, at 3:12 PM, Blake Graham-Henderson <blake@mobiusconsortium.org> wrote:</div><br class="Apple-interchange-newline"><div>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div>
All,<br>
<br>
I've been spinning up more installations of Evergreen with various
variables changed. I've successfully installed the 3.11.2 tarball on
a new machine, and the concerto set does work now. So, I'm not sure
what my problem was the first go around. I should have done this
routine before I blabbed about it. In addition to the tarball
success, I built another machine from git rel_3_11, and that worked
as well.<br>
<br>
Jason Boyer:<br>
<br>
I suppose you've ran through the installation from git rel_3_11 and
encountered an issue with EXECUTE PROCEDURE? But only for upgrading
existing DB's?<br>
<br>
I'm looking at<br>
<a class="moz-txt-link-freetext" href="https://git.evergreen-ils.org/?p=working/Evergreen.git;a=commit;h=ff542fb56b4a9f4d6db688453fb15fafc1af186d">https://git.evergreen-ils.org/?p=working/Evergreen.git;a=commit;h=ff542fb56b4a9f4d6db688453fb15fafc1af186d</a><br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div class="moz-cite-prefix">On 12/14/2023 1:49 PM, Jason Boyer
wrote:<br>
</div>
<blockquote type="cite" cite="mid:83B5DEC3-5DCB-4C6D-AC54-0F9C9DB8D833@equinoxOLI.org">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
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.
<div><br>
</div>
<div>ALL POINT RELEASE UPGRADES WILL ALSO FAIL ON PG 10.</div>
<div><br>
</div>
<div>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.)</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Jason</div>
<div>
<div>
<meta charset="UTF-8">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div><br>
-- <br>
Jason Boyer<br>
Senior System Administrator<br>
Equinox Open Library Initiative<br>
<a class="moz-txt-link-abbreviated" href="mailto:JBoyer@equinoxOLI.org">JBoyer@equinoxOLI.org</a><br>
+1 (877) Open-ILS (673-6457)<br>
<a class="moz-txt-link-freetext" href="https://equinoxoli.org/">https://equinoxOLI.org/</a></div>
</div>
</div>
</div>
</div>
<div><br>
<blockquote type="cite">
<div>On Dec 14, 2023, at 12:56 PM, Jason Boyer
<a class="moz-txt-link-rfc2396E" href="mailto:JBoyer@equinoxOLI.org"><JBoyer@equinoxOLI.org></a> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">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.
<div><br>
</div>
<div>Jason<br id="lineBreakAtBeginningOfMessage">
<div>
<meta charset="UTF-8">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div><br>
-- <br>
Jason Boyer<br>
Senior System Administrator<br>
Equinox Open Library Initiative<br>
<a class="moz-txt-link-abbreviated" href="mailto:JBoyer@equinoxOLI.org">JBoyer@equinoxOLI.org</a><br>
+1 (877) Open-ILS (673-6457)<br>
<a class="moz-txt-link-freetext" href="https://equinoxoli.org/">https://equinoxOLI.org/</a></div>
</div>
</div>
</div>
</div>
<div><br>
<blockquote type="cite">
<div>On Dec 14, 2023, at 12:42 PM, Blake
Graham-Henderson
<a class="moz-txt-link-rfc2396E" href="mailto:blake@mobiusconsortium.org"><blake@mobiusconsortium.org></a> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div> Jason,<br>
<br>
Thanks for taking a look! A couple of
clarifications:<br>
<br>
- It's rel_3_11<br>
- My test machine used PG 10:<br>
<br>
make -f Open-ILS/src/extras/Makefile.install
postgres-server-ubuntu-focal-10<br>
<br>
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.<br>
<pre class="moz-signature" cols="72">-Blake-
Conducting Magic
Will consume any data format
MOBIUS
</pre>
<div class="moz-cite-prefix">On 12/14/2023
11:32 AM, Jason Boyer wrote:<br>
</div>
<blockquote type="cite" cite="mid:769A6F0B-A0B0-4E27-801D-BA47A57B0247@equinoxOLI.org">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
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.
<div><br>
</div>
<div>Jason<br id="lineBreakAtBeginningOfMessage">
<div>
<meta charset="UTF-8">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="caret-color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div><br>
-- <br>
Jason Boyer<br>
Senior System Administrator<br>
Equinox Open Library Initiative<br>
<a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:JBoyer@equinoxOLI.org" moz-do-not-send="true">JBoyer@equinoxOLI.org</a><br>
+1 (877) Open-ILS (673-6457)<br>
<a class="moz-txt-link-freetext" href="https://equinoxoli.org/" moz-do-not-send="true">https://equinoxOLI.org/</a></div>
</div>
</div>
</div>
</div>
<div><br>
<blockquote type="cite">
<div>On Dec 14, 2023, at 9:37 AM,
Blake Graham-Henderson via
Evergreen-dev <a class="moz-txt-link-rfc2396E" href="mailto:evergreen-dev@list.evergreen-ils.org" moz-do-not-send="true"><evergreen-dev@list.evergreen-ils.org></a>
wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>Jason,<br>
<br>
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:<br>
<br>
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"<br>
<br>
-Blake-<br>
Conducting Magic<br>
Will consume any data format<br>
MOBIUS<br>
573-234-4513<br>
877-312-3517<br>
<br>
On 12/14/2023 7:15 AM, Jason
Stephenson via Evergreen-dev
wrote:<br>
<blockquote type="cite">Hi, all.<br>
<br>
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.<br>
<br>
Blake, are you ready to release
3.11.2?<br>
<br>
I'm not hanging out in IRC
today, but I might pop in
tomorrow. I have less going on
then.<br>
<br>
Jason Stephenson<br>
_______________________________________________<br>
Evergreen-dev mailing list<br>
<a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:Evergreen-dev@list.evergreen-ils.org" moz-do-not-send="true">Evergreen-dev@list.evergreen-ils.org</a><br>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" moz-do-not-send="true">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</blockquote>
<br>
_______________________________________________<br>
Evergreen-dev mailing list<br>
<a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:Evergreen-dev@list.evergreen-ils.org" moz-do-not-send="true">Evergreen-dev@list.evergreen-ils.org</a><br>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" moz-do-not-send="true">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div></blockquote></div><br></div></div></body></html>