We are attempting to upgrade the firmware on the Sophos XG and it is failing and rebooting to 17. We have attempted a few times with the same results, and will next attempt by downloading and uploading the firmware. Not sure if anyone else is having these issues but its blocking us from using some of the new natting features that come with the upgrade to 18.
Attempted resolution steps:
1. upgrade to SFOS 18.0.4 MR-4 = failed and needed a power off to restart into 17
2. upgrade to latest 17 patchset then upgrade again to 18 = failed but did not need a power off
3. final attempt to upgrade to 18 = failed again
4. viewed the logs on the sophos and saw that there were "migration" errors
We are wondering if there are settings in the 17 version which are not compatible with the new 18 upgrade. If this is the case what is the solution?
Any help/suggestions would be appreciated.
Error logs:
XG310_WP02_SFOS 17.5.15 MR-15# cat /log/migration.log Tue Nov 19 21:59:28 UTC 2019 starting old version corporate db Starting conf database 283 2019-11-19 21:59:28.615 GMTLOG: could not connect socket for statistics collector: Network is unreachable 283 2019-11-19 21:59:28.615 GMTLOG: disabling statistics collector for lack of working socket 285 2019-11-19 21:59:28.616 GMTLOG: database system was shut down at 2019-11-19 21:59:00 GMT 283 2019-11-19 21:59:28.617 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 2019-11-19 21:59:37.699 GMTLOG: received fast shutdown request 283 2019-11-19 21:59:37.699 GMTLOG: aborting any active transactions 286 2019-11-19 21:59:37.699 GMTLOG: shutting down 286 2019-11-19 21:59:37.708 GMTLOG: database system is shut down /sdisk/oldpgconfdump.sql is created Starting conf database 330 2019-11-19 21:59:46.372 GMTLOG: could not connect socket for statistics collector: Network is unreachable 330 2019-11-19 21:59:46.372 GMTLOG: disabling statistics collector for lack of working socket 332 2019-11-19 21:59:46.372 GMTLOG: database system was shut down at 2019-11-01 15:36:31 GMT 330 2019-11-19 21:59:46.375 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 2019-11-19 21:59:54.986 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it 341 2019-11-19 21:59:54.986 GMTHINT: You can drop extension plpgsql instead. 341 2019-11-19 21:59:54.986 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:16500: WARNING: column "senderemail" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/sdisk/oldpgconfdump.sql:16500: 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 -------- 88 (1 row) 333 2019-11-19 21:59:56.174 GMTLOG: checkpoints are occurring too frequently (10 seconds apart) 333 2019-11-19 21:59:56.174 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments". Stopping database 330 2019-11-19 21:59:58.265 GMTLOG: received fast shutdown request 330 2019-11-19 21:59:58.265 GMTLOG: aborting any active transactions 333 2019-11-19 21:59:58.366 GMTLOG: shutting down 333 2019-11-19 21:59:58.409 GMTLOG: database system is shut down old conf to new conf migrated with return value :: 0 Wed Nov 20 08:30:06 ACDT 2019 starting migration log Starting conf database 371 2019-11-19 22:00:06.382 GMTLOG: could not connect socket for statistics collector: Network is unreachable 371 2019-11-19 22:00:06.382 GMTLOG: disabling statistics collector for lack of working socket 373 2019-11-19 22:00:06.383 GMTLOG: database system was shut down at 2019-11-19 21:59:58 GMT 371 2019-11-19 22:00:06.385 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 371 2019-11-19 22:00:15.728 GMTLOG: received fast shutdown request 371 2019-11-19 22:00:15.728 GMTLOG: aborting any active transactions 374 2019-11-19 22:00:15.728 GMTLOG: shutting down 374 2019-11-19 22:00:15.753 GMTLOG: database system is shut down applymigration.sh exited with 0 Doing /conf/certificate/cacerts/ WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.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 UTN_USERFirst_Hardware_Root_CA.pem WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem WARNING: Skipping expired Certificate Equifax_Secure_CA.pem WARNING: Skipping expired Certificate NetLock_Express_Class_C_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_1.pem WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem Tue Mar 24 07:10:29 UTC 2020 starting old version corporate db Starting conf database 287 2020-03-24 07:10:29.574 GMTLOG: could not connect socket for statistics collector: Network is unreachable 287 2020-03-24 07:10:29.574 GMTLOG: disabling statistics collector for lack of working socket 289 2020-03-24 07:10:29.575 GMTLOG: database system was shut down at 2020-03-24 07:10:01 GMT 287 2020-03-24 07:10:29.577 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 2020-03-24 07:10:38.647 GMTLOG: received fast shutdown request 287 2020-03-24 07:10:38.647 GMTLOG: aborting any active transactions 290 2020-03-24 07:10:38.648 GMTLOG: shutting down 290 2020-03-24 07:10:38.659 GMTLOG: database system is shut down /sdisk/oldpgconfdump.sql is created Starting conf database 334 2020-03-24 07:10:47.289 GMTLOG: could not connect socket for statistics collector: Network is unreachable 334 2020-03-24 07:10:47.289 GMTLOG: disabling statistics collector for lack of working socket 336 2020-03-24 07:10:47.289 GMTLOG: database system was shut down at 2020-02-12 12:49:04 GMT 334 2020-03-24 07:10:47.292 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 2020-03-24 07:10:57.437 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it 345 2020-03-24 07:10:57.437 GMTHINT: You can drop extension plpgsql instead. 345 2020-03-24 07:10:57.437 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:16512: WARNING: column "senderemail" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/sdisk/oldpgconfdump.sql:16512: 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 -------- 88 (1 row) 337 2020-03-24 07:10:58.636 GMTLOG: checkpoints are occurring too frequently (11 seconds apart) 337 2020-03-24 07:10:58.636 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments". Stopping database 334 2020-03-24 07:11:00.737 GMTLOG: received fast shutdown request 334 2020-03-24 07:11:00.737 GMTLOG: aborting any active transactions 337 2020-03-24 07:11:00.816 GMTLOG: shutting down 337 2020-03-24 07:11:00.858 GMTLOG: database system is shut down old conf to new conf migrated with return value :: 0 Tue Mar 24 17:41:08 ACDT 2020 starting migration log Starting conf database 375 2020-03-24 07:11:08.845 GMTLOG: could not connect socket for statistics collector: Network is unreachable 375 2020-03-24 07:11:08.845 GMTLOG: disabling statistics collector for lack of working socket 377 2020-03-24 07:11:08.845 GMTLOG: database system was shut down at 2020-03-24 07:11:00 GMT 375 2020-03-24 07:11:08.847 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 375 2020-03-24 07:11:18.192 GMTLOG: received fast shutdown request 375 2020-03-24 07:11:18.192 GMTLOG: aborting any active transactions 378 2020-03-24 07:11:18.192 GMTLOG: shutting down 378 2020-03-24 07:11:18.238 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 NetLock_Business_Class_B_Root.pem WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem WARNING: Skipping expired Certificate Equifax_Secure_CA.pem WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.pem WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_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 Certplus_Class_2_Primary_CA.pem WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem WARNING: Skipping expired Certificate STATIC_GeoTrust_Inc_RapidSSL_CA.pem WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem Fri Jun 19 08:04:59 UTC 2020 starting old version corporate db Starting conf database 283 2020-06-19 08:04:59.965 GMTLOG: could not connect socket for statistics collector: Network is unreachable 283 2020-06-19 08:04:59.965 GMTLOG: disabling statistics collector for lack of working socket 285 2020-06-19 08:04:59.965 GMTLOG: database system was shut down at 2020-06-19 08:04:31 GMT 283 2020-06-19 08:04:59.986 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-06-19 08:05:08.966 GMTLOG: received fast shutdown request 283 2020-06-19 08:05:08.966 GMTLOG: aborting any active transactions 286 2020-06-19 08:05:08.966 GMTLOG: shutting down 286 2020-06-19 08:05:08.977 GMTLOG: database system is shut down /sdisk/oldpgconfdump.sql is created Starting conf database 330 2020-06-19 08:05:17.603 GMTLOG: could not connect socket for statistics collector: Network is unreachable 330 2020-06-19 08:05:17.603 GMTLOG: disabling statistics collector for lack of working socket 332 2020-06-19 08:05:17.604 GMTLOG: database system was shut down at 2020-04-28 17:46:37 GMT 330 2020-06-19 08:05:17.606 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-06-19 08:05:26.218 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it 341 2020-06-19 08:05:26.218 GMTHINT: You can drop extension plpgsql instead. 341 2020-06-19 08:05:26.218 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:16763: WARNING: column "senderemail" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/sdisk/oldpgconfdump.sql:16763: 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 -------- 88 (1 row) 333 2020-06-19 08:05:27.399 GMTLOG: checkpoints are occurring too frequently (10 seconds apart) 333 2020-06-19 08:05:27.399 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments". Stopping database 330 2020-06-19 08:05:29.552 GMTLOG: received fast shutdown request 330 2020-06-19 08:05:29.552 GMTLOG: aborting any active transactions 333 2020-06-19 08:05:29.629 GMTLOG: shutting down 333 2020-06-19 08:05:29.673 GMTLOG: database system is shut down old conf to new conf migrated with return value :: 0 Fri Jun 19 17:35:37 ACST 2020 starting migration log Starting conf database 371 2020-06-19 08:05:37.670 GMTLOG: could not connect socket for statistics collector: Network is unreachable 371 2020-06-19 08:05:37.670 GMTLOG: disabling statistics collector for lack of working socket 373 2020-06-19 08:05:37.671 GMTLOG: database system was shut down at 2020-06-19 08:05:29 GMT 371 2020-06-19 08:05:37.673 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 371 2020-06-19 08:05:47.334 GMTLOG: received fast shutdown request 371 2020-06-19 08:05:47.334 GMTLOG: aborting any active transactions 374 2020-06-19 08:05:47.334 GMTLOG: shutting down 374 2020-06-19 08:05:47.944 GMTLOG: database system is shut down applymigration.sh exited with 0 Doing /conf/certificate/cacerts/ WARNING: Skipping expired Certificate AddTrust_Public_Services_Root.pem WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem 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 Certplus_Class_2_Primary_CA.pem WARNING: Skipping expired Certificate Staat_der_Nederlanden_Root_CA_G2.pem WARNING: Skipping expired Certificate AddTrust_Qualified_Certificates_Root.pem WARNING: Skipping expired Certificate Equifax_Secure_CA.pem WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_1.pem WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_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 NetLock_Notary_Class_A_Root.pem WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem WARNING: Skipping expired Certificate AddTrust_Low_Value_Services_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 AddTrust_External_Root.pem WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem WARNING: Skipping expired Certificate Sophos_Firewall_Content_Licensing_CA.pem WARNING: Skipping expired Certificate STATIC_Microsoft_Internet_Authority.pem WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem WARNING: Skipping expired Certificate STATIC_GeoTrust_Inc_RapidSSL_CA.pem Thu Jul 30 08:03:02 UTC 2020 starting old version corporate db Starting conf database 289 2020-07-30 08:03:02.505 GMTLOG: could not connect socket for statistics collector: Network is unreachable 289 2020-07-30 08:03:02.505 GMTLOG: disabling statistics collector for lack of working socket 291 2020-07-30 08:03:02.505 GMTLOG: database system was shut down at 2020-07-30 08:02:34 GMT 289 2020-07-30 08:03:02.507 GMTLOG: database system is ready to accept connections database started DROP SCHEMA DELETE 0 DELETE 0 DELETE 0 DELETE 0 UPDATE 3 Stopping database 289 2020-07-30 08:03:11.543 GMTLOG: received fast shutdown request 289 2020-07-30 08:03:11.543 GMTLOG: aborting any active transactions 292 2020-07-30 08:03:11.544 GMTLOG: shutting down 292 2020-07-30 08:03:11.555 GMTLOG: database system is shut down /sdisk/oldpgconfdump.sql is created Starting conf database 336 2020-07-30 08:03:20.166 GMTLOG: could not connect socket for statistics collector: Network is unreachable 336 2020-07-30 08:03:20.166 GMTLOG: disabling statistics collector for lack of working socket 338 2020-07-30 08:03:20.167 GMTLOG: database system was shut down at 2020-06-30 00:25:20 GMT 336 2020-07-30 08:03:20.170 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 347 2020-07-30 08:03:28.802 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it 347 2020-07-30 08:03:28.802 GMTHINT: You can drop extension plpgsql instead. 347 2020-07-30 08:03:28.802 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:16812: WARNING: column "senderemail" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/sdisk/oldpgconfdump.sql:16812: 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 -------- 88 (1 row) 339 2020-07-30 08:03:29.999 GMTLOG: checkpoints are occurring too frequently (9 seconds apart) 339 2020-07-30 08:03:29.999 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments". Stopping database 336 2020-07-30 08:03:32.085 GMTLOG: received fast shutdown request 336 2020-07-30 08:03:32.085 GMTLOG: aborting any active transactions 339 2020-07-30 08:03:32.167 GMTLOG: shutting down 339 2020-07-30 08:03:32.209 GMTLOG: database system is shut down old conf to new conf migrated with return value :: 0 Thu Jul 30 17:33:40 ACST 2020 starting migration log Starting conf database 377 2020-07-30 08:03:40.209 GMTLOG: could not connect socket for statistics collector: Network is unreachable 377 2020-07-30 08:03:40.209 GMTLOG: disabling statistics collector for lack of working socket 379 2020-07-30 08:03:40.209 GMTLOG: database system was shut down at 2020-07-30 08:03:32 GMT 377 2020-07-30 08:03:40.211 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.320 Database is upgrading to dbv17.320 Check migration for version dbv17.320 Applying migration for version dbv17.320 disable_sfm_invalid_ip_port ----------------------------- (1 row) create_pguser --------------- (1 row) UPDATE 1 Stopping database 377 2020-07-30 08:03:49.565 GMTLOG: received fast shutdown request 377 2020-07-30 08:03:49.565 GMTLOG: aborting any active transactions 380 2020-07-30 08:03:49.565 GMTLOG: shutting down 380 2020-07-30 08:03:49.590 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 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 Certplus_Class_2_Primary_CA.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 RSA_Root_Certificate_1.pem WARNING: Skipping expired Certificate Equifax_Secure_eBusiness_CA_1.pem WARNING: Skipping expired Certificate UTN_USERFirst_Object_Root_CA.pem WARNING: Skipping expired Certificate Equifax_Secure_Global_eBusiness_CA.pem WARNING: Skipping expired Certificate Equifax_Secure_CA.pem WARNING: Skipping expired Certificate Sophos_Firewall_Content_Licensing_CA.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 AddTrust_Public_Services_Root.pem WARNING: Skipping expired Certificate Staat_der_Nederlanden_Root_CA_G2.pem WARNING: Skipping expired Certificate STATIC_Microsoft_Internet_Authority.pem WARNING: Skipping expired Certificate AddTrust_Qualified_Certificates_Root.pem WARNING: Skipping expired Certificate NetLock_Express_Class_C_Root.pem WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.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 GeoTrust_Global_CA_2.pem WARNING: Skipping expired Certificate AddTrust_External_Root.pem WARNING: Skipping expired Certificate AddTrust_Low_Value_Services_Root.pem WARNING: Skipping expired Certificate STATIC_GeoTrust_Inc_RapidSSL_CA.pem WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_Secure_Server_CA_-_G3.pem WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem WARNING: Skipping expired Certificate Class1PublicPrimaryCertificationAuthority_2.pem WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem Tue Jan 12 06:36:49 UTC 2021 starting old version corporate db Starting conf database 297 2021-01-12 06:36:49.691 GMTLOG: could not connect socket for statistics collector: Network is unreachable 297 2021-01-12 06:36:49.691 GMTLOG: disabling statistics collector for lack of working socket 299 2021-01-12 06:36:49.691 GMTLOG: database system was shut down at 2021-01-12 06:36:21 GMT 297 2021-01-12 06:36:49.693 GMTLOG: database system is ready to accept connections database started DROP SCHEMA DELETE 0 DELETE 0 DELETE 0 DELETE 0 UPDATE 3 Stopping database 297 2021-01-12 06:36:58.755 GMTLOG: received fast shutdown request 297 2021-01-12 06:36:58.755 GMTLOG: aborting any active transactions 300 2021-01-12 06:36:58.755 GMTLOG: shutting down 300 2021-01-12 06:36:58.767 GMTLOG: database system is shut down /sdisk/oldpgconfdump.sql is created Starting conf database 344 2021-01-12 06:37:07.381 GMTLOG: could not connect socket for statistics collector: Network is unreachable 344 2021-01-12 06:37:07.381 GMTLOG: disabling statistics collector for lack of working socket 346 2021-01-12 06:37:07.382 GMTLOG: database system was shut down at 2020-11-13 04:15:52 GMT 344 2021-01-12 06:37:07.384 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 355 2021-01-12 06:37:16.018 GMTERROR: cannot drop language plpgsql because extension plpgsql requires it 355 2021-01-12 06:37:16.018 GMTHINT: You can drop extension plpgsql instead. 355 2021-01-12 06:37:16.018 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:16826: WARNING: column "senderemail" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/sdisk/oldpgconfdump.sql:16826: 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 -------- 88 (1 row) 347 2021-01-12 06:37:17.125 GMTLOG: checkpoints are occurring too frequently (10 seconds apart) 347 2021-01-12 06:37:17.125 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments". Stopping database 344 2021-01-12 06:37:19.187 GMTLOG: received fast shutdown request 344 2021-01-12 06:37:19.187 GMTLOG: aborting any active transactions 347 2021-01-12 06:37:19.278 GMTLOG: shutting down 347 2021-01-12 06:37:19.342 GMTLOG: database system is shut down old conf to new conf migrated with return value :: 0 Tue Jan 12 17:07:27 ACDT 2021 starting migration log Starting conf database 386 2021-01-12 06:37:27.295 GMTLOG: could not connect socket for statistics collector: Network is unreachable 386 2021-01-12 06:37:27.295 GMTLOG: disabling statistics collector for lack of working socket 388 2021-01-12 06:37:27.296 GMTLOG: database system was shut down at 2021-01-12 06:37:19 GMT 386 2021-01-12 06:37:27.298 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 nvram_get failed with -16 Old version is 17.320 and currentversion is 17.323 Database is upgrading to dbv17.321 Check migration for version dbv17.321 Applying migration for version dbv17.321 Database is upgrading to dbv17.322 Check migration for version dbv17.322 Applying migration for version dbv17.322 Database is upgrading to dbv17.323 Check migration for version dbv17.323 Applying migration for version dbv17.323 create_pguser --------------- (1 row) UPDATE 1 Stopping database 386 2021-01-12 06:37:37.069 GMTLOG: received fast shutdown request 386 2021-01-12 06:37:37.069 GMTLOG: aborting any active transactions 389 2021-01-12 06:37:37.070 GMTLOG: shutting down 389 2021-01-12 06:37:37.104 GMTLOG: database system is shut down applymigration.sh exited with 0 Doing /conf/certificate/cacerts/ WARNING: Skipping expired Certificate Thawte_Premium_Server_CA.pem WARNING: Skipping expired Certificate Thawte_Server_CA.pem WARNING: Skipping expired Certificate ThawtePersonalPremiumCA.pem WARNING: Skipping expired Certificate ThawtePersonalBasicCA.pem WARNING: Skipping expired Certificate ThawtePersonalFreemailCA.pem WARNING: Skipping expired Certificate ThawteTimestampingCA.pem
This thread was automatically locked due to age.