XG Firewall v18 MR-5: Feedback and experiences

I upgraded a few of our hardware firewalls this week-end. All were successful except 1. It failed to reboot successfully and never recovered. I have to power off and choose the previous firmware version from the boot loader. Looks like another very, very long phone call to support in my future.

All were upgrades from 18.0.4 to 18.0.5

Check the /log/migration.log for insights, why the appliance failed to migrate. 

This is the last part of the migration.log file. Any insight would be helpful as my call to Sophos tech support was just unbearable so I hung up. The tech support guy couldn't be understood and he had no idea what was going on let alone how to troubleshoot it. Sophos is getting worse by the day...

nvram_get failed with -16
Old version is 18.031 and currentversion is 18.033
Database is upgrading to dbv18.032
Check migration for version dbv18.032
Applying migration for version dbv18.032
remove_duplicate_entry
------------------------

(1 row)

1428 2021-04-11 18:06:52.029 GMTERROR: duplicate key value violates unique constraint "tblsnmpmanagerconf_unique"
1428 2021-04-11 18:06:52.029 GMTDETAIL: Key (name, source)=($sfos$7$0$qzkr8dY8fN8iFNZnBQxwZwVWEcjP3eWosu0jI9mUH8jurqO3F4hs6mN8A-Xuxo7ZnGlotijUUKtCnEXqzwWjzw~~A7Z7nfLA3FB43QmOHGuZfbH-zAgmeymS-rLVen2qeiE~, 192.168.70.88) already exists.
1428 2021-04-11 18:06:52.029 GMTSTATEMENT: update tblsnmpmanagerconf set name=$1
DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "tblsnmpmanagerconf_unique"
DETAIL: Key (name, source)=($sfos$7$0$qzkr8dY8fN8iFNZnBQxwZwVWEcjP3eWosu0jI9mUH8jurqO3F4hs6mN8A-Xuxo7ZnGlotijUUKtCnEXqzwWjzw~~A7Z7nfLA3FB43QmOHGuZfbH-zAgmeymS-rLVen2qeiE~, 192.168.70.88) already exists. at /_conf//DB/migratesecuredata.pl line 279.
DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "tblsnmpmanagerconf_unique"
DETAIL: Key (name, source)=($sfos$7$0$qzkr8dY8fN8iFNZnBQxwZwVWEcjP3eWosu0jI9mUH8jurqO3F4hs6mN8A-Xuxo7ZnGlotijUUKtCnEXqzwWjzw~~A7Z7nfLA3FB43QmOHGuZfbH-zAgmeymS-rLVen2qeiE~, 192.168.70.88) already exists. at /_conf//DB/migratesecuredata.pl line 279.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=corporate; at /_conf//DB/migratesecuredata.pl line 279.
Secure password migration Failed
UPDATE 1
Stopping database
438 2021-04-11 18:06:53.699 GMTLOG: received fast shutdown request
438 2021-04-11 18:06:53.699 GMTLOG: aborting any active transactions
441 2021-04-11 18:06:53.700 GMTLOG: shutting down
441 2021-04-11 18:06:53.800 GMTLOG: database system is shut down
Sun Apr 11 15:06:54 ADT 2021 : Database stopped after 1 seconds
applymigration.sh exited with 1
Sun Apr 11 19:07:08 BST 2021: Before mountconf unmount

Delete your SNMP Traps and redo it. Seems to be a known bug, which is currently under investigation. Related to the duplicated SNMP Entries. 

Hello,

Just to add to Luca comment, the ID for this issue is being troubleshot under NC-71491

Could you please share the Case ID you have open with support?

Regards,

Hello,

Just to add to Luca comment, the ID for this issue is being troubleshot under NC-71491

Could you please share the Case ID you have open with support?

Regards,

This is fixed in the Re Release of MR5. There will be a new Build available on the Portal.