jjmg84

> since i upgrade de 2.9.1, am having a lot of `deadlocks` and `HTTP 500` error > > Deadlocks > > HTTP 500 Hi, good info i am in same...

> ble rows and Thanks, i have seen that the table that is locking for me is : software_categories_link 

Hi, i have fixed my problem too adapting @mujtaba-saboor fix, i atach here the code: sub _del_category_soft { my ($name, $publisher, $version) = @_; my $sqlSoftwareCat; my $sql; my @arg...

> > Hi, i have fixed my problem too adapting @mujtaba-saboor fix, i atach here the code: > > sub _del_category_soft { my ($name, $publisher, $version) = @_; my $sqlSoftwareCat;...

@mujtaba-saboor im sorry but my code dont work, it continue making deadlocks :( and i dont know how to hadle this DBD::mysql::st execute failed: Deadlock found when trying to get...

> @jjmg84 are you sure the deadlock is from `software_categories_link` table and not from the `software` table? Because for me it was `software` table, maybe you could refactor the software...

> > > @jjmg84 are you sure the deadlock is from `software_categories_link` table and not from the `software` table? Because for me it was `software` table, maybe you could refactor...

Hi, i have news, as i can see, after modify the code of : sub _del_category_soft { my ($name, $publisher, $version) = @_; my $sqlSoftwareCat; my $sql; my @arg =...

Nobody has same problem? this problem eats all my Mysql conections with locks and OCs dont work as desired :(

> Update: > > after the weekend, I can't find any deadlocks in the logs anymore. Now I found some "lock wait timeout" since tomorrow in the morning, after the...