Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Stats\DailyProfit - Statement could not be executed (08S01 - 1053 - Server shutdown in progress) #217

Open
dfelton opened this issue Jul 6, 2021 · 0 comments
Labels
bug Something isn't working Priority - Low

Comments

@dfelton
Copy link
Owner

dfelton commented Jul 6, 2021

This was caused by shutting down the OS while the DailyProfit process was still running. So it was a bit unintentional and could have been avoided.

Still, can handle better.

Shutdown Enabled at: 2021-07-05 22:08:35
Exception: Zend\Db\Adapter\Exception\InvalidQueryException
Code: 0
Message: Statement could not be executed (08S01 - 1053 - Server shutdown in progress)
Strace:
#0 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(122): Zend\Db\Adapter\Driver\Pdo\Statement->execute(Array)
#1 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(100): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->update('2021-07-05 00:0...', 'uni', '0.00457', '0.0924421885')
#2 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(77): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->logProfit('2021-07-05 00:0...', 'uni', '0.00457', '0.0924421885', true)
#3 vendor/symfony/console/Command/Command.php(255): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#4 vendor/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#7 bin/gemini(445): Symfony\Component\Console\Application->run()
#8 {main}

Previous Exception:
Exception: PDOException
Code: 08S01
Message: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress
Strace:
#0 vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php(239): PDOStatement->execute()
#1 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(122): Zend\Db\Adapter\Driver\Pdo\Statement->execute(Array)
#2 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(100): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->update('2021-07-05 00:0...', 'uni', '0.00457', '0.0924421885')
#3 src/Command/Command/TradeRepeater/Stats/DailyProfit.php(77): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->logProfit('2021-07-05 00:0...', 'uni', '0.00457', '0.0924421885', true)
#4 vendor/symfony/console/Command/Command.php(255): Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 vendor/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(Kobens\Gemini\Command\Command\TradeRepeater\Stats\DailyProfit), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#7 vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 bin/gemini(445): Symfony\Component\Console\Application->run()
#9 {main}
@dfelton dfelton added bug Something isn't working Priority - Low labels Jul 6, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Priority - Low
Projects
None yet
Development

No branches or pull requests

1 participant