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
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...
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?
(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
Created attachment 247646 [details] Ebuild for openoffice without --enable-system-hsqldb
(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?
(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.
The problem still exists with openoffice-3.2.1-r1 and I am not able to adapt the ebuild to make it work.
(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
(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
(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??
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.
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.
