Upgrade problem from 5.2.6 to 5.4

[motitest]

n/mysqld/mysqld.sock' (2)
1547:20210331:122902.491 database is down: reconnecting in 10 seconds
1547:20210331:122912.491 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
1547:20210331:122912.491 database is down: reconnecting in 10 seconds
1547:20210331:122922.492 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
1547:20210331:122922.492 database is down: reconnecting in 10 seconds
1547:20210331:122932.492 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
1547:20210331:122932.492 database is down: reconnecting in 10 seconds
1547:20210331:122942.492 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
1547:20210331:122942.492 database is down: reconnecting in 10 seconds
1547:20210331:122952.549 database connection re-established
1547:20210331:122954.745 current database version (mandatory/optional): 05000000/05000002
1547:20210331:122958.007 database is not upgraded to use double precision values
1466:20210331:123829.539 current database version (mandatory/optional): 05000000/05000002
1466:20210331:123833.610 database is not upgraded to use double precision values
3612:20210331:125553.331 current database version (mandatory/optional): 05000000/05000002
3612:20210331:125553.331 starting automatic database upgrade
3612:20210331:125725.244 completed 1% of database upgrade
3612:20210331:125725.376 completed 2% of database upgrade
3612:20210331:125725.872 completed 4% of database upgrade
3612:20210331:125725.876 completed 5% of database upgrade
3612:20210331:125730.711 completed 7% of database upgrade
3612:20210331:125817.633 completed 8% of database upgrade
3612:20210331:125820.452 completed 10% of database upgrade
31:125940.219 completed 91% of database upgrade
3612:20210331:125941.617 completed 92% of database upgrade
3612:20210331:125943.156 completed 94% of database upgrade
3612:20210331:125946.255 completed 95% of database upgrade
3612:20210331:125952.385 completed 97% of database upgrade
3612:20210331:125952.737 completed 98% of database upgrade
3612:20210331:125952.741 completed 100% of database upgrade
3612:20210331:125952.741 database upgrade fully completed
3612:20210331:125952.756 database is not upgraded to use double precision values
2053:20210331:132340.015 current database version (mandatory/optional): 05020000/05020000
2053:20210331:132350.199 database is not upgraded to use double precision values
Binary file (standard input) matches


what is the issue?

[Atsushi]

It seems that the parts that can be upgraded automatically when upgrading to 5.2 have been upgraded normally. Isn't the subsequent log output?
Did the package upgrade complete successfully? Check the currently installed Zabbix related packages.

[motitest]

cat /var/log/zabbix/zabbix_server.log | grep database



3863:20210603:163732.854 database is down: reconnecting in 10 seconds
3910:20210603:163732.921 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
3910:20210603:163732.921 database is down: reconnecting in 10 seconds
3912:20210603:163733.139 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
3912:20210603:163733.139 database is down: reconnecting in 10 seconds
3898:20210603:163734.596 [Z3001] connection to database 'nmonitor_prod' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
3898:20210603:163734.596 database is down: reconnecting in 10 seconds
3909:20210603:163740.151 database connection re-established
3869:20210603:163740.473 database connection re-established
3871:20210603:163740.476 database connection re-established
3933:20210603:163740.527 database connection re-established
3865:20210603:163740.612 database connection re-established
3900:20210603:163740.720 database connection re-established
3911:20210603:163741.230 database connection re-established
3870:20210603:163741.526 database connection re-established
3868:20210603:163741.528 database connection re-established
3913:20210603:163741.769 database connection re-established
3866:20210603:163742.019 database connection re-established
3943:20210603:163742.145 database connection re-established
3872:20210603:163742.373 database connection re-established
3863:20210603:163742.855 database connection re-established
3910:20210603:163742.922 database connection re-established
3912:20210603:163743.140 database connection re-established
3898:20210603:163744.597 database connection re-established
4861:20210603:163839.099 current database version (mandatory/optional): 05040000/05040000