Mailing-List: contact dev-help@zest.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@zest.apache.org
MIME-Version: 1.0
Sender: hedhman@gmail.com
In-Reply-To: <CADmm+KfNQPNZmHfGnUHho=fW=1fk0yvTHgA38KPjisc6ChzuJw@mail.gmail.com>
References: <CADmm+KeRTRvuVzoXhkES4tydxShNEJBwtwqYRMqs=3+s-XRBVQ@mail.gmail.com>
 <580DD473.8030501@nosphere.org> <580DF49F.30506@nosphere.org>
 <CADmm+KfSMrGDSN2m_fR1_XjfKPWAemf2b-cVBc1ft8z042_fRg@mail.gmail.com>
 <c73d7e4a-9da1-c01d-cd2b-79a4f0d2e657@zest.mail.kapsi.fi> <CADmm+KfNQPNZmHfGnUHho=fW=1fk0yvTHgA38KPjisc6ChzuJw@mail.gmail.com>
From: Niclas Hedhman <niclas@hedhman.org>
Date: Mon, 24 Oct 2016 20:23:02 +0800
Message-ID: <CADmm+KcaWhLkXQE=YCTDEKEUK56u0vzMvd_EyApTSfFnCDg90Q@mail.gmail.com>
Subject: Re: [WARNING] Unstable 'develop' branch
To: dev <dev@zest.apache.org>
Content-Type: multipart/alternative; boundary=001a11c1494a431c6a053f9b756f
archived-at: Mon, 24 Oct 2016 12:23:30 -0000

--001a11c1494a431c6a053f9b756f
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Caused by: org.postgresql.util.PSQLException: ERROR: type
&quot;ltree&quot; does not exist
  Position: 55
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx=
ecutorImpl.java:2453)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor=
Impl.java:2153)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja=
va:286)

Is there an easy way to test ltree presence with the psql command line?


On Mon, Oct 24, 2016 at 8:20 PM, Niclas Hedhman <niclas@hedhman.org> wrote:

> Ah, I see...
>
> stmt.execute( this._vendor.toString( d
>     .createTableDefinitionBuilder()
>     .setTableScope( TableScope.LOCAL_TEMPORARY )
>     .setTableName( t.tableName( "ltree_test" ) )
>     .setCommitAction( PgSQLTableCommitAction.DROP )
>     .setTableContentsSource(
>         d.createTableElementListBuilder()
>         .addTableElement(
>             d.createColumnDefinition( "test_column", dt.userDefined( "ltr=
ee" ) ) )
>         .createExpression() ).createExpression() ) );
>
>
> is the code executed and ANY SQLException will cause my InternalError, an=
d
> SQLException is not shown. Adding the root cause and running again.
>
>
>
> On Mon, Oct 24, 2016 at 8:16 PM, Stanislav Muhametsin <
> stanislav.muhametsin@zest.mail.kapsi.fi> wrote:
>
>> On 24.10.2016 15:05, Niclas Hedhman wrote:
>>
>>> I managed to install postgres locally and set up according to your
>>> instructions. I even needed to figure out that postgresql-contrib packa=
ge
>>> was needed for the "ltree" to work (accepted inside psql command line).
>>>
>>>
>>> However, I now get an error in the testcases;
>>>
>>> <failure message=3D"java.lang.InternalError: It seems that your databas=
e
>>> doesn't have ltree as type. It is needed to store collections. Please
>>> refer to hopefully supplied instructions on how to add ltree type
>>> (hint: run &lt;pg_install_dir&gt;/share/contrib/ltree.sql script or
>>> command 'CREATE EXTENSION ltree;')."
>>> type=3D"java.lang.InternalError">java.lang.InternalError: It seems that
>>> your database doesn't have ltree as type. It is needed to store
>>> collections. Please refer to hopefully supplied instructions on how to
>>> add ltree type (hint: run
>>> &lt;pg_install_dir&gt;/share/contrib/ltree.sql script or command
>>> 'CREATE EXTENSION ltree;').
>>>
>>>
>>> root@devdesk:~# su postgres
>>> postgres@devdesk:/root$ psql
>>> could not change directory to "/root": Permission denied
>>> psql (9.4.9)
>>> Type "help" for help.
>>>
>>> postgres=3D#  CREATE EXTENSION ltree;
>>> CREATE EXTENSION
>>> postgres=3D# \q
>>>
>>>
>>> Any ideas??
>>>
>>
>> Indexing-SQL uses some SQL command to test whether ltree extension is
>> installed.
>> I totally forgot what is the command, and I can not access Zest codebase
>> right now.
>>
>> Can you see the root cause via debugger, the first exception that is
>> thrown, most likely causes this.
>> It *might* be that the exception is something else, but the Indexing-SQL
>> *thinks* it is because of failing ltree-test.
>>
>>
>>
>>
>>
>>>
>>>
>>> On Mon, Oct 24, 2016 at 7:46 PM, Paul Merlin <paul@nosphere.org> wrote:
>>>
>>> So, I ran integration tests and everything is stable except indexing-sq=
l.
>>>>
>>>> A lot of the query tests fail.
>>>> Something about mapping Identity to String is incomplete.
>>>>
>>>> I've attached the tests result report to ZEST-180 and pointed to the
>>>> test setup instruction there.
>>>>
>>>>
>>>> Paul Merlin a =C3=A9crit :
>>>>
>>>>> Niclas,
>>>>>
>>>>> The Identity change is quite massive, and affects many tests,
>>>>>>
>>>>> especially in
>>>>
>>>>> the Entity Stores and Indexing/Query subsystems.
>>>>>>
>>>>>> The changes builds on my local Linux system, but I notice that Redis
>>>>>> and
>>>>>> Riak (others?) test suites are disabled, and I have not look into
>>>>>> making
>>>>>> them run locally. So there may still be issues, and I am not at all
>>>>>> surprised if the CI will fail.
>>>>>>
>>>>>> And I need to go to sleep now, so it may take a couple of days for
>>>>>> this
>>>>>>
>>>>> to
>>>>
>>>>> stabilize.
>>>>>>
>>>>>> Cheers
>>>>>>
>>>>> All integration tests that depend on external services are skipped if
>>>>> they can't reach the corresponding external service.
>>>>>
>>>>> For most of them, simply running the service with the default
>>>>> configuration is enough (Memcached, Redis, Riak, MongoDB).
>>>>>
>>>>> The SQL EntityStore is always tested against embedded databases (Derb=
y,
>>>>> H2, SQLite). If a MySQL or PostgreSQL service is available it will be
>>>>> tested against them too. The SQL Index/Query is only tested against
>>>>> PostgreSQL if available. PostgreSQL needs some special setup (user/pa=
ss
>>>>> and some extension for indexing, documented in the corresponding
>>>>>
>>>> extension).
>>>>
>>>>> The CI do not run any of these external services.
>>>>>
>>>>> Three years ago I did start creating a Docker image with almost all o=
f
>>>>> these services (https://github.com/eskatos/zest-docker-testbed). It's
>>>>> completely outdated now. I do have a very limited connection these da=
ys
>>>>> so I won't be able to update it soon. But I have all the services
>>>>> locally so I'll try and run the integration tests to see if something
>>>>>
>>>> broke.
>>>>
>>>>> Ideally we should build such a Docker image during the build and run
>>>>> the
>>>>> test suite into it on CI.
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>
>
> --
> Niclas Hedhman, Software Developer
> http://zest.apache.org - New Energy for Java
>


--=20
Niclas Hedhman, Software Developer
http://zest.apache.org - New Energy for Java

--001a11c1494a431c6a053f9b756f--