Issue 75872 - crash with postgresql-jdbc
Summary: crash with postgresql-jdbc
Status: CLOSED DUPLICATE of issue 74732
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2
Hardware: PC Linux, all
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
: 75741 76157 (view as issue list)
Depends on:
Reported: 2007-03-29 17:05 UTC by frichter
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Stack Trace of OOo Crash while accessing postgresql with jdbc (28.22 KB, text/plain)
2007-03-29 17:06 UTC, frichter
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description frichter 2007-03-29 17:05:10 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)
Comment 1 frichter 2007-03-29 17:06:13 UTC
Created attachment 44025 [details]
Stack Trace of OOo Crash while accessing postgresql with jdbc
Comment 2 klute 2007-03-31 11:03:44 UTC
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  []
# 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:

[error occurred during error reporting, step 270, id 0xb]

Java 5:
terminate called after throwing an instance of
terminate called recursively

Java 1.4.2:
Fatal: Stack size too small. Use 'java -Xss' to increase default stack size.
Comment 3 hawkhunter2002 2007-04-03 07:39:50 UTC
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 .
Comment 4 Frank Schönheit 2007-04-03 08:53:34 UTC
Anybody willing to give the potential fix at
(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.
Comment 5 hawkhunter2002 2007-04-03 09:47:18 UTC
First Impress ;) the fix works fine (Tested under Linux -- Suse 9.0)
Comment 6 klute 2007-04-03 10:12:05 UTC
Same here: The fix looks good! Thanks a billion!
Comment 7 Frank Schönheit 2007-04-03 11:42:26 UTC
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 ***
Comment 8 Frank Schönheit 2007-04-04 08:16:27 UTC
*** Issue 75741 has been marked as a duplicate of this issue. ***
Comment 9 Frank Schönheit 2007-04-10 07:23:04 UTC
*** Issue 76157 has been marked as a duplicate of this issue. ***
Comment 10 ftoth 2007-04-19 20:31:55 UTC
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.

Comment 11 rogerkeays 2007-05-02 07:41:22 UTC
oobase fails to start when I apply this patch on ubuntu 7.04
Comment 12 Frank Schönheit 2007-05-02 10:16:23 UTC
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.
Comment 13 christoph.lukasiak 2007-06-26 16:28:39 UTC
close duplicate