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