HSQLDB server prevents shutdown and restart

[Bruno Medeiros]

Every time I try to logout, my system gets back to the login screen. After some investigation using the information provided on the bug #838792, I could find out that the bug is caused by the HSQLDB Server. Here is the output of my ck-list-sessions when the bug is about to happen:

bruno.medeiros@brunojcm-notebook:~$ ck-list-sessions
Session19:
 unix-user = '1001'
 realname = 'Bruno Medeiros'
 seat = 'Seat1'
 session-type = ''
 active = TRUE
 x11-display = ':0'
 x11-display-device = '/dev/tty7'
 display-device = ''
 remote-host-name = ''
 is-local = TRUE
 on-since = '2013-03-12T00:12:39.202403Z'
 login-session-id = '4294967295'
Session2:
 unix-user = '128'
 realname = 'HSQLDB system user'
 seat = 'Seat1'
 session-type = ''
 active = FALSE
 x11-display = ''
 x11-display-device = ''
 display-device = '/dev/???'
 remote-host-name = ''
 is-local = TRUE
 on-since = '2013-03-11T14:35:41.265747Z'
 login-session-id = '4294967295'

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[John Agombar (78luphr0rnk2nuqimstywepozxn9kl19tqh0tx66b5dki1xxsh5mkz9gl21a5rlwfnr8jn6ln0m3jxne2k9x1ohg85w3jabxlrqbgszpjpwcmvkbcvq9spp6z3w5j1m33k06tlsfszeuscyt241ha-launchpad-a811i2i3ytqlsztthjth0svbccw8inm65tmkqp9sarr553jq53in4xm1m8wn3o4rlwaer06ogwvqwv9mrqoku2x334n7di44o65qze67n1wneepmidnuwnde1rqcbpgdf70gtqq2x9thj5tlcsac1)]

After some more investigation I found that if I did
 sudo /etc/init.d/hsqldb-server stop
before shutting down then the shutdown would complete fine.

Yet more investigation revealed that editing /etc/hsqldb.conf and setting
HSQLDB_OWNER=my_id
and changing the owner and group of the database directory and files in
/var/lib/hsqldb
to my_id allowed the shutdown to complete successfully without the forced stop of the server above.

Hope that these might help....