Re: [Postgres-xc-developers] Query Planning bug ?

[Ashutosh B. <ash...@en...>]

Hi Tomonari,
In the output you can see a lot of test process exited with exit code 2,
which implies that there was a server crash while running the test. So,
certainly there is something wrong in the patch.

In pgxc_collect_RTE_walker()

3112         crte_context->crte_rtable =
list_concat(crte_context->crte_rtable,
3113                                                 query->rtable);

see if copying query->rtable solves the issue. The changed code would look
like

3112         crte_context->crte_rtable =
list_concat(crte_context->crte_rtable,
3113
list_copy(query->rtable));



On Tue, Jul 2, 2013 at 6:50 AM, Tomonari Katsumata <
kat...@po...> wrote:

>  Hi,
>
>   I've tried regression test, but I could not
> get right result.
> Both patched and un-patched Postgres-XC get
> same result, so I think my process is bad.
>
> I run a gtm, a gtm_proxy, a coordinator, a datanode
> in one server(CentOS6.4 x86_64 on VMWare),
> and hit "make installcheck".
>
> The configure option is [--enable-debug CFLAGS=""].
>   What is right way to run the regression test?
>
> output is below.
> ------------------------------**---------------------------
> test tablespace ... ok
> test boolean ... ok
> test char ... ok
> test name ... ok
> test varchar ... ok
> test text ... ok
> test int2 ... ok
> test int4 ... ok
> test int8 ... ok
> test oid ... ok
> test float4 ... ok
> test float8 ... ok
> test bit ... ok
> test numeric ... ok
> test txid ... ok
> test uuid ... ok
> test enum ... FAILED
> test money ... ok
> test rangetypes ... ok
> test strings ... ok
> test numerology ... ok
> test point ... ok
> test lseg ... ok
> test box ... ok
> test path ... ok
> test polygon ... ok
> test circle ... ok
> test date ... ok
> test time ... ok
> test timetz ... ok
> test timestamp ... ok
> test timestamptz ... ok
> test interval ... ok
> test abstime ... ok
> test reltime ... ok
> test tinterval ... ok
> test inet ... ok
> test macaddr ... ok
> test tstypes ... ok
> test comments ... ok
> test geometry ... ok
> test horology ... ok
> test regex ... ok
> test oidjoins ... ok
> test type_sanity ... ok
> test opr_sanity ... ok
> test insert ... ok
> test create_function_1 ... ok
> test create_type ... ok
> test create_table ... ok
> test create_function_2 ... ok
> test create_function_3 ... ok
> test copy ... ok
> test copyselect ... ok
> test create_misc ... ok
> test create_operator ... ok
> test create_index ... FAILED
> test create_view ... ok
> test create_aggregate ... ok
> test create_cast ... ok
> test constraints ... FAILED
> test triggers ... ok
> test inherit ... FAILED
> test create_table_like ... ok
> test typed_table ... ok
> test vacuum ... ok
> test drop_if_exists ... ok
> test sanity_check ... ok
> test errors ... ok
> test select ... ok
> test select_into ... ok
> test select_distinct ... ok
> test select_distinct_on ... ok
> test select_implicit ... ok
> test select_having ... ok
> test subselect ... ok
> test union ... ok
> test case ... ok
> test join ... FAILED
> test aggregates ... FAILED
> test transactions ... ok
> test random ... ok
> test portals ... ok
> test arrays ... FAILED
> test btree_index ... ok
> test hash_index ... ok
> test update ... ok
> test delete ... ok
> test namespace ... ok
> test prepared_xacts ... ok
> test privileges ... FAILED
> test security_label ... ok
> test collate ... FAILED
> test misc ... ok
> test rules ... ok
> test select_views ... ok
> test portals_p2 ... ok
> test foreign_key ... ok
> test cluster ... ok
> test dependency ... ok
> test guc ... ok
> test bitmapops ... ok
> test combocid ... ok
> test tsearch ... ok
> test tsdicts ... ok
> test foreign_data ... ok
> test window ... ok
> test xmlmap ... FAILED (test process exited with exit code 2)
> test functional_deps ... FAILED (test process exited with exit code 2)
> test advisory_lock ... FAILED (test process exited with exit code 2)
> test json ... FAILED (test process exited with exit code 2)
> test plancache ... FAILED (test process exited with exit code 2)
> test limit ... FAILED (test process exited with exit code 2)
> test plpgsql ... FAILED (test process exited with exit code 2)
> test copy2 ... FAILED (test process exited with exit code 2)
> test temp ... FAILED (test process exited with exit code 2)
> test domain ... FAILED (test process exited with exit code 2)
> test rangefuncs ... FAILED (test process exited with exit code 2)
> test prepare ... FAILED (test process exited with exit code 2)
> test without_oid ... FAILED (test process exited with exit code 2)
> test conversion ... FAILED (test process exited with exit code 2)
> test truncate ... FAILED (test process exited with exit code 2)
> test alter_table ... FAILED (test process exited with exit code 2)
> test sequence ... FAILED (test process exited with exit code 2)
> test polymorphism ... FAILED (test process exited with exit code 2)
> test rowtypes ... FAILED (test process exited with exit code 2)
> test returning ... FAILED (test process exited with exit code 2)
> test largeobject ... FAILED (test process exited with exit code 2)
> test with ... FAILED (test process exited with exit code 2)
> test xml ... FAILED (test process exited with exit code 2)
> test stats ... FAILED (test process exited with exit code 2)
> test xc_create_function ... FAILED (test process exited with exit code 2)
> test xc_groupby ... FAILED (test process exited with exit code 2)
> test xc_distkey ... FAILED (test process exited with exit code 2)
> test xc_having ... FAILED (test process exited with exit code 2)
> test xc_temp ... FAILED (test process exited with exit code 2)
> test xc_remote ... FAILED (test process exited with exit code 2)
> test xc_node ... FAILED (test process exited with exit code 2)
> test xc_FQS ... FAILED (test process exited with exit code 2)
> test xc_FQS_join ... FAILED (test process exited with exit code 2)
> test xc_misc ... FAILED (test process exited with exit code 2)
> test xc_triggers ... FAILED (test process exited with exit code 2)
> test xc_trigship ... FAILED (test process exited with exit code 2)
> test xc_constraints ... FAILED (test process exited with exit code 2)
> test xc_copy ... FAILED (test process exited with exit code 2)
> test xc_alter_table ... FAILED (test process exited with exit code 2)
> test xc_sequence ... FAILED (test process exited with exit code 2)
> test xc_prepared_xacts ... FAILED (test process exited with exit code 2)
> test xc_notrans_block ... FAILED (test process exited with exit code 2)
> test xc_limit ... FAILED (test process exited with exit code 2)
> test xc_sort ... FAILED (test process exited with exit code 2)
> test xc_returning ... FAILED (test process exited with exit code 2)
> test xc_params ... FAILED (test process exited with exit code 2)
> =========================
> 55 of 153 tests failed.
> =========================
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company