| Anonymous | Login | Signup for a new account | 2023-10-03 07:02 CDT | |
| Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
| Viewing Issue Advanced Details [ Jump to Notes ] [ Wiki ] | [ View Simple ] [ Issue History ] [ Print ] | ||||||
| ID | Category | Type | Reproducibility | Date Submitted | Last Update | ||
| 0000052 | [In-Portal CMS] Data Management | bug report | random | 2009-06-07 07:42 | 2009-10-03 07:56 | ||
| Reporter | alex | View Status | public | Project Name | In-Portal CMS | ||
| Assigned To | alex | Developer | |||||
| Priority | normal | Resolution | fixed | Platform | |||
| Status | closed | OS | |||||
| OS Version | |||||||
| ETA | none | Fixed in Version | 5.0.0 | Product Version | |||
| Target Version | 5.0.0 | Product Build | |||||
| Time Estimate | No estimate | ||||||
| Summary | 0000052: Preventing Data loss from Temporarily tables | ||||||
| Description | We could lost data, when 2 concurrently running processes tries to copy data from same temporary table to live table. To prevent this I propose to implement semaphore system. Idea is to put all processes, that required temp->live operation to queue using database lock feature. | ||||||
| Steps To Reproduce | Preventing Data loss from Temporarily tables | ||||||
| Additional Information |
Implementing logic: Add new Semaphores table, that will consist of Timestamp, SessionKey and MainPrefix columns. Before temp to live coping starts open second database connection and lock Semaphores table (new table). Then we should search for any record for our prefix. When found we release lock, wait for 1 second and repeat previous steps. In case, when we totally have waited for 30 seconds, then exit from coping process with error. If at some point we haven't found record with our prefix, then we should add one and release lock. Perform coping from temp to live. Lock Semaphores table and delete our previously added record and release lock. This way if two (or more) temp handlers will meet, then they will wait for each other and won't start to work concurrently. |
||||||
| Tags | No tags attached. | ||||||
| Reference | |||||||
| Change Log Message | |||||||
| Estimate Points | 0 | ||||||
| Attached Files | |||||||
|
|
|||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||
|
|||||||||||
 Relationships |
|
Notes |
|
 (0000155)alex (manager) 2009-07-19 08:18 |
Fix committed to RC branch. Commit Message: Fixes 0000052: Preventing Data loss from Temporarily tables |
 (0000648)administrator (administrator) 2009-10-03 07:56 |
Closing issues from 5.0.0 version, because version was already released. |
|
Notes |
| Related Changesets |
|||
|
In-Portal CMS: RC r11933 Timestamp: 2009-07-19 08:18:46 Author: alex [ Details ] [ Diff ] |
Fixes 0000052: Preventing Data loss from Temporarily tables | ||
| mod - /in-portal/branches/RC/core/admin_templates/incs/footer.tpl | [ Diff ] [ File ] | ||
| mod - /in-portal/branches/RC/core/install/install_schema.sql | [ Diff ] [ File ] | ||
| mod - /in-portal/branches/RC/core/install/remove_schema.sql | [ Diff ] [ File ] | ||
| mod - /in-portal/branches/RC/core/install/upgrades.sql | [ Diff ] [ File ] | ||
| mod - /in-portal/branches/RC/core/kernel/db/db_event_handler.php | [ Diff ] [ File ] | ||
| mod - /in-portal/branches/RC/core/kernel/utility/temp_handler.php | [ Diff ] [ File ] | ||
| Related Changesets |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-03 07:56 | administrator | Note Added: 0000648 | |
| 2009-10-03 07:56 | administrator | Status | resolved => closed |
| 2009-07-19 08:19 | alex | Fixed in Version | => 5.0.0 |
| 2009-07-19 08:19 | alex | Target Version | Icebox => 5.0.0 |
| 2009-07-19 08:18 | alex | Note Added: 0000155 | |
| 2009-07-19 08:18 | alex | Status | active => resolved |
| 2009-07-19 08:18 | alex | Resolution | open => fixed |
| 2009-07-19 08:18 | alex | Assigned To | => alex |
| 2009-07-19 08:18 | alex | Changeset attached | RC r11933 |
| 2009-06-07 16:38 | Dmitry | Target Version | => Icebox |
| 2009-06-07 16:38 | Dmitry | Summary | Prevent data loss in temp tables => Preventing Data loss from Temporarily tables |
| 2009-06-07 16:38 | Dmitry | Steps to Reproduce Updated | View Revisions |
| 2009-06-07 07:43 | alex | Relationship added | related to 0000051 |
| 2009-06-07 07:43 | alex | Relationship added | related to 0000050 |
| 2009-06-07 07:42 | alex | New Issue | |
|
Issue History |
| Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic
In-Portal Open Source CMS |
Copyright © 2000 - 2009 MantisBT Group
 |