RE: why does tortoise, wcng and cygwin break from icon caching?

Bert Huijben <[email protected]> Fri, 6 Jul 2012 01:20:31 -0700
Newsgroups gmane.comp.version-control.subversion.devel,gmane.comp.version-control.subversion.rapidsvn.devel
Message-ID <-387560458085613771@unknownmsgid>
--0016e6dbe5f40875e104c424f09c
Content-Type: text/plain; charset=ISO-8859-1

Cygwin abstracts the windows io layer and then puts a UNIX like io layer on
top.

Sqlite then uses that io layer instead of the windows io layer it was
optimized for.

I'm certainly not surprised if you then see slight differences in locking
behavior if both implementations use the same database at the same time.

Bert Huijben (Cell phone)
------------------------------
From: Stefan Fuhrmann
Sent: 6-7-2012 10:05
To: Neels J Hofmeyr
Cc: Subversion Development; [email protected]
Subject: Re: why does tortoise, wcng and cygwin break from icon caching?

On Fri, Jul 6, 2012 at 12:58 AM, Neels J Hofmeyr <[email protected]> wrote:

> Today Random Person on #svn reported a problem and later its apparent
> solution, and it struck me as rather peculiar:
>
> [[[
> <yates`> when trying to do an svn cleanup, i get a strange message:
> svn: E200030: disk I/O error, executing statement 'COMMIT TRANSACTION;'
>
> I suspect a reader / writer locking issue with Sqlite.
The I/O error as such might be related to the win7 /
cygwin combination requiring more retries or such.


> this is under win7 using the cygwin svn client
> and also tortoisesvn is installed
>
> ...
>
> <yates`> neels: i found the issue
>
> strangely, there is an interaction between tortoisesvn and the cli svn
> under
> cygwin
>
> you must disable tortoisesvn's icon caching, then the problem goes away.
> http://www.mail-archive.com/[email protected]/msg123745.html
> ]]]
>

I.e. they disabled the background process that will
open the working copy soon after the OS detected
some file change. The scan itself may take a very
long time. Depending on OS and wc details, the db
may get opened at some very inconvenient time
while the commit is still in progress / in some critical
stage.


> and
>
> "I've confirmed what others have stated that it's only a problem with
> v3.7.12.1 and NOT a problem with v3.7.3."
>
> Hmm, disable icon caching to not break wc-ng? Why!?
>
> I think to remember that access to WCNG is much
more exclusive than it used to be in 1.6. But I don't
know whether that is actually true not the details.

-- Stefan^2.

-- 
Certified & Supported Apache Subversion Downloads:
http://www.wandisco.com/subversion/download

--0016e6dbe5f40875e104c424f09c
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><meta content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Cont=
ent-Type"></head><body><div><div style=3D"font-family:Calibri,sans-serif;fo=
nt-size:11pt">Cygwin abstracts the windows io layer and then puts a UNIX li=
ke io layer on top.<br>
<br>Sqlite then uses that io layer instead of the windows io layer it was o=
ptimized for.<br><br>I&#39;m certainly not surprised if you then see slight=
 differences in locking behavior if both implementations use the same datab=
ase at the same time.<br>
<br>Bert Huijben (Cell phone)<br></div></div><hr><span style=3D"font-family=
:Tahoma,sans-serif;font-size:10pt;font-weight:bold">From: </span><span styl=
e=3D"font-family:Tahoma,sans-serif;font-size:10pt">Stefan Fuhrmann</span><b=
r>
<span style=3D"font-family:Tahoma,sans-serif;font-size:10pt;font-weight:bol=
d">Sent: </span><span style=3D"font-family:Tahoma,sans-serif;font-size:10pt=
">6-7-2012 10:05</span><br><span style=3D"font-family:Tahoma,sans-serif;fon=
t-size:10pt;font-weight:bold">To: </span><span style=3D"font-family:Tahoma,=
sans-serif;font-size:10pt">Neels J Hofmeyr</span><br>
<span style=3D"font-family:Tahoma,sans-serif;font-size:10pt;font-weight:bol=
d">Cc: </span><span style=3D"font-family:Tahoma,sans-serif;font-size:10pt">=
Subversion Development; <a href=3D"mailto:[email protected]">dev@t=
ortoisesvn.tigris.org</a></span><br>
<span style=3D"font-family:Tahoma,sans-serif;font-size:10pt;font-weight:bol=
d">Subject: </span><span style=3D"font-family:Tahoma,sans-serif;font-size:1=
0pt">Re: why does tortoise, wcng and cygwin break from icon caching?</span>=
<br>
<br></body></html><div class=3D"gmail_quote">On Fri, Jul 6, 2012 at 12:58 A=
M, Neels J Hofmeyr <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" =
target=3D"_blank">[email protected]</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">

Today Random Person on #svn reported a problem and later its apparent<br>
solution, and it struck me as rather peculiar:<br>
<br>
[[[<br>
&lt;yates`&gt; when trying to do an svn cleanup, i get a strange message:<b=
r>
svn: E200030: disk I/O error, executing statement &#39;COMMIT TRANSACTION;&=
#39;<br>
<br></blockquote><div>I suspect a reader / writer locking issue with Sqlite=
.<br>The I/O error as such might be related to the win7 /<br>cygwin combina=
tion requiring more retries or such.<br>=A0<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">


this is under win7 using the cygwin svn client<br>
and also tortoisesvn is installed<br>
<br>
...<br>
<br>
&lt;yates`&gt; neels: i found the issue<br>
<br>
strangely, there is an interaction between tortoisesvn and the cli svn unde=
r<br>
cygwin<br>
<br>
you must disable tortoisesvn&#39;s icon caching, then the problem goes away=
.<br>
<a href=3D"http://www.mail-archive.com/[email protected]/msg123745.html" ta=
rget=3D"_blank">http://www.mail-archive.com/[email protected]/msg123745.htm=
l</a><br>
]]]<br></blockquote><div><br>I.e. they disabled the background process that=
 will<br>open the working copy soon after the OS detected<br>some file chan=
ge. The scan itself may take a very<br>long time. Depending on OS and wc de=
tails, the db<br>

may get opened at some very inconvenient time<br>while the commit is still =
in progress / in some critical<br>stage.<br><br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">


<br>
and<br>
<br>
&quot;I&#39;ve confirmed what others have stated that it&#39;s only a probl=
em with<br>
v3.7.12.1 and NOT a problem with v3.7.3.&quot;<br>
<br>
Hmm, disable icon caching to not break wc-ng? Why!?<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br></font></span></blockquo=
te><div>I think to remember that access to WCNG is much<br>more exclusive t=
han it used to be in 1.6. But I don&#39;t<br>know whether that is actually =
true not the details.<br>

=A0<br>-- Stefan^2.<br><br></div>-- <br></div>Certified &amp; Supported Apa=
che Subversion Downloads:<br><a href=3D"http://www.wandisco.com/subversion/=
download" target=3D"_blank">http://www.wandisco.com/subversion/download</a>=
<br>

<br>

--0016e6dbe5f40875e104c424f09c--