Apache OpenOffice (AOO) Bugzilla – Issue 75872
crash with postgresql-jdbc
Last modified: 2013-08-07 15:45:17 UTC
We have a database server running postgresql-8.1 Client runs Debian 3.1 (Sarge) with OpenOffice.org2.2.0 installed as Debian Packages. Jave Version is: java version "1.5.0_07" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) Java HotSpot(TM) Server VM (build 1.5.0_07-b03, mixed mode) OpenOffice-Base crashes, wenn accessing postgresql through jdbc driver version postgresql-8.1-407.jdbc3.jar, postgresql-8.2-504.jdbc2.jar and postgresql-8.2-504.jdbc3.jar. Other versions not tested. Driver connects to the database, schemas and tables ar listed correctly. Whenever one tries to open a table (simple Doubleclick on any table), OpenOffice crashes. Stack Trace is printed to stdout and included as attachment for reference. The same crash could also be reproduced on Clients running Debian 4.0 (Etch)
Created attachment 44025 [details] Stack Trace of OOo Crash while accessing postgresql with jdbc
I have just encountered the same problem. Opening the PostgreSQL database as such works, but OOo crashes when accessing a table or a view. There are quite different messages on the standard output depending on the JRE. Java 6: # # An unexpected error has been detected by Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x0620c3d7, pid=8585, tid=3056187056 # # Java VM: Java HotSpot(TM) Client VM (1.6.0-b105 mixed mode, sharing) # Problematic frame: # V [libjvm.so+0x20c3d7] # # An error report file with more information is saved as hs_err_pid8585.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # [error occurred during error reporting, step 270, id 0xb] Java 5: terminate called after throwing an instance of 'jvmaccess::VirtualMachine::AttachGuard::CreationException' terminate called recursively Java 1.4.2: Fatal: Stack size too small. Use 'java -Xss' to increase default stack size.
We have this problem too. Opening the PostgreSQL database as such works, but OOo crashes when accessing a table or a view. Same problem under Linux (Suse 9.0) and Windows XP prof. Test with postgresql jar files version 7.4 , 8.0 amd 8.2 .
Anybody willing to give the potential fix at http://dba.openoffice.org/servlets/ProjectDocumentList?folderID=547&expandFolder=547&folderID=0 (look for i74732.fix.ooo22.<your_platform>) a try, and report back whether it fixes the problem? In this case, we could mark this issue here as duplicate of issue 74732, since it has the same internal reason then.
First Impress ;) the fix works fine (Tested under Linux -- Suse 9.0)
Same here: The fix looks good! Thanks a billion!
okay, I'll mark this as duplicate of issue 74732 then. Please be aware that the fix, as mentioned on the download page, is not production quality. I discourage you from using it for production purpose! (the non-official part is that I'm pretty confident that the lib has no side effects, but hey, I am the one who also *introduced* the bug with another fix, so why wouldn't I do the same here? :) *** This issue has been marked as a duplicate of 74732 ***
*** Issue 75741 has been marked as a duplicate of this issue. ***
*** Issue 76157 has been marked as a duplicate of this issue. ***
I've tested the fix with OO 2.2 RC3 dutch w2k and it appears to fix this problem. Connection to postgresql using jdbc seems to be working fine now. Tested viewing tables and forms applying filters. Not tested: data entry. Thanks for the fix. Ferry
oobase fails to start when I apply this patch on ubuntu 7.04
Ubuntu comes with an own build of OOo. The libs provided are binary compatible with the "default build" of OOo, and thus binary incompatible to the Ubuntu build. Blame the Linux compiler people for they consider binary compatibility an unnecessary thing.
close duplicate