Upgrade from 5.7.2 to 5.9.0

Question

Upgrade from 5.7.2 to 5.9.0

EvilOlaf opened this issue 9 years ago · 7 comments

EvilOlaf commented 9 years ago

This is what I get from BM after restarting with the new jar.
Actually not sure if I should be worried about anything there. If not take is as informational :P

[19:42:55] [Server thread/INFO]: [BanManager] Enabling BanManager v5.9.0
[19:42:55] [nioEventLoopGroup-2-1/INFO]: [Votifier] Votifier enabled.
[19:42:55] [Server thread/WARN]: 66 [Server thread] INFO me.confuser.banmanager.internal.hikari.HikariDataSource - HikariPool-0 - Started.

[19:42:55] [Server thread/WARN]: 77 [Server thread] WARN me.confuser.banmanager.internal.hikari.pool.PoolBase - HikariPool-0 - Failed to get/set network timeout for connection. (com.mysql.jdbc.JDBC4Connection.getNetworkTimeout()I)

[19:42:56] [Server thread/INFO]: [BanManager] Loaded 913 bans into memory
[19:42:56] [Server thread/INFO]: [BanManager] Loaded 0 mutes into memory
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,292 [INFO] TableUtils creating table 'bm_player_report_locations'
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,293 [INFO] TableUtils creating index 'bm_player_report_locations_player_idx' for table 'bm_player_report_locations
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,293 [INFO] TableUtils creating index 'bm_player_report_locations_world_idx' for table 'bm_player_report_locations
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,293 [INFO] TableUtils creating index 'bm_player_report_locations_report_idx' for table 'bm_player_report_locations
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,357 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE `bm_player_report_locations` (`id` INTEGER AUTO_INCREMENT , `report_id` INTEGER NOT NULL , `player_id` BINARY(16) NOT NULL , `world` VARCHAR(255) NOT NULL , `x` DOUBLE PRECISION NOT NULL , `y` DOUBLE PRECISION NOT NULL , `z` DOUBLE PRECISION NOT NULL , `pitch` FLOAT NOT NULL , `yaw` FLOAT NOT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,415 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_player_report_locations_player_idx` ON `bm_player_report_locations` ( `player_id` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,471 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_player_report_locations_world_idx` ON `bm_player_report_locations` ( `world` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,517 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_player_report_locations_report_idx` ON `bm_player_report_locations` ( `report_id` )
[19:42:56] [Server thread/INFO]: [BanManager] Loaded 49 ip bans into memory
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,553 [INFO] TableUtils creating table 'bm_ip_mutes'
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,553 [INFO] TableUtils creating index 'bm_ip_mutes_ip_idx' for table 'bm_ip_mutes
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,553 [INFO] TableUtils creating index 'bm_ip_mutes_updated_idx' for table 'bm_ip_mutes
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,553 [INFO] TableUtils creating index 'bm_ip_mutes_soft_idx' for table 'bm_ip_mutes
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,554 [INFO] TableUtils creating index 'bm_ip_mutes_created_idx' for table 'bm_ip_mutes
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,554 [INFO] TableUtils creating index 'bm_ip_mutes_expires_idx' for table 'bm_ip_mutes
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,605 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE `bm_ip_mutes` (`id` INTEGER AUTO_INCREMENT , `ip` INT UNSIGNED NOT NULL , `reason` VARCHAR(255) NOT NULL , `actor_id` BINARY(16) NOT NULL , `created` INT(10) NOT NULL , `updated` INT(10) NOT NULL , `expires` INT(10) NOT NULL , `soft` TINYINT(1) , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,647 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mutes_ip_idx` ON `bm_ip_mutes` ( `ip` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,689 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mutes_updated_idx` ON `bm_ip_mutes` ( `updated` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,731 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mutes_soft_idx` ON `bm_ip_mutes` ( `soft` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,769 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mutes_created_idx` ON `bm_ip_mutes` ( `created` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,811 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mutes_expires_idx` ON `bm_ip_mutes` ( `expires` )
[19:42:56] [Server thread/INFO]: [BanManager] Loaded 0 ip mutes into memory
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,813 [INFO] TableUtils creating table 'bm_ip_mute_records'
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,813 [INFO] TableUtils creating index 'bm_ip_mute_records_created_idx' for table 'bm_ip_mute_records
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,813 [INFO] TableUtils creating index 'bm_ip_mute_records_soft_idx' for table 'bm_ip_mute_records
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,813 [INFO] TableUtils creating index 'bm_ip_mute_records_ip_idx' for table 'bm_ip_mute_records
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,853 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE `bm_ip_mute_records` (`id` INTEGER AUTO_INCREMENT , `ip` INT UNSIGNED NOT NULL , `reason` VARCHAR(255) NOT NULL , `expired` INT(10) NOT NULL , `actor_id` BINARY(16) NOT NULL , `pastActor_id` BINARY(16) NOT NULL , `pastCreated` INT(10) NOT NULL , `created` INT(10) NOT NULL , `createdReason` VARCHAR(255) NOT NULL , `soft` TINYINT(1) , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,938 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mute_records_created_idx` ON `bm_ip_mute_records` ( `created` )
[19:42:56] [Server thread/INFO]: 2016-03-14 19:42:56,992 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mute_records_soft_idx` ON `bm_ip_mute_records` ( `soft` )
[19:42:57] [Server thread/INFO]: 2016-03-14 19:42:57,037 [INFO] TableUtils executed create table statement changed 0 rows: CREATE INDEX `bm_ip_mute_records_ip_idx` ON `bm_ip_mute_records` ( `ip` )
[19:42:57] [Server thread/INFO]: [BanManager] Loaded 0 ip range bans into memory

Spigot 1.8.8

EvilOlaf commented 9 years ago

Yes, Sir.

rautamiekka · Answer 1 · 2016-03-14T19:03:04.000Z

Purely FYI.

confuser · Answer 2 · 2016-03-14T19:38:53.000Z

As @rautamiekka says, it's just informative, stating what new tables were created as well as indexes.

EvilOlaf · Answer 3 · 2016-03-15T08:32:57.000Z

Aight.
However the warning about hikari persists.

rautamiekka · Answer 4 · 2016-03-15T12:39:12.000Z

You're not the only one, Olaf. I see exactly same line, although the plugin works.

confuser · Answer 5 · 2016-03-15T12:41:32.000Z

To clarify, are you referring to the following?

[19:42:55] [Server thread/WARN]: 77 [Server thread] WARN me.confuser.banmanager.internal.hikari.pool.PoolBase - HikariPool-0 - Failed to get/set network timeout for connection. (com.mysql.jdbc.JDBC4Connection.getNetworkTimeout()I)

confuser · Answer 6 · 2016-03-15T13:58:11.000Z

It's been changed to an INFO level in the next version of Hikari. It's completely safe to ignore.

Share to