Commit Graph

45 Commits (master)

Author SHA1 Message Date
Melanie Thielker b16abc8166 Massive tab and trailing space cleanup 2017-01-05 19:07:37 +00:00
Jeff Ames bc9f793a92 Formatting cleanup. 2010-10-04 21:28:17 -04:00
Justin Clark-Casey (justincc) a22f007246 Improve the explanative text of migration failures
When running for the first time, people see migration failures because of sql statements that are trying to move data from old tables (e.g. users).  The amended text attempts to calm their nerves.
2010-09-18 03:37:10 +01:00
Jeff Ames f1f0bc23f4 Formatting cleanup. 2010-09-12 13:43:49 -04:00
Justin Clark-Casey (justincc) 3b26baf282 Even if all data migratios are up to date, still print the current revision to the log 2010-08-09 22:54:13 +01:00
Justin Clark-Casey (justincc) d399bd3eb7 minor: fix spelling mistake interupt -> interrupt in migrations
This is for  mantis 4783
2010-06-25 21:18:52 +01:00
AlexRa 527a257b9f Kind of fixed Melanie's "Exception(sql)" correction
Throwing an Ex. with SQL command in the message looks weird,
this is a bit better, but I'm still not sure if that's the
proper way to handle.  Also, there is a catch one level up,
so is this one necessary?
2010-05-19 21:49:18 +03:00
Melanie e4b8d76b10 Change appender to deal with line feeds more intelligently.
Change migration error reporting to not truncate the statement when
reporting. It's a bit messier than the old error reporting, but at least
one gets an idea of what could be wrong again. And things look a lot
neater now.
2010-05-19 04:17:56 +01:00
Melanie 0c209a469b Clean up output a bit 2010-05-19 03:48:03 +01:00
Melanie 20642f2f21 Fix the migration message to say "Continuing" again. Remove line feed, which
prevented the full message from displaying.
2010-05-19 03:26:37 +01:00
Melanie 9fa8013ca5 Remove the return that was inserted in the last merge to allow
migrations to continue in the face of an error
2010-05-19 03:07:31 +01:00
Melanie d2bc673667 Make m_log in migrations private. Define new m_log in derived class 2010-05-18 23:33:05 +01:00
AlexRa 8b6a295874 Migration.cs supports single-file migration history format
Scans for migration resources in either old-style "scattered" (one file per version)
or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections).
In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script
that must be sent to the server separately.  The old-style migrations are loaded each in one piece
and don't support the ':GO' feature.

Status:  TESTED and works fine in all modes!
2010-05-16 16:22:38 +03:00
AlexRa be1141f0f7 Refactoring in Migration.cs: "using()" instead of explicit Dispose()
This ensures that 'cmd' gets disposed on errors
2010-04-28 13:40:35 +03:00
AlexRa b49e9eff56 Fixed comments in Migration.cs: wrong argument order (no change to code) 2010-04-28 13:11:42 +03:00
Justin Clark-Casey (justincc) 1b488c2581 dispose of the DbCommand used to execute migrations after we've finished with it rather than within the loop
disposing of it within the loop causes Mono.Data.Sqlite.dll to get upset, and it's the wrong behaviour anyway
2010-04-23 20:08:24 +01:00
Melanie ebcc9874d4 Insert a ROLLBACK command on migration step failure. This ensures that
updating the Migrations table will not occur in a partial transaction, which
would be auto-rolled-back later.
2010-04-22 17:45:03 +01:00
Diva Canto 4240f2dec6 New LL login service is working! -- tested in standalone only. Things still missing from response, namely Library and Friends. Appearance service is also missing. 2010-01-01 16:54:24 -08:00
Melanie 5b69f58aae Make Migratons continue int he face of an error. This is required for the
friends migration, which MAY error out if the old friends table is not
in the same database as the new one being created. This error is nonfatal,
it would only mean that friends will not be migrated automatically. It would
bite people with nonstandard configurations.
2009-12-28 18:59:38 +00:00
John Hurliman 6309fcc5b4 Reverting the memory leak patch for MySQL. Problems have been reported with the grid server after running for several hours 2009-11-02 11:19:55 -08:00
John Hurliman 29a4614529 * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset Local member in MySQLAssetData
* First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-10-04 13:57:51 -07:00
Jeff Ames 840de6c036 Minor: Change OpenSim to OpenSimulator in older copyright headers and LICENSE.txt. 2009-06-01 06:37:14 +00:00
lbsa71 801da4346a * optimized usings. 2009-02-12 09:53:12 +00:00
idb 7e65697142 Reinstate setting timeout to never, the default 30 second timeout was causing problems with big migrations 2008-12-08 18:55:19 +00:00
Justin Clarke Casey dde32f1130 * Reapply http://opensimulator.org/mantis/view.php?id=2710
* This patch gets NHibernate working
*** PLEASE NOTE: This patch now requires the libmono-oracle2.0-cil library to be installed on Ubuntu (to stop the System.Data.Oracle missing failure) ***
* Not sure what the dependency is on other distros.  Adding this info to http://opensimulator.org/wiki/Build_Instructions would be most welcome
* Adds Castle.* libraries that were missing last time (note, dlls have been added from http://downloads.sourceforge.net/nhibernate/NHibernate-2.0.1.GA-bin.zip)
2008-12-02 15:22:58 +00:00
Justin Clarke Casey 80520206fc * Unforunately it turns out not to be that simple. Revert the rest of r7560 for now. 2008-12-01 18:42:14 +00:00
Adam Frisby 4ed7ca62b1 * From Mantis#2701 - Implements NHibernate data adapter, adds support for MsSql2005 to NHibernate.
* Patch courtesy of Adminotech and realXtend. Thanks!
2008-12-01 07:50:38 +00:00
Sean Dague 6a691df1a6 remove some extraneous debug messages from migrations 2008-09-20 12:44:39 +00:00
Justin Clarke Casey 1edee634ca * minor: spelling mistake and message tidying on Migration messages 2008-09-12 21:24:11 +00:00
Melanie Thielker b6bb5f944f Mantis #2095
Thank you, RuudL, for a complete adaptation of migration and estate
data to MSSQL, and the updating of the RegionData handling in MSSQL.
2008-09-01 17:10:01 +00:00
Jeff Ames 6ef9d4da90 Formatting cleanup. 2008-08-18 00:39:10 +00:00
Dr Scofield feb30217de dr scofield's warning safari:
* commented out [Obsolete(....)] attributes where no replacement feature
  was available: if we want to attribute code that we think needs to be 
  reworked, we should define a new attribute and use that instead 
  (together with a little tool to retrieve all the attributed code then)
* commenting out unused variables
2008-06-27 16:58:21 +00:00
Sean Dague bdb0dddfcf set CommandTimeout = 0 in the migration commands so that long
migrations (like converting asset ids) don't run into the 
normal 30 second kill switch.
2008-06-16 19:39:08 +00:00
Sean Dague e1409e0c04 be a bit more verbose about what we are doing on the migration
side so that people don't think we're hung.
2008-06-16 19:33:08 +00:00
Sean Dague 340ef33e2e fix nhibernate driver so that it starts (based on the appearance
changes it wouldn't come up).
include embedded dialect specific sql files for nhibernate migrations
figure out how to get the raw db connection so that migrations can
work with nhibernate.
create initial migration for NHibernate + SQLite + Assets.
2008-06-16 19:22:00 +00:00
Sean Dague 94034d665d change some messages on the migrations front to be
more clear
2008-06-16 16:03:37 +00:00
Sean Dague ec78a2871b the beginning of the great id format migration. This makes
asset uuids no longer binary.  I've tested this migration a
few times, and it seems working in all the scenarios I've found
but it wouldn't hurt to backup your asset db before running this
as it does touch a very sensitive part of our content system.
2008-06-16 14:10:51 +00:00
Jeff Ames 64f01ade04 Update svn properties, clean up formatting, refactor out duplicate hard-coded port numbers. 2008-06-13 00:21:53 +00:00
Sean Dague 6c1fce6147 check in working migration code fore SQLite. This
is now using migrations instead of the old model to
create tables.  Tested for existing old tables, 
and for creating new ones.
2008-06-11 21:01:33 +00:00
Sean Dague be400d1bd0 I'm going to need the Version property to manage
migrating from the old to the new system.  Silly legacy
code.
2008-06-10 23:17:18 +00:00
Sean Dague 68cda63761 update of migration code to be more sane on version
tracking, and support sub types that we'll need for
nhibernate.
2008-06-10 22:57:20 +00:00
Jeff Ames 5910a49da6 Update svn properties. Formatting cleanup. 2008-06-10 08:35:46 +00:00
Sean Dague c62f081380 actually create and populate the migrations table correctly. 2008-06-09 22:20:28 +00:00
Sean Dague 69fb4ee208 migrations seem to not break anything at this point.
Tomorrow I'll start trying to integrate them into sqlite
to see if this works right for table migration.
2008-06-09 22:01:21 +00:00
Sean Dague 504ab4477d move Migration support into OpenSim.Data, because it
really turned out to be small enough to not need it's own
assembly
2008-06-09 21:40:16 +00:00