Database skript error

  • Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  • LOOKING FOR A VERSION OF SKRIPT?

    You can always check out skUnity Downloads for downloads and any other information about Skript!

Status
Not open for further replies.

Fumioo

Member
Jun 18, 2022
1
0
1
24
Skript Version (do not put latest): Skript 2.6.2
Skript Author: Bensku
Minecraft Version: git-Purpur-1171 (MC: 1.16.5)

Full Code:


Code:
# ==== 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 http://dev.bukkit.org/server-mods/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: .*
        # 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: 5 minutes
        # 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: x.x.x.x # 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: myusername
        password: mypassword
        database: skript_bridge # The database to use. Skript will automatically create a table 'variables21' in this database if it doesn't exist
        # (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/...').
        
        backup interval: 5 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.

Errors on Reload:
Nothing
Console Errors:
[12:44:24 INFO]: [Skript] database error: Deadlock found when trying to get lock; try restarting transaction


Addons:
skript-placeholders v1.5.2 (https://github.com/APickledWalrus/skript-placeholders)
Skellett v1.9.11 (https://forums.skunity.com/resources/skellett.24/)
skript-yaml v1.4
skUtilities v0.9.2 (https://tim740.github.io/)
skRayFall v1.9.21 (https://sk.rayfall.net/)
SkQuery v4.1.0
SkBee v1.9.1 (https://github.com/ShaneBeee/SkBee)
Ersatz v1.0
MundoSK v1.8.6-BETA.58 (https://forums.skunity.com/resources/mundosk.69/)

*Console error every time, if it is not fixed the ram from the server will be full quickly.


Thanks
- Fumioo
 
Status
Not open for further replies.