Skip to content

Database isn't sometimes opened #4403

@bobhenl

Description

@bobhenl

Describe the issue

Hello, it looks like plan isn't loading on proxy because it can't reach database? it happens sometimes, quite often, but sometimes it works.

Exceptions & Other Logs

[12:45:50] [Plan MySQLDB-transaction-thread-1/INFO] [plan]: Applying Patch: PlayerTableRowPatch..

[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: Database failed to open, com.djrapitops.plan.storage.database.transactions.patches.PlayerTableRowPatch failed to be executed.
[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: Error msg: com.djrapitops.plan.storage.database.transactions.patches.PlayerTableRowPatch failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction
[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: Ran into CompletionException - logged to plugins/plan/logs/CompletionException-68cbca414e.txt
[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: Error msg: "com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.patches.PlayerTableRowPatch failed to execute and database could not be opened: SQL Failure: Lock wait timeout exceeded; try restarting transaction"
[12:46:41] [Plan MySQLDB-transaction-thread-1/ERROR] [plan]: CRITICAL error triggered a plugin shutdown.
[12:46:41] [Plan MySQLDB-transaction-thread-1/INFO] [plan]: Processing complete.
[12:46:41] [Plan MySQLDB-transaction-thread-1/INFO] [plan]: Waiting for unfinished transactions to avoid data loss..

Plugin versions

I'm usng the v5.7 build 3153

Additional information

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugIssues that contain unintended behavior

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions