Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-21664

Sigserv on database upgrade from 5.0 to 6.0

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 6.0.9rc1, 6.2.3rc1, 6.4.0alpha1
    • Server (S)
    • None
    • RHEL 8.5
      MySQL 8.0.30
      Zabbix LTS 5.0 -> 6.0
    • Sprint 92 (Sep 2022)
    • 0.25

      Steps to reproduce:

      1. start upgrade using official packages

      Result:

       72752:20220916:095647.197 query [txnlev:0] [show tables like 'dbversion']
       72752:20220916:095647.200 query [txnlev:0] [select mandatory,optional from dbversion]
       72752:20220916:095647.200 current database version (mandatory/optional): 05050127/05050127
       72752:20220916:095647.200 required mandatory version: 06000000
       72752:20220916:095647.201 optional patches were found
       72752:20220916:095647.201 starting automatic database upgrade
       72752:20220916:095647.201 query [txnlev:1] [begin;]
       72752:20220916:095647.201 query [txnlev:1] [select s.serviceid,s.showsla,s.goodsla,t.type,t.ts_from,t.ts_to,t.note from services s left join services_times t on s.serviceid=t.serviceid order by s.serviceid]
      
        2609:20220916:103343.707 === Backtrace: ===
        2609:20220916:103343.709 12: /usr/sbin/zabbix_server(zbx_backtrace+0x3f) [0x55b0ea4bc8c0]
        2609:20220916:103343.709 11: /usr/sbin/zabbix_server(zbx_log_fatal_info+0x141) [0x55b0ea4bcb1d]
        2609:20220916:103343.709 10: /usr/sbin/zabbix_server(+0x24c309) [0x55b0ea4bd309]
        2609:20220916:103343.709 9: /lib64/libpthread.so.0(+0x12c20) [0x7fa0ba37fc20]
        2609:20220916:103343.709 8: /usr/sbin/zabbix_server(+0x2e732f) [0x55b0ea55832f]
        2609:20220916:103343.709 7: /usr/sbin/zabbix_server(+0x2e7776) [0x55b0ea558776]
        2609:20220916:103343.709 6: /usr/sbin/zabbix_server(DBcheck_version+0x495) [0x55b0ea5185d9]
        2609:20220916:103343.709 5: /usr/sbin/zabbix_server(+0x66243) [0x55b0ea2d7243]
        2609:20220916:103343.709 4: /usr/sbin/zabbix_server(MAIN_ZABBIX_ENTRY+0x53a) [0x55b0ea2d883c]
        2609:20220916:103343.709 3: /usr/sbin/zabbix_server(daemon_start+0x384) [0x55b0ea4bc4df]
        2609:20220916:103343.709 2: /usr/sbin/zabbix_server(main+0x33a) [0x55b0ea2d71ce]
        2609:20220916:103343.709 1: /lib64/libc.so.6(__libc_start_main+0xf3) [0x7fa0b84e7493]
        2609:20220916:103343.709 0: /usr/sbin/zabbix_server(_start+0x2e) [0x55b0ea2d5f1e]
      


      Expected:
      Upgrade must go on.

        1. zabbix2-1.PNG
          zabbix2-1.PNG
          25 kB
        2. image-2-3.png
          image-2-3.png
          32 kB
        3. DBpatch_5050128-fix.patch
          0.5 kB

            vso Vladislavs Sokurenko
            edgar.akhmetshin Edgar Akhmetshin
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: