This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SFOS 18.0.4 MR-4 upgrade failed and rebooted to previous firmware

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.
Parents Reply Children
  • I am facing the same issue.. any solution in this regard??

  • Hello Faiyaz,

    Thank you for contacting the Sophos Community!

    Please open a case with support and provide the output of the following:

    1) Put csc in debug mode

    # csc custom debug 

    (no output would be generated)

    2) Upgrade to 18 MR4 or latest available.

    3) Provide the output of the following logs:

    csc.log, applog.log, postgres.log, syslog.log

    4) And the output of the following commands:

    nvram get '#'li.status
    nvram get "#li.master"
    nvram get '#'li.serial
    showfw
    cat /etc/fwtype
    cat /etc/fwgroup
    cat /etc/version
    system diagnostics show version-info

    # grep  syslog.log.0 | grep -e "error\|fail" | head

    # grep "Command line: auto BOOT_IMAGE" syslog.log.0 | tail -n5

    # hdparm -i /dev/sda

    5) Connect a Serial Cable and get the console output

    Regards,


     
    Emmanuel (EmmoSophos)
    Technical Team Lead, Global Community Support
    Sophos Support VideosProduct Documentation  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'Verify Answer' link.