« Réunion du 18-01-2022 » : différence entre les versions

De OSWiki
Aller à la navigation Aller à la recherche
Ligne 56 : Ligne 56 :
[11:12] Ubit Umarov : donc... même chose
[11:12] Ubit Umarov : donc... même chose
[11:12] Vincent.Sylvester @hg.zetaworlds.com:8002 : Je commençais à perdre la raison en pensant que c'était une obscure perte de paquets quelque part ou quelque chose comme ça.
[11:12] Vincent.Sylvester @hg.zetaworlds.com:8002 : Je commençais à perdre la raison en pensant que c'était une obscure perte de paquets quelque part ou quelque chose comme ça.
[11:12] Gavin.Hird @grid.xmir.org:8002: they rather have 1000 prims(meses) with 3 millions tries each to contend with
[11:12] Gavin.Hird @grid.xmir.org:8002 : ils préfèrent avoir 1000 prims(meshes) avec 3 millions de tests chacun pour faire face à la situation.
[11:13] Vincent.Sylvester @hg.zetaworlds.com:8002: It going all the way to LL and then being half a decade old code is just comical, the cherry on top
[11:13] Vincent.Sylvester @hg.zetaworlds.com:8002 : Cela va jusqu'à LL et ensuite c'est un code vieux d'une demi-décennie, c'est juste comique, la cerise sur le gâteau.
[11:13] Ubit Umarov: aurora did had culling
[11:13] Ubit Umarov : Aurora a fait de la sélection.
[11:13] Ubit Umarov: but also heavy
[11:13] Ubit Umarov : mais aussi lourd
[11:14] Ubit Umarov: interest lists per user.. looked at all the time..
[11:14] Ubit Umarov: interest lists per user.. looked at all the time..
[11:14] Vincent.Sylvester @hg.zetaworlds.com:8002: Speaking of prims, been digging about today and found an old linkset with xml encoding utf 16 followed by utf 8 data
[11:14] Vincent.Sylvester @hg.zetaworlds.com:8002: Speaking of prims, been digging about today and found an old linkset with xml encoding utf 16 followed by utf 8 data

Version du 19 janvier 2022 à 09:38

Source : http://opensimulator.org/wiki/Chat_log_from_the_meeting_on_2022-01-18

Introduction

[11:01] Gavin.Hird @grid.xmir.org:8002 : Salut Andrew
[11:01] Andrew Hellershanks : Bonjour, tout le monde.
[11:02] Ubit Umarov : Oh, voici M. Andrew White Hellershanks.
[11:02] Andrew Hellershanks : Blanc est mon deuxième prénom ;)
[11:02] Gavin.Hird @grid.xmir.org:8002 : l'hiver est pâle.
[11:02] Ubit Umarov : la nourriture et les boissons sont si vieilles ici.
[11:02] Selby.Evans @grid.kitely.com:8002 : bonjour à tous.
[11:02] Andrew Hellershanks : J'essaie de me fondre dans le décor avec les 30 cm de neige que nous avons dehors.
[11:02] Ubit Umarov : et le pari est venu de régions encore plus anciennes.
[11:03] Jamie.Jordan @grid.kitely.com:8002 : Salut Selby
[11:03] Ubit Umarov : oh ? il n'y a pas de neige ici.
[11:03] Gavin.Hird @grid.xmir.org:8002 : C'est vrai, Ubit - la dégradation de la nourriture n'est pas une bonne chose.
[11:03] Ubit Umarov : Il se peut que Gavin ait un bot de plus en neige.
[11:03] Gavin.Hird @grid.xmir.org:8002: pas god
[11:03] Gavin.Hird @grid.xmir.org:8002: good*
 [11:03] Ubit Umarov : ou un peu plus..
[11:03] Gavin.Hird @grid.xmir.org:8002 : Gavin a 0 mm de couverture neigeuse
[11:04] Ubit Umarov : ok il semble que nous ayons un problème de fautes de frappe :)
[11:04] Gavin.Hird @grid.xmir.org:8002 : 5°C de trop

Bogue du cache des objets

[11:04] Vincent.Sylvester @hg.zetaworlds.com:8002 : Gavin as-tu vu la correction du bug du cache d'objet ?
[11:04] Gavin.Hird @grid.xmir.org:8002 : Je l'ai compilé
[11:04] Gavin.Hird @grid.xmir.org:8002 : donc d'un jour à l'autre.
[11:04] Gavin.Hird @grid.xmir.org:8002: :-)
[11:04] Vincent.Sylvester @hg.zetaworlds.com:8002 : Super !
[11:05] Gavin.Hird @grid.xmir.org:8002 : peut-être vendredi.
[11:05] Ubit Umarov : rappelez-vous que sur opensim une prim est retenue pour le cache que  15mins après le dernier changement/rez.
[11:05] Ubit Umarov : sur SL c'est moins de 5 minutes.
[11:05] Ubit Umarov : avant c'était 1 heure ici...
[11:05] Ubit Umarov : c'est 1 heure sur les anciennes versions.
[11:06] Ubit Umarov : il vaut mieux recharger quelques prims au cas où vous auriez besoin d'en tester plusieurs et attendre 15 minutes.
[11:06] Vincent.Sylvester @hg.zetaworlds.com:8002 : J'ai désactivé les caps sur certaines régions pour tester et j'ai du mal à voir ce que cela  fait en termes de performances. Bien sûr, les prims sont mises en cache pour qu'elles s'affichent plus rapidement, mais j'ai du mal à "voir" la différence.
[11:07] Ubit Umarov : Ohh c'est énorme
[11:07] Ubit Umarov : au retour dans une région
[11:07] Vincent.Sylvester @hg.zetaworlds.com:8002 : Je n'en doute pas, surtout si la connexion est plus lente, etc.
[11:07] Ubit Umarov : très visible.
[11:08] Ubit Umarov : Bien sûr, de temps en temps Firestorm s'étrangle en rezzant les prims.
[11:08] Ubit Umarov : et de temps en temps, aucune idée pourquoi, certaines restent trasparentes jusqu'à ce qu'elles soient touchées.
[11:09] Vincent.Sylvester @hg.zetaworlds.com:8002 : Peut-être que le test sur les varegions  avec 50000 objets le remplit probablement ou quelque chose comme ça, en fait la taille du cache par défaut n'est pas très grande.
[11:09] Ubit Umarov : le tri des objets par la distance est aussi réalisé côté du viewer.
[11:09] Ubit Umarov : ( où le bug était.. )
[11:10] Vincent.Sylvester @hg.zetaworlds.com:8002 : Je m'attendais probablement à ce que ce soit plus comme à l'époque où il fallait attendre une demi-heure pour qu'une région se charge complètement ou quelque chose comme ça avec le cache désactivé.
[11:10] Ubit Umarov : c'est un mauvais point du cache d'objet.
[11:10] Ubit Umarov : le viewer veut avoir toutes les prims d'une région au départ.
[11:11] Gavin.Hird @grid.xmir.org:8002 : si ce n'est pas le cas, le tri sera plutôt aléatoire.
[11:11] Ubit Umarov : j'ai fait un peu de travail sur la sélection côté serveur même en plus de cela.
[11:11] Ubit Umarov : l'option est là.
[11:11] Ubit Umarov : mais c'est lourd et je n'ai pas fini.
[11:11] Ubit Umarov : SL n'a jamais envisagé de régions avec 120K prims.
[11:12] Ubit Umarov : mais d'un autre côté opensim n'a jamais fait de filtrage comme le faisaient les régions SL.
[11:12] Ubit Umarov : donc... même chose
[11:12] Vincent.Sylvester @hg.zetaworlds.com:8002 : Je commençais à perdre la raison en pensant que c'était une obscure perte de paquets quelque part ou quelque chose comme ça.
[11:12] Gavin.Hird @grid.xmir.org:8002 : ils préfèrent avoir 1000 prims(meshes) avec 3 millions de tests chacun pour faire face à la situation.
[11:13] Vincent.Sylvester @hg.zetaworlds.com:8002 : Cela va jusqu'à LL et ensuite c'est un code vieux d'une demi-décennie, c'est juste comique, la cerise sur le gâteau.
[11:13] Ubit Umarov : Aurora a fait de la sélection.
[11:13] Ubit Umarov : mais aussi lourd
[11:14] Ubit Umarov: interest lists per user.. looked at all the time..
[11:14] Vincent.Sylvester @hg.zetaworlds.com:8002: Speaking of prims, been digging about today and found an old linkset with xml encoding utf 16 followed by utf 8 data
[11:15] Vincent.Sylvester @hg.zetaworlds.com:8002: That based on some idea or should I just ignore that as bad formatting?
[11:16] Andrew Hellershanks: Sounds odd for it to have two different string encodings.
[11:16] Gavin.Hird @grid.xmir.org:8002: possibly written and updated by two different viewers
[11:16] Andrew Hellershanks: Could be.
[11:17] Vincent.Sylvester @hg.zetaworlds.com:8002: It's also missing a bunch of parameters in the xml like particle system and such things
[11:17] Ubit Umarov: xml is a crap
[11:17] Gavin.Hird @grid.xmir.org:8002: doe the thing rez?
[11:17] Ubit Umarov: and opensim use of has not been the best
[11:17] Ubit Umarov: and opensim use of it has not been the best
[11:18] Ubit Umarov: also ms documentation on it is confusing
[11:18] Ubit Umarov: so.. yeah  utf-16 may had shown up on oars
[11:18] Ubit Umarov: at least on the first line
[11:18] Ubit Umarov: while actual data was utf-8
[11:19] Vincent.Sylvester @hg.zetaworlds.com:8002: Haven't tried, I just found the asset data being flagged as malformed by the xml parsing so looking at it the linkset xml itself claimed utf16 encoding in the parameter of the header, but the parts xml all said utf8, weird double structure in there
[11:19] Ubit Umarov: use of BOM also not that clear
[11:19] Vincent.Sylvester @hg.zetaworlds.com:8002: It should be an inventory item so I might be able to find and rez it
[11:19] Gavin.Hird @grid.xmir.org:8002: double structure - like DNA?
[11:20] Vincent.Sylvester @hg.zetaworlds.com:8002: Well like one xml open and close tag around a bunch of others for each link part
[11:20] Ubit Umarov: well and possible several oar formats outthere now
[11:20] Ubit Umarov: think inworldz had its own variant?
[11:20] Vincent.Sylvester @hg.zetaworlds.com:8002: Original creator is from osgrid back when that other profiles system was in use
[11:21] Ubit Umarov: i think the utf-16 on the header line is ignored if there is a BOM
[11:22] Vincent.Sylvester @hg.zetaworlds.com:8002: Forcing utf8 encoding it parsed just fine though so at least the rest of it seems proper
[11:22] Vincent.Sylvester @hg.zetaworlds.com:8002: Surprises me that it probably works as asset in OpenSim like that
[11:23] Ubit Umarov: guess that utf16 is still there even on new oars
[11:23] Ubit Umarov: let me xee
[11:23] Vincent.Sylvester @hg.zetaworlds.com:8002: There are certainly some whacky data structures in OpenSim
[11:24] Vincent.Sylvester @hg.zetaworlds.com:8002: I recall decoding parcel blob data was a fun trip into bits and byte land
[11:24] Gavin.Hird @grid.xmir.org:8002: xee - is that a new xml keyword?
[11:24] Ubit Umarov: <SceneObjectGroup><SceneObjectPart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
[11:24] Ubit Umarov: no idea why we thave that xsi bs
[11:25] Ubit Umarov: <?xml version="1.0" encoding="utf-16"?>
<RegionSettings>
[11:26] Ubit Umarov: <?xml version="1.0" encoding="utf-16"?>
<archive major_version="0" minor_version="8">
[11:26] Ubit Umarov: well this was broken from start
[11:26] Vincent.Sylvester @hg.zetaworlds.com:8002: Thing is the data in there is utf8 most likely, because most of it is now
[11:26] Ubit Umarov: can't change now
[11:26] Ubit Umarov: utf-16 is a stupid encode
[11:26] Ubit Umarov: but windows and linux went for it
[11:27] Ubit Umarov: like many early adopters of unicode
[11:27] Ubit Umarov: at a point utf-16 was the entire unicode
[11:27] Ubit Umarov: unicode was so clever that decided 16bits was all that would be needed
[11:28] Andrew Hellershanks: Yup. 64k should be enough for anyone. :)
[11:28] Ubit Umarov: yeah when present all xml headers ssay utf8
[11:28] Ubit Umarov: opoe utf-16
[11:28] Ubit Umarov: hmm let me see a file in binary
[11:29] Vincent.Sylvester @hg.zetaworlds.com:8002: lxml.etree.XMLSyntaxError: Document labelled UTF-16 but has UTF-8 content, line 1, column 38
[11:30] Vincent.Sylvester @hg.zetaworlds.com:8002: Thankfully can always tell it to force utf8 in that case
[11:31] Ubit Umarov: file is utf8
[11:31] Vincent.Sylvester @hg.zetaworlds.com:8002: Just really odd given it was also missing normal parameters for prims, I'd imagine those would eventually get added when reloading the asset via an archive, but doesn't seem to be the case either
[11:31] Ubit Umarov: in fact ascii
[11:31] Ubit Umarov: one byte per char
[11:31] Ubit Umarov: and no BOM
[11:32] Ubit Umarov: no idea how it works LOL
[11:32] Ubit Umarov: ms xml crap
[11:32] Ubit Umarov: 3c 3f 78 6d 6c 20 76 65 72 73 69 6f 6e 3d 22 31 2e 30 22 20 65 6e 63 6f 64 69 6e 67 3d 22 75 74 66 2d 31 36 22 3f 3e 0d 0a 3c 61 72 63 68 69 76 65 20 6d 61 6a 6f 72 5f 76 65 72 73 69 6f 6e 3d
[11:32] Vincent.Sylvester @hg.zetaworlds.com:8002: I imagine if proper structure was enforced half the stuff in world wouldn't load anymore
[11:32] Ubit Umarov: see? simple plain ascii
[11:34] Ubit Umarov: guess on read we do force utf8
[11:34] Vincent.Sylvester @hg.zetaworlds.com:8002: I figured as much given the parser said it was all utf8 anyways
[11:35] Vincent.Sylvester @hg.zetaworlds.com:8002: Got stuck on something else after that, but that's a different story for another time
[11:35] Ubit Umarov: utf-16 also has bit order issues lol
[11:35] Ubit Umarov: byte order
[11:36] Ubit Umarov: xml is so well done protocoll
[11:36] Ubit Umarov: for a crap made on knees
[11:36] Vincent.Sylvester @hg.zetaworlds.com:8002: I been making more modules lately and found the old dreaded thread stuck on shutdown gets worse the more modules I add
[11:37] Andrew Hellershanks: I thought that problem went away as of 0.9
[11:37] Vincent.Sylvester @hg.zetaworlds.com:8002: I thought so too
[11:37] Vincent.Sylvester @hg.zetaworlds.com:8002: It is starting to look a bit like the reason for that is usage or data contained in those threads
[11:37] Vincent.Sylvester @hg.zetaworlds.com:8002: Given I add modules that put a lot of data out into the system tend to make the most impact
[11:38] Vincent.Sylvester @hg.zetaworlds.com:8002: So I wonder if the cause is some form of memory leak or other orphaned data that fails to clear
[11:38] Vincent.Sylvester @hg.zetaworlds.com:8002: Especially when I do a lot of testing with the modules thus cause more data to go back and forth
[11:39] Vincent.Sylvester @hg.zetaworlds.com:8002: On master I still see some red during shutdown on random threads not shutting down cleanly, though only on mono
[11:40] Vincent.Sylvester @hg.zetaworlds.com:8002: on windows .net doing tests in vscode it all works splendidly
[11:40] Ubit Umarov: mono has issues on threads stop
[11:40] Ubit Umarov: lets them stuck on some things
[11:41] Ubit Umarov: in same cases can't even kill then the wai it wants, then gets stuck
[11:41] Jagga Meredith whispers: -[[[[[[[[[
[11:41] Ubit Umarov: ...the way...
[11:42] Vincent.Sylvester @hg.zetaworlds.com:8002: One can always check if the simulator responds to "pings" and nuke it, but of course not ideal either
[11:42] Vincent.Sylvester @hg.zetaworlds.com:8002: It surprises me that bug is still in mono after all this time
[11:42] Vincent.Sylvester @hg.zetaworlds.com:8002: Would assume we can't be the only ones to see it
[11:42] Gavin.Hird @grid.xmir.org:8002: mono is not being updated any more
[11:42] Ubit Umarov: well mono is now dead
[11:42] Gavin.Hird @grid.xmir.org:8002: yes
[11:42] Ubit Umarov: on its down hill
[11:43] Ubit Umarov: ms made all the devel it needs to canabilze parts of it to dotnet
[11:43] Andrew Hellershanks: Vincent, to do that properly requires more than one ping and enough time between them to have allowed the instance to have saved prim data to the data base so that it doesn't get killed while it is still in the process of shutting down.
[11:43] Ubit Umarov: now..  basicly dead
[11:43] Kayaker Magic: so how is progress on mono's dotnet on Linux?
[11:43] Ubit Umarov: no updates in almost one year
[11:43] Ubit Umarov: who cares..
[11:44] Ubit Umarov: opensim is a huge pain to covert to dotnet
[11:44] Ubit Umarov: we aill lose some features
[11:44] Ubit Umarov: Xengine is one
[11:44] Ubit Umarov: even Yengine may have issues
[11:45] Ubit Umarov: bitmap operations need to be converted to use other external lib, because removed from .net
[11:46] Ubit Umarov: that measn no map, no dynamic textures, even no lludp textures fetch some viewers still use
[11:46] Ubit Umarov: ann and no sculpt maps
[11:47] Ubit Umarov: .net5 and 6 is just a huge breaking change
[11:47] Ubit Umarov: and .net framework 4.8 is suposed to last several years still
[11:47] Ubit Umarov: problem is  mono
[11:47] Ubit Umarov: how it lost all devs
[11:48] Vincent.Sylvester @hg.zetaworlds.com:8002: Last commit two weeks ago it says
[11:48] Vincent.Sylvester @hg.zetaworlds.com:8002: I mean thankfully is open source, but yeah
[11:48] Gavin.Hird @grid.xmir.org:8002: also no usable 64-bit arm version of mono
[11:48] Ubit Umarov: well no release since Feb last here
[11:48] Ubit Umarov: yeah no new things on mono
[11:49] Ubit Umarov: ms will slow start killing it to "sell" dotnet
[11:49] Vincent.Sylvester @hg.zetaworlds.com:8002: It got so much traction 5 and 6 flew out the door quickly and then MS killed it by buying it
[11:49] Ubit Umarov: also ms does not care
[11:49] Ubit Umarov: who does use linux and mono on the users universe?
[11:49] Ubit Umarov: 0.001% of all users?
[11:50] Vincent.Sylvester @hg.zetaworlds.com:8002: Er that reminds me, Gavin, you saw the mantis on postgres not working, were you able to reproduce that?
[11:50] Gavin.Hird @grid.xmir.org:8002: I did not see that
[11:51] Kayaker Magic: Lots of the commercial OpenSim grids use Linux/Mono. Lots of the mid-sized users (between grids and sim-on a stick) use Linux/Mono
[11:51] Vincent.Sylvester @hg.zetaworlds.com:8002: 8959 is the id iirc
[11:51] Gavin.Hird @grid.xmir.org:8002: postgres don't run on mono higher than 6.6.0.161
[11:52] Gavin.Hird @grid.xmir.org:8002: without a larger rewrite
[11:52] Ubit Umarov: yes and opensim users are like 0.000000001% of all users :p
[11:52] Ubit Umarov: all ms users..
[11:52] Vincent.Sylvester @hg.zetaworlds.com:8002: Well I was able to get OpenSim to load with just one error by updating the Npgsql and supply two additional dlls to it
[11:52] Vincent.Sylvester @hg.zetaworlds.com:8002: Though as Ubit pointed out those are a bad idea
[11:53] Gavin.Hird @grid.xmir.org:8002: you can get it to laod, but try logging in
[11:53] Vincent.Sylvester @hg.zetaworlds.com:8002: Yeah there is an issue with user accounts parsing uuid field
[11:54] Vincent.Sylvester @hg.zetaworlds.com:8002: I'm not familiar with postgres so attempting to fix that....
[11:54] Gavin.Hird @grid.xmir.org:8002: as I said, a rather large rewrite
[11:54] Ubit Umarov: our current Npgsql.dll fails to run on last stable mono??
[11:54] Gavin.Hird @grid.xmir.org:8002: yes
[11:54] Ubit Umarov whispers: why i  hell??
[11:54] Ubit Umarov: should not
[11:55] Vincent.Sylvester @hg.zetaworlds.com:8002: You have to use version 3.2.7 of it and supply two additional dlls then it kinda works
[11:55] Gavin.Hird @grid.xmir.org:8002: you have your work cut out in front of you ;-)
[11:55] Gavin.Hird @grid.xmir.org:8002: except 3.2.7 is proably already unsupported too
[11:55] Ubit Umarov: vince that is changinf to a .net5 or standard lib
[11:55] Vincent.Sylvester @hg.zetaworlds.com:8002: Tell me about it I looked at the Npgsql source to remove the need for said dlls...
[11:56] Vincent.Sylvester @hg.zetaworlds.com:8002: OpenSim has clean and well structured code in comparison
[11:56] Ubit Umarov: possible can't anymore
[11:56] Gavin.Hird @grid.xmir.org:8002: current supported versions are in the 4.high or even 5 versions
[11:56] Vincent.Sylvester @hg.zetaworlds.com:8002: 4.1.9 is total nightmare, 8 dlls that wants
[11:56] Vincent.Sylvester @hg.zetaworlds.com:8002: All manners of random things
[11:56] Ubit Umarov: like all religion kids, possible they just blindly moved to .net5/6 and relatives
[11:57] Gavin.Hird @grid.xmir.org:8002: nuget(?) install
[11:57] Vincent.Sylvester @hg.zetaworlds.com:8002: It's total bloatware, the latest version is 8 times the size of the one OpenSim uses
[11:58] Ubit Umarov: vincent main software job is to force users to by more powerfull machines
[11:58] Vincent.Sylvester @hg.zetaworlds.com:8002: Space heaters
[11:58] Gavin.Hird @grid.xmir.org:8002: it actually does more like supporting new features in postgres 13 and 14
[11:58] Ubit Umarov: ofc is is larger and needs more cpu to do the same.. that is what software is all abotu :p
[11:59] Andrew Hellershanks: :)
[11:59] Andrew Hellershanks: We are at the top of the hour.
[12:00] Vincent.Sylvester @hg.zetaworlds.com:8002: If the postgres connector code was a bit easier to understand I might be inclined to try to fix that uuid error just bending over and embedding the two dlls in there, but I feel I will go down a rabbit hole of further errors down the line
[12:00] Ubit Umarov: what uuid error?
[12:00] Andrew Hellershanks: One small bit of OpenSim news. The biggest change this past week was saving some nanoseconds by handling the checks for empty strings in a more efficient manner.
[12:00] Gavin.Hird @grid.xmir.org:8002: it is a casting error in
[12:00] Gavin.Hird @grid.xmir.org:8002: casting error with libomv (or what it is called)
[12:01] Ubit Umarov: libomv has nothing to do with pgsql
[12:01] Gavin.Hird @grid.xmir.org:8002: you keep saying that
[12:01] Gavin.Hird @grid.xmir.org:8002: but it does
[12:01] Gavin.Hird @grid.xmir.org:8002: it cannot do a cast
[12:01] Gavin.Hird @grid.xmir.org:8002: with uuid as it is implemented in libomv
[12:01] Ubit Umarov: wel then the cast needs a workaround
[12:02] Ubit Umarov: ut has own uuid?
[12:02] Ubit Umarov: possible the casts need the full namespace spec
[12:02] Ubit Umarov: uuid is also a native type of that hign?
[12:02] Ubit Umarov: thing?
[12:03] Ubit Umarov: or is it ms guid ?
[12:03] Vincent.Sylvester @hg.zetaworlds.com:8002: https://pastebin.com/XDg6XaUi
[12:04] Vincent.Sylvester @hg.zetaworlds.com:8002: Error loading plugin OpenSim.Services.Interfaces.IUserAccountService from OpenSim.Services.UserAccountService.dll. Exception: Can't convert .NET type >
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Can't convert .NET type OpenMetaverse.UUID to PostgreSQL uu>
[12:04] Gavin.Hird @grid.xmir.org:8002: I think it has to do with ms guid, but O cannot recall exactly right now
[12:04] Ubit Umarov: Can't convert .NET type OpenMetaverse.UUID to PostgreSQL uu
[12:04] Ubit Umarov: uu ?
[12:04] Vincent.Sylvester @hg.zetaworlds.com:8002: id
[12:04] Gavin.Hird @grid.xmir.org:8002: uuid
[12:04] Ubit Umarov: it tells uu
[12:04] Ubit Umarov: :)
[12:04] Gavin.Hird @grid.xmir.org:8002: uuid is native dataype in postgres
[12:05] Ubit Umarov: ok then isolation is needed
[12:05] Ubit Umarov: one needs to have full namespace spec
[12:06] Ubit Umarov: why that is a issue with new mono and not older.. well..  no idea
[12:06] Gavin.Hird @grid.xmir.org:8002: deprecations
[12:06] Gavin.Hird @grid.xmir.org:8002: or actually removal of support in npgsql
[12:07] Gavin.Hird @grid.xmir.org:8002: but then BOOM - mono was not updated any more
[12:07] Ubit Umarov: PGSQLGenericTableHandler
[12:08] Ubit Umarov: well that is a "clever" to it all thing
[12:08] Ubit Umarov: not that simple do fix
[12:08] Gavin.Hird @grid.xmir.org:8002: actaully it is pretty dumb and needs to be rewriten
[12:08] Gavin.Hird @grid.xmir.org:8002: it does not support upsert, so there are issues with some tables bacause of that
[12:09] Ubit Umarov: else if (m_Fields[name].GetValue(row) is UUID)
                        {
                            UUID uuid = UUID.Zero;

                            UUID.TryParse(reader[name].ToString(), out uuid);
                            m_Fields[name].SetValue(row, uuid);
[12:09] Ubit Umarov: guess m_Fields[name].GetValue(row) is UUID is other uuid
[12:09] Vincent.Sylvester @hg.zetaworlds.com:8002: With mariadb getting uuid field type soon might be good to revisit the connectors in general is my thinking on this, squeeze some performance out of them perhaps :)
[12:10] Ubit Umarov: then code goes via string to convert it to openmetaverse :)
[12:10] Ubit Umarov: uuid on opensim and dbs is a mess
[12:10] Ubit Umarov: some are just done as string
[12:10] Jamie.Jordan @grid.kitely.com:8002: Have a great week yall
[12:11] Ubit Umarov: and not just on the db.. even on main opensim code
[12:11] Andrew Hellershanks: ok, Jamie. You too. Thanks for dropping by
[12:11] Ubit Umarov: and worse
[12:11] Gavin.Hird @grid.xmir.org:8002: the postgres tables are partly native uuid and partly varchar
[12:11] Ubit Umarov: some where born as uuid and now have more things
[12:11] Ubit Umarov: like the uui
[12:11] Ubit Umarov: ie  uuid+ gridhost etc
[12:12] Andrew Hellershanks: Right.
[12:12] Gavin.Hird @grid.xmir.org:8002: Griduser UserID is also a gem
[12:13] Ubit Umarov: hard to fix that mess now
[12:13] Ubit Umarov: it is on a lot of places
[12:13] Gavin.Hird @grid.xmir.org:8002: :-)
[12:14] Ubit Umarov: so use of dbs native uuid is not that great
[12:14] Ubit Umarov: and on same that natice is just a 36 chars string and with the useless '-'
[12:14] Ubit Umarov: that native..
[12:15] Gavin.Hird @grid.xmir.org:8002: the native actually support 3 different implementations of uuid
[12:17] Gavin.Hird @grid.xmir.org:8002: PostgreSQL also accepts the following alternative forms for input: use of upper-case digits, the standard format surrounded by braces, omitting some or all hyphens, adding a hyphen after any group of four digits.
[12:19] Gavin.Hird @grid.xmir.org:8002: PostgreSQL provides storage and comparison functions for UUIDs, but the core database does not include any function for generating UUIDs, because no single algorithm is well suited for every application
[12:20] Ubit Umarov: well no idea that crash needs some debug to find where is the types mix
[12:21] Ubit Umarov: cmd.Parameters.Add(m_database.CreateParameter(fields[i], keys[i], m_FieldTypes[fields[i]]));
[12:21] Ubit Umarov: guess here
[12:22] Ubit Umarov: yeha guess it is there
[12:27] Andrew Hellershanks: Almost half past the hour. Any last minute items for today?
[12:28] Gavin.Hird @grid.xmir.org:8002: got the macOS version of the viewer building on the latest Xcode. Now the Intel version also compiles on an Apple Silicon machine
[12:29] Andrew Hellershanks: Sounds good, Gavin.
[12:29] Gavin.Hird @grid.xmir.org:8002: it compiled faster than on any of the Intel kit I have
[12:29] Andrew Hellershanks: :)
[12:30] Andrew Hellershanks: Time to wrap the meeting for today.
[12:30] Gavin.Hird @grid.xmir.org:8002: warp
[12:30] Kayaker Magic: Yup, I need to run.
[12:30] Andrew Hellershanks: Good luck with your work on Postgres issues. Postgres support doesn't see a lot of love.
[12:30] Kayaker Magic: bye all!
[12:30] Andrew Hellershanks: Thank you all for coming. See you again next week.