package hsqldb-server 1.8.0.10-9ubuntu2 failed to uninstall: subprocess installed pre-removal script returned error exit status 1

[antoniosanct]

pangolin

uninstalling

error stopping daemon

sudo apt-get remove hsqldb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
  hsqldb-server
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 125 kB disk space will be freed.
Do you want to continue [Y/n]? Y
(Reading database ... 301766 files and directories currently installed.)
Removing hsqldb-server ...
Failed instances: [test]
WARNING: hsqldb is still running!
invoke-rc.d: initscript hsqldb-server, action "stop" failed.
dpkg: error processing hsqldb-server (--remove):
 subprocess installed pre-removal script returned error exit status 1
There is already a hsqldb server running with pid 1932.
invoke-rc.d: initscript hsqldb-server, action "start" failed.
dpkg: error while cleaning up:
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 hsqldb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

# Hsqldb Server cfg file.
# See the Advanced Topics chapter of the Hsqldb User Guide.

server.database.0 file:/~/db/test
server.dbname.0 test
server.urlid.0 test
server.silent true
server.trace false

server.port 9001
server.no_system_exit true

# Until the following setting is changed, the HSQLDB service will not accept
# remote connections. Failing to set a value for server.address at all will
# result in the service binding itself to 0.0.0.0 and accepting remote
# connections.
#
# IT IS STRONGLY ADVISED that before doing this you alter the password of
# the default account (username "sa"). By default, no password is required
# to connect to HSQLDB with the "sa" account.
server.address localhost

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: hsqldb-server 1.8.0.10-9ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-24.39-generic 3.2.16
Uname: Linux 3.2.0-24-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu7
AptOrdering: hsqldb-server: Remove
Architecture: amd64
Date: Fri May 25 01:06:08 2012
ErrorMessage: subprocess installed pre-removal script returned error exit status 1
PackageArchitecture: all
SourcePackage: hsqldb
Title: package hsqldb-server 1.8.0.10-9ubuntu2 failed to install/upgrade: subprocess installed pre-removal script returned error exit status 1
UpgradeStatus: Upgraded to precise on 2012-05-04 (19 days ago)
mtime.conffile..etc.hsqldb.server.properties: 2012-05-25T00:19:08.562617

[Launchpad Janitor (janitor)]

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

[Sebastian Schlatow (buzz-dee)]

maybe this solution works for you too:

~$ sudo service hsqldb-server start

~$ sudo apt-get purge hsqldb-server

https://bugs.launchpad.net/ubuntu/+source/hsqldb/+bug/1026546
https://bugs.launchpad.net/ubuntu/+source/hsqldb/+bug/1019387

[antoniosanct (antoniosanct)]

This solution doesn't work =(

The 'stop' script hangs before it can remove the 'hsqldb.pid' file.

Any other solution?

Thanks a lot!

[shishkander (shishkander)]

I had the same problem and it seems the `service hsqldb-server stop` fails only if the mode is WebServer.
My solution:
change /etc/hsqldb.conf mode from WebServer to Server
kill both processes Server and Websever using `kill -9 <pid>`
service hsqldb-server restart
apt-get purge hsqldb-server #now it works!

[maarten (info-maartenabbring)]

Didn't work for me. I cleared out the sections 'start' and 'stop' in the script /etc/init.d/hsqldb. Then did the sudo apt-get purge hsqldb-server and finally I got rid of this thing. Not something you want to tell an Ubuntu newbie about ...

[maarten (info-maartenabbring)]

I think this bug is rather serious. I could easily reproduce it on another 13.04 system by simply installing and uninstalling hsqldb-server with apt-get.

And until solved in the awfull way mentioned in my previous comment, apt-get (and therefore also the Ubuntu Software Center and Update Center) will not work once people get in this state!

It's not like they did anything funky ...

[tiago (mv2axx)]

maarten (info-maartenabbring) your hack was the only thing that worked for me thanks! I tried everything else...

"cleared out the sections 'start' and 'stop' in the script /etc/init.d/hsqldb. Then did the sudo apt-get purge hsqldb-server"

awesome!