- 论坛徽章:
- 2
|
问题描述:当执行insert操作某表t1的时候,如果insert失败,后续对t1写操作,都是保存“database is locked”
测试描述:在经过我测试之后,发现问题是没有commit。但是,我不知道是不是这个原因。代码如下:
- <div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, "Courier New", monospace; line-height: 19px; white-space: pre;"><div> <span style="color: #9cdcfe;">sqlStmt</span> := <span style="color: #ce9178;">`</span></div><div><span style="color: #ce9178;"> create table if not exists foo (id integer not null primary key, name text);</span></div><div><span style="color: #ce9178;"> `</span></div><div> <span style="color: #9cdcfe;">_</span>, <span style="color: #9cdcfe;">err</span> = db.<span style="color: #dcdcaa;">Exec</span>(sqlStmt)</div><div> <span style="color: #c586c0;">if</span> err != <span style="color: #569cd6;">nil</span> {</div><div> fmt.<span style="color: #dcdcaa;">Printf</span>(<span style="color: #ce9178;">"%q: %s</span><span style="color: #d7ba7d;">\n</span><span style="color: #ce9178;">"</span>, err, sqlStmt)</div><div> <span style="color: #c586c0;">return</span></div><div> }</div><div> <span style="color: #c586c0;">for</span> <span style="color: #9cdcfe;">i</span> := <span style="color: #b5cea8;">0</span>; i < <span style="color: #b5cea8;">3</span>; i++ {</div><div> <span style="color: #9cdcfe;">tx</span>, <span style="color: #9cdcfe;">err</span> := db.<span style="color: #dcdcaa;">Begin</span>()</div><div> <span style="color: #c586c0;">if</span> err != <span style="color: #569cd6;">nil</span> {</div><div> log.<span style="color: #dcdcaa;">Fatal</span>(err)</div><div> }</div><div> <span style="color: #9cdcfe;">j</span> := <span style="color: #b5cea8;">2</span></div><div> <span style="color: #9cdcfe;">_</span>, <span style="color: #9cdcfe;">err</span> = tx.<span style="color: #dcdcaa;">Exec</span>(<span style="color: #ce9178;">"insert into foo(id, name) values(?, ?)"</span>, j, fmt.<span style="color: #dcdcaa;">Sprintf</span>(<span style="color: #ce9178;">"test_%03d"</span>, j))</div><div> <span style="color: #c586c0;">if</span> err != <span style="color: #569cd6;">nil</span> {</div><div> fmt.<span style="color: #dcdcaa;">Printf</span>(<span style="color: #ce9178;">"Exec(%d):%v</span><span style="color: #d7ba7d;">\n</span><span style="color: #ce9178;">"</span>, i, err)</div><div> } <span style="color: #c586c0;">else</span> {</div><div> <span style="color: #9cdcfe;">err</span> = tx.<span style="color: #dcdcaa;">Commit</span>()</div><div> <span style="color: #c586c0;">if</span> err != <span style="color: #569cd6;">nil</span> {</div><div> fmt.<span style="color: #dcdcaa;">Println</span>(<span style="color: #ce9178;">"Commit err :"</span>, err)</div><div> }</div><div> }</div><div> }</div></div>
复制代码 如上面代码,id是唯一键;如果重复插入,第一次会报错“UNIQUE constraint failed: foo.id” <这个错误是正常的>
在第二次执行的时候,会报错database is locked。<这个错误,是因为上一个错误,locked了>
这里tx.Commit()是在err之后不会执行;如果将else去掉,即不管是否err都执行commit,那么就不会database is locked。
|
|