Hello, I'm here with an update.

My conclusion, that the replication is running, was false. The DDL 
attempt seems to have dropped all triggers from tables, the replication 
is stopped, tha changes are not being recorded, and we'll have to 
reinitialize it.

Well, this particular case is closed, but maybe the developers could 
look into it, so that this would not happen in the future to some other 
poor folk.

MT.

Michal Taborsky - Internet Mall napsal(a):
> Hello everyone.
> 
> We've run into problem with EXECUTE SCRIPT. Our configuration is two 
> servers, one master, one slave. All tables are in one set. PostgreSQL 
> version is 8.1.9, Slony is 1.2.9.
> 
> The problem was (probably) caused by executing a DDL script via slonik 
> EXECUTE SCRIPT command. This script included BEGIN and COMMIT, which 
> slony did not accept. We do not have the exact error message, 
> unfortunately.
> 
> The slonik script is pretty simple:
> 
> EXECUTE SCRIPT ( SET ID = 1, FILENAME = 'change.sql' );
> 
> After that, all attempts to run EXECUTE SCRIPT end up with:
> 
> <stdin>:5: PGRES_FATAL_ERROR select "_T1".ddlScript_prepare(1, -1);  - 
> ERROR:  Slony-I: alterTableRestore(): Table "adm"."dberror_help" is not 
> in altered state
> CONTEXT:  SQL statement "SELECT  "_T1".alterTableRestore(tab_id) from 
> "_T1".sl_table where tab_set in (select set_id from "_T1".sl_set where 
> set_origin = "_T1".getLocalNodeId('_T1'))"
> PL/pgSQL function "ddlscript_prepare" line 30 at perform
> 
> The "adm"."dberror_help" is the first table in the set. We have tried 
> even the most simple script, just a "SELECT 1", the result being the same.
> 
> The replication seems to be running, but of course we'd like to fix this 
> as soon as possible.
> 
> Thanks for your advice.
> 


-- 
Michal Táborský
chief systems architect
Internet Mall, a.s.
<http://www.MALL.cz>
-----------------------
NOVINKA - VODNI HRISTE PRO HORKE DNY! Detske nafukovaci vodni hriste Intex s bazenkem, brouzdalistem, sprchovadlem a vodnimi hrami. Dodani obratem.


http://www.ostrovpokladu.cz/nafukovaci-hracky/intex-vodni-centrum
-----------------------