Skip to content

Instantly share code, notes, and snippets.

@nikushi
Created June 5, 2013 02:00
Show Gist options
  • Select an option

  • Save nikushi/5711114 to your computer and use it in GitHub Desktop.

Select an option

Save nikushi/5711114 to your computer and use it in GitHub Desktop.
GrowthForecastに同時に複数の新規グラフのgraph postするとdead lockで稀に失敗する
10:56:29 3.1 | Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle growthforecast;hostname=localhost at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Scope/Container.pm line 38.
10:56:29 3.1 | Error:DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "INSERT /* /home/growthforecast/GrowthForecast/lib/GrowthForecast/Data.pm line 271 */ INTO graphs (service_name, section_name, graph_name, number, mode, color, llimit, sllimit, created_at, updated_at)
10:56:29 3.1 | VALUES (?,?,?,?,?,?,?,?,?,?)" with ParamValues: 0="0", 1="0", 2="0", 3="9850", 4='gauge', 5='#66cc99', 6=-1000000000, 7=-100000, 8=1370397389, 9=1370397389] at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/DBIx/Sunny.pm line 150.
10:56:29 3.1 | 0/0/0 => 9850,gauge, at /home/growthforecast/GrowthForecast/lib/GrowthForecast/Web.pm line 815.
10:56:29 3.1 | at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Kossy.pm line 133
10:56:29 3.1 | Kossy::__ANON__('Error:DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "INSERT /* /home/growthforecast/GrowthForecast/lib/GrowthForecast/Data.pm line 271 */ INTO graphs (service_name, section_name, graph_name, number, mode, color, llimit, sllimit, created_at, updated_at) ^J VALUES (?,?,?,?,?,?,?,?,?,?)" with ParamValues: 0="0", 1="0", 2="0", 3="9850", 4=\'gauge\', 5=\'#66cc99\', 6=-1000000000, 7=-100000, 8=1370397389, 9=1370397389] at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/DBIx/Sunny.pm line 150.^J 0/0/0 => 9850,gauge, at /home/growthforecast/GrowthForecast/lib/GrowthForecast/Web.pm line 815.^J') called at /home/growthforecast/perl5/perlbrew/perls/perl-5.19.0/lib/site_perl/5.19.0/Try/Tiny.pm line 100
10:56:29 3.1 | Try::Tiny::try('CODE(0x2991ba8)', 'Try::Tiny::Catch=REF(0x2991a70)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Kossy.pm line 134
10:56:29 3.1 | Kossy::__ANON__('HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Middleware/Scope/Container.pm line 14
10:56:29 3.1 | Plack::Middleware::Scope::Container::call('Plack::Middleware::Scope::Container=HASH(0x27350c8)', 'HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Component.pm line 50
10:56:29 3.1 | Plack::Component::__ANON__('HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Middleware/Static.pm line 18
10:56:29 3.1 | Plack::Middleware::Static::call('Plack::Middleware::Static=HASH(0x2741078)', 'HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Component.pm line 50
10:56:29 3.1 | Plack::Component::__ANON__('HASH(0x27e70f8)') called at growthforecast.pl line 119
10:56:29 3.1 | Plack::Middleware::StackTrace::__ANON__ at /home/growthforecast/perl5/perlbrew/perls/perl-5.19.0/lib/site_perl/5.19.0/Try/Tiny.pm line 71
10:56:29 3.1 | eval {...} at /home/growthforecast/perl5/perlbrew/perls/perl-5.19.0/lib/site_perl/5.19.0/Try/Tiny.pm line 67
10:56:29 3.1 | Plack::Middleware::StackTrace::call('Plack::Middleware::StackTrace=HASH(0x2261b60)', 'HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Component.pm line 50
10:56:29 3.1 | Plack::Component::__ANON__('HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Middleware/Lint.pm line 24
10:56:29 3.1 | Plack::Middleware::Lint::call('Plack::Middleware::Lint=HASH(0x2740b80)', 'HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Component.pm line 50
10:56:29 3.1 | Plack::Component::__ANON__('HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Util.pm line 142
10:56:29 3.1 | eval {...} at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Util.pm line 142
10:56:29 3.1 | Plack::Util::run_app('CODE(0x275e748)', 'HASH(0x27e70f8)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Starlet/Server.pm line 193
10:56:29 3.1 | Starlet::Server::handle_connection('Plack::Handler::Starlet=HASH(0x12dfea0)', 'HASH(0x27e70f8)', 'IO::Socket::INET=GLOB(0x27e6f48)', 'CODE(0x275e748)', '', '') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Starlet/Server.pm line 139
10:56:29 3.1 | Starlet::Server::accept_loop('Plack::Handler::Starlet=HASH(0x12dfea0)', 'CODE(0x275e748)', 100) called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Plack/Handler/Starlet.pm line 67
10:56:29 3.1 | Plack::Handler::Starlet::run('Plack::Handler::Starlet=HASH(0x12dfea0)', 'CODE(0x275e748)') called at growthforecast.pl line 155
10:56:29 3.1 | main::__ANON__ at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Proclet.pm line 213
10:56:29 3.1 | Proclet::__ANON__ at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Parallel/Prefork.pm line 75
10:56:29 3.1 | Parallel::Prefork::start('Parallel::Prefork=HASH(0x2650a78)', 'CODE(0x2650478)') called at /home/growthforecast/.perlbrew/libs/perl-5.19.0@GrowthForecast/lib/perl5/Proclet.pm line 224
10:56:29 3.1 | Proclet::run('Proclet=HASH(0x2580a08)') called at growthforecast.pl line 160
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment