ChestShop-authors / ChestShop-3

ChestShop - the chest & sign shop plugin for Minecraft Servers running Bukkit/Spigot/Paper
https://dev.bukkit.org/projects/chestshop
GNU Lesser General Public License v2.1
275 stars 176 forks source link

Console Error about Xerial SQLite driver & tables #49

Open nitewing76 opened 7 years ago

nitewing76 commented 7 years ago

Please see error on PasteBin (must be read from the bottom up).

VADemon commented 7 years ago

Corrected link Log:

24.05 12:35:55 [Server] WARN 17810 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - executed create table statement changed 0 rows: CREATE INDEX IF NOT EXISTS `accounts_shortName_idx` ON `accounts` ( `shortName` )
24.05 12:35:55 [Server] WARN 17810 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `accounts` (`lastSeenName` VARCHAR NOT NULL , `name` VARCHAR NOT NULL , `shortName` VARCHAR NOT NULL , `uuid` VARCHAR NOT NULL , PRIMARY KEY (`name`) ) 
24.05 12:35:55 [Server] WARN 17809 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - creating index 'accounts_shortName_idx' for table 'accounts
24.05 12:35:55 [Server] WARN 17808 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - creating table 'accounts'
24.05 12:35:55 [Server] WARN 17808 [Server thread] ERROR com.Acrobot.ChestShop.ORMlite.db.SqliteDatabaseType - WARNING: you seem to not be using the Xerial SQLite driver.  See ORMLite docs on SQLite: http://ormlite.com/docs/sqlite
24.05 12:35:55 [Server] WARN 17804 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `items` (`id` INTEGER PRIMARY KEY AUTOINCREMENT , `code` VARCHAR NOT NULL ,  UNIQUE (`code`)) 
24.05 12:35:55 [Server] WARN 17794 [Server thread] INFO com.Acrobot.ChestShop.ORMlite.table.TableUtils - creating table 'items'
24.05 12:35:55 [Server] WARN 17684 [Server thread] ERROR com.Acrobot.ChestShop.ORMlite.db.SqliteDatabaseType - WARNING: you seem to not be using the Xerial SQLite driver.  See ORMLite docs on SQLite: http://ormlite.com/docs/sqlite
24.05 12:35:55 [Server] INFO Enabling ChestShop v3.8.13-SNAPSHOT (build #11)

You can use gist.github.com for pastes or enclose code within three ``` apostrophs ```

nitewing76 commented 7 years ago

Thanks for correcting the link.

Phoenix616 commented 7 years ago

These are not real errors but just warnings. The reasoning behind them showing is described in the corresponding Bukkit issue.

Phoenix616 commented 6 years ago

The ORMlite update seems to really have fixed the Xerial driver warning. I'll have to look into how to stop it from sending the table messages though.

Drainer2002 commented 4 years ago

Phoenix616, u said u don't get these info msgs so u cant tests them. I can test it on my server

Phoenix616 commented 4 years ago

Phoenix616, u said u don't get these info msgs so u cant tests them. I can test it on my server

Could you start by providing some information about your setup like requested before? (your server type and version, operating system version and some info about how you host it)

Drainer2002 commented 4 years ago

if you don't mind, can I get ur discord to reply as fast as possible?

Phoenix616 commented 4 years ago

I mind, please just post the information here so that we can collect it and it's accessible to anyone who might be able to work on it.

Drainer2002 commented 4 years ago

Server Type: Spigot Version: 1.12.2 It is a Towny server. and my server is hosted by a private ppl any more info ?

Phoenix616 commented 4 years ago

@Drainer2002 Which Spigot version are you running exactly? Also which operating system and java version is this running on?

Also could you try adding -Dcom.j256.ormlite.logger.type=LOCAL and -Dcom.j256.ormlite.logger.level=ERROR to your startup arguments? (Before the -jar)

Phoenix616 commented 4 years ago

So it isn't problem and it doesn't affect server's CPU?

The only problem here is that the message shows up for some people and not for others. Please provide the information requested in this comment and test the startup arguments.