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

Zabbix Server crash (mysql->pgsql)

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 3.0.3
    • Server (S)
    • None
    • Linux server 4.4.6-gentoo-domU #1 SMP Thu May 12 20:52:17 MSK 2016 x86_64 Intel(R) Xeon(R) CPU E31230 @ 3.20GHz GenuineIntel GNU/Linux
      8Gb RAM
      Mysql 5.6.28
      Postgresql 9.5.2

      After convert database with https://github.com/AnatolyUss/FromMySqlToPostgreSql.git i have zabbix_server crash

       29887:20160603:030908.577 Starting Zabbix Server. Zabbix 3.0.3 (revision 60173).
       29887:20160603:030908.577 ****** Enabled features ******
       29887:20160603:030908.577 SNMP monitoring:            NO
       29887:20160603:030908.578 IPMI monitoring:            NO
       29887:20160603:030908.578 Web monitoring:            YES
       29887:20160603:030908.578 VMware monitoring:         YES
       29887:20160603:030908.578 SMTP authentication:       YES
       29887:20160603:030908.578 Jabber notifications:      YES
       29887:20160603:030908.578 Ez Texting notifications:  YES
       29887:20160603:030908.578 ODBC:                       NO
       29887:20160603:030908.578 SSH2 support:               NO
       29887:20160603:030908.578 IPv6 support:              YES
       29887:20160603:030908.578 TLS support:               YES
       29887:20160603:030908.578 ******************************
       29887:20160603:030908.578 using configuration file: /etc/zabbix/zabbix_server.conf
       29887:20160603:030908.642 current database version (mandatory/optional): 03000000/03000000
       29887:20160603:030908.642 required mandatory version: 03000000
       29887:20160603:030908.678 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
       29887:20160603:030908.678 ====== Fatal information: ======
       29887:20160603:030908.678 Program counter: 0x7f94bf3f056a
       29887:20160603:030908.678 === Registers: ===
       29887:20160603:030908.678 r8      =             fef5 =                65269 =                65269
       29887:20160603:030908.678 r9      =                0 =                    0 =                    0
       29887:20160603:030908.678 r10     =       68cbc2ec00 =         450095148032 =         450095148032
       29887:20160603:030908.679 r11     =           7aa50c =              8037644 =              8037644
       29887:20160603:030908.679 r12     =     7f94c0fb9168 =      140276869599592 =      140276869599592
       29887:20160603:030908.679 r13     =                1 =                    1 =                    1
       29887:20160603:030908.679 r14     = fffffffffffffffc = 18446744073709551612 =                   -4
       29887:20160603:030908.679 r15     =           7a8850 =              8030288 =              8030288
       29887:20160603:030908.679 rdi     =                0 =                    0 =                    0
       29887:20160603:030908.679 rsi     = fffffffffffffffc = 18446744073709551612 =                   -4
       29887:20160603:030908.679 rbp     =                0 =                    0 =                    0
       29887:20160603:030908.679 rbx     =                0 =                    0 =                    0
       29887:20160603:030908.679 rdx     =                0 =                    0 =                    0
       29887:20160603:030908.679 rax     =                0 =                    0 =                    0
       29887:20160603:030908.679 rcx     =                0 =                    0 =                    0
       29887:20160603:030908.679 rsp     =     7ffd882bace8 =      140726888017128 =      140726888017128
       29887:20160603:030908.679 rip     =     7f94bf3f056a =      140276840465770 =      140276840465770
       29887:20160603:030908.679 efl     =            10293 =                66195 =                66195
       29887:20160603:030908.679 csgsfs  =             e033 =                57395 =                57395
       29887:20160603:030908.679 err     =                4 =                    4 =                    4
       29887:20160603:030908.680 trapno  =                e =                   14 =                   14
       29887:20160603:030908.680 oldmask =                0 =                    0 =                    0
       29887:20160603:030908.680 cr2     =                0 =                    0 =                    0
       29887:20160603:030908.680 === Backtrace: ===
       29887:20160603:030908.681 14: /usr/sbin/zabbix_server(print_fatal_info+0xae) [0x47335e]
       29887:20160603:030908.681 13: /usr/sbin/zabbix_server() [0x473622]
       29887:20160603:030908.681 12: /lib64/libc.so.6(+0x33340) [0x7f94bf3a2340]
       29887:20160603:030908.681 11: /lib64/libc.so.6(strlen+0x2a) [0x7f94bf3f056a]
       29887:20160603:030908.681 10: /usr/sbin/zabbix_server(zbx_default_string_hash_func+0x9) [0x46af19]
       29887:20160603:030908.681 9: /usr/sbin/zabbix_server(zbx_hashset_search+0x1d) [0x46cefd]
       29887:20160603:030908.681 8: /usr/sbin/zabbix_server(zbx_strpool_intern+0x1c) [0x46a1fc]
       29887:20160603:030908.681 7: /usr/sbin/zabbix_server() [0x455fe7]
       29887:20160603:030908.681 6: /usr/sbin/zabbix_server() [0x458a7b]
       29887:20160603:030908.681 5: /usr/sbin/zabbix_server(DCsync_configuration+0x3e1) [0x45cd31]
       29887:20160603:030908.681 4: /usr/sbin/zabbix_server(MAIN_ZABBIX_ENTRY+0x241) [0x41a271]
       29887:20160603:030908.681 3: /usr/sbin/zabbix_server(daemon_start+0x1c3) [0x472bf3]
       29887:20160603:030908.681 2: /usr/sbin/zabbix_server(main+0x2f3) [0x415533]
       29887:20160603:030908.681 1: /lib64/libc.so.6(__libc_start_main+0xf0) [0x7f94bf38f620]
       29887:20160603:030908.682 0: /usr/sbin/zabbix_server(_start+0x29) [0x415809]
       29887:20160603:030908.682 === Memory map: ===
       29887:20160603:030908.682 00400000-00562000 r-xp 00000000 ca:01 24515328                           /usr/sbin/zabbix_server
       29887:20160603:030908.682 00761000-00762000 r--p 00161000 ca:01 24515328                           /usr/sbin/zabbix_server
       29887:20160603:030908.682 00762000-00769000 rw-p 00162000 ca:01 24515328                           /usr/sbin/zabbix_server
       29887:20160603:030908.682 00769000-00790000 rw-p 00000000 00:00 0                                  [heap]
       29887:20160603:030908.682 00790000-008a5000 rw-p 00000000 00:00 0                                  [heap]
       29887:20160603:030908.682 7f94bb42f000-7f94bb445000 r-xp 00000000 ca:01 23210443                   /usr/lib64/gcc/x86_64-pc-linux-gnu/4.9.3/libgcc_s.so.1
       29887:20160603:030908.682 7f94bb445000-7f94bb644000 ---p 00016000 ca:01 23210443                   /usr/lib64/gcc/x86_64-pc-linux-gnu/4.9.3/libgcc_s.so.1
       29887:20160603:030908.682 7f94bb644000-7f94bb645000 r--p 00015000 ca:01 23210443                   /usr/lib64/gcc/x86_64-pc-linux-gnu/4.9.3/libgcc_s.so.1
       29887:20160603:030908.682 7f94bb645000-7f94bb646000 rw-p 00016000 ca:01 23210443                   /usr/lib64/gcc/x86_64-pc-linux-gnu/4.9.3/libgcc_s.so.1
       29887:20160603:030908.682 7f94bb646000-7f94bb650000 r-xp 00000000 ca:01 23344546                   /lib64/libnss_files-2.22.so
       29887:20160603:030908.682 7f94bb650000-7f94bb84f000 ---p 0000a000 ca:01 23344546                   /lib64/libnss_files-2.22.so
       29887:20160603:030908.682 7f94bb84f000-7f94bb850000 r--p 00009000 ca:01 23344546                   /lib64/libnss_files-2.22.so
       29887:20160603:030908.682 7f94bb850000-7f94bb851000 rw-p 0000a000 ca:01 23344546                   /lib64/libnss_files-2.22.so
       29887:20160603:030908.683 7f94bb851000-7f94bb85b000 r-xp 00000000 ca:01 23344560                   /lib64/libnss_nis-2.22.so
       29887:20160603:030908.683 7f94bb85b000-7f94bba5a000 ---p 0000a000 ca:01 23344560                   /lib64/libnss_nis-2.22.so
       29887:20160603:030908.683 7f94bba5a000-7f94bba5b000 r--p 00009000 ca:01 23344560                   /lib64/libnss_nis-2.22.so
       29887:20160603:030908.683 7f94bba5b000-7f94bba5c000 rw-p 0000a000 ca:01 23344560                   /lib64/libnss_nis-2.22.so
       29887:20160603:030908.683 7f94bba5c000-7f94bba70000 r-xp 00000000 ca:01 23344559                   /lib64/libnsl-2.22.so
       29887:20160603:030908.683 7f94bba70000-7f94bbc70000 ---p 00014000 ca:01 23344559                   /lib64/libnsl-2.22.so
       29887:20160603:030908.683 7f94bbc70000-7f94bbc71000 r--p 00014000 ca:01 23344559                   /lib64/libnsl-2.22.so
       29887:20160603:030908.683 7f94bbc71000-7f94bbc72000 rw-p 00015000 ca:01 23344559                   /lib64/libnsl-2.22.so
       29887:20160603:030908.683 7f94bbc72000-7f94bbc74000 rw-p 00000000 00:00 0 
       29887:20160603:030908.683 7f94bbc74000-7f94bbc7b000 r-xp 00000000 ca:01 23344827                   /lib64/libnss_compat-2.22.so
       29887:20160603:030908.683 7f94bbc7b000-7f94bbe7a000 ---p 00007000 ca:01 23344827                   /lib64/libnss_compat-2.22.so
       29887:20160603:030908.683 7f94bbe7a000-7f94bbe7b000 r--p 00006000 ca:01 23344827                   /lib64/libnss_compat-2.22.so
       29887:20160603:030908.683 7f94bbe7b000-7f94bbe7c000 rw-p 00007000 ca:01 23344827                   /lib64/libnss_compat-2.22.so
       29887:20160603:030908.683 7f94bbe7c000-7f94bc67c000 rw-s 00000000 00:05 2621461                    /SYSV760108b3 (deleted)
       29887:20160603:030908.683 7f94bc67c000-7f94bcd49000 rw-s 00000000 00:05 2523154                    /SYSV670108b3 (deleted)
       29887:20160603:030908.683 7f94bcd49000-7f94bd149000 rw-s 00000000 00:05 2490385                    /SYSV740108b3 (deleted)
       29887:20160603:030908.684 7f94bd149000-7f94bd549000 rw-s 00000000 00:05 2457616                    /SYSV480108b3 (deleted)
       29887:20160603:030908.684 7f94bd549000-7f94be549000 rw-s 00000000 00:05 2424847                    /SYSV680108b3 (deleted)
       29887:20160603:030908.684 7f94be549000-7f94be5c0000 r-xp 00000000 ca:01 23203809                   /usr/lib64/libgmp.so.10.2.0
       29887:20160603:030908.684 7f94be5c0000-7f94be7c0000 ---p 00077000 ca:01 23203809                   /usr/lib64/libgmp.so.10.2.0
       29887:20160603:030908.684 7f94be7c0000-7f94be7c1000 r--p 00077000 ca:01 23203809                   /usr/lib64/libgmp.so.10.2.0
       29887:20160603:030908.684 7f94be7c1000-7f94be7c2000 rw-p 00078000 ca:01 23203809                   /usr/lib64/libgmp.so.10.2.0
       29887:20160603:030908.684 7f94be7c2000-7f94be7f6000 r-xp 00000000 ca:01 23208873                   /usr/lib64/libhogweed.so.4.2
       29887:20160603:030908.684 7f94be7f6000-7f94be9f5000 ---p 00034000 ca:01 23208873                   /usr/lib64/libhogweed.so.4.2
       29887:20160603:030908.684 7f94be9f5000-7f94be9f6000 r--p 00033000 ca:01 23208873                   /usr/lib64/libhogweed.so.4.2
       29887:20160603:030908.684 7f94be9f6000-7f94be9f7000 rw-p 00034000 ca:01 23208873                   /usr/lib64/libhogweed.so.4.2
       29887:20160603:030908.684 7f94be9f7000-7f94bea2d000 r-xp 00000000 ca:01 23209020                   /usr/lib64/libnettle.so.6.2
       29887:20160603:030908.684 7f94bea2d000-7f94bec2d000 ---p 00036000 ca:01 23209020                   /usr/lib64/libnettle.so.6.2
       29887:20160603:030908.684 7f94bec2d000-7f94bec2f000 r--p 00036000 ca:01 23209020                   /usr/lib64/libnettle.so.6.2
       29887:20160603:030908.684 7f94bec2f000-7f94bec30000 rw-p 00038000 ca:01 23209020                   /usr/lib64/libnettle.so.6.2
       29887:20160603:030908.684 7f94bec30000-7f94bec41000 r-xp 00000000 ca:01 23205649                   /usr/lib64/libtasn1.so.6.4.2
       29887:20160603:030908.684 7f94bec41000-7f94bee41000 ---p 00011000 ca:01 23205649                   /usr/lib64/libtasn1.so.6.4.2
       29887:20160603:030908.685 7f94bee41000-7f94bee42000 r--p 00011000 ca:01 23205649                   /usr/lib64/libtasn1.so.6.4.2
       29887:20160603:030908.685 7f94bee42000-7f94bee43000 rw-p 00012000 ca:01 23205649                   /usr/lib64/libtasn1.so.6.4.2
       29887:20160603:030908.685 7f94bee43000-7f94bee58000 r-xp 00000000 ca:01 23201995                   /lib64/libz.so.1.2.8
       29887:20160603:030908.685 7f94bee58000-7f94bf057000 ---p 00015000 ca:01 23201995                   /lib64/libz.so.1.2.8
       29887:20160603:030908.685 7f94bf057000-7f94bf058000 r--p 00014000 ca:01 23201995                   /lib64/libz.so.1.2.8
       29887:20160603:030908.685 7f94bf058000-7f94bf059000 rw-p 00015000 ca:01 23201995                   /lib64/libz.so.1.2.8
       29887:20160603:030908.685 7f94bf059000-7f94bf163000 r-xp 00000000 ca:01 23226693                   /usr/lib64/libgnutls.so.28.41.9
       29887:20160603:030908.685 7f94bf163000-7f94bf362000 ---p 0010a000 ca:01 23226693                   /usr/lib64/libgnutls.so.28.41.9
       29887:20160603:030908.685 7f94bf362000-7f94bf36c000 r--p 00109000 ca:01 23226693                   /usr/lib64/libgnutls.so.28.41.9
       29887:20160603:030908.685 7f94bf36c000-7f94bf36e000 rw-p 00113000 ca:01 23226693                   /usr/lib64/libgnutls.so.28.41.9
       29887:20160603:030908.685 7f94bf36e000-7f94bf36f000 rw-p 00000000 00:00 0 
       29887:20160603:030908.685 7f94bf36f000-7f94bf502000 r-xp 00000000 ca:01 23344643                   /lib64/libc-2.22.so
       29887:20160603:030908.685 7f94bf502000-7f94bf702000 ---p 00193000 ca:01 23344643                   /lib64/libc-2.22.so
       29887:20160603:030908.685 7f94bf702000-7f94bf706000 r--p 00193000 ca:01 23344643                   /lib64/libc-2.22.so
       29887:20160603:030908.685 7f94bf706000-7f94bf708000 rw-p 00197000 ca:01 23344643                   /lib64/libc-2.22.so
       29887:20160603:030908.685 7f94bf708000-7f94bf70c000 rw-p 00000000 00:00 0 
       29887:20160603:030908.686 7f94bf70c000-7f94bf71f000 r-xp 00000000 ca:01 23344541                   /lib64/libresolv-2.22.so
       29887:20160603:030908.686 7f94bf71f000-7f94bf91f000 ---p 00013000 ca:01 23344541                   /lib64/libresolv-2.22.so
       29887:20160603:030908.686 7f94bf91f000-7f94bf920000 r--p 00013000 ca:01 23344541                   /lib64/libresolv-2.22.so
       29887:20160603:030908.686 7f94bf920000-7f94bf921000 rw-p 00014000 ca:01 23344541                   /lib64/libresolv-2.22.so
       29887:20160603:030908.686 7f94bf921000-7f94bf923000 rw-p 00000000 00:00 0 
       29887:20160603:030908.686 7f94bf923000-7f94bf925000 r-xp 00000000 ca:01 23344851                   /lib64/libdl-2.22.so
       29887:20160603:030908.686 7f94bf925000-7f94bfb25000 ---p 00002000 ca:01 23344851                   /lib64/libdl-2.22.so
       29887:20160603:030908.686 7f94bfb25000-7f94bfb26000 r--p 00002000 ca:01 23344851                   /lib64/libdl-2.22.so
       29887:20160603:030908.686 7f94bfb26000-7f94bfb27000 rw-p 00003000 ca:01 23344851                   /lib64/libdl-2.22.so
       29887:20160603:030908.686 7f94bfb27000-7f94bfc24000 r-xp 00000000 ca:01 23344529                   /lib64/libm-2.22.so
       29887:20160603:030908.686 7f94bfc24000-7f94bfe23000 ---p 000fd000 ca:01 23344529                   /lib64/libm-2.22.so
       29887:20160603:030908.686 7f94bfe23000-7f94bfe24000 r--p 000fc000 ca:01 23344529                   /lib64/libm-2.22.so
       29887:20160603:030908.686 7f94bfe24000-7f94bfe25000 rw-p 000fd000 ca:01 23344529                   /lib64/libm-2.22.so
       29887:20160603:030908.686 7f94bfe25000-7f94bfe85000 r-xp 00000000 ca:01 23211105                   /usr/lib64/libcurl.so.4.4.0
       29887:20160603:030908.686 7f94bfe85000-7f94c0084000 ---p 00060000 ca:01 23211105                   /usr/lib64/libcurl.so.4.4.0
       29887:20160603:030908.686 7f94c0084000-7f94c0086000 r--p 0005f000 ca:01 23211105                   /usr/lib64/libcurl.so.4.4.0
       29887:20160603:030908.687 7f94c0086000-7f94c0087000 rw-p 00061000 ca:01 23211105                   /usr/lib64/libcurl.so.4.4.0
       29887:20160603:030908.687 7f94c0087000-7f94c029c000 r-xp 00000000 ca:01 23208422                   /usr/lib64/libcrypto.so.1.0.0
       29887:20160603:030908.687 7f94c029c000-7f94c049c000 ---p 00215000 ca:01 23208422                   /usr/lib64/libcrypto.so.1.0.0
       29887:20160603:030908.687 7f94c049c000-7f94c04ba000 r--p 00215000 ca:01 23208422                   /usr/lib64/libcrypto.so.1.0.0
       29887:20160603:030908.687 7f94c04ba000-7f94c04c6000 rw-p 00233000 ca:01 23208422                   /usr/lib64/libcrypto.so.1.0.0
       29887:20160603:030908.687 7f94c04c6000-7f94c04ca000 rw-p 00000000 00:00 0 
       29887:20160603:030908.687 7f94c04ca000-7f94c0536000 r-xp 00000000 ca:01 23208424                   /usr/lib64/libssl.so.1.0.0
       29887:20160603:030908.687 7f94c0536000-7f94c0735000 ---p 0006c000 ca:01 23208424                   /usr/lib64/libssl.so.1.0.0
       29887:20160603:030908.687 7f94c0735000-7f94c073a000 r--p 0006b000 ca:01 23208424                   /usr/lib64/libssl.so.1.0.0
       29887:20160603:030908.687 7f94c073a000-7f94c0741000 rw-p 00070000 ca:01 23208424                   /usr/lib64/libssl.so.1.0.0
       29887:20160603:030908.687 7f94c0741000-7f94c089b000 r-xp 00000000 ca:01 23216802                   /usr/lib64/libxml2.so.2.9.3
       29887:20160603:030908.687 7f94c089b000-7f94c0a9b000 ---p 0015a000 ca:01 23216802                   /usr/lib64/libxml2.so.2.9.3
       29887:20160603:030908.687 7f94c0a9b000-7f94c0aa3000 r--p 0015a000 ca:01 23216802                   /usr/lib64/libxml2.so.2.9.3
       29887:20160603:030908.687 7f94c0aa3000-7f94c0aa5000 rw-p 00162000 ca:01 23216802                   /usr/lib64/libxml2.so.2.9.3
       29887:20160603:030908.687 7f94c0aa5000-7f94c0aa7000 rw-p 00000000 00:00 0 
       29887:20160603:030908.687 7f94c0aa7000-7f94c0ab4000 r-xp 00000000 ca:01 23205474                   /usr/lib64/libiksemel.so.3.1.1
       29887:20160603:030908.687 7f94c0ab4000-7f94c0cb3000 ---p 0000d000 ca:01 23205474                   /usr/lib64/libiksemel.so.3.1.1
       29887:20160603:030908.688 7f94c0cb3000-7f94c0cb4000 r--p 0000c000 ca:01 23205474                   /usr/lib64/libiksemel.so.3.1.1
       29887:20160603:030908.688 7f94c0cb4000-7f94c0cb5000 rw-p 0000d000 ca:01 23205474                   /usr/lib64/libiksemel.so.3.1.1
       29887:20160603:030908.688 7f94c0cb5000-7f94c0ce0000 r-xp 00000000 ca:01 23215498                   /usr/lib64/postgresql-9.5/lib64/libpq.so.5.8
       29887:20160603:030908.688 7f94c0ce0000-7f94c0edf000 ---p 0002b000 ca:01 23215498                   /usr/lib64/postgresql-9.5/lib64/libpq.so.5.8
       29887:20160603:030908.688 7f94c0edf000-7f94c0ee2000 r--p 0002a000 ca:01 23215498                   /usr/lib64/postgresql-9.5/lib64/libpq.so.5.8
       29887:20160603:030908.688 7f94c0ee2000-7f94c0ee3000 rw-p 0002d000 ca:01 23215498                   /usr/lib64/postgresql-9.5/lib64/libpq.so.5.8
       29887:20160603:030908.688 7f94c0ee3000-7f94c0f05000 r-xp 00000000 ca:01 23344072                   /lib64/ld-2.22.so
       29887:20160603:030908.688 7f94c0fb9000-7f94c10ed000 rw-s 00000000 00:05 2555923                    /SYSV730108b3 (deleted)
       29887:20160603:030908.688 7f94c10ed000-7f94c10f6000 rw-p 00000000 00:00 0 
       29887:20160603:030908.688 7f94c10fe000-7f94c10ff000 rw-p 00000000 00:00 0 
       29887:20160603:030908.688 7f94c10ff000-7f94c1102000 rw-s 00000000 00:05 2588692                    /SYSV530108b3 (deleted)
       29887:20160603:030908.688 7f94c1102000-7f94c1103000 rw-p 00000000 00:00 0 
       29887:20160603:030908.688 7f94c1103000-7f94c1104000 rw-p 00000000 00:00 0 
       29887:20160603:030908.688 7f94c1104000-7f94c1105000 r--p 00021000 ca:01 23344072                   /lib64/ld-2.22.so
       29887:20160603:030908.688 7f94c1105000-7f94c1106000 rw-p 00022000 ca:01 23344072                   /lib64/ld-2.22.so
       29887:20160603:030908.688 7f94c1106000-7f94c1107000 rw-p 00000000 00:00 0 
       29887:20160603:030908.689 7ffd8829c000-7ffd882bd000 rw-p 00000000 00:00 0                          [stack]
       29887:20160603:030908.689 7ffd88325000-7ffd88327000 r--p 00000000 00:00 0                          [vvar]
       29887:20160603:030908.689 7ffd88327000-7ffd88329000 r-xp 00000000 00:00 0                          [vdso]
       29887:20160603:030908.689 ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
       29887:20160603:030908.689 ================================
       29887:20160603:030908.689 Please consider attaching a disassembly listing to your bug report.
       29887:20160603:030908.689 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
       29887:20160603:030908.689 ================================
      

      objdump attached

      Please help.

            Unassigned Unassigned
            lek Alexey Kireev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: