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

mark lewman (JIRA) jira at osuosl.org
Sun Dec 3 21:40:31 PST 2006


     [ http://bugs.osuosl.org/browse/MNT-1481?page=comments#action_11181 ]
     
mark lewman commented on MNT-1481:
----------------------------------

http://www.combas.com/fr/contacts/forum/messages/15018.html http://www.combas.com/fr/contacts/forum/messages/15019.html http://www.combas.com/fr/contacts/forum/messages/15020.html http://www.combas.com/fr/contacts/forum/messages/15021.html http://www.combas.com/fr/contacts/forum/messages/15022.html http://www.combas.com/fr/contacts/forum/messages/15023.html http://www.combas.com/fr/contacts/forum/messages/15024.html http://www.combas.com/fr/contacts/forum/messages/15025.html http://www.combas.com/fr/contacts/forum/messages/15026.html http://www.combas.com/fr/contacts/forum/messages/15027.html http://www.combas.com/fr/contacts/forum/messages/15028.html http://www.combas.com/fr/contacts/forum/messages/15029.html http://www.combas.com/fr/contacts/forum/messages/15030.html http://www.combas.com/fr/contacts/forum/messages/15031.html http://www.combas.com/fr/contacts/forum/messages/15032.html http://www.combas.com/fr/contacts/forum/messages/15033.html http://www.combas.com/fr/contacts/forum/messages/15034.html http://www.combas.com/fr/contacts/forum/messages/15035.html http://www.combas.com/fr/contacts/forum/messages/15036.html http://www.combas.com/fr/contacts/forum/messages/15037.html http://www.combas.com/fr/contacts/forum/messages/15038.html http://www.combas.com/fr/contacts/forum/messages/15039.html http://www.combas.com/fr/contacts/forum/messages/15040.html http://www.combas.com/fr/contacts/forum/messages/15041.html http://www.combas.com/fr/contacts/forum/messages/15042.html http://www.combas.com/fr/contacts/forum/messages/15043.html http://www.combas.com/fr/contacts/forum/messages/15044.html http://www.combas.com/fr/contacts/forum/messages/15045.html http://www.combas.com/fr/contacts/forum/messages/15046.html http://www.combas.com/fr/contacts/forum/messages/15047.html http://www.combas.com/fr/contacts/forum/messages/15048.html http://www.combas.com/fr/contacts/forum/messages/15049.html http://www.combas.com/fr/contacts/forum/messages/15050.html http://www.combas.com/fr/contacts/forum/messages/15051.html http://www.combas.com/fr/contacts/forum/messages/15052.html http://www.combas.com/fr/contacts/forum/messages/15053.html http://www.combas.com/fr/contacts/forum/messages/15054.html http://www.combas.com/fr/contacts/forum/messages/15055.html http://www.combas.com/fr/contacts/forum/messages/15056.html http://www.combas.com/fr/contacts/forum/messages/15057.html http://www.combas.com/fr/contacts/forum/messages/15058.html http://www.combas.com/fr/contacts/forum/messages/15059.html http://www.combas.com/fr/contacts/forum/messages/15060.html http://www.combas.com/fr/contacts/forum/messages/15061.html http://www.combas.com/fr/contacts/forum/messages/15062.html http://www.combas.com/fr/contacts/forum/messages/15063.html http://www.combas.com/fr/contacts/forum/messages/15064.html http://www.combas.com/fr/contacts/forum/messages/15065.html http://www.combas.com/fr/contacts/forum/messages/15066.html http://www.combas.com/fr/contacts/forum/messages/15067.html http://www.combas.com/fr/contacts/forum/messages/15068.html http://www.combas.com/fr/contacts/forum/messages/15069.html http://www.combas.com/fr/contacts/forum/messages/15070.html http://www.combas.com/fr/contacts/forum/messages/15071.html http://www.combas.com/fr/contacts/forum/messages/15072.html http://www.combas.com/fr/contacts/forum/messages/15073.html http://www.combas.com/fr/contacts/forum/messages/15074.html http://www.combas.com/fr/contacts/forum/messages/15075.html http://www.combas.com/fr/contacts/forum/messages/15076.html http://www.combas.com/fr/contacts/forum/messages/15077.html http://www.combas.com/fr/contacts/forum/messages/15078.html http://www.combas.com/fr/contacts/forum/messages/15079.html http://www.combas.com/fr/contacts/forum/messages/15080.html http://www.combas.com/fr/contacts/forum/messages/15081.html http://www.combas.com/fr/contacts/forum/messages/15082.html http://www.combas.com/fr/contacts/forum/messages/15083.html http://www.combas.com/fr/contacts/forum/messages/15084.html http://www.combas.com/fr/contacts/forum/messages/15085.html http://www.combas.com/fr/contacts/forum/messages/15086.html http://www.combas.com/fr/contacts/forum/messages/15087.html http://www.combas.com/fr/contacts/forum/messages/15088.html http://www.combas.com/fr/contacts/forum/messages/15089.html http://www.combas.com/fr/contacts/forum/messages/15090.html http://www.combas.com/fr/contacts/forum/messages/15091.html http://www.combas.com/fr/contacts/forum/messages/15092.html http://www.combas.com/fr/contacts/forum/messages/15093.html http://www.combas.com/fr/contacts/forum/messages/15094.html http://www.combas.com/fr/contacts/forum/messages/15095.html http://www.combas.com/fr/contacts/forum/messages/15096.html http://www.combas.com/fr/contacts/forum/messages/15097.html http://www.combas.com/fr/contacts/forum/messages/15098.html http://www.combas.com/fr/contacts/forum/messages/15099.html http://www.combas.com/fr/contacts/forum/messages/15100.html http://www.combas.com/fr/contacts/forum/messages/15101.html http://www.combas.com/fr/contacts/forum/messages/15102.html http://www.combas.com/fr/contacts/forum/messages/15103.html http://www.combas.com/fr/contacts/forum/messages/15104.html http://www.combas.com/fr/contacts/forum/messages/15105.html http://www.combas.com/fr/contacts/forum/messages/15106.html http://www.combas.com/fr/contacts/forum/messages/15107.html http://www.combas.com/fr/contacts/forum/messages/15108.html http://www.combas.com/fr/contacts/forum/messages/15109.html http://www.combas.com/fr/contacts/forum/messages/15110.html http://www.combas.com/fr/contacts/forum/messages/15111.html http://www.combas.com/fr/contacts/forum/messages/15112.html http://www.combas.com/fr/contacts/forum/messages/15113.html http://www.combas.com/fr/contacts/forum/messages/15114.html http://www.combas.com/fr/contacts/forum/messages/15115.html http://www.combas.com/fr/contacts/forum/messages/15116.html http://www.combas.com/fr/contacts/forum/messages/15117.html 

> 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: Brad Morgan
>     Priority: Urgent
>      Fix For: 3.0

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