Changes between Version 6 and Version 7 of proposals/readonly

Timestamp:

01/25/13 09:12:01 (12 years ago)

Author:

fxp

Comment:

--

proposals/readonly

@@ -55 +55 @@
 
 
+=== Testing ===
+
+In config.xml, set the maxIdle connection parameter to 0 to force the pool to request new connection:
+{{{
+   <minIdle>0</minIdle>
+   <maxIdle>0</maxIdle>
+}}}
+
+Change the DB read/write mode using:
+{{{
+-- For postgres
+ALTER DATABASE eea_catalogue SET default_transaction_read_only = true;
+}}}
+
+The DBHeartBeat status will change in the log:
+{{{
+
+2013-01-25 18:10:21,122 WARN  [jeeves.apphand] - DBHeartBeat SQLException: ERROR: cannot execute INSERT in a read-only transaction
+2013-01-25 18:10:21,123 INFO  [jeeves.apphand] - GeoNetwork remains in read-only mode
+2013-01-25 18:10:41,123 INFO  [jeeves.apphand] - DBHeartBeat: GN is read-only ? true
+2013-01-25 18:10:41,141 WARN  [jeeves.apphand] - GeoNetwork can write to the database, switching to read-write mode
+
+}}}
+
+
 === Backwards Compatibility Issues ===