Knowledge Drop

Error starting Looker. See log file for details.


Userlevel 3
Badge

Last tested: Nov 17, 2017
 

Chat tip: In general, try stopping looker then check if the java process is running. If it is, kill it and try again.

Search the log file for ERROR. Below are some errors and the ways to fix them (at the time of this writing there is just one that I know of)

Error starting Looker: Java::JavaSql::SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@14e27af2[file =/Users/user/looker/.db/looker.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-11-17 20:15:56 heartbeat - read: -2460 ms.

 

This usually means that Looker was shut down improperly. When I encountered this, I had previously shut down my computer without stopping Looker. This created a looker.lck file that prevented looker from starting.

Steps to resolve (assumes you are in the looker directory):

  • run ./looker stop
  • run ps aux | grep java to see if Looker is still running
    • if Looker is running, run pkill -9 java
  • delete the lock file: rm .db/looker.lck
  • start Looker: ./looker start

 

This content is subject to limited support.                

 

 


2 replies

Thanks for your post, very helpful!

I had similar issue, but not able to kill the java, even using sudo command (also tried to restart VM). any suggestions?

 

Userlevel 3
Badge

Hey Chris! I’m not sure, but you can reach out to our support team to see if they have any suggestions. Bonus points for posting back here with the answer!

Reply