8 Replies Latest reply: Nov 23, 2017 2:47 AM by Piotr Gora RSS

    Recurring postgres "qlogs_reader" error on server.

    Christopher Obert

      Hi everyone,

       

      Soooooo...Since we updated from Qlik sense 3.2 to September 2017 release (skipping over June 2017 release) we have been getting a recurring error every hour on the server that hosts QLIK. Has anyone else seen this and van give me some direction?  Google literally returned zero matches on the error. (never really seen THAT before).  Thanks in advance. The full error text is below.

       

      FATAL: password authentication failed for user "qlogs_reader" DETAIL: Role "qlogs_reader" does not exist. Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

        • Re: Recurring postgres "qlogs_reader" error on server.
          Jai Soni

          Did you configure Centralized Logging during the upgrade? If yes, do you see Qlogs database in repository database. If not, you can simple disable logging service on Qlik host or install the database as explained here

          https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Qlik-Logging-…

          • Re: Recurring postgres "qlogs_reader" error on server.
            Christopher Obert

            Hi Jai,

            First thank you for your reply,

            one question (ok maybe two)...

            Will disabling the service mean that All logs will cease?  We only have the one node at this point so centralized logging is probably not really needed. But I still want to locally log. If I need to keep the service running? Does the qlog reader and qlog writer need to be added to AD? or can they be local user account to the machine?

             

            Thanks for you help

            • Re: Recurring postgres "qlogs_reader" error on server.
              Damian Thomson

              Hi

               

              Stumbled across this as we are seeing the same issue, we did deploy the centralised logging.

               

              Looking at the URL you listed I can validate the logging service:

              C:\Program Files\Qlik\Sense\Logging>qlik.logging.service.exe validate

              Successfully validated logging database and schema version.

                      CentralizedLoggingEnabled: True

                      LoggingToFileEnabled: True

                      archive_age_in_days: 30

                      last_forced_db_trim: 2017-10-17 20:12:24.138551+01

                      purge_age_in_days: 60

                      version: 0.1

               

              But still see the twice hourly error in windows event log:

              FATAL:  password authentication failed for user "qlogs_reader"

              DETAIL:  Password does not match for user "qlogs_reader".

              Connection matched pg_hba.conf line 82: "host    all             all             ::1/128                 md5"

               

              Can anyone advise how we update the password for the reading to what we set on the install

              • Re: Recurring postgres "qlogs_reader" error on server.
                Christopher Obert

                Here is my latest update....I disabled the logging service, and it is still disabled.  I just noticed that it solved the problem for about a day or so and now we are getting the error again, although the error is slightly different

                 

                 

                The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

                 

                 

                If the event originated on another computer, the display information had to be saved with the event.

                 

                 

                The following information was included with the event:

                 

                 

                FATAL:  password authentication failed for user "qlogs_reader"

                DETAIL:  Role "qlogs_reader" does not exist.

                Connection matched pg_hba.conf line 82: "host    all             all             ::1/128                 md5"

                  • Re: Recurring postgres "qlogs_reader" error on server.
                    Piotr Gora

                    Hi!

                    Disabling the logging server did not work for me, I would guess that the logging server uses the role/user qlogswriter, during other work I found that the data connection "QLogs" uses the user/role Qlogs_reader, I think the data connection is used by Operations Monitor app. I checked that my password for Qlogs_reader was correct by connecting to the database using psql

                     

                    PS C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin> ./psql -p xxxx -U qlogs_reader -d QLogs

                    Password for user qlogs_reader:

                    psql (9.6.3)

                    Type "help" for help.

                     

                    QLogs=> \dt

                                    List of relations

                    Schema |      Name       | Type  |    Owner

                    --------+-----------------+-------+--------------

                    public | archive_entries | table | qlogs_writer

                    public | log_entries     | table | qlogs_writer

                    public | settings        | table | qlogs_writer

                    (3 rows)

                     


                    After that I went to the Data connections in QMC, took edit on QLogs and inserted the password for the Qlogs_reader user and applied the changes. For now at least it looks like the error messages have stopped coming. A lot of "I guess" and "I think" but it seems to work...for now.