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

Cannot Login to Zabbix Interface- Database Error

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Commercial support required
    • Icon: Minor Minor
    • None
    • 3.0.24
    • Frontend (F), Server (S)
    • None
    • CetOS 7.5.1804, Postgre10 DB

      Steps to reproduce:

      1. Cannot login to zabbix front end

      Result:

      128935:20181130:113427.687 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (45387,1543577667,672318563,65.723344);
      ]
      128935:20181130:113427.728 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (31707,1543577667,716514154,0.000000);
      ]
      128935:20181130:113427.741 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into events (eventid,source,object,objectid,clock,ns,value) values (11426,3,0,17033,1543577667,716514154,1),(11427,3,0,20443,1543577667,716514154,1);
      ]
      128935:20181130:113427.753 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (34527,1543577667,734498950,61.133708),(28347,1543577667,744447548,99.870703);
      ]
      128935:20181130:113427.780 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (41367,1543577667,745321948,95.353993);
      ]
      128934:20181130:113427.825 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (32787,1543577667,781858840,38.845812);
      ]
      128935:20181130:113427.843 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot execute INSERT in a read-only transaction
      [insert into history (itemid,clock,ns,value) values (35067,1543577667,836420329,0.000000);
      

      See attached patch file...

            Unassigned Unassigned
            gradinar Marcelo Gradinar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: