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

  • Hi Mike , Sophos have confirmed a migration bug (from 18.5 MR4 to 19.0 MR1). One could hit this issue if one have uploaded certificate (in 18.5 MR4) signed from new CA added in 18.5 MR4 and then attempt migration to 19.0 MR1. Sophos have released a hotfix for affection version (which is 18.5 MR4).  

    Thank you very much for feedback. 

  • Hello,

    is the update released or will be release?

Reply Children
No Data