java compiler_error on startup

[preske87]

java compiler_error on startup

[vigorouscoding]

From the log output I can tell that the schema compilation fails with an obscure error message.

If you could provide us access to the database (preferably as a copy), I could debug this on my machine to see where the problem is and how to solve it.

[preske87]

Sure.
How can I reach out to you (Email?).
How can I get a database copy?

[vigorouscoding]

If you are using our docker setup (from https://github.com/structr/docker-setup), the default configuration for the database files is that they should be written to ./volumes/neo4j-database. Creating a ZIP file of that complete folder would be perfect I think.

I'll send you an email so we can exchange the files.

[vigorouscoding]

Thanks for supplying the database - with it I was able to find the problem.

There is a bug in the schema validation - one of the enum properties contains values which are protected keywords in Java and thus compilation fails. But at runtime this only throws an error when the compilation fails, but the change is still saved.

You can fix this by renaming the enum values of the Gateway type with the following query in the neo4j browser.
I only added a _ as a prefix, you could also capitalize the values or change them another way.

MATCH (n { id: "11ecbe150e6645d28be2222407170b1d" })
    set n.format = '_public,_private,_unknown' RETURN n

Again, thank you for helping us find that bug! We will fix the compilation issue - but those Java keywords will still be reserved and will result in a compilation failure. The error handling will improve though.

[preske87]

Hi.
we unfortunately do not have access to the neo4j browser due to firewall rules.

Any alternative to get this fixed? I have ssh access to the docker host, but no http to neo4j.

[vigorouscoding]

SSH access to the docker host should work as well. You could use cypher-shell, log in with the database credentials and issue the same query. The only difference in cypher-shell is that the command has to be terminated with ;

[preske87]

So did I

ubuntux@ubuntu-docker:/docker$ sudo docker-compose exec structr_neo4j cypher-shell
username: neo4j
password: xxxx
Connected to Neo4j using Bolt protocol version 4.4 at neo4j://localhost:7687 as user neo4j.
Type :help for a list of available commands or :exit to exit the shell.
Note that Cypher queries must end with a semicolon.
neo4j@neo4j> 
neo4j@neo4j> 
neo4j@neo4j> MATCH (n { id: "11ecbe150e6645d28be2222407170b1d" })
                 set n.format = '_public,_private,_unknown' RETURN n;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| (:SchemaReloadingNode:AbstractNode:NodeInterface:AccessControllable:SchemaProperty:PropertyDefinition {hidden: FALSE, indexed: TRUE, notNull: FALSE, lastModifiedDate: 1669822583453, defaultValue: "", lastModifiedBy: "a6995a4bf83d41f594b759fdac3ef85e", dbName: "", format: "_public,_private,_unknown", visibleToAuthenticatedUsers: FALSE, visibleToPublicUsers: FALSE, type: "SchemaProperty", compound: FALSE, createdDate: 1669822558995, createdBy: "a6995a4bf83d41f594b759fdac3ef85e", isCachingEnabled: FALSE, unique: FALSE, propertyType: "Enum", name: "apn_type", id: "11ecbe150e6645d28be2222407170b1d"}) |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row
ready to start consuming query after 52 ms, results consumed after another 88 ms
Set 1 properties
neo4j@neo4j> :exit

Bye!

Structr some seconds after....

structr_1                      | 2022-12-10 11:18:09.932 [main] INFO  org.structr.core.Services - 5 service(s) processed
structr_1                      | 2022-12-10 11:18:09.932 [main] INFO  org.structr.core.Services - Registering shutdown hook.
structr_1                      | 2022-12-10 11:18:09.932 [main] INFO  org.structr.core.Services - Started Structr 4.3-SNAPSHOT 2872d 202210071329
structr_1                      | 2022-12-10 11:18:09.932 [main] INFO  org.structr.core.Services - ---------------- Initialization complete ----------------

We're back online, hurray.