aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-02-12Fix http://opensimulator.org/mantis/view.php?id=4224Justin Clark-Casey (justincc)1-5/+0
This resolves the problem where eyes and hair would turn white on standalone configurations When a client receives body part information, for some insane reason or other it always ends up uploading this back to the server and then immediately re-requesting it. This should have been okay since we stored that asset in cache. However, the standalone asset service connector was not checking this cache properly, so every time the client made the request for the asset it has just loaded it would get a big fat null back in the face, causing it to make clothes and hair white. This bug did not affect grids since they use a different service connector.
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim15-2629/+2230
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2010-02-05Fixing an incorrect logging message in insertUserRowOpenSim Master1-1/+1
2010-02-05* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
2010-02-06Fixing an incorrect logging message in insertUserRowOpenSim Master1-1/+1
2010-02-06* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
2010-01-04Finish conversion if XInventoryServiceMelanie1-6/+49
2010-01-04First stage port of the XInventoryServiceMelanie2-0/+118
2010-01-04Formatting cleanup. Add copyright headers.Jeff Ames1-3/+3
2010-01-01Prevent the creation of duplicate inventory folders in the case of a loginMelanie1-1/+1
database issue. Now the login will instaead fail later.
2009-12-26Correct some issues with the last commitroot1-1/+2
2009-12-26Close a SQL injection loophole in the new database driverMelanie1-2/+3
2009-12-26Make the GenericTableHandler work as intendedroot1-2/+8
2009-12-26Add a generic REPLACE INTO handler for put into the generic table handlerMelanie1-0/+25
2009-12-13* Implements OSSL function: osGetSimulatorMemory - returns the current ↵Adam Frisby1-0/+3
amount of memory allocated to the simulator process (Moderate Threat Level). * Cleans redundant information out of the Simulator Version. Versions now look like: "OpenSimulator 0.6.9(dev) Unix/Mono" * [Minor] additional log info for MySQLInventoryData
2009-12-11Refix the fixMelanie1-1/+1
2009-12-11Kill a NRE caused by an error message trying to print unavailable datagrid1-2/+2
2009-12-02Log old position and region information when an orphaned child prim is foundJustin Clark-Casey (justincc)1-1/+3
2009-11-23* Implements SQL Rollback support to Inventory Service for quicker backup ↵Adam Frisby1-0/+154
restoration. * Can optionally replace the OpenGridMode committed earlier. * Will create a series of incrementing restore SQL files, one per user, in folders listed per-day. * For MySql Section of InventoryService INI: rollback = "true" rollbackdir = "/absolute/path/to/rollback/storage/dir"
2009-11-23* Adds a modicum of additional checking to the Inventory Service (MySQL only)Adam Frisby1-5/+22
* Enable "opengridmode=true" in your Inventory Connector (where the mysql connection strings are) to enable if you are running a 'wide-open-grid'. * More comprehensive rollback support being implemented, should be available later today.
2009-11-23Formatting cleanup.Jeff Ames1-2/+2
2009-11-18Implement generic delete methodMelanie1-1/+14
2009-11-18Tweak presence handling and whip up a database connector and handlerMelanie1-1/+3
for testign the new generic table handling
2009-11-15Committing the incomplete table handler to get it into the tree. No userMelanie1-0/+200
functionality yet
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-02Removing Console.WriteLine()s that were brought in with the revertJohn Hurliman1-2/+0
2009-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman10-834/+860
the grid server after running for several hours
2009-10-27* Tweak to region module loading to check for a matching constructor first ↵John Hurliman1-14/+18
instead of throwing and catching exceptions * Commenting out the MySQL startup sequence that cleans out dropped attachments under the advice that it is no longer relevant. If anything, it could be brought back as a database cleanup console command * Updated to the latest libomv 0.8.0-pre. UUID.TryParse() will no longer throw and catch exceptions for most failed UUID parses
2009-10-25Changing Scene.ForEachClient to use the synchronous for loop instead of ↵John Hurliman2-30/+26
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-18* Big performance increase in loading prims from the region database with MySQLJohn Hurliman1-133/+138
* Handle the AgentFOV packet * Bypass queuing and throttles for ping checks to make ping times more closely match network latency * Only track reliable bytes in LLUDPCLient.BytesSinceLastACK
2009-10-16* Changing the "clean dropped attachments" MySQL command to a using ↵John Hurliman1-6/+14
statement inside a try/catch. This statement times out for me very frequently * More verbose logging when zerocoding fails on an outbound packet
2009-10-16* Change appearance packets from State to Task. This will hopefully fix the ↵John Hurliman1-0/+5
cloud issues * Changed the throttling logic to obey the requested client bandwidth limit but also share bandwidth between some of the categories to improve throughput on high prim or heavily trafficked regions
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-12Stop null values from being returned on database queriesMelanie1-1/+4
2009-10-06Reverting MySQLLegacyRegionData spamJohn Hurliman1-6/+0
2009-10-06MySQLLegacyRegionData: Extreme Spam Edition(tm)John Hurliman1-0/+6
2009-10-06Remove the using() constructs from the new style database modules; they causedMelanie4-75/+77
the underlying connection of a reader or command to be closed before the reader or command itself. Added the proper logic to Close and dispose items in CloseDBConnection. Readers and Connections need Close(), Commands need Dispose(), in the order Reader, Command, Connection. Also reinstated 80-column-friendly formatting
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-05Added CloseDBConnection() to replace the old CloseReaderCommand(). This will ↵John Hurliman4-11/+21
close the MySQLConnection attached to a MySQLCommand. I'm not sure if this accounts for every time a database connection needs to be closed, but it matches up 1:1 with the places where the database connection was previously being closed
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman11-1213/+1111
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-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-3/+3
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames4-11/+11
2009-09-29Add copyright header. Formatting cleanup.Jeff Ames3-3/+3
2009-09-27Make the RegionData plugin store the RegionNameMelanie1-2/+3
2009-09-27Prevent manually setting Data["locX"] and Data["locY"], since that wouldMelanie1-0/+4
overwrite the posX and posY members of the structure
2009-09-27Add the Migration for the regions tableMelanie2-8/+20
2009-09-25minor: remove some mono compiler warningsJustin Clark-Casey (justincc)2-2/+2
2009-09-24All tests pass for MySQL/MySQLRegionData.Diva Canto1-12/+3
Added OpenSim.GridServer.ini.example that I have been using for testing the ROBUST grid service with the GridClient.
2009-09-16Add the migration for scoping grid dataMelanie1-0/+7