postgres-xc-general

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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/>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...> wrote:

>  Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use
> pg_dumpall, not pg_dump unless you’re backing up single database.    I’m
> afraid coord2 had had some issue.
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/05/06 21:50、Juned Khan <jkh...@gm...> のメール：
>
>   nope i have directly did those steps on live server. I don't know
> exactly what cause that problem. one day i just tried to run some queries
> manually and got those errors.
>
>  I have tried to restart all components several times without success.
>
>  now another problem is i am not able to take dump of database. i am
> getting this error.
>
> postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
> connections
> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
> SHARE MODE
>
>  Please suggest.
>
>
>
> On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...>wrote:
>
>> Did you make any test before you did any action on your database?
>> Also could you share what you did to have this situation?   Anyway,
>> with this situation, I believe no DDL has been handled except for
>> temporary object, which is session specific.
>>
>> So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
>> reinitialize it as long as you maintain gtm_proxy.conf) and coord2.
>>
>> Anyway, it is very essential to record and share what you did, and
>> more important thing is to test it with non-product environment and
>> see what goes on, and then review any step you are taking before you
>> do.
>>
>> Hope to have more info on this.
>>
>> Best Regards;
>> ---
>> Koichi Suzuki
>>
>>
>>  2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...>:
>>  > Hi Koichi,
>> >
>> > I tried to follow the steps removing datanode slave and adding it again
>> but
>> > i no success. even earlier only datanode slave was not working but now
>> gtm
>> > slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed
>> GTM
>> > slave and datanode slave
>> >
>> > here is my current status of pgxc
>> >
>> > PGXC monitor all
>> > Running: gtm master
>> > Running: gtm proxy gtm_pxy1
>> > Not running: gtm proxy gtm_pxy2
>> > Running: coordinator master coord1
>> > Not running: coordinator master coord2
>> > Running: datanode master datanode1
>> >
>> > Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
>> > mydatabase) but its not allowing me to modify table structure. and
>> giving me
>> > below error.
>> >
>> > mydatabase=#  alter table invoice_summary_data add countrycode text not
>> null
>> > default ''::character(1);
>> > ERROR:  Failed to get pooled connections
>> > CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
>> > pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>> >
>> > So as of now i am planning to remove those components which are not
>> working
>> > (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>> >
>> > what will be the impact of this, i don't want to loost database access
>> > completely.
>> >
>> > Please suggest.
>> >
>> > Regards
>> > Juned Khan
>> >
>>   >
>> ------------------------------------------------------------------------------
>> > "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...
>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>> >
>>
>
>
>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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
>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

PGXC pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...> wrote:

>  What error did you have?
> ---
> Koichi Suzuki
>
>  2014/05/07 14:18、Juned Khan <jkh...@gm...> のメール：
>
>   yeah i tried to restart the coord2 and gtm_pxy2 but no success.
>  I have tried to take pg_dumpall but its giving me same error.
>
>  please suggest.
>
>  Regards
>  Juned Khan
>
> On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...> wrote:
>
>> Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use
>> pg_dumpall, not pg_dump unless you’re backing up single database.    I’m
>> afraid coord2 had had some issue.
>>
>>  Regards;
>> ---
>> Koichi Suzuki
>>
>>  2014/05/06 21:50、Juned Khan <jkh...@gm...> のメール：
>>
>>   nope i have directly did those steps on live server. I don't know
>> exactly what cause that problem. one day i just tried to run some queries
>> manually and got those errors.
>>
>>  I have tried to restart all components several times without success.
>>
>>  now another problem is i am not able to take dump of database. i am
>> getting this error.
>>
>> postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>> connections
>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
>> SHARE MODE
>>
>>  Please suggest.
>>
>>
>>
>> On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...>wrote:
>>
>>> Did you make any test before you did any action on your database?
>>> Also could you share what you did to have this situation?   Anyway,
>>> with this situation, I believe no DDL has been handled except for
>>> temporary object, which is session specific.
>>>
>>> So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
>>> reinitialize it as long as you maintain gtm_proxy.conf) and coord2.
>>>
>>> Anyway, it is very essential to record and share what you did, and
>>> more important thing is to test it with non-product environment and
>>> see what goes on, and then review any step you are taking before you
>>> do.
>>>
>>> Hope to have more info on this.
>>>
>>> Best Regards;
>>> ---
>>> Koichi Suzuki
>>>
>>>
>>>  2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...>:
>>>  > Hi Koichi,
>>> >
>>> > I tried to follow the steps removing datanode slave and adding it
>>> again but
>>> > i no success. even earlier only datanode slave was not working but now
>>> gtm
>>> > slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have
>>> removed GTM
>>> > slave and datanode slave
>>> >
>>> > here is my current status of pgxc
>>> >
>>> > PGXC monitor all
>>> > Running: gtm master
>>> > Running: gtm proxy gtm_pxy1
>>> > Not running: gtm proxy gtm_pxy2
>>> > Running: coordinator master coord1
>>> > Not running: coordinator master coord2
>>> > Running: datanode master datanode1
>>> >
>>> > Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
>>> > mydatabase) but its not allowing me to modify table structure. and
>>> giving me
>>> > below error.
>>> >
>>> > mydatabase=#  alter table invoice_summary_data add countrycode text
>>> not null
>>> > default ''::character(1);
>>> > ERROR:  Failed to get pooled connections
>>> > CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
>>> > pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>>> >
>>> > So as of now i am planning to remove those components which are not
>>> working
>>> > (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>>> >
>>> > what will be the impact of this, i don't want to loost database access
>>> > completely.
>>> >
>>> > Please suggest.
>>> >
>>> > Regards
>>> > Juned Khan
>>> >
>>>   >
>>> ------------------------------------------------------------------------------
>>> > "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...
>>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>> >
>>>
>>
>>
>>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

Hmm, did pgxc_pool_reload() work?
---
Koichi Suzuki

2014/05/07 14:33、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

PGXC pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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/>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

nope it didn't

astpp=# SELECT pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

astpp=# \q
PGXC  pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Hmm, did pgxc_pool_reload() work?
> ---
> Koichi Suzuki
>
>  2014/05/07 14:33、Juned Khan <jkh...@gm...> のメール：
>
>  PGXC pg_dumpall -h db02 > dumpall.sql
> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
> connections
> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
> SHARE MODE
> pg_dumpall: pg_dump failed on database "astpp", exiting
>
>
>
> On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...> wrote:
>
>> What error did you have?
>> ---
>> Koichi Suzuki
>>
>>  2014/05/07 14:18、Juned Khan <jkh...@gm...> のメール：
>>
>>   yeah i tried to restart the coord2 and gtm_pxy2 but no success.
>>  I have tried to take pg_dumpall but its giving me same error.
>>
>>  please suggest.
>>
>>  Regards
>>  Juned Khan
>>
>> On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...> wrote:
>>
>>> Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to
>>> use pg_dumpall, not pg_dump unless you’re backing up single database.
>>>  I’m afraid coord2 had had some issue.
>>>
>>>  Regards;
>>> ---
>>> Koichi Suzuki
>>>
>>>  2014/05/06 21:50、Juned Khan <jkh...@gm...> のメール：
>>>
>>>   nope i have directly did those steps on live server. I don't know
>>> exactly what cause that problem. one day i just tried to run some queries
>>> manually and got those errors.
>>>
>>>  I have tried to restart all components several times without success.
>>>
>>>  now another problem is i am not able to take dump of database. i am
>>> getting this error.
>>>
>>> postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
>>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>>> connections
>>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
>>> SHARE MODE
>>>
>>>  Please suggest.
>>>
>>>
>>>
>>> On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...>wrote:
>>>
>>>> Did you make any test before you did any action on your database?
>>>> Also could you share what you did to have this situation?   Anyway,
>>>> with this situation, I believe no DDL has been handled except for
>>>> temporary object, which is session specific.
>>>>
>>>> So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
>>>> reinitialize it as long as you maintain gtm_proxy.conf) and coord2.
>>>>
>>>> Anyway, it is very essential to record and share what you did, and
>>>> more important thing is to test it with non-product environment and
>>>> see what goes on, and then review any step you are taking before you
>>>> do.
>>>>
>>>> Hope to have more info on this.
>>>>
>>>> Best Regards;
>>>> ---
>>>> Koichi Suzuki
>>>>
>>>>
>>>>  2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...>:
>>>>  > Hi Koichi,
>>>> >
>>>> > I tried to follow the steps removing datanode slave and adding it
>>>> again but
>>>> > i no success. even earlier only datanode slave was not working but
>>>> now gtm
>>>> > slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have
>>>> removed GTM
>>>> > slave and datanode slave
>>>> >
>>>> > here is my current status of pgxc
>>>> >
>>>> > PGXC monitor all
>>>> > Running: gtm master
>>>> > Running: gtm proxy gtm_pxy1
>>>> > Not running: gtm proxy gtm_pxy2
>>>> > Running: coordinator master coord1
>>>> > Not running: coordinator master coord2
>>>> > Running: datanode master datanode1
>>>> >
>>>> > Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
>>>> > mydatabase) but its not allowing me to modify table structure. and
>>>> giving me
>>>> > below error.
>>>> >
>>>> > mydatabase=#  alter table invoice_summary_data add countrycode text
>>>> not null
>>>> > default ''::character(1);
>>>> > ERROR:  Failed to get pooled connections
>>>> > CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
>>>> > pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>>>> >
>>>> > So as of now i am planning to remove those components which are not
>>>> working
>>>> > (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>>>> >
>>>> > what will be the impact of this, i don't want to loost database access
>>>> > completely.
>>>> >
>>>> > Please suggest.
>>>> >
>>>> > Regards
>>>> > Juned Khan
>>>> >
>>>>   >
>>>> ------------------------------------------------------------------------------
>>>> > "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...
>>>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>>> >
>>>>
>>>
>>>
>>>
>>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

Did you have any more messages to the log file of the node (both coordinator and datanode)?  Maybe you have some extra messages in the server log at the coordinator.


---
Koichi Suzuki

2014/05/07 16:03、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope it didn't

astpp=# SELECT pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

astpp=# \q
PGXC  pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Hmm, did pgxc_pool_reload() work?
---
Koichi Suzuki

2014/05/07 14:33、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

PGXC pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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/>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

here is the logs
coord
LOG:  failed to connect to Datanode
WARNING:  can not connect to node 16384
LOG:  failed to acquire connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
ERROR:  Failed to get pooled connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE

datanode:
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set




On Wed, May 7, 2014 at 12:39 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Did you have any more messages to the log file of the node (both
> coordinator and datanode)?  Maybe you have some extra messages in the
> server log at the coordinator.
>
>
> ---
> Koichi Suzuki
>
>  2014/05/07 16:03、Juned Khan <jkh...@gm...> のメール：
>
>  nope it didn't
>
> astpp=# SELECT pgxc_pool_reload();
>  pgxc_pool_reload
> ------------------
>  t
> (1 row)
>
> astpp=# \q
> PGXC  pg_dumpall -h db02 > dumpall.sql
> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
> connections
> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
> SHARE MODE
> pg_dumpall: pg_dump failed on database "astpp", exiting
>
>
>
> On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...> wrote:
>
>> Hmm, did pgxc_pool_reload() work?
>> ---
>> Koichi Suzuki
>>
>>  2014/05/07 14:33、Juned Khan <jkh...@gm...> のメール：
>>
>>  PGXC pg_dumpall -h db02 > dumpall.sql
>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>> connections
>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
>> SHARE MODE
>> pg_dumpall: pg_dump failed on database "astpp", exiting
>>
>>
>>
>> On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...> wrote:
>>
>>> What error did you have?
>>> ---
>>> Koichi Suzuki
>>>
>>>  2014/05/07 14:18、Juned Khan <jkh...@gm...> のメール：
>>>
>>>   yeah i tried to restart the coord2 and gtm_pxy2 but no success.
>>>  I have tried to take pg_dumpall but its giving me same error.
>>>
>>>  please suggest.
>>>
>>>  Regards
>>>  Juned Khan
>>>
>>> On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...> wrote:
>>>
>>>> Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to
>>>> use pg_dumpall, not pg_dump unless you’re backing up single database.
>>>>  I’m afraid coord2 had had some issue.
>>>>
>>>>  Regards;
>>>> ---
>>>> Koichi Suzuki
>>>>
>>>>  2014/05/06 21:50、Juned Khan <jkh...@gm...> のメール：
>>>>
>>>>   nope i have directly did those steps on live server. I don't know
>>>> exactly what cause that problem. one day i just tried to run some queries
>>>> manually and got those errors.
>>>>
>>>>  I have tried to restart all components several times without success.
>>>>
>>>>  now another problem is i am not able to take dump of database. i am
>>>> getting this error.
>>>>
>>>> postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
>>>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>>>> connections
>>>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN
>>>> ACCESS SHARE MODE
>>>>
>>>>  Please suggest.
>>>>
>>>>
>>>>
>>>> On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...>wrote:
>>>>
>>>>> Did you make any test before you did any action on your database?
>>>>> Also could you share what you did to have this situation?   Anyway,
>>>>> with this situation, I believe no DDL has been handled except for
>>>>> temporary object, which is session specific.
>>>>>
>>>>> So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
>>>>> reinitialize it as long as you maintain gtm_proxy.conf) and coord2.
>>>>>
>>>>> Anyway, it is very essential to record and share what you did, and
>>>>> more important thing is to test it with non-product environment and
>>>>> see what goes on, and then review any step you are taking before you
>>>>> do.
>>>>>
>>>>> Hope to have more info on this.
>>>>>
>>>>> Best Regards;
>>>>> ---
>>>>> Koichi Suzuki
>>>>>
>>>>>
>>>>>  2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...>:
>>>>>  > Hi Koichi,
>>>>> >
>>>>> > I tried to follow the steps removing datanode slave and adding it
>>>>> again but
>>>>> > i no success. even earlier only datanode slave was not working but
>>>>> now gtm
>>>>> > slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have
>>>>> removed GTM
>>>>> > slave and datanode slave
>>>>> >
>>>>> > here is my current status of pgxc
>>>>> >
>>>>> > PGXC monitor all
>>>>> > Running: gtm master
>>>>> > Running: gtm proxy gtm_pxy1
>>>>> > Not running: gtm proxy gtm_pxy2
>>>>> > Running: coordinator master coord1
>>>>> > Not running: coordinator master coord2
>>>>> > Running: datanode master datanode1
>>>>> >
>>>>> > Now each time i have to connect on db02 only( i.e PGXC Psql -h db02
>>>>> -d
>>>>> > mydatabase) but its not allowing me to modify table structure. and
>>>>> giving me
>>>>> > below error.
>>>>> >
>>>>> > mydatabase=#  alter table invoice_summary_data add countrycode text
>>>>> not null
>>>>> > default ''::character(1);
>>>>> > ERROR:  Failed to get pooled connections
>>>>> > CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
>>>>> > pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>>>>> >
>>>>> > So as of now i am planning to remove those components which are not
>>>>> working
>>>>> > (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>>>>> >
>>>>> > what will be the impact of this, i don't want to loost database
>>>>> access
>>>>> > completely.
>>>>> >
>>>>> > Please suggest.
>>>>> >
>>>>> > Regards
>>>>> > Juned Khan
>>>>> >
>>>>>   >
>>>>> ------------------------------------------------------------------------------
>>>>> > "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...
>>>>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>>>> >
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Thanks,
>> Juned Khan
>> iNextrix Technologies Pvt Ltd.
>> www.inextrix.com
>>
>>
>>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

Oh, your datanode has inconsistency.   I wonder how come.   The reason why your datanode slave does not work will be this.

From your result of pyxc_ctl monitor all command result, your datanode is still running.

What you can do is to restart stopping gtm_pxy2 and coord2.   This will not be harmful.   Please try and let me know what’s going on.   If you have a problem, please share what you get from the server log.

Regards;

---
Koichi Suzuki

2014/05/07 16:25、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

here is the logs
coord
LOG:  failed to connect to Datanode
WARNING:  can not connect to node 16384
LOG:  failed to acquire connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
ERROR:  Failed to get pooled connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE

datanode:
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set




On Wed, May 7, 2014 at 12:39 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you have any more messages to the log file of the node (both coordinator and datanode)?  Maybe you have some extra messages in the server log at the coordinator.


---
Koichi Suzuki

2014/05/07 16:03、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope it didn't

astpp=# SELECT pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

astpp=# \q
PGXC  pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Hmm, did pgxc_pool_reload() work?
---
Koichi Suzuki

2014/05/07 14:33、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

PGXC pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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/>




--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

you mean i should try to restart gtm_pxy2 and coord2. but i have already
tried to restart this components but it didn't start at all. and it also
caused other components to stop functioning. so i am very scared to do
anything with live pgxc environment.


On Wed, May 7, 2014 at 1:17 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Oh, your datanode has inconsistency.   I wonder how come.   The reason
> why your datanode slave does not work will be this.
>
>  From your result of pyxc_ctl monitor all command result, your datanode
> is still running.
>
>  What you can do is to restart stopping gtm_pxy2 and coord2.   This will
> not be harmful.   Please try and let me know what’s going on.   If you have
> a problem, please share what you get from the server log.
>
>  Regards;
>
> ---
> Koichi Suzuki
>
>  2014/05/07 16:25、Juned Khan <jkh...@gm...> のメール：
>
>   here is the logs
>  coord
> LOG:  failed to connect to Datanode
> WARNING:  can not connect to node 16384
> LOG:  failed to acquire connections
> STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
> ERROR:  Failed to get pooled connections
> STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
>
>  datanode:
> WARNING:  archive_mode enabled, yet archive_command is not set
> WARNING:  archive_mode enabled, yet archive_command is not set
> WARNING:  archive_mode enabled, yet archive_command is not set
>
>
>
>
> On Wed, May 7, 2014 at 12:39 PM, 鈴木 幸市 <ko...@in...> wrote:
>
>> Did you have any more messages to the log file of the node (both
>> coordinator and datanode)?  Maybe you have some extra messages in the
>> server log at the coordinator.
>>
>>
>> ---
>> Koichi Suzuki
>>
>>  2014/05/07 16:03、Juned Khan <jkh...@gm...> のメール：
>>
>>  nope it didn't
>>
>> astpp=# SELECT pgxc_pool_reload();
>>  pgxc_pool_reload
>> ------------------
>>  t
>> (1 row)
>>
>> astpp=# \q
>> PGXC  pg_dumpall -h db02 > dumpall.sql
>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>> connections
>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
>> SHARE MODE
>> pg_dumpall: pg_dump failed on database "astpp", exiting
>>
>>
>>
>> On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...> wrote:
>>
>>> Hmm, did pgxc_pool_reload() work?
>>> ---
>>> Koichi Suzuki
>>>
>>>  2014/05/07 14:33、Juned Khan <jkh...@gm...> のメール：
>>>
>>>  PGXC pg_dumpall -h db02 > dumpall.sql
>>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>>> connections
>>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
>>> SHARE MODE
>>> pg_dumpall: pg_dump failed on database "astpp", exiting
>>>
>>>
>>>
>>> On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...> wrote:
>>>
>>>> What error did you have?
>>>> ---
>>>> Koichi Suzuki
>>>>
>>>>  2014/05/07 14:18、Juned Khan <jkh...@gm...> のメール：
>>>>
>>>>   yeah i tried to restart the coord2 and gtm_pxy2 but no success.
>>>>  I have tried to take pg_dumpall but its giving me same error.
>>>>
>>>>  please suggest.
>>>>
>>>>  Regards
>>>>  Juned Khan
>>>>
>>>> On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...> wrote:
>>>>
>>>>> Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to
>>>>> use pg_dumpall, not pg_dump unless you’re backing up single database.
>>>>>  I’m afraid coord2 had had some issue.
>>>>>
>>>>>  Regards;
>>>>> ---
>>>>> Koichi Suzuki
>>>>>
>>>>>  2014/05/06 21:50、Juned Khan <jkh...@gm...> のメール：
>>>>>
>>>>>   nope i have directly did those steps on live server. I don't know
>>>>> exactly what cause that problem. one day i just tried to run some queries
>>>>> manually and got those errors.
>>>>>
>>>>>  I have tried to restart all components several times without success.
>>>>>
>>>>>  now another problem is i am not able to take dump of database. i am
>>>>> getting this error.
>>>>>
>>>>> postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
>>>>> pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
>>>>> connections
>>>>> pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN
>>>>> ACCESS SHARE MODE
>>>>>
>>>>>  Please suggest.
>>>>>
>>>>>
>>>>>
>>>>> On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...>wrote:
>>>>>
>>>>>> Did you make any test before you did any action on your database?
>>>>>> Also could you share what you did to have this situation?   Anyway,
>>>>>> with this situation, I believe no DDL has been handled except for
>>>>>> temporary object, which is session specific.
>>>>>>
>>>>>> So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
>>>>>> reinitialize it as long as you maintain gtm_proxy.conf) and coord2.
>>>>>>
>>>>>> Anyway, it is very essential to record and share what you did, and
>>>>>> more important thing is to test it with non-product environment and
>>>>>> see what goes on, and then review any step you are taking before you
>>>>>> do.
>>>>>>
>>>>>> Hope to have more info on this.
>>>>>>
>>>>>> Best Regards;
>>>>>> ---
>>>>>> Koichi Suzuki
>>>>>>
>>>>>>
>>>>>>  2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...>:
>>>>>>  > Hi Koichi,
>>>>>> >
>>>>>> > I tried to follow the steps removing datanode slave and adding it
>>>>>> again but
>>>>>> > i no success. even earlier only datanode slave was not working but
>>>>>> now gtm
>>>>>> > slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have
>>>>>> removed GTM
>>>>>> > slave and datanode slave
>>>>>> >
>>>>>> > here is my current status of pgxc
>>>>>> >
>>>>>> > PGXC monitor all
>>>>>> > Running: gtm master
>>>>>> > Running: gtm proxy gtm_pxy1
>>>>>> > Not running: gtm proxy gtm_pxy2
>>>>>> > Running: coordinator master coord1
>>>>>> > Not running: coordinator master coord2
>>>>>> > Running: datanode master datanode1
>>>>>> >
>>>>>> > Now each time i have to connect on db02 only( i.e PGXC Psql -h db02
>>>>>> -d
>>>>>> > mydatabase) but its not allowing me to modify table structure. and
>>>>>> giving me
>>>>>> > below error.
>>>>>> >
>>>>>> > mydatabase=#  alter table invoice_summary_data add countrycode text
>>>>>> not null
>>>>>> > default ''::character(1);
>>>>>> > ERROR:  Failed to get pooled connections
>>>>>> > CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
>>>>>> > pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>>>>>> >
>>>>>> > So as of now i am planning to remove those components which are not
>>>>>> working
>>>>>> > (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is
>>>>>> down.
>>>>>> >
>>>>>> > what will be the impact of this, i don't want to loost database
>>>>>> access
>>>>>> > completely.
>>>>>> >
>>>>>> > Please suggest.
>>>>>> >
>>>>>> > Regards
>>>>>> > Juned Khan
>>>>>> >
>>>>>>   >
>>>>>> ------------------------------------------------------------------------------
>>>>>> > "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...
>>>>>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>>>>> >
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Juned Khan
>>> iNextrix Technologies Pvt Ltd.
>>> www.inextrix.com
>>>
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Juned Khan
>> iNextrix Technologies Pvt Ltd.
>> www.inextrix.com
>>
>>
>>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

Okay.   I see.   Let me think another action to do.
---
Koichi Suzuki

2014/05/07 17:12、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

you mean i should try to restart gtm_pxy2 and coord2. but i have already tried to restart this components but it didn't start at all. and it also caused other components to stop functioning. so i am very scared to do anything with live pgxc environment.


On Wed, May 7, 2014 at 1:17 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Oh, your datanode has inconsistency.   I wonder how come.   The reason why your datanode slave does not work will be this.

From your result of pyxc_ctl monitor all command result, your datanode is still running.

What you can do is to restart stopping gtm_pxy2 and coord2.   This will not be harmful.   Please try and let me know what’s going on.   If you have a problem, please share what you get from the server log.

Regards;

---
Koichi Suzuki

2014/05/07 16:25、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

here is the logs
coord
LOG:  failed to connect to Datanode
WARNING:  can not connect to node 16384
LOG:  failed to acquire connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
ERROR:  Failed to get pooled connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE

datanode:
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set




On Wed, May 7, 2014 at 12:39 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you have any more messages to the log file of the node (both coordinator and datanode)?  Maybe you have some extra messages in the server log at the coordinator.


---
Koichi Suzuki

2014/05/07 16:03、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope it didn't

astpp=# SELECT pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

astpp=# \q
PGXC  pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 12:29 PM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Hmm, did pgxc_pool_reload() work?
---
Koichi Suzuki

2014/05/07 14:33、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

PGXC pg_dumpall -h db02 > dumpall.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

nope i have directly did those steps on live server. I don't know exactly what cause that problem. one day i just tried to run some queries manually and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi Koichi,
>
> I tried to follow the steps removing datanode slave and adding it again but
> i no success. even earlier only datanode slave was not working but now gtm
> slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
> slave and datanode slave
>
> here is my current status of pgxc
>
> PGXC monitor all
> Running: gtm master
> Running: gtm proxy gtm_pxy1
> Not running: gtm proxy gtm_pxy2
> Running: coordinator master coord1
> Not running: coordinator master coord2
> Running: datanode master datanode1
>
> Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
> mydatabase) but its not allowing me to modify table structure. and giving me
> below error.
>
> mydatabase=#  alter table invoice_summary_data add countrycode text not null
> default ''::character(1);
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
>
> So as of now i am planning to remove those components which are not working
> (gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.
>
> what will be the impact of this, i don't want to loost database access
> completely.
>
> Please suggest.
>
> Regards
> Juned Khan
>
> ------------------------------------------------------------------------------
> "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/>




--
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/>