openoffice.org uninstallable due to build failure

Bug #176487 reported by Colin Stark
34
Affects Status Importance Assigned to Milestone
openoffice.org (Ubuntu)
Fix Released
High
Chris Cheney
Hardy
Fix Released
High
Chris Cheney

Bug Description

Binary package hint: openoffice.org

Running hardy alpha. Ran apt-get update/upgrade and wasn't paying too much attention and chose to install the version of libhsqldb-java that was intended to be kept back. This resulted in completely uninstalling openoffice. There is a compatibility issue between libhsqldb-java and openoffice.org-base. I'm not sure which package needs the upgrade but as of now I am unable to install openoffice.

Revision history for this message
Colin Stark (cstark) wrote :

sudo apt-get install openoffice.org
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.

Since you only requested a single operation it is extremely likely that
the package is simply not installable and a bug report against
that package should be filed.
The following information may help resolve the situation:

The following packages have unmet dependencies:
  openoffice.org: Depends: openoffice.org-base but it is not going to be installed
E: Broken packages

sudo apt-get install openoffice.org-base
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.

Since you only requested a single operation it is extremely likely that
the package is simply not installable and a bug report against
that package should be filed.
The following information may help resolve the situation:

The following packages have unmet dependencies:
  openoffice.org-base: Depends: libhsqldb-java (>= 1.8.0.8-1) but it is not going to be installed
E: Broken packages

sudo apt-get install libhsqldb-java
Reading package lists... Done
Building dependency tree
Reading state information... Done
libhsqldb-java is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

apt-cache show libhsqldb-java
Package: libhsqldb-java
Priority: optional
Section: libs
Installed-Size: 1104
Maintainer: Ubuntu Core Developers <email address hidden>
Original-Maintainer: Peter Eisentraut <email address hidden>
Architecture: all
Source: hsqldb
Version: 1.8.0.9-2
Depends: gij | java-gcj-compat | java2-runtime, libservlet2.4-java
Suggests: java-virtual-machine, libhsqldb-java-doc, libhsqldb-java-gcj
Conflicts: openoffice.org-base (<< 1:2.3.1~m8)
Filename: pool/main/h/hsqldb/libhsqldb-java_1.8.0.9-2_all.deb
Size: 949492
MD5sum: cb7222b3ab2085af3cb934cafaa6ffca
SHA1: 1da6b1122fe653b6e1bfae47e580e06584323e66
SHA256: 80fbaa55a7406d656ca3a4f0126991b4113f566db0b29dd01cfebf91569dbb92
Description: Java SQL database engine
 HSQLDB is an SQL relational database engine written in Java. It has a
 JDBC driver and supports a rich subset of SQL-92 (BNF tree format) plus
 SQL:1999 and SQL:2003 enhancements. It offers a small, fast database
 engine that offers both in-memory and disk-based tables. Embedded and
 server modes are available. Additionally, it includes tools such as a
 minimal web server, in-memory query and management tools (can be run as
 applets), and a number of demonstration examples.
 .
 Web site: http://hsqldb.org/
Bugs: mailto:<email address hidden>
Origin: Ubuntu
Task: ubuntu-desktop, edubuntu-desktop, gobuntu-desktop

Revision history for this message
des (des-frommars) wrote :

The current version of libhsqldb-java in Hardy (1.8.0.9-2 which changelog says adds a security fix over 1.8.0.8) requires a newer version of openoffice.org than the packages available. See "Conflicts: openoffice.org-base (<< 1:2.3.1~m8)", but the newest version of openoffice.org-base for hardy is 2.3.0-1ubuntu5.

It looks like the 2.3.1 openoffice.org packages need to be merged into Hardy?

Changed in openoffice.org:
assignee: nobody → ccheney
importance: Undecided → Medium
status: New → Confirmed
Revision history for this message
Matt Zimmerman (mdz) wrote :

The problem is that the latest openoffice.org (1:2.3.1-1ubuntu1) hasn't built yet. See https://launchpad.net/ubuntu/+source/openoffice.org/1:2.3.1-1ubuntu1 for details.

This, in turn, is because it build-depends on libflute-1.3-jfree-java, which is in universe.

Revision history for this message
Matt Zimmerman (mdz) wrote :

Increasing severity to high, as this is bad mojo for alpha 2

Changed in openoffice.org:
importance: Medium → High
Steve Langasek (vorlon)
Changed in openoffice.org:
milestone: none → hardy-alpha-2
Revision history for this message
Steve Langasek (vorlon) wrote :

worked around for alpha2 by dropping openoffice.org-base from the desktop seed; we should still get the build-dep issue sorted for alpha3.

Changed in openoffice.org:
milestone: hardy-alpha-2 → hardy-alpha-3
Revision history for this message
ElCid87 (steven-wolford) wrote :

so after we are here how do we get oo installed again?

Revision history for this message
Charles Perreault (muganor) wrote :

ElCid87 : you can always change your /etc/apt/sources.list to include sources from gutsy, and downgrade libhsqldb-java to the version from gutsy. Then you remove the gutsy sources from sources.list and reinstall oo. Clue : don't forget to refresh/update your repositories in synaptic / apt-get after each change to sources.list. And the "force version" of synaptic (ctrl+E) comes very handy here...

Or you can go on packages.ubuntu.com, find the libhsqldb-java package from gutsy, download it from there and manually install it with dpkg (you may need to remove the hardy version before).

Have fun.

Revision history for this message
viking777 (viking-f2s) wrote :

Out of interest I tried the downgrade of libhsqldb-java to the Gutsy version, but it made no difference on my system, no element of open office will run. I have a theory that this may be architecture specific in some way. I have asked this question on the forums and from the replies I got those with 32 bit architecture don't seem to have a problem whereas those like myself with 64bit architecture do have it. Not entirely scientific analysis but it may be worth looking at.

Revision history for this message
ElCid87 (steven-wolford) wrote :

Charles,

The downgrade of the library seems to have worked.

FWIW: I downloaded the libhsqldb-java deb and using dpkg removed the existing version and installed the old version. Then used Synaptic to install OO. I am using Hardy on a Lenovo T42 laptop.

Revision history for this message
jarondl (jarondl) wrote :

Thanks Charles,
I had the same problem too, and your tip (to get it from gutsy packages on the web) solved it.

Revision history for this message
Charles Perreault (muganor) wrote :

I expected this bug to be solved very quickly but weeks have passed. As many people seems to use the "downgrade" workaround, here's a link to the Ubuntu mirrors where you can download the right gutsy package:

http://packages.ubuntu.com/cgi-bin/download.pl?arch=all&file=pool%2Fmain%2Fh%2Fhsqldb%2Flibhsqldb-java_1.8.0.8-1ubuntu1_all.deb&md5sum=330ac9d68c736b7b2cbd357672a5bff2&arch=all&type=main

For people that wants a complete step by step procedure, here it is. It first download the package, then delete any trace of the hardy package, and finally install the downloaded gutsy package. In a terminal window, type the following:

wget http://mirrors.kernel.org/ubuntu/pool/main/h/hsqldb/libhsqldb-java_1.8.0.8-1ubuntu1_all.deb
sudo dpkg --purge libhsqldb-java
sudo dpkg -i libhsqldb-java_1.8.0.8-1ubuntu1_all.deb
rm libhsqldb-java_1.8.0.8-1ubuntu1_all.deb

Then reinstall OpenOffice :)

sudo apt-get install openoffice.org

Have fun.

Revision history for this message
pdlethbridge (pdleth) wrote :

                                                                              would this be what caused this bug? Bug #179858

Revision history for this message
Chris Cheney (ccheney) wrote :

I am working on getting a new version of OpenOffice.org into Hardy. I have uploaded several versions but they had problems due to various issues. The last one I uploaded yesterday ICE'd in gcj (due to using too much memory) on amd64/lpia and ICE'd in g++ on sparc. Once we can resolve the compiler issues it will be rebuilt and installable again on Hardy.

Thanks,

Chris Cheney

Steve Langasek (vorlon)
Changed in openoffice.org:
milestone: hardy-alpha-3 → hardy-alpha-4
Revision history for this message
des (des-frommars) wrote :

pdlethbridge: I marked bug 179858 as a duplicate of this one. Yes, in hardy alpha 2 you would experience this package incompatibility as you reported.

Revision history for this message
des (des-frommars) wrote :

Chris, with the latest updated packages in hardy apt, everything looks good to me.

- openoffice.org (and friends) are version 2.3.1-3ubuntu1.
- openoffice.org-base depends on libhsqldb-java (>= 1.8.0.9-1).
- libhsqldb-java is version 1.8.0.9-2 (which is where we came in...)

Standard operations in OO write/calc/impress work for me in very brief tests.

Revision history for this message
SK (stephantom) wrote :

I can confirm that everything installs/upgrades as expected now on 32bit i386.

Revision history for this message
tomato (jdvorak2) wrote :

Same problem!
I installed HH Alpha3 and mine oO isn´t working too. Same error - broken package. No change after installing old libhsqldb-java (1.8.0.8-1ubuntu1_all). I using x86_64 version.
One difference here: Depends on: openoffice.org-java-common (> 2.2.0-4)

Revision history for this message
Manuel Siggen (manuel-siggen) wrote :

I upgraded from gusty yesterday night (s/gutsy/hardy/g in source.list, followed by apt-get update && dist-upgrade) and I encountered the same problem as reported in first post (sorry, I have no log). The upgrade stopped, but I could make it continue just by typing :

    sudo apt-get install openoffice.org-base-core

I find strange that dist-upgrade could not resolve the dependency in the first try, but I'm not into packaging so I don't really know.

Revision history for this message
Steve Langasek (vorlon) wrote :

Current openoffice.org has been built now on both i386 and amd64 and is consequently installable now. Marking this as 'fix released'.

Changed in openoffice.org:
status: Confirmed → Fix Released
Revision history for this message
tomato (jdvorak2) wrote :

Just confirming - all`s working now just fine, including translations (language-support). Thx

Revision history for this message
dcherryholmes (david-cherryholmes) wrote :

I just installed Hardy Alpha 5 AMD64 version, and I am still seeing this bug.

Revision history for this message
Chris Cheney (ccheney) wrote :

dcherryholmes,

The bug you see is the same symptoms but a different cause. Hopefully that one will be fixed in the next day or two.

Thanks,

Chris

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.