Inactive [SEC] BigBrother 1.11.0 - Catch griffers red-handed [1060]

Discussion in 'Inactive/Unsupported Plugins' started by N3X15, Apr 13, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    N3X15

    [​IMG]
    Important Crap

    I'm done, but BB isn't.
    I've got 10 developers on the contributors' list who supposedly want to help, but I haven't heard a word from them since the day I added them. BigBrother's so full of bugs now that I don't know where to start, and I simply don't have the time or patience to work on it anymore. If you want something that works, pick up LogBlock. I'm fucking done. I updated it to "run" on 1060, but that's as far as I'm taking this. If you still want to help, email me at nexis@7chan.org and give me a rundown of your experience in coding plugins so I know you'll do something.​
    UPDATE: 3 developers have been added to the repo, but I'm waiting for them to get familiarized and start committing before I declare this crisis over. I appreciate the support and help that has been thrown this way. If you'd still like to help, but don't know how to code, there are many other ways to contribute. See the Contributors section for more info.​


    Version: 1.11.0
    Original Author: tkelly910

    Contributors
    • Development Team
      • N3X15
      • Mafio
      • FalconGaming
    • Quality Assurance (QA) Team (Testing, ONLY ON LATEST RB*!)
      • N3X15
      • Mineral
      • All of the poor bastards on the 7chan.org minecraft server + other dev servers
      • *NOTE: Unless EvilSeph or other bukkit devs indicate an RB is imminent, e.g. within the next week.
    • Bug Triage (Sorting through bugs, marking duplicates, closing, prioritizing)
      • N3X15
    • Documentation (Wiki, FAQ, other stuff people will read)
      • N3X15
    • MORE NEEDED. PLEASE PM ME IF YOU ARE INTERESTED IN TESTING OR DEVELOPING.
    Introduction

    BigBrother is a powerful plugin that enables you to investigate roll back griefing via a large and all-knowing database. You have a choice between using immensely powerful commands to search an area for changes, or you can whack a block with a stick or place a log to see changes within a single block.

    • /bb log - Gives you the BigBrother Multipurpose Tool, or a simple log. Hit something with it to see changes in that spot, and place it if the block you're check is non-solid, like water, lava or air.
    • /bb done - Removes the log from your inventory, and gives you back any items it replaced.
    • Want to check an entire area? Use /bb here to list who changed what!
    • Need to roll back EvilGuy and DoucheBug's edits? Use /bb rollback EvilGuy DoucheBug!
      • Have to roll back edits up to 5 minutes ago? Simple! /bb rollback t:5m
      • Need to only roll back within a certain radius? /bb rollback r:<radius-in-blocks>
      • Roll back specific actions with /bb rollback a:10,BLOCK_PLACE
    • If you screw up, /bb undo
    • (NEW) /bb history "Suspicious Guy" to see that player's recent history! (add pg:# to go to page #)
    • Mow your lawn with /bb mowlawn!
    See the full list of commands and Permissions nodes here.

    Screenshots

    [​IMG]
    [​IMG]
    [​IMG](Yes, stationary_* and regular blocks got reversed, this is fixed.)​
    [​IMG]

    Need Help?

    • What version of CraftBukkit and BigBrother? If you don't know, type /version and /bb version.
    • What database engine are you using? Look at the value for database.type in BigBrother.yml. I use MySQL on my server and test on H2.
    • Do you get any errors? If so, please link to a pastebin with your server.log
    • What steps do I have to take to reproduce this behavior?
    • What other plugins are you using?
    Known Issues
    • Everything listed here
    • ItemCraft is not supported due to it sending unexpected NULLs via Block.getType(). Can be fixed by adding a new enum value for unknown blocks.
    • Bugs everywhere, stopped counting.
    Coming Soon
    • /bb history - Gets the history of a player
    • Fixed /bb update
    • Updated API
    • Externally accessible API
    • Custom Action IDs (for WorldEdit support, etc.)
    More Information

    IRC: Support/Chatter/Developer Jive @ irc.7chan.org #bigbrother (Moved so my build notification bot has an easier time notifying multiple channels)

    Changelog
    BigBrother 1.11.0 Changelog
    • Centralize and update bystander checks.
    • Fix parsing errors in DeltaChest
    • Clarify /bb log
    • Fix sign lines being too far down
    • Add command censoring (for people worried about xAuth and the like)
    • Fix pagination capping
    • Fix an error in DeltaChest reading
    • Add ?autoReconnect=true to the MySQL DSN
    • Remove all H2 support
    • Removed /bb stick from /bb help since it is now obsolete
    • Fixed it so commands that work won't say commands not recognized after they already work
    • Fixed the issue of when you had the /bb log if you broke something it would not record the break even if you were watched
    • Now if the user tries to find the history of an invalid user it won't throw null errors.
    • Yell at the users if they don't follow the setup procedure
    • Should fix most of the errors dealing with the log and watch/unwatch problems
    • Update README
    1.10.0+ (open)

    BigBrother 1.10.1 Changelog
    • Fix a rollback SQL syntax error
    • Fix explosion logging
    • Clarify database trimming message in log
    • Fix /bb history
    • Continue rolling back incorrectly-logged BlockBurns, if the data field is unparsable, default to 0.
    • Fix Heartbeat logging
    • Fix SuperPerms support.
    BigBrother 1.10.0 Changelog

    New Features:
    • Brand new plugin API! (Wiki)
    • Database change. There is now a converter, but you might still lose data!
    • Compact chest changes: (+Added)(=Replaced)(-Removed)
    • Heartbeat Action: Logs users online and the current time, both to keep your database connection open, and for monitoring of your server's uptime!
    • Piston Actions!
    • Bukkit Superperms support!
    • RB 1000 support!
    • /bb history!
    • Formatting fix for rollbacks
    • A buttload of NPE fixes
    Bugfixes:


    • [BB-81] Rollback doesn't work because of empty data-values
    • [BB-78/BB-69] onPickupItem/onDropItem NPEs
    • Memory leak fix (Thanks to Wootalyzer!)
    BigBrother 1.9.1:

    • Use BlockSpreadEvent for tracking fires (later told by EvilSeph that there's no current way to track fire in Bukkit)
    • Display a "Permission Denied" to users trying to use commands with insufficient priviliges instead of silently failing.
    • Add /bb mowlawn.
    • Fix stupid mixup between String.format usage on C# and Java in DeltaChest
    • Automatically update plugin.yml via Maven (internal crap)
    BigBrother 1.9


    • Support for 928+
    • NEW: Lava/Water/Fire flow logging (AND ACTUALLY TESTED, FOR ONCE!)
    • NEW: a: directive for rollbacks, for specifying comma-delimited action IDs to track
    • Lots and lots of bugfixes.
    • Marginally better H2 support
    • More automated tests
    • Standardized QA tests (ongoing)
     
  2. Offline

    mcanusrules

    Same here, except it's not every now and then. It happens when I start BB, and after I stop the server MySQL is still maxing out the CPU.
     
  3. Offline

    Teh_Bucket

    This plugin is amazing. It is essential for any server.
     
    fneyret likes this.
  4. Offline

    Stadionfeger

    is there a way to undo the 2 latest rollbacks? :S
     
  5. Offline

    Unscrewed

    I got a big-ass error each time:

    Code:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0)
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.table.Column.validateConvertUpdateSequence(Column.java:321)
    at org.h2.table.Table.validateConvertUpdateSequence(Table.java:671)
    at org.h2.command.dml.Insert.insertRows(Insert.java:122)
    at org.h2.command.dml.Insert.update(Insert.java:86)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
    at java.lang.Thread.run(Unknown Source)
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b303a3236323a2b36343a303a303b313a3335313a2b323a303a303b323a3334363a313a303a333d3236353a36343a303a303b333a3239363a2d31343a303a3... (2068)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b333a33353a36343a303a303d333a36343a303a303b343a33353a2d35303a303a303b363a3335313a2d36343a343a343b373a3335313a2d36343a343a343b3... (772)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b303a343a2b36343a303a303b333a343a2d36343a303a303b343a343a2d36343a303a303b353a343a2d36343a303a303b393a343a2b36343a303a303b31303... (916)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b393a3333343a2b35303a303a303b31303a3335313a2b32323a333a333b31313a3239363a2b36343a303a303b31323a3239363a2b36343a303a303b31333a3... (768)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b303a353a2b33353a303a303b313a3335313a2b313a333a333b323a3332353a2b313a303a303b333a313a2b32353a303a303b343a3239333a2b313a303a313... (550)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b32313a363a2b35303a303a303b32393a3335323a2b36323a303a303b33353a3238393a2b31303a303a303b33363a3239363a2b36343a303a303b33373a323... (556)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    2011-05-03 16:50:44 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-03 16:50:45 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 12": "'7b303a3333313a2b36343a303a303b313a3239363a2b36343a303a303b323a3332333a2b313a303a303b333a3333313a2b36343a303a303b343a333a2b363a3... (578)"; SQL statement:
    
    It stopped now though
     
  6. Offline

    andrewkm

    it would be nice... but i dont think so.

    Something like:
    http://forums.bukkit.org/threads/my-msql-keeps-crashing-losing-connection.15786/
    ? (Wondering if u have same issue as me, and if it was BB that causes it)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  7. Offline

    MacG32

    I had that problem going to BB #405, along with 100% processor usage. I repaired my database, restarted MySQL, updated to BB #407, and everything seems fine now. I'm also using CB #755. Here's what my .yml file looks like. Hope it helps.
    Code:
    general:
        rollbacks-per-tick: 2000
        personal-log-files: true
        auto-watch: true
        debug-mode: false
        default-search-radius: 2
        restore-fire: false
        stick-item: 280
        library-autodownload: true
        excluded-blocks: []
        tnt-threshold: 10.0
    database:
        cleanse-age: 3d
        deletes-per-cleansing: '20000'
        max-records: '3000000'
        type: MYSQL
        send-delay: 4
        mysql:
            port: ####
            username: ####
            engine: MyISAM
            prefix: ####
            low-priority-insert: true
            hostname: localhost
            password: ####
            database: ####
    watched:
        environment:
            lava-flow: true
            leaf-decay: true
        player:
            ip-player: true
            disconnect: true
            login: true
            teleport: true
            drop-item: false
            pickup-item: false
        explosions:
            tnt: true
            creeper: true
            misc: true
        chat:
            commands: true
            chat: true
        blocks:
            chest-changes: true
            block-place: true
            block-break: true
        misc:
            flint-logging: true
            door-open: true
            lever-switch: true
            button-press: true
     
  8. Offline

    Phat32

    I have been having the same issue with BB for MySQL, however I have found another bug. If you use the stick the server just freezes. I have to kill the server to make it work
     
  9. Offline

    Jessicadawn

    Once again we cant use bb on our server running latest rb and it always shows "No edits on this block" Can you PLEASE get this fixed. I run a big server with lots of people and griefing is happening...
     
  10. Offline

    Kevin Forte

    Code:
    21:09:47 [SEVERE] [BBROTHER] Could not executeUpdate for Upgrading to BLOBs inst
    ead of VARCHAR.:
    org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "69
    .132.136.173"; SQL statement:
     -- row #2 (37187, 1303781792, 3, 8, 0, 715, 61, 456, 0, '69.132.136.173', FALSE
    ) [90004-153]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.get(DbException.java:144)
            at org.h2.util.StringUtils.getHexDigit(StringUtils.java:975)
            at org.h2.util.StringUtils.convertStringToBytes(StringUtils.java:961)
            at org.h2.value.Value.convertTo(Value.java:832)
            at org.h2.table.Column.convert(Column.java:151)
            at org.h2.command.dml.Insert.addRow(Insert.java:155)
            at org.h2.command.dml.Select.queryFlat(Select.java:524)
            at org.h2.command.dml.Select.queryWithoutCache(Select.java:614)
            at org.h2.command.dml.Query.query(Query.java:269)
            at org.h2.command.dml.Insert.insertRows(Insert.java:134)
            at org.h2.command.dml.Insert.update(Insert.java:86)
            at org.h2.command.ddl.CreateTable.update(CreateTable.java:176)
            at org.h2.command.ddl.AlterTableAlterColumn.execute(AlterTableAlterColum
    n.java:395)
            at org.h2.command.ddl.AlterTableAlterColumn.cloneTableStructure(AlterTab
    leAlterColumn.java:287)
            at org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColu
    mn.java:181)
            at org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn
    .java:118)
            at org.h2.command.CommandContainer.update(CommandContainer.java:69)
            at org.h2.command.Command.executeUpdate(Command.java:212)
            at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedS
    tatement.java:143)
            at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement
    .java:129)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.jav
    a:86)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.jav
    a:99)
            at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:30)
            at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:179)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:632)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:218)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Thought you might like that.
     
  11. Offline

    JagerPrime

    EDIT: WOAH If i do any checks of a spot with BB, it locks the server up for that amount of time while it searches...

    I run two servers.
    Server A: bbdata file is 245mb
    Server B: bbdata file is 89mb

    The configs are the exact same as each other, except for the table they print into.

    Checks done with the log or stick on server A are instant.
    Checks done with the log or stick on server b take around 5 seconds to happen.

    Any clue what may be causing this? I get no error's. I can provide whatever info you may need.
     
  12. Offline

    Lunar Delta

    I've been getting a shitload of invalid database address jdbc:jdc:jdcpool errors lately, and BB keeps corrupting my entire database and borking my phpmyadmin installation. I never had any of these issues until I upgraded to the 405 snapshot.

    BB in general has been terribly unreliable as of late. I keep having to completely drop the tables because of unrecoverable errors, and if that is the case then what is the point of running it at all? If this keeps up I just might have to try logblock.
     
  13. Offline

    TewDIE

    405 causes my mysql software to completely crash. Completely useless after about 1 hour of use. using H2 atm having some heavy lags in block placings once in a while
     
  14. Offline

    hintzsche

    [BROTHER] Possible cause of previous SQLExeption
    [BROTHER] SQL Send Failed. Keeping data for later.
    [BROTHER] Data Insert SQL Exeption when sending blocks
    [BROTHER] java.sql.BatchUpdateExeption: Lock wait timeout exeeded; try restarting transaction
    at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
    at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSql(DataBlockSender.java:85)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
    at me.taylorkelly.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:225)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Unknown Source)


    please help ^^
     
  15. Offline

    Fearlessagent

    Thanks for the help! Unfortunately for me I must be doing something wrong on the MySQL end because I upgraded to CB#755 and BB#407 and nothing changed. I wouldn't doubt its something like a misplaced punctuation. Those types of things haunt me. I'll take a look tomorrow.
     
  16. Offline

    Phat32

    using CB #740 and BB #409 stick will crash the server every time
     
  17. Offline

    Hakaslak

    The amount of connections seems kinda excessive for most MySQL servers - I had to raise the connection limit for the server to stop crashing - is this ok?

    BigBrother 405
    CB 740
    MySQL 5.5.11
    Windows Server 2008 R2 Datacenter


    [​IMG]

    and 5 minutes later....

    [​IMG]
     
  18. Offline

    Clontarf[X]

    Hey there,

    I am using latest recommended (#405) and intermittently see that happening. At some point, a BB update had corrupted my bbdata tables. Try dropping the tables (after backing them up of course) and then restart the server so that BB recreates the tables. I'm pretty sure something changed with the way BB talks to MySQL which based on the amount of reports in this thread has affected a lot of servers.

    This is the proc listing for an idle server;

    Code:
    www:/home/minecraft# mysqladmin proc -p
    Enter password:
    +-------+------+-----------------+-------------------+---------+------+-------+------------------+
    | Id    | User | Host            | db                | Command | Time | State | Info             |
    +-------+------+-----------------+-------------------+---------+------+-------+------------------+
    | 20330 | root | localhost:53105 | minecraft_vanilla | Sleep   | 100  |       |                  |
    | 20331 | root | localhost:53106 | minecraft_vanilla | Sleep   | 69   |       |                  |
    | 21999 | root | localhost       |                   | Query   | 0    |       | show processlist |
    +-------+------+-----------------+-------------------+---------+------+-------+------------------+
    
     
  19. Offline

    Novar234

    BB Is unrealiable. I'd stop using it, its causing too many issues on the MYSQL backend, (TOO MANY CONNECTIONS BRO)
     
  20. Offline

    stkeroro

    the solution is going back to build 366???
     
  21. Offline

    Scipione

    yap .... needed to deactivate BB, too .. please fix cause BB is really a good plugin :)
     
  22. Offline

    1994mat

    BB is being unstable after 740+
     
  23. Offline

    f5inet

    as we can see, the problem is the SLUGGISH 'DELETE FROM...' SQL sentence. perhaps a simpler DELETE FROM bbdata WHERE date<'now minus x days' can make the trick.

    if you kill the DELETE SQL connection, all the INSERTs waiting for the lock, commit succesfully and BigBrother work flawlessly. Also, Mysql goes from 100% CPU to 2-5% CPU time (the normal CPU Time)
     
  24. Offline

    bluemoondevil

    I keep getting this error everytime I start my server with BB.
    05:58:01 [INFO] [BBROTHER] ------------------------------------
    05:58:01 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of
    BigBrother!
    05:58:01 [INFO] [BBROTHER] Please note that, since this is far from complete, th
    ere will be many bugs.
    05:58:01 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bu
    gs.nexisonline.net/bb
    05:58:01 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for up
    dates and build notifications.
    05:58:01 [INFO] [BBROTHER] ------------------------------------
    05:58:02 [INFO] [BBROTHER] Building `bbdata` table...
    05:58:02 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    05:58:03 [SEVERE] [BBROTHER] Create World Table SQL Exception
    org.h2.jdbc.JdbcSQLException: Table "BBWORLDS" already exists; SQL statement:
    CREATE TABLE `bbworlds` (`id` INTEGER PRIMARY KEY,`name` varchar(50) NOT NULL DE
    FAULT 'world'); [42101-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.command.ddl.CreateTable.update(CreateTable.java:108)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:12
    5)
    at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
    at me.taylorkelly.bigbrother.WorldManager.createWorldTable(WorldManager.
    java:100)
    at me.taylorkelly.bigbrother.WorldManager.<init>(WorldManager.java:20)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:143)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:632)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    05:58:04 [INFO] [BBROTHER] Building `bbusers` table...
    05:58:05 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.7.2
    05:58:05 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    05:58:06 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT enabled

    I'm using craftbukkit 740 and I've got Windows XP
     
  25. Offline

    Jessicadawn

    Please fix thisssssss......I really need BB :(!!
     
  26. Offline

    Trust518

    BB does not work for me since 740
     
  27. Offline

    but2002

    Guys, I'm sure he's working on it. Bugs like this are sometimes extremely hard to find in code, and sometimes are not easy to fix. And when they do get fixed, some testing has to happen before a fix can be considered safe or unsafe. Hold your horses.

    Remember, he's also working on re-writing the plugin from scratch, BigBrother 2.0 is on it's way.
     
  28. Offline

    Ratchet

    Code:
    2011-05-04 08:08:48 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Unknown Source)
    2011-05-04 08:08:48 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    2011-05-04 08:08:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:09:15 [INFO] /173.234.147.81:52304 lost connection
    2011-05-04 08:09:30 [INFO] /50.23.30.168:51272 lost connection
    2011-05-04 08:10:29 [INFO] /94.231.109.47:33581 lost connection
    2011-05-04 08:10:37 [INFO] /94.231.101.83:54526 lost connection
    2011-05-04 08:10:39 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Unknown Source)2011-05-04 08:12:48 [SEVERE] [BBROTHER] Possible cause of previous SQLException: 
    2011-05-04 08:12:48 [SEVERE] [BBROTHER] Possible cause of previous SQLException: 
    2011-05-04 08:12:48 [SEVERE] [BBROTHER] Possible cause of previous SQLException: 
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    2011-05-04 08:12:48 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    I keep getting this in my logs.. any idea?
     
  29. Offline

    Lil_Lyon

    If your having issues with the latest builds rollback to an older build; I would recommend 360. build 405 is broken I upgraded to 407 no issues since.
     
  30. Offline

    Sumsang

    I also get the "SQL send failed" thingy, but my database was spammed full with MILLIONS of entries which always contained "0" in the "data" row.
     
  31. Offline

    quickclay

    One small issue I've noticed is that if you /bb undo your last rollback, the block edits in the initial edit event you rolled back are lost. Ok that sounded confusing.. example:
    -The local area has a creeper explosion logged as environment edit.
    1) /bb rollback environment t:8h r:20 - > explosion removed
    "oops too far"
    2) /bb undo -> explosion restored
    3) /bb rollback environment t:4h r:20 -> no edits found
    hmmm
    4) /bb here -> no edits found
     
Thread Status:
Not open for further replies.

Share This Page