hello,
we have a XG 310 FW that we have tried to upgrade to 18.0.4 MR-4 and it fails consistently. it was part of an HA cluster and we have since disabled it and pulled it off the network to try and manually upgrade the device
we have done the following with it isolated . rebooted device tried to boot to the v 18 FW that was the secondary firmware on the FW still failed
booted to factory defaults , loaded backup config and attempted to upgrade again - failed again
here is the output from the migration.log
Sophos Firmware Version SFOS 17.5.12 MR-12.HF062020.1
Device Management
1. Reset to Factory Defaults
2. Show Firmware(s)
3. Advanced Shell
4. Flush Device Reports
0. Exit
Select Menu Number [0-4]: 3
[H[J
Sophos Firewall
===============
(C) Copyright 2000-2020 Sophos Limited and others. All rights reserved.
Sophos is a registered trademark of Sophos Limited and Sophos Group.
All other product and company names mentioned are trademarks or registered
trademarks of their respective owners.
For End User License Agreement - www.sophos.com/.../sophos-end-user-license-agreement.aspx
NOTE: If not explicitly approved by Sophos support, any modifications
done through this option will void your support.
XG310_WP02_SFOS 17.5.12 MR-12.HF062020.1# cd /log
XG310_WP02_SFOS 17.5.12 MR-12.HF062020.1# cAT[J[Jat mig XG310_WP02_SFOS 17.5.12 MR-12.HF062020.1# cat migration.log [J
Tue Nov 6 16:06:38 UTC 2018 starting old version corporate db
Starting conf database
238 2018-11-06 16:06:38.324 GMTLOG: could not connect socket for statistics collector: Network is unreachable
238 2018-11-06 16:06:38.324 GMTLOG: disabling statistics collector for lack of working socket
240 2018-11-06 16:06:38.324 GMTLOG: database system was shut down at 2018-11-06 16:06:10 GMT
238 2018-11-06 16:06:38.326 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
238 2018-11-06 16:06:47.317 GMTLOG: received fast shutdown request
238 2018-11-06 16:06:47.318 GMTLOG: aborting any active transactions
241 2018-11-06 16:06:47.318 GMTLOG: shutting down
241 2018-11-06 16:06:47.338 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
285 2018-11-06 16:06:55.887 GMTLOG: could not connect socket for statistics collector: Network is unreachable
285 2018-11-06 16:06:55.887 GMTLOG: disabling statistics collector for lack of working socket
287 2018-11-06 16:06:55.888 GMTLOG: database system was shut down at 2018-09-19 10:28:21 GMT
285 2018-11-06 16:06:55.890 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
296 2018-11-06 16:07:04.495 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
296 2018-11-06 16:07:04.495 GMTHINT: You can drop extension plpgsql instead.
296 2018-11-06 16:07:04.495 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
288 2018-11-06 16:07:04.731 GMTLOG: checkpoints are occurring too frequently (9 seconds apart)
288 2018-11-06 16:07:04.731 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
psql:/sdisk/oldpgconfdump.sql:15528: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:15528: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
160
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
64
(1 row)
288 2018-11-06 16:07:05.759 GMTLOG: checkpoints are occurring too frequently (1 second apart)
288 2018-11-06 16:07:05.759 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
285 2018-11-06 16:07:07.717 GMTLOG: received fast shutdown request
285 2018-11-06 16:07:07.717 GMTLOG: aborting any active transactions
288 2018-11-06 16:07:07.740 GMTLOG: shutting down
288 2018-11-06 16:07:07.772 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Tue Nov 6 11:07:15 EST 2018 starting migration log
Starting conf database
327 2018-11-06 16:07:15.832 GMTLOG: could not connect socket for statistics collector: Network is unreachable
327 2018-11-06 16:07:15.832 GMTLOG: disabling statistics collector for lack of working socket
329 2018-11-06 16:07:15.832 GMTLOG: database system was shut down at 2018-11-06 16:07:07 GMT
327 2018-11-06 16:07:15.834 GMTLOG: database system is ready to accept connections
database started
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.111 and currentversion is 17.208
Database is upgrading to dbv17.112
Check migration for version dbv17.112
Applying migration for version dbv17.112
Database is upgrading to dbv17.113
Check migration for version dbv17.113
Applying migration for version dbv17.113
Database is upgrading to dbv17.114
Check migration for version dbv17.114
Applying migration for version dbv17.114
Database is upgrading to dbv17.200
Check migration for version dbv17.200
Applying migration for version dbv17.200
smtp_allow_block_to_exception_migrate
---------------------------------------
(1 row)
Database is upgrading to dbv17.201
Check migration for version dbv17.201
Applying migration for version dbv17.201
Database is upgrading to dbv17.202
Check migration for version dbv17.202
Applying migration for version dbv17.202
Database is upgrading to dbv17.203
Check migration for version dbv17.203
Applying migration for version dbv17.203
Database is upgrading to dbv17.204
Check migration for version dbv17.204
Applying migration for version dbv17.204
Database is upgrading to dbv17.205
Check migration for version dbv17.205
Applying migration for version dbv17.205
Database is upgrading to dbv17.206
Check migration for version dbv17.206
Applying migration for version dbv17.206
Database is upgrading to dbv17.207
Check migration for version dbv17.207
Applying migration for version dbv17.207
upsert_sac_mapping_category
-----------------------------
(1 row)
upsert_sac_mapping_category
-----------------------------
(1 row)
Database is upgrading to dbv17.208
Check migration for version dbv17.208
Applying migration for version dbv17.208
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
327 2018-11-06 16:07:25.528 GMTLOG: received fast shutdown request
327 2018-11-06 16:07:25.528 GMTLOG: aborting any active transactions
330 2018-11-06 16:07:25.528 GMTLOG: shutting down
330 2018-11-06 16:07:25.574 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
Wed Dec 12 19:36:55 UTC 2018 starting old version corporate db
Starting conf database
243 2018-12-12 19:36:55.340 GMTLOG: could not connect socket for statistics collector: Network is unreachable
243 2018-12-12 19:36:55.340 GMTLOG: disabling statistics collector for lack of working socket
245 2018-12-12 19:36:55.341 GMTLOG: database system was shut down at 2018-12-12 19:37:03 GMT
243 2018-12-12 19:36:55.343 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
243 2018-12-12 19:37:04.364 GMTLOG: received fast shutdown request
243 2018-12-12 19:37:04.364 GMTLOG: aborting any active transactions
246 2018-12-12 19:37:04.364 GMTLOG: shutting down
246 2018-12-12 19:37:04.380 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
290 2018-12-12 19:37:12.924 GMTLOG: could not connect socket for statistics collector: Network is unreachable
290 2018-12-12 19:37:12.924 GMTLOG: disabling statistics collector for lack of working socket
292 2018-12-12 19:37:12.925 GMTLOG: database system was shut down at 2018-11-14 13:01:18 GMT
290 2018-12-12 19:37:12.927 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
301 2018-12-12 19:37:21.596 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
301 2018-12-12 19:37:21.596 GMTHINT: You can drop extension plpgsql instead.
301 2018-12-12 19:37:21.596 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
293 2018-12-12 19:37:22.488 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
293 2018-12-12 19:37:22.488 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
psql:/sdisk/oldpgconfdump.sql:15922: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:15922: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
160
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
80
(1 row)
293 2018-12-12 19:37:23.552 GMTLOG: checkpoints are occurring too frequently (1 second apart)
293 2018-12-12 19:37:23.552 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
290 2018-12-12 19:37:25.604 GMTLOG: received fast shutdown request
290 2018-12-12 19:37:25.604 GMTLOG: aborting any active transactions
293 2018-12-12 19:37:25.648 GMTLOG: shutting down
293 2018-12-12 19:37:25.680 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Wed Dec 12 14:37:33 EST 2018 starting migration log
Starting conf database
331 2018-12-12 19:37:33.717 GMTLOG: could not connect socket for statistics collector: Network is unreachable
331 2018-12-12 19:37:33.717 GMTLOG: disabling statistics collector for lack of working socket
333 2018-12-12 19:37:33.718 GMTLOG: database system was shut down at 2018-12-12 19:37:25 GMT
331 2018-12-12 19:37:33.720 GMTLOG: database system is ready to accept connections
database started
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.208 and currentversion is 17.209
Database is upgrading to dbv17.209
Check migration for version dbv17.209
Applying migration for version dbv17.209
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
331 2018-12-12 19:37:43.000 GMTLOG: received fast shutdown request
331 2018-12-12 19:37:43.000 GMTLOG: aborting any active transactions
334 2018-12-12 19:37:43.000 GMTLOG: shutting down
334 2018-12-12 19:37:43.025 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
Fri Jan 11 14:31:43 UTC 2019 starting old version corporate db
Starting conf database
261 2019-01-11 14:31:43.640 GMTLOG: could not connect socket for statistics collector: Network is unreachable
261 2019-01-11 14:31:43.640 GMTLOG: disabling statistics collector for lack of working socket
263 2019-01-11 14:31:43.640 GMTLOG: database system was shut down at 2019-01-11 14:31:23 GMT
261 2019-01-11 14:31:43.642 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
261 2019-01-11 14:31:52.676 GMTLOG: received fast shutdown request
261 2019-01-11 14:31:52.676 GMTLOG: aborting any active transactions
264 2019-01-11 14:31:52.676 GMTLOG: shutting down
264 2019-01-11 14:31:52.688 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
309 2019-01-11 14:32:01.258 GMTLOG: could not connect socket for statistics collector: Network is unreachable
309 2019-01-11 14:32:01.258 GMTLOG: disabling statistics collector for lack of working socket
311 2019-01-11 14:32:01.258 GMTLOG: database system was shut down at 2018-12-05 14:51:19 GMT
309 2019-01-11 14:32:01.261 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
320 2019-01-11 14:32:09.868 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
320 2019-01-11 14:32:09.868 GMTHINT: You can drop extension plpgsql instead.
320 2019-01-11 14:32:09.868 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
312 2019-01-11 14:32:10.082 GMTLOG: checkpoints are occurring too frequently (9 seconds apart)
312 2019-01-11 14:32:10.082 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
psql:/sdisk/oldpgconfdump.sql:15922: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:15922: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
160
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
80
(1 row)
312 2019-01-11 14:32:11.141 GMTLOG: checkpoints are occurring too frequently (1 second apart)
312 2019-01-11 14:32:11.141 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
309 2019-01-11 14:32:13.155 GMTLOG: received fast shutdown request
309 2019-01-11 14:32:13.155 GMTLOG: aborting any active transactions
312 2019-01-11 14:32:13.181 GMTLOG: shutting down
312 2019-01-11 14:32:13.217 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Fri Jan 11 09:32:21 EST 2019 starting migration log
Starting conf database
350 2019-01-11 14:32:21.285 GMTLOG: could not connect socket for statistics collector: Network is unreachable
350 2019-01-11 14:32:21.285 GMTLOG: disabling statistics collector for lack of working socket
352 2019-01-11 14:32:21.286 GMTLOG: database system was shut down at 2019-01-11 14:32:13 GMT
350 2019-01-11 14:32:21.288 GMTLOG: database system is ready to accept connections
database started
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.209 and currentversion is 17.302
Database is upgrading to dbv17.300
Check migration for version dbv17.300
Applying migration for version dbv17.300
exceptionpolicy_src_host_migrate
----------------------------------
(1 row)
tbleacapplications_add_system_app_column
------------------------------------------
(1 row)
convert_tblesecuritypolicy
----------------------------
(1 row)
remove_duplicate_default_policy_rule
--------------------------------------
(1 row)
remove_duplicate_default_policy_rule
--------------------------------------
(1 row)
Database is upgrading to dbv17.301
Check migration for version dbv17.301
Applying migration for version dbv17.301
Database is upgrading to dbv17.302
Check migration for version dbv17.302
Applying migration for version dbv17.302
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
350 2019-01-11 14:32:30.852 GMTLOG: received fast shutdown request
350 2019-01-11 14:32:30.852 GMTLOG: aborting any active transactions
353 2019-01-11 14:32:30.852 GMTLOG: shutting down
353 2019-01-11 14:32:30.897 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
Wed Feb 13 19:37:49 UTC 2019 starting old version corporate db
Starting conf database
265 2019-02-13 19:37:49.322 GMTLOG: could not connect socket for statistics collector: Network is unreachable
265 2019-02-13 19:37:49.322 GMTLOG: disabling statistics collector for lack of working socket
267 2019-02-13 19:37:49.323 GMTLOG: database system was shut down at 2019-02-13 19:38:34 GMT
265 2019-02-13 19:37:49.325 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
265 2019-02-13 19:37:58.384 GMTLOG: received fast shutdown request
265 2019-02-13 19:37:58.384 GMTLOG: aborting any active transactions
268 2019-02-13 19:37:58.384 GMTLOG: shutting down
268 2019-02-13 19:37:58.401 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
312 2019-02-13 19:38:07.030 GMTLOG: could not connect socket for statistics collector: Network is unreachable
312 2019-02-13 19:38:07.030 GMTLOG: disabling statistics collector for lack of working socket
314 2019-02-13 19:38:07.031 GMTLOG: database system was shut down at 2019-01-10 13:41:19 GMT
312 2019-02-13 19:38:07.033 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
323 2019-02-13 19:38:15.639 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
323 2019-02-13 19:38:15.639 GMTHINT: You can drop extension plpgsql instead.
323 2019-02-13 19:38:15.639 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
315 2019-02-13 19:38:15.878 GMTLOG: checkpoints are occurring too frequently (8 seconds apart)
315 2019-02-13 19:38:15.878 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
psql:/sdisk/oldpgconfdump.sql:16342: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16342: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
160
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
80
(1 row)
315 2019-02-13 19:38:16.916 GMTLOG: checkpoints are occurring too frequently (1 second apart)
315 2019-02-13 19:38:16.916 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
312 2019-02-13 19:38:19.019 GMTLOG: received fast shutdown request
312 2019-02-13 19:38:19.019 GMTLOG: aborting any active transactions
315 2019-02-13 19:38:19.039 GMTLOG: shutting down
315 2019-02-13 19:38:19.079 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Wed Feb 13 14:38:27 EST 2019 starting migration log
Starting conf database
354 2019-02-13 19:38:27.131 GMTLOG: could not connect socket for statistics collector: Network is unreachable
354 2019-02-13 19:38:27.131 GMTLOG: disabling statistics collector for lack of working socket
356 2019-02-13 19:38:27.131 GMTLOG: database system was shut down at 2019-02-13 19:38:19 GMT
354 2019-02-13 19:38:27.133 GMTLOG: database system is ready to accept connections
database started
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.302 and currentversion is 17.303
Database is upgrading to dbv17.303
Check migration for version dbv17.303
Applying migration for version dbv17.303
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
354 2019-02-13 19:38:36.476 GMTLOG: received fast shutdown request
354 2019-02-13 19:38:36.476 GMTLOG: aborting any active transactions
357 2019-02-13 19:38:36.476 GMTLOG: shutting down
357 2019-02-13 19:38:36.502 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
Thu Feb 14 20:08:08 UTC 2019 starting old version corporate db
Starting conf database
273 2019-02-14 20:08:08.723 GMTLOG: could not connect socket for statistics collector: Network is unreachable
273 2019-02-14 20:08:08.723 GMTLOG: disabling statistics collector for lack of working socket
275 2019-02-14 20:08:08.724 GMTLOG: database system was shut down at 2019-02-14 20:07:41 GMT
273 2019-02-14 20:08:08.726 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
273 2019-02-14 20:08:17.785 GMTLOG: received fast shutdown request
273 2019-02-14 20:08:17.785 GMTLOG: aborting any active transactions
276 2019-02-14 20:08:17.785 GMTLOG: shutting down
276 2019-02-14 20:08:17.797 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
320 2019-02-14 20:08:26.453 GMTLOG: could not connect socket for statistics collector: Network is unreachable
320 2019-02-14 20:08:26.453 GMTLOG: disabling statistics collector for lack of working socket
322 2019-02-14 20:08:26.454 GMTLOG: database system was shut down at 2019-02-07 21:22:36 GMT
320 2019-02-14 20:08:26.456 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
331 2019-02-14 20:08:35.067 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
331 2019-02-14 20:08:35.067 GMTHINT: You can drop extension plpgsql instead.
331 2019-02-14 20:08:35.067 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
323 2019-02-14 20:08:35.282 GMTLOG: checkpoints are occurring too frequently (9 seconds apart)
323 2019-02-14 20:08:35.282 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
psql:/sdisk/oldpgconfdump.sql:16343: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16343: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
160
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
80
(1 row)
323 2019-02-14 20:08:36.371 GMTLOG: checkpoints are occurring too frequently (1 second apart)
323 2019-02-14 20:08:36.371 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
320 2019-02-14 20:08:38.421 GMTLOG: received fast shutdown request
320 2019-02-14 20:08:38.421 GMTLOG: aborting any active transactions
323 2019-02-14 20:08:38.452 GMTLOG: shutting down
323 2019-02-14 20:08:38.486 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Thu Feb 14 15:08:46 EST 2019 starting migration log
Starting conf database
361 2019-02-14 20:08:46.531 GMTLOG: could not connect socket for statistics collector: Network is unreachable
361 2019-02-14 20:08:46.531 GMTLOG: disabling statistics collector for lack of working socket
363 2019-02-14 20:08:46.531 GMTLOG: database system was shut down at 2019-02-14 20:08:38 GMT
361 2019-02-14 20:08:46.533 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.303 and currentversion is 17.311
Database is upgrading to dbv17.311
Check migration for version dbv17.311
Applying migration for version dbv17.311
smtp_mta_dos_migration
------------------------
(1 row)
insertmigratedfirewallgroup
-----------------------------
(1 row)
replacegroupname
------------------
t
(1 row)
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
361 2019-02-14 20:08:55.874 GMTLOG: received fast shutdown request
361 2019-02-14 20:08:55.874 GMTLOG: aborting any active transactions
364 2019-02-14 20:08:55.874 GMTLOG: shutting down
364 2019-02-14 20:08:55.924 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
Wed May 1 22:44:00 UTC 2019 starting old version corporate db
Starting conf database
281 2019-05-01 22:44:00.536 GMTLOG: could not connect socket for statistics collector: Network is unreachable
281 2019-05-01 22:44:00.536 GMTLOG: disabling statistics collector for lack of working socket
283 2019-05-01 22:44:00.536 GMTLOG: database system was shut down at 2019-05-01 22:46:17 GMT
281 2019-05-01 22:44:00.538 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
281 2019-05-01 22:44:09.616 GMTLOG: received fast shutdown request
281 2019-05-01 22:44:09.616 GMTLOG: aborting any active transactions
284 2019-05-01 22:44:09.616 GMTLOG: shutting down
284 2019-05-01 22:44:09.629 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
328 2019-05-01 22:44:18.252 GMTLOG: could not connect socket for statistics collector: Network is unreachable
328 2019-05-01 22:44:18.252 GMTLOG: disabling statistics collector for lack of working socket
330 2019-05-01 22:44:18.253 GMTLOG: database system was shut down at 2019-04-09 18:36:59 GMT
328 2019-05-01 22:44:18.255 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
339 2019-05-01 22:44:26.930 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
339 2019-05-01 22:44:26.930 GMTHINT: You can drop extension plpgsql instead.
339 2019-05-01 22:44:26.930 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16367: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16367: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
310
(1 row)
331 2019-05-01 22:44:28.925 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
331 2019-05-01 22:44:28.925 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
328 2019-05-01 22:44:31.084 GMTLOG: received fast shutdown request
328 2019-05-01 22:44:31.084 GMTLOG: aborting any active transactions
331 2019-05-01 22:44:31.171 GMTLOG: shutting down
331 2019-05-01 22:44:31.215 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Wed May 1 18:44:39 EDT 2019 starting migration log
Starting conf database
370 2019-05-01 22:44:39.223 GMTLOG: could not connect socket for statistics collector: Network is unreachable
370 2019-05-01 22:44:39.223 GMTLOG: disabling statistics collector for lack of working socket
372 2019-05-01 22:44:39.224 GMTLOG: database system was shut down at 2019-05-01 22:44:31 GMT
370 2019-05-01 22:44:39.225 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.311 and currentversion is 17.313
Database is upgrading to dbv17.312
Check migration for version dbv17.312
Applying migration for version dbv17.312
Database is upgrading to dbv17.313
Check migration for version dbv17.313
Applying migration for version dbv17.313
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
370 2019-05-01 22:44:49.198 GMTLOG: received fast shutdown request
370 2019-05-01 22:44:49.198 GMTLOG: aborting any active transactions
373 2019-05-01 22:44:49.199 GMTLOG: shutting down
373 2019-05-01 22:44:49.228 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
Thu Jun 27 00:06:45 UTC 2019 starting old version corporate db
Starting conf database
278 2019-06-27 00:06:45.321 GMTLOG: could not connect socket for statistics collector: Network is unreachable
278 2019-06-27 00:06:45.321 GMTLOG: disabling statistics collector for lack of working socket
280 2019-06-27 00:06:45.322 GMTLOG: database system was shut down at 2019-06-27 00:06:14 GMT
278 2019-06-27 00:06:45.323 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
278 2019-06-27 00:06:54.414 GMTLOG: received fast shutdown request
278 2019-06-27 00:06:54.414 GMTLOG: aborting any active transactions
281 2019-06-27 00:06:54.414 GMTLOG: shutting down
281 2019-06-27 00:06:54.425 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
325 2019-06-27 00:07:03.061 GMTLOG: could not connect socket for statistics collector: Network is unreachable
325 2019-06-27 00:07:03.061 GMTLOG: disabling statistics collector for lack of working socket
327 2019-06-27 00:07:03.062 GMTLOG: database system was shut down at 2019-06-06 19:05:30 GMT
325 2019-06-27 00:07:03.064 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
336 2019-06-27 00:07:11.675 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
336 2019-06-27 00:07:11.675 GMTHINT: You can drop extension plpgsql instead.
336 2019-06-27 00:07:11.675 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16441: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16441: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
328
(1 row)
328 2019-06-27 00:07:12.863 GMTLOG: checkpoints are occurring too frequently (9 seconds apart)
328 2019-06-27 00:07:12.863 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
325 2019-06-27 00:07:15.019 GMTLOG: received fast shutdown request
325 2019-06-27 00:07:15.019 GMTLOG: aborting any active transactions
328 2019-06-27 00:07:15.098 GMTLOG: shutting down
328 2019-06-27 00:07:15.141 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Wed Jun 26 20:07:23 EDT 2019 starting migration log
Starting conf database
366 2019-06-27 00:07:23.172 GMTLOG: could not connect socket for statistics collector: Network is unreachable
366 2019-06-27 00:07:23.172 GMTLOG: disabling statistics collector for lack of working socket
368 2019-06-27 00:07:23.172 GMTLOG: database system was shut down at 2019-06-27 00:07:15 GMT
366 2019-06-27 00:07:23.174 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.313 and currentversion is 17.314
Database is upgrading to dbv17.314
Check migration for version dbv17.314
Applying migration for version dbv17.314
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
366 2019-06-27 00:07:32.477 GMTLOG: received fast shutdown request
366 2019-06-27 00:07:32.477 GMTLOG: aborting any active transactions
369 2019-06-27 00:07:32.478 GMTLOG: shutting down
369 2019-06-27 00:07:32.503 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
Thu Jul 18 22:39:40 UTC 2019 starting old version corporate db
Starting conf database
286 2019-07-18 22:39:40.705 GMTLOG: could not connect socket for statistics collector: Network is unreachable
286 2019-07-18 22:39:40.705 GMTLOG: disabling statistics collector for lack of working socket
288 2019-07-18 22:39:40.705 GMTLOG: database system was shut down at 2019-07-18 22:39:58 GMT
286 2019-07-18 22:39:40.707 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
286 2019-07-18 22:39:49.984 GMTLOG: received fast shutdown request
286 2019-07-18 22:39:49.984 GMTLOG: aborting any active transactions
289 2019-07-18 22:39:49.985 GMTLOG: shutting down
289 2019-07-18 22:39:50.002 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
334 2019-07-18 22:39:58.660 GMTLOG: could not connect socket for statistics collector: Network is unreachable
334 2019-07-18 22:39:58.660 GMTLOG: disabling statistics collector for lack of working socket
336 2019-07-18 22:39:58.660 GMTLOG: database system was shut down at 2019-07-04 21:13:50 GMT
334 2019-07-18 22:39:58.663 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
345 2019-07-18 22:40:07.267 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
345 2019-07-18 22:40:07.267 GMTHINT: You can drop extension plpgsql instead.
345 2019-07-18 22:40:07.267 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16441: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16441: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
328
(1 row)
337 2019-07-18 22:40:08.460 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
337 2019-07-18 22:40:08.460 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
334 2019-07-18 22:40:10.629 GMTLOG: received fast shutdown request
334 2019-07-18 22:40:10.629 GMTLOG: aborting any active transactions
337 2019-07-18 22:40:10.710 GMTLOG: shutting down
337 2019-07-18 22:40:10.757 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Thu Jul 18 18:40:18 EDT 2019 starting migration log
Starting conf database
375 2019-07-18 22:40:18.745 GMTLOG: could not connect socket for statistics collector: Network is unreachable
375 2019-07-18 22:40:18.745 GMTLOG: disabling statistics collector for lack of working socket
377 2019-07-18 22:40:18.746 GMTLOG: database system was shut down at 2019-07-18 22:40:10 GMT
375 2019-07-18 22:40:18.748 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.314 and currentversion is 17.315
Database is upgrading to dbv17.315
Check migration for version dbv17.315
Applying migration for version dbv17.315
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
375 2019-07-18 22:40:28.068 GMTLOG: received fast shutdown request
375 2019-07-18 22:40:28.068 GMTLOG: aborting any active transactions
378 2019-07-18 22:40:28.068 GMTLOG: shutting down
378 2019-07-18 22:40:28.094 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
Mon Oct 7 21:49:25 UTC 2019 starting old version corporate db
Starting conf database
282 2019-10-07 21:49:26.035 GMTLOG: could not connect socket for statistics collector: Network is unreachable
282 2019-10-07 21:49:26.035 GMTLOG: disabling statistics collector for lack of working socket
284 2019-10-07 21:49:26.035 GMTLOG: database system was shut down at 2019-10-07 21:51:52 GMT
282 2019-10-07 21:49:26.037 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
282 2019-10-07 21:49:35.097 GMTLOG: received fast shutdown request
282 2019-10-07 21:49:35.097 GMTLOG: aborting any active transactions
285 2019-10-07 21:49:35.098 GMTLOG: shutting down
285 2019-10-07 21:49:35.111 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
329 2019-10-07 21:49:43.745 GMTLOG: could not connect socket for statistics collector: Network is unreachable
329 2019-10-07 21:49:43.745 GMTLOG: disabling statistics collector for lack of working socket
331 2019-10-07 21:49:43.745 GMTLOG: database system was shut down at 2019-08-07 19:49:28 GMT
329 2019-10-07 21:49:43.748 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
340 2019-10-07 21:49:52.359 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
340 2019-10-07 21:49:52.359 GMTHINT: You can drop extension plpgsql instead.
340 2019-10-07 21:49:52.359 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16444: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16444: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
413
(1 row)
332 2019-10-07 21:49:53.533 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
332 2019-10-07 21:49:53.533 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
329 2019-10-07 21:49:55.661 GMTLOG: received fast shutdown request
329 2019-10-07 21:49:55.661 GMTLOG: aborting any active transactions
332 2019-10-07 21:49:55.762 GMTLOG: shutting down
332 2019-10-07 21:49:55.810 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Mon Oct 7 17:50:03 EDT 2019 starting migration log
Starting conf database
371 2019-10-07 21:50:03.779 GMTLOG: could not connect socket for statistics collector: Network is unreachable
371 2019-10-07 21:50:03.779 GMTLOG: disabling statistics collector for lack of working socket
373 2019-10-07 21:50:03.779 GMTLOG: database system was shut down at 2019-10-07 21:49:55 GMT
371 2019-10-07 21:50:03.781 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.315 and currentversion is 17.316
Database is upgrading to dbv17.316
Check migration for version dbv17.316
Applying migration for version dbv17.316
email_migrate_587_for_proxy
-----------------------------
(1 row)
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
371 2019-10-07 21:50:13.112 GMTLOG: received fast shutdown request
371 2019-10-07 21:50:13.112 GMTLOG: aborting any active transactions
374 2019-10-07 21:50:13.112 GMTLOG: shutting down
374 2019-10-07 21:50:13.158 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
Sun Nov 24 13:45:01 UTC 2019 starting old version corporate db
Starting conf database
287 2019-11-24 13:45:01.852 GMTLOG: could not connect socket for statistics collector: Network is unreachable
287 2019-11-24 13:45:01.852 GMTLOG: disabling statistics collector for lack of working socket
289 2019-11-24 13:45:01.853 GMTLOG: database system was shut down at 2019-11-24 13:46:10 GMT
287 2019-11-24 13:45:01.874 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
287 2019-11-24 13:45:10.944 GMTLOG: received fast shutdown request
287 2019-11-24 13:45:10.944 GMTLOG: aborting any active transactions
290 2019-11-24 13:45:10.944 GMTLOG: shutting down
290 2019-11-24 13:45:10.961 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
334 2019-11-24 13:45:19.538 GMTLOG: could not connect socket for statistics collector: Network is unreachable
334 2019-11-24 13:45:19.538 GMTLOG: disabling statistics collector for lack of working socket
336 2019-11-24 13:45:19.538 GMTLOG: database system was shut down at 2019-11-01 15:36:31 GMT
334 2019-11-24 13:45:19.541 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
345 2019-11-24 13:45:28.176 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
345 2019-11-24 13:45:28.176 GMTHINT: You can drop extension plpgsql instead.
345 2019-11-24 13:45:28.176 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16445: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16445: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
413
(1 row)
337 2019-11-24 13:45:29.342 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
337 2019-11-24 13:45:29.342 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
334 2019-11-24 13:45:31.505 GMTLOG: received fast shutdown request
334 2019-11-24 13:45:31.505 GMTLOG: aborting any active transactions
337 2019-11-24 13:45:31.585 GMTLOG: shutting down
337 2019-11-24 13:45:31.651 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Sun Nov 24 08:45:39 EST 2019 starting migration log
Starting conf database
375 2019-11-24 13:45:39.623 GMTLOG: could not connect socket for statistics collector: Network is unreachable
375 2019-11-24 13:45:39.623 GMTLOG: disabling statistics collector for lack of working socket
377 2019-11-24 13:45:39.623 GMTLOG: database system was shut down at 2019-11-24 13:45:31 GMT
375 2019-11-24 13:45:39.625 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.316 and currentversion is 17.317
Database is upgrading to dbv17.317
Check migration for version dbv17.317
Applying migration for version dbv17.317
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
375 2019-11-24 13:45:48.958 GMTLOG: received fast shutdown request
375 2019-11-24 13:45:48.958 GMTLOG: aborting any active transactions
378 2019-11-24 13:45:48.959 GMTLOG: shutting down
378 2019-11-24 13:45:48.983 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
Thu Mar 12 22:38:18 UTC 2020 starting old version corporate db
Starting conf database
283 2020-03-12 22:38:18.949 GMTLOG: could not connect socket for statistics collector: Network is unreachable
283 2020-03-12 22:38:18.949 GMTLOG: disabling statistics collector for lack of working socket
285 2020-03-12 22:38:18.950 GMTLOG: database system was shut down at 2020-03-12 22:35:36 GMT
283 2020-03-12 22:38:18.952 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
283 2020-03-12 22:38:28.048 GMTLOG: received fast shutdown request
283 2020-03-12 22:38:28.048 GMTLOG: aborting any active transactions
286 2020-03-12 22:38:28.048 GMTLOG: shutting down
286 2020-03-12 22:38:28.063 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
330 2020-03-12 22:38:36.664 GMTLOG: could not connect socket for statistics collector: Network is unreachable
330 2020-03-12 22:38:36.664 GMTLOG: disabling statistics collector for lack of working socket
332 2020-03-12 22:38:36.664 GMTLOG: database system was shut down at 2020-02-12 12:49:04 GMT
330 2020-03-12 22:38:36.667 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
341 2020-03-12 22:38:45.281 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
341 2020-03-12 22:38:45.281 GMTHINT: You can drop extension plpgsql instead.
341 2020-03-12 22:38:45.281 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16457: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16457: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
437
(1 row)
333 2020-03-12 22:38:46.475 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
333 2020-03-12 22:38:46.475 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
330 2020-03-12 22:38:48.737 GMTLOG: received fast shutdown request
330 2020-03-12 22:38:48.737 GMTLOG: aborting any active transactions
333 2020-03-12 22:38:48.840 GMTLOG: shutting down
333 2020-03-12 22:38:48.896 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Thu Mar 12 18:38:56 EDT 2020 starting migration log
Starting conf database
371 2020-03-12 22:38:56.862 GMTLOG: could not connect socket for statistics collector: Network is unreachable
371 2020-03-12 22:38:56.862 GMTLOG: disabling statistics collector for lack of working socket
373 2020-03-12 22:38:56.863 GMTLOG: database system was shut down at 2020-03-12 22:38:48 GMT
371 2020-03-12 22:38:56.864 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.317 and currentversion is 17.318
Database is upgrading to dbv17.318
Check migration for version dbv17.318
Applying migration for version dbv17.318
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
371 2020-03-12 22:39:06.208 GMTLOG: received fast shutdown request
371 2020-03-12 22:39:06.208 GMTLOG: aborting any active transactions
374 2020-03-12 22:39:06.209 GMTLOG: shutting down
374 2020-03-12 22:39:06.234 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
Thu Apr 16 21:48:45 UTC 2020 starting old version corporate db
Starting conf database
286 2020-04-16 21:48:45.845 GMTLOG: could not connect socket for statistics collector: Network is unreachable
286 2020-04-16 21:48:45.845 GMTLOG: disabling statistics collector for lack of working socket
288 2020-04-16 21:48:45.846 GMTLOG: database system was shut down at 2020-04-16 21:48:18 GMT
286 2020-04-16 21:48:45.848 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
286 2020-04-16 21:48:55.804 GMTLOG: received fast shutdown request
286 2020-04-16 21:48:55.804 GMTLOG: aborting any active transactions
289 2020-04-16 21:48:55.804 GMTLOG: shutting down
289 2020-04-16 21:48:56.122 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
333 2020-04-16 21:49:04.437 GMTLOG: could not connect socket for statistics collector: Network is unreachable
333 2020-04-16 21:49:04.437 GMTLOG: disabling statistics collector for lack of working socket
335 2020-04-16 21:49:04.438 GMTLOG: database system was shut down at 2020-03-23 08:54:16 GMT
333 2020-04-16 21:49:04.440 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
344 2020-04-16 21:49:13.055 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
344 2020-04-16 21:49:13.055 GMTHINT: You can drop extension plpgsql instead.
344 2020-04-16 21:49:13.055 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16467: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16467: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
458
(1 row)
336 2020-04-16 21:49:14.210 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
336 2020-04-16 21:49:14.210 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
333 2020-04-16 21:49:16.437 GMTLOG: received fast shutdown request
333 2020-04-16 21:49:16.437 GMTLOG: aborting any active transactions
336 2020-04-16 21:49:16.538 GMTLOG: shutting down
336 2020-04-16 21:49:16.593 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Thu Apr 16 17:49:24 EDT 2020 starting migration log
Starting conf database
375 2020-04-16 21:49:24.568 GMTLOG: could not connect socket for statistics collector: Network is unreachable
375 2020-04-16 21:49:24.568 GMTLOG: disabling statistics collector for lack of working socket
377 2020-04-16 21:49:24.569 GMTLOG: database system was shut down at 2020-04-16 21:49:16 GMT
375 2020-04-16 21:49:24.571 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.318 and currentversion is 17.319
Database is upgrading to dbv17.319
Check migration for version dbv17.319
Applying migration for version dbv17.319
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
375 2020-04-16 21:49:34.303 GMTLOG: received fast shutdown request
375 2020-04-16 21:49:34.303 GMTLOG: aborting any active transactions
378 2020-04-16 21:49:34.303 GMTLOG: shutting down
378 2020-04-16 21:49:34.328 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem
WARNING: Skipping expired Certificate Staat_der_Nederlanden_Root_CA_G2.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
Mon Jul 6 21:32:58 UTC 2020 starting old version corporate db
Starting conf database
282 2020-07-06 21:32:58.636 GMTLOG: could not connect socket for statistics collector: Network is unreachable
282 2020-07-06 21:32:58.636 GMTLOG: disabling statistics collector for lack of working socket
284 2020-07-06 21:32:58.637 GMTLOG: database system was shut down at 2020-07-06 21:32:29 GMT
282 2020-07-06 21:32:58.639 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA
DELETE 0
DELETE 0
DELETE 0
DELETE 0
UPDATE 3
Stopping database
282 2020-07-06 21:33:07.749 GMTLOG: received fast shutdown request
282 2020-07-06 21:33:07.749 GMTLOG: aborting any active transactions
285 2020-07-06 21:33:07.749 GMTLOG: shutting down
285 2020-07-06 21:33:07.766 GMTLOG: database system is shut down
/sdisk/oldpgconfdump.sql is created
Starting conf database
330 2020-07-06 21:33:16.351 GMTLOG: could not connect socket for statistics collector: Network is unreachable
330 2020-07-06 21:33:16.351 GMTLOG: disabling statistics collector for lack of working socket
332 2020-07-06 21:33:16.352 GMTLOG: database system was shut down at 2020-04-28 17:46:37 GMT
330 2020-07-06 21:33:16.354 GMTLOG: database system is ready to accept connections
database started
DROP SCHEMA config CASCADE
DROP SCHEMA
DROP SCHEMA public CASCADE
DROP SCHEMA
DROP PROCEDURAL LANGUAGE plpgsql
341 2020-07-06 21:33:24.988 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it
341 2020-07-06 21:33:24.988 GMTHINT: You can drop extension plpgsql instead.
341 2020-07-06 21:33:24.988 GMTSTATEMENT: DROP PROCEDURAL LANGUAGE plpgsql
ERROR: cannot drop language plpgsql because extension plpgsql requires it
HINT: You can drop extension plpgsql instead.
CREATE SCHEMA public
CREATE SCHEMA
psql:/sdisk/oldpgconfdump.sql:16757: WARNING: column "senderemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
psql:/sdisk/oldpgconfdump.sql:16757: WARNING: column "receipientemail" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
setval
--------
168
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
458
(1 row)
333 2020-07-06 21:33:26.292 GMTLOG: checkpoints are occurring too frequently (10 seconds apart)
333 2020-07-06 21:33:26.292 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".
Stopping database
330 2020-07-06 21:33:29.251 GMTLOG: received fast shutdown request
330 2020-07-06 21:33:29.252 GMTLOG: aborting any active transactions
333 2020-07-06 21:33:29.342 GMTLOG: shutting down
333 2020-07-06 21:33:29.387 GMTLOG: database system is shut down
old conf to new conf migrated with return value :: 0
Mon Jul 6 17:33:37 EDT 2020 starting migration log
Starting conf database
371 2020-07-06 21:33:37.380 GMTLOG: could not connect socket for statistics collector: Network is unreachable
371 2020-07-06 21:33:37.380 GMTLOG: disabling statistics collector for lack of working socket
373 2020-07-06 21:33:37.380 GMTLOG: database system was shut down at 2020-07-06 21:33:29 GMT
371 2020-07-06 21:33:37.382 GMTLOG: database system is ready to accept connections
database started
INSERT 0 0
UPDATE 1
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 1
UPDATE 1
Old version is 17.319 and currentversion is 17.319
create_pguser
---------------
(1 row)
UPDATE 1
Stopping database
371 2020-07-06 21:33:46.610 GMTLOG: received fast shutdown request
371 2020-07-06 21:33:46.610 GMTLOG: aborting any active transactions
374 2020-07-06 21:33:46.611 GMTLOG: shutting down
374 2020-07-06 21:33:46.653 GMTLOG: database system is shut down
applymigration.sh exited with 0
Doing /conf/certificate/cacerts/
WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem
WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
WARNING: Skipping expired Certificate AddTrust_Public_Services_Root.pem
WARNING: Skipping expired Certificate Equifax_Secure_eBusiness_CA_1.pem
WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
WARNING: Skipping expired Certificate Sophos_Firewall_Content_Licensing_CA.pem
WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
WARNING: Skipping expired Certificate AddTrust_Qualified_Certificates_Root.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate AddTrust_Low_Value_Services_Root.pem
WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
WARNING: Skipping expired Certificate Staat_der_Nederlanden_Root_CA_G2.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem
WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_Secure_Server_CA_-_G3.pem
WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
WARNING: Skipping expired Certificate AddTrust_External_Root.pem
WARNING: Skipping expired Certificate Equifax_Secure_Global_eBusiness_CA.pem
WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem
WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem
WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem
XG310_WP02_SFOS 17.5.12 MR-12.HF062020.1#
Any help would be greatly appreciated.
thank you
This thread was automatically locked due to age.
