Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007151opensim[GRID] Grid Servicepublic2014-05-05 20:162014-11-27 22:50
ReporterEliopodB 
Assigned To 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0007151: Groups V2 does not show my groups in Firestorm using release 0.7.6.1
DescriptionI created a new grid with one Region with a fresh database called Dahlia
Started Robust and created user Eliopod Beaumont
the os_groups_xxx tables were created

Started Opensim for one Region called Dahlia
made Eliopod Beaumont the Estate Manager

Logged Eliopod into Region Dahlia, no errors so far
opened conversations and the group tag,
Entered Admirers for group name and Everyone here for description,everyone can join, ratings moderate and hit enter, got an error , new group did not diaplay but was created correctly in database.

last entry in log:
2014-05-05 22:50:46,090 DEBUG - OpenSim.Groups.GroupsServiceLocalConnectorModule [Groups]: Creating group Admirers
2014-05-05 22:50:46,121 ERROR - OpenSim.Region.ClientStack.LindenUDP.LLClientView [LLCLIENTVIEW]: Caught exception while processing OpenMetaverse.Packets.CreateGroupRequestPacket for Eliopod Beaumont, Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). at System.Guid..ctor(String g)
   at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
   at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
   at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms)
   at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlDataReader.Read()
   at OpenSim.Data.MySQL.MySQLGenericTableHandler`1.DoQuery(MySqlCommand cmd) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Data\MySQL\MySQLGenericTableHandler.cs:line 154
   at OpenSim.Data.MySQL.MySQLGenericTableHandler`1.Get(String[] fields, String[] keys) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Data\MySQL\MySQLGenericTableHandler.cs:line 134
   at OpenSim.Data.MySQL.MySQLGroupsData.RetrieveMember(UUID groupID, String pricipalID) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Data\MySQL\MySQLGroupsData.cs:line 116
   at OpenSim.Groups.GroupsService._AddAgentToGroupRole(String RequestingAgentID, String AgentID, UUID GroupID, UUID RoleID) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\Service\GroupsService.cs:line 845
   at OpenSim.Groups.GroupsService._AddAgentToGroup(String RequestingAgentID, String AgentID, UUID GroupID, UUID RoleID, String accessToken) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\Service\GroupsService.cs:line 783
   at OpenSim.Groups.GroupsService._AddAgentToGroup(String RequestingAgentID, String AgentID, UUID GroupID, UUID RoleID) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\Service\GroupsService.cs:line 742
   at OpenSim.Groups.GroupsService.CreateGroup(String RequestingAgentID, String name, String charter, Boolean showInList, UUID insigniaID, Int32 membershipFee, Boolean openEnrollment, Boolean allowPublish, Boolean maturePublish, UUID founderID, String& reason) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\Service\GroupsService.cs:line 166
   at OpenSim.Groups.GroupsServiceLocalConnectorModule.CreateGroup(UUID RequestingAgentID, String name, String charter, Boolean showInList, UUID insigniaID, Int32 membershipFee, Boolean openEnrollment, Boolean allowPublish, Boolean maturePublish, UUID founderID, String& reason) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\Local\GroupsServiceLocalConnectorModule.cs:line 153
   at OpenSim.Groups.GroupsModule.CreateGroup(IClientAPI remoteClient, String name, String charter, Boolean showInList, UUID insigniaID, Int32 membershipFee, Boolean openEnrollment, Boolean allowPublish, Boolean maturePublish) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Addons\Groups\GroupsModule.cs:line 774
   at OpenSim.Region.ClientStack.LindenUDP.LLClientView.HandleCreateGroupRequest(IClientAPI sender, Packet Pack) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Region\ClientStack\Linden\UDP\LLClientView.cs:line 10904
   at OpenSim.Region.ClientStack.LindenUDP.LLClientView.ProcessSpecificPacketAsync(Object state) in C:\cygwin\home\caseyj\ljc\opensim-0.7.6.1-source\OpenSim\Region\ClientStack\Linden\UDP\LLClientView.cs:line 736

 


Additional InformationThis Report replaces my previous 0007139
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (1 Region per Sim)
Physics EngineBulletSim
EnvironmentMono / Windows
Mono VersionNone
ViewerFirestorm x64
Attached Files? file icon Robust.ini [^] (19,064 bytes) 2014-05-05 20:16
? file icon OpenSim.ini [^] (51,512 bytes) 2014-05-06 08:51
log file icon Robust.log [^] (34,149 bytes) 2014-05-10 21:39

- Relationships
related to 0007139new Groups V2 doesn't show groups 

-  Notes
(0026030)
EliopodB (reporter)
2014-05-10 21:40

Repeated test with 0.8-rc1

uploaded complete Robust.log
(0026035)
hack13 (reporter)
2014-05-11 22:09

I had this issue before, here is how to fix it. Find and set this:

    ;# {MessageOnlineUsersOnly} {Module:GroupsModule Module} {Message online users only?} {true false} false
    ; Experimental option to only message online users rather than all users
    ; Should make large groups with few online members messaging faster, as the expense of more calls to presence service
    ; Applies Flotsam Group only. V2 has this always on, no other option
    MessageOnlineUsersOnly = true
(0026101)
justincc (administrator)
2014-05-14 12:42

So, what appears to be happening is that when the create group command attempts to insert the founder as a member of the new group, it encounters bad data when it checks to see if anything is already present (the "Guid should contain 32 digits with 4 dashes") part.

Looking at Mantis 7139, are you using database tables that contain data migrated from Flotsam groups? I would highly suspect that there is some corruption in the os_groups_membership table, quite possibly a GroupID entry or entries that are not valid UUIDs.

You will need to look in your os_groups_membership MySQL table and manually fix these if you can, or simply remove them.

@hack13. I doubt messaging users has anything to do with this issue.
(0026121)
EliopodB (reporter)
2014-05-17 03:33

Thank you for looking into this Justin, the interesting part about Mantis 7151 is that the group appears to have been created correctly, it has an entry in the os_groups_groups table. If i relog the founder, the error with the 4 dashes reappears and if i attempt to recreate the group again, it points out correctly that the group already exists. the conversion of flotsam groups in mantis 7139 appears to have been done correctly by the published sql scripts. From earlier debugging for 7139 it seems the error has to do with resolving "?" parameters for the query.
========================================================
For now I am going back to using the flotsam groups with modifications introduced 2 years ago to acomodate PHP 5.x
(0027020)
Magnuz (reporter)
2014-11-24 15:12

This is still an issue in OpenSim 0.8.0.3 Release (Unix/Mono), Ubuntu 12.04 32 bit, Mono 2.10.8.1 and MySQL 5.5.31, tested with Singularity 1.8.6 and Firestorm 4.4.2 on OS X 10.6.8. Clean install of new hypergrid, no old data, groups are created properly in the database. hack13's suggestion makes no difference.
(0027034)
justincc (administrator)
2014-11-27 16:55

You see the same exception in the description with Flotsam groups?
(0027037)
Magnuz (reporter)
2014-11-27 22:50

I tried installing Flotsam groups, but never got them to play. No errors in log, but it never wrote anything in the (Flotsam) database. Funny enough it seemed to semi-create groups locally somehow though, because I saw created groups (named "New group" and non-functioning) in list until I either crossed to another sim or relogged, when they disappeared again.

I tried the Arriba fork with the same settings as I tried with the OpenSim 0.8.0.3 for groups V2, and there groups V2 play out of the box.

- Issue History
Date Modified Username Field Change
2014-05-05 20:16 EliopodB New Issue
2014-05-05 20:16 EliopodB File Added: Robust.ini
2014-05-06 05:32 aiaustin Summary Groups V2 doesnt show my groups in Firestorm using release 0.7.6.1 => Groups V2 does not show my groups in Firestorm using release 0.7.6.1
2014-05-06 08:51 EliopodB File Added: OpenSim.ini
2014-05-10 21:39 EliopodB File Added: Robust.log
2014-05-10 21:40 EliopodB Note Added: 0026030
2014-05-11 22:09 hack13 Note Added: 0026035
2014-05-14 12:38 justincc Relationship added related to 0007139
2014-05-14 12:42 justincc Note Added: 0026101
2014-05-17 03:33 EliopodB Note Added: 0026121
2014-11-24 15:12 Magnuz Note Added: 0027020
2014-11-27 16:55 justincc Note Added: 0027034
2014-11-27 22:50 Magnuz Note Added: 0027037


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker