hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex (Oleksandr) Diachenko" <odiache...@pivotal.io>
Subject Re: HAWQ upgrade command
Date Wed, 15 Feb 2017 02:13:30 GMT
Hi Lili and Hubert,

I was testing my changes to upgrade HAWQ from HDB 2.0.0.0 to
HDB-2.2.0.0(current master), with my changes in the scope of HAWQ-1314.
It went through, so no worries.

Regards, Alex.

On Sun, Feb 12, 2017 at 7:35 PM, Hubert Zhang <hzhang@pivotal.io> wrote:

> Hi Alex,
>   There is an known issue if you init the system between commit 787c096 and
>  commit 1866a93(Nov 22-Nov25 2016). Could you please check the proargtypes
> of function gp_relfile_insert_for_register in pg_proc by the following
> steps:
>
>    - select oid,* from pg_proc where proname
>    ='gp_relfile_insert_for_register';
>    - \c template1
>    - select oid,* from pg_proc where proname
>    ='gp_relfile_insert_for_register';
>
>
> On Mon, Feb 13, 2017 at 10:57 AM, Lili Ma <lma@pivotal.io> wrote:
>
> > Hi Alex,
> >
> > Could you tell the original version and to-be-upgraded version of HAWQ,
> so
> > that we can try to reproduce it?
> >
> > Thanks
> > Lili
> >
> > On Sat, Feb 11, 2017 at 10:27 AM, Alex (Oleksandr) Diachenko <
> > odiachenko@pivotal.io> wrote:
> >
> > > Hi,
> > >
> > > I saw HAWQ-1171 was merged to master recently, and I am trying to
> figure
> > > out how it works.
> > > The scripts drops gp_relfile_insert_for_register procedure if it exists
> > and
> > > creates it again using latest signature.
> > >
> > > I tried it out and it worked for me in a case when
> > > gp_relfile_insert_for_register doesn't exist.
> > > But in case when gp_relfile_insert_for_register exist I am getting:
> > >
> > > *ERROR:  cannot drop function
> > > gp_relfile_insert_for_register(oid,oid,oid,oid,oid,
> > > cstring,character,character,oid)
> > > because it is required by the database system*
> > >
> > > Is it even intended to be run when procedure exists? Do I have to set
> any
> > > GUCs to make it work?
> > >
> > > Regards, Alex.
> > >
> >
>
>
>
> --
> Thanks
>
> Hubert Zhang
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message