[ZBX-12258] Unnecessary SQL queries while processing trigger escalations in maintenance period Created: 2017 Jun 02  Updated: 2024 Apr 10  Resolved: 2017 Aug 04

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 3.2.5
Fix Version/s: 3.2.8rc1, 3.4.0alpha2, 3.4 (plan)

Type: Problem report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: escalations, escalator, maintenance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Causes
causes ZBX-13299 Auto registration messages not sent w... Closed
causes ZBX-14908 Crashing escalator process zabbix_ser... Closed
Duplicate
Team: Team C
Sprint: Sprint 9, Sprint 10, Sprint 11, Sprint 12, Sprint 13
Story Points: 5

 Description   

Escalator process performs many SQL queries beforemaintenance mode check:

 15623:20170602:130549.296 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations where triggerid is not null order by actionid,triggerid,itemid,escalationid]
 15623:20170602:130549.306 query [txnlev:0] [select actionid,name,status,eventsource,esc_period,def_shortdata,def_longdata,r_shortdata,r_longdata,maintenance_mode from actions where actionid=100100000000005]
 15623:20170602:130549.307 query [txnlev:0] [select null from operations where actionid=100100000000005 and recovery=1]
 15623:20170602:130549.308 query [txnlev:0] [select eventid,source,object,objectid,clock,value,acknowledged,ns from events where eventid=626686]
 15623:20170602:130549.309 query [txnlev:0] [select tag,value from event_tag where eventid=626686]
 15623:20170602:130549.310 query [txnlev:0] [select description,expression,priority,comments,url,recovery_expression,recovery_mode from triggers where triggerid=2581059]
 15623:20170602:130549.311 In check_escalation() escalationid:54428 status:active
 15623:20170602:130549.311 End of check_escalation():skip error: '(null)'

It is better to use such information from DC/execute queries after performing maintenance and other DC checks or use bulk requests.



 Comments   
Comment by Sergejs Paskevics [ 2017 Jun 28 ]

Implemented in development branch svn://svn.zabbix.com/branches/dev/ZBX-12258

Comment by Andris Zeila [ 2017 Jul 05 ]

(1) Actions, events and recovery events should be stored in vectors and later simple iteration is used to find corresponding object by its id. It would be more efficient to sort those vectors (actions and events are already sorted) and use zbx_vector_ptr_bsearch() for object lookup.

Actually events and recovery events can be stored in the same vector - it's used only as database cache anyway.

s.paskevics RESOLVED in r70012.

vso CLOSED

Comment by Andris Zeila [ 2017 Jul 05 ]

(2) The escalations are processed by selecting first 1000 eligible escalations. However there is no guarantees, that the escalation will be executed, so it will be selected in the next process_ecalations call again. In worst case we could have 1k escalations that are paused in maintenance, blocking execution of the other escalations.

We should select all escalations, read into batches, process batch when it reaches the limit (1000 escalations) and continue reading escalations into new batch without exiting process_escalations (and reselecting escalations from database).

s.paskevics RESOLVED in r70012.

vso CLOSED

Comment by Vladislavs Sokurenko [ 2017 Jul 25 ]

(8)

7909:20170725:143238.156 Starting Zabbix Server. Zabbix 3.4.0alpha2 (revision {ZABBIX_REVISION}).
  7909:20170725:143238.156 ****** Enabled features ******
  7909:20170725:143238.156 SNMP monitoring:            NO
  7909:20170725:143238.156 IPMI monitoring:            NO
  7909:20170725:143238.156 Web monitoring:             NO
  7909:20170725:143238.156 VMware monitoring:          NO
  7909:20170725:143238.156 SMTP authentication:        NO
  7909:20170725:143238.156 Jabber notifications:       NO
  7909:20170725:143238.156 Ez Texting notifications:   NO
  7909:20170725:143238.156 ODBC:                       NO
  7909:20170725:143238.156 SSH2 support:               NO
  7909:20170725:143238.156 IPv6 support:               NO
  7909:20170725:143238.156 TLS support:                NO
  7909:20170725:143238.156 ******************************
  7909:20170725:143238.156 using configuration file: /etc/zabbix/zabbix_server.conf
  7909:20170725:143238.163 current database version (mandatory/optional): 03000000/03000000
  7909:20170725:143238.163 required mandatory version: 03030175
  7909:20170725:143238.163 starting automatic database upgrade
  7909:20170725:143238.194 completed 0% of database upgrade
  7909:20170725:143238.320 completed 1% of database upgrade
  7909:20170725:143238.545 completed 2% of database upgrade
  7909:20170725:143238.598 completed 3% of database upgrade
  7909:20170725:143238.658 completed 4% of database upgrade
  7909:20170725:143238.747 completed 5% of database upgrade
  7909:20170725:143238.829 completed 6% of database upgrade
  7909:20170725:143238.897 completed 7% of database upgrade
  7909:20170725:143238.988 completed 8% of database upgrade
  7909:20170725:143239.070 completed 9% of database upgrade
  7909:20170725:143239.161 completed 10% of database upgrade
  7909:20170725:143239.163 Action "Report problems to Zabbix administrators" condition "Trigger value = PROBLEM" will be removed during database upgrade: this type of condition is not supported anymore
  7909:20170725:143239.239 completed 11% of database upgrade
  7909:20170725:143239.390 completed 12% of database upgrade
  7909:20170725:143239.547 completed 13% of database upgrade
  7909:20170725:143239.623 completed 14% of database upgrade
  7909:20170725:143239.669 completed 15% of database upgrade
  7909:20170725:143239.699 completed 16% of database upgrade
  7909:20170725:143239.851 completed 17% of database upgrade
  7909:20170725:143239.945 completed 18% of database upgrade
  7909:20170725:143240.014 completed 19% of database upgrade
  7909:20170725:143240.040 completed 20% of database upgrade
  7909:20170725:143240.093 completed 21% of database upgrade
  7909:20170725:143240.121 completed 22% of database upgrade
  7909:20170725:143240.203 completed 23% of database upgrade
  7909:20170725:143240.236 completed 24% of database upgrade
  7909:20170725:143240.279 completed 25% of database upgrade
  7909:20170725:143240.321 completed 26% of database upgrade
  7909:20170725:143240.340 completed 27% of database upgrade
  7909:20170725:143240.478 completed 28% of database upgrade
  7909:20170725:143240.618 completed 29% of database upgrade
  7909:20170725:143240.726 completed 30% of database upgrade
  7909:20170725:143240.730 completed 31% of database upgrade
  7909:20170725:143240.976 completed 32% of database upgrade
  7909:20170725:143241.056 completed 33% of database upgrade
  7909:20170725:143241.093 completed 34% of database upgrade
  7909:20170725:143241.138 completed 35% of database upgrade
  7909:20170725:143241.223 completed 36% of database upgrade
  7909:20170725:143241.276 completed 37% of database upgrade
  7909:20170725:143241.352 completed 38% of database upgrade
  7909:20170725:143241.748 completed 39% of database upgrade
  7909:20170725:143241.764 completed 40% of database upgrade
  7909:20170725:143241.791 completed 41% of database upgrade
  7909:20170725:143241.992 completed 42% of database upgrade
  7909:20170725:143242.087 completed 43% of database upgrade
  7909:20170725:143242.132 completed 44% of database upgrade
  7909:20170725:143242.198 completed 45% of database upgrade
  7909:20170725:143242.220 completed 46% of database upgrade
  7909:20170725:143242.245 completed 47% of database upgrade
  7909:20170725:143242.264 completed 48% of database upgrade
  7909:20170725:143242.298 completed 49% of database upgrade
  7909:20170725:143242.487 completed 50% of database upgrade
  7909:20170725:143242.566 completed 51% of database upgrade
  7909:20170725:143242.633 completed 52% of database upgrade
  7909:20170725:143242.668 completed 53% of database upgrade
  7909:20170725:143242.708 completed 54% of database upgrade
  7909:20170725:143242.751 completed 55% of database upgrade
  7909:20170725:143242.783 completed 56% of database upgrade
  7909:20170725:143242.807 completed 57% of database upgrade
  7909:20170725:143242.880 completed 58% of database upgrade
  7909:20170725:143242.892 completed 59% of database upgrade
  7909:20170725:143242.913 completed 60% of database upgrade
  7909:20170725:143242.962 completed 61% of database upgrade
  7909:20170725:143243.039 completed 62% of database upgrade
  7909:20170725:143243.202 completed 63% of database upgrade
  7909:20170725:143243.320 completed 64% of database upgrade
  7909:20170725:143243.428 completed 65% of database upgrade
  7909:20170725:143243.527 completed 66% of database upgrade
  7909:20170725:143243.665 completed 67% of database upgrade
  7909:20170725:143243.815 completed 68% of database upgrade
  7909:20170725:143243.997 completed 69% of database upgrade
  7909:20170725:143244.079 completed 70% of database upgrade
  7909:20170725:143244.244 completed 71% of database upgrade
  7909:20170725:143244.364 completed 72% of database upgrade
  7909:20170725:143244.469 completed 73% of database upgrade
  7909:20170725:143244.555 completed 74% of database upgrade
  7909:20170725:143244.750 completed 75% of database upgrade
  7909:20170725:143244.864 completed 76% of database upgrade
  7909:20170725:143244.921 completed 77% of database upgrade
  7909:20170725:143245.037 completed 78% of database upgrade
  7909:20170725:143245.126 completed 79% of database upgrade
  7909:20170725:143245.207 completed 80% of database upgrade
  7909:20170725:143245.293 completed 81% of database upgrade
  7909:20170725:143245.465 completed 82% of database upgrade
  7909:20170725:143245.594 completed 83% of database upgrade
  7909:20170725:143245.730 completed 84% of database upgrade
  7909:20170725:143245.742 completed 85% of database upgrade
  7909:20170725:143245.759 completed 86% of database upgrade
  7909:20170725:143245.868 completed 87% of database upgrade
  7909:20170725:143246.029 completed 88% of database upgrade
  7909:20170725:143246.102 completed 89% of database upgrade
  7909:20170725:143246.141 completed 90% of database upgrade
  7909:20170725:143246.238 completed 91% of database upgrade
  7909:20170725:143246.264 completed 92% of database upgrade
  7909:20170725:143246.354 completed 93% of database upgrade
  7909:20170725:143246.397 completed 94% of database upgrade
  7909:20170725:143246.426 completed 95% of database upgrade
  7909:20170725:143246.466 completed 96% of database upgrade
  7909:20170725:143246.543 completed 97% of database upgrade
  7909:20170725:143246.777 completed 98% of database upgrade
  7909:20170725:143247.177 completed 99% of database upgrade
  7909:20170725:143247.194 completed 100% of database upgrade
  7909:20170725:143247.194 database upgrade fully completed
  7909:20170725:143247.199 server #0 started [main process]
  7915:20170725:143247.199 server #1 started [configuration syncer #1]
  7917:20170725:143247.199 server #3 started [alerter #2]
  7918:20170725:143247.200 server #4 started [alerter #3]
  7919:20170725:143247.200 server #5 started [housekeeper #1]
  7920:20170725:143247.200 server #6 started [timer #1]
  7916:20170725:143247.200 server #2 started [alerter #1]
  7922:20170725:143247.200 server #8 started [discoverer #1]
  7921:20170725:143247.200 server #7 started [http poller #1]
  7924:20170725:143247.200 server #9 started [history syncer #1]
  7929:20170725:143247.201 server #14 started [proxy poller #1]
  7930:20170725:143247.201 server #15 started [self-monitoring #1]
  7943:20170725:143247.202 server #24 started [trapper #2]
  7940:20170725:143247.202 server #21 started [poller #5]
  7941:20170725:143247.202 server #22 started [unreachable poller #1]
  7946:20170725:143247.202 server #27 started [trapper #5]
  7937:20170725:143247.202 server #18 started [poller #2]
  7942:20170725:143247.202 server #23 started [trapper #1]
  7948:20170725:143247.203 server #28 started [icmp pinger #1]
  7944:20170725:143247.203 server #25 started [trapper #3]
  7938:20170725:143247.203 server #19 started [poller #3]
  7939:20170725:143247.203 server #20 started [poller #4]
  7933:20170725:143247.203 server #17 started [poller #1]
  7931:20170725:143247.204 server #16 started [task manager #1]
  7949:20170725:143247.205 server #29 started [alert manager #1]
  7928:20170725:143247.205 server #13 started [escalator #1]
  7945:20170725:143247.205 server #26 started [trapper #4]
  7927:20170725:143247.206 server #12 started [history syncer #4]
  7926:20170725:143247.207 server #11 started [history syncer #3]
  7925:20170725:143247.207 server #10 started [history syncer #2]
  7928:20170725:143247.208 Got signal [signal:11(SIGSEGV),reason:2,refaddr:0x7f51d4000000]. Crashing ...
  7928:20170725:143247.208 ====== Fatal information: ======
  7928:20170725:143247.208 Program counter: 0x7f51d52dd0b4
  7928:20170725:143247.208 === Registers: ===
  7928:20170725:143247.208 r8      =          247171e =             38213406 =             38213406
  7928:20170725:143247.208 r9      =                0 =                    0 =                    0
  7928:20170725:143247.208 r10     =     7f51d53cfd00 =      139989446622464 =      139989446622464
  7928:20170725:143247.208 r11     =                a =                   10 =                   10
  7928:20170725:143247.208 r12     =           4d7808 =              5077000 =              5077000
  7928:20170725:143247.208 r13     =              7ea =                 2026 =                 2026
  7928:20170725:143247.208 r14     =     7ffe539033a8 =      140730300380072 =      140730300380072
  7928:20170725:143247.208 r15     =                0 =                    0 =                    0
  7928:20170725:143247.208 rdi     =     7f51d561bae0 =      139989449030368 =      139989449030368
  7928:20170725:143247.208 rsi     =     7f51d52d496d =      139989445593453 =      139989445593453
  7928:20170725:143247.208 rbp     =          247171f =             38213407 =             38213407
  7928:20170725:143247.208 rbx     =          246d270 =             38195824 =             38195824
  7928:20170725:143247.208 rdx     =     7f51d52d497d =      139989445593469 =      139989445593469
  7928:20170725:143247.208 rax     =     7f51d4000000 =      139989425848320 =      139989425848320
  7928:20170725:143247.208 rcx     =          247171f =             38213407 =             38213407
  7928:20170725:143247.208 rsp     =     7ffe53903310 =      140730300379920 =      140730300379920
  7928:20170725:143247.209 rip     =     7f51d52dd0b4 =      139989445628084 =      139989445628084
  7928:20170725:143247.209 efl     =            10206 =                66054 =                66054
  7928:20170725:143247.209 csgsfs  =   2b000000000033 =    12103423998558259 =    12103423998558259
  7928:20170725:143247.209 err     =                4 =                    4 =                    4
  7928:20170725:143247.209 trapno  =                e =                   14 =                   14
  7928:20170725:143247.209 oldmask =                0 =                    0 =                    0
  7928:20170725:143247.209 cr2     =     7f51d4000000 =      139989425848320 =      139989425848320
  7928:20170725:143247.209 === Backtrace: ===
  7928:20170725:143247.210 14: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](zbx_log_fatal_info+0x17e) [0x47637e]
  7928:20170725:143247.210 13: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations]() [0x476866]
  7928:20170725:143247.210 12: /lib64/libc.so.6(+0x366f0) [0x7f51d52866f0]
  7928:20170725:143247.210 11: /lib64/libc.so.6(cfree+0x164) [0x7f51d52dd0b4]
  7928:20170725:143247.210 10: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](zbx_strdup2+0x20) [0x484110]
  7928:20170725:143247.210 9: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](get_db_actions_info+0x1c0) [0x419dd0]
  7928:20170725:143247.210 8: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations]() [0x437ddb]
  7928:20170725:143247.210 7: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations]() [0x438b00]
  7928:20170725:143247.210 6: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](escalator_thread+0x14d) [0x438e4d]
  7928:20170725:143247.210 5: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](zbx_thread_start+0x1a) [0x480d5a]
  7928:20170725:143247.210 4: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](MAIN_ZABBIX_ENTRY+0x623) [0x41eec3]
  7928:20170725:143247.211 3: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](daemon_start+0x1b3) [0x475d53]
  7928:20170725:143247.211 2: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](main+0x42f) [0x416def]
  7928:20170725:143247.211 1: /lib64/libc.so.6(__libc_start_main+0xea) [0x7f51d52704da]
  7928:20170725:143247.211 0: ./sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.000000 sec, processing escalations](_start+0x2a) [0x41709a]
  7928:20170725:143247.211 === Memory map: ===
  7928:20170725:143247.211 00400000-00589000 r-xp 00000000 fd:00 1580453                            /var/www/html/zabbix/trunk/sbin/zabbix_server
  7928:20170725:143247.211 00788000-00789000 r--p 00188000 fd:00 1580453                            /var/www/html/zabbix/trunk/sbin/zabbix_server
  7928:20170725:143247.211 00789000-00791000 rw-p 00189000 fd:00 1580453                            /var/www/html/zabbix/trunk/sbin/zabbix_server
  7928:20170725:143247.211 00791000-00798000 rw-p 00000000 00:00 0 
  7928:20170725:143247.211 02429000-0248e000 rw-p 00000000 00:00 0                                  [heap]
  7928:20170725:143247.211 7f51d0924000-7f51d092f000 r-xp 00000000 fd:00 920403                     /usr/lib64/libnss_files-2.25.so
  7928:20170725:143247.211 7f51d092f000-7f51d0b2e000 ---p 0000b000 fd:00 920403                     /usr/lib64/libnss_files-2.25.so
  7928:20170725:143247.211 7f51d0b2e000-7f51d0b2f000 r--p 0000a000 fd:00 920403                     /usr/lib64/libnss_files-2.25.so
  7928:20170725:143247.211 7f51d0b2f000-7f51d0b30000 rw-p 0000b000 fd:00 920403                     /usr/lib64/libnss_files-2.25.so
  7928:20170725:143247.211 7f51d0b30000-7f51d0b36000 rw-p 00000000 00:00 0 
  7928:20170725:143247.211 7f51d0b36000-7f51d1336000 rw-s 00000000 00:05 25428014                   /SYSV00000000 (deleted)
  7928:20170725:143247.211 7f51d1336000-7f51d1a03000 rw-s 00000000 00:05 25329707                   /SYSV00000000 (deleted)
  7928:20170725:143247.211 7f51d1a03000-7f51d1e03000 rw-s 00000000 00:05 25296936                   /SYSV00000000 (deleted)
  7928:20170725:143247.211 7f51d1e03000-7f51d2203000 rw-s 00000000 00:05 25264156                   /SYSV00000000 (deleted)
  7928:20170725:143247.211 7f51d2203000-7f51d3203000 rw-s 00000000 00:05 25231364                   /SYSV00000000 (deleted)
  7928:20170725:143247.211 7f51d3203000-7f51d3228000 r-xp 00000000 fd:00 926107                     /usr/lib64/libselinux.so.1
  7928:20170725:143247.211 7f51d3228000-7f51d3427000 ---p 00025000 fd:00 926107                     /usr/lib64/libselinux.so.1
  7928:20170725:143247.211 7f51d3427000-7f51d3428000 r--p 00024000 fd:00 926107                     /usr/lib64/libselinux.so.1
  7928:20170725:143247.211 7f51d3428000-7f51d3429000 rw-p 00025000 fd:00 926107                     /usr/lib64/libselinux.so.1
  7928:20170725:143247.211 7f51d3429000-7f51d342b000 rw-p 00000000 00:00 0 
  7928:20170725:143247.211 7f51d342b000-7f51d342e000 r-xp 00000000 fd:00 919830                     /usr/lib64/libkeyutils.so.1.6
  7928:20170725:143247.211 7f51d342e000-7f51d362d000 ---p 00003000 fd:00 919830                     /usr/lib64/libkeyutils.so.1.6
  7928:20170725:143247.211 7f51d362d000-7f51d362e000 r--p 00002000 fd:00 919830                     /usr/lib64/libkeyutils.so.1.6
  7928:20170725:143247.211 7f51d362e000-7f51d362f000 rw-p 00000000 00:00 0 
  7928:20170725:143247.211 7f51d362f000-7f51d363c000 r-xp 00000000 fd:00 923390                     /usr/lib64/libkrb5support.so.0.1
  7928:20170725:143247.211 7f51d363c000-7f51d383c000 ---p 0000d000 fd:00 923390                     /usr/lib64/libkrb5support.so.0.1
  7928:20170725:143247.211 7f51d383c000-7f51d383d000 r--p 0000d000 fd:00 923390                     /usr/lib64/libkrb5support.so.0.1
  7928:20170725:143247.211 7f51d383d000-7f51d383e000 rw-p 0000e000 fd:00 923390                     /usr/lib64/libkrb5support.so.0.1
  7928:20170725:143247.211 7f51d383e000-7f51d3854000 r-xp 00000000 fd:00 918975                     /usr/lib64/libgcc_s-7-20170622.so.1
  7928:20170725:143247.211 7f51d3854000-7f51d3a53000 ---p 00016000 fd:00 918975                     /usr/lib64/libgcc_s-7-20170622.so.1
  7928:20170725:143247.211 7f51d3a53000-7f51d3a54000 r--p 00015000 fd:00 918975                     /usr/lib64/libgcc_s-7-20170622.so.1
  7928:20170725:143247.211 7f51d3a54000-7f51d3a55000 rw-p 00016000 fd:00 918975                     /usr/lib64/libgcc_s-7-20170622.so.1
  7928:20170725:143247.211 7f51d3a55000-7f51d3a86000 r-xp 00000000 fd:00 923382                     /usr/lib64/libk5crypto.so.3.1
  7928:20170725:143247.211 7f51d3a86000-7f51d3c85000 ---p 00031000 fd:00 923382                     /usr/lib64/libk5crypto.so.3.1
  7928:20170725:143247.211 7f51d3c85000-7f51d3c87000 r--p 00030000 fd:00 923382                     /usr/lib64/libk5crypto.so.3.1
  7928:20170725:143247.211 7f51d3c87000-7f51d3c88000 rw-p 00032000 fd:00 923382                     /usr/lib64/libk5crypto.so.3.1
  7928:20170725:143247.211 7f51d3c88000-7f51d3c8b000 r-xp 00000000 fd:00 919397                     /usr/lib64/libcom_err.so.2.1
  7928:20170725:143247.211 7f51d3c8b000-7f51d3e8a000 ---p 00003000 fd:00 919397                     /usr/lib64/libcom_err.so.2.1
  7928:20170725:143247.211 7f51d3e8a000-7f51d3e8b000 r--p 00002000 fd:00 919397                     /usr/lib64/libcom_err.so.2.1
  7928:20170725:143247.212 7f51d3e8b000-7f51d3e8c000 rw-p 00003000 fd:00 919397                     /usr/lib64/libcom_err.so.2.1
  7928:20170725:143247.212 7f51d3e8c000-7f51d3f62000 r-xp 00000000 fd:00 923388                     /usr/lib64/libkrb5.so.3.3
  7928:20170725:143247.212 7f51d3f62000-7f51d4162000 ---p 000d6000 fd:00 923388                     /usr/lib64/libkrb5.so.3.3
  7928:20170725:143247.212 7f51d4162000-7f51d4171000 r--p 000d6000 fd:00 923388                     /usr/lib64/libkrb5.so.3.3
  7928:20170725:143247.212 7f51d4171000-7f51d4173000 rw-p 000e5000 fd:00 923388                     /usr/lib64/libkrb5.so.3.3
  7928:20170725:143247.212 7f51d4173000-7f51d41bd000 r-xp 00000000 fd:00 923069                     /usr/lib64/libgssapi_krb5.so.2.2
  7928:20170725:143247.212 7f51d41bd000-7f51d43bc000 ---p 0004a000 fd:00 923069                     /usr/lib64/libgssapi_krb5.so.2.2
  7928:20170725:143247.212 7f51d43bc000-7f51d43be000 r--p 00049000 fd:00 923069                     /usr/lib64/libgssapi_krb5.so.2.2
  7928:20170725:143247.212 7f51d43be000-7f51d43bf000 rw-p 0004b000 fd:00 923069                     /usr/lib64/libgssapi_krb5.so.2.2
  7928:20170725:143247.212 7f51d43bf000-7f51d4539000 r-xp 00000000 fd:00 919395                     /usr/lib64/libstdc++.so.6.0.24
  7928:20170725:143247.212 7f51d4539000-7f51d4738000 ---p 0017a000 fd:00 919395                     /usr/lib64/libstdc++.so.6.0.24
  7928:20170725:143247.212 7f51d4738000-7f51d4742000 r--p 00179000 fd:00 919395                     /usr/lib64/libstdc++.so.6.0.24
  7928:20170725:143247.212 7f51d4742000-7f51d4744000 rw-p 00183000 fd:00 919395                     /usr/lib64/libstdc++.so.6.0.24
  7928:20170725:143247.212 7f51d4744000-7f51d4747000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d4747000-7f51d497c000 r-xp 00000000 fd:00 923402                     /usr/lib64/libcrypto.so.1.0.2k
  7928:20170725:143247.212 7f51d497c000-7f51d4b7b000 ---p 00235000 fd:00 923402                     /usr/lib64/libcrypto.so.1.0.2k
  7928:20170725:143247.212 7f51d4b7b000-7f51d4b97000 r--p 00234000 fd:00 923402                     /usr/lib64/libcrypto.so.1.0.2k
  7928:20170725:143247.212 7f51d4b97000-7f51d4ba4000 rw-p 00250000 fd:00 923402                     /usr/lib64/libcrypto.so.1.0.2k
  7928:20170725:143247.212 7f51d4ba4000-7f51d4ba8000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d4ba8000-7f51d4c10000 r-xp 00000000 fd:00 923404                     /usr/lib64/libssl.so.1.0.2k
  7928:20170725:143247.212 7f51d4c10000-7f51d4e0f000 ---p 00068000 fd:00 923404                     /usr/lib64/libssl.so.1.0.2k
  7928:20170725:143247.212 7f51d4e0f000-7f51d4e13000 r--p 00067000 fd:00 923404                     /usr/lib64/libssl.so.1.0.2k
  7928:20170725:143247.212 7f51d4e13000-7f51d4e1a000 rw-p 0006b000 fd:00 923404                     /usr/lib64/libssl.so.1.0.2k
  7928:20170725:143247.212 7f51d4e1a000-7f51d4e30000 r-xp 00000000 fd:00 919393                     /usr/lib64/libz.so.1.2.11
  7928:20170725:143247.212 7f51d4e30000-7f51d502f000 ---p 00016000 fd:00 919393                     /usr/lib64/libz.so.1.2.11
  7928:20170725:143247.212 7f51d502f000-7f51d5030000 r--p 00015000 fd:00 919393                     /usr/lib64/libz.so.1.2.11
  7928:20170725:143247.212 7f51d5030000-7f51d5031000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d5031000-7f51d504a000 r-xp 00000000 fd:00 920407                     /usr/lib64/libpthread-2.25.so
  7928:20170725:143247.212 7f51d504a000-7f51d524a000 ---p 00019000 fd:00 920407                     /usr/lib64/libpthread-2.25.so
  7928:20170725:143247.212 7f51d524a000-7f51d524b000 r--p 00019000 fd:00 920407                     /usr/lib64/libpthread-2.25.so
  7928:20170725:143247.212 7f51d524b000-7f51d524c000 rw-p 0001a000 fd:00 920407                     /usr/lib64/libpthread-2.25.so
  7928:20170725:143247.212 7f51d524c000-7f51d5250000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d5250000-7f51d5417000 r-xp 00000000 fd:00 918980                     /usr/lib64/libc-2.25.so
  7928:20170725:143247.212 7f51d5417000-7f51d5617000 ---p 001c7000 fd:00 918980                     /usr/lib64/libc-2.25.so
  7928:20170725:143247.212 7f51d5617000-7f51d561b000 r--p 001c7000 fd:00 918980                     /usr/lib64/libc-2.25.so
  7928:20170725:143247.212 7f51d561b000-7f51d561d000 rw-p 001cb000 fd:00 918980                     /usr/lib64/libc-2.25.so
  7928:20170725:143247.212 7f51d561d000-7f51d5621000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d5621000-7f51d5692000 r-xp 00000000 fd:00 919386                     /usr/lib64/libpcre.so.1.2.9
  7928:20170725:143247.212 7f51d5692000-7f51d5891000 ---p 00071000 fd:00 919386                     /usr/lib64/libpcre.so.1.2.9
  7928:20170725:143247.212 7f51d5891000-7f51d5892000 r--p 00070000 fd:00 919386                     /usr/lib64/libpcre.so.1.2.9
  7928:20170725:143247.212 7f51d5892000-7f51d5893000 rw-p 00071000 fd:00 919386                     /usr/lib64/libpcre.so.1.2.9
  7928:20170725:143247.212 7f51d5893000-7f51d5895000 r-xp 00000000 fd:00 919388                     /usr/lib64/libpcreposix.so.0.0.5
  7928:20170725:143247.212 7f51d5895000-7f51d5a94000 ---p 00002000 fd:00 919388                     /usr/lib64/libpcreposix.so.0.0.5
  7928:20170725:143247.212 7f51d5a94000-7f51d5a95000 r--p 00001000 fd:00 919388                     /usr/lib64/libpcreposix.so.0.0.5
  7928:20170725:143247.212 7f51d5a95000-7f51d5a96000 rw-p 00000000 00:00 0 
  7928:20170725:143247.212 7f51d5a96000-7f51d5aac000 r-xp 00000000 fd:00 920413                     /usr/lib64/libresolv-2.25.so
  7928:20170725:143247.212 7f51d5aac000-7f51d5cab000 ---p 00016000 fd:00 920413                     /usr/lib64/libresolv-2.25.so
  7928:20170725:143247.212 7f51d5cab000-7f51d5cac000 r--p 00015000 fd:00 920413                     /usr/lib64/libresolv-2.25.so
  7928:20170725:143247.213 7f51d5cac000-7f51d5cad000 rw-p 00016000 fd:00 920413                     /usr/lib64/libresolv-2.25.so
  7928:20170725:143247.213 7f51d5cad000-7f51d5caf000 rw-p 00000000 00:00 0 
  7928:20170725:143247.213 7f51d5caf000-7f51d5cb2000 r-xp 00000000 fd:00 918984                     /usr/lib64/libdl-2.25.so
  7928:20170725:143247.213 7f51d5cb2000-7f51d5eb1000 ---p 00003000 fd:00 918984                     /usr/lib64/libdl-2.25.so
  7928:20170725:143247.213 7f51d5eb1000-7f51d5eb2000 r--p 00002000 fd:00 918984                     /usr/lib64/libdl-2.25.so
  7928:20170725:143247.213 7f51d5eb2000-7f51d5eb3000 rw-p 00003000 fd:00 918984                     /usr/lib64/libdl-2.25.so
  7928:20170725:143247.213 7f51d5eb3000-7f51d5fc8000 r-xp 00000000 fd:00 919544                     /usr/lib64/libm-2.25.so
  7928:20170725:143247.213 7f51d5fc8000-7f51d61c7000 ---p 00115000 fd:00 919544                     /usr/lib64/libm-2.25.so
  7928:20170725:143247.213 7f51d61c7000-7f51d61c8000 r--p 00114000 fd:00 919544                     /usr/lib64/libm-2.25.so
  7928:20170725:143247.213 7f51d61c8000-7f51d61c9000 rw-p 00115000 fd:00 919544                     /usr/lib64/libm-2.25.so
  7928:20170725:143247.213 7f51d61c9000-7f51d6210000 r-xp 00000000 fd:00 926584                     /usr/lib64/libevent-2.0.so.5.1.9
  7928:20170725:143247.213 7f51d6210000-7f51d640f000 ---p 00047000 fd:00 926584                     /usr/lib64/libevent-2.0.so.5.1.9
  7928:20170725:143247.213 7f51d640f000-7f51d6411000 r--p 00046000 fd:00 926584                     /usr/lib64/libevent-2.0.so.5.1.9
  7928:20170725:143247.213 7f51d6411000-7f51d6412000 rw-p 00048000 fd:00 926584                     /usr/lib64/libevent-2.0.so.5.1.9
  7928:20170725:143247.213 7f51d6412000-7f51d6736000 r-xp 00000000 fd:00 1063730                    /usr/lib64/mysql/libmysqlclient.so.18.0.0
  7928:20170725:143247.213 7f51d6736000-7f51d6936000 ---p 00324000 fd:00 1063730                    /usr/lib64/mysql/libmysqlclient.so.18.0.0
  7928:20170725:143247.213 7f51d6936000-7f51d693e000 r--p 00324000 fd:00 1063730                    /usr/lib64/mysql/libmysqlclient.so.18.0.0
  7928:20170725:143247.213 7f51d693e000-7f51d69b1000 rw-p 0032c000 fd:00 1063730                    /usr/lib64/mysql/libmysqlclient.so.18.0.0
  7928:20170725:143247.213 7f51d69b1000-7f51d69bb000 rw-p 00000000 00:00 0 
  7928:20170725:143247.213 7f51d69bb000-7f51d69e2000 r-xp 00000000 fd:00 918973                     /usr/lib64/ld-2.25.so
  7928:20170725:143247.213 7f51d6a87000-7f51d6bbb000 rw-s 00000000 00:05 25362476                   /SYSV00000000 (deleted)
  7928:20170725:143247.213 7f51d6bbb000-7f51d6bc6000 rw-p 00000000 00:00 0 
  7928:20170725:143247.213 7f51d6bdc000-7f51d6bdf000 rw-s 00000000 00:05 25395245                   /SYSV00000000 (deleted)
  7928:20170725:143247.213 7f51d6bdf000-7f51d6be1000 rw-p 00000000 00:00 0 
  7928:20170725:143247.213 7f51d6be1000-7f51d6be2000 r--p 00026000 fd:00 918973                     /usr/lib64/ld-2.25.so
  7928:20170725:143247.213 7f51d6be2000-7f51d6be4000 rw-p 00027000 fd:00 918973                     /usr/lib64/ld-2.25.so
  7928:20170725:143247.213 7ffe538e6000-7ffe53907000 rw-p 00000000 00:00 0                          [stack]
  7928:20170725:143247.213 7ffe53984000-7ffe53986000 r--p 00000000 00:00 0                          [vvar]
  7928:20170725:143247.213 7ffe53986000-7ffe53988000 r-xp 00000000 00:00 0                          [vdso]
  7928:20170725:143247.213 ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
  7928:20170725:143247.213 ================================
  7928:20170725:143247.213 Please consider attaching a disassembly listing to your bug report.
  7928:20170725:143247.213 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
  7928:20170725:143247.213 ================================
  7909:20170725:143247.217 One child process died (PID:7928,exitcode/signal:1). Exiting ...
  7909:20170725:143249.218 syncing history data...
  7909:20170725:143249.218 syncing history data done
  7909:20170725:143249.218 syncing trend data...
  7909:20170725:143249.218 syncing trend data done
  7909:20170725:143249.218 Zabbix Server stopped. Zabbix 3.4.0alpha2 (revision {ZABBIX_REVISION}).
[vso@localhost trunk]$ 

s.paskevics RESOLVED in r70552 (trunk).

vso CLOSED

Comment by Sergejs Paskevics [ 2017 Jul 25 ]

Implemented in:

  • 3.2.8rc1 r70487, r70492
  • 3.4.0alpha2 (trunk) r70490, r70496, r70552
Generated at Fri Jun 13 07:07:42 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.