Possible issue with cwms_loc.store_loc2 and external transactions
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 38/100
- Issue type
- Bug
- Clarity
- Needs clarification
- Activity status
- Active
- Tech stack
- visualbasic
- Domain
- databases
Research direction
Start with cwms_loc.store_loc2 and the linked OpenDCS test-suite changes, then trace how tx.rollback() interacts with the site creation path. Check whether site IDs, existing-site detection, and caches participate in the transaction context. Done means reproducing the failure and identifying a confirmed transaction or caching cause with an appropriate regression test or documented finding.
Written by the indexing model from the issue text.
Description
This may be something else entirely, but opening it now in case similar issues creep up later.
The following OpenDCS test suite uses the linked method to create a list of platforms with Sites to perform it's operations. https://github.com/opendcs/opendcs/pull/2155/changes#diff-39e49efbe7e00d3e10642d1441693f93c3644f254429b264d9b943b3bea59a7aR229
After each test, tx.rollback() is called which should remove anything that was created previously.
I do not see a message that we would be updating an existing site and now errors are thrown on the method (stored procedure) execution. However, the site id is never retrieved.
Now that I type this, it is possible this has something to do with the the various caches as they most likely don't participate in the transaction context.
- Dominant language
- Visual Basic 6.0
- Stars
- 4
- Forks
- 8
- Avg merge
- 8d 20h
- Merged PRs (30d)
- 4
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from HydrologicEngineeringCenter/cwms-database
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
enhancement
HydrologicEngineeringCenter/cwms-database#231 · 1 assignee ·
-
Difficulty 4/5 3-5 days Newbie friendliness 45/100
-
HydrologicEngineeringCenter/cwms-database#223 · 3 comments · 2 assignees ·
-
Difficulty 3/5 1-2 days Newbie friendliness 48/100
All issues in HydrologicEngineeringCenter/cwms-database
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100