Error starting Looker: Java::JavaLang::ArrayIndexOutOfBoundsException

Knowledge Drop

Last tested: Mar 28, 2019
 

The Error

When trying to start up a self-hosted Looker after an update, the following error is shown:

2019-03-26 16:18:14.441 -0400 [ERROR|007d0|db:looker] :: Java::JavaLang::ArrayIndexOutOfBoundsException: 5: SELECT * FROM `setting` WHERE (`key` = 'license_key') LIMIT 1

2019-03-26 16:18:14.444 -0400 [ERROR|007d0|main] :: Error starting Looker: Java::JavaLang::ArrayIndexOutOfBoundsException: 5

2019-03-26 16:18:14.490 -0400 [WARN|007d0|ruby:stderr] ::

Possible Solutions

Update backend mysql

MySQL 5.6 doesn't work as of for a commit we've implemented, you need to upgrade it to 5.7.

(MARIADB) turn off query_cache_type

Looker changed the Mariadb driver to connect to the internal database starting in version 6.4. A similar error is cited here. After checking output of user's show variables & comparing it to ours in master , we noticed that:

THEIRS OURS

query_cache_type ON query_cache_type OFF

So in some cases after changing that setting on the Mysql DB side to match ours, it worked!

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 06:18 PM
Updated by: