Database failed to start: DB [database-02706ad0-a3b6-4e2f-a67e-457b608eb3ac] 'v3.5.14' exited with status 'KILLED'. Check the logs

[hristian_h_hris]

Hi,

Pleace help me. When i start my graph, it appears the error in the title. What should i do, i really need that for my bachelor thesis and would be very happy if someone can write me. I have tried to restart the programm, but nothing.. I also have raed the advices in the forum and tried to follow then, but nothing

[Cobra]

Hello @hristian.h.hristov,

Did you try to recreate the database?

Regards,
Cobra

[hristian_h_hris]

Hi,@Cobra
I have tried to restart my computer, because one of the advices was to do that. Nothing. I am not a programmierer, therefor i do not know what means recreate a date base. I am afraid that i lost the data i have created before, 108 nodes and 120 relationships .. can you connect with me on my gmail or facebook

gmail: hristian.h.hristov@gmail.com
facebook: Hristiyan Hristov

[Cobra]

When I said recreate the database, I mean create a new database:) Your database looks very small so it should be quick:)

Regards,
Cobra

[Cobra]

First of all, you should defenitly create a cypher script to recreate your database anytime

This error happened to me when

• I updated Neo4j Desktop or a Neo4j Database when it was running
• I upgraded a Neo4j Database when it was running

Before you close Neo4j Desktop or do an update, you must close the database properly

Sorry, but I don't provide help outside of this forum

Regards,
Cobra

[Cobra]

Which version of Neo4j Desktop are you using and what is the version of your database?
Where did you find the data that you put in your database?

By script I mean a file where you can write all cypher requests you used to put the data in it, like this in the future you will just have to copy pasta cypher requests in Neo4j Desktop, you can even save these requests in Neo4j Desktop

Regards,
Cobra

[hristian_h_hris]

Hi Cabra

The version of the data base is 3.5.14 and the version of the desktop is 4. I interned the database manually, that were the CVS of persons, name, age, education, university etc.

Now when I don't have an access to the graph, starting it, but I although see that there are created nodes and relationships, can i recreate my database that i entered before.

How can I create this Cypher script, that must be done before starting the work with Neo4j, at very the beginning?

Regards

На сб, 6 юни 2020 г., 15:54 Maxime via Neo4j Online Community <neo4jcommunity@discoursemail.com> написа:

[Cobra]

Neo4j Desktop version is something like 1.2.8 not 4

Do you use Neo4j Server or a local database created in Neo4j Desktop?

How did you import your data in the database?

Regards,
Cobra

[hristian_h_hris]

Cobra:

create a cypher script

oh, you are right, the version is 1.2.4. I use local data base, i think so. I import my data manually, for example i write the code create ( p:Person{ name"Jack") etc.

[Cobra]

I see

• First update Neo4j Desktop to the last version
• After, create a local database with the latest version of Neo4j (4.0.4)
• To finish, in a text file, write all cypher requests you are using to import your data Like this if it happens again, you will just have to copy pasta everything at the same time

Regards,
Cobra

[Cobra]

Yes, just open a txt file and put your requests in it It will be the easiest way for you

Regards,
Cobra

[irler_clesius]

Hello Hristian,
I already had this error sometimes. and I found a workaround, similar to the advice from Cobra:

1. exit from db (I suppose you are in Windows, in Unix it's similar set .sh instead of .bat)
2. goto the import directory (something like:C:\neo4j\neo4jDatabases\database-56ce1c35-11f6-4006-9521-dc42a79a7cd2\installation-4.0.4\import)
3. create a dump.bat file like this:

for /f "delims=" %%# in ('powershell get-date -format "{dd-MMM-yyyy.HH.mm}"') do @set _date=%%#
 ../bin/neo4j-admin.bat dump --database=neo4j --to=./mydb-%_date%.neo4j

(check if database name inside data/databases is neo4j, before 4.0 it was always graph.db, eventually set --datebase=graph.db)
4.open command prompt, do cd C:\neo4j\neo4jDatabases\database-56ce1c35-11f6-4006-9521-dc42a79a7cd2\installation-4.0.4\import
5. execute dump.bat, wait a while, should create a .neo4j file there
6. create a new database, fill it with one dummy node
7.in directory import create a load.bat:

../bin/neo4j-admin load --database=neo4j --from=./nameof dump. with data.neo4j --force

, eventually graph.db instead of neo4j, if refused
8. execute load.bat, should recreate your db.

---

this is the procedure to save my own db after the error above, I'm actually in Desktop 1.2.7 (upgrade to t.2.8 never worked) and neo4j 4.0.4
Fortunately after having opened the newly created db, all went fine,
BUT the next day I had again the same error,
first error in log: Unable to register procedure, because the name apoc.spatial.sortByDistance is already in use., I uninstalled apoc and got it again: Starting Neo4j failed: Component 'org.neo4j.server.database.LifecycleManagingDatabaseService@191ec193' was successfully initialized, but failed to start. Please see the attached cause exception "org.neo4j.graphdb.event.TransactionEventHandler
whole log file is attached
20200606-WolfgangIrler-error-log.txt (10.8 KB)

I fear I have to repeat the procedure described above, good luck for you
Hopefully, some developer reads this and find the error
WJI

[hristian_h_hris]

Thank you, Cabra, thank you irler, for the information. I will use it by working with the Neo4j. I have another question. After I create my graph I need to brenn it to CD so that my professors from the university could just see what I did. But when I write my code in a separate text file, ecerytime when I copy paste it in the Neo4j browser it shows me an error because the code is not aligned correctly. What advice would you give me?

[hristian_h_hris]

@Cabra @irler.clesius With another words, how can I align/format the code from my text file in Neo4j browser

[irler_clesius]

Hi,
what do you mean with "align"? please, paste the whole cypher error.
I suppose this is more a problem with quotes, hence check if " and ' quotes match always. A constructed code in a text editor may have another quote sequence than necessary for cypher.
BTW, in my last explanation, I forgot to mention to disable an important conf line:

Whether requests to Neo4j are authenticated.
To disable authentication, uncomment this line
dbms.security.auth_enabled=true

I was remembered this (necessary for upgrade from 3.5 to 4.0), when I repeated again my own recommendations, because without enabling, I got the former "password error".

Now for "brenning" a Cd for your professor. For visualizing a neo4j without server, I use a screenscanner to scan still images (cypher + nodes display) or still better, a short film using the neo4j browser. Alternatively you could put your db in a Neo4j sandbox and communicate the address.

[hristian_h_hris]

@irler.clesius do you know if there is an alternative way to use Neo4j. I'v heard that there is online Neo4j server, something like a cloud where I work online and there is no possibility that the data base go lost

[Cobra]

@hristian.h.hristov it's Neo4j Aura

Neo4j Graph Database Platform

Neo4j Aura: The Simplest Way to Run Neo4j in the Cloud

The world's most flexible, reliable and developer-friendly graph database as a service lets you focus on building rich, graph-powered applications.

Regards,
Cobra

[hristian_h_hris]

@Cobra that is a paid version, okey if i chose it, how much memory do i need, there is many options 1, 2, 4, 8 GB. I will create max.600 nodes and 600 relationships

[hristian_h_hris]

and one more question. At the End can i transfer the database and the visualisation to my professor ? And is that reliable?

[Cobra]

There is Neo4j sandbox that is free

I never use it but I think you can share the database after

But you should still keep a file with all your cypher requests, moreover what was the error that you got when you did it?

Regards,
Cobra

[hristian_h_hris]

I opened the Neo4j sandbox. There I clicked on a new project. Then it asks me to choose a Projekt. Which project should I choose? There are many.. Network It, Panama papers.. Etc. And afterwards when I launch it, it says that it expires in 3 days. After that I can extend for more days and. After that I cannot any more. What happens with my created data base? I will describe you my issue. I need to give my visualization to my prof till 05.07 Till then I want to create my visualization. It doesn't take much time but ecerytime appears error in the desktop and it slows me.. So, my question is, what would you recommend me. If I use the sandbox, I have max 10 days because of the expiry date. Can I longer work with the same data base. And on the end just send the visualisated data base to my prof. It is really very important for me. Thanks

[hristian_h_hris]

irler, hi

do you know good the sand box. Can you discribe me in steps what i shoud du from the beginning to the end. I tell you what i must do. I must till 05.07 give my visualization code to my prof. But i am new to the neo4j, i learned only how to code, but i don''t know how i can share this code and visualisation after that. So my question. Can i work with the neo4j sandbox and after that share my code and visualisation with my professor. In the sandbox it is said that i have only 3 days and after that i can extend only once for 7 days. What happens after that with my data base? What shoud i do. Is it completely free, should i pay after these 3+7 = 10 days are over. I deny to work with the desktop, error appears only and it slows me much.. So what would you recommend me, i would be really very grateful,

[irler_clesius]

hi,
how can we help, if you never said nothing about your problem, never named your PC, or system, never showed some code, never showed any log? It seems you don't even read the manuals and our answers. Or have you tried some advice? If so, show the results.

[irler_clesius]

hristian.h.hristov:

dump.bat file like this

Hi,
this permits to dump the db. read:
https://neo4j.com/docs/operations-manual/current/tools/dump-load/
Now the steps for a totally newbee PC user, as you seem to be:

a)open Explore file
b)select the .../import directory of your neo4j db.
c)right click inside, select new text file
d)give it the name dump.bat (eliminate the .txt extension!)
e)open this dump.bat (right click on it, select modify)
f) paste all my given file content, eventually change dbname instead of mydb
g) essential is only the second line, the first creates a filename with date
h)save dump.bat
i)"right select+copy directory name as text": the name of the directory to clipboard
j)open a command prompt (a black rectangle)
k)write "cd " + insert (ctrl-V) to change directory, must finish with ../import
l)write dump.bat + enter , wait, after some seconds you see feedback, hopefully positive
m) the directory there should be a new file with the chosen file name
n) this file can be copied in .../import of a newly created db and loaded with my load.bat file from above

Now to your nice images, it seems your goal is to create a graph with German Ceos etc. and permit an info system to identify multiple responsibilities or even incompatibilies.
The whole graph (match (n).. ) is almost useless and of doubtful privacy aspects.
Think of inverting all relationships and attach properties instead of long names; could facilitate some queries.
To show your approach to someone (professor?), build cypher queries which show for single persons or enterprises, who is responsible, something like:
match (n:Person)-[r]->(m) where id(n)=46 return n,r,m (gets 3 nodes)
Think of more complicated queries, like "who has a double post", etc.

these query result can be shown like your attached images to your tutor;

using the neo4j sandbox is not easy: you must first export your Desktop db with apoc.export.csv.all(), create in sandbox an empty db, copy/paste the csv file in the left import box and cypher: LOAD CSV WITH HEADERS FROM "file:///csvfile.csv" AS row CREATE (n:X) SET n = row
If successful, find the relationships in the last columns of the csv (perhaps in via spreadsheet), create with adequate cypher the relations, etc.

in Aura, almost identical, only to payed, GOOD LUCK, my patience id almost exhausted
WJI