Solved QueryErrorException and NullReferenceException on server start

Hi, Wulf.

I also Oxide does not start. help sir...
version: steamdb buildid 1220752, oxide new patch
-------------------------------
oxide started after 2 minutes.... lol
Please remove this res(article).

 

Ok, now i got my server back up and running ! map intact, oxide intact, but all xp is back to zero.

I have previous xp files on backup, but no restoring appears to work.

Ideas?

 

Use XpBooster for Rust | Oxide for a short time to let people catch back up to where they were and then remove it.

 

Code:

(20:32:43) | [0.4s] FIELD ROCKS(20:32:44) | [0.3s] CLIFFS(20:32:45) | [1.5s] MICRO CLIFFS(20:32:53) | [6.9s] TERRAIN MESH(20:32:54) | [1.4s] ROAD OBJECTS(20:32:55) | [0.6s] CLIFF SPLAT(20:33:01) | [5.9s] PROCEDURAL OBJECTS(20:33:02) | [1.0s] CLIFF TOPOLOGY(20:33:02) | [47.8s] Procedural Generation(20:33:03) | Loaded database server/mega-rust/UserPersistence.db (110 entries)(20:33:03) | QueryErrorException: Query Error: SELECT AgentId, Data FROM AgentData (no such table: AgentData)(20:33:03) | NullReferenceException: Object reference not set to an instance of an object(20:33:03) | NullReferenceException: Object reference not set to an instance of an object(20:33:03) | NullReferenceException: Object reference not set to an instance of an object

 

Just did an update, now this and server is stuck spamming this in console.

NullReferenceException: Object reference not set to an instance of an object
at ServerMgr.Update () [0x00000] in <filename unknown>:0

(Filename: Line: -1)

Server will not start up

EDIT: Fixed by deleting xp2.db

 

[0.5s] FIELD ROCKS
[0.3s] CLIFFS
[2.1s] MICRO CLIFFS
[7.1s] TERRAIN MESH
[1.5s] ROAD OBJECTS
[1.0s] CLIFF SPLAT
[6.8s] PROCEDURAL OBJECTS
[1.3s] CLIFF TOPOLOGY
[0.3s] CLUTTER TOPOLOGY
[60.5s] Procedural Generation
Loaded database server/ABSOLUTE/UserPersistence.db (0 entries)
QueryErrorException: Query Error: SELECT AgentId, Data FROM AgentData (no such t
able: AgentData)
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object

 

Did you fix this? I have this same error now. Server fully up to date.
[DOUBLEPOST=1468200627][/DOUBLEPOST]Found a fix. Delete xp2.db and server will restart as normal

 

I have game servers....After updating today, my server wouldn't start either. They told me that something was preventing it from starting (duh?) so they had to wipe my server. Needless to say, I am not happy. Oh well..... we deal with it and move on.

 

Delete the xp3.db file

 

Thx for the fix @redone , it's works now

 

Hi, Wolf

I have a same problem. Today i update my server and when i start it i see red text: NullReferenceException: Object reference not set to an instance of an object

I read file out_put.log: (Filename: C:/buildslave/unity/build/artifacts/generated/common/runtime/UnityEngineDebugBindings.gen.cpp Line: 37)
But my server live in disk D: not C:
I see disk C: 1468228586787 (281 kb) закачан 11 июля 2016 г. Joxi - it is no folder buildslave/

Can you help me?

 

i have the same all morning i cant even start server. So i removed oxide resinstalled server now it says. Server update required! updated server nothing helps!

 

I am getting the same issue after update oxide I dont know what else to do I've updated and updated and updated and still does nothing

 

But this wipe the XP of the players no? Cause that happend to me lol

 

It happend to me too. I did unload every plugin, when the server start, load them. I found that sometimes, plugins that handle OnEntitySpawn hook, cause this problem. Strange

 

I got it fixed I had to remove the xp2.db

 

My fix for don't lose the XP, i just remove the name of xp2.db to xp3.db and I don't lose anything, if you delete xp3.db, you wipe the XP players.. just change the name

 

I simply renamed xp3.db to xp3.db.old, xp2.db to xp3.db and and got levels restored. I'm vanilla though. Try this at your own risk, backup all previous!

Damn...._ero beat me to it. =P

 

So I updated some Mods the other day and realized I could also use an oxide update. I went into my control panel and did the update, restarted the server obviously and now i'm getting this mess....

Code:

[7/12/2016 6:32:07 AM] QueryErrorException: Query Error: SELECT AgentId, Data FROM AgentData (no such table: AgentData)
Facepunch.SQLite.QueryPrepare (System.String query)
Rust.Xp.Convert.FromVersion2 (System.String olddb, System.String newdb)
ServerMgr.Initialize (Boolean loadSave, System.String saveFile, Boolean allowOutOfDateSaves, Boolean skipInitialSpawn)
Bootstrap+<StartServer>c__IteratorF.MoveNext ()
UnityEngine.SetupCoroutine.InvokeMoveNext (IEnumerator enumerator, IntPtr returnValueAddress)
[7/12/2016 6:32:07 AM] NullReferenceException: Object reference not set to an instance of an object
ServerMgr.Update ()

I opened a ticket and they are saying this:

"Yes we are aware of issues from the latest Oxide branch. We've sent info over to the devs in hopes for a fix as we pull the mod data right from their site. This issue is directly related to Oxide and not how we install/set it up.

I'm a little confused because it seems like my server is one of the only ones that has went down completely due to an upgrade."

Anyone having any similar issues because it seems to me my host is failing, not oxide or rust...