Fri Aug 20 22:14:45 PDT 2004
- Previous message: [Slony1-general] slonik documentation
- Next message: [Slony1-general] Issue
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I've been putting Slony-I 1.0.2 though it's paces so to speak and I have a concern /question. select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 7.4.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) When I do the ever faithful pull the power on the test box while pgbench and replication is running, once the box comes back up the slon's (both source and destination) die with a FATAL message "localListenThread: Another slon daemon is serving this node already". I tracked this down to a check in src/slon/local_listner.c The error message only happens when a row exists in the pg_catalog.pg_listener where relname = '_<clustername>_Restart'. I can clear the error up by issuing a NOTIFY "_<clustername>_Restart" on both the source and the target, then issuing a kill -9 on the two slon's that are running and the re-launching them (I've waited approcimately 3 minutes with no response from the slon's and normal kill doesn't work). The NOTIFY get's rid of the old pg_listener entries, the kill get's rid of the current entries, and the restart prompts the new slon's to pick up where they left off before the simulated outage. Need any more info? Just a couple more things: I changed the pgbench test to -s 100 -c 100 -t 10000 so database comparisons were taking forever, so I changed the psql script to use TEMP TABLES and COPY (much faster, see below). I also took out the dependency on the added slonik key and added my own index on history(tid, bid, aid) so that the databases can be compared after issuing UNISTALL NODE commands. This had the side benifit of tesing the EXECUTE SCRIPT command as well. select 'accounts:'::text, aid, bid, abalance, filler into temp table t1 from accounts order by aid; copy t1 TO stdout; select 'branches:'::text, bid, bbalance, filler into temp table t2 from branches order by bid; copy t2 TO stdout; select 'tellers:'::text, tid, bid, tbalance, filler into temp table t3 from tellers order by tid; copy t3 TO stdout; select 'history:'::text, tid, bid, aid, delta, mtime, filler into temp table t4 from history order by tid, bid, aid, delta, mtime, filler; copy t4 TO stdout;
- Previous message: [Slony1-general] slonik documentation
- Next message: [Slony1-general] Issue
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list