Getting an error on some branches when committed [message #16204] |
Wed, 01 July 2009 16:46  |
Mark D-B Messages: 188 Registered: July 2009 |
Senior Member |
|
|
When I commit some branches back to their parent, they work fine.
However, if more complex work is done, they fail with something of the
following form:
sql update failed:
INSERT IGNORE INTO osee_removed_txs (transaction_id, rem_mod_type,
rem_tx_current, rem_transaction_id, rem_gamma_id) (SELECT ?, txs.mod_type,
txs.tx_current, txs.transaction_id, txs.gamma_id FROM osee_txs txs WHERE
txs.gamma_id = ? AND txs.transaction_id = ?)
[ DATA OBJECT:
0: java.lang.Integer:647
1: java.lang.Integer:9618
2: java.lang.Integer:576
0: java.lang.Integer:647
1: java.lang.Integer:9618
2: java.lang.Integer:584
0: java.lang.Integer:647
1: java.lang.Integer:9619
2: java.lang.Integer:576
0: java.lang.Integer:647
1: java.lang.Integer:9619
2: java.lang.Integer:584
0: java.lang.Integer:647
1: java.lang.Integer:9622
2: java.lang.Integer:577
0: java.lang.Integer:647
1: java.lang.Integer:9623
2: java.lang.Integer:577
0: java.lang.Integer:647
1: java.lang.Integer:9627
2: java.lang.Integer:577
0: java.lang.Integer:647
1: java.lang.Integer:9628
2: java.lang.Integer:577
0: java.lang.Integer:647
1: java.lang.Integer:10101
2: java.lang.Integer:579
0: java.lang.Integer:647
1: java.lang.Integer:10102
2: java.lang.Integer:579
0: java.lang.Integer:647
1: java.lang.Integer:10104
2: java.lang.Integer:580
0: java.lang.Integer:647
1: java.lang.Integer:10105
2: java.lang.Integer:580
0: java.lang.Integer:647
1: java.lang.Integer:10107
2: java.lang.Integer:581
0: java.lang.Integer:647
1: java.lang.Integer:10108
2: java.lang.Integer:581
0: java.lang.Integer:647
1: java.lang.Integer:10110
2: java.lang.Integer:582
0: java.lang.Integer:647
1: java.lang.Integer:9617
2: java.lang.Integer:576
0: java.lang.Integer:647
1: java.lang.Integer:10115
2: java.lang.Integer:584
]
This is worrying. Can anyone explain what the problem is please?
|
|
|
|
Re: Getting an error on some branches when committed [message #16232 is a reply to message #16219] |
Thu, 02 July 2009 10:58   |
Mark D-B Messages: 188 Registered: July 2009 |
Senior Member |
|
|
Adding the following database table resolved the problem.
If a developer could look at this to see if there are any constraints,
indexes, etc which are wrong I will be very grateful. Also, I would like
to know please whether the fact this table was not created was user error
or needs raising on bugzilla.
- Table: osee.osee_removed_txs
-- DROP TABLE osee.osee_removed_txs;
CREATE TABLE osee.osee_removed_txs
(
transaction_id integer NOT NULL,
rem_mod_type integer,
rem_tx_current integer NOT NULL,
rem_transaction_id integer NOT NULL,
rem_gamma_id numeric NOT NULL,
CONSTRAINT osee_removed_txs_pkey PRIMARY KEY (rem_transaction_id,
rem_gamma_id)
)
WITH (OIDS=FALSE);
ALTER TABLE osee.osee_removed_txs OWNER TO osee;
COMMENT ON TABLE osee.osee_removed_txs IS 'Created manually by M.D-B
because it was not here and OSEE seemed to need it to merge a branch back
to its parent.';
|
|
|
|
|
|
|
Re: Getting an error on some branches when committed [message #574342 is a reply to message #16219] |
Thu, 02 July 2009 10:58  |
Mark D-B Messages: 188 Registered: July 2009 |
Senior Member |
|
|
Adding the following database table resolved the problem.
If a developer could look at this to see if there are any constraints,
indexes, etc which are wrong I will be very grateful. Also, I would like
to know please whether the fact this table was not created was user error
or needs raising on bugzilla.
- Table: osee.osee_removed_txs
-- DROP TABLE osee.osee_removed_txs;
CREATE TABLE osee.osee_removed_txs
(
transaction_id integer NOT NULL,
rem_mod_type integer,
rem_tx_current integer NOT NULL,
rem_transaction_id integer NOT NULL,
rem_gamma_id numeric NOT NULL,
CONSTRAINT osee_removed_txs_pkey PRIMARY KEY (rem_transaction_id,
rem_gamma_id)
)
WITH (OIDS=FALSE);
ALTER TABLE osee.osee_removed_txs OWNER TO osee;
COMMENT ON TABLE osee.osee_removed_txs IS 'Created manually by M.D-B
because it was not here and OSEE seemed to need it to merge a branch back
to its parent.';
|
|
|
Re: Getting an error on some branches when committed [message #574419 is a reply to message #16232] |
Fri, 17 July 2009 02:49  |
Ryan D. Brooks Messages: 100 Registered: July 2009 |
Senior Member |
|
|
Mark,
The osee database schema used during database initialization is defined at
/org.eclipse.osee.framework.skynet.core/dbschemas/SKYNET.VER SIONING.SCHEMA.xml.
For the latest version of this file on trunk, 23845, the definition of
the table OSEE_REMOVED_TXS is:
<Table name="OSEE_REMOVED_TXS" schema="OSEE" tablespace="osee_data">
<Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
<Column id="REM_GAMMA_ID" defaultValue="not null" type="BIGINT" />
<Column id="REM_MOD_TYPE" defaultValue="not null" type="INTEGER" />
<Column id="REM_TX_CURRENT" defaultValue="not null" type="INTEGER" />
<Column id="REM_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
<Constraint schema="OSEE" id="OSEE_REM_TXS_RG_RTX_PK" type="PRIMARY KEY"
appliesTo="REM_GAMMA_ID, REM_TRANSACTION_ID"/>
<Constraint schema="OSEE" id="OSEE_TRANSACTION_ID_FK3" type="FOREIGN KEY"
appliesTo="TRANSACTION_ID" deferrable="true">
<References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID"
onDelete="CASCADE" />
</Constraint>
</Table>
I tried a local database initialization and the OSEE_REMOVED_TXS table was
created, so I wasn't able to repeat the problem. Based on the file
history, I don't think this table's definition has changed since it was
added on 2009-02-19. I guess you could look in your install to check the
contents of SKYNET.VERSIONING.SCHEMA.xml which is inside a jar file in the
plugins folder of your Eclipse install named something like
org.eclipse.osee.framework.skynet.core_0.4.0.200906291333.ja r.
Thanks,
Ryan
P.S. Nice work working around the problem!
Thanks,
Ryan Brooks
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.02801 seconds