Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
Date: Thu, 10 Mar 2016 18:20:47 -0800
From: Konstantin Boudnik <cos@apache.org>
To: dev@hawq.incubator.apache.org
Subject: Re: Strange error during the db initialization
Message-ID: <20160311022047.GK17583@tpx>
Mail-Followup-To: dev@hawq.incubator.apache.org
References: <20160310053604.GC17583@tpx>
 <CAE44UQchvd_6WhH9vPzLRCKa=0Z9WVa5-E-LvKNbC1s4hkQLHw@mail.gmail.com>
 <20160310212658.GH17583@tpx>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="EVcIhgQsEzAXu06J"
Content-Disposition: inline
In-Reply-To: <20160310212658.GH17583@tpx>
User-Agent: Mutt/1.5.21 (2010-09-15)

--EVcIhgQsEzAXu06J
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Keep on digging here....=20

I spent a bit of time trying to run
  % psql -d postgres=20

because I was hitting the error where psql couldn't bind to PGSQL socket
locally, so I had to create=20
    ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

Now, the client is able to connect to the server, but I am getting this
psql (9.2.15, server 8.2.15)
WARNING: psql version 9.2, server version 8.2.
         Some psql features might not work.

which is quite weird, considering that I have built everything from the
current master's HEAD. I see that server version is hardcoded everywhere, a=
nd
the client code is checked into the code base. Is it possible these version
were intentionally made different? Any ideas what could be causing these
discrepancies?

Thanks
  Cos

On Thu, Mar 10, 2016 at 01:26PM, Konstantin Boudnik wrote:
> Ah, indeed - sysctl changed helped! Thanks for the good piece of the info.
>=20
> Cos
>=20
> On Thu, Mar 10, 2016 at 04:20PM, Lei Chang wrote:
> > Hi Konstantin,
> >=20
> > I think it is possible due to system configurations, I just added an
> > section about "system configuration" on the build and install page. you=
 can
> > have a try.
> >=20
> > https://cwiki.apache.org/confluence/display/HAWQ/Build+and+Install
> >=20
> > Cheers
> > Lei
> >=20
> >=20
> > On Thu, Mar 10, 2016 at 1:36 PM, Konstantin Boudnik <cos@apache.org> wr=
ote:
> >=20
> > > Guys,
> > >
> > > I am seeing the following debug output while running initial boot seq=
uence:
> > >
> > >   bash-4.2$ /usr/lib/hawq/bin/postgres -d 5 --boot -x0 -F -c
> > > max_connections=3D1280 -c shared_buffers=3D4000 -c max_fsm_pages=3D20=
0000 <
> > > "/dev/null"
> > >
> > >   2016-03-10 05:34:31.445003
> > > GMT,,,p32521,th-908068352,,,,0,,,seg-10000,,,,,"FATAL","42601","--boot
> > >   requires a value",,,,,,,,"PostmasterMain","postmaster.c",1023,
> > >   2016-03-10 05:34:31.445777
> > > GMT,,,p32521,th-908068352,,,,0,,,seg-10000,,,,,"DEBUG3","00000","shme=
m_exit(1):
> > >   0 callbacks to make",,,,,,,,"shmem_exit","ipc.c",195,
> > >   2016-03-10 05:34:31.446467
> > > GMT,,,p32521,th-908068352,,,,0,,,seg-10000,,,,,"DEBUG3","00000","proc=
_exit(1):
> > >   0 callbacks to make",,,,,,,,"proc_exit_prepare","ipc.c",167,
> > >   2016-03-10 05:34:31.447147
> > > GMT,,,p32521,th-908068352,,,,0,,,seg-10000,,,,,"DEBUG3","00000","exit=
(1)",,,,,,,,"proc_exit","ipc.c",132,
> > >
> > >
> > > Can't figure out what's missing. Would appreciate any pointers.
> > > Thanks in advance,
> > >   Cos
> > >
> > >


--EVcIhgQsEzAXu06J
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iF4EAREIAAYFAlbiK38ACgkQenyFlstYjhISvgD/Yaktaxtyn7z89uDFQ3i1cPxl
lRdn9AHZuX/zWOnwtC8BAIQUyqrvzANng+rNwv/qgQK64zJxpeU6rdItQq3B5l8q
=xS5T
-----END PGP SIGNATURE-----

--EVcIhgQsEzAXu06J--