[Geoserver-devel] build.geoserver geoserver-main-app-schema-online job maintenance / discussion.

jive · July 5, 2024, 10:43pm

I have a PR that looks at some gaps in the GeoTools feature model around validation… and Niels made the perfectly sensible recommendation to run the app-schema online tests…

Checking build.geoserver.org the geoserver-main-app-schema-online is disabled
Looking at the configuration it was java 8 based, so this has been disabled for some time
The setup has a lot of messing around to get the ojdbc7.jar to talk to oracle-db.dev.boundlessgeo.com … so quite a long time.

Do we have an active module maintainer (or experienced developer) for application schema?

Trying it out:

I do not think the steps to copy ojdbc7.jar are required any more (since such a jar is now available via maven dependency)
Changing to Java 11 and commenting out the oracle.properties test fixed and running the job shows …

[INFO] Application Schema Support … SUCCESS [ 4.694 s]

[INFO] Application Schema Module … SUCCESS [ 9.101 s]

[INFO] Application Schema Integration Test … FAILURE [01:28 min]

[INFO] Sample DataAccess Integration Test … SUCCESS [ 4.919 s]

[INFO] Application Schema Integration Online Test with Postgis Database SUCCESS [01:14 min]

[INFO] Application Schema Solr Integration Test … SUCCESS [ 2.659 s]

[INFO] Application Schema Indexes Integration Test … SUCCESS [ 1.319 s]

[INFO] Application Schema Geopackage Integration Test … FAILURE [ 11.730 s]

So what do you think? Does this test have value? For now I will enable it but not schedule it @daily (in case anyone else wants to look).

Thanks

···

–
Jody Garnett

Niels_Charlier · July 8, 2024, 12:29pm

Hello Jody

I have always run those tests locally whenever making changes that affect app-schema, not sure about Jenkins issues.

Kind Regards

Niels

···

On 06/07/2024 00:43, Jody Garnett wrote:

I have a PR that looks at some gaps in the GeoTools feature model around validation… and Niels made the perfectly sensible recommendation to run the app-schema online tests…

Checking build.geoserver.org the geoserver-main-app-schema-online is disabled

Looking at the configuration it was java 8 based, so this has been disabled for some time

The setup has a lot of messing around to get the ojdbc7.jar to talk to oracle-db.dev.boundlessgeo.com … so quite a long time.

Do we have an active module maintainer (or experienced developer) for application schema?

Trying it out:

I do not think the steps to copy ojdbc7.jar are required any more (since such a jar is now available via maven dependency)

Changing to Java 11 and commenting out the oracle.properties test fixed and running the job shows …

[INFO] Application Schema Support … SUCCESS [ 4.694 s]

[INFO] Application Schema Module … SUCCESS [ 9.101 s]

[INFO] Application Schema Integration Test … FAILURE [01:28 min]

[INFO] Sample DataAccess Integration Test … SUCCESS [ 4.919 s]

[INFO] Application Schema Integration Online Test with Postgis Database SUCCESS [01:14 min]

[INFO] Application Schema Solr Integration Test … SUCCESS [ 2.659 s]

[INFO] Application Schema Indexes Integration Test … SUCCESS [ 1.319 s]

[INFO] Application Schema Geopackage Integration Test … FAILURE [ 11.730 s]

So what do you think? Does this test have value? For now I will enable it but not schedule it @daily (in case anyone else wants to look).

Thanks

–
Jody Garnett

jive · July 9, 2024, 6:28am

Niels,

How do you run the app-schema tests?

I create a ~/.geoserver/postgis.properties with connection parameters including a database name
And then run with:
mvn clean install -Papp-schema-online-test

When I run I get errors such as:

[ERROR] testNoPrimaryKey(org.geoserver.test.onlineTest.WfsOnlinePostgisTest) Time elapsed: 0.294 s <<< ERROR!
org.postgresql.util.PSQLException:
ERROR: function public.ndims(public.geometry) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 355

Looking at the build server job configuration I am shocked to see this is defined as part of the script:

#missing functions required for refdataset sql but removed in postgis 2.1

export PGPASSWORD=‘’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.ndims(g geometry) returns smallint as $$ begin return public.st_ndims(g); end; $$ language plpgsql immutable strict;’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.srid(g geometry) returns integer as $$ begin return public.st_srid(g); end; $$ language plpgsql immutable strict;’

Surely that cannot be right?
Is defining ndims part of the app schema installation instructions? No…

I How do you run the tests locally…

···

–
Jody Garnett

Andrea_Aime4 · July 9, 2024, 8:18am

Hi Jody,
the same way you run other online test cases in GeoTools.

For postgis, locally I have the following file in ~/.geoserver:

cat postgis.properties
#This is an example fixture. Update the values and remove the .example suffix to enable the test
#Mon Jan 23 12:28:28 CET 2023
password=mysecret
database=app-schema
driver=org.postgresql.Driver
passwd=mysecret
port=5432
host=localhost
dbtype=postgisng
user=myuser
url=jdbc:postgresql://localhost/app-schema

And then with maven in the path:

cd extension/app-schema/app-schema-postgis-test/

mvn clean install -Ponline -nsu -fae

If you had everything properly set up, the build should end with:

[INFO] Results:
[INFO]
[WARNING] Tests run: 319, Failures: 0, Errors: 0, Skipped: 1

I don’t have an Oracle ready for usage but the postgis ones already provide a good coverage of
the common cases.

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Andrea_Aime4 · July 9, 2024, 8:19am

And oh, my local postgis database has the postgis extensions installed.

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Lahr-Vivaz_Emilio · July 9, 2024, 12:21pm

Have you guys considered using testcontainers[1] for this type of test? The only requirement is a local docker install. I’ve found it very useful for testing postgis in a repeatable manner, both in CI and locally.

Thanks,

[1] https://java.testcontainers.org/modules/databases/postgres/

···

Emilio Lahr-Vivaz
General Atomics, CCRi

From: Andrea Aime <andrea.aime@…6887…>
Sent: Tuesday, July 9, 2024 4:19 AM
To: Jody Garnett <jody.garnett@…403…>
Cc: Geoserver-devel geoserver-devel@lists.sourceforge.net
Subject: -EXT-Re: [Geoserver-devel] build.geoserver geoserver-main-app-schema-online job maintenance / discussion.

WARNING: This message is from an external source. Evaluate the message carefully BEFORE clicking on links or opening attachments.

And oh, my local postgis database has the postgis extensions installed.

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

On Tue, Jul 9, 2024 at 10:18 AM Andrea Aime <andrea.aime@…6887…> wrote:

Hi Jody,
the same way you run other online test cases in GeoTools.

For postgis, locally I have the following file in ~/.geoserver:

cat postgis.properties
#This is an example fixture. Update the values and remove the .example suffix to enable the test
#Mon Jan 23 12:28:28 CET 2023
password=mysecret
database=app-schema
driver=org.postgresql.Driver
passwd=mysecret
port=5432
host=localhost
dbtype=postgisng
user=myuser
url=jdbc:postgresql://localhost/app-schema

And then with maven in the path:

cd extension/app-schema/app-schema-postgis-test/

mvn clean install -Ponline -nsu -fae

If you had everything properly set up, the build should end with:

[INFO] Results:
[INFO]
[WARNING] Tests run: 319, Failures: 0, Errors: 0, Skipped: 1

I don’t have an Oracle ready for usage but the postgis ones already provide a good coverage of
the common cases.

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

On Tue, Jul 9, 2024 at 8:29 AM Jody Garnett <jody.garnett@…403…> wrote:

Niels,

How do you run the app-schema tests?

I create a ~/.geoserver/postgis.properties with connection parameters including a database name

And then run with:
mvn clean install -Papp-schema-online-test

When I run I get errors such as:

[ERROR] testNoPrimaryKey(org.geoserver.test.onlineTest.WfsOnlinePostgisTest) Time elapsed: 0.294 s <<< ERROR!
org.postgresql.util.PSQLException:
ERROR: function public.ndims(public.geometry) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 355

Looking at the build server job configuration I am shocked to see this is defined as part of the script:

#missing functions required for refdataset sql but removed in postgis 2.1

export PGPASSWORD=‘’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.ndims(g geometry) returns smallint as $$ begin return public.st_ndims(g); end; $$ language plpgsql immutable strict;’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.srid(g geometry) returns integer as $$ begin return public.st_srid(g); end; $$ language plpgsql immutable strict;’

Surely that cannot be right?
Is defining ndims part of the app schema installation instructions? No…

I How do you run the tests locally…

–
Jody Garnett

On Jul 8, 2024 at 5:29:42 AM, Niels Charlier <niels@…2918…> wrote:

Hello Jody

I have always run those tests locally whenever making changes that affect app-schema, not sure about Jenkins issues.

Kind Regards

Niels

On 06/07/2024 00:43, Jody Garnett wrote:

I have a PR that looks at some gaps in the GeoTools feature model around validation… and Niels made the perfectly sensible recommendation to run the app-schema online tests…

Checking build.geoserver.org the geoserver-main-app-schema-online is disabled

Looking at the configuration it was java 8 based, so this has been disabled for some time

The setup has a lot of messing around to get the ojdbc7.jar to talk to oracle-db.dev.boundlessgeo.com … so quite a long time.

Do we have an active module maintainer (or experienced developer) for application schema?

Trying it out:

I do not think the steps to copy ojdbc7.jar are required any more (since such a jar is now available via maven dependency)

Changing to Java 11 and commenting out the oracle.properties test fixed and running the job shows …

[INFO] Application Schema Support … SUCCESS [ 4.694 s]

[INFO] Application Schema Module … SUCCESS [ 9.101 s]

[INFO] Application Schema Integration Test … FAILURE [01:28 min]

[INFO] Sample DataAccess Integration Test … SUCCESS [ 4.919 s]

[INFO] Application Schema Integration Online Test with Postgis Database SUCCESS [01:14 min]

[INFO] Application Schema Solr Integration Test … SUCCESS [ 2.659 s]

[INFO] Application Schema Indexes Integration Test … SUCCESS [ 1.319 s]

[INFO] Application Schema Geopackage Integration Test … FAILURE [ 11.730 s]

So what do you think? Does this test have value? For now I will enable it but not schedule it @daily (in case anyone else wants to look).

Thanks

–
Jody Garnett

Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Andrea_Aime4 · July 9, 2024, 12:33pm

Yes,
we have ElasticSearch tests running that way. Quite nice.
As it’s often the case, we’re limited by lack of time. Contributors welcomed.

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

Niels_Charlier · July 9, 2024, 8:39pm

Seems you are missing the postgis extension, but I have no idea why that is in the script, that is strange indeed.

···

On 09/07/2024 08:28, Jody Garnett wrote:

Niels,

How do you run the app-schema tests?

I create a ~/.geoserver/postgis.properties with connection parameters including a database name

And then run with:
mvn clean install -Papp-schema-online-test

When I run I get errors such as:

[ERROR] testNoPrimaryKey(org.geoserver.test.onlineTest.WfsOnlinePostgisTest) Time elapsed: 0.294 s <<< ERROR!
org.postgresql.util.PSQLException:
ERROR: function public.ndims(public.geometry) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 355

Looking at the build server job configuration I am shocked to see this is defined as part of the script:

#missing functions required for refdataset sql but removed in postgis 2.1

export PGPASSWORD=‘’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.ndims(g geometry) returns smallint as $$ begin return public.st_ndims(g); end; $$ language plpgsql immutable strict;’

psql -h localhost -p 5432 -U geotools -d geotoolstest -c ‘create or replace function public.srid(g geometry) returns integer as $$ begin return public.st_srid(g); end; $$ language plpgsql immutable strict;’

Surely that cannot be right?
Is defining ndims part of the app schema installation instructions? No…

I How do you run the tests locally…

–
Jody Garnett

On Jul 8, 2024 at 5:29:42 AM, Niels Charlier <niels@…2918…> wrote:

Hello Jody

I have always run those tests locally whenever making changes that affect app-schema, not sure about Jenkins issues.

Kind Regards

Niels

On 06/07/2024 00:43, Jody Garnett wrote:

I have a PR that looks at some gaps in the GeoTools feature model around validation… and Niels made the perfectly sensible recommendation to run the app-schema online tests…

Checking build.geoserver.org the geoserver-main-app-schema-online is disabled

Looking at the configuration it was java 8 based, so this has been disabled for some time

The setup has a lot of messing around to get the ojdbc7.jar to talk to oracle-db.dev.boundlessgeo.com … so quite a long time.

Do we have an active module maintainer (or experienced developer) for application schema?

Trying it out:

I do not think the steps to copy ojdbc7.jar are required any more (since such a jar is now available via maven dependency)

Changing to Java 11 and commenting out the oracle.properties test fixed and running the job shows …

[INFO] Application Schema Support … SUCCESS [ 4.694 s]

[INFO] Application Schema Module … SUCCESS [ 9.101 s]

[INFO] Application Schema Integration Test … FAILURE [01:28 min]

[INFO] Sample DataAccess Integration Test … SUCCESS [ 4.919 s]

[INFO] Application Schema Integration Online Test with Postgis Database SUCCESS [01:14 min]

[INFO] Application Schema Solr Integration Test … SUCCESS [ 2.659 s]

[INFO] Application Schema Indexes Integration Test … SUCCESS [ 1.319 s]

[INFO] Application Schema Geopackage Integration Test … FAILURE [ 11.730 s]

So what do you think? Does this test have value? For now I will enable it but not schedule it @daily (in case anyone else wants to look).

Thanks

–
Jody Garnett

jive · July 11, 2024, 7:03pm

Niels and Andrea,

I am running postgis/postgis:16-3.4 which is the latest recommended. I assume postgis is installed when I am using that instance.

The postgis/postgis image provides tags for running Postgres with PostGIS⁠ extensions installed.

GeoTools
I used the same approach with ~/geotools/postgis.properties - to confirm I changed to match Andrea’s example with the following Dockerfile.

services:
db:
image: postgis/postgis:16-3.4
platform: linux/amd64
restart: always
environment:
POSTGRES_PASSWORD: ‘mysecret’
POSTGRES_USER: ‘myuser’
POSTGRES_DB: ‘app-schema’
volumes:

/Users/jgarnett/dev/geoserver/testing/db:/var/lib/postgresql/data
ports:
5432:5432

During startup I can see that PostGIS extension is being installed:

db-1 | CREATE EXTENSION

db-1 | Loading PostGIS extensions into app-schema

For good measure I confirmed by running the jdbc-postgis online tests successfully.

GeoServer

Andrea your example used -Ponline but perhaps you just had the geotools build in mind. If I use the same thing as the builds server:

cd src/extensions/app-schema
mvn clean install -Papp-schema-online-test -nsu -fae

Results in the following failures:

[INFO] Application Schema Support … SUCCESS [ 3.180 s]
[INFO] Application Schema Module … SUCCESS [ 3.175 s]
[INFO] Application Schema Integration Test … FAILURE [02:04 min]
[INFO] Sample DataAccess Integration Test … SUCCESS [ 3.817 s]
[INFO] Application Schema Integration Online Test with Oracle Database FAILURE [ 6.723 s]
[INFO] Application Schema Integration Online Test with Postgis Database SUCCESS [02:40 min]
[INFO] Application Schema MongoDB Integration Test … SUCCESS [ 4.095 s]
[INFO] Application Schema Solr Integration Test … SUCCESS [ 1.278 s]
[INFO] Application Schema Indexes Integration Test … SUCCESS [ 1.467 s]
[INFO] Application Schema Geopackage Integration Test … FAILURE [ 9.565 s]

For the geoserver build can you try -Papp-schema-online-test which is what is used by the build server. I would like to see if you get the same failure as me?

I am curious that Application Schema Integration Test and Application Schema Geopackage Integration Test fail presently.

···

–
Jody Garnett

jive · July 11, 2024, 7:31pm

Okay reporting the bug here https://osgeo-org.atlassian.net/browse/GEOT-7616 with a pull request.

The file Postgis_Data_ref_set.sql does not seem to be present in the geotools codebase presently; if anyone has details history it would be good!

···

–
Jody Garnett

jive · July 12, 2024, 11:02pm

I was able to get postgis integration tests working, thanks for your help everyone:

There remains integration tests failures (with geopackage and others), but I am going to call this a solid improvement and ask folks review the above two PRs.

···

–
Jody Garnett

Andrea_Aime4 · July 14, 2024, 10:11am

I did not remember, but there is actually already an online postgis app-schema build on Github.
You might want to have a look at it:
https://github.com/geoserver/geoserver/blob/main/.github/workflows/postgis_appschema_online.yml

Btw, it does indeed use the app-schema-online-test profile.

Looking at one random PR build logs:
https://productionresultssa15.blob.core.windows.net/actions-results/b110be38-b4b7-4040-a471-cd38443ce7c9/workflow-job-run-3f5256d7-ee1a-5cd3-cafb-0f27f5df5886/logs/job/job-logs.txt?rsct=text%2Fplain&se=2024-07-14T10%3A17%3A08Z&sig=9QdfwWvnbvbHEjaYX5hrUig71nAA1icyu5e97uTHyI4%3D&ske=2024-07-14T19%3A40%3A06Z&skoid=ca7593d4-ee42-46cd-af88-8b886a2f84eb&sks=b&skt=2024-07-14T07%3A40%3A06Z&sktid=398a6654-997b-47e9-b12b-9515b896b4de&skv=2023-11-03&sp=r&spr=https&sr=b&st=2024-07-14T10%3A07%3A03Z&sv=2023-11-03

I see the following:

2024-06-08T09:04:00.6934534Z [INFO] -------------------------------------------------------
2024-06-08T09:04:00.6935184Z [INFO]  T E S T S
2024-06-08T09:04:00.6935838Z [INFO] -------------------------------------------------------
2024-06-08T09:04:01.4943211Z [INFO] Running org.geoserver.test.BBox3DTest
2024-06-08T09:04:10.5385836Z SLF4J: No SLF4J providers were found.
2024-06-08T09:04:10.5387030Z SLF4J: Defaulting to no-operation (NOP) logger implementation
2024-06-08T09:04:10.5388139Z SLF4J: See [https://www.slf4j.org/codes.html#noProviders](https://www.slf4j.org/codes.html#noProviders) for further details.
2024-06-08T09:04:10.5389587Z SLF4J: Class path contains SLF4J bindings targeting slf4j-api versions 1.7.x or earlier.
2024-06-08T09:04:10.5392660Z SLF4J: Ignoring binding found at [jar:file:/home/runner/.m2/repository/org/apache/logging/log4j/log4j-slf4j-impl/2.17.2/log4j-slf4j-impl-2.17.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2024-06-08T09:04:10.5395540Z SLF4J: See [https://www.slf4j.org/codes.html#ignoredBindings](https://www.slf4j.org/codes.html#ignoredBindings) for an explanation.
2024-06-08T09:04:13.5947486Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 12.042 s - in org.geoserver.test.BBox3DTest
2024-06-08T09:04:13.5949129Z [INFO] Running org.geoserver.test.BBoxFilterTest
2024-06-08T09:04:15.3528364Z [INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.739 s - in org.geoserver.test.BBoxFilterTest
2024-06-08T09:04:15.3529895Z [INFO] Running org.geoserver.test.CSVOutputFormatTest
2024-06-08T09:04:16.5552129Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.195 s - in org.geoserver.test.CSVOutputFormatTest
2024-06-08T09:04:16.5559219Z [INFO] Running org.geoserver.test.ConnectionUsageTest
2024-06-08T09:04:17.7109314Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.151 s - in org.geoserver.test.ConnectionUsageTest
2024-06-08T09:04:17.7116293Z [INFO] Running org.geoserver.test.CoordinatesFormattingTest
2024-06-08T09:04:19.5350303Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.819 s - in org.geoserver.test.CoordinatesFormattingTest
2024-06-08T09:04:19.5354706Z [INFO] Running org.geoserver.test.DefaultIdTest
2024-06-08T09:04:21.4488719Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.909 s - in org.geoserver.test.DefaultIdTest
2024-06-08T09:04:21.4493132Z [INFO] Running org.geoserver.test.DuplicatePropertiesWfsTest
2024-06-08T09:04:22.7389446Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.285 s - in org.geoserver.test.DuplicatePropertiesWfsTest
2024-06-08T09:04:22.7393718Z [INFO] Running org.geoserver.test.DuplicateTypeTest
2024-06-08T09:04:24.3338173Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.591 s - in org.geoserver.test.DuplicateTypeTest
2024-06-08T09:04:24.3341184Z [INFO] Running org.geoserver.test.EncodeIfEmptyTest
2024-06-08T09:04:25.5136529Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.171 s - in org.geoserver.test.EncodeIfEmptyTest
2024-06-08T09:04:25.5139815Z [INFO] Running org.geoserver.test.FeatureChainingSharedConnectionTest
2024-06-08T09:04:27.3376259Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.824 s - in org.geoserver.test.FeatureChainingSharedConnectionTest
2024-06-08T09:04:27.3390212Z [INFO] Running org.geoserver.test.FeatureChainingWfsTest
2024-06-08T09:04:30.9250216Z [WARNING] Tests run: 32, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 3.58 s - in org.geoserver.test.FeatureChainingWfsTest
2024-06-08T09:04:30.9252198Z [INFO] Running org.geoserver.test.FeatureGML32Test
2024-06-08T09:04:32.5637512Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.635 s - in org.geoserver.test.FeatureGML32Test
2024-06-08T09:04:32.5643903Z [INFO] Running org.geoserver.test.GUChainNoIDMFTest
2024-06-08T09:04:33.5541723Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.986 s - in org.geoserver.test.GUChainNoIDMFTest
2024-06-08T09:04:33.5547821Z [INFO] Running org.geoserver.test.GeoJsonOutputFormatWfsTest
2024-06-08T09:04:35.2731997Z [INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.715 s - in org.geoserver.test.GeoJsonOutputFormatWfsTest
2024-06-08T09:04:35.2739073Z [INFO] Running org.geoserver.test.GetFeatureNumberMatchedGMLTest
2024-06-08T09:04:36.8769905Z [INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.586 s - in org.geoserver.test.GetFeatureNumberMatchedGMLTest
2024-06-08T09:04:36.8772163Z [INFO] Running org.geoserver.test.GetFeatureNumberMatchedGeoJSONTest
2024-06-08T09:04:38.7716255Z [INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.888 s - in org.geoserver.test.GetFeatureNumberMatchedGeoJSONTest
2024-06-08T09:04:38.7722916Z [INFO] Running org.geoserver.test.GetFeatureNumberMatchedWithoutPrimaryKeyGMLTest
2024-06-08T09:04:40.2665967Z [INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.488 s - in org.geoserver.test.GetFeatureNumberMatchedWithoutPrimaryKeyGMLTest
2024-06-08T09:04:40.2753591Z [INFO] Running org.geoserver.test.GetPropertyValueTest
2024-06-08T09:04:43.9486282Z [INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.681 s - in org.geoserver.test.GetPropertyValueTest
2024-06-08T09:04:43.9488072Z [INFO] Running org.geoserver.test.Gsml30WfsTest
2024-06-08T09:04:45.2729152Z [INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.32 s - in org.geoserver.test.Gsml30WfsTest
2024-06-08T09:04:45.2734899Z [INFO] Running org.geoserver.test.Gsml32BoreholeIntervalWfsTest
2024-06-08T09:04:46.1785742Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.901 s - in org.geoserver.test.Gsml32BoreholeIntervalWfsTest
2024-06-08T09:04:46.1799482Z [INFO] Running org.geoserver.test.Gsml32BoreholeWfsTest
2024-06-08T09:04:47.0367809Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.853 s - in org.geoserver.test.Gsml32BoreholeWfsTest
2024-06-08T09:04:47.0375758Z [INFO] Running org.geoserver.test.HandlesIncludesTest
2024-06-08T09:04:47.9562423Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.911 s - in org.geoserver.test.HandlesIncludesTest
2024-06-08T09:04:47.9568491Z [INFO] Running org.geoserver.test.IdFunctionWfsTest
2024-06-08T09:04:48.9923388Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.032 s - in org.geoserver.test.IdFunctionWfsTest
2024-06-08T09:04:48.9924870Z [INFO] Running org.geoserver.test.IdFunctionWfsWithJoiningTest
2024-06-08T09:04:49.8660593Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.87 s - in org.geoserver.test.IdFunctionWfsWithJoiningTest
2024-06-08T09:04:49.8666419Z [INFO] Running org.geoserver.test.IdNotEncodedTest
2024-06-08T09:04:50.7347809Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.863 s - in org.geoserver.test.IdNotEncodedTest
2024-06-08T09:04:50.7352567Z [INFO] Running org.geoserver.test.InvalidColumnTest
2024-06-08T09:04:51.5032058Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.764 s - in org.geoserver.test.InvalidColumnTest
2024-06-08T09:04:51.5035022Z [INFO] Running org.geoserver.test.IsolatedNamespacesWfsTest
2024-06-08T09:04:52.7318315Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.222 s - in org.geoserver.test.IsolatedNamespacesWfsTest
2024-06-08T09:04:52.7324887Z [INFO] Running org.geoserver.test.LayersNamesAliasingTest
2024-06-08T09:04:54.0111005Z [INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.27 s - in org.geoserver.test.LayersNamesAliasingTest
2024-06-08T09:04:54.0112566Z [INFO] Running org.geoserver.test.LocalResolveFeatureChainingByRefTest
2024-06-08T09:04:55.4776631Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.464 s - in org.geoserver.test.LocalResolveFeatureChainingByRefTest
2024-06-08T09:04:55.4780457Z [INFO] Running org.geoserver.test.LocalResolveTest
2024-06-08T09:04:58.1272114Z [INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.647 s - in org.geoserver.test.LocalResolveTest
2024-06-08T09:04:58.1274248Z [INFO] Running org.geoserver.test.MappingNameTest
2024-06-08T09:04:59.0271173Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.897 s - in org.geoserver.test.MappingNameTest
2024-06-08T09:04:59.0277158Z [INFO] Running org.geoserver.test.MeasureTypeBindingTest
2024-06-08T09:04:59.8258953Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.793 s - in org.geoserver.test.MeasureTypeBindingTest
2024-06-08T09:04:59.8260901Z [INFO] Running org.geoserver.test.MultiGeometryTest
2024-06-08T09:05:00.4791133Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.651 s - in org.geoserver.test.MultiGeometryTest
2024-06-08T09:05:00.4803242Z [INFO] Running org.geoserver.test.MultivaluedXlinkHrefTest
2024-06-08T09:05:01.4208525Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.939 s - in org.geoserver.test.MultivaluedXlinkHrefTest
2024-06-08T09:05:01.4209964Z [INFO] Running org.geoserver.test.NamespacesWfsTest
2024-06-08T09:05:02.8665619Z [INFO] Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.441 s - in org.geoserver.test.NamespacesWfsTest
2024-06-08T09:05:02.8675624Z [INFO] Running org.geoserver.test.NestedElementsFilteringTest
2024-06-08T09:05:03.7452298Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.874 s - in org.geoserver.test.NestedElementsFilteringTest
2024-06-08T09:05:03.7454268Z [INFO] Running org.geoserver.test.NestedGeometryFilterEncodingTest
2024-06-08T09:05:04.5844789Z [INFO] Tests run: 13, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.836 s - in org.geoserver.test.NestedGeometryFilterEncodingTest
2024-06-08T09:05:04.5851121Z [INFO] Running org.geoserver.test.NestedIdSupportTest
2024-06-08T09:05:05.7698642Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.182 s - in org.geoserver.test.NestedIdSupportTest
2024-06-08T09:05:05.7704494Z [INFO] Running org.geoserver.test.NoIdExpressionTest
2024-06-08T09:05:06.5019851Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.727 s - in org.geoserver.test.NoIdExpressionTest
2024-06-08T09:05:06.5025712Z [INFO] Running org.geoserver.test.NormalizedMultiValuesTest
2024-06-08T09:05:07.8541991Z [INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.348 s - in org.geoserver.test.NormalizedMultiValuesTest
2024-06-08T09:05:07.8549452Z [INFO] Running org.geoserver.test.Observation_2_0_WfsTest
2024-06-08T09:05:08.6418700Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.784 s - in org.geoserver.test.Observation_2_0_WfsTest
2024-06-08T09:05:08.6420505Z [INFO] Running org.geoserver.test.PagingTest
2024-06-08T09:05:10.8607086Z [INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.214 s - in org.geoserver.test.PagingTest
2024-06-08T09:05:10.8611526Z [INFO] Running org.geoserver.test.PolymorphismInlineWfsTest
2024-06-08T09:05:11.6644252Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.799 s - in org.geoserver.test.PolymorphismInlineWfsTest
2024-06-08T09:05:11.6645984Z [INFO] Running org.geoserver.test.PolymorphismWfsTest
2024-06-08T09:05:12.5159158Z [INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.848 s - in org.geoserver.test.PolymorphismWfsTest
2024-06-08T09:05:12.5165359Z [INFO] Running org.geoserver.test.PropertyEncodingOrderTest
2024-06-08T09:05:14.0277712Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.508 s - in org.geoserver.test.PropertyEncodingOrderTest
2024-06-08T09:05:14.0283472Z [INFO] Running org.geoserver.test.PropertySelectionTest
2024-06-08T09:05:15.1764336Z [INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.143 s - in org.geoserver.test.PropertySelectionTest
2024-06-08T09:05:15.1772952Z [INFO] Running org.geoserver.test.Reprojection3DTest
2024-06-08T09:05:16.0167529Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.836 s - in org.geoserver.test.Reprojection3DTest
2024-06-08T09:05:16.0173292Z [INFO] Running org.geoserver.test.ReprojectionAxisFlipTest
2024-06-08T09:05:16.7514793Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.73 s - in org.geoserver.test.ReprojectionAxisFlipTest
2024-06-08T09:05:16.7518135Z [INFO] Running org.geoserver.test.RestconfigWfsTest
2024-06-08T09:05:18.1013718Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.286 s - in org.geoserver.test.RestconfigWfsTest
2024-06-08T09:05:18.1015467Z [INFO] Running org.geoserver.test.SRSReprojectionTest
2024-06-08T09:05:19.1196281Z [INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.012 s - in org.geoserver.test.SRSReprojectionTest
2024-06-08T09:05:19.1197572Z [INFO] Running org.geoserver.test.SRSWfsTest
2024-06-08T09:05:19.7263893Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.603 s - in org.geoserver.test.SRSWfsTest
2024-06-08T09:05:19.7271146Z [INFO] Running org.geoserver.test.SameNameDiffNamespaceTest
2024-06-08T09:05:20.2800985Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.548 s - in org.geoserver.test.SameNameDiffNamespaceTest
2024-06-08T09:05:20.2802775Z [INFO] Running org.geoserver.test.SameNestedAttributeTest
2024-06-08T09:05:21.1059982Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.823 s - in org.geoserver.test.SameNestedAttributeTest
2024-06-08T09:05:21.1067516Z [INFO] Running org.geoserver.test.SecondaryNamespaceTest
2024-06-08T09:05:21.7659026Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.656 s - in org.geoserver.test.SecondaryNamespaceTest
2024-06-08T09:05:21.7665662Z [INFO] Running org.geoserver.test.SecuredFeatureChainingTest
2024-06-08T09:05:23.2186228Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.448 s - in org.geoserver.test.SecuredFeatureChainingTest
2024-06-08T09:05:23.2188110Z [INFO] Running org.geoserver.test.SimpleAttributeFeatureChainWfsTest
2024-06-08T09:05:24.5467359Z [INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.324 s - in org.geoserver.test.SimpleAttributeFeatureChainWfsTest
2024-06-08T09:05:24.5473813Z [INFO] Running org.geoserver.test.SimpleOutputTest
2024-06-08T09:05:25.7290306Z [INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.177 s - in org.geoserver.test.SimpleOutputTest
2024-06-08T09:05:25.7299680Z [INFO] Running org.geoserver.test.SortByTest
2024-06-08T09:05:26.6840742Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.945 s - in org.geoserver.test.SortByTest
2024-06-08T09:05:26.6851770Z [INFO] Running org.geoserver.test.SpecimenWfsTest
2024-06-08T09:05:27.5287836Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.837 s - in org.geoserver.test.SpecimenWfsTest
2024-06-08T09:05:27.5289116Z [INFO] Running org.geoserver.test.StringConstantIdWfsTest
2024-06-08T09:05:28.2793853Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.747 s - in org.geoserver.test.StringConstantIdWfsTest
2024-06-08T09:05:28.2795478Z [INFO] Running org.geoserver.test.SubstitutionGroupCoverageWfsTest
2024-06-08T09:05:28.9779746Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.694 s - in org.geoserver.test.SubstitutionGroupCoverageWfsTest
2024-06-08T09:05:28.9800204Z [INFO] Running org.geoserver.test.SubstitutionGroupTest
2024-06-08T09:05:29.8611948Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.878 s - in org.geoserver.test.SubstitutionGroupTest
2024-06-08T09:05:29.8628222Z [INFO] Running org.geoserver.test.TimeSeriesInlineWfsTest
2024-06-08T09:05:30.7876757Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.921 s - in org.geoserver.test.TimeSeriesInlineWfsTest
2024-06-08T09:05:30.7897142Z [INFO] Running org.geoserver.test.TimeSeriesWfsTest
2024-06-08T09:05:31.6570663Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.86 s - in org.geoserver.test.TimeSeriesWfsTest
2024-06-08T09:05:31.6572343Z [INFO] Running org.geoserver.test.UnboundedSequenceMultiValuesTest
2024-06-08T09:05:32.6992775Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.035 s - in org.geoserver.test.UnboundedSequenceMultiValuesTest
2024-06-08T09:05:32.6994839Z [INFO] Running org.geoserver.test.ValidationTest
2024-06-08T09:05:33.6632045Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.961 s - in org.geoserver.test.ValidationTest
2024-06-08T09:05:33.6634178Z [INFO] Running org.geoserver.test.WaterMLTimeSeriesWfsTest
2024-06-08T09:05:34.5709806Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.902 s - in org.geoserver.test.WaterMLTimeSeriesWfsTest
2024-06-08T09:05:34.5722633Z [INFO] Running org.geoserver.test.WmsGetFeatureInfoTest
2024-06-08T09:05:35.9175272Z Jun 08, 2024 9:05:35 AM java.util.prefs.FileSystemPreferences$1 run
2024-06-08T09:05:35.9176244Z INFO: Created user preferences directory.
2024-06-08T09:05:36.4109790Z [INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.836 s - in org.geoserver.test.WmsGetFeatureInfoTest
2024-06-08T09:05:36.4116076Z [INFO] Running org.geoserver.test.WmsGetLegendGraphicTest
2024-06-08T09:05:38.4046838Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.988 s - in org.geoserver.test.WmsGetLegendGraphicTest
2024-06-08T09:05:38.4057768Z [INFO] Running org.geoserver.test.WmsGetMapTest
2024-06-08T09:05:39.5052809Z [INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.097 s - in org.geoserver.test.WmsGetMapTest
2024-06-08T09:05:39.5054757Z [INFO] Running org.geoserver.test.XPathPredicateTest
2024-06-08T09:05:40.8334148Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.323 s - in org.geoserver.test.XPathPredicateTest
2024-06-08T09:05:40.8340981Z [INFO] Running org.geoserver.test.XYGeomTest
2024-06-08T09:05:41.4175422Z [INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.58 s - in org.geoserver.test.XYGeomTest
2024-06-08T09:05:41.4180753Z [INFO] Running org.geoserver.test.XlinkGeometryTest
2024-06-08T09:05:41.9029369Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.482 s - in org.geoserver.test.XlinkGeometryTest
2024-06-08T09:05:41.9031462Z [INFO] Running org.geoserver.test.XlinkWfsTest
2024-06-08T09:05:42.6748917Z [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.769 s - in org.geoserver.test.XlinkWfsTest
2024-06-08T09:05:42.6750545Z [INFO] Running org.geoserver.test.web.Gml311LinksTest
2024-06-08T09:05:44.7443891Z [INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.066 s - in org.geoserver.test.web.Gml311LinksTest
2024-06-08T09:05:44.7459353Z [INFO] Running org.geoserver.test.web.Gml32LinksTest
2024-06-08T09:05:45.9406524Z [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.193 s - in org.geoserver.test.web.Gml32LinksTest
2024-06-08T09:05:46.3155309Z [INFO] 
2024-06-08T09:05:46.3155745Z [INFO] Results:
2024-06-08T09:05:46.3156138Z [INFO] 
2024-06-08T09:05:46.3158854Z [WARNING] Tests run: 319, Failures: 0, Errors: 0, Skipped: 1
2024-06-08T09:05:46.3160388Z [INFO]

I have the impression the tests are being run (and passing), or do you think they are taking
that much time, but not actually execute? I’m not an expert in the matter, just wanted to avoid some
confusion that happened as Gabriel was proposing some (good!) changes to the app-schema module,
and came up with this PR (which I’ve then totally forgot about).

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

jive · July 14, 2024, 9:15pm

Nice,

I am a bit confused why it is working, perhaps the srid and ndims functions were only removed in a newer PostGIS? Or defined in the custom postgis action …

The magic must be in amrocha/postgis action?

Still the changes I have made allow the build to work in the most recent recommended postgis which I believe is a good thing.

···

–
Jody Garnett

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Andrea_Aime4 · July 15, 2024, 9:02am

Hi Jody,
that action is really the same we use for the GeoTools build, with a couple of commits more, as the
huaxk one (used in the postgis geotools action) has fell un-maintained:
https://github.com/amrocha/postgis-action

Both actions indeed use postgresql version 11, which fell out of support six months ago.
Our policy has been, so far, to test and support the oldest version we can, while being as compatible as possible with the new ones,
but indeed we should be building with postgresql 12 now. Having a build matrix to test support up to version 16
would be great, I would not be surprised if the basic postgis tests (the postgis datastore one, not app-schema)
would not fully pass with the latest.

For reference, locally I have a postgresql 14 with postgis 3.2, and both the postgis store test, and the app-schema integration test
pass fully without any changes to the sources:

postgis store tests
[WARNING] Tests run: 1010, Failures: 0, Errors: 0, Skipped: 5

app-schema-postgis-tests
[WARNING] Tests run: 319, Failures: 0, Errors: 0, Skipped: 1

Hum… and now I notice that the tests actually using the reference data are not in the list of executed tests, at all?
E.g., I don’t see DataReferenceWmsPostgisTest in the output of the app-schema-postgis-tests
How is this possible? Oh because they were excluded from the build, in a profile that activates by default,
and that I guess needs to be forcefully disabled instead?
https://github.com/geoserver/geoserver/blame/main/src/extension/app-schema/app-schema-test/pom.xml

Mind, as far as I know, the test that are being run, do run against PostgreSQL with some magic that
replaces the data fixtures (I can see postgres in use while those tests are running).

Even running with -P!offline does not add the back… hmm… ah, but I’m running the tests inside app-schema-postgis-test
while the Jenkins build runs from the top level. Perhaps that’s the difference?
I get plenty of failures in app-schema-test but indeed I never run an online build in it, only in the dedicated postgis module instead.

Nuno, how do you run the app-schema tests locally? Any comment about the ones using the “reference data”?

Regards,

···

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Shaozhong_SHI · July 15, 2024, 12:19pm

Can anyone send me instructions?

It is for loading geodata onto PostGIS.

Regards,

David

···

–
Jody Garnett

jive · July 15, 2024, 2:26pm

Yes I was going to recommend removing the excludes, which are there to prevent double testing.

And instead exclude the tests upstream. Since that plugin does not pass requiring both oracle and postgis at the same time.

Better to test oracle and postgis independently.

···

–
Jody Garnett

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail

–
Jody Garnett

jive · July 15, 2024, 6:41pm

You are not contacting the right list (this one is for geoserver development).

···

–
Jody Garnett