Re: [Postgres-xc-general] Problem with taking database dump with pgxc-1.2.1

[Masataka S. <pg...@gm...>]

On 17 June 2014 17:07, 鈴木 幸市 <ko...@in...> wrote:
> This came in 1.2.   pg_dump runs as a single transaction so it looks okay.

No, the isolation level is changed even before 1.1. The location of
statement block is moved from main to setup_connection and appended
READ ONLY attribute, but REPEATABLE READ or SERIALIZABLE level has
been used.
I thought it intend to protect from other concurrent transaction, and
removing it brings something wrong.

Are we ever seeing such error after Pavan's patch? He get rid of "READ
ONLY" from isolation level if the remote version is equal or higher
than PG9.1 (and XC 1.0 is based on PG9.1.)

> ---
> Koichi Suzuki
>
> 2014/06/17 16:31、Masataka Saito <pg...@gm...> のメール：
>
>> On 17 June 2014 10:05, 鈴木 幸市 <ko...@in...> wrote:
>>> Year, it’s XC bug.   Because of the sequence handling difference from PG,
>>> transaction should not be read-only.   Please try the attached patch.   It
>>> will go to 1.2 and master tree if it works.
>>
>> Your patch looks skipping to set transaction isolation level. Is it OK
>> to continue with READ COMMITTED transaction?
>>
>>>
>>> Hope it helps.
>>>
>>> Regards;
>>> ---
>>> Koichi Suzuki
>>>
>>> 2014/06/17 4:25〠Aaron Jackson <aja...@re...> 㠮メール：
>>>
>>> So, I tried the same thing and applied this patch.  I even verified that it
>>> was setting the transaction mode to "serializable, read only, deferrable" -
>>> yet the problem persists.  I believe my execution is similar to the OP.
>>>
>>> pg_dump -d analysisdb --serializable-deferrable
>>>
>>> pg_dump: [archiver (db)] query failed: ERROR:  cannot execute nextval() in a
>>> read-only transaction
>>> pg_dump: [archiver (db)] query was: SELECT
>>> pg_catalog.nextval('customtype_customtypeid_seq');
>>>
>>> Did I miss something else?
>>>
>>> Aaron
>>>
>>> ________________________________
>>> From: Juned Khan [jkh...@gm...]
>>> Sent: Friday, April 11, 2014 2:05 AM
>>> To: Pavan Deolasee
>>> Cc: Postgres-XC mailing list
>>> Subject: Re: [Postgres-xc-general] Problem with taking database dump with
>>> pgxc-1.2.1
>>>
>>> Thanks to Pavan and Koichi for your inputs.
>>>
>>> So i think as of now i do not need to worry about
>>> this
>>>
>>>
>>>
>>>
>>> On Fri, Apr 11, 2014 at 12:31 PM, Pavan Deolasee <pav...@gm...>
>>> wrote:
>>>
>>> On Fri, Apr 11, 2014 at 12:07 PM, Juned Khan <jkh...@gm...> wrote:
>>>
>>> As of now this fix worked fine for me. is there any side effect of this
>>> patch ?
>>>
>>>
>>> IMV there won't be any significant side effect of the patch. pg_dump used to
>>> run in RW mode till we fixed it in 9.3.  If it has worked for so many years,
>>> it may work for some more time too :-) Marking pg_dump READ ONLY was exactly
>>> to catch bugs like these. But other than that, I think its OK.
>>>
>>> Thanks,
>>> Pavan
>>>
>>> --
>>> Pavan Deolasee
>>> http://www.linkedin.com/in/pavandeolasee
>>>
>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Juned Khan
>>> iNextrix Technologies Pvt Ltd.
>>> www.inextrix.com
>>> ------------------------------------------------------------------------------
>>> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
>>> Find What Matters Most in Your Big Data with HPCC Systems
>>> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
>>> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
>>> http://p.sf.net/sfu/hpccsystems_______________________________________________
>>>
>>> Postgres-xc-general mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
>>> Find What Matters Most in Your Big Data with HPCC Systems
>>> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
>>> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
>>> http://p.sf.net/sfu/hpccsystems
>>> _______________________________________________
>>> Postgres-xc-general mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>>
>>
>