| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007807 | opensim | [GRID] Hypergrid | public | 2016-01-12 20:37 | 2019-04-18 05:25 |
|
| Reporter | TomTheDragon | |
| Assigned To | | |
| Priority | normal | Severity | major | Reproducibility | random |
| Status | patch included | Resolution | open | |
| Platform | | OS | | OS Version | |
| Product Version | master (dev code) | |
| Target Version | | Fixed in Version | | |
|
| Summary | 0007807: Hypergrid asset issues in PGSQL |
| Description | Occasionally, when one is traveling in the Hypergrid and their home grid uses PGSQL, assets will fail to get stored. When you go to pull the item out of your inventory. I've attached a patch which aligns the creatorid on the assets table with the other database backends. I haven't had a chance to heavily test it, though there do not seem to be any regressions. |
| Steps To Reproduce | Travel around as an HG visitor in OSGrid for a while. This doesn't seem to be entirely reproducible but it does occur. |
| Tags | No tags attached. |
|
| Git Revision or version number | |
| Run Mode | Grid (Multiple Regions per Sim) |
| Physics Engine | BulletSim |
| Script Engine | |
| Environment | Mono / Linux64 |
| Mono Version | Other |
| Viewer | Singularity Viewer 1.8.6 |
|
| Attached Files |  0003-Increase-size-of-creatorid-in-assets.patch [^] (833 bytes) 2016-01-12 20:37 [Show Content] [Hide Content]From 5f122b578cb60e65134894b724e1c34e6bfa5e00 Mon Sep 17 00:00:00 2001
From: TomDataworks <muckwaddle@gmail.com>
Date: Tue, 12 Jan 2016 22:48:25 -0500
Subject: [PATCH 3/6] Increase size of creatorid in assets.
---
OpenSim/Data/PGSQL/Resources/AssetStore.migrations | 8 ++++++++
1 file changed, 8 insertions(+)
diff --git a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
index 7a858b4..783fef3 100644
--- a/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/AssetStore.migrations
@@ -97,3 +97,11 @@ alter table assets add "creatorid" varchar(36) not null default '';
BEGIN TRANSACTION;
COMMIT;
+
+:VERSION 9
+
+BEGIN TRANSACTION;
+
+ALTER TABLE assets ALTER COLUMN "creatorid" TYPE character varying(128);
+
+COMMIT;
--
1.7.10.4
|
|
Relationships 
Relationships 