Guest User!

You are not Sophos Staff.

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

XG210 rev2 won't upgrade

I have a XG210 Rev2 appliance running SFOS v17.5.16 MR-16-Build830

This box doesn't want to upgrade.

In the web admin under Backup&Firmware SFOS 18.5.1 MR1-Build326 is shown as latest available firmware.
Downloading, applying doesn't give any errors. But after the reboot, no upgrade occured. It boots into its current version 17.5.16

In mySophos I have downloaded the 2 firmwares available for this device:
.SFOS 18.5.2 MR2-Build380
.SFOS 18.0.6 MR6-Build655

Same thing here. After an upload into the box (no errors) and a reboot, nothing happens. It boots into version 17.5.16

Any suggestions?

Thx



This thread was automatically locked due to age.
Parents
  • Seems like the migration does not work.

    Check the CLI logs: /log/migration.log

  • Thanks for your reply.

    I have inserted the last 500 records of the migration.log
    The latest entry is dated 2021-07-14.

    We tried to upgrade last week (2021-12-30) -> not a single entry?!

    2021-07-14 corresponds with the previous upgrade (to v17.5.16) we were told to do relating to and resolving case 04219299 (No web access after activating imported certificate).
    The Sophos tech at that time suggested to wait for the release of 18.0.6 MR6-Build655 in order to upgrade from v17.5.16

    Could this be related?

    Should we try to upgrade using SFLoader?
    Or even reimage ?

    XG210_WP02_SFOS 17.5.16 MR-16-Build830# tail -n 500 /log/migration.log
    UPDATE 1
    Stopping database
    351 2019-07-18 10:09:00.713 GMTLOG:  received fast shutdown request
    351 2019-07-18 10:09:00.713 GMTLOG:  aborting any active transactions
    354 2019-07-18 10:09:00.713 GMTLOG:  shutting down
    354 2019-07-18 10:09:00.826 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 Deutsche_Telekom_Root_CA_2.pem
    WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
    WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_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
    Doing Frako_wildcard_CA_5D30400B.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
    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_Object_Root_CA.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping duplicate certificate AddTrust_External_Root.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 NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
    Thu Jul 18 10:23:48 UTC 2019 starting old version corporate db
    Starting conf database
    272 2019-07-18 10:23:49.141 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    272 2019-07-18 10:23:49.141 GMTLOG:  disabling statistics collector for lack of working socket
    274 2019-07-18 10:23:49.142 GMTLOG:  database system was shut down at 2019-07-18 10:23:28 GMT
    272 2019-07-18 10:23:49.144 GMTLOG:  database system is ready to accept connections
    database started
    DROP SCHEMA
    DELETE 0
    DELETE 0
    DELETE 0
    DELETE 0
    UPDATE 3
    Stopping database
    272 2019-07-18 10:23:59.356 GMTLOG:  received fast shutdown request
    272 2019-07-18 10:23:59.356 GMTLOG:  aborting any active transactions
    275 2019-07-18 10:23:59.356 GMTLOG:  shutting down
    275 2019-07-18 10:23:59.379 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    319 2019-07-18 10:24:08.215 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    319 2019-07-18 10:24:08.215 GMTLOG:  disabling statistics collector for lack of working socket
    321 2019-07-18 10:24:08.215 GMTLOG:  database system was shut down at 2019-07-04 21:13:50 GMT
    319 2019-07-18 10:24:08.218 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
    330 2019-07-18 10:24:17.073 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    330 2019-07-18 10:24:17.073 GMTHINT:  You can drop extension plpgsql instead.
    330 2019-07-18 10:24:17.073 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:16551: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16551: 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
    --------
        109
    (1 row)
    
    322 2019-07-18 10:24:18.609 GMTLOG:  checkpoints are occurring too frequently (10 seconds apart)
    322 2019-07-18 10:24:18.609 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    319 2019-07-18 10:24:21.162 GMTLOG:  received fast shutdown request
    319 2019-07-18 10:24:21.162 GMTLOG:  aborting any active transactions
    322 2019-07-18 10:24:21.277 GMTLOG:  shutting down
    322 2019-07-18 10:24:21.324 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Thu Jul 18 12:24:29 CEST 2019 starting migration log
    Starting conf database
    360 2019-07-18 10:24:29.275 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    360 2019-07-18 10:24:29.275 GMTLOG:  disabling statistics collector for lack of working socket
    362 2019-07-18 10:24:29.276 GMTLOG:  database system was shut down at 2019-07-18 10:24:21 GMT
    360 2019-07-18 10:24:29.278 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
    360 2019-07-18 10:24:39.259 GMTLOG:  received fast shutdown request
    360 2019-07-18 10:24:39.260 GMTLOG:  aborting any active transactions
    363 2019-07-18 10:24:39.260 GMTLOG:  shutting down
    363 2019-07-18 10:24:39.287 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
    Doing Frako_wildcard_CA_5D30400B.pem
    WARNING: Skipping duplicate certificate AddTrust_External_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 RSA_Root_Certificate_1.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
    WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
    WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
    WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.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 UTN_USERFirst_Object_Root_CA.pem
    WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
    Tue Jul 14 12:16:50 UTC 2020 starting old version corporate db
    Starting conf database
    273 2020-07-14 12:16:51.045 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    273 2020-07-14 12:16:51.045 GMTLOG:  disabling statistics collector for lack of working socket
    275 2020-07-14 12:16:51.046 GMTLOG:  database system was shut down at 2020-07-14 12:16:30 GMT
    273 2020-07-14 12:16:51.048 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 2020-07-14 12:17:01.097 GMTLOG:  received fast shutdown request
    273 2020-07-14 12:17:01.097 GMTLOG:  aborting any active transactions
    276 2020-07-14 12:17:01.097 GMTLOG:  shutting down
    276 2020-07-14 12:17:01.110 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    320 2020-07-14 12:17:09.951 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    320 2020-07-14 12:17:09.951 GMTLOG:  disabling statistics collector for lack of working socket
    322 2020-07-14 12:17:09.952 GMTLOG:  database system was shut down at 2020-06-30 00:25:20 GMT
    320 2020-07-14 12:17:09.954 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 2020-07-14 12:17:18.799 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    331 2020-07-14 12:17:18.799 GMTHINT:  You can drop extension plpgsql instead.
    331 2020-07-14 12:17:18.799 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:16839: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16839: 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
    --------
        109
    (1 row)
    
    323 2020-07-14 12:17:20.340 GMTLOG:  checkpoints are occurring too frequently (11 seconds apart)
    323 2020-07-14 12:17:20.340 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    320 2020-07-14 12:17:22.822 GMTLOG:  received fast shutdown request
    320 2020-07-14 12:17:22.822 GMTLOG:  aborting any active transactions
    323 2020-07-14 12:17:22.923 GMTLOG:  shutting down
    323 2020-07-14 12:17:23.001 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Tue Jul 14 14:17:30 CEST 2020 starting migration log
    Starting conf database
    361 2020-07-14 12:17:30.947 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    361 2020-07-14 12:17:30.947 GMTLOG:  disabling statistics collector for lack of working socket
    363 2020-07-14 12:17:30.948 GMTLOG:  database system was shut down at 2020-07-14 12:17:23 GMT
    361 2020-07-14 12:17:30.950 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.320
    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)
    
    Database is upgrading to dbv17.317
    Check migration for version dbv17.317
    Applying migration for version dbv17.317
    Database is upgrading to dbv17.318
    Check migration for version dbv17.318
    Applying migration for version dbv17.318
    Database is upgrading to dbv17.319
    Check migration for version dbv17.319
    Applying migration for version dbv17.319
    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
    361 2020-07-14 12:17:43.715 GMTLOG:  received fast shutdown request
    361 2020-07-14 12:17:43.715 GMTLOG:  aborting any active transactions
    364 2020-07-14 12:17:43.715 GMTLOG:  shutting down
    364 2020-07-14 12:17:43.751 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    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 Class1PublicPrimaryCertificationAuthority_2.pem
    Doing Frako_wildcard_CA_5D30400B.pem
    WARNING: Skipping expired Certificate Frako_wildcard_CA_5D30400B.pem1.pem
    WARNING: Skipping expired Certificate AddTrust_Qualified_Certificates_Root.pem
    WARNING: Skipping expired Certificate AddTrust_Low_Value_Services_Root.pem
    WARNING: Skipping expired Certificate Sophos_Firewall_Content_Licensing_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 STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
    WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.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 STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
    WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
    WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
    WARNING: Skipping expired Certificate AddTrust_Public_Services_Root.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 Equifax_Secure_eBusiness_CA_1.pem
    WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
    WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_Secure_Server_CA_-_G3.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
    WARNING: Skipping expired Certificate Equifax_Secure_Global_eBusiness_CA.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate AddTrust_External_Root.pem
    WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem
    Wed Jul 14 10:56:44 UTC 2021 starting old version corporate db
    Starting conf database
    287 2021-07-14 10:56:44.399 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    287 2021-07-14 10:56:44.399 GMTLOG:  disabling statistics collector for lack of working socket
    289 2021-07-14 10:56:44.400 GMTLOG:  database system was shut down at 2021-07-14 10:56:23 GMT
    287 2021-07-14 10:56:44.416 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 2021-07-14 10:56:54.887 GMTLOG:  received fast shutdown request
    287 2021-07-14 10:56:54.887 GMTLOG:  aborting any active transactions
    290 2021-07-14 10:56:54.887 GMTLOG:  shutting down
    290 2021-07-14 10:56:55.535 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    334 2021-07-14 10:57:05.142 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    334 2021-07-14 10:57:05.142 GMTLOG:  disabling statistics collector for lack of working socket
    336 2021-07-14 10:57:05.143 GMTLOG:  database system was shut down at 2021-06-25 17:03:24 GMT
    334 2021-07-14 10:57:05.145 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 2021-07-14 10:57:14.024 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    345 2021-07-14 10:57:14.024 GMTHINT:  You can drop extension plpgsql instead.
    345 2021-07-14 10:57:14.024 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:16881: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16881: 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
    --------
        109
    (1 row)
    
    337 2021-07-14 10:57:15.483 GMTLOG:  checkpoints are occurring too frequently (10 seconds apart)
    337 2021-07-14 10:57:15.483 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    334 2021-07-14 10:57:17.980 GMTLOG:  received fast shutdown request
    334 2021-07-14 10:57:17.980 GMTLOG:  aborting any active transactions
    337 2021-07-14 10:57:18.091 GMTLOG:  shutting down
    337 2021-07-14 10:57:18.140 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Wed Jul 14 12:57:26 CEST 2021 starting migration log
    Starting conf database
    375 2021-07-14 10:57:26.114 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    375 2021-07-14 10:57:26.114 GMTLOG:  disabling statistics collector for lack of working socket
    377 2021-07-14 10:57:26.115 GMTLOG:  database system was shut down at 2021-07-14 10:57:18 GMT
    375 2021-07-14 10:57:26.117 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.324
    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
    Database is upgrading to dbv17.324
    Check migration for version dbv17.324
    Applying migration for version dbv17.324
     remove_duplicate_entry
    ------------------------
    
    (1 row)
    
     create_pguser
    ---------------
    
    (1 row)
    
    UPDATE 1
    Stopping database
    375 2021-07-14 10:57:37.007 GMTLOG:  received fast shutdown request
    375 2021-07-14 10:57:37.007 GMTLOG:  aborting any active transactions
    378 2021-07-14 10:57:37.007 GMTLOG:  shutting down
    378 2021-07-14 10:57:37.050 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    WARNING: Skipping expired Certificate ThawtePersonalPremiumCA.pem
    WARNING: Skipping expired Certificate QuoVadis_Root_CA.pem
    WARNING: Skipping expired Certificate ThawtePersonalBasicCA.pem
    WARNING: Skipping expired Certificate Microsoft_Root_Certificate_Authority.pem
    Doing Frako wildcard 2021_CA_60EC7670.pem
    WARNING: Skipping expired Certificate ThawteTimestampingCA.pem
    WARNING: Skipping expired Certificate TDC_Internet_Root_CA.pem
    WARNING: Skipping expired Certificate Thawte_Server_CA.pem
    WARNING: Skipping expired Certificate Root_CA_Generalitat_Valenciana.pem
    WARNING: Skipping expired Certificate Sonera_Class_1_Root_CA.pem
    WARNING: Skipping expired Certificate ThawtePersonalFreemailCA.pem
    WARNING: Skipping expired Certificate WellsFargoRootCertificateAuthority.pem
    WARNING: Skipping expired Certificate Sonera_Class_2_Root_CA.pem
    WARNING: Skipping expired Certificate Thawte_Premium_Server_CA.pem
    WARNING: Skipping duplicate certificate USERTrust_RSA_Certification_Authority.pem
    XG210_WP02_SFOS 17.5.16 MR-16-Build830#
    

Reply
  • Thanks for your reply.

    I have inserted the last 500 records of the migration.log
    The latest entry is dated 2021-07-14.

    We tried to upgrade last week (2021-12-30) -> not a single entry?!

    2021-07-14 corresponds with the previous upgrade (to v17.5.16) we were told to do relating to and resolving case 04219299 (No web access after activating imported certificate).
    The Sophos tech at that time suggested to wait for the release of 18.0.6 MR6-Build655 in order to upgrade from v17.5.16

    Could this be related?

    Should we try to upgrade using SFLoader?
    Or even reimage ?

    XG210_WP02_SFOS 17.5.16 MR-16-Build830# tail -n 500 /log/migration.log
    UPDATE 1
    Stopping database
    351 2019-07-18 10:09:00.713 GMTLOG:  received fast shutdown request
    351 2019-07-18 10:09:00.713 GMTLOG:  aborting any active transactions
    354 2019-07-18 10:09:00.713 GMTLOG:  shutting down
    354 2019-07-18 10:09:00.826 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 Deutsche_Telekom_Root_CA_2.pem
    WARNING: Skipping expired Certificate Digital_Signature_Trust_Co_Global_CA_3.pem
    WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_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
    Doing Frako_wildcard_CA_5D30400B.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
    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_Object_Root_CA.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping duplicate certificate AddTrust_External_Root.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 NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
    Thu Jul 18 10:23:48 UTC 2019 starting old version corporate db
    Starting conf database
    272 2019-07-18 10:23:49.141 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    272 2019-07-18 10:23:49.141 GMTLOG:  disabling statistics collector for lack of working socket
    274 2019-07-18 10:23:49.142 GMTLOG:  database system was shut down at 2019-07-18 10:23:28 GMT
    272 2019-07-18 10:23:49.144 GMTLOG:  database system is ready to accept connections
    database started
    DROP SCHEMA
    DELETE 0
    DELETE 0
    DELETE 0
    DELETE 0
    UPDATE 3
    Stopping database
    272 2019-07-18 10:23:59.356 GMTLOG:  received fast shutdown request
    272 2019-07-18 10:23:59.356 GMTLOG:  aborting any active transactions
    275 2019-07-18 10:23:59.356 GMTLOG:  shutting down
    275 2019-07-18 10:23:59.379 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    319 2019-07-18 10:24:08.215 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    319 2019-07-18 10:24:08.215 GMTLOG:  disabling statistics collector for lack of working socket
    321 2019-07-18 10:24:08.215 GMTLOG:  database system was shut down at 2019-07-04 21:13:50 GMT
    319 2019-07-18 10:24:08.218 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
    330 2019-07-18 10:24:17.073 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    330 2019-07-18 10:24:17.073 GMTHINT:  You can drop extension plpgsql instead.
    330 2019-07-18 10:24:17.073 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:16551: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16551: 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
    --------
        109
    (1 row)
    
    322 2019-07-18 10:24:18.609 GMTLOG:  checkpoints are occurring too frequently (10 seconds apart)
    322 2019-07-18 10:24:18.609 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    319 2019-07-18 10:24:21.162 GMTLOG:  received fast shutdown request
    319 2019-07-18 10:24:21.162 GMTLOG:  aborting any active transactions
    322 2019-07-18 10:24:21.277 GMTLOG:  shutting down
    322 2019-07-18 10:24:21.324 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Thu Jul 18 12:24:29 CEST 2019 starting migration log
    Starting conf database
    360 2019-07-18 10:24:29.275 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    360 2019-07-18 10:24:29.275 GMTLOG:  disabling statistics collector for lack of working socket
    362 2019-07-18 10:24:29.276 GMTLOG:  database system was shut down at 2019-07-18 10:24:21 GMT
    360 2019-07-18 10:24:29.278 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
    360 2019-07-18 10:24:39.259 GMTLOG:  received fast shutdown request
    360 2019-07-18 10:24:39.260 GMTLOG:  aborting any active transactions
    363 2019-07-18 10:24:39.260 GMTLOG:  shutting down
    363 2019-07-18 10:24:39.287 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_2_Policy_Validation_Authority.pem
    Doing Frako_wildcard_CA_5D30400B.pem
    WARNING: Skipping duplicate certificate AddTrust_External_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 RSA_Root_Certificate_1.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping expired Certificate STATIC_GTE_Corporation_GTE_CyberTrust_Global_Root.pem
    WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
    WARNING: Skipping expired Certificate STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
    WARNING: Skipping expired Certificate Deutsche_Telekom_Root_CA_2.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 UTN_USERFirst_Object_Root_CA.pem
    WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
    WARNING: Skipping expired Certificate STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Hardware_Root_CA.pem
    Tue Jul 14 12:16:50 UTC 2020 starting old version corporate db
    Starting conf database
    273 2020-07-14 12:16:51.045 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    273 2020-07-14 12:16:51.045 GMTLOG:  disabling statistics collector for lack of working socket
    275 2020-07-14 12:16:51.046 GMTLOG:  database system was shut down at 2020-07-14 12:16:30 GMT
    273 2020-07-14 12:16:51.048 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 2020-07-14 12:17:01.097 GMTLOG:  received fast shutdown request
    273 2020-07-14 12:17:01.097 GMTLOG:  aborting any active transactions
    276 2020-07-14 12:17:01.097 GMTLOG:  shutting down
    276 2020-07-14 12:17:01.110 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    320 2020-07-14 12:17:09.951 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    320 2020-07-14 12:17:09.951 GMTLOG:  disabling statistics collector for lack of working socket
    322 2020-07-14 12:17:09.952 GMTLOG:  database system was shut down at 2020-06-30 00:25:20 GMT
    320 2020-07-14 12:17:09.954 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 2020-07-14 12:17:18.799 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    331 2020-07-14 12:17:18.799 GMTHINT:  You can drop extension plpgsql instead.
    331 2020-07-14 12:17:18.799 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:16839: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16839: 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
    --------
        109
    (1 row)
    
    323 2020-07-14 12:17:20.340 GMTLOG:  checkpoints are occurring too frequently (11 seconds apart)
    323 2020-07-14 12:17:20.340 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    320 2020-07-14 12:17:22.822 GMTLOG:  received fast shutdown request
    320 2020-07-14 12:17:22.822 GMTLOG:  aborting any active transactions
    323 2020-07-14 12:17:22.923 GMTLOG:  shutting down
    323 2020-07-14 12:17:23.001 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Tue Jul 14 14:17:30 CEST 2020 starting migration log
    Starting conf database
    361 2020-07-14 12:17:30.947 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    361 2020-07-14 12:17:30.947 GMTLOG:  disabling statistics collector for lack of working socket
    363 2020-07-14 12:17:30.948 GMTLOG:  database system was shut down at 2020-07-14 12:17:23 GMT
    361 2020-07-14 12:17:30.950 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.320
    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)
    
    Database is upgrading to dbv17.317
    Check migration for version dbv17.317
    Applying migration for version dbv17.317
    Database is upgrading to dbv17.318
    Check migration for version dbv17.318
    Applying migration for version dbv17.318
    Database is upgrading to dbv17.319
    Check migration for version dbv17.319
    Applying migration for version dbv17.319
    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
    361 2020-07-14 12:17:43.715 GMTLOG:  received fast shutdown request
    361 2020-07-14 12:17:43.715 GMTLOG:  aborting any active transactions
    364 2020-07-14 12:17:43.715 GMTLOG:  shutting down
    364 2020-07-14 12:17:43.751 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    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 Class1PublicPrimaryCertificationAuthority_2.pem
    Doing Frako_wildcard_CA_5D30400B.pem
    WARNING: Skipping expired Certificate Frako_wildcard_CA_5D30400B.pem1.pem
    WARNING: Skipping expired Certificate AddTrust_Qualified_Certificates_Root.pem
    WARNING: Skipping expired Certificate AddTrust_Low_Value_Services_Root.pem
    WARNING: Skipping expired Certificate Sophos_Firewall_Content_Licensing_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 STATIC_StartCom_Ltd_StartCom_Extended_Validation_Server_CA.pem
    WARNING: Skipping expired Certificate Certplus_Class_2_Primary_CA.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 STATIC_ValiCert_Inc_ValiCert_Class_1_Policy_Validation_Authority.pem
    WARNING: Skipping expired Certificate UTN_DATACorp_SGC_Root_CA.pem
    WARNING: Skipping expired Certificate NetLock_Notary_Class_A_Root.pem
    WARNING: Skipping expired Certificate Equifax_Secure_CA.pem
    WARNING: Skipping expired Certificate NetLock_Business_Class_B_Root.pem
    WARNING: Skipping expired Certificate RSA_Root_Certificate_1.pem
    WARNING: Skipping expired Certificate AddTrust_Public_Services_Root.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 Equifax_Secure_eBusiness_CA_1.pem
    WARNING: Skipping expired Certificate STATIC_Entrust_net_Secure_Server_Certification_Authority.pem
    WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_Secure_Server_CA_-_G3.pem
    WARNING: Skipping expired Certificate UTN_USERFirst_Email_Root_CA.pem
    WARNING: Skipping expired Certificate Equifax_Secure_Global_eBusiness_CA.pem
    WARNING: Skipping expired Certificate GeoTrust_Global_CA_2.pem
    WARNING: Skipping expired Certificate AddTrust_External_Root.pem
    WARNING: Skipping expired Certificate STATIC_VeriSign_Inc_VeriSign_Class_3_International_Server_CA_-_G3.pem
    Wed Jul 14 10:56:44 UTC 2021 starting old version corporate db
    Starting conf database
    287 2021-07-14 10:56:44.399 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    287 2021-07-14 10:56:44.399 GMTLOG:  disabling statistics collector for lack of working socket
    289 2021-07-14 10:56:44.400 GMTLOG:  database system was shut down at 2021-07-14 10:56:23 GMT
    287 2021-07-14 10:56:44.416 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 2021-07-14 10:56:54.887 GMTLOG:  received fast shutdown request
    287 2021-07-14 10:56:54.887 GMTLOG:  aborting any active transactions
    290 2021-07-14 10:56:54.887 GMTLOG:  shutting down
    290 2021-07-14 10:56:55.535 GMTLOG:  database system is shut down
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    334 2021-07-14 10:57:05.142 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    334 2021-07-14 10:57:05.142 GMTLOG:  disabling statistics collector for lack of working socket
    336 2021-07-14 10:57:05.143 GMTLOG:  database system was shut down at 2021-06-25 17:03:24 GMT
    334 2021-07-14 10:57:05.145 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 2021-07-14 10:57:14.024 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    345 2021-07-14 10:57:14.024 GMTHINT:  You can drop extension plpgsql instead.
    345 2021-07-14 10:57:14.024 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:16881: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:16881: 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
    --------
        109
    (1 row)
    
    337 2021-07-14 10:57:15.483 GMTLOG:  checkpoints are occurring too frequently (10 seconds apart)
    337 2021-07-14 10:57:15.483 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    334 2021-07-14 10:57:17.980 GMTLOG:  received fast shutdown request
    334 2021-07-14 10:57:17.980 GMTLOG:  aborting any active transactions
    337 2021-07-14 10:57:18.091 GMTLOG:  shutting down
    337 2021-07-14 10:57:18.140 GMTLOG:  database system is shut down
    old conf to new conf migrated with return value :: 0
    Wed Jul 14 12:57:26 CEST 2021 starting migration log
    Starting conf database
    375 2021-07-14 10:57:26.114 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    375 2021-07-14 10:57:26.114 GMTLOG:  disabling statistics collector for lack of working socket
    377 2021-07-14 10:57:26.115 GMTLOG:  database system was shut down at 2021-07-14 10:57:18 GMT
    375 2021-07-14 10:57:26.117 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.324
    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
    Database is upgrading to dbv17.324
    Check migration for version dbv17.324
    Applying migration for version dbv17.324
     remove_duplicate_entry
    ------------------------
    
    (1 row)
    
     create_pguser
    ---------------
    
    (1 row)
    
    UPDATE 1
    Stopping database
    375 2021-07-14 10:57:37.007 GMTLOG:  received fast shutdown request
    375 2021-07-14 10:57:37.007 GMTLOG:  aborting any active transactions
    378 2021-07-14 10:57:37.007 GMTLOG:  shutting down
    378 2021-07-14 10:57:37.050 GMTLOG:  database system is shut down
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    WARNING: Skipping expired Certificate ThawtePersonalPremiumCA.pem
    WARNING: Skipping expired Certificate QuoVadis_Root_CA.pem
    WARNING: Skipping expired Certificate ThawtePersonalBasicCA.pem
    WARNING: Skipping expired Certificate Microsoft_Root_Certificate_Authority.pem
    Doing Frako wildcard 2021_CA_60EC7670.pem
    WARNING: Skipping expired Certificate ThawteTimestampingCA.pem
    WARNING: Skipping expired Certificate TDC_Internet_Root_CA.pem
    WARNING: Skipping expired Certificate Thawte_Server_CA.pem
    WARNING: Skipping expired Certificate Root_CA_Generalitat_Valenciana.pem
    WARNING: Skipping expired Certificate Sonera_Class_1_Root_CA.pem
    WARNING: Skipping expired Certificate ThawtePersonalFreemailCA.pem
    WARNING: Skipping expired Certificate WellsFargoRootCertificateAuthority.pem
    WARNING: Skipping expired Certificate Sonera_Class_2_Root_CA.pem
    WARNING: Skipping expired Certificate Thawte_Premium_Server_CA.pem
    WARNING: Skipping duplicate certificate USERTrust_RSA_Certification_Authority.pem
    XG210_WP02_SFOS 17.5.16 MR-16-Build830#
    

Children
No Data