Jump to content
  • 0
Ainz Ooal Gown

Migration Issue to B5 or B5.1

Question

Hi,

 

Seem to be having an issue on my linux server with migration. I have updated to the latest version of mono but I'm getting an error (log dump also not working):

 

Starting migration, please wait! This might take several minutes....
Stacktrace:

  at <unknown> <0xffffffff>
  at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3/NativeMethods.sqlite3_open_v2 (byte[],intptr&,int,byte[]) [0x00014] in <94e90f2e2a1e4f8983b76383f64574ce>:0
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_open_v2 (string,intptr&,int,string) [0x0000f] in <94e90f2e2a1e4f8983b76383f64574ce>:0
  at SQLitePCL.raw.sqlite3_open_v2 (string,SQLitePCL.sqlite3&,int,string) [0x00000] in <724f9a22df504a05b4645fb690570b7a>:0
  at Microsoft.Data.Sqlite.SqliteConnection.Open () [0x000fb] in <56cfa09aae23467e945f1a64a1f893bb>:0
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection (bool) [0x00025] in <1b06b8e99d984506b89b3e4ae11831eb>:0
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open (bool) [0x0002a] in <1b06b8e99d984506b89b3e4ae11831eb>:0
  at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteRelationalConnection.Open (bool) [0x00000] in <6fac96ba37a44740bc51ba823588ec81>:0
  at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteDatabaseCreator.Exists () [0x0000c] in <6fac96ba37a44740bc51ba823588ec81>:0
  at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureDeleted () [0x00000] in <1b06b8e99d984506b89b3e4ae11831eb>:0
  at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureDeleted () [0x00006] in <905e41ddd9a149f0936da7d5ab99e38e>:0
  at Intersect.Migration.UpgradeInstructions.Upgrade_12.Upgrade12..ctor (System.Collections.Generic.Dictionary`2<Intersect.Migration.UpgradeInstructions.Upgrade_11.Intersect_Convert_Lib.Enums.GameObjectType, System.Collections.Generic.Dictionary`2<int, string>>,Intersect.Migration.UpgradeInstructions.Upgrade_11.Intersect_Convert_Lib.GameObjects.Maps.MapList.MapList,System.Collections.Generic.Dictionary`2<int, Intersect.Migration.UpgradeInstructions.Upgrade_11.User11>,System.Collections.Generic.Dictionary`2<int, Intersect.Migration.UpgradeInstructions.Upgrade_11.Character11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Ban11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Mute11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Friend11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.PSwitch11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.PVar11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Quest11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Spell11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Bag11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Inventory11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Bank11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.BagItem11>,System.Collections.Generic.List`1<Intersect.Migration.UpgradeInstructions.Upgrade_11.Hotbar11>) [0x004be] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.UpgradeInstructions.Upgrade_11.Upgrade11.Upgrade () [0x000b0] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.Database.Upgrade () [0x0023e] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.Migrator.Start (string[]) [0x0023d] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at (wrapper runtime-invoke) <Module>.runtime_invoke_void_object (object,intptr,intptr,intptr) [0x0004e] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at <unknown> <0xffffffff>
  at (wrapper managed-to-native) System.Reflection.MonoMethod.InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&) [0x0000c] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
  at System.Reflection.MonoMethod.Invoke (object,System.Reflection.BindingFlags,System.Reflection.Binder,object[],System.Globalization.CultureInfo) [0x0003b] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
  at System.Reflection.MethodBase.Invoke (object,object[]) <0x00013>
  at Intersect.Migration.MainClass.Main (string[]) [0x000be] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at (wrapper runtime-invoke) <Module>.runtime_invoke_void_object (object,intptr,intptr,intptr) [0x0004e] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
/proc/self/maps:
408a5000-408b5000 rwxp 00000000 00:00 0 
41091000-412e1000 rwxp 00000000 00:00 0 
560ea758e000-560ea79c5000 r-xp 00000000 08:01 25085                      /usr/bin/mono-sgen
560ea7bc4000-560ea7bcb000 r--p 00436000 08:01 25085                      /usr/bin/mono-sgen
560ea7bcb000-560ea7bd0000 rw-p 0043d000 08:01 25085                      /usr/bin/mono-sgen
560ea7bd0000-560ea7be7000 rw-p 00000000 00:00 0 
560ea8182000-560ea9d47000 rw-p 00000000 00:00 0                          [heap]
7fee1c000000-7fee1c021000 rw-p 00000000 00:00 0 
7fee1c021000-7fee20000000 ---p 00000000 00:00 0 
7fee24000000-7fee24071000 rw-p 00000000 00:00 0 
7fee24071000-7fee28000000 ---p 00000000 00:00 0 
7fee28000000-7fee2808f000 rw-p 00000000 00:00 0 
7fee2808f000-7fee2c000000 ---p 00000000 00:00 0 
7fee2c000000-7fee2c021000 rw-p 00000000 00:00 0 
7fee2c021000-7fee30000000 ---p 00000000 00:00 0 
7fee31a1a000-7fee31afa000 r-xp 00000000 08:01 530544                     /home/RecoStar/Server/libe_sqlite3.so
7fee31afa000-7fee31cfa000 ---p 000e0000 08:01 530544                     /home/RecoStar/Server/libe_sqlite3.so
7fee31cfa000-7fee31cfd000 r--p 000e0000 08:01 530544                     /home/RecoStar/Server/libe_sqlite3.so
7fee31cfd000-7fee31d00000 rw-p 000e3000 08:01 530544                     /home/RecoStar/Server/libe_sqlite3.so
7fee31d00000-7fee31e00000 rw-p 00000000 00:00 0 
7fee31f00000-7fee32000000 rw-p 00000000 00:00 0 
7fee320fc000-7fee320fd000 ---p 00000000 00:00 0 
7fee320fd000-7fee320fe000 rw-p 00000000 00:00 0 
7fee320fe000-7fee32106000 ---p 00000000 00:00 0 
7fee32106000-7fee322fd000 rw-p 00000000 00:00 0 
The Intersect Migration tool has encountered an error and must close. Error information can be found in resources/migration_errors.log. Press any key to exit.

Not sure what is causing this as no log dump is being generated "resources/migration_errors.log."

 

Im running my server in Ubuntu 18.04.1

 

Any ideas as its just stating the tool encountered an error and not really telling me anything. Thanks in advance.

Share this post


Link to post
Share on other sites

12 answers to this question

Recommended Posts

  • 0

I’m guessing one of two things...

 

One, it might be running into permission issues and needs to be ran  as root.

 

Or two, you might need to update the native SQLite packages. Sadly I cannot provide the commands you’d have to type, but once I’m at pc I can tell you what version is working on my server. 

Share this post


Link to post
Share on other sites
  • 0
19 minutes ago, jcsnider said:

I’m guessing one of two things...

 

One, it might be running into permission issues and needs to be ran  as root.

 

Or two, you might need to update the native SQLite packages. Sadly I cannot provide the commands you’d have to type, but once I’m at pc I can tell you what version is working on my server. 

Thanks JC,

 

I already tried running it in root with no joy. I will give updating SQLite and let you know how it goes.

 

*EDIT* SQLite seems to be on the latest version:

 

sqlite3 is already the newest version (3.22.0-1).


 

Edited by Ainz Ooal Gown
Update

Share this post


Link to post
Share on other sites
  • 0
5 minutes ago, jcsnider said:

Latest version of Mono?

Yeah latest version of mono, tried both the mono-complete and dev version:

 

Mono JIT compiler version 5.16.0.220 (tarball Mon Nov 26 17:17:59 UTC 2018)
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(3.6.0svn-mono-/)
    GC:            sgen (concurrent by default)
 

Share this post


Link to post
Share on other sites
  • 0

Is this running in a docker container by chance?  

 

Maybe try running it with the alpine argument

 

mono "Intersect Migration Tool.exe" alpine

 

(I'm grasping at straws)

Share this post


Link to post
Share on other sites
  • 0

No docker, just running in my own Azure Dedicated Server.

 

Tried alpine argument but didn't like it at all, and didn't write anything out:

Starting migration, please wait! This might take several minutes....
The Intersect Migration tool has encountered an error and must close. Error information can be found in resources/migration_errors.log. Press any key to exit.

I'm confused myself to why it wont work. I might try ripping the server out of linux and trying to migrate it on my windows machine then put it back if it works.

Share this post


Link to post
Share on other sites
  • 0

Found the log dump, forgot they dump in logs now and not resources sorry:

2019-12-06 13:52:47.643 [Error] Received unhandled exception from .
2018-12-06 13:52:47.644 [Error] Message: Object reference not set to an instance of an object
2018-12-06 13:52:47.645 [Error] Stack Trace:   at (wrapper managed-to-native) SQLitePCL.SQLite3Provider_e_sqlite3+NativeMethods.sqlite3_open_v2(byte[],intptr&,int,byte[])
  at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_open_v2 (System.String filename, System.IntPtr& db, System.Int32 flags, System.String vfs) [0x0000f] in <94e90f2e2a1e4f8983b76383f64574ce>:0
  at SQLitePCL.raw.sqlite3_open_v2 (System.String filename, SQLitePCL.sqlite3& db, System.Int32 flags, System.String vfs) [0x00000] in <724f9a22df504a05b4645fb690570b7a>:0
  at Microsoft.Data.Sqlite.SqliteConnection.Open () [0x000fb] in <56cfa09aae23467e945f1a64a1f893bb>:0
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection (System.Boolean errorsExpected) [0x00061] in <1b06b8e99d984506b89b3e4ae11831eb>:0
  at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open (System.Boolean errorsExpected) [0x0002a] 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.Storage.RelationalDatabaseCreator.EnsureDeleted () [0x00000] in <1b06b8e99d984506b89b3e4ae11831eb>:0
  at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureDeleted () [0x00006] in <905e41ddd9a149f0936da7d5ab99e38e>:0
  at Intersect.Migration.UpgradeInstructions.Upgrade_12.Upgrade12..ctor (System.Collections.Generic.Dictionary`2[TKey,TValue] up11objs, Intersect.Migration.UpgradeInstructions.Upgrade_11.Intersect_Convert_Lib.GameObjects.Maps.MapList.MapList mapList, System.Collections.Generic.Dictionary`2[TKey,TValue] oldUsers, System.Collections.Generic.Dictionary`2[TKey,TValue] oldCharacters, System.Collections.Generic.List`1[T] oldBans, System.Collections.Generic.List`1[T] oldMutes, System.Collections.Generic.List`1[T] oldFriends, System.Collections.Generic.List`1[T] oldSwitches, System.Collections.Generic.List`1[T] oldVariables, System.Collections.Generic.List`1[T] oldQuests, System.Collections.Generic.List`1[T] oldSpells, System.Collections.Generic.List`1[T] oldBags, System.Collections.Generic.List`1[T] oldItems, System.Collections.Generic.List`1[T] oldBanks, System.Collections.Generic.List`1[T] oldBagItems, System.Collections.Generic.List`1[T] oldHotbar) [0x004be] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.UpgradeInstructions.Upgrade_11.Upgrade11.Upgrade () [0x000b0] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.Database.Upgrade () [0x0023e] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at Intersect.Migration.Migrator.Start (System.String[] args) [0x0023d] in <30e2a3b9ce4b4d0ea6431d765715a392>:0
  at (wrapper managed-to-native) System.Reflection.MonoMethod.InternalInvoke(System.Reflection.MonoMethod,object,object[],System.Exception&)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x0003b] in <0f8aeac9d63d4b8aa575761bb4e65b79>:0
2018-12-06 13:52:47.645 [Error] Time: 12/6/2018 1:52:47 PM

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

This is running Migration tool as root.

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, Ainz Ooal Gown said:

I might try ripping the server out of linux and trying to migrate it on my windows machine then put it back if it works.

That's probably a good idea.

 

Another good thing to try would be running a clean server (without migrating) and see if it's going to have the same problem.

Share this post


Link to post
Share on other sites
  • 0
Just now, jcsnider said:

That's probably a good idea.

 

Another good thing to try would be running a clean server (without migrating) and see if it's going to have the same problem.

Yeah I will give this a try when I get in from work. Thanks again buddy :)

Share this post


Link to post
Share on other sites
  • 0

Just an update on this:

  • Ran a clean 5.1 server on my Linux box and it worked fine.
  • Tried to do a migration again but it failed.
  • Couldn't get files off my Linux box to my windows PC to try a migration on windows (going upload files to my site tonight and try again)

So I will try a migration on my windows machine tonight, then will know if its an issue with migration on Linux or my game files that are having the issue. Push come to shove I will do a manual move to new version as core content will be easy enough, just maps (done over 100) will be a bother, but means I can correct and change stuff to new ideas as I go :P

Share this post


Link to post
Share on other sites
  • 0
51 minutes ago, jcsnider said:

Weird, but that's promising. If you need help with the upgrade and can get the files to an accessible feel free to PM me and ill do the migration if you don't want to bother with Windows.

Thanks JC Ill keep that in mind :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×