SQLite (Debian) is related with Bug Place Eight

[HETAL]

Bug Place Eight is a pretty known issue, I've started a zombie server using SQLite and I kept getting a Bug Place Eight error on Ubuntu/Debian, but when I changed to MySQL, the errors magically disappeared, my guess with this issue is due to mono capability with SQLite.

[dzienny]

It may happen when you change the game mode. If it occurs you may have to restart the server. It's unlikely that it is releated to the database.

[HETAL]

I've restarted the server many times, this bug seems to be related to Mono more than gamemodes.

[dzienny]

Okey. I will investigate it in the context of a possibly Mono related issue.

[HETAL]

I have found a series of errors that occur at server start if it is using SQLite, it might be related to this.

Code: Select all

SQLite error: CREATE TABLE if not exists Players ( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Name VARCHAR(64), IP CHAR(15), FirstLogin DATETIME, LastLogin DATETIME, totalLogin MEDIUMINT, Title CHAR(20), TotalDeaths SMALLINT, Money MEDIUMINT UNSIGNED, totalBlocks BIGINT, totalKicked MEDIUMINT, color VARCHAR(6), title_color VARCHAR(6), totalScore BIGINT, bestScore MEDIUMINT UNSIGNED, timesWon MEDIUMINT UNSIGNED, welcomeMessage VARCHAR(37), farewellMessage VARCHAR(37));


Code: Select all

SQLite error: CREATE TABLE if not exists `Blockportals` (Username TEXT, TimePerformed DATETIME, X INTEGER, Y INTEGER, Z INTEGER, Type INTEGER, Deleted INTEGER)


Code: Select all

SQLite error: SELECT * FROM `Zoneportals`


[dzienny]

Could you also post the associated error log? It would be very helpful.

[HETAL]

This is over a series of shutdowns and restarts so errors are repeated.

Spoiler:

Code: Select all

----04/15/2014 00:00:22 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:00:24 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:00:24 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:00:24 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.fillData (System.String queryString, System.Collections.Generic.Dictionary`2 parameters, Boolean skipError) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:00:24 ----
Type: NullReferenceException
Source: MCDzienny_
Message: Object reference not set to an instance of an object
Target: StartFreebuild
Trace:   at MCDzienny.Server.StartFreebuild () [0x00000] in <filename unknown>:0
  at MCDzienny.Server.<Start>b__d () [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:16:16 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:19:03 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:05 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:35 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:37 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:37 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.ExecuteQuery (System.String queryString, System.Collections.Generic.Dictionary`2 parameters) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:37 ----
Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL
Target: Open
Trace:   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],int,intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in <filename unknown>:0
  at MCDzienny.SQLite.fillData (System.String queryString, System.Collections.Generic.Dictionary`2 parameters, Boolean skipError) [0x00000] in <filename unknown>:0

-------------------------
----04/15/2014 00:20:37 ----
Type: NullReferenceException
Source: MCDzienny_
Message: Object reference not set to an instance of an object
Target: StartFreebuild
Trace:   at MCDzienny.Server.StartFreebuild () [0x00000] in <filename unknown>:0
  at MCDzienny.Server.<Start>b__d () [0x00000] in <filename unknown>:0

-------------------------

[dzienny]

You are missing a file.

Code: Select all

Type: DllNotFoundException
Source: System.Data.SQLite
Message: System.Data.SQLite.DLL

Do you have the above file in your server folder?

[HETAL]

Yes it is there.

[dzienny]

Yes it is there.

Is it named "System.Data.SQLite.DLL" or "System.Data.SQLite.dll" ? Try changing the name and see if the error happens again.