← Back to team overview

openjdk team mailing list archive

[Bug 686028] Re: Base tables load sort slow bad jre

 

Launchpad has imported 13 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=35023.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-03-04T18:33:08+00:00 Don Myers wrote:

I was using LibreOffice 3.3.0 and then upgraded 3.3.1. Base worked
instantly in Ubuntu 10.10 with a quad core AMD 910 processor and 8 gigs
of ram, It takes one core at 100% about 15 to 20 seconds to go from the
first record in a form to the last record in a form in a realtively
simple database with 2300 records. Apparently this is tied with the
release of Java 1.6.0_24. Base worked fine with 1.6.0_22. It will not
work properly with Java 1.6.0_20 either. This issue is in your forums.
It also is affecting OpenOffice base in the same way according to
information in the OpenOffice forums. I have my database on 4 different
computers and the issue is on all of them with Ubuntu 10.10. It is
significantly slower on the older, slower machines than what I stated
above. It is also sluggish when pulling data from a database to do a
mailmerge.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/12

------------------------------------------------------------------------
On 2011-05-24T10:04:34+00:00 Alex Thurgood wrote:

Hi Don,

Is this still the case, or has the problem now gone away, say, with
further Ubuntu updates ?

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/13

------------------------------------------------------------------------
On 2011-05-24T10:05:40+00:00 Alex Thurgood wrote:

It would also be good to test on a more recent version of LibreOffice.
Version 3.3.2 is currently the stable, version 3.4 will be out soon and
is currently in rc1.

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/14

------------------------------------------------------------------------
On 2011-05-24T12:32:29+00:00 Don Myers wrote:

Hi again,

I'm running 3.3.2 now on all my computers. When things got messed up was 
when Java went from version 6-22 to 6-24. When 3.3.4 is finalized I will 
upgrade to that. Also I'm using the version directly from LibreOfice, 
not the Ubuntu version.

Don

On 05/24/2011 06:05 AM, bugzilla-daemon@xxxxxxxxxxxxxxx wrote:
> https://bugs.freedesktop.org/show_bug.cgi?id=35023
>
> --- Comment #2 from Alex Thurgood<alex.thurgood@xxxxxxxxx>  2011-05-24 03:05:40 PDT ---
> It would also be good to test on a more recent version of LibreOffice. Version
> 3.3.2 is currently the stable, version 3.4 will be out soon and is currently in
> rc1.
>
> Alex
>

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/15

------------------------------------------------------------------------
On 2011-05-24T12:34:28+00:00 Don Myers wrote:

Hi Alex,

I've upgraded to Ubuntu 11.04. The same issue still persists. Sometimes 
on my most powerful computer it doesn't seem quite as bad. But base is 
far from working like it always used to. I've used it ever since it was 
part of OpenOffice. Would it make sense, or is it possible for 
LibreOffice to include a minimal java package with the download so 
LibreOffice is independent of anything java might mess up?.

Don

On 05/24/2011 06:04 AM, bugzilla-daemon@xxxxxxxxxxxxxxx wrote:
> https://bugs.freedesktop.org/show_bug.cgi?id=35023
>
> Alex Thurgood<alex.thurgood@xxxxxxxxx>  changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>             Keywords|                            |NEEDINFO
>
> --- Comment #1 from Alex Thurgood<alex.thurgood@xxxxxxxxx>  2011-05-24 03:04:34 PDT ---
> Hi Don,
>
> Is this still the case, or has the problem now gone away, say, with further
> Ubuntu updates ?
>
> Alex
>

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/16

------------------------------------------------------------------------
On 2011-05-29T09:51:05+00:00 Nicodorn wrote:

Bug confirmed for LibreOffice 3.3.2 on Ubuntu 10.10.
Java-Version: 6.24.

Because of this bug, base is barely usable. Some measurments I took on
my machine with a single core 1.8Ghz processor:

Opening a table mit 1.500 entries takes about 30 seconds. Jumping to the
last entry takes in the very same table takes anouther 2 minutes and 30
seconds.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/17

------------------------------------------------------------------------
On 2011-05-29T09:52:25+00:00 Nicodorn wrote:

Bug confirmed for LibreOffice 3.3.2 on Ubuntu 10.10.
Java-Version: 6.24.

Because of this bug, base is barely usable. Some measurments I took on
my machine with a single core 1.8Ghz processor:

Opening a table 1.500 entries takes about 30 seconds. Jumping to the
last entry in the very same table takes another 2 minutes and 30
seconds.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/18

------------------------------------------------------------------------
On 2011-05-30T08:51:21+00:00 Tlillqvist-k wrote:

Björn, lots of mentions of Ubuntu here, want to take this one? Feel free
to assign back to list...

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/19

------------------------------------------------------------------------
On 2011-07-14T10:33:51+00:00 Nicodorn wrote:

The performance remains weak in 3.4.1, Java version 1.6.0_26.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/28

------------------------------------------------------------------------
On 2011-07-14T15:17:29+00:00 Don Myers wrote:

I was so hopeful when the next update of Java from Java version 1.6.0_24
was released that it would make Base work like it had for many years.
I'm running  completely updated Ubuntu 11.04 systems and presently
LibreOffice 3.4.1 and the performance is still just as bad with Java
version 1.6.0_26 as it was when Java version 1.6.0_24 was released.
Would it not be possible for LibreOffice to ship with a basic java
package included just for LibreOffice so these issues would not happen?

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/29

------------------------------------------------------------------------
On 2011-08-19T08:29:51+00:00 Alex Thurgood wrote:

This has been confirmed multiple times on the users mailing list.


The only current workaraound is to downgrade the Java version to _u21 or _u22, both of which are unfortunately known to contain serious security issues.

There is a thread on the user mailing list which indicates how to have
several versions of the Java environment installed on a Ubuntu machine
and then be able to choose which version one wants to run with
LibreOffice.

As the problem appears to lie with the JDK version and not LibreOffice
as such, and there is a workaround, I'm setting this issue to resolved
"not our bug".


Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/30

------------------------------------------------------------------------
On 2011-10-19T06:44:56+00:00 John Talbut wrote:

It is still not sure that this is a Java bug (it could be as a result of
an intended change in Java) or what the the actual change in Java is
that is causing the problem.

I have uploaded an strace at
http://wiki.documentfoundation.org/File:Bug_35023_strace.log.7z for
these operations:

Start  19:05
Open test.odb
Go to tables pane 19:06:22 - 19:06:40
Open table 19:07 - 19:08 (first show) - 19:08:45 (finish loading 1st page)
Maximise  19:09:07 - 19:09:35 (finish loading 1st page)
Go to last record 19:09:50 - 19:11:56

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/32

------------------------------------------------------------------------
On 2011-11-14T17:00:39+00:00 Vstuart-foote wrote:

A continuing problem with Java 6 JRE, unclear if any improvement yet in 7 given problems of LO not recognizing JRE 7 on install or if selected as JRE.
Ref: https://bugs.freedesktop.org/show_bug.cgi?id=39659

Recent LO Dev forum exchanges:
http://nabble.documentfoundation.org/Trying-to-diagnose-base-running-extremely-slowly-tt3426499.html#none

And issue with Java stack guard as detailed in these Sun/Oracle Java
related bug reports:

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7024514
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6978641
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6929067

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/686028/comments/33


** Changed in: df-libreoffice
       Status: Unknown => Won't Fix

** Changed in: df-libreoffice
   Importance: Unknown => High

** Bug watch added: freedesktop.org Bugzilla #39659
   https://bugs.freedesktop.org/show_bug.cgi?id=39659

-- 
You received this bug notification because you are a member of OpenJDK,
which is subscribed to openjdk-6 in Ubuntu.
https://bugs.launchpad.net/bugs/686028

Title:
  Base tables load sort slow bad jre

Status in LibreOffice Productivity Suite:
  Won't Fix
Status in The OpenOffice.org Suite:
  Unknown
Status in Sun Java SE Development Kit:
  New
Status in “libreoffice” package in Ubuntu:
  Confirmed
Status in “openjdk-6” package in Ubuntu:
  Confirmed
Status in “openoffice.org” package in Ubuntu:
  Won't Fix
Status in “sun-java6” package in Ubuntu:
  Confirmed
Status in “libreoffice” package in Debian:
  Confirmed
Status in “openjdk-6” package in Debian:
  Confirmed
Status in “sun-java6” package in Debian:
  Fix Released

Bug description:
  Binary package hint: openoffice.org

  1)  lsb_release -rd
  Description:	Ubuntu 11.10
  Release:	11.10

  2) apt-cache policy libreoffice-base
  libreoffice-base:
    Installed: 1:3.4.4-0ubuntu1
    Candidate: 1:3.4.4-0ubuntu1
    Version table:
   *** 1:3.4.4-0ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.4.3-3ubuntu2 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

  apt-cache policy openjdk-6-jre
  openjdk-6-jre:
    Installed: 6b23~pre11-0ubuntu1.11.10
    Candidate: 6b23~pre11-0ubuntu1.11.10
    Version table:
   *** 6b23~pre11-0ubuntu1.11.10 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
          500 http://security.ubuntu.com/ubuntu/ oneiric-security/main i386 Packages
          100 /var/lib/dpkg/status
       6b23~pre10-0ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

  3) What is expected to happen in Base via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/686028/+attachment/2166527/+files/test.odb
  && lobase -nologo test.odb

  click Tables icon on left -> secondary click Books -> click Open

  is clicking page down within the table itself moves instantly or near
  instantly.

  4) What happens instead is it takes 5 seconds for it to go down 11
  rows.

  Original Reporter Comments: I note that jre was upgraded recently and that was when the problem began. My conclusion is that there is a problem with the jre installed recently:
  ii  openjdk-6-jre                                             6b20-1.9.2-0ubuntu1~10.04.1
  ii  openjdk-6-jre-headless                                           6b20-1.9.2-0ubuntu1~10.04.1
  ii  openjdk-6-jre-lib                                                6b20-1.9.2-0ubuntu1~10.04.1

  WORKAROUND: I fixed the problem by going to java.com and installing
  jre-6u22-linux-i586.bin in /opt.  I then chose that jre in openoffice
  options and the tables work fine with it.

  Upstream bug link for sun-java6-jre and openjdk-6-jre (as openjdk bugzilla not fully operational yet):
  http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7024514

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: openoffice.org-base 1:3.2.0-7ubuntu4.1
  ProcVersionSignature: Ubuntu 2.6.32-26.48-generic 2.6.32.24+drm33.11
  Uname: Linux 2.6.32-26-generic i686
  Architecture: i386
  Date: Mon Dec  6 10:31:57 2010
  InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
  ProcEnviron:
   PATH=(custom, user)
   LANG=en_US.utf8
   SHELL=/bin/bash
  SourcePackage: openoffice.org

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/686028/+subscriptions