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

error sending mail to SMTP server causes a SQL error

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.0.2
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      CENTOS 6.5X86_64+curl 7.48.0 with ORACLE 11gR2

      Description

       24937:20160513:095751.639 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24936:20160513:095808.373 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24938:20160513:095809.398 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:095820.728 Login denied:   24944:20160513:095820.728 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:095850.848 Login denied:   24944:20160513:095850.849 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:095920.957 Login denied:   24944:20160513:095920.957 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24940:20160513:095925.688 cannot send list of active checks to "10.130.131.131": host [centos65_10.130.131.131] not found
       24944:20160513:095951.070 Login denied:   24944:20160513:095951.070 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24940:20160513:095951.832 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24937:20160513:100008.413 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24938:20160513:100009.423 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:100021.190 Login denied:   24944:20160513:100021.191 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100051.384 Login denied:   24944:20160513:100051.384 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100121.486 Login denied:   24944:20160513:100121.487 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24938:20160513:100125.708 cannot send list of active checks to "10.130.131.131": host [centos65_10.130.131.131] not found
       24944:20160513:100151.632 Login denied:   24944:20160513:100151.632 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24936:20160513:100151.850 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24937:20160513:100208.440 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24940:20160513:100209.441 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:100221.786 Login denied:   24944:20160513:100221.786 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100251.903 Login denied:   24944:20160513:100251.903 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100322.027 Login denied:   24944:20160513:100322.027 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24937:20160513:100325.726 cannot send list of active checks to "10.130.131.131": host [centos65_10.130.131.131] not found
       24940:20160513:100351.914 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24944:20160513:100352.193 Login denied:   24944:20160513:100352.193 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24938:20160513:100408.472 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24937:20160513:100409.461 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:100422.350 Login denied:   24944:20160513:100422.350 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100452.446 Login denied:   24944:20160513:100452.446 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100522.592 Login denied:   24944:20160513:100522.592 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24940:20160513:100525.749 cannot send list of active checks to "10.130.131.131": host [centos65_10.130.131.131] not found
       24940:20160513:100551.949 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24944:20160513:100552.711 Login denied:   24944:20160513:100552.711 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24940:20160513:100608.499 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24942:20160513:100609.496 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:100622.850 Login denied:   24944:20160513:100622.850 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100653.017 Login denied:   24944:20160513:100653.017 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24944:20160513:100723.188 Login denied:   24944:20160513:100723.188 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24942:20160513:100725.770 cannot send list of active checks to "10.130.131.131": host [centos65_10.130.131.131] not found
       24938:20160513:100751.988 cannot send list of active checks to "10.130.130.89": host [bak] not found
       24944:20160513:100753.307 Login denied:   24944:20160513:100753.307 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
       24940:20160513:100808.529 cannot send list of active checks to "10.130.131.163": host [zcfzApp1_10.130.131.163] not found
       24940:20160513:100809.513 cannot send list of active checks to "10.130.130.170": host [bak] not found
       24944:20160513:100823.448 Login denied:   24944:20160513:100823.449 [Z3005] query failed: [-1] ORA-01756: quoted string not properly terminated [update alerts set retries=1,error='Login denied:  where alertid=8]
      

        Attachments

        1. 1.png
          1.png
          28 kB
        2. 1.png
          1.png
          1.08 MB
        3. zabbix_server.log.7z
          756 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jhwangpin Mr.Wang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: