Changes between Version 209 and Version 210 of Versions

Timestamp:

Mar 26, 2022, 7:19:15 AM (2 years ago)

Author:

Dimitar Misev

Comment:

—

Versions

@@ -49 +49 @@
  - Support GDAL 3 when transforming coordinates with regards to EPSG CRS YX axis orders
  - Allow non-ASCII characters in coverage metadata
+ - (v10.0.1) Fixed leak of large binary objects in PostgreSQL which were left in petascopedb when removing data, e.g. dropping a coverage, pyramid levels, styles, etc; these objects will be properly and automatically removed via triggers from now on.
+
+  However, the already leaked orphan objects cannot be automatically removed, and require the following steps to address in order to reduce the size of petascopedb:
+{{{
+#!sh
+# Stop rasdaman and embedded petascope if exists
+sudo service rasdaman stop
+# If petascope runs on external tomcat, then stop it
+sudo service tomcat9 stop
+# Rename the existing petascopedb to petascopedb_backup
+sudo -u postgres psql -c "ALTER DATABASE petascopedb RENAME TO petascopedb_backup"
+# Create a new empty database
+sudo -u postgres createdb petascopedb
+# Change in petascope.properties
+metadata_url=jdbc:postgresql://localhost:5432/petascopedb_backup
+# Finally, run migration script to copy only the relevant data from
+# petascopedb_backup to the new petascopedb
+/opt/rasdaman/bin/migrate_petascopedb.sh
+# Start rasdaman (and Tomcat if needed)
+sudo service rasdaman start
+sudo service tomcat9 start
+# Verify that services are working as expected, if all is fine the
+# petascopedb_backup can be dropped from PostgreSQL (but maybe consider
+# exporting it to a backup first)
+sudo -u postgres dropdb petascopedb_backup
+}}}
+
 
 - wcst_import
@@ -279 +306 @@
 
 === Full list of commits
+
+==== v10.0.1 (2022-03-28)
+
+'''Addressed tickets''' between v10.0.0 and v10.0.1 with 3 commits:
+{{{
+#!sh
+echo "||= changeset =||= author =||= ticket =||= subject =||" && \
+git log --pretty=format:"|| changeset:%h || %an || %s" v10.0.0..v10.0.1 | sort -k 3 -t ':' -n | sed 's/ticket:\([0-9]*[^ ]\) -* */ticket:\1 || /'
+}}}
+|| changeset:e460270cb || Bang Pham Huu || ticket:2522 || [FIX] wcst_import supports null values per band
+|| changeset:a853b3ba1 || Dimitar Misev || ticket:2542 || add details on patch submission to the docs
+|| changeset:1b880ecf8 || Bang Pham Huu || ticket:2564 || FIX - postgresql - create triggers for cleaning large objects (CLOB) of TEXT type when update / remove
 
 ==== v10.0.0 (2022-03-18)