Red Hat Bugzilla – Bug 192403
oobase crashes on record insert to a postgres db through ODBC
Last modified: 2007-11-30 17:11:33 EST
Description of problem:
When a record is inserted in a table that is accessed through ODBC and has a
primary key in it, if the PK is not filled in by the user oobase crashes.
Version-Release number of selected component (if applicable):
On a Fedora Core 4 system with the following versions:
Steps to Reproduce:
Begin with a postgres database that has a single table (ptab).
The table has three fields, setup as follows:
CREATE TABLE ptab (
tadtest_id integer DEFAULT nextval('"ptab_tadtest_id_seq"'::text) NOT NULL,
tadtest character varying(50),
tadsecitem character varying(15)
tadtest_id is a SEQUENCEd number.
[I attached the following on the OOo bugzilla:
a dump and script to load the database, .odbc.ini, and the
testingdb.odb I used. Also included my firstInsert.txt and
secondInsert.txt crash info files]
ODBC is setup with a .odbc.ini.
Method for problem replication:
1) oobase ~/testingdb.odb> firstInsert.txt 2>&1
2) select Tables
3) double click ptab
4) click in tadtest field
5) type "test"
6) press tab
7) type "test"
8) press enter
9) capture crash info.
10) oobase ~/testingdb.odb> secondInsert.txt 2>&1
11) click "start recovery"
12) select Tables
13) double click ptab
14) click in tadtest field for a new record (i.e. create record 2)
15) do steps 5-9 again
Be ready to work on the next record.
See files inserted in to the OOo bugzilla.
Note that AFAIK the proposed fix (attached to OOo bz 64427) dba203c _May_ be in
OOo 2.0.3 acording to
but any Fedora that has versions between openoffice.org-core-220.127.116.11-5.1 and the
OOo release 2.0.3 are probably affected by this bug as well. (should this bug be
cloned into FC5 and test/RawHide?)
It'd be nice to be able to backport all crash fixes to all supported releases,
but resources limit that to the most serious and widespread problems.
We'll pick it up in the 2.0.3 release in rawhide/fc6 onwards.