[Pdns-users] Upgrading PDNS from 2.9 to 3.0- Communicator thread died because of error: GSQLBackend unable to refresh domain_id 196: PostgreSQL failed to execute command: ERROR: Slony-I: Table domains is replicated and cannot be modified on a subscriber node - role=0

[bert hubert]

On Thu, Feb 16, 2012 at 02:38:33PM -0500, Dougan, Linda A wrote:
> I am upgrading from pdns 2.9 to 3.0.1.   I was able to fix the previous STL error by adding query-local-address6=  to pdns.conf as Bert suggested, thank you! Now DNS works on every other try but not every time. I have also upgraded to pdns-recursor-3.3. I am running Lua 5.1 and boost-1.41.0-r3.
> 
> I am getting a new error:
> Communicator thread died because of error: GSQLBackend unable to refresh domain_id 196: PostgreSQL failed to execute command: ERROR:  Slony-I: Table domains is replicated and cannot be modified on a subscriber node - role=0
> 
> This server is one of a 4 servers that use Slony to copy the database between them.  It is not the master node and the table is sort of locked by slony so it cannot do an update to the table as it appears it be trying to do.  Does anyone know why it is trying to do an update?

Do you have either 'master' or 'slave' in your configuration?

	Bert