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
