FIXED: Blue Dragon: Tenkai no Shichi Ryuu not accessible


Back to topics list
[post:448#3959]
Devil Doll

05/22/2010 08:50 AM

Reviews: 365
Posts: 1574

series 1815 (Blue Dragon: Tenkai no Shichi Ryuu) is not accessible (regardless of the type of link being used):

System error error: DBD::mysql::st execute failed: Subquery returns more than 1 row at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339. context: ... 335: " SQL: $sqln". 336: "STACK TRACEn". 337: Carp::longmess()."n"; 338: } 339: if (!$sth->execute(@bind_values)) { 340: eval('use Carp;'); 341: die 'DBIx::Abstract (execute): '.$sth->errstr."n". 342: " SQL: $sqln". 343: "STACK TRACEn". ... code stack: /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm:339 /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm:370 /opt/www/anime/html/comp/series_sparkline:10 /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm:848 /opt/www/anime/html/comp/series_sparkline:8 /opt/www/anime/html/series.html:86 /opt/www/anime/html/autohandler:98

The message text appears to indicate that the database contains a duplicate entry for this anime ("abstract" = synopsis?) where the SQL query doesn't expect one, i. e. this would be an issue only for this anime.

[post:448#4022]
Rebecca

06/13/2010 09:12 AM

Reviews: 23
Posts: 772

No, it actually has to do with when the page table, which tracks every unique page generated by the site, ends up with more then one entry for that particular series page. This is used as part of hit tracking. This is happening due to a combination of a race condition and insufficient constraints on the database. Beyond fixing that part, I've made the sparkline generation sufficiently robust that it won't die should this happen again.

So all that means, fixed. =)

Reply to this topic Start a new topic
Back to topics list

Community Anime Reviews

anime mikomi org