Menu
▾
▴
Re: [Postgres-xc-general] Problem with executing any query (No space left on )
|
From: 鈴木 幸市 <ko...@in...> - 2014-05-01 10:49:56
|
Do you mean pg_xlog at the slave? Because pg_xlog contains all the redo logs needed to recovery, it is quite harmful to do so. If you are removing pg_xlog at the slave, it is also harmful too. Pgxc_ctl configures the slave to remove unnecessary files under pg_xlog automatically. Anyway, the problem looks to be caused by missing gtm.control. Do you have any indication how it’s been gone? And what is your current status of the database? Do you have any chance to stop the database, take backups and see what’s going on? Regards; --- Koichi Suzuki 2014/05/01 19:45、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール： what will be the impact if i remove files under pg_xlog directory ? root@db02:/home/postgres/pgxc/nodes/dn_master/pg_xlog# du -sh 33G . On Thu, May 1, 2014 at 4:05 PM, Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> wrote: As of now i am attaching my pgxc_ctl.conf file, i have setup everything using pgxc_ctl. this database is in production. to perform all above steps i need to set downtime. so when i get a change i ll perform this steps . please tell me if i have done any misconfiguration in this file. so i can update this at that time. On Thu, May 1, 2014 at 3:50 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote: I needd an info how you configured your cluster, manually or pgxc_ctl. If pgxc_ctl, I need your configuration file. Also, it’s very funny that gtm.control is missing. If so, next thing you can do is: 1) Stop all the coordinators/datanodes/gtm, master and slave. 2) Bake file-level backup of all the resources (cold backup) 3) Detach coordinator/datanode slaves and see if masters run normally. 4) If so, then reconstruct slaves. 5) If masters does not work correctly, you need to hack each node’s pg_control to see current GXID value and restore gtm.control with this value to restart gtm. Even if gtm fails, gtm.control is available to indicate a safe restart point. Do you have any idea how it’s been gone? Regards; --- Koichi Suzuki 2014/05/01 19:02、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール： I am not sure but may be datanode_archlog directory is not exists in my case. may be its have different name. however size of /home/postgres/pgxc/nodes/dn_master directory is 42G and /home/postgres/pgxc/nodes/gtm_pxy is of 31G. Please suggest. On Thu, May 1, 2014 at 12:50 PM, Michael Paquier <mic...@gm...<mailto:mic...@gm...>> wrote: On Mon, Apr 28, 2014 at 8:31 PM, Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> wrote: > "/home/postgres/pgxc/nodes/datanode_archlog/000000010000001C0000006A": No > space left on device (28) This means that the partition containing folder /home/postgres/pgxc/nodes/datanode_archlog/ is full. Try to do some df and monitor the size of this partition/disk that you are using for your archive files. -- Michael -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com<http://www.inextrix.com/> ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs_______________________________________________ Postgres-xc-general mailing list Pos...@li...<mailto:Pos...@li...> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com<http://www.inextrix.com/> -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com<http://www.inextrix.com/> |
