aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLAssetData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-02-22Changed asset CreatorID to a stringJohn Hurliman1-1/+1
2010-02-22* Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman1-1/+1
CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim1-197/+158
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2009-11-05Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman1-4/+1
unknown asset type, and log an error if it ever does happen
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-47/+55
the grid server after running for several hours
2009-10-25Changing Scene.ForEachClient to use the synchronous for loop instead of ↵John Hurliman1-3/+0
Parallel. This is quite possibly the source of some deadlocking, and at the very least the synchronous version gives better stack traces * Lock the LLUDPClient RTO math * Add a helper function for backing off the RTO, and follow the optional advice in RFC 2988 to clear existing SRTT and RTTVAR values during a backoff * Removing the unused PrimitiveBaseShape.SculptImage parameter * Improved performance of SceneObjectPart instantiation * ZeroMesher now drops SculptData bytes like Meshmerizer, to allow the texture data to be GCed * Improved typecasting speed in MySQLLegacyRegionData.BuildShape() * Improved the instantiation of PrimitiveBaseShape
2009-10-14* Replaced (possibly broken?) math for calculating the unix timestamp in ↵John Hurliman1-5/+5
MySQLAssetData with Utils.DateTimeToUnixTime() * Disabled UpdateAccessTime() function since it was only writing zeros anyways. This gave me a significant performance improvement for startup times and avatar logins in standalone mode * Load attachments asynchronously so avatars with lots of attachments don't have to race the timeout clock to login
2009-10-06* Continued work on the new LLUDP implementation. Appears to be functioning, ↵John Hurliman1-4/+2
although not everything is reimplemented yet * Replaced logic in ThreadTracker with a call to System.Diagnostics that does the same thing * Added Util.StringToBytes256() and Util.StringToBytes1024() to clamp output at byte[256] and byte[1024], respectively * Fixed formatting for a MySQLAssetData error logging line
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-54/+48
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-01Formatting cleanup.Jeff Ames1-1/+1
2009-08-21Fix issue where conversion of temporary boolean variable fails on MySQLArthur Valadares1-2/+2
2009-08-19* Switching IAssetData to follow the new naming schema, removing the ↵Kunnis1-11/+2
separate insert and update methods.
2009-08-16* Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis1-8/+1
parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
2009-08-16Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis1-0/+1
2009-07-24* Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey1-2/+16
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-04-13* Some more experimental work on distributed assets. Nothing hotwired yet.lbsa711-17/+19
* Introduced preprocess step in FetchAsset (Might revert this later) * Some minor CCC * Added actual implementation of GetUserProfile( uri ) and the corresponding handler to OGS1. * Introduced non-functioning GetUserUri( userProfile) awaiting user server wireup (this might move elsewhere)
2009-04-09* Improve inventory uuid conversions to make sure that we aren't converting ↵Justin Clarke Casey1-1/+1
anything that already contains a - * Among other things, this means that if a migration is interrupted, it can simply be retried
2009-03-09Implemented FetchAssetMetadataSet in DB backends.Mike Mazur1-0/+51
This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-17/+17
properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
2009-02-12* optimized usings.lbsa711-7/+5
2009-02-04- add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur1-17/+17
- trim trailing whitespace
2009-02-03Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur1-1/+1
plugins.
2009-01-28Slight cleanup of docs, removing trailing whitespace.Mike Mazur1-6/+5
2009-01-18Avoid an invalid cast on legacy dataMelanie Thielker1-1/+8
2008-12-22Update the MySQL connector to 5.2.5. Fixes Mantids#2673. Thanks for the ↵Homer Horwitz1-1/+1
hint, jhurliman.
2008-11-06add create_time and access_time to asset db for mysql, as wellSean Dague1-2/+46
as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
2008-09-24let the asset tests run on MySQL. Interesting difference here, theSean Dague1-1/+1
sqlite driver can handle .Data = Null, the mysql driver can not. We should decide which is the right behavior and adjust code for it.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-3/+3
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-08-27remove the legacy pre-Migration database upgrade pathsSean Dague1-42/+0
2008-08-18Formatting cleanup.Jeff Ames1-4/+4
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-1/+1
PluginLoader. Fix issue 1871.
2008-07-18Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur1-0/+1
(issue 1763).
2008-07-07* remove unused CommitAssets() hook for nowJustin Clarke Casey1-7/+0
2008-07-03Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke1-0/+6
patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-5/+3
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-06-29* Fix for http://opensimulator.org/mantis/view.php?id=1512Justin Clarke Casey1-1/+1
* Introduce experimental wait timeout checking to mysql region datastore code * This should mean that if the mysql connection has timed out, we should automatically reconnect and not fail or drop queries on region database manipulations
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-10/+10
2008-06-27Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke1-1/+3
Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
2008-06-26Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames1-19/+42
kerunix_Flan!
2008-06-26Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames1-1/+36
files. Thanks kerunix_Flan!
2008-06-16the beginning of the great id format migration. This makesSean Dague1-6/+4
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-12this, in theory, adds migration support to mysql for all Sean Dague1-34/+50
data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
2008-06-04Formatting cleanup, minor refactoring, svn properties.Jeff Ames1-5/+5
2008-05-31* Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey1-0/+1
exists would be better than carrying on
2008-05-31* Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey1-2/+2
2008-05-31* Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey1-1/+40
into the database
2008-05-16Formatting cleanup.Jeff Ames1-5/+5
2008-05-14More formatting cleanup.Jeff Ames1-2/+5
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey1-3/+3
settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code