Ad Widget

Collapse

Zabbix not start after update from 4.2.8 to v5

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • wifi75
    Member
    • Apr 2018
    • 45
    #1

    Zabbix not start after update from 4.2.8 to v5

    Hello I trued to update my zabbix 4.2.8 to version 5 after send command

    after send command
    cat /var/log/zabbix/zabbix_server.log | grep database

    I have this message:

    629:20200826:151116.562 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    629:20200826:151116.562 database is down: reconnecting in 10 seconds
    629:20200826:151126.565 database connection re-established
    629:20200826:151126.567 current database version (mandatory/optional): 04020000/04020001
    4273:20200826:162219.910 current database version (mandatory/optional): 04020000/04020001
    4273:20200826:162219.910 starting automatic database upgrade
    4273:20200826:162220.013 completed 0% of database upgrade
    4273:20200826:162220.102 completed 1% of database upgrade
    4273:20200826:162220.210 completed 2% of database upgrade
    4273:20200826:162220.249 completed 3% of database upgrade
    4273:20200826:162220.526 completed 4% of database upgrade
    4273:20200826:162220.875 completed 5% of database upgrade
    4273:20200826:162220.899 completed 6% of database upgrade
    4273:20200826:162220.982 completed 7% of database upgrade
    4273:20200826:162220.999 completed 8% of database upgrade
    4273:20200826:162221.048 completed 9% of database upgrade
    4273:20200826:162221.053 completed 10% of database upgrade
    4273:20200826:162221.071 completed 11% of database upgrade
    4273:20200826:162221.092 completed 12% of database upgrade
    4273:20200826:162221.117 completed 13% of database upgrade
    4273:20200826:162221.120 completed 14% of database upgrade
    4273:20200826:162221.134 completed 15% of database upgrade
    4273:20200826:162221.138 completed 16% of database upgrade
    4273:20200826:162221.141 completed 17% of database upgrade
    4273:20200826:162221.145 completed 18% of database upgrade
    4273:20200826:162221.162 completed 19% of database upgrade
    4273:20200826:162221.171 completed 20% of database upgrade
    4273:20200826:162221.177 completed 21% of database upgrade
    4273:20200826:162221.205 completed 22% of database upgrade
    4273:20200826:162221.231 completed 23% of database upgrade
    4273:20200826:162221.256 completed 24% of database upgrade
    4273:20200826:162221.282 completed 25% of database upgrade
    4273:20200826:162221.304 completed 26% of database upgrade
    4273:20200826:162221.871 completed 27% of database upgrade
    4273:20200826:162221.889 completed 28% of database upgrade
    4273:20200826:162221.902 completed 29% of database upgrade
    4273:20200826:162222.206 completed 30% of database upgrade
    4273:20200826:162222.340 completed 31% of database upgrade
    4273:20200826:162222.525 completed 32% of database upgrade
    4273:20200826:162222.560 completed 33% of database upgrade
    4273:20200826:162222.577 completed 34% of database upgrade
    4273:20200826:162222.581 completed 35% of database upgrade
    4273:20200826:162222.598 completed 36% of database upgrade
    4273:20200826:162222.618 completed 37% of database upgrade
    4273:20200826:162222.641 completed 38% of database upgrade
    4273:20200826:162222.677 completed 39% of database upgrade
    4273:20200826:162222.695 completed 40% of database upgrade
    4273:20200826:162222.722 completed 41% of database upgrade
    4273:20200826:162222.740 completed 42% of database upgrade
    4273:20200826:162222.747 completed 43% of database upgrade
    4273:20200826:162222.764 completed 44% of database upgrade
    4273:20200826:162222.791 completed 45% of database upgrade
    4273:20200826:162222.838 completed 46% of database upgrade
    4273:20200826:162222.872 completed 47% of database upgrade
    4273:20200826:162222.926 completed 48% of database upgrade
    4273:20200826:162222.969 completed 49% of database upgrade
    4273:20200826:162223.017 completed 50% of database upgrade
    4273:20200826:162223.128 completed 51% of database upgrade
    4273:20200826:162223.152 completed 52% of database upgrade
    4273:20200826:162223.472 completed 53% of database upgrade
    4273:20200826:162223.765 completed 54% of database upgrade
    4273:20200826:162224.223 completed 55% of database upgrade
    4273:20200826:162224.487 completed 56% of database upgrade
    4273:20200826:162224.625 completed 57% of database upgrade
    4273:20200826:162224.650 completed 58% of database upgrade
    4273:20200826:162224.677 completed 59% of database upgrade
    4273:20200826:162224.680 completed 60% of database upgrade
    4273:20200826:162224.683 completed 61% of database upgrade
    4273:20200826:162224.686 completed 62% of database upgrade
    4273:20200826:162224.693 completed 63% of database upgrade
    4273:20200826:162224.702 completed 64% of database upgrade
    4273:20200826:162224.711 completed 65% of database upgrade
    4273:20200826:162224.740 completed 66% of database upgrade
    4273:20200826:162224.765 completed 67% of database upgrade
    4273:20200826:162224.790 completed 68% of database upgrade
    4273:20200826:162224.806 completed 69% of database upgrade
    4273:20200826:162224.811 completed 70% of database upgrade
    4273:20200826:162224.839 completed 71% of database upgrade
    4273:20200826:162224.867 completed 72% of database upgrade
    4273:20200826:162224.896 completed 73% of database upgrade
    4273:20200826:162224.923 completed 74% of database upgrade
    4273:20200826:162224.952 completed 75% of database upgrade
    4273:20200826:162224.982 completed 76% of database upgrade
    4273:20200826:162225.012 completed 77% of database upgrade
    4273:20200826:162225.032 completed 78% of database upgrade
    4273:20200826:162225.062 completed 79% of database upgrade
    4273:20200826:162225.068 completed 80% of database upgrade
    4273:20200826:162225.098 completed 81% of database upgrade
    4273:20200826:162225.115 completed 82% of database upgrade
    4273:20200826:162225.147 completed 83% of database upgrade
    4273:20200826:162225.164 completed 84% of database upgrade
    4273:20200826:162225.196 completed 85% of database upgrade
    4273:20200826:162225.237 completed 86% of database upgrade
    4273:20200826:162225.294 completed 87% of database upgrade
    4273:20200826:162225.316 completed 88% of database upgrade
    4273:20200826:162225.332 completed 89% of database upgrade
    4273:20200826:162225.342 completed 90% of database upgrade
    4273:20200826:162225.366 completed 91% of database upgrade
    4273:20200826:162225.394 completed 92% of database upgrade
    4273:20200826:162225.424 completed 93% of database upgrade
    4273:20200826:162225.441 completed 94% of database upgrade
    4273:20200826:162225.602 completed 95% of database upgrade
    4273:20200826:162225.645 completed 96% of database upgrade
    4273:20200826:162225.668 completed 97% of database upgrade
    4273:20200826:162225.695 completed 98% of database upgrade
    4273:20200826:162225.698 completed 99% of database upgrade
    4273:20200826:162225.700 completed 100% of database upgrade
    4273:20200826:162225.700 database upgrade fully completed
    4273:20200826:162225.793 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    4273:20200826:162225.793 only character set "utf8" and collation "utf8_bin" should be used in database
    4273:20200826:162225.795 database is not upgraded to use double precision values
    899:20200826:152852.832 current database version (mandatory/optional): 05000000/05000002
    899:20200826:152852.990 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    899:20200826:152852.990 only character set "utf8" and collation "utf8_bin" should be used in database
    899:20200826:152852.992 database is not upgraded to use double precision values
    2014:20200826:163225.354 current database version (mandatory/optional): 05000000/05000002
    2014:20200826:163225.372 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    2014:20200826:163225.372 only character set "utf8" and collation "utf8_bin" should be used in database
    2014:20200826:163225.375 database is not upgraded to use double precision values
    8342:20200827:081508.002 current database version (mandatory/optional): 05000000/05000002
    8342:20200827:081508.021 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    8342:20200827:081508.021 only character set "utf8" and collation "utf8_bin" should be used in database
    889:20200827:072034.813 current database version (mandatory/optional): 05000000/05000002
    889:20200827:072035.108 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    889:20200827:072035.108 only character set "utf8" and collation "utf8_bin" should be used in database
    893:20200827:074406.378 current database version (mandatory/optional): 05000000/05000002
    893:20200827:074406.603 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    893:20200827:074406.603 only character set "utf8" and collation "utf8_bin" should be used in database
    3000:20200827:085838.228 current database version (mandatory/optional): 05000000/05000002
    3000:20200827:085838.244 character set name or collation name that is not supported by Zabbix found in 421 column(s) of database "zabbix"
    3000:20200827:085838.244 only character set "utf8" and collation "utf8_bin" should be used in database

    what can I do for repair service?
    Last edited by wifi75; 27-08-2020, 09:11.
    Tags: None
    • isaqueprofeta
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Aug 2020
      • 154
      #2
      2014:20200826:163225.375 database is not upgraded to use double precision values
      Look at docs and apply double.sql to your database manually

      889:20200827:072035.108 only character set "utf8" and collation "utf8_bin" should be used in database
      Review the charset of your database.

        Comment

        • wifi75
          Member
          • Apr 2018
          • 45
          #3
          Originally posted by isaqueprofeta

          Look at docs and apply double.sql to your database manually



          Review the charset of your database.

          hello, allready patched but still want start :

          wget https://git.zabbix.com/projects/ZBX/...sql/double.sql
          mysql -u'zabbix' -p'zabbixDBpass' zabbix < double.sql

          -------------------------------------------------------------------------+
          | Table | Create Table |
          +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------+
          | history | CREATE TABLE `history` (
          `itemid` bigint(20) unsigned NOT NULL,
          `clock` int(11) NOT NULL DEFAULT '0',
          `value` double NOT NULL DEFAULT '0',
          `ns` int(11) NOT NULL DEFAULT '0',
          KEY `history_1` (`itemid`,`clock`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |


          what ca I do?

            Comment

            • wifi75
              Member
              • Apr 2018
              • 45
              #4
              someone help me in centos server to change default collation to utf8 and the tables to utf8_bin ?

                Comment

                • wifi75
                  Member
                  • Apr 2018
                  • 45
                  #5
                  Originally posted by isaqueprofeta

                  Review the charset of your database.
                  please can you link me step by step to renew charset database ?



                    Comment

                  • wifi75
                    Member
                    • Apr 2018
                    • 45
                    #6
                    I've never done it, and I wouldn't want to cause further damage, can you tell me the commands to give?

                      Comment

                      • isaqueprofeta
                        Senior Member
                        Zabbix Certified SpecialistZabbix Certified Professional
                        • Aug 2020
                        • 154
                        #7
                        You shouldn't be asking for commands, you need to understand what you're doing.

                        First, make your backup (I wish that you have it right before starting update)
                        Second, review the docs on upgrading: https://www.zabbix.com/documentation...lation/upgrade
                        LAST (and I said L-A-S-T), look at the docs on charset fix: https://www.zabbix.com/documentation...b_charset_coll

                          Comment

                          Previous template Next
                          Working...