Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 9366 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

HotSpot database locked

Daniels_UTM
since some days i have a problem with a locked HotSpot Database.

Does somebody know how to unlock it? must be just a command ... sophos did it last time @ a service call ... but after 12 days ... 


2015:10:14-09:27:40 firewall-2 hotspotd[3773]: ERROR: cannot execute UPDATE in a read-only transaction

2015:10:14-09:27:40 firewall-2 hotspotd[3773]: hotspotd started

2015:10:14-09:27:40 firewall-2 hotspotd[3773]: hotspotd stopped

2015:10:14-09:28:10 firewall-2 hotspotd[8139]: ERROR: cannot execute UPDATE in a read-only transaction

2015:10:14-09:28:10 firewall-2 hotspotd[8139]: hotspotd started

2015:10:14-09:28:10 firewall-2 hotspotd[8139]: hotspotd stopped

2015:10:14-09:28:40 firewall-2 hotspotd[12558]: ERROR: cannot execute UPDATE in a read-only transaction

2015:10:14-09:28:40 firewall-2 hotspotd[12558]: hotspotd started

2015:10:14-09:28:40 firewall-2 hotspotd[12558]: hotspotd stopped

2015:10:14-09:29:10 firewall-2 hotspotd[16959]: ERROR: cannot execute UPDATE in a read-only transaction

2015:10:14-09:29:10 firewall-2 hotspotd[16959]: hotspotd started

2015:10:14-09:29:10 firewall-2 hotspotd[16959]: hotspotd stopped

2015:10:14-09:29:40 firewall-2 hotspotd[21319]: ERROR: cannot execute UPDATE in a read-only transaction

2015:10:14-09:29:40 firewall-2 hotspotd[21319]: hotspotd started

2015:10:14-09:29:40 firewall-2 hotspotd[21319]: hotspotd stopped


This thread was automatically locked due to age.
  • 0
    Are you in Hot-Standby?  What happens if you reboot to failover to the Slave?

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • 0
    i couldn't fix that problem by restarting the devices ...

    at the and a rebuild of the database and reconfiguration of HotSpot did the job ...
  • 0
    For the next person with a similar problem, I guess he did a rebuild of all of the PostgreSQL databases:

    /etc/init.d/postgresql92 rebuild


    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Unfiltered HTML