Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 322379

Summary: app-office/openoffice: hsqldb-1.8.1.2-r1 breaks openoffice 3.2 odb files
Product: Gentoo Linux Reporter: Stephan Karacson <stkabugs>
Component: Current packagesAssignee: Gentoo Office Team <office>
Status: RESOLVED CANTFIX    
Severity: normal CC: corecrystal, cruzki123, ecyoung, serkan, ubiquitous1980
Priority: High    
Version: unspecified   
Hardware: AMD64   
OS: Linux   
URL: http://forums.gentoo.org/viewtopic-t-830427.html
Whiteboard:
Package list:
Runtime testing required: ---
Attachments: Ebuild for openoffice without --enable-system-hsqldb

Description Stephan Karacson 2010-06-01 16:58:47 UTC
I think openoffice has a bug with the new hsql package.
Reopening all my odb-files makes them not accessable (the tables) anymore.
A change the hsql-version of the odb file (version=1.8.1 to 1.8.0 in database/properties of the odb) makes it accessable, until reopening with hsql 1.8.1&OOo 3.2

Reproducible: Sometimes

Steps to Reproduce:
1. update to hsqldb-1.8.1.2-r1 (and reemergeing openoffice after that)
2. open an odb file with tables one or three times
3. try to access the tables in OOo each time

Tried it up to 7 times, and damaged odb-files 4 times
Actual Results:  
SQL-Status: HY000 
 
The connection could not be established. The database was created by a newer version of OpenOffice.org.

Expected Results:  
Shown tables

Also shown on arch Linux: http://bugs.archlinux.org/task/18373

emerge  --info
Portage 2.1.8.3 (default/linux/amd64/10.0, gcc-4.4.3, glibc-2.10.1-r1, 2.6.32-gentoo-r7 x86_64)
=================================================================                              
System uname: Linux-2.6.32-gentoo-r7-x86_64-AMD_Athlon-tm-_64_X2_Dual_Core_Processor_5200+-with-gentoo-1.12.13                                                                                                          
Timestamp of tree: Tue, 01 Jun 2010 12:45:03 +0000                                                          
app-shells/bash:     4.0_p37                                                                                
dev-java/java-config: 2.1.10                                                                                
dev-lang/python:     2.6.5-r2, 3.1.2-r3                                                                     
dev-util/cmake:      2.6.4-r3                                                                               
sys-apps/baselayout: 1.12.13                                                                                
sys-apps/sandbox:    1.6-r2                                                                                 
sys-devel/autoconf:  2.13, 2.65                                                                             
sys-devel/automake:  1.8.5-r4, 1.9.6-r3, 1.10.3, 1.11.1                                                     
sys-devel/binutils:  2.18-r3                                                                                
sys-devel/gcc:       4.4.3-r2                                                                               
sys-devel/gcc-config: 1.4.1                                                                                 
sys-devel/libtool:   2.2.6b                                                                                 
virtual/os-headers:  2.6.30-r1                                                                              
ACCEPT_KEYWORDS="amd64"                                                                                     
ACCEPT_LICENSE="* -@EULA dlj-1.1 ut2003 PUEL"                                                               
CBUILD="x86_64-pc-linux-gnu"                                                                                
CFLAGS="-march=k8-sse3 -O2 -pipe"                                                                           
CHOST="x86_64-pc-linux-gnu"                                                                                 
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config /var/lib/hsqldb"                                  
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"                                                           
CXXFLAGS="-march=k8-sse3 -O2 -pipe"                                                                         
DISTDIR="/usr/portage/distfiles"                                                                            
FEATURES="assume-digests distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch"                                                                         
GENTOO_MIRRORS="http://gentoo.inode.at/ ftp://gd.tuwien.ac.at/opsys/linux/gentoo/ "                         
LANG="de_AT.UTF-8"                                                                                          
LC_ALL="de_AT.UTF-8"                                                                                        
LDFLAGS="-Wl,-O1"                                                                                           
LINGUAS="de"                                                                                                
MAKEOPTS="-j3"                                                                                              
PKGDIR="/usr/portage/packages"                                                                              
PORTAGE_CONFIGROOT="/"                                                                                      
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"                          
PORTAGE_TMPDIR="/var/tmp"                                                                                   
PORTDIR="/usr/portage"                                                                                      
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext 7zip X a52 aac ace acl acpi acpi4linux alsa amarok amd64 audiofile bidi binfilter bluetooth bzip2 c c++ cdaudio cdda cddb cdinstall cdparanoia cdr cdrom chroot cjk clamav cli codecs consolekit cracklib css cups cvs cxx dbus dhcp dri dvd dvdnav dvdread emul-linux-x86 encode ethereal exif ffmpeg flac flash foomaticdb fortran ftp gcj gdbm german gif gphoto2 gpm h323 hal iconv imap imlib irmc java javascript joystick jpeg jpeg2k kde kdepim lame langpacks libwww live logitech-mouse mad matroska md5sum mikmod mjpeg mmx mmx2 mmxext mng modules mp2 mp3 mp4 mp4live mpeg mpeg2 mpeg4 mudflap multilib music ncurses net network nls nptl nptlonly nsplugin nvidia obex ogg oggvorbis opengl openmp oss pam pcre pdf png pnm pnp postscript pppd qt4 quicktime readline reflection rtc rtsp scanner semantic-desktop session smime sound sounds spl sqlite sse sse2 ssl stream svg svgz sysfs tcpd theora threads tiff timidity transcode truetype unicode usb utf8 vcd vdpau videos vlm vorbis wav wma wmf wmp x264 xcb xorg xpm xv xvid zip zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="mouse evdev keyboard joystick void" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="de" RUBY_TARGETS="ruby18" SANE_BACKENDS="epson epson2" USERLAND="GNU" VIDEO_CARDS="nv nvidia fbdev vesa vga" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 1 Stephan Karacson 2010-06-01 17:19:49 UTC
broken odb files cannot be opened on other openoffice installations (e.g. 3.2 on WindowsXP...). Downgrade to hsqldb 1.8.0 even made corrupted files opened once change back to normal working...
Comment 2 Damien John-Alan Sticklen 2010-08-25 10:42:10 UTC
I can confirm this on x86 Gentoo with hsqldb-1.8.1.2-r1 and openoffice-3.2.0  Wondering if openoffice-3.2.1 is affected by this bug?
Comment 3 Damien John-Alan Sticklen 2010-08-26 00:39:45 UTC
(In reply to comment #2)
> I can confirm this on x86 Gentoo with hsqldb-1.8.1.2-r1 and openoffice-3.2.0 
> Wondering if openoffice-3.2.1 is affected by this bug?
> 

This bug is replicated in openoffice-3.2.1 on my system with hsqldb-1.8.1.2-r1.  Also, portage is not permitting a downgrade to 1.8.0.x

Comment 4 riku 2010-09-16 22:38:17 UTC
Created attachment 247646 [details]
Ebuild for openoffice without --enable-system-hsqldb
Comment 5 riku 2010-09-16 22:42:10 UTC
(In reply to comment #3)
>  Also, portage is not permitting a downgrade to 1.8.0.x

You can use the ebuild attached to build openoffice with hsqldb from upstream sources. This should be the default, as most people using oobase with hsqldb do so for interoperability reasons. Maybe building with --enable-system-hsqldb should have a USE-flag?
Comment 6 Damien John-Alan Sticklen 2010-09-16 23:20:00 UTC
(In reply to comment #5)
> (In reply to comment #3)
> >  Also, portage is not permitting a downgrade to 1.8.0.x
> 
> You can use the ebuild attached to build openoffice with hsqldb from upstream
> sources. This should be the default, as most people using oobase with hsqldb do
> so for interoperability reasons. Maybe building with --enable-system-hsqldb
> should have a USE-flag?
> 

I am inclined to agree that it should have some sort of embedded-hsqldb USE-flag.  Perhaps the relevant dev should consider this.

Comment 7 Kevin Dinant 2011-01-14 12:51:59 UTC
The problem still exists with openoffice-3.2.1-r1 and I am not able to adapt the ebuild to make it work.
Comment 8 Carter Young 2011-02-08 01:30:51 UTC
(In reply to comment #7)
> The problem still exists with openoffice-3.2.1-r1 and I am not able to adapt
> the ebuild to make it work.
> 

This ebuild does work.  You must add it to your local overlay and then mask the openoffice packages from the official tree.  If you don't know how to do this, please see the documentation for your respective package manager, paludis a.k.a. cave or portage a.k.a. emerge.  Quick and dirty:
1. Create local overlay
2. Add this ebuild to app-office/openoffice/*
3. Copy patch files from /usr/portage/app-openoffice/files to localoverlay/app-openoffice/files
4.Mask the official versions of package using appropriate files (etc/portage/package.mask - /etc/paludis/package_mask.conf)
5. Unmask local overlay package. (Opposite of 4.)
6. emerge/install
Comment 9 Carter Young 2011-02-08 03:54:51 UTC
(In reply to comment #8)
> (In reply to comment #7)
> > The problem still exists with openoffice-3.2.1-r1 and I am not able to adapt
> > the ebuild to make it work.
> > 
> 
> This ebuild does work.  You must add it to your local overlay and then mask the
> openoffice packages from the official tree.  If you don't know how to do this,
> please see the documentation for your respective package manager, paludis
> a.k.a. cave or portage a.k.a. emerge.  Quick and dirty:
> 1. Create local overlay
> 2. Add this ebuild to app-office/openoffice/*
> 3. Copy patch files from /usr/portage/app-openoffice/files to
> localoverlay/app-openoffice/files
> 4.Mask the official versions of package using appropriate files
> (etc/portage/package.mask - /etc/paludis/package_mask.conf)
> 5. Unmask local overlay package. (Opposite of 4.)
> 6. emerge/install
> 

Last snippet of my build logs(I'm sure there is a way around this)

Entering /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app
Compiling: vcl/unx/source/app/i18n_cb.cxx
Compiling: vcl/unx/source/app/i18n_ic.cxx
Compiling: vcl/unx/source/app/i18n_im.cxx
Compiling: vcl/unx/source/app/i18n_xkb.cxx
Compiling: vcl/unx/source/app/i18n_wrp.cxx
Compiling: vcl/unx/source/app/i18n_status.cxx
Compiling: vcl/unx/source/app/i18n_keysym.cxx
Compiling: vcl/unx/source/app/saldata.cxx
/var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldata.cxx: In member function 'virtual void SalXLib::Wakeup()':
/var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldata.cxx:801: warning: ignoring return value of 'ssize_t write(int, const void*, size_t)', declared with attribute warn_unused_result
Compiling: vcl/unx/source/app/saltimer.cxx
Compiling: vcl/unx/source/app/saldisp.cxx
In file included from ../../../unx/inc/salobj.h:33,
                 from /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldisp.cxx:98:
../../../inc/vcl/salobj.hxx:74: warning: unused parameter 'bEnable'
In file included from /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldisp.cxx:101:
../../../unx/inc/dtint.hxx:41: error: using typedef-name 'Display' after 'struct'
/usr/include/X11/Xlib.h:495: error: 'Display' has a previous declaration here
../../../unx/inc/dtint.hxx:42: error: using typedef-name 'XEvent' after 'struct'
/usr/include/X11/Xlib.h:1017: error: 'XEvent' has a previous declaration here
rmdir /var/tmp/paludis/app-office-openoffice-3.2.1/temp/bYaF9TPRCB
dmake:  Error code 1, while making '../../../unxlngx6.pro/slo/saldisp.obj'

ERROR: Error 65280 occurred while making /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app
make: *** [stamp/build] Error 1
-----
tried 1st with kde enabled then disabled kde enabled gnome,gtk, same error either way
Comment 10 Carter Young 2011-02-08 04:11:54 UTC
(In reply to comment #9)
> (In reply to comment #8)
> > (In reply to comment #7)
> > > The problem still exists with openoffice-3.2.1-r1 and I am not able to adapt
> > > the ebuild to make it work.
> > > 
> > 
> > This ebuild does work.  You must add it to your local overlay and then mask the
> > openoffice packages from the official tree.  If you don't know how to do this,
> > please see the documentation for your respective package manager, paludis
> > a.k.a. cave or portage a.k.a. emerge.  Quick and dirty:
> > 1. Create local overlay
> > 2. Add this ebuild to app-office/openoffice/*
> > 3. Copy patch files from /usr/portage/app-openoffice/files to
> > localoverlay/app-openoffice/files
> > 4.Mask the official versions of package using appropriate files
> > (etc/portage/package.mask - /etc/paludis/package_mask.conf)
> > 5. Unmask local overlay package. (Opposite of 4.)
> > 6. emerge/install
> > 
> 
> Last snippet of my build logs(I'm sure there is a way around this)
> 
> Entering
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app
> Compiling: vcl/unx/source/app/i18n_cb.cxx
> Compiling: vcl/unx/source/app/i18n_ic.cxx
> Compiling: vcl/unx/source/app/i18n_im.cxx
> Compiling: vcl/unx/source/app/i18n_xkb.cxx
> Compiling: vcl/unx/source/app/i18n_wrp.cxx
> Compiling: vcl/unx/source/app/i18n_status.cxx
> Compiling: vcl/unx/source/app/i18n_keysym.cxx
> Compiling: vcl/unx/source/app/saldata.cxx
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldata.cxx:
> In member function 'virtual void SalXLib::Wakeup()':
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldata.cxx:801:
> warning: ignoring return value of 'ssize_t write(int, const void*, size_t)',
> declared with attribute warn_unused_result
> Compiling: vcl/unx/source/app/saltimer.cxx
> Compiling: vcl/unx/source/app/saldisp.cxx
> In file included from ../../../unx/inc/salobj.h:33,
>                  from
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldisp.cxx:98:
> ../../../inc/vcl/salobj.hxx:74: warning: unused parameter 'bEnable'
> In file included from
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app/saldisp.cxx:101:
> ../../../unx/inc/dtint.hxx:41: error: using typedef-name 'Display' after
> 'struct'
> /usr/include/X11/Xlib.h:495: error: 'Display' has a previous declaration here
> ../../../unx/inc/dtint.hxx:42: error: using typedef-name 'XEvent' after
> 'struct'
> /usr/include/X11/Xlib.h:1017: error: 'XEvent' has a previous declaration here
> rmdir /var/tmp/paludis/app-office-openoffice-3.2.1/temp/bYaF9TPRCB
> dmake:  Error code 1, while making '../../../unxlngx6.pro/slo/saldisp.obj'
> 
> ERROR: Error 65280 occurred while making
> /var/tmp/paludis/app-office-openoffice-3.2.1/work/ooo/build/OOO320_m19/vcl/unx/source/app
> make: *** [stamp/build] Error 1
> -----
> tried 1st with kde enabled then disabled kde enabled gnome,gtk, same error
> either way
> 

Can we get a version bump to 2.0  Would that help??
Comment 11 Tomáš Chvátal (RETIRED) gentoo-dev 2011-07-26 22:59:07 UTC
lo-3.4.2 and later use internal hsqldb as upstream explicitely wants 1.8.0 version and no other.

Closing as CANTFIX until upstream updates the code the way it can be unbundled.
Comment 12 Carter Young 2011-07-26 23:22:12 UTC
I urge everyone to migrate to LibreOffice.  This bug is the reason I opened Bug 359861.  Please feel free to add yourself to CC list there.