Server crashes with new update

[ItzBlue72]

Issue description

I just updated the plugin to 0.7.0. Previous version have not led the server to crash, however this version causes a crash for me.

• Expected result: Use the server with BCP v0.7.0 installed.
• Actual result: I was able to join but the server crashed moments after.

Steps to reproduce the issue

1. Join a 3.13.0 PocketMine server with BCP v0.7.0 installed.
2. Wait for some time to pass.

OS and versions

• BedcoreProtect: 0.7.0

• PocketMine-MP: 3.13.0
• PHP: 7.3
• Server OS: sqlite
• Game version: PE/Win10 (delete as appropriate)

Plugins

Plugins (43): DoorBell v1.0.0, OnlineTime v1.3, BuilderTools v1.2.0-beta2, SizePlayer v1.1.0, JukeBox v1.0.1, MailPlugin v3.5, LockMyStuff v1.1.0, ServerChannels v2.3, DevTools v1.14.0, MCPEToDiscord v1.4.1, CustomAlerts v2.1, Broadcaster v1.5, PlayerSelectors v1.0.7, MaxEnchants v1.2.1, GroupsUI v1.0.0, aDvaNceDmOcK v0.0.1, Slapper v1.5.30, iProtector v3.1.1, AutoClearLagg v3.0.1, WorldProtect v2.3.8, WorldBackup v1.0, WorldStyler v1.1, RenameItems v1.1, ShulkerBox v1.0.1, MultiWorld v1.5.2, PersonaToSkin v0.0.1, BanItem v2.3.3, PurePerms v1.4.3, essentialsTP v1.2.2, ChatMuffler v1.1.0, VanillaCoordinates v1.0.0, AllSigns v1.0.13, PlayerAdmin v1.0.0, StairSeat v1.4.2, DEVirion v1.2.7, StaffChat v1.1.4, VanishV2 v1.7, GrapplingHook v1.0.3, PureChat v1.4.11, Backpack v0.2.1, MyPlot v1.7.0, BlockSniper v3.2.3, BedcoreProtect v0.7.0

• If you remove all plugins, does the issue still occur?
  • Have not tested
• If the issue is not reproducible without plugins:
  • Can you provide sample, minimal reproducing code for the issue? If so, paste it in the bottom section

Crashdump, backtrace or other files

Crash Archive Link: https://crash.pmmp.io/view/4291574
Console Log:

Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: main.entities_old in phar:///home/container/plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/sqlite3/Sqlite3Thread.php on line 79
[07:18:23] [Server thread/CRITICAL]: matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitException: "Unhandled async exception" (EXCEPTION) in "plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await" at line 436
[07:18:23] [Server thread/DEBUG]: #0 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(202): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #1 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(176): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeup(object Closure)
[07:18:23] [Server thread/DEBUG]: #2 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(397): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeupFlat(object Closure)
[07:18:23] [Server thread/DEBUG]: #3 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/AwaitChild(48): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->recheckPromiseQueue(object matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild)
[07:18:23] [Server thread/DEBUG]: #4 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(432): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #5 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(202): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #6 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(176): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeup(object Closure)
[07:18:23] [Server thread/DEBUG]: #7 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(397): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeupFlat(object Closure)
[07:18:23] [Server thread/DEBUG]: #8 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/AwaitChild(48): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->recheckPromiseQueue(object matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild)
[07:18:23] [Server thread/DEBUG]: #9 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(432): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #10 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(202): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #11 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(176): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeup(object Closure)
[07:18:23] [Server thread/DEBUG]: #12 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/Await(397): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->wakeupFlat(object Closure)
[07:18:23] [Server thread/DEBUG]: #13 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/SOFe/AwaitGenerator/AwaitChild(48): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\Await->recheckPromiseQueue(object matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild)
[07:18:23] [Server thread/DEBUG]: #14 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/DataConnectorImpl(240): matcracker\BedcoreProtect\libs\SOFe\AwaitGenerator\AwaitChild->reject(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError, NULL )
[07:18:23] [Server thread/DEBUG]: #15 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/DataConnectorImpl(186): matcracker\BedcoreProtect\libs\poggit\libasynql\base\DataConnectorImpl->reportError(array[2], object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError, NULL )
[07:18:23] [Server thread/DEBUG]: #16 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/SqlThreadPool(112): matcracker\BedcoreProtect\libs\poggit\libasynql\base\DataConnectorImpl->matcracker\BedcoreProtect\libs\poggit\libasynql\base\{closure}(object matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError)
[07:18:23] [Server thread/DEBUG]: #17 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/DataConnectorImpl(268): matcracker\BedcoreProtect\libs\poggit\libasynql\base\SqlThreadPool->readResults(array[1])
[07:18:23] [Server thread/DEBUG]: #18 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/SqlThreadPool(65): matcracker\BedcoreProtect\libs\poggit\libasynql\base\DataConnectorImpl->checkResults()
[07:18:23] [Server thread/DEBUG]: #19 vendor/pocketmine/snooze/src/SleeperHandler(123): matcracker\BedcoreProtect\libs\poggit\libasynql\base\SqlThreadPool->matcracker\BedcoreProtect\libs\poggit\libasynql\base\{closure}()
[07:18:23] [Server thread/DEBUG]: #20 vendor/pocketmine/snooze/src/SleeperHandler(85): pocketmine\snooze\SleeperHandler->processNotifications()
[07:18:23] [Server thread/DEBUG]: #21 src/pocketmine/Server(2154): pocketmine\snooze\SleeperHandler->sleepUntil(double 1592205503.7405)
[07:18:23] [Server thread/DEBUG]: #22 src/pocketmine/Server(1991): pocketmine\Server->tickProcessor()
[07:18:23] [Server thread/DEBUG]: #23 src/pocketmine/Server(1585): pocketmine\Server->start()
[07:18:23] [Server thread/DEBUG]: #24 src/pocketmine/PocketMine(273): pocketmine\Server->__construct(object BaseClassLoader, object pocketmine\utils\MainLogger, string[16] /home/container/, string[24] /home/container/plugins/)
[07:18:23] [Server thread/DEBUG]: #25 src/pocketmine/PocketMine(296): pocketmine\server()
[07:18:23] [Server thread/DEBUG]: #26 (11): require(string[71] phar:///home/container/PocketMine-MP.phar/src/pocketmine/PocketMine.php)
[07:18:23] [Server thread/DEBUG]: Previous: matcracker\BedcoreProtect\libs\poggit\libasynql\SqlError: "SQL PREPARE error: no such table: main.entities_old, for query INSERT INTO "log_history"(who, x, y, z, world_name, action, time) VALUES ((SELECT uuid FROM entities WHERE uuid = 'e45ca4ff-b3aa-3789-888d-7dee05584f5d'), 18, 65, 103, 'plots3', 0, STRFTIME('%Y-%m-%d %H:%M:%f', 1592205503.6907, 'unixepoch', 'localtime')); | []" (EXCEPTION) in "plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/sqlite3/Sqlite3Thread" at line 81
[07:18:23] [Server thread/DEBUG]: #0 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/libs/poggit/libasynql/base/SqlSlaveThread(85): matcracker\BedcoreProtect\libs\poggit\libasynql\sqlite3\Sqlite3Thread->executeQuery(string[15] object(SQLite3), integer 2, string[255] INSERT INTO "log_history"(who, x, y, z, world_name, action, time).VALUES ((SELEC, array[0])
[07:18:23] [Server thread/DEBUG]: #1 (): matcracker\BedcoreProtect\libs\poggit\libasynql\base\SqlSlaveThread->run()
[07:18:23] [Server thread/DEBUG]: #2 Internal(0): Corrected generator stack trace()
[07:18:23] [Server thread/DEBUG]: #3 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/storage/queries/Query(145): executeInsert()
[07:18:23] [Server thread/DEBUG]: #4 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/storage/queries/BlocksQueries(138): addRawBlockLog()
[07:18:23] [Server thread/DEBUG]: #5 plugins/BedcoreProtect.phar/src/matcracker/BedcoreProtect/storage/queries/BlocksQueries(97): matcracker\BedcoreProtect\storage\queries\{closure}()
[07:18:23] [Server thread/EMERGENCY]: An unrecoverable error has occurred and the server has crashed. Creating a crash dump

[matcracker]

Fixed in 05fae09. (Blame SQLite)

To resolve the v0.7.0 crash, before starting the server with v0.7.1, rename the database backup file in the data folder of the plugin as shown in the following example: logs.db.0.6.2.bak to logs.db.
Once this is done you can start the server.

Thank you for your report!