Mercurial > hg > orthanc-databases
annotate PostgreSQL/NEWS @ 429:dbf811b1bb43 pg-transactions
new configuration 'EnableVerboseLogs' to log SQL statements being executed
author | Alain Mazy <am@osimis.io> |
---|---|
date | Thu, 30 Nov 2023 14:47:23 +0100 |
parents | 3cdea26ece73 |
children | f1f3c5554283 |
rev | line source |
---|---|
429
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
1 Pending changes in the mainline |
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
2 =============================== |
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
3 |
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
4 * New "EnableVerboseLogs" configuration to show SQL statements being executed. |
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
5 |
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
6 |
419 | 7 Release 5.1 (2023-06-27) |
8 ======================== | |
0 | 9 |
418
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
10 * Experimental debug feature: |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
11 Introduced 2 new configurations with these default values: |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
12 "ReadOnlyTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ ONLY" |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
13 "ReadWriteTransactionStatement": "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE READ WRITE" |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
14 You can now customize the transaction isolation level. |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
15 If setting these values to "", no statement is run and therefore, the default DB or server |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
16 isolation level is used. |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
17 * internals: |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
18 - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
19 - Added an advisory lock around CreateInstance |
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
20 |
415
7e123f047771
LookupResources optimization continued
Alain Mazy <am@osimis.io>
parents:
412
diff
changeset
|
21 * Optimization of LookupResources mainly used in tools/find, C-Find and QIDO-RS. |
410
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
22 |
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
23 Release 5.0 (2023-04-15) |
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
24 ======================== |
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
25 |
412 | 26 * Added support for labels |
386 | 27 * Compatibility with Orthanc SDK 1.12.0 (communications between the |
28 Orthanc core and the database plugin using Google Protocol Buffers) | |
358
1280b40d6696
switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
276
diff
changeset
|
29 * Upgraded dependencies for static builds (notably on Windows and LSB): |
400
897253c21208
support for labels in mysql
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
386
diff
changeset
|
30 - openssl 3.1.0 |
358
1280b40d6696
switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
276
diff
changeset
|
31 |
276
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
32 |
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
33 Release 4.0 (2021-04-22) |
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
34 ======================== |
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
35 |
253
3bc442765b88
new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
248
diff
changeset
|
36 * New option "IndexConnectionsCount" to control how many simultaneous |
3bc442765b88
new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
248
diff
changeset
|
37 connections to the PostgreSQL database are used by the index plugin |
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
253
diff
changeset
|
38 * Support of revisions for metadata and attachments |
248
7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
243
diff
changeset
|
39 * Support of multiple readers/writers, by handling retries from Orthanc SDK 1.9.2 |
7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
243
diff
changeset
|
40 * Support of range reads for the storage area, from Orthanc SDK 1.9.0 |
267 | 41 * Fix issue #193 (LSB binaries crash with PostgreSQL + SSL) by changeset |
426
d700c8f9fc24
migration to UCLouvain servers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
419
diff
changeset
|
42 in OrthancFramework: https://orthanc.uclouvain.be/hg/orthanc/rev/9a9118406484 |
269
567761f0c1ea
fix issue #151: support of retries in the storage area plugins to deal with multiple writers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
268
diff
changeset
|
43 * Fix issue #151 (Storage failures when running with two instances and PG_LOCK=false) |
195
53bd9022c58b
Support of "OrthancPluginRegisterStorageArea2()" from Orthanc SDK 1.9.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
179
diff
changeset
|
44 |
179
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
45 |
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
46 Release 3.3 (2020-12-14) |
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
47 ======================== |
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
48 |
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
49 * Added an advisory lock to avoid race conditions during database setup |
141
0b3e9ee53c46
Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents:
134
diff
changeset
|
50 * Added "MaximumConnectionRetries" & "ConnectionRetryInterval" to configure |
0b3e9ee53c46
Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents:
134
diff
changeset
|
51 the retries when connecting to the DB at startup |
156
710537acb488
dynamic linking against the system-wide Orthanc framework library
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
141
diff
changeset
|
52 * Support of dynamic linking against the system-wide Orthanc framework library |
172
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
156
diff
changeset
|
53 * Upgraded dependencies for static builds (notably on Windows and LSB): |
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
156
diff
changeset
|
54 - openssl 1.1.1g |
268 | 55 - libpq 13.1 (replacing libpq 9.6.1) |
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
56 |
132
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
57 |
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
58 Release 3.2 (2019-03-01) |
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
59 ======================== |
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
60 |
130
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
61 * Explicit deallocation of prepared statements |
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
62 |
125
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
63 |
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
64 Release 3.1 (2019-02-08) |
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
65 ======================== |
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
66 |
103 | 67 * Fix build on Debian Buster |
106
b559af8fe6e0
Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
103
diff
changeset
|
68 * Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL |
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
106
diff
changeset
|
69 * Implementation of new extensions: LookupResourceAndParent and GetAllMetadata |
121
0886da5b4816
integration pg-tcp-nodelay->mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
117
diff
changeset
|
70 * Performance: Defining option "TCP_NODELAY" if libpq is linked statically |
103 | 71 |
100 | 72 |
73 Release 3.0 (2019-01-21) | |
74 ======================== | |
75 | |
81
515a783630df
injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
56
diff
changeset
|
76 * New configuration option: "EnableSsl" |
80
16df1a6ea452
Fix issue 105 (Unable to connect to PostgreSQL database using SSL)
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
77 * Database optimizations by implementing new primitives of Orthanc SDK 1.5.2 |
81
515a783630df
injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
56
diff
changeset
|
78 * Fix issue 105 (Unable to connect to PostgreSQL database using SSL) |
56
4f66bc893fc3
Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
48
diff
changeset
|
79 * Fix Debian issue #906771 (Uncaught exception prevents db intialization |
4f66bc893fc3
Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
48
diff
changeset
|
80 (likely related to pg_trgm)) |
48 | 81 * Fix: Catching exceptions in destructors |
82 | |
33 | 83 |
42 | 84 Release 2.2 (2018-07-16) |
33 | 85 ======================== |
86 | |
29 | 87 !! Important remark when upgrading from an older version of the plugin: |
88 | |
89 The plugin will create a new index to improve search performance. | |
90 This can take several minutes at the first Orthanc startup. Orthanc | |
91 will not be available during this period. On a PostgreSQL database | |
92 with 100,000 studies, we have observed that updating the index took | |
93 around 10 minutes. | |
19 | 94 |
0 | 95 * Migration into the "orthanc-databases" repository |
96 * Full refactoring to share code with MySQL | |
97 * Fix issue 41 (Additional range IdentifierConstraintType in Orthanc) | |
33 | 98 !! This fix requires Orthanc version >= 1.4.0 |
0 | 99 * Fix issue 47 (Index improvements for PG plugin) |
100 * Fix issue 76 (PG connection shall reconnect/retry in case it loses | |
101 the connection to the server) | |
102 | |
103 | |
104 Release 2.1 (2018-04-20) | |
105 ======================== | |
106 | |
107 * Running transactions in "Serializable" isolation level to avoid | |
108 inconsistencies if multiple Orthanc are writing to the same DB | |
109 * Upgrade to PostgreSQL 9.6.1 client library for static builds | |
110 * Performance warning if runtime debug assertions are turned on | |
111 * Fix issue 62 (use correct type for lo_read() value) | |
112 * Fix issue 63 (allow to connect without specifing username and/or port) | |
113 * Fix issue 68 (PostgreSQL plugin needs extra flags to compile) | |
114 * Resort to Orthanc framework | |
115 * Support of Linux Standard Base, OpenBSD and FreeBSD | |
116 | |
117 | |
118 Release 2.0 (2015-12-02) | |
119 ======================== | |
120 | |
121 => Minimum SDK version: 0.9.5 <= | |
122 => Supported database versions: 5 (upgrade only) and 6 <= | |
123 | |
124 * Support version 6 of the database schema | |
125 * The "value" column of tables "MainDicomTags" and "DicomIdentifiers" are now TEXT instead of BYTEA | |
126 | |
127 | |
128 Release 1.3 (2015-10-07) | |
129 ======================== | |
130 | |
131 => Minimum SDK version: 0.9.4 <= | |
132 => Supported database versions: 5 <= | |
133 | |
134 * Fix build with Orthanc plugin SDK 0.9.4 | |
135 * Implementation of "GetAllPublicIdsWithLimit" extension | |
136 * Implementation of "UpgradeDatabase" extension | |
137 | |
138 | |
139 Release 1.2 (2015-08-02) | |
140 ======================== | |
141 | |
142 => Minimum SDK version: 0.9.1 <= | |
143 | |
144 * Inject version information into Windows binaries | |
145 * CMake flag to prevent compiling the unit tests (if no PostgreSQL test server is available) | |
146 * Update to Boost 1.58.0 for static and Windows builds | |
147 * Support of OS X compilation | |
148 | |
149 | |
150 Release 1.1 (2015-07-03) | |
151 ======================== | |
152 | |
153 * Fixes | |
154 * Support of Visual Studio 2008 | |
155 * Support of FreeBSD thanks Mikhail <mp39590@gmail.com> | |
156 | |
157 | |
158 Release 1.0 (2015-02-27) | |
159 ======================== | |
160 | |
161 * Use of advisory locks | |
162 * Support of connection URI in PostgreSQL | |
163 * Options "EnableIndex" and "EnableStorage" to explicitly enable PostgreSQL | |
164 | |
165 | |
166 2015-02-06 | |
167 ========== | |
168 | |
169 * Initial release |