Re: [Postgres-xc-general] Problem with starting datanode slave

[鈴木 幸市 <ko...@in...>]

The setup of max_connection=1000 might have written to WAL and shipped to the slave.   This could be the cause of the issue.

You can do the following to recover from the issue.

1. Run checkpoint and vacuum full at the master,
2. Build the slave from the scotch using pg_basebackup (pgxc_ctl provides this means).
3. Start the slave.

Regards;
---
Koichi Suzuki

2014/04/16 21:53、Juned Khan <jkh...@gm...> のメール：

> Hi All,
> 
> When i tried to set max_connection value to 1000 it gave me this error
> 
> FATAL:  could not create semaphores: No space left on device 
> DETAIL:  Failed system call was semget(20008064, 17, 03600). 
> 
> From the docs i came to know that to use than much connection i have to modify kernel configuration
> 
> But now i am now trying to set 500 connection instead of 1000 then its giving below error.
> 
> LOG:  database system was interrupted while in recovery at log time 2014-04-16 09:06:06 WAT
> HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
> LOG:  entering standby mode
> LOG:  restored log file "000000010000000B00000011" from archive
> FATAL:  hot standby is not possible because max_connections = 500 is a lower setting than on the master server (its value was 1000)
> LOG:  startup process (PID 16829) exited with exit code 1
> LOG:  aborting startup due to startup process failure
> 
> It says master value is 1000 but i have set it to 500. seems it reading old values i guess.
> 
> database=# show max_connections;
>  max_connections 
> -----------------
>  500
> (1 row)
> 
> I have restarted all components several times but no luck.
> 
> Anyone please suggest if any other way is there to fix this like clearing cache or something so it can read correct values.
> 
> 
> Regards
> Juned Khan
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general