<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
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); 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>
<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>
</body>
</html>