Guest User!

You are not Sophos Staff.

Parents
  • Anyone seen this error migrating config after upgrading from SFOS 18.5.4 MR-4-Build418

    Database is upgrading to dbv19.003
    Check migration for version dbv19.003
    Applying migration for version dbv19.003
    1513 :send_data_to_listener: write error 'Network is unreachable'
    Cleaned up nasm directories using mv/rm
    Database is upgrading to dbv19.004
    Check migration for version dbv19.004
    Applying migration for version dbv19.004
    1520 2022-09-11 21:19:52.449 GMTERROR: update or delete on table "tblrootcainfo" violates foreign key constraint "tblvpncertificate_caid_fkey" on table "tblvpncertificate"
    1520 2022-09-11 21:19:52.449 GMTDETAIL: Key (companyid)=(54) is still referenced from table "tblvpncertificate".
    1520 2022-09-11 21:19:52.449 GMTSTATEMENT: delete from tblrootcainfo where caname in ('Lets_Encrypt_r3','AC_RAIZ_FNMT_RCM_SERVIDORES_SEGUROS','GlobalSign_Root_R46','GlobalSign_Root_E46','GLOBALTRUST_2020','ANF_Secure_Server_Root_CA','Certum_EC_384_CA','Certum_Trusted_Root_CA','TunTrust_Root_CA','HARICA_TLS_RSA_Root_CA_2021','HARICA_TLS_ECC_Root_CA_2021','vTrus_ECC_Root_CA','vTrus_Root_CA','ISRG_Root_X2','A_Trust_Root_07','DigiCert_RSA4096_Root_G5','DigiCert_SMIME_RSA4096_Root_G5','DigiCert_TLS_ECC_P384_Root_G5','DigiCert_TLS_RSA4096_Root_G5','DigiCert_SMIME_ECC_P384_Root_G5','DigiCert_CS_RSA4096_Root_G5','DigiCert_Client_RSA4096_Root_G5','DigiCert_Client_ECC_P384_Root_G5','DigiCert_ECC_P384_Root_G5','DigiCert_CS_ECC_P384_Root_G5','GlobalSign_Secure_Mail_Root_E45','GlobalSign_Secure_Mail_Root_R45','GlobalSign_Client_Authentication_Root_R45','GlobalSign_Client_Authentication_Root_E45','GlobalSign_Code_Signing_Root_E45','GlobalSign_Document_Signing_Root_R45','GlobalSign_Document_Signing_Root_E45','GlobalSign_Code_Signing_Root_R45','GlobalSign_Timestamping_Root_R45','Autoridade_Certificadora_Raiz_Brasileira_v10','DVV_Gov._Root_CA_G3_ECC','DVV_Gov._Root_CA_G3_RSA','HARICA_Code_Signing_RSA_Root_CA_2021','HARICA_Client_ECC_Root_CA_2021','HARICA_Client_RSA_Root_CA_2021','HARICA_Code_Signing_ECC_Root_CA_2021','Microsoft_Identity_Verification_Root_Certificate_Authority_2020','I.CA_Root_CA_ECC_12_2016','Telia_Root_CA_v2','Izenpe.com');
    psql:/_conf/DB/dbv19.004/corporate.sql:68: ERROR: update or delete on table "tblrootcainfo" violates foreign key constraint "tblvpncertificate_caid_fkey" on table "tblvpncertificate"
    DETAIL: Key (companyid)=(54) is still referenced from table "tblvpncertificate".
    /bin/psql -1 -p 5432 -U pgroot -q -d corporate -f /_conf//DB/dbv19.004/corporate.sql Failed
    /bin/sh /_conf//DB/dbv19.004/migration.sh Failed
    UPDATE 1
    Stopping database

    488 2022-09-11 21:19:55.104 GMTLOG: received fast shutdown request
    488 2022-09-11 21:19:55.105 GMTLOG: aborting any active transactions
    491 2022-09-11 21:19:55.105 GMTLOG: shutting down
    491 2022-09-11 21:19:55.736 GMTLOG: database system is shut down
    2022-09-11 21:19:56.143 GMT : Database stopped after 1 seconds
    applymigration.sh exited with 1
    2022-09-11 21:20:22.672 GMT: Before mountconf unmount

    Thanks

Reply Children
No Data