I think we should rather find and fix the root cause why stopping the service via sc does make an unclean shutdown.
Michael On Sun, Jun 1, 2014 at 11:01 PM, Jim Salmons <jim.salm...@softalkapple.com> wrote: > Thanks for the pointer to that technique, Chris. None of my databases ATM > are so critical that it is a show-stopper for me, but I figure it is good > to surface the issue in the event that others with critical needs get > bitten. > > Now that I've looked at the situation a bit, too, it appears that a > possible 'fix' would be to silently call the shell and do the exit before > asking 'sc' to stop the Windows Service. I'm going to look at incorporating > that approach into my Neo4jCP (mini Control Panel, > https://github.com/Jim-Salmons/neo4jcp) and if that looks promising, we > might want to see if a similar approach in the Neo4jInstaller.bat file > would avoid this situation. > > ITMT, you might want to consider a Heads-up note somewhere in the Update > 2.0-.2.1 notes that points this situation out and provides the recommended > work-around. > > Thanks again, > --Jim-- > > > On Sunday, June 1, 2014 12:45:18 PM UTC-5, Chris Vest wrote: > >> You can, after you’ve shut down the Neo4j Windows service, use >> neo4j-shell with the `-path <dir>` option to start a non-service Neo4j >> instance and then do a clean shutdown with the `exit` command. You should >> then be able to upgrade. >> >> I don’t know why there is this problem with shutting down the Windows >> service. >> >> -- >> Chris Vest >> System Engineer, Neo Technology >> [ skype: mr.chrisvest, twitter: chvest ] >> >> >> On 31 May 2014, at 23:09, Jim Salmons <jim.s...@softalkapple.com> wrote: >> >> This issue has surfaced a number of times in various flavors, >> particularly when an explicit upgrade (non-automatic requiring >> "allow_store_upgrade=true") is involved and the culprit seems to be this: >> >> - If you run Neo4j as a Windows Service (having installed via >> Neo4jInstaller.bat and using recommended start/stop 'sc' commands, etc.) >> there is no way to do a clean shutdown of a database. >> >> (As long as no upgrade is involved, apparently Neo4j running as a Windows >> Service can start, stop, and restart databases with no problem (although >> the message logs reveal that a non-clean shutdown has been silently been >> detected and addressed on restart). >> >> In the past, it has been suggested that this issue was from "jumping the >> gun" of not letting the Neo4j-Server instance shut down completely before >> restarting the Neo4j-Server Windows Service. But that is not the case. >> >> To test the basic situation I did this with the same results on both 2.0 >> and 2.1: >> >> 1. Create an empty graph.db directory in my Neo4j data directory, >> then start the Neo4j-Server Windows Service instance. >> 2. Observe the fresh database being made. Make a copy of the >> messages.log (called messages_onCreation.log >> 3. Stop the Neo4j-Server Windows Service... wait, wait... wait >> (longer than necessary) >> 4. Compare the two messages logs... the same, no stopping messages. >> 5. Delete the message.log and start the Neo4j-Server Windows Service. >> 6. Observe the database directory during restart. Make a copy of the >> new messages.log (called messages_on2ndStart.log >> >> With no activity other than to create it, stop it, and then start it back >> up the messages.log shows multiple messages about detecting a non-clean >> shutdown. (The number of non-clean detection issues in the log depend on >> the Neo4j version being run.) >> >> In the past, the recommendation was to use the deprecated Gremlin shell >> to do g.shutdown() then exit. But this doesn't seem to be (readily) >> available. >> >> QUESTION 1: Does anyone know of a way to cleanly shut down a Neo4j >> database running under a Windows Service configuration? >> >> QUESTION 2: Has anyone running Neo4j-Server as a Windows Service >> successfully upgraded a 2.0 DB to 2.1? If so, how? >> >> I'm hoping to get a quick helpful reply or additional insights here >> before posting a question to S/O. Once I fully understand this issue, if it >> still appears that the fundamental problem is the Windows Service not >> cleanly shutting down, I'll enter an issue to this effect on the Neo4j >> GitHub Issue queue. >> >> Thanks, >> --Jim-- >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to neo4j+un...@googlegroups.com. >> >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
