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 On Sun, Jul 14, 2024 at 3:11 AM Andrea Aime < andrea.a...@geosolutionsgroup.com> wrote: > 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 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 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 > <https://github.com/geoserver/geoserver/pull/7453> (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 > > > On Sat, Jul 13, 2024 at 1:03 AM Jody Garnett <jody.garn...@gmail.com> > wrote: > >> I was able to get postgis integration tests working, thanks for your help >> everyone: >> >> >> - [GEOS-6883] Improvements to app schema integration tests >> <https://github.com/geoserver/geoserver/pull/7772> >> - [GEOT-7616] Postgis_Data_ref_set.sql updates for modern PostGIS >> releases <https://github.com/geotools/geotools/pull/4841> >> >> >> 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 >> >> >> On Jul 11, 2024 at 12:31:31 PM, Jody Garnett <jody.garn...@gmail.com> >> wrote: >> >>> 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 >>> >>> >>> On Jul 11, 2024 at 12:03:04 PM, Jody Garnett <jody.garn...@gmail.com> >>> wrote: >>> >>>> 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 >>>> >>>> >>>> On Jul 9, 2024 at 1:39:05 PM, Niels Charlier <ni...@scitus.be> wrote: >>>> >>>>> 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? >>>>> >>>>> >>>>> 1. I create a ~/.geoserver/postgis.properties with connection >>>>> parameters including a database name >>>>> 2. 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 <ni...@scitus.be> 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 >>>>>> <https://dficcfc.r.af.d.sendibt2.com/tr/cl/QnmEf4CiLzefQ8tvswpygu_mKOoVQYE_ymKm8YxI8KlC5Oky3xgemTOMFlheDxw7yfA0Ckx8oGqw94a_hRDOlVGXZewXdciN7xvD7M_rEd1R1rtu2mMm59pwZkkH2ZiMCWaeHCpmMWjPZd9E9F6M7TJtVQYL6Juaazw0CeqmAs90WSKZg5UI6sm8-3kOEC137-01Uu5tc2aY7FtDR-RwG1pkloVK2u99LweEcTF6j2KySuBjL90_-4IjweVKflwwU6cfARFQDGeH5iSioGKRuHZ7ZlMdX-73ykakFUTCQcrnS-EW> >>>>>> 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... >>>>>> >>>>>> >>>>>> 1. Checking build.geoserver.org >>>>>> >>>>>> <https://dficcfc.r.af.d.sendibt2.com/tr/cl/XzwiyRYFMgufdjTffCOZKuLas1HzYo0A3G72jOEFBlOrZhk15PUdzFckDA1jFwcllUEiVQf6DKw68XxItKGLGa_2j5AP4TDPcUVDSLIaM6ZZkc1fnToljiZcp6hoYtejFQ9NY3IFWDnwTnMoyGKjIND376ahzpSRmwOuyi-qg9HKc_mfbNkdj2ZiWqCxPnIqI3RM8HSIx-C2D5RqmkXtDuQ-f-Ihutyv_OxLvVyT-j0MrOkLGFf2fr-6nKMioMiX750R24zo5Vw> >>>>>> the geoserver-main-app-schema-online >>>>>> >>>>>> <https://dficcfc.r.af.d.sendibt2.com/tr/cl/Ds5yMP0W1nLQwCo3m3ZabKQg8Jh23U86KCnuN506HyWCU_4ODqDvVJrIJzYbBRDZwAuXUBwR71PGYTp23w6jz_JmJtiPcq0MQTZygJYByi5KCStdM_mNHPWewpnAKJmLclqereIIZ0vgfvcNEtpqj82LW2kzfLFIpFvLJSVpK3L8sKE6Kq9c2I80ouevPJIq7lfJfNVHLgfK9fgV766Z2zy1Ky67C9bcm__h3JLGg8QycLVrCSz9SHnqqmb7T3Xh0n3NLvQjE3kM-iKcCDi8clbWOmRL7HOz2o-uC2ugxZml7bxBSUnbVUPUnUJjRQFX_fjZEPrpBXq4DznMFs1KD7p71tgFScz9> >>>>>> is disabled >>>>>> 2. Looking at the configuration it was java 8 based, so this has >>>>>> been disabled for some time >>>>>> 3. The setup has a lot of messing around to get the ojdbc7.jar to >>>>>> talk to oracle-db.dev.boundlessgeo.com >>>>>> >>>>>> <https://dficcfc.r.af.d.sendibt2.com/tr/cl/unOkFWXeyJmZIY8qRTRfEOWS7MGyOk4vkdzoJyUiwkcH9yRsDojjPS_a77MX248fX9iZJGLRLX_qf5Rhme4iUNeTWwPvePI2TTI46ny9WtEcprgjPVkdaKgW5yZV8sbuW4InphYTDd0l1E7xMMxaUvthsp69SyJB2DiWJ4IJiYU7u2Kgb2xPk_qYdiLx57HZKfzX2_SwJtpS5nD-ZmeJm7F5DF2VZKTj6qgTUd6HnHQnvGM9X1JvFm60YhkBoEIJfXLt7P-eHDHbvODtvxVsyQK_lQ> >>>>>> ... 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 >>>>>> >>>>>> <https://dficcfc.r.af.d.sendibt2.com/tr/cl/LfbWvC9tnFQ2Kw5ymOBeMXXeT8KmZn9PWK0NdXq52y5AYgfeX8mz06QT5ntFE-CKVt-ayEtPArTWSd2tixGSIEsOCw19g25HJNXHOpr7XEwluNq1_BUiIrzgr0flipi2EIBE8KbuuRpPJXKaGRA2Lc0Nq-UGcqd0p5tdbGWmOc5AA4-VnX7OxNt0O9ruU8yWc999jWsXXc3VeywtedDPUsdFmae6wzsRP-4lxATCFNfq7_TZn2NA9YJxiX_sa-razs2GEF-J8k9jk_XwnjqgwFLRgTL0v7uOSSiOdKI3ZO1kYTVxFfvfGfeD35FNb9SHic25FOFs2A6n63ff920JMw9Ed0YNZZmfuzP9lex9> >>>>>> ... >>>>>> >>>>>> >>>>>> *[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
