Cannot execute UNLISTEN during recovery

Comments

4 comments

  • Avatar
    Kobbi Gal

    It seems that the DB is currently in recovery mode (called 'hot standby') and therefore querying (or LISTEN/UNLISTEN/NOTIFY events) are not possible in this state according to PostgreSQL documentation.

    Try to run the build when the DB is finished its recovery or standby mode.

     

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    In most cases you can't switch off hot standby and there is no real window to connect to get around that. I'd suggest creating a mirror of this database on PostGres, which will have hot standby disabled.

    0
    Comment actions Permalink
  • Avatar
    Pep Masoliver (Edited )

    Hello,

    Any update on how did you solve it? We're suffering the same situation after upgrading to Sisense 8.1 :-(

    Thanks in advance!

    0
    Comment actions Permalink
  • Avatar
    Shawn Hilditch

    I was able to resolve using the Web ECM and adding the Additional parameter: NoResetOnClose=true

    to all DB connections to the read replica databases we used. No issue with the UNLISTEN error after that.

    There is no way to configure DB parameters in the Desktop ECM, so all cubes had to be updated using Web. When editing tables with custom queries, copy the current query using Edit Table option. Then choose Edit Connection, add the parameter, then select database then add new Custom Query and paste the query from earlier. Click OK the connection will be updated.

    0
    Comment actions Permalink

Please sign in to leave a comment.