<div dir="ltr"><div>If you have a reproducible 2% failure rate, can you come up with a simple reproducible test case?<br><br>I'm talking something of the form, "Start with an empty Sybase database, create these tables, run this script to add sample data, run this migration, run this test, and voila!"<br>
<br></div>Something to let someone else reproduce the problem without your full environment.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Feb 3, 2014 at 1:34 PM, Phillip Moore <span dir="ltr"><<a href="mailto:w.phillip.moore@gmail.com" target="_blank">w.phillip.moore@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I'm working with a very large, and very old software product, and trying to convert it's ancient Sybase tables to modern, normalized forms with a DBIC API to access it. Things have been going well, until I started parallelizing the data conversion, and hitting the database a little hard (up to 16 processes at a time -- hardly "huge" by modern standards).<div>
<br></div><div>I'm starting to see a problem where about 2% of the DBIC objects I create come back with a primary key (which is a Sybase identity column) whose value has been incremented one too many times. Then, when I create related objects and assign that identity value as a foreign key, the relationships are essentially corrupted. Things get associated with the wrong object.</div>
<div><br></div><div>The 2% failure rate is reproducible, but when I convert the entire legacy database to the new schema, it's a different, seemingly random subset of objects that get returned this way. I figured out what was happening by noticing the off by one error, and then sanity checking the metadata for id-1 and finding THAT to be correct.</div>
<div><br></div><div>I'm using DBIC 0.08250 with DBD-Sybase 1.14 (both are a tad out of date; I've requested upgrades, which sadly I no longer control) against a Sybase ASE 12.5.4 server.</div><div><br></div><div>
I am working on getting more in depth debugging information, and I am well aware that this problem report is lacking in such details, but in the meantime do these symptoms sound familiar to anyone at all? </div>
</div>
<br>_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br></blockquote></div><br></div>