MantisBT - opensim
View Issue Details
0007151opensim[GRID] Grid Servicepublic2014-05-05 20:162014-11-27 22:50
EliopodB 
 
highmajoralways
newopen 
 
 
Grid (1 Region per Sim)
BulletSim
Mono / Windows
None
Firestorm x64
0007151: Groups V2 does not show my groups in Firestorm using release 0.7.6.1
I 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

 


This Report replaces my previous 0007139
No tags attached.
related to 0007139new  Groups V2 doesn't show groups 
? Robust.ini (19,064) 2014-05-05 20:16
http://opensimulator.org/mantis/file_download.php?file_id=3900&type=bug
? OpenSim.ini (51,512) 2014-05-06 08:51
http://opensimulator.org/mantis/file_download.php?file_id=3902&type=bug
log Robust.log (34,149) 2014-05-10 21:39
http://opensimulator.org/mantis/file_download.php?file_id=3905&type=bug
Issue History
2014-05-05 20:16EliopodBNew Issue
2014-05-05 20:16EliopodBFile Added: Robust.ini
2014-05-06 05:32aiaustinSummaryGroups 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:51EliopodBFile Added: OpenSim.ini
2014-05-10 21:39EliopodBFile Added: Robust.log
2014-05-10 21:40EliopodBNote Added: 0026030
2014-05-11 22:09hack13Note Added: 0026035
2014-05-14 12:38justinccRelationship addedrelated to 0007139
2014-05-14 12:42justinccNote Added: 0026101
2014-05-17 03:33EliopodBNote Added: 0026121
2014-11-24 15:12MagnuzNote Added: 0027020
2014-11-27 16:55justinccNote Added: 0027034
2014-11-27 22:50MagnuzNote Added: 0027037

Notes
(0026030)
EliopodB   
2014-05-10 21:40   
Repeated test with 0.8-rc1

uploaded complete Robust.log
(0026035)
hack13   
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   
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   
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   
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   
2014-11-27 16:55   
You see the same exception in the description with Flotsam groups?
(0027037)
Magnuz   
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.