XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 6.0.18
    • Server (S)
    • None
    • Ubuntu 20.04

      Steps to reproduce:
      We are facing the same issue as ZBX-22557 when creating scheduled reports in Zabbix 6.0.18.

      The report seems to work fine when running manually.

      Result:

       

      4067995:20230605:111853.570 Starting Zabbix Server. Zabbix 6.0.18 
      (revision d2032721bc8).
      4067995:20230605:111853.570 ****** Enabled features ******
      4067995:20230605:111853.570 SNMP monitoring:           YES
      4067995:20230605:111853.570 IPMI monitoring:           YES
      4067995:20230605:111853.570 Web monitoring:            YES
      4067995:20230605:111853.570 VMware monitoring:         YES
      4067995:20230605:111853.570 SMTP authentication:       YES
      4067995:20230605:111853.570 ODBC:                      YES
      4067995:20230605:111853.570 SSH support:               YES
      4067995:20230605:111853.570 IPv6 support:              YES
      4067995:20230605:111853.570 TLS support:               YES
      4067995:20230605:111853.570 ******************************
      4067995:20230605:111853.570 using configuration file: 
      /etc/zabbix/zabbix_server.conf
      4067995:20230605:111853.582 current database version 
      (mandatory/optional): 06000000/06000020
      4067995:20230605:111853.582 required mandatory version: 06000000
      4067996:20230605:111853.589 starting HA manager
      4067996:20230605:111853.593 HA manager started in active mode
      4067995:20230605:111853.594 server #0 started [main process]
      4067998:20230605:111853.596 server #2 started configuration syncer #1
      4067997:20230605:111853.597 server #1 started service manager #1
      4068010:20230605:111853.720 server #3 started alert manager #1
      4068011:20230605:111853.720 server #4 started alerter #1
      4068013:20230605:111853.721 server #6 started alerter #3
      4068014:20230605:111853.721 server #7 started preprocessing manager #1
      4068015:20230605:111853.722 server #8 started preprocessing worker #1
      4068017:20230605:111853.722 server #10 started preprocessing worker #3
      4068012:20230605:111853.723 server #5 started alerter #2
      4068019:20230605:111853.724 server #12 started lld worker #1
      4068022:20230605:111853.724 server #15 started timer #1
      4068016:20230605:111853.724 server #9 started preprocessing worker #2
      4068020:20230605:111853.725 server #13 started lld worker #2
      4068023:20230605:111853.725 server #16 started http poller #1
      4068018:20230605:111853.726 server #11 started lld manager #1
      4068021:20230605:111853.727 server #14 started housekeeper #1
      4068028:20230605:111853.727 server #21 started history syncer #4
      4068034:20230605:111853.728 server #27 started poller #2
      4068033:20230605:111853.728 server #26 started poller #1
      4068031:20230605:111853.730 server #24 started self-monitoring #1
      4068029:20230605:111853.730 server #22 started escalator #1
      4068035:20230605:111853.730 server #28 started poller #3
      4068027:20230605:111853.732 server #20 started history syncer #3
      4068024:20230605:111853.732 server #17 started discoverer #1
      4068025:20230605:111853.732 server #18 started history syncer #1
      4068039:20230605:111853.733 server #32 started poller #7
      4068040:20230605:111853.733 server #33 started poller #8
      4068041:20230605:111853.733 server #34 started poller #9
      4068032:20230605:111853.736 server #25 started task manager #1
      4068030:20230605:111853.736 server #23 started proxy poller #1
      4068036:20230605:111853.737 server #29 started poller #4
      4068044:20230605:111853.737 server #37 started poller #12
      4068053:20230605:111853.737 server #45 started poller #20
      4068037:20230605:111853.738 server #30 started poller #5
      4068038:20230605:111853.739 server #31 started poller #6
      4068026:20230605:111853.739 server #19 started history syncer #2
      4068048:20230605:111853.740 server #41 started poller #16
      4068049:20230605:111853.740 server #42 started poller #17
      4068050:20230605:111853.740 server #43 started poller #18
      4068042:20230605:111853.741 server #35 started poller #10
      4068043:20230605:111853.741 server #36 started poller #11
      4068046:20230605:111853.741 server #39 started poller #14
      4068047:20230605:111853.741 server #40 started poller #15
      4068055:20230605:111853.741 server #47 started trapper #1
      4068054:20230605:111853.742 server #46 started unreachable poller #1
      4068052:20230605:111853.742 server #44 started poller #19
      4068045:20230605:111853.743 server #38 started poller #13
      4068058:20230605:111853.743 server #48 started trapper #2
      4068059:20230605:111853.743 server #49 started trapper #3
      4068062:20230605:111853.743 server #51 started trapper #5
      4068060:20230605:111853.744 server #50 started trapper #4
      4068064:20230605:111853.744 server #53 started icmp pinger #2
      4068065:20230605:111853.745 server #54 started icmp pinger #3
      4068068:20230605:111853.745 server #56 started icmp pinger #5
      4068072:20230605:111853.745 server #57 started icmp pinger #6
      4068067:20230605:111853.746 server #55 started icmp pinger #4
      4068073:20230605:111853.746 server #58 started icmp pinger #7
      4068063:20230605:111853.746 server #52 started icmp pinger #1
      4068076:20230605:111853.746 server #60 started icmp pinger #9
      4068079:20230605:111853.748 server #63 started icmp pinger #12
      4068080:20230605:111853.748 server #64 started icmp pinger #13
      4068075:20230605:111853.748 server #59 started icmp pinger #8
      4068078:20230605:111853.750 server #62 started icmp pinger #11
      4068084:20230605:111853.750 server #68 started icmp pinger #17
      4068077:20230605:111853.750 server #61 started icmp pinger #10
      4068085:20230605:111853.750 server #69 started icmp pinger #18
      4068081:20230605:111853.752 server #65 started icmp pinger #14
      4068086:20230605:111853.752 server #70 started icmp pinger #19
      4068082:20230605:111853.752 server #66 started icmp pinger #15
      4068087:20230605:111853.753 server #71 started icmp pinger #20
      4068083:20230605:111853.753 server #67 started icmp pinger #16
      4068088:20230605:111853.753 server #72 started alert syncer #1
      4068089:20230605:111853.753 server #73 started history poller #1
      4068090:20230605:111853.754 server #74 started history poller #2
      4068091:20230605:111853.755 server #75 started history poller #3
      4068092:20230605:111853.756 server #76 started history poller #4
      4068093:20230605:111853.756 server #77 started history poller #5
      4068096:20230605:111853.757 server #78 started availability manager #1
      4068097:20230605:111853.757 server #79 started report manager #1
      4068103:20230605:111853.758 server #82 started trigger housekeeper #1
      4068106:20230605:111853.758 server #83 started odbc poller #1
      zabbix_server [4068097]: ERROR [file and function: 
      <time.c,tm_add_seconds>, revision:d2032721bc8, line:104] Something 
      impossible has just happened.
      4068097:20230605:111853.759 === Backtrace: ===
      4068097:20230605:111853.760 12: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_backtrace+0x51) [0x561665ec0a01]
      4068097:20230605:111853.760 11: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x210cae) [0x561665eeccae]
      4068097:20230605:111853.760 10: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_tm_round_up+0x95) [0x561665eecef5]
      4068097:20230605:111853.760 9: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_get_report_nextcheck+0x1b5) [0x561665ee27d5]
      4068097:20230605:111853.760 8: /usr/sbin/zabbix_server: report manager 
      #1 started(+0xaba66) [0x561665d87a66]
      4068097:20230605:111853.760 7: /usr/sbin/zabbix_server: report manager 
      #1 started(report_manager_thread+0x190f) [0x561665d8aa6f]
      4068097:20230605:111853.760 6: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_thread_start+0x24) [0x561665ec3044]
      4068097:20230605:111853.760 5: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x745a0) [0x561665d505a0]
      4068097:20230605:111853.760 4: /usr/sbin/zabbix_server: report manager 
      #1 started(MAIN_ZABBIX_ENTRY+0xa03) [0x561665d519a3]
      4068097:20230605:111853.760 3: /usr/sbin/zabbix_server: report manager 
      #1 started(daemon_start+0x16d) [0x561665ec05fd]
      4068097:20230605:111853.760 2: /usr/sbin/zabbix_server: report manager 
      #1 started(main+0x4b7) [0x561665d489b7]
      4068097:20230605:111853.760 1: 
      /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f974ff39083]
      4068097:20230605:111853.760 0: /usr/sbin/zabbix_server: report manager 
      #1 started(_start+0x2e) [0x561665d4fa3e]
      zabbix_server [4068097]: ERROR [file and function: 
      <time.c,tm_add_seconds>, revision:d2032721bc8, line:104] Something 
      impossible has just happened.
      4068097:20230605:111853.760 === Backtrace: ===
      4068097:20230605:111853.761 12: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_backtrace+0x51) [0x561665ec0a01]
      4068097:20230605:111853.761 11: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x210cae) [0x561665eeccae]
      4068097:20230605:111853.761 10: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_tm_round_up+0xb9) [0x561665eecf19]
      4068097:20230605:111853.761 9: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_get_report_nextcheck+0x1b5) [0x561665ee27d5]
      4068097:20230605:111853.761 8: /usr/sbin/zabbix_server: report manager 
      #1 started(+0xaba66) [0x561665d87a66]
      4068097:20230605:111853.761 7: /usr/sbin/zabbix_server: report manager 
      #1 started(report_manager_thread+0x190f) [0x561665d8aa6f]
      4068097:20230605:111853.761 6: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_thread_start+0x24) [0x561665ec3044]
      4068097:20230605:111853.761 5: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x745a0) [0x561665d505a0]
      4068097:20230605:111853.761 4: /usr/sbin/zabbix_server: report manager 
      #1 started(MAIN_ZABBIX_ENTRY+0xa03) [0x561665d519a3]
      4068097:20230605:111853.761 3: /usr/sbin/zabbix_server: report manager 
      #1 started(daemon_start+0x16d) [0x561665ec05fd]
      4068097:20230605:111853.761 2: /usr/sbin/zabbix_server: report manager 
      #1 started(main+0x4b7) [0x561665d489b7]
      4068097:20230605:111853.761 1: 
      /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f974ff39083]
      4068097:20230605:111853.761 0: /usr/sbin/zabbix_server: report manager 
      #1 started(_start+0x2e) [0x561665d4fa3e]
      zabbix_server [4068097]: ERROR [file and function: 
      <time.c,tm_add_seconds>, revision:d2032721bc8, line:104] Something 
      impossible has just happened.
      4068097:20230605:111853.761 === Backtrace: ===
      4068097:20230605:111853.761 12: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_backtrace+0x51) [0x561665ec0a01]
      4068097:20230605:111853.761 11: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x210cae) [0x561665eeccae]
      4068097:20230605:111853.761 10: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_tm_round_up+0x79) [0x561665eeced9]
      4068097:20230605:111853.761 9: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_get_report_nextcheck+0x1b5) [0x561665ee27d5]
      4068097:20230605:111853.761 8: /usr/sbin/zabbix_server: report manager 
      #1 started(+0xaba66) [0x561665d87a66]
      4068097:20230605:111853.761 7: /usr/sbin/zabbix_server: report manager 
      #1 started(report_manager_thread+0x190f) [0x561665d8aa6f]
      4068097:20230605:111853.761 6: /usr/sbin/zabbix_server: report manager 
      #1 started(zbx_thread_start+0x24) [0x561665ec3044]
      4068097:20230605:111853.761 5: /usr/sbin/zabbix_server: report manager 
      #1 started(+0x745a0) [0x561665d505a0]
      4068097:20230605:111853.761 4: /usr/sbin/zabbix_server: report manager 
      #1 started(MAIN_ZABBIX_ENTRY+0xa03) [0x561665d519a3]
      4068097:20230605:111853.761 3: /usr/sbin/zabbix_server: report manager 
      #1 started(daemon_start+0x16d) [0x561665ec05fd]
      4068097:20230605:111853.761 2: /usr/sbin/zabbix_server: report manager 
      #1 started(main+0x4b7) [0x561665d489b7]
      4068097:20230605:111853.761 1: 
      /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f974ff39083]
      4068097:20230605:111853.761 0: /usr/sbin/zabbix_server: report manager 
      #1 started(_start+0x2e) [0x561665d4fa3e]
      4068101:20230605:111853.857 server #81 started report writer #2
      4068098:20230605:111853.858 server #80 started report writer #1

      Also, in the frontend we have an error with the report:

      Cannot calculate report start time: [75] Value too large for defined 
      data type

      Expected:

      Clear error on what the user needs to input and/or prevention of thread crash.

            zabbix.dev Zabbix Development Team
            qix Raymond Kuiper
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: