[Maintain-dev] [JIRA] Updated: (MNT-1481) Big DB operations have to happen in transaction so that no inconsistent state is propagated to the config files

Frederic Wenzel (JIRA) jira at osuosl.org
Fri Jul 7 11:09:31 PDT 2006


     [ http://bugs.osuosl.org/browse/MNT-1481?page=history ]

Frederic Wenzel updated MNT-1481:
---------------------------------

    Summary: Big DB operations have to happen in transaction so that no inconsistent state is propagated to the config files  (was: Big DB operations have ot happen in transaction so that no inconsistent state is propagated to the config files)

> Big DB operations have to happen in transaction so that no inconsistent state is propagated to the config files
> ---------------------------------------------------------------------------------------------------------------
>
>          Key: MNT-1481
>          URL: http://bugs.osuosl.org/browse/MNT-1481
>      Project: Maintain
>         Type: Task
>   Components: Database
>     Versions: 3.0
>     Reporter: Frederic Wenzel
>     Assignee: Michael Clay
>     Priority: Urgent

>
>
> Currently, our dataobjects to not use transactions. This can lead to problems when changes are made while the backend is built.
> When the backend process gets an inconsistent state, we'll have unpredictable results in the config files.
> There is no problem for one-row-operations (since both states before and after will be consistent) but when more complex operations are executed (with more than one SQL statement), they have to happen inside a transaction.
> Tasks:
> - find out if MySQL's MyISAM table format supports transactions, meanwhile. If not, switch to one that does (transparently) and reflect these changes in the update and install sql scripts.
> - Find out how DB_DataObjects handle transactions or how to teach them. This can happen as a DB_DataObject command, or maybe the START TRANSACTION and COMMIT statements have to be sent to the db handle in clear text before and after the DB_DataObject update stuff.
> - Analyze the source tree for such multi-statement issues
> - Apply the solution to all of these issues.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://bugs.osuosl.org/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira



More information about the Maintain-dev mailing list