"table 'migrations' already exists"

[Remy Cucui]

Hi!

I'm trying to get Tundra-0.2.0 working for a project at school. We've got a MySQL database set up, and OpenSim.Grid.UserServer, OpenSim.Server.exe, and OpenSim.Grid.Messaging.Server.

exe, all start with no problem.

OpenSim.32BitLaunch.exe however keeps terminating when it connects to the database we're using. Our output reads:

:~/Desktop/rxttest/Taiga-0.2.0/opensim$ mono OpenSim.32BitLaunch.exe
log4net:ERROR XmlHierarchyConfigurator: No appender named [NHibernateFileLog] could be found.
log4net:ERROR XmlHierarchyConfigurator: Appender named [NHibernateFileLog] not found.
32-bit OpenSim executor
-----------------------

This application is compiled for 32-bit CPU and will run under WOW32 or similar.
All 64-bit incompatibilities should be gone.

log4net:ERROR XmlHierarchyConfigurator: No appender named [NHibernateFileLog] could be found.
log4net:ERROR XmlHierarchyConfigurator: Appender named [NHibernateFileLog] not found.
15:44:14 - [OPENSIM MAIN]: configured log4net using default OpenSim.exe.config
15:44:14 - [OPENSIM MAIN]: Runtime gave us 200 worker threads and 8 IOCP threads
15:44:14 - [OPENSIM MAIN]: Bumping up to 500 worker threads and 1000 IOCP threads
15:44:14 - Performing compatibility checks...
15:44:14 - Environment is compatible.

15:44:14 - [CONFIG]: Reading configuration settings
15:44:14 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/OpenSim.ini
15:44:14 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/addon-modules/ModreX/config/modrex.ini
15:44:14 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/addon-modules/MumbleVoice/config/mumblevoice.ini
15:44:14 - [LOGGING]: Logging started to file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/OpenSim.32BitLaunch.log
15:44:14 - [OPENSIM MAIN]: Using async_call_method SmartThreadPool
15:44:14 - [STARTUP]: Beginning startup processing
15:44:14 - [STARTUP]: Version: OpenSim 0.6.9 (RC1)             

15:44:14 - ====================================================================
15:44:14 - ========================= STARTING OPENSIM =========================
15:44:14 - ====================================================================
15:44:14 - [OPENSIM MAIN]: Running in grid mode
15:44:14 - [DATASTORE]: Attempting to load OpenSim.Data.MySQL.dll
15:44:14 - [REGION DB]: MySql - connecting: Data Source=localhost;Database=OpenSim2;User ID=opensim;Password=***;
OpenSim threw an exception:
MySql.Data.MySqlClient.MySqlException: Table 'migrations' already exists
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000] in <filename unknown>:0

Application will now terminate!

We've tried deleting the table migrations before starting OpenSim, and all it does is add the table back in and give us this output:

:~/Desktop/rxttest/Taiga-0.2.0/opensim$ mono OpenSim.32BitLaunch.exe
log4net:ERROR XmlHierarchyConfigurator: No appender named [NHibernateFileLog] could be found.
log4net:ERROR XmlHierarchyConfigurator: Appender named [NHibernateFileLog] not found.
32-bit OpenSim executor
-----------------------

This application is compiled for 32-bit CPU and will run under WOW32 or similar.
All 64-bit incompatibilities should be gone.

log4net:ERROR XmlHierarchyConfigurator: No appender named [NHibernateFileLog] could be found.
log4net:ERROR XmlHierarchyConfigurator: Appender named [NHibernateFileLog] not found.
15:52:02 - [OPENSIM MAIN]: configured log4net using default OpenSim.exe.config
15:52:02 - [OPENSIM MAIN]: Runtime gave us 200 worker threads and 8 IOCP threads
15:52:02 - [OPENSIM MAIN]: Bumping up to 500 worker threads and 1000 IOCP threads
15:52:02 - Performing compatibility checks...
15:52:02 - Environment is compatible.

15:52:02 - [CONFIG]: Reading configuration settings
15:52:02 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/OpenSim.ini
15:52:02 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/addon-modules/ModreX/config/modrex.ini
15:52:02 - [CONFIG]: Reading configuration file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/addon-modules/MumbleVoice/config/mumblevoice.ini
15:52:02 - [LOGGING]: Logging started to file /home/administrator/Desktop/rxttest/Taiga-0.2.0/opensim/OpenSim.32BitLaunch.log
15:52:03 - [OPENSIM MAIN]: Using async_call_method SmartThreadPool
15:52:03 - [STARTUP]: Beginning startup processing
15:52:03 - [STARTUP]: Version: OpenSim 0.6.9 (RC1)             

15:52:03 - ====================================================================
15:52:03 - ========================= STARTING OPENSIM =========================
15:52:03 - ====================================================================
15:52:03 - [OPENSIM MAIN]: Running in grid mode
15:52:03 - [DATASTORE]: Attempting to load OpenSim.Data.MySQL.dll
15:52:03 - [REGION DB]: MySql - connecting: Data Source=localhost;Database=OpenSim2;User ID=opensim;Password=***;
15:52:03 - [MIGRATIONS]: Creating migrations at version 1
15:52:03 - [MIGRATIONS]: EstateStore up to date, no migrations to apply
OpenSim threw an exception:
MySql.Data.MySqlClient.MySqlException: Table 'migrations' already exists
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000] in <filename unknown>:0

Application will now terminate!

Please help, thank you!

[Ali Kämäräinen]

Hi,

Please notice that that you're using the Taiga software, not Tundra. Taiga has been deprecated and dead for couple years already - I doubt that anyone one can help on this matter.

Grey skies,

Ali Kämäräinen

[Jonne Nauha]

Yeah, I probably worked the most on Taiga (from people still actively lurking here) and I have no idea whats going on there.

You might have better luck with OpenSim people as that database error is coming from opensim. In fact if you are looking for opensim based server, I suggest you head to http://opensimulator.org and get the latest server from there. The opensim bundled with Taiga is about 2 years old so not exactly the latest tech out there :)

If you wanna check out realXtend Tundra based stuff head over to https://code.google.com/p/realxtend-naali/downloads/list for the rex distributions. Or check out Meshmoon http://meshmoon.com/ and docs http://doc.meshmoon.com/documentation.html

We'll be happy to answer any Tundra related questions as that is what we are working on currently!

Best regards,
Jonne Nauha
Meshmoon developer at Adminotech Ltd.

www.meshmoon.com

--
--
http://groups.google.com/group/realxtend-dev
http://wiki.realxtend.org
http://dev.realxtend.org
---
You received this message because you are subscribed to the Google Groups "realXtend-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to realxtend-de...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.