[Dbix-class] SQLite problem (cannot update in iterator loop)

[Christopher H. Laco]

Dan Sully wrote:
> * Daisuke Murase shaped the electrons to say...
> 
>> This script shows following error:
>>
>>    DBD::SQLite::st execute failed: database table is locked(1) at
>>    dbdimp.c line 398 at
>>    /usr/local/share/perl/5.8.4/DBIx/Class/Storage/DBI.pm line 187.
>>    Use of uninitialized value in numeric eq (==) at
>>    /usr/local/share/perl/5.8.4/DBIx/Class/Row.pm line 116.  Can't
>>    update DBIC::Test=HASH(0x85a8c3c): row not found at dbic_test.pl
>>    line 20
> 
> This is an unfortunate limitation with DBD::SQLite. Not SQLite itself,
> which
> can handle multiple readers and one writer.
> 
> -D


There is some DBIC-ness in this problem as well.

When I converted Handel to a DBIC branch, I had the same problem as well
with iterators (foreach items->next). But, if I changed them to use an
array instead (@items = ->items; foreach item @items)), all worked well.

-=Chris


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3178 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.rawmode.org/pipermail/dbix-class/attachments/20060119/7cd29bab/smime-0001.bin