Ad Widget

Collapse

Проблема при обновлении с 6.2.7 до 6.4.0

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Shans
    Junior Member
    • Nov 2013
    • 14
    #1

    Проблема при обновлении с 6.2.7 до 6.4.0

    Приветствую, товарищи.
    Может кто-то тоже столкнулся с похожей ситуацией и сможет помочь советом.
    Сервер: Freebsd 13.1-RELEASE-p6
    Mariadb -10.6.11
    База партиционированна.
    Предыдущие обновления накатывались без проблем ... 6.2.5; 6.2.6; 6.2.7
    В это раз при первом запуске сервера 6.4.0, в процессе обновления структуры базы получаю в логе следующее:
    Code:
     95287:20230308:024852.989 Starting Zabbix Server. Zabbix 6.4.0 (revision 5b2736b6027).
 95287:20230308:024852.989 ****** Enabled features ******
 95287:20230308:024852.989 SNMP monitoring:           YES
 95287:20230308:024852.989 IPMI monitoring:           YES
 95287:20230308:024852.989 Web monitoring:            YES
 95287:20230308:024852.989 VMware monitoring:          NO
 95287:20230308:024852.989 SMTP authentication:       YES
 95287:20230308:024852.989 ODBC:                       NO
 95287:20230308:024852.989 SSH support:               YES
 95287:20230308:024852.989 IPv6 support:              YES
 95287:20230308:024852.989 TLS support:                NO
 95287:20230308:024852.989 ******************************
 95287:20230308:024852.989 using configuration file: /usr/local/etc/zabbix_server.conf
 95287:20230308:024853.020 current database version (mandatory/optional): 06020000/06020014
 95287:20230308:024853.020 required mandatory version: 06040000
 95287:20230308:024853.020 starting automatic database upgrade
 95287:20230308:024853.021 completed 0% of database upgrade
 95287:20230308:024853.064 completed 1% of database upgrade
 95287:20230308:024853.157 completed 2% of database upgrade
 95287:20230308:024853.193 completed 3% of database upgrade
 95287:20230308:024853.208 completed 4% of database upgrade
 95287:20230308:024853.217 completed 5% of database upgrade
 95287:20230308:024853.220 completed 6% of database upgrade
 95287:20230308:024853.229 completed 7% of database upgrade
 95287:20230308:024853.236 completed 8% of database upgrade
 95287:20230308:024853.246 completed 9% of database upgrade
 95287:20230308:024853.254 completed 10% of database upgrade
 95287:20230308:024853.259 completed 11% of database upgrade
 95287:20230308:024853.267 completed 12% of database upgrade
 95287:20230308:024853.274 completed 13% of database upgrade
 95287:20230308:024853.285 completed 14% of database upgrade
 95287:20230308:024853.293 completed 15% of database upgrade
 95287:20230308:024853.298 completed 16% of database upgrade
 95287:20230308:024853.306 completed 17% of database upgrade
 95287:20230308:024853.313 completed 18% of database upgrade
 95287:20230308:024853.324 completed 19% of database upgrade
 95287:20230308:024853.363 completed 20% of database upgrade
 95287:20230308:024853.392 completed 21% of database upgrade
 95287:20230308:024853.402 completed 22% of database upgrade
 95287:20230308:024853.418 completed 23% of database upgrade
 95287:20230308:024853.433 completed 24% of database upgrade
 95287:20230308:024853.446 completed 25% of database upgrade
 95287:20230308:024853.461 completed 26% of database upgrade
 95287:20230308:024853.465 completed 27% of database upgrade
 95287:20230308:024853.480 completed 28% of database upgrade
 95287:20230308:024853.495 completed 29% of database upgrade
 95287:20230308:024853.510 completed 30% of database upgrade
 95287:20230308:024853.523 completed 31% of database upgrade
 95287:20230308:024853.532 completed 32% of database upgrade
 95287:20230308:024853.540 completed 33% of database upgrade
 95287:20230308:024853.553 completed 34% of database upgrade
 95287:20230308:024853.556 completed 35% of database upgrade
 95287:20230308:024853.578 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding "name_upper" column to "hosts" table
 95287:20230308:024853.580 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding index to "name_upper" column
 95287:20230308:024853.580 completed 36% of database upgrade
 95287:20230308:024853.581 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of updating "name_upper" column
 95287:20230308:024853.582 completed 37% of database upgrade
 95287:20230308:024853.583 hosts_name_upper_insert trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 95287:20230308:024853.585 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 95287:20230308:024853.585 completed 38% of database upgrade
 95287:20230308:024853.587 items_name_upper_update trigger for table "items" already exists, skipping patch of adding "name_upper" column to "items" table
 95287:20230308:024853.588 items_name_upper_update trigger for table "items" already exists, skipping patch of adding index to "name_upper" column
 95287:20230308:024853.589 completed 39% of database upgrade
 95287:20230308:024853.590 items_name_upper_update trigger for table "items" already exists, skipping patch of updating "name_upper" column
 95287:20230308:024853.592 items_name_upper_insert trigger for table "items" already exists, skipping patch of adding it to "items" table
 95287:20230308:024853.592 completed 40% of database upgrade
 95287:20230308:024853.593 items_name_upper_update trigger for table "items" already exists, skipping patch of adding it to "items" table
 95287:20230308:024853.598 completed 41% of database upgrade
 95287:20230308:024853.738 completed 42% of database upgrade
 95287:20230308:024853.742 completed 43% of database upgrade
 95287:20230308:024853.772 completed 44% of database upgrade
 95287:20230308:024853.783 completed 45% of database upgrade
 95287:20230308:024853.812 completed 46% of database upgrade
 95287:20230308:024853.823 completed 47% of database upgrade
 95287:20230308:024853.828 completed 48% of database upgrade
 95287:20230308:024853.843 completed 49% of database upgrade
 95287:20230308:024853.857 completed 50% of database upgrade
 95287:20230308:024853.868 completed 51% of database upgrade
 95287:20230308:024853.879 completed 52% of database upgrade
 95287:20230308:024853.884 completed 53% of database upgrade
 95287:20230308:024853.899 completed 54% of database upgrade
 95287:20230308:024853.913 completed 55% of database upgrade
 95287:20230308:024853.922 completed 56% of database upgrade
 95287:20230308:024853.943 completed 57% of database upgrade
 95287:20230308:024853.946 completed 58% of database upgrade
 95287:20230308:024853.956 completed 59% of database upgrade
 95287:20230308:024853.972 completed 60% of database upgrade
 95287:20230308:024853.988 completed 61% of database upgrade
 95287:20230308:024853.998 completed 62% of database upgrade
 95287:20230308:024854.008 completed 63% of database upgrade
 95287:20230308:024854.025 completed 64% of database upgrade
 95287:20230308:024854.033 completed 65% of database upgrade
 95287:20230308:024854.041 completed 66% of database upgrade
 95287:20230308:024854.052 completed 67% of database upgrade
 95287:20230308:024854.064 completed 68% of database upgrade
 95287:20230308:024854.065 completed 69% of database upgrade
 95287:20230308:024854.099 completed 70% of database upgrade
 95287:20230308:024854.113 completed 71% of database upgrade
 95287:20230308:024854.127 completed 72% of database upgrade
 95287:20230308:024854.141 completed 73% of database upgrade
 95287:20230308:024854.148 completed 74% of database upgrade
 95287:20230308:024854.161 completed 75% of database upgrade
 95287:20230308:024854.174 completed 76% of database upgrade
 95287:20230308:024854.187 completed 77% of database upgrade
 95287:20230308:024854.197 completed 78% of database upgrade
 95287:20230308:024854.202 completed 79% of database upgrade
 95287:20230308:024854.212 completed 80% of database upgrade
 95287:20230308:024854.221 completed 81% of database upgrade
 95287:20230308:024854.230 completed 82% of database upgrade
 95287:20230308:024854.237 completed 83% of database upgrade
 95287:20230308:024854.267 [Z3005] query failed: [1005] Can't create table `zabbix2`.`event_symptom` (errno: 150 "Foreign key constraint is incorrectly formed") [alter table `event_symptom` add constraint c_event_symptom_1 foreign key (`eventid`) references `events` (`eventid`) on delete cascade]
 95287:20230308:024854.267 database upgrade failed
 95287:20230308:024854.276 database could be upgraded to use primary keys in history tables​
    Он почти завершает обновление базы, но в конце затыкается на создании новой таблицы event_symptom.
    Tags: None
    • Kos
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Aug 2015
      • 3404
      #2
      Могу ошибаться, но судя по сообщению, делается попытка сослаться на primary key таблицы, в котором его нет.
      В версии 6.0 эти первичные ключи были добавлены ко всем таблицам, кроме исторических (точнее, для исторических таблиц их надо было добавлять вручную, ссылка).

        Comment

        • Shans
          #2.1
          Shans commented
          08-03-2023, 15:57
          Editing a comment
          Моё почтение, Kos.
          Вроде в логе сервер ссылается на таблицу "events", а её вручную модифицировать не надо было по приведённому вами мануалу.
          Думаю, может причина ошибки в том, что "events" у меня тоже партиционированна и серверу это не нравится.
        • Kos
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • Aug 2015
          • 3404
          #3
          Вроде в логе сервер ссылается на таблицу "events", а её вручную модифицировать не надо было по приведённому вами мануалу.
          Да, это у меня тоже вызвало сомнение. Тем не менее, в логе есть и такая запись:
          Code:
          database could be upgraded to use primary keys in history tables​
          Повторюсь, я не исключаю, что могу ошибаться: всё же, совершенно новая версия, может быть всякое...

            Comment

            • Shans
              Junior Member
              • Nov 2013
              • 14
              #4
              Как и предполагал, дело в партициях 'events'.
              В базе версии 06020000 Привёл таблицу 'events' обратно к виду .frm, .ibd. Запустил сервер 6.4.0 и вуаля:

              Code:
               12641:20230308:223002.589 Starting Zabbix Server. Zabbix 6.4.0 (revision 5b2736b6027).
 12641:20230308:223002.589 ****** Enabled features ******
 12641:20230308:223002.589 SNMP monitoring:           YES
 12641:20230308:223002.589 IPMI monitoring:           YES
 12641:20230308:223002.589 Web monitoring:            YES
 12641:20230308:223002.589 VMware monitoring:          NO
 12641:20230308:223002.589 SMTP authentication:       YES
 12641:20230308:223002.589 ODBC:                       NO
 12641:20230308:223002.589 SSH support:               YES
 12641:20230308:223002.589 IPv6 support:              YES
 12641:20230308:223002.589 TLS support:                NO
 12641:20230308:223002.589 ******************************
 12641:20230308:223002.589 using configuration file: /usr/local/etc/zabbix_server.conf
 12641:20230308:223002.616 current database version (mandatory/optional): 06020000/06020014
 12641:20230308:223002.616 required mandatory version: 06040000
 12641:20230308:223002.616 starting automatic database upgrade
 12641:20230308:223002.617 completed 0% of database upgrade
 12641:20230308:223002.634 completed 1% of database upgrade
 12641:20230308:223002.640 completed 2% of database upgrade
 12641:20230308:223002.655 completed 3% of database upgrade
 12641:20230308:223002.685 completed 4% of database upgrade
 12641:20230308:223002.693 completed 5% of database upgrade
 12641:20230308:223002.697 completed 6% of database upgrade
 12641:20230308:223002.706 completed 7% of database upgrade
 12641:20230308:223002.715 completed 8% of database upgrade
 12641:20230308:223002.726 completed 9% of database upgrade
 12641:20230308:223002.735 completed 10% of database upgrade
 12641:20230308:223002.741 completed 11% of database upgrade
 12641:20230308:223002.749 completed 12% of database upgrade
 12641:20230308:223002.758 completed 13% of database upgrade
 12641:20230308:223002.770 completed 14% of database upgrade
 12641:20230308:223002.779 completed 15% of database upgrade
 12641:20230308:223002.784 completed 16% of database upgrade
 12641:20230308:223002.793 completed 17% of database upgrade
 12641:20230308:223002.802 completed 18% of database upgrade
 12641:20230308:223002.813 completed 19% of database upgrade
 12641:20230308:223002.826 completed 20% of database upgrade
 12641:20230308:223002.847 completed 21% of database upgrade
 12641:20230308:223002.857 completed 22% of database upgrade
 12641:20230308:223002.873 completed 23% of database upgrade
 12641:20230308:223002.888 completed 24% of database upgrade
 12641:20230308:223002.902 completed 25% of database upgrade
 12641:20230308:223002.917 completed 26% of database upgrade
 12641:20230308:223002.921 completed 27% of database upgrade
 12641:20230308:223002.937 completed 28% of database upgrade
 12641:20230308:223002.953 completed 29% of database upgrade
 12641:20230308:223002.969 completed 30% of database upgrade
 12641:20230308:223002.982 completed 31% of database upgrade
 12641:20230308:223002.991 completed 32% of database upgrade
 12641:20230308:223003.000 completed 33% of database upgrade
 12641:20230308:223003.012 completed 34% of database upgrade
 12641:20230308:223003.016 completed 35% of database upgrade
 12641:20230308:223003.038 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding "name_upper" column to "hosts" table
 12641:20230308:223003.040 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding index to "name_upper" column
 12641:20230308:223003.040 completed 36% of database upgrade
 12641:20230308:223003.042 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of updating "name_upper" column
 12641:20230308:223003.042 completed 37% of database upgrade
 12641:20230308:223003.043 hosts_name_upper_insert trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 12641:20230308:223003.045 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 12641:20230308:223003.045 completed 38% of database upgrade
 12641:20230308:223003.047 items_name_upper_update trigger for table "items" already exists, skipping patch of adding "name_upper" column to "items" table
 12641:20230308:223003.048 items_name_upper_update trigger for table "items" already exists, skipping patch of adding index to "name_upper" column
 12641:20230308:223003.049 completed 39% of database upgrade
 12641:20230308:223003.050 items_name_upper_update trigger for table "items" already exists, skipping patch of updating "name_upper" column
 12641:20230308:223003.052 items_name_upper_insert trigger for table "items" already exists, skipping patch of adding it to "items" table
 12641:20230308:223003.052 completed 40% of database upgrade
 12641:20230308:223003.053 items_name_upper_update trigger for table "items" already exists, skipping patch of adding it to "items" table
 12641:20230308:223003.058 completed 41% of database upgrade
 12641:20230308:223003.131 completed 42% of database upgrade
 12641:20230308:223003.135 completed 43% of database upgrade
 12641:20230308:223003.165 completed 44% of database upgrade
 12641:20230308:223003.176 completed 45% of database upgrade
 12641:20230308:223003.205 completed 46% of database upgrade
 12641:20230308:223003.213 completed 47% of database upgrade
 12641:20230308:223003.218 completed 48% of database upgrade
 12641:20230308:223003.234 completed 49% of database upgrade
 12641:20230308:223003.247 completed 50% of database upgrade
 12641:20230308:223003.259 completed 51% of database upgrade
 12641:20230308:223003.271 completed 52% of database upgrade
 12641:20230308:223003.275 completed 53% of database upgrade
 12641:20230308:223003.291 completed 54% of database upgrade
 12641:20230308:223003.305 completed 55% of database upgrade
 12641:20230308:223003.314 completed 56% of database upgrade
 12641:20230308:223003.335 completed 57% of database upgrade
 12641:20230308:223003.338 completed 58% of database upgrade
 12641:20230308:223003.348 completed 59% of database upgrade
 12641:20230308:223003.369 completed 60% of database upgrade
 12641:20230308:223003.385 completed 61% of database upgrade
 12641:20230308:223003.395 completed 62% of database upgrade
 12641:20230308:223003.406 completed 63% of database upgrade
 12641:20230308:223003.424 completed 64% of database upgrade
 12641:20230308:223003.431 completed 65% of database upgrade
 12641:20230308:223003.440 completed 66% of database upgrade
 12641:20230308:223003.450 completed 67% of database upgrade
 12641:20230308:223003.463 completed 68% of database upgrade
 12641:20230308:223003.464 completed 69% of database upgrade
 12641:20230308:223003.480 completed 70% of database upgrade
 12641:20230308:223003.494 completed 71% of database upgrade
 12641:20230308:223003.507 completed 72% of database upgrade
 12641:20230308:223003.521 completed 73% of database upgrade
 12641:20230308:223003.527 completed 74% of database upgrade
 12641:20230308:223003.539 completed 75% of database upgrade
 12641:20230308:223003.552 completed 76% of database upgrade
 12641:20230308:223003.564 completed 77% of database upgrade
 12641:20230308:223003.574 completed 78% of database upgrade
 12641:20230308:223003.579 completed 79% of database upgrade
 12641:20230308:223003.588 completed 80% of database upgrade
 12641:20230308:223003.598 completed 81% of database upgrade
 12641:20230308:223003.607 completed 82% of database upgrade
 12641:20230308:223003.614 completed 83% of database upgrade
 12641:20230308:223003.631 completed 84% of database upgrade
 12641:20230308:223003.659 completed 85% of database upgrade
 12641:20230308:223241.431 slow query: 157.772183 sec, "alter table `problem` add constraint c_problem_3 foreign key (`cause_eventid`) references `events` (`eventid`)"
 12641:20230308:223241.436 completed 86% of database upgrade
 12641:20230308:223241.458 completed 87% of database upgrade
 12641:20230308:223255.924 slow query: 14.462034 sec, "update sessions set secret=sessionid"
 12641:20230308:223255.932 completed 88% of database upgrade
 12641:20230308:223255.944 completed 89% of database upgrade
 12641:20230308:223255.948 completed 90% of database upgrade
 12641:20230308:223255.956 completed 91% of database upgrade
 12641:20230308:223255.966 completed 92% of database upgrade
 12641:20230308:223255.974 completed 93% of database upgrade
 12641:20230308:223255.986 completed 94% of database upgrade
 12641:20230308:223255.991 completed 95% of database upgrade
 12641:20230308:223256.000 completed 96% of database upgrade
 12641:20230308:223256.160 completed 97% of database upgrade
 12641:20230308:223256.187 completed 98% of database upgrade
 12641:20230308:223256.198 completed 99% of database upgrade
 12641:20230308:223256.198 completed 100% of database upgrade
 12641:20230308:223256.304 database upgrade fully completed​

                Comment

                • kharkov_max
                  Member
                  • Mar 2016
                  • 83
                  #5
                  Мне кажется что лучше перейти на postgresql и timescaleDB и уйти от партиционирования mysql.
                  Пару дней назад обновлял 6.2.7 до 6.4.0, тоже на Freebsd13 - все работает без гвоздей.

                    Comment

                    • Hamardaban
                      #5.1
                      Hamardaban commented
                      13-03-2023, 12:00
                      Editing a comment
                      Вопрос не в топик но всёже
                      Обновлялись на FreeBSD из портов? Проблем с libevent небыло?
                      • kharkov_max
                        #5.2
                        kharkov_max commented
                        13-03-2023, 12:39
                        Editing a comment
                        Да из портов, НЕ из пакетов.
                        Все собиралось ...
                        • Hamardaban
                          #5.3
                          Hamardaban commented
                          13-03-2023, 12:49
                          Editing a comment
                          Разобрался...
                          В devel/libevent нужно включить "Threading support" - тогда собирутся libevent_pthreads*, нужные для zabbix.
                          Ранее без этого работало.
                        Previous template Next
                        Working...