Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 413161 - app-office/libreoffice-bin-3.4.5.2-r1 - localc segfaults connecting to existing database
Summary: app-office/libreoffice-bin-3.4.5.2-r1 - localc segfaults connecting to existi...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: AMD64 Linux
: Normal normal
Assignee: Gentoo Office Team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-22 21:53 UTC by Francisco Lloret
Modified: 2012-06-01 12:45 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
backtrace attempting to connect to existing database (backtrace.log,4.84 KB, text/plain)
2012-05-05 11:32 UTC, Chris Mayo
Details
backtrace with libreoffice-bin-debug (backtrace2.log,10.16 KB, text/plain)
2012-05-05 12:23 UTC, Chris Mayo
Details
backtrace with app-office/libreoffice-bin-debug-3.5.2.2 (backtrace3.log,11.18 KB, text/plain)
2012-05-05 17:35 UTC, Chris Mayo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Francisco Lloret 2012-04-22 21:53:50 UTC
When I try to create a new database file selecting File -> New -> Database, clicking the "Connect to existing database" option in order to select a calc file produces a Libreoffice segfault and exits the application.

Reproducible: Always

Steps to Reproduce:
1.Open Libreoffice-bin-3.4.5.2-r1
2.Select New->database
3.Clic on "Connect to existing database" option
Actual Results:  
Libreoffice-bin segfaults

Expected Results:  
Libreoffice-bin don't segfaults
Comment 1 Francisco Lloret 2012-04-22 21:54:57 UTC
Libreoffice bin spoanish translation.
Comment 2 Tomáš Chvátal (RETIRED) gentoo-dev 2012-04-24 16:17:11 UTC
Please mind installing libreoffice-bin-debug and try to get backtrace.

http://www.gentoo.org/proj/en/qa/backtraces.xml
Comment 3 Francisco Lloret 2012-04-24 16:59:54 UTC
Seems a java-related problem.

I'm installing libreoffice-bin-debug, when installed I try it.

But opening libreoffice, in options menu don't appears any Java version, and it don't allow me to select the java version installed. (I have sun-jre-bin-1.6.0.31 version installed)
Comment 4 Francisco Lloret 2012-04-25 21:35:00 UTC
It's not a java problem.

The problem with java was fixed, but the segfault persists.
Comment 5 Tomáš Chvátal (RETIRED) gentoo-dev 2012-04-26 12:29:21 UTC
Really without the backtrace it is not reproducable, as I am unable to crash it on my machine.

Look on bug#413201 where I just gave pointers how to get that trace.

Thanks
Comment 6 Chris Mayo 2012-05-05 11:32:33 UTC
Created attachment 310857 [details]
backtrace attempting to connect to existing database

I get the same running lobase with a crash as soon as I click on "Connect to an existing database".

Backtrace attached running soffice.bin, let me know if there are other packages I need to emerge with symbols (created using splitdebug).

I am seeing this with compiled libreoffice running in a non-virtualised environment, the backtrace was created with libreoffice-bin in a KVM guest which has stable packages except for spice related ones, llvm, portage, grub 2 and libreoffice-bin-3.5.2.2 for this test.

Portage 2.2.0_alpha101 (unavailable, gcc-4.5.3, glibc-2.14.1-r3, 3.2.12-gentoo x86_64)
=================================================================
System uname: Linux-3.2.12-gentoo-x86_64-QEMU_Virtual_CPU_version_1.0,1-with-gentoo-2.0.3
Timestamp of tree: Unknown
dev-lang/python:          2.7.2-r3::gentoo, 3.2.2::gentoo
sys-devel/autoconf:       2.68::gentoo
sys-devel/automake:       1.9.6-r3::gentoo, 1.11.1::gentoo
sys-devel/binutils:       2.21.1-r1::gentoo
sys-devel/libtool:        2.4-r1::gentoo
sys-kernel/linux-headers: 3.1::gentoo (virtual/os-headers)
Repositories: x-portage
Installed sets: 
ACCEPT_LICENSE="* -@EULA"
CFLAGS="-O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests binpkg-logs collision-protect distlocks ebuild-locks fixlafiles news parallel-fetch preserve-libs protect-owned sandbox sfperms splitdebug strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY=""
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X alsa consolekit dbus jpeg jpeg2k mmx opengl pam png policykit sse sse2 svg truetype udev"
Unset:  ACCEPT_KEYWORDS, EMERGE_DEFAULT_OPTS, PORTAGE_BUNZIP2_COMMAND
Comment 7 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-05 11:44:17 UTC
install libreoffice-bin-debug and recompile glibc with splidebug.
Comment 8 Chris Mayo 2012-05-05 12:23:00 UTC
Created attachment 310875 [details]
backtrace with libreoffice-bin-debug

Couldn't get libreoffice-bin-debug-3.5.2.2 to emerge due blockages to so new trace (same behaviour) using:

app-office/libreoffice-bin-3.4.5.2-r1
app-office/libreoffice-bin-debug-3.4.5.2-r1
Comment 9 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-05 13:01:04 UTC
Meh, seems like as the 3.4 still didnt build with respecting cflags on some places it failed, could you please try to merge libreoffice-bin-3.5.2.2 and the corresponding debug?

If it is fixed there then great, if not it should produce proper trace.
Comment 10 Chris Mayo 2012-05-05 13:19:34 UTC
I can't figure out how to resolve the blockage:


# emerge -av  libreoffice-bin-debug

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild  N    ~] app-office/libreoffice-bin-3.5.2.2  USE="debug (-aqua) -cups -gnome -java -kde" 0 kB
[ebuild  N    ~] app-office/libreoffice-l10n-3.5.3  USE="-offlinehelp -templates" LINGUAS="-af -ar -as -ast -be -bg -bn -bo -br -brx -bs -ca -ca_XV -cs -cy -da -de -dgo -dz -el -en -en_GB -en_ZA -eo -es -et -eu -fa -fi -fr -ga -gd -gl -gu -he -hi -hr -hu -id -is -it -ja -ka -kk -km -kn -ko -kok -ks -ku -lb -lo -lt -lv -mai -mk -ml -mn -mni -mr -my -nb -ne -nl -nn -nr -nso -oc -om -or -pa_IN -pl -pt -pt_BR -ro -ru -rw -sa_IN -sat -sd -sh -si -sk -sl -sq -sr -ss -st -sv -sw_TZ -ta -te -tg -th -tn -tr -ts -tt -ug -uk -uz -ve -vi -xh -zh_CN -zh_TW -zu" 0 kB
[ebuild  N    ~] app-office/libreoffice-bin-debug-3.5.2.2  USE="-gnome -java -kde" 694,944 kB
[blocks B      ] app-office/libreoffice-bin-debug ("app-office/libreoffice-bin-debug" is blocking app-office/libreoffice-bin-3.5.2.2)

Total: 3 packages (3 new), Size of downloads: 694,944 kB
Conflict: 1 block (1 unsatisfied)

 * Error: The above package list contains packages which cannot be
 * installed at the same time on the same system.

  (app-office/libreoffice-bin-3.5.2.2::gentoo, ebuild scheduled for merge) pulled in by
    app-office/libreoffice-bin required by (virtual/ooo-0::gentoo, installed)
    >=app-office/libreoffice-bin-3.4.4.2-r1 required by (app-office/libreoffice-l10n-3.5.3::gentoo, ebuild scheduled for merge)
    =app-office/libreoffice-bin-3.5.2.2[-gnome,-java,-kde] required by (app-office/libreoffice-bin-debug-3.5.2.2::gentoo, ebuild scheduled for merge)

  (app-office/libreoffice-bin-debug-3.5.2.2::gentoo, ebuild scheduled for merge) pulled in by
    libreoffice-bin-debug
Comment 11 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-05 13:26:24 UTC
(In reply to comment #10)
> I can't figure out how to resolve the blockage:

Seems like your useflag does not match between libreoffice-bin and libreoffice-bin-debug, verify that both have same.
Comment 12 Chris Mayo 2012-05-05 17:35:08 UTC
Created attachment 310903 [details]
backtrace with app-office/libreoffice-bin-debug-3.5.2.2

Had to remove from libreoffice-bin-3.5.2.2 RDEPEND:
	!app-office/libreoffice-bin
	!app-office/libreoffice-bin-debug
Comment 13 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-05 17:40:23 UTC
Hmpf, try to grab the java enabled version.

And also fixed the blocker, Thanks for spotting that.
Comment 14 Chris Mayo 2012-05-09 19:44:06 UTC
Yes, the java version works OK for me.

Doesn't seem to have the built-in PostgreSQL support though.
Comment 15 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-09 19:50:00 UTC
(In reply to comment #14)
> Yes, the java version works OK for me.
> 
> Doesn't seem to have the built-in PostgreSQL support though.

Ok this means that even with other db connectors the hsqldb is required by base, so the -java version won't ever work, unless ported to sqlite (which is quite long open easy hack nobody bothered to fix :/)

Wrt pgsql we indeed do not depend on it in binary version. Basically I would recommend to build the version yourself with features you want. We only tried to cover basic setups, and pgsql is not exactly common use case ;-)

Anyway to fix this, do you think some elog information about non-functional base/extensions would work for people installing it?
Comment 16 Chris Mayo 2012-05-09 20:03:24 UTC
It would definitely be good to have an elog warning in the binary version.

For the source version maybe mysql and postgres USE flags should only be allowed if java is selected too?
Comment 17 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-09 20:08:36 UTC
(In reply to comment #16)
> It would definitely be good to have an elog warning in the binary version.

Ok I will add there some text.

> 
> For the source version maybe mysql and postgres USE flags should only be
> allowed if java is selected too?

Thats the question. They don't in reality need java as the extensions works entirely without it.
Problem is only the hsqldb dep on lobase. And even that can be worked around by importing after creating basic project in mysql/pgsql.

I should try to get more free time to work on the sqlite port as it would solve everything. But it will take few man days to get done and I don't have that much while not neglecting less of the lo stuff :)
Comment 18 Tomáš Chvátal (RETIRED) gentoo-dev 2012-05-09 20:15:08 UTC
Text added to 3.5.2.2 binary and 3.5.3.2 source and later.
Comment 19 Tomáš Chvátal (RETIRED) gentoo-dev 2012-06-01 12:26:17 UTC
Closing as fixed with the warning in the ebuild.
Comment 20 Chris Mayo 2012-06-01 12:39:35 UTC
It actually seems to be fixed to me in app-office/libreoffice-3.5.4.2-r1.

With USE="(-aqua) -binfilter -binfilterdebug branding cups dbus -eds gnome graphite gstreamer gtk -java jemalloc -kde -mysql -nlpsolver nsplugin -odk opengl pdfimport postgres svg -test vba webdav xmlsec"

I can start loffice and go right through connecting to an existing database (PostgreSQL).
Comment 21 Tomáš Chvátal (RETIRED) gentoo-dev 2012-06-01 12:45:17 UTC
(In reply to comment #20)
> It actually seems to be fixed to me in app-office/libreoffice-3.5.4.2-r1.
> 
> With USE="(-aqua) -binfilter -binfilterdebug branding cups dbus -eds gnome
> graphite gstreamer gtk -java jemalloc -kde -mysql -nlpsolver nsplugin -odk
> opengl pdfimport postgres svg -test vba webdav xmlsec"
> 
> I can start loffice and go right through connecting to an existing database
> (PostgreSQL).

Yes that is another solution, to use mysql/pgsql backend :-)