[Skript] Skript's aliases can be found here: https://github.com/SkriptLang/skript-aliases
[00:24:25 INFO]: [Skript] Skript's documentation can be found here: https://docs.skriptlang.org/
[00:24:25 INFO]: [Skript] Skript's tutorials can be found here: https://docs.skriptlang.org/tutorials
[00:24:25 INFO]: [Skript] Server Version: git-Paper-381 (MC: 1.20.4)
[00:24:25 INFO]: [Skript] Skript Version: 2.9.2 (skriptlang-github)
[00:24:25 INFO]: [Skript] Installed Skript Addons:
[00:24:25 INFO]: [Skript] - skript-placeholders v1.5.2 (https://github.com/APickledWalrus/skript-placeholders)
[00:24:25 INFO]: [Skript] - Parties v3.2.15 (https://alessiodp.com/parties)
[00:24:25 INFO]: [Skript] - Skellett v2.0.9 (https://forums.skunity.com/resources/skellett.24/)
[00:24:25 INFO]: [Skript] - HQGiftBoxSK v1.0.0
[00:24:25 INFO]: [Skript] - skUtilities v0.9.2 (https://tim740.github.io/)
[00:24:25 INFO]: [Skript] - skript-reflect v2.4 (https://github.com/SkriptLang/skript-reflect)
[00:24:25 INFO]: [Skript] - CoroutineSK v1.0.1
[00:24:25 INFO]: [Skript] - skRayFall v1.9.28 (https://sk.rayfall.net/)
[00:24:25 INFO]: [Skript] - SkQuery v4.1.10
[00:24:25 INFO]: [Skript] - SkBee v3.4.3 (https://github.com/ShaneBeee/SkBee)
[00:24:25 INFO]: [Skript] Installed dependencies:
[00:24:25 INFO]: [Skript] - SQLibrary v7.1
[00:24:25 INFO]: [Skript] - Vault v1.7.3-b131
[00:24:25 INFO]: [Skript] - WorldGuard v7.0.9+5934e49
I am using the script's variables by storing them in a MySQL database.
However, when I start the server, I see an error in the bucket saying "Cannot load variables from the database fast enough (loading took 1.779s, monitor interval = 1.0s). Please increase your monitor interval or reduce usage of variables. (this warning will be repeated at most once every 10 seconds)" and intermittently I see an error in the bucket saying "[Skript variable save thread for database 'MySQL'/INFO]: [Skript] database error: Deadlock found when trying to get lock; try restarting transaction".
This error hasn't caused any major problems on our servers yet, but I suspect it will at some point.
Can you help me fix this error?
The config configuration is as follows, and if you do not set the "monitor interval" to 1 seconds, data will not be loaded immediately when the server is moved.
# ==== Variables ====
databases:
# Databases to store variables in. These can either be used as a simple one-server-storage
# where variables are written constantly but only read at server start,
# or as a connection between multiple servers by monitoring the database(s) for changes.
#
# You can define as many databases as you want, just make sure to choose a distinct name for each one, and don't forget to set all options correctly.
#
# To be able to use a database you'll need to download the plugin 'SQLibrary' from https://dev.bukkit.org/projects/sqlibrary/files
# and install it in your server's plugin directory like other plugins.
#
# Please note that '/skript reload' will not reload this section, i.e. you'll have to restart Skript for changes to take effect.
# Each database definition must be in a separate section. You can choose any name for the sections, as long as it's not already used.
database 1:
# An example database to describe all possible options.
type: MySQL
# The type of this database. Allowed values are 'CSV', 'SQLite', 'MySQL' and 'disabled'.
# CSV uses a text file to store the variables, while SQLite and MySQL use databases, and 'disabled' makes Skript ignore the database as if it wasn't defined at all.
pattern: playerdata::.*
# Defines which variables to save in this database.
# This pattern uses Regex syntax, e.g. use 'db_.*' (without the quotes) to store all variables prefixed with 'db_' in this database,
# or use '.*' (the default value) to store all variables here (recommended for the last database in this list, as otherwise some variables might not be saved).
# Please note that variables are only stored in one database, and databases are checked from top to bottom,
# e.g. if a variable matches the topmost database's pattern it will be saved there and nowhere else.
# BTW: Patterns are checked in a separate thread, i.e. your server likely won't run slower when using complicated patterns.
monitor changes: true
monitor interval: 1 seconds
# If 'monitor changes' is set to true, variables will repeatedly be checked for updates in the database (in intervals set in 'monitor interval').
# ! Please note that you should set 'pattern', 'monitor changes' and 'monitor interval' to the same values on all servers that access the same database!
# == MySQL configuration ==
host: localhost# Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
port: 3306# 3306 is MySQL's default port, i.e. you likely won't need to change this value
user: root
password: password
database: minecraft# The database to use, the table will be created in this database.
table: skript# The name of the table to create. 'variables21' is the default name, if this was to be omitted.
# (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)
# == SQLite/CSV configuration ==
file: ./plugins/Skript/variables.db
# Where to save the variables to. For a CSV file, the file extension '.csv' is recommended, but not required, but SQLite database files must end in '.db' (SQLibrary forces this).
# The file path can either be absolute (e.g. 'C:\whatever\...' [Windows] or '/usr/whatever/...' [Unix]), or relative to the server directory (e.g. './plugins/Skript/...').
#table: variables21
# The name of the table to create. 'variables21' is the default name, if this was to be omitted.
# (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)
# This is generally not required as the the .db file will only be used by Skript, unless you want to split different variables into different tables
backup interval: 2 hours
# Creates a backup of the file every so often. This can be useful if you ever want to revert variables to an older state.
# Variables are saved constantly no matter what is set here, thus a server crash will never make you loose any variables.
# Set this to 0 to disable this feature.
[00:24:25 INFO]: [Skript] Skript's documentation can be found here: https://docs.skriptlang.org/
[00:24:25 INFO]: [Skript] Skript's tutorials can be found here: https://docs.skriptlang.org/tutorials
[00:24:25 INFO]: [Skript] Server Version: git-Paper-381 (MC: 1.20.4)
[00:24:25 INFO]: [Skript] Skript Version: 2.9.2 (skriptlang-github)
[00:24:25 INFO]: [Skript] Installed Skript Addons:
[00:24:25 INFO]: [Skript] - skript-placeholders v1.5.2 (https://github.com/APickledWalrus/skript-placeholders)
[00:24:25 INFO]: [Skript] - Parties v3.2.15 (https://alessiodp.com/parties)
[00:24:25 INFO]: [Skript] - Skellett v2.0.9 (https://forums.skunity.com/resources/skellett.24/)
[00:24:25 INFO]: [Skript] - HQGiftBoxSK v1.0.0
[00:24:25 INFO]: [Skript] - skUtilities v0.9.2 (https://tim740.github.io/)
[00:24:25 INFO]: [Skript] - skript-reflect v2.4 (https://github.com/SkriptLang/skript-reflect)
[00:24:25 INFO]: [Skript] - CoroutineSK v1.0.1
[00:24:25 INFO]: [Skript] - skRayFall v1.9.28 (https://sk.rayfall.net/)
[00:24:25 INFO]: [Skript] - SkQuery v4.1.10
[00:24:25 INFO]: [Skript] - SkBee v3.4.3 (https://github.com/ShaneBeee/SkBee)
[00:24:25 INFO]: [Skript] Installed dependencies:
[00:24:25 INFO]: [Skript] - SQLibrary v7.1
[00:24:25 INFO]: [Skript] - Vault v1.7.3-b131
[00:24:25 INFO]: [Skript] - WorldGuard v7.0.9+5934e49
I am using the script's variables by storing them in a MySQL database.
However, when I start the server, I see an error in the bucket saying "Cannot load variables from the database fast enough (loading took 1.779s, monitor interval = 1.0s). Please increase your monitor interval or reduce usage of variables. (this warning will be repeated at most once every 10 seconds)" and intermittently I see an error in the bucket saying "[Skript variable save thread for database 'MySQL'/INFO]: [Skript] database error: Deadlock found when trying to get lock; try restarting transaction".
This error hasn't caused any major problems on our servers yet, but I suspect it will at some point.
Can you help me fix this error?
The config configuration is as follows, and if you do not set the "monitor interval" to 1 seconds, data will not be loaded immediately when the server is moved.
# ==== Variables ====
databases:
# Databases to store variables in. These can either be used as a simple one-server-storage
# where variables are written constantly but only read at server start,
# or as a connection between multiple servers by monitoring the database(s) for changes.
#
# You can define as many databases as you want, just make sure to choose a distinct name for each one, and don't forget to set all options correctly.
#
# To be able to use a database you'll need to download the plugin 'SQLibrary' from https://dev.bukkit.org/projects/sqlibrary/files
# and install it in your server's plugin directory like other plugins.
#
# Please note that '/skript reload' will not reload this section, i.e. you'll have to restart Skript for changes to take effect.
# Each database definition must be in a separate section. You can choose any name for the sections, as long as it's not already used.
database 1:
# An example database to describe all possible options.
type: MySQL
# The type of this database. Allowed values are 'CSV', 'SQLite', 'MySQL' and 'disabled'.
# CSV uses a text file to store the variables, while SQLite and MySQL use databases, and 'disabled' makes Skript ignore the database as if it wasn't defined at all.
pattern: playerdata::.*
# Defines which variables to save in this database.
# This pattern uses Regex syntax, e.g. use 'db_.*' (without the quotes) to store all variables prefixed with 'db_' in this database,
# or use '.*' (the default value) to store all variables here (recommended for the last database in this list, as otherwise some variables might not be saved).
# Please note that variables are only stored in one database, and databases are checked from top to bottom,
# e.g. if a variable matches the topmost database's pattern it will be saved there and nowhere else.
# BTW: Patterns are checked in a separate thread, i.e. your server likely won't run slower when using complicated patterns.
monitor changes: true
monitor interval: 1 seconds
# If 'monitor changes' is set to true, variables will repeatedly be checked for updates in the database (in intervals set in 'monitor interval').
# ! Please note that you should set 'pattern', 'monitor changes' and 'monitor interval' to the same values on all servers that access the same database!
# == MySQL configuration ==
host: localhost# Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
port: 3306# 3306 is MySQL's default port, i.e. you likely won't need to change this value
user: root
password: password
database: minecraft# The database to use, the table will be created in this database.
table: skript# The name of the table to create. 'variables21' is the default name, if this was to be omitted.
# (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)
# == SQLite/CSV configuration ==
file: ./plugins/Skript/variables.db
# Where to save the variables to. For a CSV file, the file extension '.csv' is recommended, but not required, but SQLite database files must end in '.db' (SQLibrary forces this).
# The file path can either be absolute (e.g. 'C:\whatever\...' [Windows] or '/usr/whatever/...' [Unix]), or relative to the server directory (e.g. './plugins/Skript/...').
#table: variables21
# The name of the table to create. 'variables21' is the default name, if this was to be omitted.
# (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)
# This is generally not required as the the .db file will only be used by Skript, unless you want to split different variables into different tables
backup interval: 2 hours
# Creates a backup of the file every so often. This can be useful if you ever want to revert variables to an older state.
# Variables are saved constantly no matter what is set here, thus a server crash will never make you loose any variables.
# Set this to 0 to disable this feature.
Last edited: