CoreProtect

Table of Contents

CoreProtect - Fast, efficient block logging, rollbacks, and restores

Version: v2.15.1

CoreProtect is a fast, efficient, data logging and anti-griefing tool. Rollback and restore any amount of damage. Designed with large servers in mind, CoreProtect will record and manage data without impacting your server performance.

CoreProtect is the #1 anti-griefing plugin, and has been actively developed since early 2012.

Download
Latest Downloads for Spigot 1.8 - Spigot 1.13: https://www.spigotmc.org/resources/coreprotect.8631/

Video Tutorial: (by jfreeze256)

Core Features

Fast efficient data logging.
Fast rollbacks - no lag while performing rollbacks/restores.
Multi-threaded to ensure server performance is never impacted
No configuration required. Put the plugin on your server, and you're good to go.
SQLite based data storage.
Optional MySQL support.
Easy to use commands.
Perform rollbacks AND restores. Undo any rollback, anytime.
Easy to use block inspector
Advanced search-based lookup tool.
Paginated logs.
Automatic update checker.
Multi-world support.
Enable or disable any aspect of logging in the configuration file.
Rollback per-player, or just do a global rollback to all damage around you.
Specify certain block types to skip in rollbacks/restores.
Restrict rollbacks/restores to specific block types
Log basic player actions (such as when a player opens a door)
Liquid tracking. Associate liquid flow with players
Tree tracking. Trees grown from saplings show who originally planted the sapling.
Restrict rollbacks/restores to a radius area.
Supports bucket permission system.
Able to track blocks that fall off of other blocks. If a player breaks a block that had a sign on it, both the block and the sign can be rolled back.
Easily delete old log data.
Safe default parameters.
Rollback or restore multiple players at once.
Create per-world configuration files.
Lookup, rollback, or restore by a specific action.
Exclude multiple users or blocks.
Preview rollbacks or restores.
Use WorldEdit selections.
An easy to use API.
Works with Tekkit servers
...and much more!!

What does it log?

Log blocks broken by players
Log blocks placed by players
Log natural block breakage (ex: if a sign pops off a dirt block that was broken)
Log bucket usage
Log liquid flow
Log tree growth
Log mushroom growth
Log vine growth.
Log explosions (TNT, Creepers, Ghasts, etc)
Log flint & steel and fire charge usage
Log fire igniting blocks
Log blocks burning up in fires
Log entities changing blocks (Endermen/Enderdragons)
Log block movement (Falling sand/gravel)
Log leaf decay
Log player interactions
Log Nether portal generation
Log blocks moved by pistons
Log crops trampled by players
Log snow generated by snow golems
Log items taken or placed in chests, furnaces, dispensers, etc.
Log paintings and item frames. (With rollback support!)
Log entities killed by players (animals/monsters)
Log chat messages and commands used by players
Log player sessions (logins/logouts)
Log player deaths
Log username changes
Log changes made via WorldEdit
...and the list is still expanding!

How to use the inspector.

Once you have the inspector enabled ("/core inspect", or just "/co i"), you can do the following:

Left-click a block to see who placed that block.
Right-click a block to see what adjacent block was removed.
Right-click (place) a block in a location to see what block was removed at that location.
Right-click (place) a block in another block to see who placed it. (ex: place dirt in water to see who placed the water)
Right-click on a door,button,lever,chest,etc, to see who last used it.

A Few Reviews

"It's easy to use and lightning fast when it comes to rollbacks."
"I've been running a MC server since before Bukkit, so I've used just about every block logger out there. CoreProtect is the best and the fastest."
"Go with CoreProtect. It's fast, updated frequently, and logs WorldEdit."
"Overall it felt more natural, simpler, and much faster to use CoreProtect than Prism, which just doesn't compare."
"CoreProtect brings complex logging and rollbacks, whilst at the same time keeping a low profile."

Commands
http://minerealm.com/community/viewtopic.php?f=32&t=6781

Permissions
http://minerealm.com/community/viewtopic.php?f=32&t=6782

Guides & Resources
http://dev.bukkit.org/bukkit-plugins/coreprotect/pages/guides-resources/

API Documentation
http://minerealm.com/community/viewtopic.php?f=32&t=16687

IRC
Join us on Discord: https://discord.gg/H7HyPxz

Sponsors
Thanks to HostHorde for sponsoring CoreProtect!

Have a question, a suggestion, or just want to tell us thanks? Post below!

Thanks for your support!

Comments

DOGCKyle
- Join Date: 4/5/2012
- Posts: 19
- Member Details
#3299 DOGCKyle

View User Profile

Send Message

Posted Jan 11, 2019
I've recently noticed my console is full of errors, nothing is getting logged... I think I might have a corrupt database...

Gonna give some background info first, questions below. This seems like a pretty complex issue, and I feel it might be a bit of an unusual situation, but any help would be greatly appreciated!

Looking back at logs from a few days ago, I've found the following:

[01:34:46] [Server thread/INFO]: HesitantMads issued server command: /co i [01:34:50] [Thread-11/WARN]: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked) [01:34:50] [Thread-11/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:909) [01:34:50] [Thread-11/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:921) [01:34:50] [Thread-11/WARN]: at org.sqlite.core.DB.throwex(DB.java:886) [01:34:50] [Thread-11/WARN]: at org.sqlite.core.NativeDB._exec_utf8(Native Method) [01:34:50] [Thread-11/WARN]: at org.sqlite.core.NativeDB._exec(NativeDB.java:87) [01:34:50] [Thread-11/WARN]: at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:116) [01:34:50] [Thread-11/WARN]: at net.coreprotect.database.Database.commitTransaction(Database.java:52) [01:34:50] [Thread-11/WARN]: at net.coreprotect.consumer.Process.processConsumer(Process.java:168) [01:34:50] [Thread-11/WARN]: at net.coreprotect.consumer.Consumer.run(Consumer.java:105) [01:34:50] [Thread-11/WARN]: at java.lang.Thread.run(Thread.java:748)

So one of my admins used the inspector, nothing unusual there so far. This error came up, not sure if it's just regular when the database is busy, or if it's relevant.

A little while later, another admin was doing some WorldEditing, and the first disk IO error came up...

[02:06:42] [Server thread/INFO]: GalvinNerth issued server command: //paste
[02:06:43] [Thread-11/WARN]: org.sqlite.SQLiteException: [SQLITE_IOERR_WRITE] I/O error in the VFS layer while trying to write to a file on disk (disk I/O error)
[02:06:43] [Thread-11/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:909)
[02:06:43] [Thread-11/WARN]: at org.sqlite.core.DB.newSQLException(DB.java:921)
[02:06:43] [Thread-11/WARN]: at org.sqlite.core.DB.throwex(DB.java:886)
[02:06:43] [Thread-11/WARN]: at org.sqlite.core.NativeDB._exec_utf8(Native Method)
[02:06:43] [Thread-11/WARN]: at org.sqlite.core.NativeDB._exec(NativeDB.java:87)
[02:06:43] [Thread-11/WARN]: at org.sqlite.jdbc3.JDBC3Statement.executeUpdate(JDBC3Statement.java:116)
[02:06:43] [Thread-11/WARN]: at net.coreprotect.database.Database.commitTransaction(Database.java:52)
[02:06:43] [Thread-11/WARN]: at net.coreprotect.consumer.Process.processConsumer(Process.java:168)
[02:06:43] [Thread-11/WARN]: at net.coreprotect.consumer.Consumer.run(Consumer.java:105)
[02:06:43] [Thread-11/WARN]: at java.lang.Thread.run(Thread.java:748)

After that, the logs were full of "statement not executing"...

[02:08:23] [Thread-11/WARN]: java.sql.SQLException: statement is not executing
[02:08:23] [Thread-11/WARN]: at org.sqlite.core.CoreStatement.checkOpen(CoreStatement.java:50)
[02:08:23] [Thread-11/WARN]: at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:117)
[02:08:23] [Thread-11/WARN]: at org.sqlite.jdbc3.JDBC3PreparedStatement.setInt(JDBC3PreparedStatement.java:324)
[02:08:23] [Thread-11/WARN]: at net.coreprotect.database.Database.insertBlock(Database.java:195)
[02:08:23] [Thread-11/WARN]: at net.coreprotect.database.Logger.log_break(Logger.java:195)
[02:08:23] [Thread-11/WARN]: at net.coreprotect.consumer.Process.processBlockBreak(Process.java:201)
[02:08:23] [Thread-11/WARN]: at net.coreprotect.consumer.Process.processConsumer(Process.java:84)
[02:08:23] [Thread-11/WARN]: at net.coreprotect.consumer.Consumer.run(Consumer.java:105)
[02:08:23] [Thread-11/WARN]: at java.lang.Thread.run(Thread.java:748)

Then I got one "SQL error or missing database"...

[02:08:23] [Thread-11/WARN]: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (cannot commit - no transaction is active)

After that, logs were spammed with disk IO errors again, which continued for several days, including after restarts, until I noticed it last night and shut down my server.

org.sqlite.SQLiteException: [SQLITE_IOERR_WRITE] I/O error in the VFS layer while trying to write to a file on disk (disk I/O error)

I opened up the database file in an SQLite Browser, and checked the timestamps - seems like it stopped logging altogether around 2:06:33 (last container transaction logged, 10 seconds before the first disk IO error) and the last mob death logged was 2:08:07 (just a couple minutes later).

My block table is massive and I can't get it to load in the SQLite browser without crashing. A CSV export of the block table is 18.7 GB and is over 500 million rows, MS Excel can load it, but runs out of memory when doing bigger queries on it, so I can't see the bottom.
It does report some 450+ errors, but I am not sure what that means. Searching for errors seems to pull up a lot of empty rows (null or 0 values).

My database as a whole is 154 GB - six years of logging, I know it's massive and I should probably purge. My server disk has ~75 GB free space, so space isn't an immediate concern.

So, with all that out of the way, here are my questions...

Any idea what could've happened to the database? I'm guessing that it somehow got corrupted, and now won't save new data (reading the existing data works fine). I looked up the SQLite errors, but I can't figure out what could've possibly happened. It doesn't seem to actually be a disk error, as far as I can tell.

Could the size of my database be an issue? I looked up what the OS and SQLite are capable of, and they should both be able to handle databases that were significantly larger. Does CoreProtect have anything that might cause it to struggle with such a large database?

Adding onto that, would purging the database, or switching to MySQL be a good option?

Most importantly, any idea how to check if the database is damaged, or attempt to repair it? I've looked through all the tables (except the block one, due to size) and nothing seems out of the ordinary.

EDIT: Forgot to include, CoreProtect version is 2.14.2 - looks like I'm a little behind, should I update to 2.14.4? Not sure if that would help or make things worse.
Server version is the final build of Spigot 1.12.2.

I have backups of the database, but most recent one is two months old, and I'd prefer not to lose that much data. One thing I was considering trying was copying rows from the current (broken) database, into the backup one, and seeing if that works. But I am not sure if the error is the actual data, the structure/meta of the database, or something else entirely.
Last edited by DOGCKyle: Jan 11, 2019

Rollback Post to Revision RollBack
therealwisepotato
- Join Date: 11/28/2018
- Posts: 1
- Member Details
#3298 therealwisepotato

View User Profile

Send Message

Posted Dec 1, 2018
Great plugin. Works super good with my small SMP.

Rollback Post to Revision RollBack
leamasrein
- Join Date: 10/5/2018
- Posts: 1
- Member Details
#3297 leamasrein

View User Profile

Send Message

Posted Oct 25, 2018
Not safe for 1.13 +

Rollback Post to Revision RollBack
meso27_
- Join Date: 10/21/2018
- Posts: 8
- Member Details
#3296 meso27_

View User Profile

Send Message

Posted Oct 21, 2018
I am getting an internal error when using commands, someone help?

EDIT: i just figured out that this plugin is spigot, does anyone have a 1.12 Bukkit version?

Last edited by meso27_: Oct 21, 2018

Rollback Post to Revision RollBack
Antwantheboss
- Join Date: 10/16/2018
- Posts: 1
- Member Details
#3295 Antwantheboss

View User Profile

Send Message

Posted Oct 16, 2018
When I do /pl its red! Help!

Rollback Post to Revision RollBack
MasonStormBroady
- Join Date: 7/17/2015
- Posts: 4
- Member Details
#3294 MasonStormBroady

View User Profile

Send Message

Posted Oct 6, 2018
I suggest to change sqlite to .h2
(do not quite understand what I am saying)

Rollback Post to Revision RollBack
gabedwest
- Join Date: 8/25/2018
- Posts: 2
- Member Details
#3291 gabedwest

View User Profile

Send Message

Posted Aug 25, 2018
can some one please help me? it dosent work in 1.12.2 for me.

Rollback Post to Revision RollBack
flailofthelord
- Join Date: 8/23/2018
- Posts: 2
- Member Details
#3292 flailofthelord

View User Profile

Send Message

Posted Aug 25, 2018
In reply to gabedwest:

Use version 2.14.4 for 1.12.2

https://www.spigotmc.org/resources/coreprotect.8631/history

Rollback Post to Revision RollBack
gabedwest
- Join Date: 8/25/2018
- Posts: 2
- Member Details
#3290 gabedwest

View User Profile

Send Message

Posted Aug 25, 2018
-_-

Last edited by gabedwest: Aug 25, 2018

Rollback Post to Revision RollBack
hard_11_
- Join Date: 7/26/2018
- Posts: 6
- Member Details
#3287 hard_11_

View User Profile

Send Message

Posted Aug 15, 2018
whenever i do any command from those listed it doesnt say anything not even unknown command im running 1.8

Rollback Post to Revision RollBack
Intellii
- Join Date: 5/26/2011
- Posts: 518
- Member Details
#3288 Intellii

View User Profile

Send Message

Posted Aug 15, 2018
In reply to hard_11_:

For Minecraft 1.8, you need to use this version of CoreProtect: https://www.spigotmc.org/resources/coreprotect.8631/download?version=32072

Rollback Post to Revision RollBack
hard_11_
- Join Date: 7/26/2018
- Posts: 6
- Member Details
#3289 hard_11_

View User Profile

Send Message

Posted Aug 16, 2018
In reply to Intellii:

ok thank you

Rollback Post to Revision RollBack
OhCruz
- Join Date: 2/6/2018
- Posts: 3
- Member Details
#3284 OhCruz

View User Profile

Send Message

Posted Mar 6, 2018
How often does this take up so much memory?

server has been up for only 3 months with 10-30 players and some how took up so much

memory that it filled my drive up and started to mess my files up and cause some to not save

and get cleared lol.

i have a mc-64 ovh 2x450GB NVMe

Rollback Post to Revision RollBack
codewow
- Location: Chicago
- Join Date: 11/14/2008
- Posts: 71
- Member Details
#3285 codewow

View User Profile

Send Message

Posted Apr 6, 2018
In reply to OhCruz:

The more users you have, the more space it will use faster. Make sure to purge old data or your page/database size will be huge especially with 10-30 players.

Rollback Post to Revision RollBack
PetrichorCraft
- Join Date: 12/30/2016
- Posts: 15
- Member Details
#3283 PetrichorCraft

View User Profile

Send Message

Posted Feb 21, 2018
Actually, we just had another problem - a huge one. Only very recent changes are logged. We can no longer use /co i on older blocks ("No block data found for this location"). Anyone know what may have caused this?

Rollback Post to Revision RollBack
codewow
- Location: Chicago
- Join Date: 11/14/2008
- Posts: 71
- Member Details
#3286 codewow

View User Profile

Send Message

Posted Apr 6, 2018
In reply to PetrichorCraft:

It's possible you have auto-purge on in the config. Which will purge block data that is X (typically older than 1 month)

Rollback Post to Revision RollBack
PetrichorCraft
- Join Date: 12/30/2016
- Posts: 15
- Member Details
#3282 PetrichorCraft

View User Profile

Send Message

Posted Feb 18, 2018
To the three directly below me that said it doesn't work on 1.12, I have no idea what you're talking about, it works fine for me - 1.12.2.

Fine, that is, except for the fact that it takes several (and I mean sometimes over 50) tries to get it to do a rollback - Database Busy. Please try again later.
In normal circumstances, it does work fine for me, and only takes a bit to do a full rollback of the area I want, and it shows the details of who broke/placed a block, took from a chest, etc. just fine.

Rollback Post to Revision RollBack
starwish_sama
- Join Date: 3/25/2017
- Posts: 3
- Member Details
#3281 starwish_sama

View User Profile

Send Message

Posted Jan 2, 2018
plz support 1.12.2

Rollback Post to Revision RollBack
Tianyi
- Join Date: 12/7/2017
- Posts: 2
- Member Details
#3280 Tianyi

View User Profile

Send Message

Posted Dec 31, 2017
1.12.2?

Rollback Post to Revision RollBack
Fischchen_banane
- Join Date: 12/22/2017
- Posts: 3
- Member Details
#3279 Fischchen_banane

View User Profile

Send Message

Posted Dec 27, 2017
It dosent works on 1.12

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.