In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

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 EstimateNo 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.
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to 0000050closed (5.0.0)alex Improvements of CheckSimultaneousEdit functionality 
related to 0000051closed (5.0.0)alex Improvements to Duplicate Submit checks 

-  Notes
User avatar (0000155)
alex (manager)
2009-07-19 08:18

Fix committed to RC branch. Commit Message:

Fixes 0000052: Preventing Data loss from Temporarily tables
User avatar (0000648)
administrator (administrator)
2009-10-03 07:56

Closing issues from 5.0.0 version, because version was already released.

- 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 ]

- 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

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker