10 | | == Version 10.0 |
| 10 | == Version 10.0.1 (2022-03-28) |
| 11 | |
| 12 | === Bug fixes |
| 13 | |
| 14 | - OGC frontend (petascope) |
| 15 | - 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. |
| 16 | |
| 17 | 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: |
| 18 | {{{ |
| 19 | #!sh |
| 20 | # Stop rasdaman and embedded petascope if exists |
| 21 | sudo service rasdaman stop |
| 22 | # If petascope runs on external tomcat, then stop it |
| 23 | sudo service tomcat9 stop |
| 24 | # Rename the existing petascopedb to petascopedb_backup |
| 25 | sudo -u postgres psql -c "ALTER DATABASE petascopedb RENAME TO petascopedb_backup" |
| 26 | # Create a new empty database |
| 27 | sudo -u postgres createdb petascopedb |
| 28 | # Change in petascope.properties |
| 29 | metadata_url=jdbc:postgresql://localhost:5432/petascopedb_backup |
| 30 | # Finally, run migration script to copy only the relevant data from |
| 31 | # petascopedb_backup to the new petascopedb |
| 32 | /opt/rasdaman/bin/migrate_petascopedb.sh |
| 33 | # Start rasdaman (and Tomcat if needed) |
| 34 | sudo service rasdaman start |
| 35 | sudo service tomcat9 start |
| 36 | # Verify that services are working as expected, if all is fine the |
| 37 | # petascopedb_backup can be dropped from PostgreSQL (but maybe consider |
| 38 | # exporting it to a backup first) |
| 39 | sudo -u postgres dropdb petascopedb_backup |
| 40 | }}} |
| 41 | |
| 42 | === Full list of commits |
| 43 | |
| 44 | '''Addressed tickets''' between v10.0.0 and v10.0.1 with 3 commits: |
| 45 | {{{ |
| 46 | #!sh |
| 47 | echo "||= changeset =||= author =||= ticket =||= subject =||" && \ |
| 48 | 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 || /' |
| 49 | }}} |
| 50 | || changeset:e460270cb || Bang Pham Huu || ticket:2522 || [FIX] wcst_import supports null values per band |
| 51 | || changeset:a853b3ba1 || Dimitar Misev || ticket:2542 || add details on patch submission to the docs |
| 52 | || changeset:1b880ecf8 || Bang Pham Huu || ticket:2564 || FIX - postgresql - create triggers for cleaning large objects (CLOB) of TEXT type when update / remove |
| 53 | |
| 54 | |
| 55 | |
| 56 | == Version 10.0.0 (2022-03-18) |
51 | | - (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. |
52 | | |
53 | | 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: |
54 | | {{{ |
55 | | #!sh |
56 | | # Stop rasdaman and embedded petascope if exists |
57 | | sudo service rasdaman stop |
58 | | # If petascope runs on external tomcat, then stop it |
59 | | sudo service tomcat9 stop |
60 | | # Rename the existing petascopedb to petascopedb_backup |
61 | | sudo -u postgres psql -c "ALTER DATABASE petascopedb RENAME TO petascopedb_backup" |
62 | | # Create a new empty database |
63 | | sudo -u postgres createdb petascopedb |
64 | | # Change in petascope.properties |
65 | | metadata_url=jdbc:postgresql://localhost:5432/petascopedb_backup |
66 | | # Finally, run migration script to copy only the relevant data from |
67 | | # petascopedb_backup to the new petascopedb |
68 | | /opt/rasdaman/bin/migrate_petascopedb.sh |
69 | | # Start rasdaman (and Tomcat if needed) |
70 | | sudo service rasdaman start |
71 | | sudo service tomcat9 start |
72 | | # Verify that services are working as expected, if all is fine the |
73 | | # petascopedb_backup can be dropped from PostgreSQL (but maybe consider |
74 | | # exporting it to a backup first) |
75 | | sudo -u postgres dropdb petascopedb_backup |
76 | | }}} |
77 | | |
308 | | |
309 | | ==== v10.0.1 (2022-03-28) |
310 | | |
311 | | '''Addressed tickets''' between v10.0.0 and v10.0.1 with 3 commits: |
312 | | {{{ |
313 | | #!sh |
314 | | echo "||= changeset =||= author =||= ticket =||= subject =||" && \ |
315 | | 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 || /' |
316 | | }}} |
317 | | || changeset:e460270cb || Bang Pham Huu || ticket:2522 || [FIX] wcst_import supports null values per band |
318 | | || changeset:a853b3ba1 || Dimitar Misev || ticket:2542 || add details on patch submission to the docs |
319 | | || changeset:1b880ecf8 || Bang Pham Huu || ticket:2564 || FIX - postgresql - create triggers for cleaning large objects (CLOB) of TEXT type when update / remove |