Migration Issue to B5 or B5.1

Ainz Ooal Gown · December 6, 2018

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.

**jcsnider** · December 6, 2018

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.

Ainz Ooal Gown · December 6, 2018

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 December 6, 2018 by Ainz Ooal Gown
Update

**jcsnider** · December 6, 2018

Latest version of Mono?

Ainz Ooal Gown · December 6, 2018

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)

**jcsnider** · December 6, 2018

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)

Ainz Ooal Gown · December 6, 2018

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.

Ainz Ooal Gown · December 6, 2018

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.

**jcsnider** · December 6, 2018

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.

Ainz Ooal Gown · December 6, 2018

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

Ainz Ooal Gown · December 10, 2018

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

**jcsnider** · December 10, 2018

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.

Ainz Ooal Gown · December 10, 2018

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

Migration Issue to B5 or B5.1

Question

Link to comment

Share on other sites

12 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in