Problem with Base in 3.3.1

users
#1

Hi,

I used Open Office from the time it was in beta. When LibreOffice 3.3.0 came out, I switched. I applaud what the document foundation is doing.

Two days ago I upgraded to LibreOffice 3.3.1. I'm running it on Ubuntu 10.10 on 4 computers and all 4 have the same issue. There is a major bug in the base program which did not exist in 3.3.0. I have a database with about 2400 records. The form opens a little bit slowly. But the BIG problem is if I try to go to the end of the database in the form once it opens, it takes anywhere from 30 to 60 seconds depending on the speed of the computer. I thought it might be a java issue, so in tools/options/java I checked my java versions. I had the most recent one from Ubuntu, which is 1.6.0_24, and it also showed 1.6.0_20 was installed. 1.6.0_24 was the one selected by default. I selected the 1.6.0_20 and tried it. I had the same issue. I then deleted Iced Tea, and the older version of java, 1.6.0_20, so that the only java on my one system is 1.6.0_24. Nothing I did made any difference to resolve this issue. The database worked perfectly in 3.3.0 on all of the computers.

Any assistance you can give would be greatly appreciated. The database is very important in my work, and it is almost unusable in this version.

Thank you.

Don

#2

Don,

I had exactly the same problem. Mine actually started with OOo Base when Sun Java was upgraded to 1.6.20. I upgraded Sun Java to 1.6.22, and that fixed the problem. Then I switched to LibreOffice and all was still okay. But Sun Java was upgraded to 1.6.24, and the problem was back big time.

I tried to install 1.6.22 from the debs, but I kept getting a broken package, even after completely removing 1.6.24. So here's how I solved it.

I removed the Partners software source (only unchecked it), removed 1.6.24, installed Sun Java (sun-java6-bin) which gave me 1.6.21. My performance problem was resolved.

I don't know whether the bug is in Java or Libreoffice (and OOo as well), but I sent a message to the Libreoffice folks in this mailing list suggesting they determine where it was because it can deter people from using Libreoffice in a production environment. I have received no response, so I do not know the status.

#3

Thank you for the help. I do know that the Java 1.6.0_24 update came through about the same time as I did the LibreOffice upgrade. So it may have just been coincidence that I had the problem with LibreOffice 3.3.1 and not 3.3.0.

I completely uninstalled Java 1.6.0_24 and unchecked the Partner software source. I actually had several of those. However, when I go back to find sun-java6-bin using synaptic it isn't there. I did do a refresh of the repositories before I tried to find it. I would appreciate knowing where you found it.

Thank you.

Don

#4

Well, sun-java6-bin and sun-java6-jre were both there in Synaptic for me. I do have *http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu Maverick Main* as a source for Maverick for both deb and deb-src. Perhaps it came from there. You can try to add those two sources. However, you may be able to install by using sudo apt-get install sun-java6-bin from a terminal.

#5

I have seen the slowness problem mentioned on two other lists now and
the apparent solution is to go back to 1.6.0_22 or earlier.

The 24 update only came through recently, since I update one of my
Ubuntu machines fairly regularly and it was installed this week, but I
haven't had a chance to see whether this will affect any of my existing
ODB files.

If you try typing in "java -version" in a terminal, what does it say ?
That will give you an idea of the JVM that is actually installed and
thereby point to the name of the packet. It may be that you have IcedTea
as a JVM instead of Sun JVM, or even OpenJDK.

Refreshing your repositories using synaptic will simply update the list
of available packets with the latest version, so finding an older JDK
through that is going to be hard to do. Either you have to find a
repository on the net that has the older version, and add that as a
software source, or you will have to download a package for the
particular version you want and install that (with whatever installation
mechanism they propose - installation script, dpkg -i, apt-get install
if it is a Ubuntu package, alien if RPM, etc). The problem is that you
will have to make sure that your regular system updates do not overwrite
the installed java version with another more recent one that may cause
the issue again, which, as an aside issue, will leave you vulnerable to
hacking exploits. Damned if you, damned if you don't - catch 22 !!

Alex

#6

Don,

As I mentioned earlier, if you add the source(s) I mentioned , I think
you'll get a version of Sun Java that works, namely 1.6.0_21. I can say for
sure that 1.6.0_20 does not work. That is when my performance problems
started in OOo, and I'm sure they will be there in LO because so much of the
code is common at this point. When I upgraded to 1.6.0_22, the problems
went away (see here: http://ubuntuforums.org/showthread.php?t=1642858). So
you either need 1.6.0_21 or 1.6.0_22. I tried unsuccessfully to install
1.6.0_22 from the debs (see here:
http://ubuntuforums.org/showthread.php?t=1694448).

If you refresh your sources with Partners still a source, you will only get
1.6.0_24. However, if you remove Partners as a source and add the PPA in my
previous post, you will get 1.6.0_21. You should use Synaptic to completely
remove sun-java6-bin and sun-java6-jre before installing sun-java6-bin from
the PPA.

So, do the following:
(1) Un-install sun-java6-bin;
(2) remove Partners as a source;
(3) add the following two lines to your software sources:
deb http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu
Maverick Main
deb-src http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu
Maverick Main
(4) install sun-java6-bin.

You should now have version 1.6.0_21

#7

Hi,

Most of today was spent working on a network and on two printers. Plus our Internet connection was down all morning! :frowning: I'm computered out at the moment!!!!!! When I'm back in the office on Monday I will give this a try.

Don

Thank you so much for your assistance.

#8

I gave this a try at home tonight. First I removed all Java (Iced Tea and
Sun). From the Software sources in the update manager, I added the two
lines:
deb http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu
Maverick Main
deb-src http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu
Maverick Main
I unchecked third party sources.
When I ran update, I got the following:
Failed to fetch
http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu/dists/Maverick/Main/source/Sources.gz
404 Not Found
Failed to fetch
http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu/dists/Maverick/Main/binary-i386/Packages.gz
404 Not Found
Some index files failed to download, they have been ignored, or old ones
used instead.

#9

Don,

In the paths that are failing, all letters should be in lower case, in particular, Maverick and Main. Sources.gz and Packages.gz are correct. So when you added the sources, you probably typed Maverick and Main as I had shown you. That is my mistake. Delete the two sources and re-enter using lower case for maverick and main. Of course, Sources.gz and Packages.gz are not part of the entries. That part is obtained from deb and deb-src. Sorry for the confusion.

#10

No problem. I just tried them by copying and pasting. I'll try again.

#11

Thank you cscj01 for your solution that works very well for me with LibreOffice
3.3.1 under Ubuntu 10.10 (french versions).