[prev in list] [next in list] [prev in thread] [next in thread]
List: nepomuk
Subject: Re: [Nepomuk] Review Request: DMM: Auto-commit after each data manipulation statement
From: "Sebastian Trueg" <sebastian () trueg ! de>
Date: 2012-12-11 9:57:36
Message-ID: 20121211095736.13420.46455 () vidsolbach ! de
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
http://git.reviewboard.kde.org/r/107630/#review23306
-----------------------------------------------------------
services/storage/datamanagementmodel.cpp
<http://git.reviewboard.kde.org/r/107630/#comment17928>
I think it should be 2 instead of 3. Or do we need logging?
- Sebastian Trueg
On Dec. 7, 2012, 7:51 p.m., Vishesh Handa wrote:
> =
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> http://git.reviewboard.kde.org/r/107630/
> -----------------------------------------------------------
> =
> (Updated Dec. 7, 2012, 7:51 p.m.)
> =
> =
> Review request for Nepomuk and Sebastian Trueg.
> =
> =
> Description
> -------
> =
> With the ResourceMerger rewrite we no longer push one statement at a
> time. We now push them in one large statement. This has been shown to
> cause transaction deadlocks in virtuoso. It is recommended to set
> log_enable( 3 ) in order to auto commit after each data manipulation
> command.
> =
> Ideally we should have proper transaction support and each command in
> the data management model should be a separate transaction. However,
> this will have to do until we figure out how to do that.
> =
> =
> Diffs
> -----
> =
> services/storage/datamanagementmodel.cpp 4568e49 =
> =
> Diff: http://git.reviewboard.kde.org/r/107630/diff/
> =
> =
> Testing
> -------
> =
> Still testing to see if I receive any transaction deadlocked errors.
> =
> =
> Thanks,
> =
> Vishesh Handa
> =
>
[Attachment #5 (text/html)]
<html>
<body>
<div style="font-family: Verdana, Arial, Helvetica, Sans-Serif;">
<table bgcolor="#f9f3c9" width="100%" cellpadding="8" style="border: 1px #c9c399 \
solid;"> <tr>
<td>
This is an automatically generated e-mail. To reply, visit:
<a href="http://git.reviewboard.kde.org/r/107630/">http://git.reviewboard.kde.org/r/107630/</a>
</td>
</tr>
</table>
<br />
<div>
<table width="100%" border="0" bgcolor="white" style="border: 1px solid #C0C0C0; \
border-collapse: collapse; margin: 2px padding: 2px;"> <thead>
<tr>
<th colspan="4" bgcolor="#F0F0F0" style="border-bottom: 1px solid #C0C0C0; \
font-size: 9pt; padding: 4px 8px; text-align: left;"> <a \
href="http://git.reviewboard.kde.org/r/107630/diff/1/?file=97566#file97566line226" \
style="color: black; font-weight: bold; text-decoration: \
underline;">services/storage/datamanagementmodel.cpp</a> <span style="font-weight: \
normal;">
(Diff revision 1)
</span>
</th>
</tr>
</thead>
<tbody style="background-color: #e4d9cb; padding: 4px 8px; text-align: center;">
<tr>
<td colspan="4"><pre style="font-size: 8pt; line-height: 140%; margin: 0; \
">Nepomuk2::DataManagementModel::DataManagementModel(Nepomuk2::ClassAndPropertyTree* \
tree, Soprano::Model* model, QObject *parent)</pre></td>
</tr>
</tbody>
<tbody>
<tr>
<th bgcolor="#b1ebb0" style="border-right: 1px solid #C0C0C0;" \
align="right"><font size="2"></font></th> <td bgcolor="#c5ffc4" width="50%"><pre \
style="font-size: 8pt; line-height: 140%; margin: 0; "></pre></td> <th \
bgcolor="#b1ebb0" style="border-left: 1px solid #C0C0C0; border-right: 1px solid \
#C0C0C0;" align="right"><font size="2">226</font></th> <td bgcolor="#c5ffc4" \
width="50%"><pre style="font-size: 8pt; line-height: 140%; margin: 0; "> <span \
class="n">QLatin1String</span> <span class="n">command</span><span \
class="p">(</span><span class="s">"log_enable( 3 )"</span><span \
class="p">);</span></pre></td> </tr>
</tbody>
</table>
<pre style="margin-left: 2em; white-space: pre-wrap; white-space: -moz-pre-wrap; \
white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">I think it \
should be 2 instead of 3. Or do we need logging?</pre> </div>
<br />
<p>- Sebastian</p>
<br />
<p>On December 7th, 2012, 7:51 p.m., Vishesh Handa wrote:</p>
<table bgcolor="#fefadf" width="100%" cellspacing="0" cellpadding="8" \
style="background-image: \
url('http://git.reviewboard.kde.org/media/rb/images/review_request_box_top_bg.png'); \
background-position: left top; background-repeat: repeat-x; border: 1px black \
solid;"> <tr>
<td>
<div>Review request for Nepomuk and Sebastian Trueg.</div>
<div>By Vishesh Handa.</div>
<p style="color: grey;"><i>Updated Dec. 7, 2012, 7:51 p.m.</i></p>
<h1 style="color: #575012; font-size: 10pt; margin-top: 1.5em;">Description </h1>
<table width="100%" bgcolor="#ffffff" cellspacing="0" cellpadding="10" \
style="border: 1px solid #b8b5a0"> <tr>
<td>
<pre style="margin: 0; padding: 0; white-space: pre-wrap; white-space: \
-moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: \
break-word;"> With the ResourceMerger rewrite we no longer push one statement at a \
time. We now push them in one large statement. This has been shown to cause \
transaction deadlocks in virtuoso. It is recommended to set log_enable( 3 ) in order \
to auto commit after each data manipulation command.
Ideally we should have proper transaction support and each command in
the data management model should be a separate transaction. However,
this will have to do until we figure out how to do that.
</pre>
</td>
</tr>
</table>
<h1 style="color: #575012; font-size: 10pt; margin-top: 1.5em;">Testing </h1>
<table width="100%" bgcolor="#ffffff" cellspacing="0" cellpadding="10" style="border: \
1px solid #b8b5a0"> <tr>
<td>
<pre style="margin: 0; padding: 0; white-space: pre-wrap; white-space: \
-moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: \
break-word;">Still testing to see if I receive any transaction deadlocked \
errors.</pre> </td>
</tr>
</table>
<h1 style="color: #575012; font-size: 10pt; margin-top: 1.5em;">Diffs</b> </h1>
<ul style="margin-left: 3em; padding-left: 0;">
<li>services/storage/datamanagementmodel.cpp <span style="color: \
grey">(4568e49)</span></li>
</ul>
<p><a href="http://git.reviewboard.kde.org/r/107630/diff/" style="margin-left: \
3em;">View Diff</a></p>
</td>
</tr>
</table>
</div>
</body>
</html>
_______________________________________________
Nepomuk mailing list
Nepomuk@kde.org
https://mail.kde.org/mailman/listinfo/nepomuk
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic