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

SQL Error After 4.0.19 Upgrade on Oracle

    XMLWordPrintable

Details

    • Team B
    • Sprint 62 (Mar 2020)
    • 0.125

    Description

      Upgrade frontend to version 4.0.19
      After Login SQL error appears:

      "SQL error [ORA-00933: неверное завершение SQL-предложения] in [SELECT NULL FROM users u WHERE u.userid=13 FOR UPDATE;]"

      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
      Version 18.6.0.0.0

      Attachments

        1. error1.png
          error1.png
          520 kB
        2. error2.png
          error2.png
          41 kB

        Issue Links

          caused by

          Problem report - Problem report ZBX-9057 Duplicate rows in "profiles" table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              talbergs Mārtiņš Tālbergs (Inactive)
              dlamberts Dmitrijs Lamberts
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: