Fri Oct 5 06:25:00 PDT 2012
- Previous message: [Slony1-general] slony init_cluster problem
- Next message: [Slony1-general] Staging/reporting replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
*Sorry for redundancy: forgot to include the slony1-general list in my first response * ---------- Forwarded message ---------- From: Mark Steben <mark.steben at drivedominion.com> Date: Fri, Oct 5, 2012 at 9:22 AM Subject: Re: [Slony1-general] slony init_cluster problem To: Raghav <ragavendra.dba at gmail.com> *First of all, I apologize for the excessive length of my first query. I'll try to keep everything short and sweet. In response to Raghav's query: no slony logs have been created yet because I haven't issued a start_slon statement. Can't do that till I initialize a cluster. **Also, all the pg_logs show are the printouts of the script to create the schema. Finally, check the pg_stat_activity listing I attached. The CREATE table for sl_node is not in a wait state. * On Fri, Oct 5, 2012 at 12:54 AM, Raghav <ragavendra.dba at gmail.com> wrote: > > On Fri, Oct 5, 2012 at 1:08 AM, Mark Steben <mark.steben at drivedominion.com > > wrote: > >> *Hi, trying to initialize a new cluster using the alt-perl scripts >> provided >> in the install >> Here are the specs >> >> MASTER: >> linux installed on a VM setup. >> (The VM is installed on a Windows 7 OS running on a HP Elitebook laptop) >> 8.0.4 build-744019 >> the uname -a command: >> Linux localhost.localdomain 2.6.18-308.13.1.el5 #1 SMP Tue Aug 21 >> 17:10:18 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux >> **total shared memory available: 2 GB >> postgres installed: 8.3.21 (with enable_thread_safety) >> slony installed: 2.1.1 >> >> *** >> *SLAVE: >> linux installed on a dell desktop >> (The primary OS on this machine is linux) >> the uname -a command: >> Linux msteben-centos.autorevenue.com 2.6.1**8-194.11.4.el5 #1 SMP Tue >> Sep 21 05:04:09 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux >> **total shared memory available: 2 GB >> **postgres installed: 8.3.21 (with enable_thread_safety) >> slony installed: 2.1.1 >> >> PROBLEM: >> I attempt to run the altperl script ./slonik_init_cluster from the slave >> the connection gets through to the master, but all it does on the >> master is >> print the replication schema (all the sl tables) over and over and over >> again >> in the postgres logs. It never gets to creating the _reptest schema, >> then >> defining the sl_tables. When I do a query on pg_stat_activity on the >> master >> the one query actually running is the CREATE TABLE sl_nodes statement. >> It never >> finishes. I finally have to kill the connection and nothing gets done. >> >> I've attached the postgresql.conf from both servers as well as the >> slon_tools.conf >> from the slave. The admin user referenced in the slon_tools is slony >> and >> is defined as a superuser. >> >> Any help appreciated. Any other info you need, please let me know. >> >> Mark Steben >> DBA at AutoRevenue * >> >> >> _______________________________________________ >> Slony1-general mailing list >> Slony1-general at lists.slony.info >> http://lists.slony.info/mailman/listinfo/slony1-general >> >> > Before doing any guesses, slony logs(also pg_logs) would be helpful to > know why exactly CREATE TABLE SL_NODE is in waiting state. > > -- > Regards > Raghav > Blog: htt://raghavt.blogspot.com/ > > -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase<http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg> -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase<http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20121005/ff777af3/attachment-0001.htm -------------- next part -------------- -[ RECORD 2 ]-+-------------------------------------------------------------------------------------------------- datid | 469329490 datname | slonytst procpid | 6042 usesysid | 16385 usename | slony current_query | -- ---------------------------------------------------------------------- : -- slony1_base.sql : -- : -- Declaration of the basic replication schema. : -- : -- Copyright (c) 2003-2009, PostgreSQL Global Development Group : -- Author: Jan Wieck, Afilias USA INC. : -- : -- : -- ---------------------------------------------------------------------- : : : -- ********************************************************************** : -- * Tables : -- ********************************************************************** : : : -- ---------------------------------------------------------------------- : -- TABLE sl_node : -- ---------------------------------------------------------------------- : create table "_reptest".sl_node ( : no_id int4, : no_active bool, : no_comment text, : CONSTRAINT "sl_node-pkey" : PRIMARY KEY (no_id) : ) WITHOUT OIDS; : comment on table "_reptest".sl_node is 'Holds the list of nodes associated with this namespace.'; : comment on column "_reptest".sl_node.no_id is 'The unique ID number for the node'; : comment on column "_rep waiting | f xact_start | 2012-10-05 09:05:36.20057-04 query_start | 2012-10-05 09:05:36.446774-04 backend_start | 2012-10-05 09:05:35.990462-04 client_addr | 10.10.4.34 client_port | 35521
- Previous message: [Slony1-general] slony init_cluster problem
- Next message: [Slony1-general] Staging/reporting replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list