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 package
was needed for the "ltree" to work (accepted inside psql command line).
However, I now get an error in the testcases;
<failure message="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 <pg_install_dir>/share/contrib/ltree.sql script or
command 'CREATE EXTENSION ltree;')."
type="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
<pg_install_dir>/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=# CREATE EXTENSION ltree;
CREATE EXTENSION
postgres=# \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 <[email protected]> wrote:
So, I ran integration tests and everything is stable except indexing-sql.
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 écrit :
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 (Derby,
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/pass
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 of
these services (https://github.com/eskatos/zest-docker-testbed). It's
completely outdated now. I do have a very limited connection these days
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.