ChestShop-3 icon indicating copy to clipboard operation
ChestShop-3 copied to clipboard

Console Error about Xerial SQLite driver & tables

Open nitewing76 opened this issue 8 years ago • 11 comments

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

nitewing76 avatar May 24 '17 16:05 nitewing76

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 ```

VADemon avatar May 24 '17 16:05 VADemon

Thanks for correcting the link.

nitewing76 avatar May 24 '17 17:05 nitewing76

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

Phoenix616 avatar Oct 07 '17 18:10 Phoenix616

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.

Phoenix616 avatar Apr 19 '18 15:04 Phoenix616

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

Drainer2002 avatar Jun 19 '20 13:06 Drainer2002

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)

Phoenix616 avatar Jun 19 '20 14:06 Phoenix616

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

Drainer2002 avatar Jun 19 '20 16:06 Drainer2002

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.

Phoenix616 avatar Jun 19 '20 17:06 Phoenix616

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

Drainer2002 avatar Jun 19 '20 17:06 Drainer2002

@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 avatar Jun 25 '20 16:06 Phoenix616

I have same problem, https://paste.hostify.cz/?822644cfb6a74497#HVfGeXhQoh7wVKY8iXKWvRJoAjvVqZyjuypkXXbUrvPo

MrNeeony avatar Jul 04 '20 18:07 MrNeeony

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

MrNeeony avatar Jul 04 '20 18:07 MrNeeony

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.

Phoenix616 avatar Jul 04 '20 18:07 Phoenix616