Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Console Error about Xerial SQLite driver & tables #49

Open
nitewing76 opened this issue May 24, 2017 · 11 comments
Open

Console Error about Xerial SQLite driver & tables #49

nitewing76 opened this issue May 24, 2017 · 11 comments

Comments

@nitewing76
Copy link

nitewing76 commented May 24, 2017

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

@VADemon
Copy link

VADemon commented May 24, 2017

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
Copy link
Author

Thanks for correcting the link.

@Phoenix616
Copy link
Member

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

Phoenix616 referenced this issue Apr 18, 2018
This might fix the Xerial driver warning from #9/BUKKIT-1073
@Phoenix616
Copy link
Member

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
Copy link

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

@Phoenix616
Copy link
Member

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
Copy link

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

@Phoenix616
Copy link
Member

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
Copy link

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
Copy link
Member

Phoenix616 commented Jun 25, 2020

@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 Phoenix616 mentioned this issue Jul 4, 2020
Closed
@Phoenix616
Copy link
Member

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants