Ubuntu
apt package

USC & pkg mgr fail: cannot remove, repair or install

Asked by Ken Wagner

Hi All,

Ubuntu 13.04 32bit pae.

Decided to install (add) Libreoffice Base. Error message creating DB connection on first attempt: libhsqldb-java missing. Installed same via USC.

Created a small test DB. Worked OK the first time. Table with 5 fields and 5 records.

Second attempt to edit file caused "out of memory" error. Then I could not shutdown normally. System hung at login.

Used sudo /etc/init.d/hsqldb-server stop. That allowed me to shutdown finally.

Tried to install hsqldb-server to see if that would help. Would not install. Tried to uninstall Libreoffice Base. Would not install either. Tried to re-install both. No go.

No matter what I did to install, remove, purge. No go. Even with the "-f" switch using apt-get.

Did recovery mode on reboot. Ran debpkg repair. Same errors again & again.

All errors revolve around an "hsqldb-server" running with pid #nnnn or #nnn.

The error:

ken@KensSSD120:~$ sudo apt-get remove -f 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 ... 225633 files and directories currently installed.)
Removing hsqldb-server ...
Exception in thread "main" java.lang.NoClassDefFoundError: org.hsqldb.jdbcDriver
at java.lang.Class.initializeClass(libgcj.so.13)
at java.lang.Class.forName(libgcj.so.13)
at java.lang.Class.forName(libgcj.so.13)
at org.hsqldb.util.RCData.getConnection(Unknown Source)
at org.hsqldb.util.SqlTool.objectMain(Unknown Source)
at org.hsqldb.util.SqlToolSprayer.main(Unknown Source)
Caused by: java.lang.ClassNotFoundException: java.sql.SQLFeatureNotSupportedException not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:/usr/share/java/hsqldb.jar], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
at java.net.URLClassLoader.findClass(libgcj.so.13)
at gnu.gcj.runtime.SystemClassLoader.findClass(libgcj.so.13)
at java.lang.ClassLoader.loadClass(libgcj.so.13)
at java.lang.ClassLoader.loadClass(libgcj.so.13)
at java.lang.Class.forName(libgcj.so.13)
at java.lang.Class.initializeClass(libgcj.so.13)
...5 more
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 1879.
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)
ken@KensSSD120:~$

edited /etc/hsqldb.conf and set HSQLDB_OWNER=my_id helped. The server stopped running.

BUT!!!

Still cannot install, remove or repair hsqldb-server or libhsqldb-java or libreoffice-base.

How to fix?

Thanks, guys!

Regards,

Ken Wagner

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu apt Edit question
Assignee:
No assignee Edit question
Solved by:
Thomas Krüger
Solved:
Last query:
Last reply:
Revision history for this message
Best Thomas Krüger (thkrueger) said : 		#1

Did you go through https://help.ubuntu.com/community/PackageManagerTroubleshootingProcedure ?
It might help.

Revision history for this message
Ken Wagner (beaucoder) said : 		#2

Hi Tom,.

I looked over the link you supplied above.

Checked my backups & saw may last drive image was 3 weeks old and I had all data since then.

So, I reloaded the image, copied all the data I could find and then did a fresh, clean 13.04 32bit install. This was needed because I had different PPA's in the old system and wanted an all Ubuntu Main reinstall.

Aside from a "no sound" problem after the new install and all the updates (fixed via ALSAMIXER and setting 'automute' to disable) it all looked good. I then installed LibreOffice Base. That went smoothly, too.

BUT I think I have found the weak point. If I freshly install LibreOffice Base and create a new (default) file, open a table, add three fields and IN THE MIDDLE OF THAT cancel what I was doing then after one or more attempts at doing this the system will hang and be unable to honor the click on the title bar close button.

So, I instead did the following.

Revision history for this message
Ken Wagner (beaucoder) said : 		#3

1. I did it in steps:
    a. Created the database in default mode. Closed the database. Then restarted Base.
    b. Opened the database and created the table with 3 input fields defined, added an autonumber indes. Closed the DB again.
    c. Opened the DB and the table just created and entered a few records. Saved and closed the DB.
    d. Continued working. All now seems well.

The problem seems to occur when the create DB, create table, enter a few fields (but no indes or data) and then cancel what I am doing, Base gets confused and hangs and the Base DB exit.

So the new fresh install with the DB steps as above are all working well. With sound, even. Shazzam!!

Thanks for your reply.

Ken Wagner

Revision history for this message
Ken Wagner (beaucoder) said : 		#4

Thanks Thomas Krüger, that solved my question.