Linux Server Issue

[Guite Emortal]

The other day I was able to run 'mono start.exe' just fine and after I restarted the server I started to get some weird errors.
Cannot launch my server at all as of this time. I have tried with a fresh server file and get the same errors.

I've updated SQlite, and mono with no success. Any help would be appreciated.

errors-mono-sgen.log

Spoiler

2020-06-29 05:25:06.974 [Error] Received unhandled exception from .

--------------------------------------------------------------------------------
2020-06-29 05:25:06.976 [Error] 
  Message: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
    Stack:   at (wrapper managed-to-native) System.Object.__icall_wrapper_mono_generic_class_init(intptr)
  at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteRelationalConnection.CreateDbConnection () [0x00006] in <6fac96ba37a44740bc51ba823588ec81>:0 
  at Microsoft.EntityFrameworkCore.Internal.LazyRef`1[T].get_Value () [0x00008] in <905e41ddd9a149f0936da7d5ab99e38e>:0 
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection () [0x00000] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open (System.Boolean errorsExpected) [0x00000] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteRelationalConnection.Open (System.Boolean errorsExpected) [0x00000] in <6fac96ba37a44740bc51ba823588ec81>:0 
  at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteDatabaseCreator.Exists () [0x0000c] in <6fac96ba37a44740bc51ba823588ec81>:0 
  at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists () [0x0000b] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrations () [0x00006] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetAppliedMigrations (Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade databaseFacade) [0x00010] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetPendingMigrations (Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade databaseFacade) [0x00006] in <1b06b8e99d984506b89b3e4ae11831eb>:0 
  at Intersect.Server.Database.IntersectDbContext`1[T].get_PendingMigrations () [0x0000a] in <4d78250d4e6c42e28ecb2fb35e8467b6>:0 
  at Intersect.Server.Database.DbInterface.InitDatabase (Intersect.Server.Core.ServerContext serverContext) [0x000ec] in <4d78250d4e6c42e28ecb2fb35e8467b6>:0 
  at Intersect.Server.Core.Bootstrapper.PostContextSetup () [0x0001e] in <4d78250d4e6c42e28ecb2fb35e8467b6>:0 
  at Intersect.Server.Core.Bootstrapper.Start (System.String[] args) [0x0003e] in <4d78250d4e6c42e28ecb2fb35e8467b6>:0 
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <a17fa1457c5d44f2885ac746c1764ea5>:0 

Caused By
  Message: Exception has been thrown by the target of an invocation.
    Stack:   at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00083] in <a17fa1457c5d44f2885ac746c1764ea5>:0 
  at System.Reflection.MethodBase.Invoke (System.Object obj, System.Object[] parameters) [0x00000] in <a17fa1457c5d44f2885ac746c1764ea5>:0 
  at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize () [0x0002f] in <56cfa09aae23467e945f1a64a1f893bb>:0 
  at Microsoft.Data.Sqlite.SqliteConnection..cctor () [0x00000] in <56cfa09aae23467e945f1a64a1f893bb>:0 

Caused By
  Message: e_sqlite3 assembly:<unknown assembly> type:<unknown type> member:(null)
    Stack:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3+NativeMethods.sqlite3_libversion_number()
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number () [0x00000] in <94e90f2e2a1e4f8983b76383f64574ce>:0 
  at SQLitePCL.raw.SetProvider (SQLitePCL.ISQLite3Provider imp) [0x00008] in <724f9a22df504a05b4645fb690570b7a>:0 
  at SQLitePCL.Batteries_V2.Init () [0x00005] in <a13ad878b60c48a5be8c61d809c413bc>:0 
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <a17fa1457c5d44f2885ac746c1764ea5>:0 

--------------------------------------------------------------------------------
2020-06-29 05:25:06.978 [Error] Inner Exception?

--------------------------------------------------------------------------------
2020-06-29 05:25:06.978 [Error] 
  Message: Exception has been thrown by the target of an invocation.
    Stack:   at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00083] in <a17fa1457c5d44f2885ac746c1764ea5>:0 
  at System.Reflection.MethodBase.Invoke (System.Object obj, System.Object[] parameters) [0x00000] in <a17fa1457c5d44f2885ac746c1764ea5>:0 
  at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize () [0x0002f] in <56cfa09aae23467e945f1a64a1f893bb>:0 
  at Microsoft.Data.Sqlite.SqliteConnection..cctor () [0x00000] in <56cfa09aae23467e945f1a64a1f893bb>:0 

Caused By
  Message: e_sqlite3 assembly:<unknown assembly> type:<unknown type> member:(null)
    Stack:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3+NativeMethods.sqlite3_libversion_number()
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number () [0x00000] in <94e90f2e2a1e4f8983b76383f64574ce>:0 
  at SQLitePCL.raw.SetProvider (SQLitePCL.ISQLite3Provider imp) [0x00008] in <724f9a22df504a05b4645fb690570b7a>:0 
  at SQLitePCL.Batteries_V2.Init () [0x00005] in <a13ad878b60c48a5be8c61d809c413bc>:0 
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <a17fa1457c5d44f2885ac746c1764ea5>:0 

--------------------------------------------------------------------------------
2020-06-29 05:25:06.979 [Error] Inner Exception? Inner Exception?

--------------------------------------------------------------------------------
2020-06-29 05:25:06.979 [Error] 
  Message: e_sqlite3 assembly:<unknown assembly> type:<unknown type> member:(null)
    Stack:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3+NativeMethods.sqlite3_libversion_number()
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number () [0x00000] in <94e90f2e2a1e4f8983b76383f64574ce>:0 
  at SQLitePCL.raw.SetProvider (SQLitePCL.ISQLite3Provider imp) [0x00008] in <724f9a22df504a05b4645fb690570b7a>:0 
  at SQLitePCL.Batteries_V2.Init () [0x00005] in <a13ad878b60c48a5be8c61d809c413bc>:0 
  at (wrapper managed-to-native) System.Reflection.RuntimeMethodInfo.InternalInvoke(System.Reflection.RuntimeMethodInfo,object,object[],System.Exception&)
  at System.Reflection.RuntimeMethodInfo.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0006a] in <a17fa1457c5d44f2885ac746c1764ea5>:0 

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

 

[wishy]

what version are you using?

you can get the mono version by typing

mono --version

 in the console, output should be something like this: 

Mono JIT compiler version 6.8.0.105 (tarball Tue Feb  4 21:20:20 UTC 2020)
Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors. www.mono-project.com
        TLS:           __thread
        SIGSEGV:       altstack
        Notifications: epoll
        Architecture:  amd64
        Disabled:      none
        Misc:          softdebug
        Interpreter:   yes
        LLVM:          yes(610)
        Suspend:       hybrid
        GC:            sgen (concurrent by default)

 

sqlite version can be seen by going into a python console and typing

import sqlite3
print "SQLite Version is:", sqlite3.sqlite_version
print "DB-API Version is:", sqlite3.version

output should be something like this:

SQLite Version is: 3.22.0
DB-API Version is: 2.6.0

 

 

These are the steps i do on a fresh ubuntu 18.04 server to get an intersect server running:

apt update
apt install dirmngr gnupg apt-transport-https ca-certificates
apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF
sh -c 'echo "deb https://download.mono-project.com/repo/ubuntu stable-bionic main" > /etc/apt/sources.list.d/mono-official-stable.list'
apt update
apt install mono-complete 

 

[Scaly]

If you want the same version as @wishy here is what you would do to lock in the older version of mono:

sh -c 'echo "deb https://download.mono-project.com/repo/ubuntu stable-bionic/snapshots/6.8.0.105 main" > /etc/apt/sources.list.d/mono-official-stable.list'

 

Go to this website to check the different versions:

https://download.mono-project.com/repo/ubuntu stable-bionic

 

obviously after you do this you're going to need to run an apt update.

 

Edit: After testing this out - this is a working fix @Guite Emortal.

 

As always thanks to @wishy for providing the above information which lead me on the right path on how to get this working (at least with my version of intersect).

[Lathander]

I ended up moving my install from Linux to a Windows hosted server with AWS. There was something fishy going on with mono, causing crashes (I was on Ubuntu, digitalocean). And the error report was not at all useful to me. Maybe the team would want to address it, and I am happy to share my error file as well, but after switching I haven't had any issues.

[jcsnider]

I know you said you've updated it, but that error almost exclusively occurs when libsqlite3 or libsqlite3-dev is out of date. (Or maybe too new?)

 

Not sure, I have all the servers I host running in Linux docker containers, over 30 of them now, no issues whatsoever.

[Guite Emortal]

Mono Version:
 

Spoiler

Mono JIT compiler version 6.10.0.104 (tarball Fri Jun 26 19:38:44 UTC 2020)
Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors. www.mono-project.com
    TLS:           __thread
    SIGSEGV:       altstack
    Notifications: epoll
    Architecture:  amd64
    Disabled:      none
    Misc:          softdebug 
    Interpreter:   yes
    LLVM:          yes(610)
    Suspend:       hybrid
    GC:            sgen (concurrent by default)
 

 

SQLite Version:
SQLite version 3.32.3 2020-06-18 14:00:33


EDIT: 
Started with fresh version of Ubuntu 18.04
- I can't for whatever reason install a version of mono other than 6.10.104
- brought sqlite3 back to version 3.22.0

Still no luck running my server

[TheKezStrel]

HI,

 

I'm Running Intersect 0.6.0.182 on a virtual Linux server in the Oracle cloud with the same version of mono as wishy has 6.8.0.105, yet my SQlite versions are  3.7.17 and DB-API 2.6.0.

I had similar issues when running Intersect and when I disconnected if it did run, the server closed.

The answer for me was to run intersect in a tmux shell (a terminal emulator program) AS ADMIN (sudo). 

Log into your server and type tmux. This will give you a terminal window with a green footer.

When in tmux, run

 

sudo mono "Intersect Server.exe"

or whatever your .exe file is called in "speech marks"

This should run your server.

To exit and let your server run unattended press [CTRL] + {B} to issue a command to tmux, then press [D] to disconnect from the terminal and return to your standard prompt.

You can disconnect now and it should run all the time.

 

To admin your server from the terminal again, connect to your server normally and type 

tmux attach

 

I hope this helps.

 

TheKezStrel

Edited June 30, 2020 by TheKezStrel
Version numbers change and new information.

[TheKezStrel]

Hi all.

 

As a further update, I have managed to log into my control panel and see what O.S. was installed.

The O.S. on the virtual server in the Oracle Cloud is CentOS-7-2020.01.27-0

Weather that has any bearing on your issue Guite Emortal, I have no idea.

 

Hopefully it was just an issue with not running under admin (sudo).

The TMUX was so it could continue running whilst I logged off.

 

Let us know if you have any further issues or if this fixes it for you.

 

TheKezStrel

[TheKezStrel]

Hi all,

 

Again, sorry for the excessive posts. But..........

Found this which may be useful if it is sqlite issue.  https://askubuntu.com/questions/138284/how-to-downgrade-a-package-via-apt-get

 

Also aptitude package manager may help here if dependencies need to be changed also.

 

Again, Hope this helps.

 

TheKezStrel

[Lucressia]

I also tried it seems to be running but after "Loading, please wait." It just closes and I can't seem to be connecting to the server. Any ideas?

[Smoot]

Hey all just a quick note. I've been fighting to setup a new Ubuntu server install the past couple days. It's running an AWS instance on Ubuntu 20.04 and was trying to run 6.12.xx whatever the latest is at this time. The server would not start at all, just would crash back to command line. Logs really didn't have anything. I just got finished downgrading to Mono 6.8 and am up and running.

 

So just for completeness:

Intersect: .07.0.126

Ubuntu: 20.04.3

Mono 6.8.0.105

Sqlite: 3.31.1

 

I then migrated to Maria 10.3.31 no problems.

 

[Voltramas]

For anyone seeing this issue, I ran into a similar problem when trying to containerize the intersect server using the mono builder image.

 

I had success with using Mono 6.8.0.123, and then installing sqlite3 and libsqlite3-dev.

 

Here is an example dockerfile (disclaimer, this is an example, I am no linux wiz):

FROM mono:6.8.0.123

# Install sqlite dep
RUN su -
RUN apt-get -y update
RUN apt-get install -y sqlite3 libsqlite3-dev

WORKDIR /app

# Copy server files
COPY ./Server/ .

# Remove dev env files
RUN rm /app/resources/playerdata.db
RUN rm /app/resources/logging.db
RUN rm -r /app/logs

# make logs folder
RUN mkdir /app/logs

# Run the application
ENTRYPOINT ["mono", "intersect-server.exe"]