<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ok that works. I closed all my open python sessions and then
retried the tests and they all passed, no problem. That locking feature can
certainly produce some odd errors. Thanks for your help Eric.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Alex<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>The add_user function doesn't need to be called at the time
of this error for it to happen. If there are any connections to the
database that have not been committed then this error can occur. Mine got
me a couple of times when I had an Idle session connected with un-committed
transactions.<o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br clear=all>
Eric<br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>On Sat, Oct 18, 2008 at 7:27 PM, Alex Nolley <<a
href="mailto:nolleyal@msu.edu">nolleyal@msu.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p><span style='font-size:11.0pt;color:#1F497D'>That's what is stumping me
because not only do I do a conn.commit() at the end of my add_user function,
but the add_user function isn't even being called when this error is thrown.</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'>-Alex</span><span
style='color:#888888'><o:p></o:p></span></p>
<div>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p> <o:p></o:p></p>
<div>
<p>This happens when you don't do a c.commit() after your done doing stuff with
the database in add_user.<o:p></o:p></p>
<div>
<p style='margin-bottom:12.0pt'><br clear=all>
Eric<o:p></o:p></p>
<div>
<p>On Sat, Oct 18, 2008 at 6:59 PM, Alex Nolley <<a
href="mailto:nolleyal@msu.edu" target="_blank">nolleyal@msu.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p>Hey I keep getting the error 'database is locked' when I run the tests. This
occurs on line 540 of the webserve-test.py file. When I open a python
interactive terminal and run each command through it:<o:p></o:p></p>
<p>import webserve<o:p></o:p></p>
<p>conn = webserve.conn<o:p></o:p></p>
<p>c = conn.cursor()<o:p></o:p></p>
<p>c.execute("DELETE FROM users WHERE username='foo'")<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>I get the same error, so whatever the error is, it isn't related to a
previous test being run. I created the conn object directly under the import
statements like so:<o:p></o:p></p>
<p>conn = sqlite3.connect('webserve-info.db')<o:p></o:p></p>
<p>and I have a feeling this is related to the error but I don't know why. Does
anyone know how to solve this problem?<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Thanks,<o:p></o:p></p>
<p>Ale<span style='color:#1F497D'>x</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
_______________________________________________<br>
cse491-fall-2008 mailing list<br>
<a href="mailto:cse491-fall-2008@lists.idyll.org">cse491-fall-2008@lists.idyll.org</a><br>
<a href="http://lists.idyll.org/listinfo/cse491-fall-2008" target="_blank">http://lists.idyll.org/listinfo/cse491-fall-2008</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>No virus
found in this incoming message.<br>
Checked by AVG - http://www.avg.com<br>
Version: 8.0.138 / Virus Database: 270.8.1/1731 - Release Date: 10/17/2008 7:01
PM</span><o:p></o:p></p>
</div>
</body>
</html>