weak dependency to libreoffice-sdbc-hsqldb

Bug #1916786 reported by Jérôme Bouat
24
This bug affects 3 people
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
Fix Released
Undecided
Rico Tzschichholz
Focal
Fix Released
Undecided
Unassigned
Groovy
Fix Released
Undecided
Unassigned

Bug Description

[Verification and regression analysis is all handled via the main SRU bug of LP: #1913353 (for groovy) and LP: #1906684 (for focal)]

The user can't create a new Base file with the wizard if the libreoffice-sdbc-hsqldb package isn't installed. The package libreoffice-base-drivers has only a "suggests" dependency to libreoffice-sdbc-hsqldb. It should have a "depends" dependency.

ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: libreoffice-base-drivers 1:6.4.6-0ubuntu0.20.04.1
ProcVersionSignature: Ubuntu 5.4.0-66.74-generic 5.4.86
Uname: Linux 5.4.0-66-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.16
Architecture: amd64
CasperMD5CheckResult: skip
CurrentDesktop: XFCE
Date: Wed Feb 24 18:32:22 2021
InstallationDate: Installed on 2020-10-12 (134 days ago)
InstallationMedia: Xubuntu 20.04.1 LTS "Focal Fossa" - Release amd64 (20200731)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)
mtime.conffile..etc.logrotate.d.apport: 2021-02-03T16:41:54.752959

Revision history for this message
Jérôme Bouat (jeromebouat) wrote :
tags: added: packaging unmetdeps
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

The fix for both the focal and groovy branch has been committed and will be picked up in the next SRU for each release.

Changed in libreoffice (Ubuntu):
status: New → Fix Committed
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Turns out the current fix (just adding libreoffice-sdbc-hsqldb) causes openjdk to be pulled in on ISOs: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1918308

Changing the status of this bug until an alternative solution is found.

Changed in libreoffice (Ubuntu):
status: Fix Committed → Triaged
Revision history for this message
Jérôme Bouat (jeromebouat) wrote :

If you keep this dependency weak then Libreoffice Base doesn't work. Next the user has the feeling that Ubuntu doesn't work.

As a clean workaround, maybe we could change the following packages dependencies of the ISOs :
- remove libreoffice (=> openjdk isn't pulled anymore)
- add libreoffice-calc
- add libreoffice-draw
- add libreoffice-impress
- add libreoffice-math
- add libreoffice-writer

However, openjdk-11 requires only 171 MB for x86_64.

Revision history for this message
Heather Ellsworth (hellsworth) wrote :

My last comment was incorrect. https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1918308 is a different issue altogether.

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Committed
assignee: nobody → Rico Tzschichholz (ricotz)
description: updated
Revision history for this message
Łukasz Zemczak (sil2100) wrote : Please test proposed package

Hello Jérôme, or anyone else affected,

Accepted libreoffice into groovy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/libreoffice/1:7.0.5-0ubuntu0.20.10.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-groovy to verification-done-groovy. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-groovy. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Changed in libreoffice (Ubuntu Groovy):
status: New → Fix Committed
tags: added: verification-needed verification-needed-groovy
description: updated
Revision history for this message
Łukasz Zemczak (sil2100) wrote :

Hello Jérôme, or anyone else affected,

Accepted libreoffice into focal-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/libreoffice/1:6.4.7-0ubuntu0.20.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-focal to verification-done-focal. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-focal. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Changed in libreoffice (Ubuntu Focal):
status: New → Fix Committed
tags: added: verification-needed-focal
Revision history for this message
Ubuntu SRU Bot (ubuntu-sru-bot) wrote : Autopkgtest regression report (libreoffice/1:6.4.7-0ubuntu0.20.04.1)

All autopkgtests for the newly accepted libreoffice (1:6.4.7-0ubuntu0.20.04.1) for focal have finished running.
The following regressions have been reported in tests triggered by the package:

libreoffice/1:6.4.7-0ubuntu0.20.04.1 (armhf)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/focal/update_excuses.html#libreoffice

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

Revision history for this message
Łukasz Zemczak (sil2100) wrote :

Groovy verified per LP: #1913353.

tags: added: verification-done-groovy
removed: verification-needed-groovy
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package libreoffice - 1:7.0.5-0ubuntu0.20.10.1

---------------
libreoffice (1:7.0.5-0ubuntu0.20.10.1) groovy; urgency=medium

  * New upstream release (LP: #1913353)

  [ Rico Tzschichholz ]
  * Update yaru icon style "2021-01-31"
  * Move libreoffice-sdbc-hsqldb to Recommends (LP: #1916786)
  * Fix Calc crash in ScSelectionTransferObj (LP: #1897784)
  * Drop fix-bluez-external.diff and unowinreg-static-libgcc.diff,
    applied upstream

  [ Heather Ellsworth ]
  * Add timeout to uicheck-sw test to allow it to handle timeouts under
    load better (LP: #1785262)

libreoffice (1:7.0.4-3) unstable; urgency=medium

  * debian/tests/control.in: *really* add libreoffice-writer dependency
    to uicheck-sc test

libreoffice (1:7.0.4-2) unstable; urgency=medium

  * debian/test/control: make uicheck-sc depend on libreoffice-writer, too
    (the openDialogs/uno.Show:License Dialog test opens a new "Writer/Web"
    document...)

libreoffice (1:7.0.4-1) unstable; urgency=medium

  * LibreOffice 7.0.4 final release (identical to rc2)

  * debian/patches/pdfium-m68k.diff: fix pdfium build on m68k

  * debian/rules, debian/control*in: s/noinsttests/noinsttest/, thanks
    lintian
  * debian/rules:
    - revert clang (>= 1:11) build-dep for buster-backports; doesn't exist in
      buster and we resort back to gcc
    - don't rm LICENSE.html, it is used by
      Help -> License Information -> Show License
  * debian/control.mediawiki.in: remove Homepage: (closes: #978713)
  * debian/*.mime: stop quoting %s (closes: #950319)

libreoffice (1:7.0.4~rc2-1) unstable; urgency=medium

  * New upstream release candidate

libreoffice (1:7.0.4~rc1-1) unstable; urgency=medium

  * New upstream release candidate

  * debian/patches/unowinreg-static-libgcc.diff: use -static-libgcc, see
    LO master commit 01241113947fc7bd7f7b765dd897bb023c8ca99c

  * debian/rules:
    - set MYSQL_FLAVOUR=mariadb (as it's used anyway, and upstreams internal
      copy is mariadb-connector-c anyway) and build-depend on libmariadb-dev
      instead of libmariadbclient-dev-compat (closes: #975481)
    - build-depend on clang (>= 1:11) on armel
    - fix nocheck -b builds...
    - use nowindows build profile for (not) building unowinreg
  * debian/rules, debian/control*in:
    - honour noinsttests build profile for (not) building
      -subsequentcheckbase/-smoketest-test-data
  * debian/rules, debian/control*in:
    - move unowinreg.dll into /usr/lib/i686-w64-mingw32 (the mingw g++
      compiler installs its .dlls into /usr/lib/gcc/i686-w64-mingw32)

 -- Rico Tzschichholz <email address hidden> Mon, 15 Mar 2021 19:01:12 +0100

Changed in libreoffice (Ubuntu Groovy):
status: Fix Committed → Fix Released
Revision history for this message
Łukasz Zemczak (sil2100) wrote : Update Released

The verification of the Stable Release Update for libreoffice has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

Revision history for this message
Łukasz Zemczak (sil2100) wrote :

Focal verified via LP: #1906684.

tags: added: verification-done verification-done-focal
removed: verification-needed verification-needed-focal
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package libreoffice - 1:6.4.7-0ubuntu0.20.04.1

---------------
libreoffice (1:6.4.7-0ubuntu0.20.04.1) focal; urgency=medium

  * New upstream release (LP: #1906684)
  * Move libreoffice-sdbc-hsqldb to Recommends (LP: #1916786)
  * Fix Calc crash in ScSelectionTransferObj (LP: #1897784)

 -- Rico Tzschichholz <email address hidden> Mon, 15 Mar 2021 19:12:01 +0100

Changed in libreoffice (Ubuntu Focal):
status: Fix Committed → Fix Released
Changed in libreoffice (Ubuntu):
status: Fix Committed → Fix Released
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.