| [CDO] list=>database mapping: internal index is wrong in rare cases [message #1851839] |
Tue, 19 April 2022 13:43 |
 Robert Schulk
Messages: 144
Registered: July 2015 |
Senior Member |
|
|
We are using the CDO release 2022-03.
The error's symptoms are seen during element removal from the list (see attachment stacktrace_element_removal.txt), but I think the problem occurs during insertion.
We are always inserting elements at list index 0. Now, when looking at the database, I see the following two tables (reduced to relevent rows):
Elements which reside in the list:
+----------+-------------+---------------+-------------+--------------+---------------+-------------+---------------------+--------+---------+----------------+
| CDO_ID | CDO_VERSION | CDO_CREATED | CDO_REVISED | CDO_RESOURCE | CDO_CONTAINER | CDO_FEATURE | EXECUTIONEND | STATUS | COMMENT | FAILUREMESSAGE |
+----------+-------------+---------------+-------------+--------------+---------------+-------------+---------------------+--------+---------+----------------+
| 24671156 | 2 | 1650243425591 | 0 | 0 | 20429330 | -2 | 2022-04-18 00:57:05 | 2 | NULL | NULL |
| 24671165 | 2 | 1650243485554 | 0 | 0 | 20429330 | -2 | 2022-04-18 00:58:05 | 2 | NULL | NULL |
| 24671178 | 2 | 1650243545594 | 0 | 0 | 20429330 | -2 | 2022-04-18 00:59:05 | 2 | NULL | NULL |
| 24671188 | 2 | 1650243605639 | 0 | 0 | 20429330 | -2 | 2022-04-18 01:00:05 | 2 | NULL | NULL |
| 24671195 | 2 | 1650243605997 | 0 | 0 | 20429330 | -2 | 2022-04-18 01:00:05 | 2 | NULL | NULL |
| 24671205 | 2 | 1650243665799 | 0 | 0 | 20429330 | -2 | 2022-04-18 01:01:05 | 2 | NULL | NULL |
+----------+-------------+---------------+-------------+--------------+---------------+-------------+---------------------+--------+---------+----------------+
List definition:
+------------+---------+-----------+
| CDO_SOURCE | CDO_IDX | CDO_VALUE |
+------------+---------+-----------+
| 20429330 | -28136 | 24671195 |
| 20429330 | -28135 | 24671188 |
| 20429330 | -28134 | 24671178 |
| 20429330 | -28133 | 24671165 |
| 20429330 | -28132 | 24671156 |
| 20429330 | -28104 | 24671205 |
+------------+---------+-----------+
The element which was inserted last with CDOID=24671205 seems to have received a wrong list index. It got -28104, but it should have been -28137.
Note: the list resides within the value of a map. I.e. Map<String, List<Element>>, but I think the problem is probably unrelated to that.
|
|
|
Powered by
FUDForum. Page generated in 0.02708 seconds
] 
Search
Help
Register
Login
Home
