Ad Widget

Collapse

'zabbixdb.hosts_name_upper_insert' already exists when importing mysql database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fol
    Junior Member
    • Nov 2023
    • 5

    #1

    'zabbixdb.hosts_name_upper_insert' already exists when importing mysql database

    Hello everyone,

    By following the installation procedure with the source, I install zabbix server then I import my database with all my dashboards.
    I had no problem with zabbix 6.0.5 and database version 6.0.2. I upgraded to 6.0.24 and 6.0.25 and the database was upgraded to 6.0.36. From there, in a new install, importing the database triggers the errors as following :
    Code:
    #mysql -uroot -p$MARIADB_ROOT_PWD $ZABBIX_MYSQL_DB < ${FIC_SRC[Zabbixdb]}
    ERROR 1359 (HY000) at line 34971: Trigger 'zabbixdb.hosts_name_upper_insert' already exists
    This causes the suppression of all users especially the zabbix admin and the server cannot start.

    Is anyone having the same issue ?

    Thanks
Working...