|
|
| (35 versions intermédiaires par le même utilisateur non affichées) |
| Ligne 6 : |
Ligne 6 : |
|
| |
|
| = Code général = | | = Code général = |
| | === Inventaires === |
| | * Il n'est pas question pour l'instant d'implémenter la nouvelle image de prévisualisation de l'inventaire dans FS pour OpenSimulator, même si cela fonction dans SL. En revanche avec la version beta il y a l'affichage de la fonctionnalité sans la prévisualisation. '''Les viewer actuels n'ont pas le code pour implémenter cette fonctionnalité avec l'API d'inventaire d'OpenSimulator''' [[Réunion_du_31-10-2023#Projets_en_cours_/_Infos |depuis que SL est passé à AIS V3]]. Il faudra beaucoup de code côté serveur... et des changements dans les bases de données. Le développement d'OpenSimulator est libre et ouvert et fait par des bénévoles. |
| | <gallery widths=120px heights=60px > |
| | Firestorm pre-visualisation.png |Dans Firestorm : clic droit sur le dossier, option "Images..." du menu. |
| | Fichier:Firestorm-image_survol.jpg | Survol d'une texture de l'inventaire de Firestorm depuis la version 6.6.16 (70339) . |
| | </gallery> |
| | * Si vous voulez vraiment une fonctionnalité particulière et que vous pensez que l'argent est le moyen de l'obtenir, vous pouvez essayer d'embaucher quelqu'un pour implémenter la fonctionnalité que vous voulez voir ajoutée. |
| | * NDLR : ne pas confondre (comme moi) l'affichage des images d'un dossier et l'affichage d'une image de l'inventaire au survol de la souris. |
|
| |
|
| = Base de données =
| |
| = Modules =
| |
| = Bugs = | | = Bugs = |
| | === Problème de migration de la base de données === |
| | * Mantis : 0009098 [http://opensimulator.org/mantis/view.php?id=9098] |
| | * Le cast spécifié n'est pas valide au redémarrage de la région : les migrations ne se déroulent pas correctement entre les mises à jour. |
| | * Il serait peut-être judicieux d'ajouter un contrôle au démarrage pour vérifier le schéma de la table ([http://opensimulator.org/wiki/Prims_(database_table)/fr Mise à jour du schéma de la table Prims sur le wiki] ). |
| | * Il semble que le passage de double à float pendant la migration de table n'a pas été exécuté ou a échoué d'une manière ou d'une autre. Si une table est cassée sur une installation avant une migration quand elle s'exécute le désordre s’accroît. |
| | * Le problème : si la migration échoue, le démarrage se poursuit quand même. À la fin il n'y a pas vérification si la table est dans le bon format. |
| | * Solution SQL de fortune : mettre une condition pour dire d'ajouter le champ s'il n'existe pas au lieu de l'ajouter aveuglément. |
| | * Solution idéale : S'il n'y a pas de table, il suffit de la créer directement à partir d'un fichier SQL, sans avoir besoin de faire toute la migration. Si le schéma de la table ne correspond pas, il suffit d'arrêter le démarrage et de dire à l'utilisateur que quelque chose ne va pas. Un plan ultime pour cela serait un système qui vérifie l'"état" d'une table et n'exécute que les migrations dont il a besoin et échoue s'il ne peut pas corriger la table à la structure appropriée. Puis, inclure un message qui indique où le schéma diverge et où intervenir manuellement dans la base de données pour faire les ajustements selon un fichier sql de structure ou sortir le bon schéma par rapport à l'installation. |
| | --> Détection de la version X de la table, exécution des migrations... |
| | --> Impossible de mettre à jour le schéma de la table Structure de la table malformée, |
| | --> Veuillez corriger le type de données |
| | * La version de la base de données est dans la table des migrations. |
| | * Il faudrait une migration avec retour en arrière en cas d'échec. |
| | === Problème chaîne de connexion à la base de données === |
| | * Il faudrait signaler l'origine du problème immédiatement dans la console au lieu d'avoir un flot de texte rouge. |
| | |
| = Tests = | | = Tests = |
| === Test unitaires === | | === Test unitaires === |
| Ligne 15 : |
Ligne 37 : |
|
| |
|
| = Projets en cours / Infos= | | = Projets en cours / Infos= |
| | === OSCC 2023 -- 11e édition === |
| | ==== Objectif ==== |
| | * Renforcer la communauté, voir ce que tout le monde fait et où nous nous situons. |
| | |
| | ====Dates ==== |
| | * ''' La conférence aura lieu les 9 et 10 décembre 2023 avec une fête d'ouverture le vendredi 8 décembre.''' |
| | |
| | ==== Programme ==== |
| | * C'est la conférence de la communauté OpenSimulator, donc tous les sujets liés à Opensim sont les bienvenus, y compris l'avenir. |
| | * Il y a 30 sessions de 7h à 18h et de la danse en soirée. |
| | * Le core des développeurs parle de 7h à 9h |
| | * Il y a une session VIP"Core Dev à 11h45 le samedi 9 décembre. |
| | * La table ronde sur les Viewers se tiendra le samedi 9 décembre à 12h30. |
| | * Il y aura pas mal de sessions sur la recherche, l'éducation, le divertissement et les arts, ainsi que quelques intégrations d'outils avec d'autres mondes et technologies. |
| | * Contrairement aux autres conférences, elle ne se limitera pas à un thème. Il y a 5 titres : les entreprises, la technologie, la recherche, l'éducation, la créativité et les arts. De cette façon, tout est visible par tous depuis les 4 régions sur les Keynotes de l'OSCC. |
| | * Le programme est en cours d'élaboration et sera en ligne dans quelques semaines. |
| | |
| | ==== S'inscrire ==== |
| | * Lien pour s'inscrire : https://conference.opensimulator.org/ |
| | * Venez nous rejoindre. Il n'y a pas de communauté sans vous |
| | |
| | ==== Des chiffres ==== |
| | * '''Sur Hypergrid Business, Maria mène une enquête. Mais, il faudrait que plus de personnes y participent.''' |
| | |
| | === Mono === |
| * Mono appartient à Microsoft (MS) et même si c'est un logiciel libre, c'est une impasse, MS l'a tué. | | * Mono appartient à Microsoft (MS) et même si c'est un logiciel libre, c'est une impasse, MS l'a tué. |
| | === Rôle des réunions du mardi === |
| | * discuter des changements en cours, des orientations futures, des projets et des besoins des développeurs et de la communauté, rapporter des observations. |
|
| |
|
| = Viewers= | | = Viewers= |
| === Firestorm=== | | === Firestorm=== |
| * Pas de problèmes majeurs avec la dernière version (6.6.14.69596) qui date du 1er août. Hormis, des problèmes de cache qui avalent les textures ou les objets mais, qui ne sont pas lié au viewer mais plutôt aux modifications apportées par Linden Lab. | | * Pas de problèmes majeurs avec la dernière version (6.6.14.69596) qui date du 1er août. Hormis, des problèmes de cache qui avalent les textures ou les objets mais, qui ne sont pas liés au viewer mais plutôt aux modifications apportées par Linden Lab. |
| * La version beta ajoute des modifications pour les inventaires. Cette version a supprimé les inventaires lludp pour SL mais pas pour OpenSim. Pour OpenSim seules les vignettes ne fonctionnent pas. | | * La version beta ajoute des modifications pour les inventaires. Cette version a supprimé les inventaires lludp pour SL mais pas pour OpenSim. Pour OpenSim seules les vignettes ne fonctionnent pas. |
| * La version alpha sera une version 7.x.x | | * La version alpha sera une version 7.x.x |
| * Il n'est pas question pour l'instant d'implémenter la nouvelle image de prévisualisation de l'inventaire dans FS pour OpenSimulator, même si cela fonction dans SL. En revanche avec la version beta [[Fichier:Firestorm pre-visualisation.png|frameless|100px]] | | * NDLR : cette information n'a pas été donnée à la réunion mais depuis la version 6.6.16.70339 de Firestorm la visualisation des textures s'affichent dans l'inventaire de Firestorm. |
|
| |
|
| === Visionneuse Second Life === | | === Visionneuse Second Life === |
| * Il semble que son développement est bloqué depuis deux ou trois semaines. | | * Il semble que son développement soit bloqué depuis deux ou trois semaines. |
| | |
| === Sharpview === | | === Sharpview === |
| * Code du [[Réunion_du_07-11-2023#Sharpview |jeu factice avec la même structure que Sharpview ]] compilé et exécuté sur MacOS : pas de problème. | | * Code du [[Réunion_du_07-11-2023#Sharpview |jeu factice avec la même structure que Sharpview ]] compilé et exécuté sur MacOS : pas de problème. |
| Ligne 32 : |
Ligne 82 : |
| http://opensimulator.org/wiki/Chat_log_from_the_meeting_on_2023-11-14 | | http://opensimulator.org/wiki/Chat_log_from_the_meeting_on_2023-11-14 |
| <!-- | | <!-- |
| [12:21 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: seems ok to me?
| |
| [12:21 PM PT] Arielle Popstar: maybe the yengine thing?
| |
| [12:21 PM PT] Ubit Umarov: most likely your glasses.. but details
| |
| [12:21 PM PT] Ubit Umarov: :p
| |
| [12:21 PM PT] Arielle Popstar: maybe my ao script is old
| |
| [12:22 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Anyways, no news on xunit either. I been talking to someone more familiar with testing on how to approach setting them up. Probably will be a few more weeks to have a battle plan for that
| |
| [12:23 PM PT] Arielle Popstar: so i was noticing the new inventory preview image in FS isnt supported in Osgrid sandbox.
| |
| [12:23 PM PT] Arielle Popstar: https://gyazo.com/b38653270e516fb3823db12df8dd0c66
| |
| [12:23 PM PT] Arielle Popstar: any plans to put that in?
| |
| [12:24 PM PT] Vincent.Sylvester @hg.zetaworlds.com: You don't read the meeting logs do you, no not planned at the moment
| |
| [12:24 PM PT] Ubit Umarov: not in imediate future. FS does not have support for it on opensim either
| |
| [12:24 PM PT] Arielle Popstar: I do on occasion but usually I come to the meeting and hear it first hand unless it cases someone stress
| |
| [12:24 PM PT] Lyr Lobo: It was reviewed, Arielle and I think that until the viewer supports it, no
| |
| [12:24 PM PT] Andrew Hellershanks: Regarding libraries -> cdn.discordapp.com/attachments/1096934148410716271/1173739759022129193/image0.png ;)
| |
| [12:25 PM PT] Arielle Popstar: the viewer does support it though
| |
| [12:25 PM PT] Lyr Lobo: in Opensimulator?
| |
| [12:25 PM PT] Arielle Popstar: works in sl
| |
| [12:25 PM PT] Ubit Umarov: uff yes.. does support it IN SL
| |
| [12:25 PM PT] Arielle Popstar: yes
| |
| [12:25 PM PT] Orbert.Tatham @hg.zetaworlds.com: Find it in the OpenSim version and you get a cookie
| |
| [12:25 PM PT] Arielle Popstar: i see it
| |
| [12:27 PM PT] Arielle Popstar: https://gyazo.com/3ad2de6adeed59ff9dbdeb851e5bc68b
| |
| [12:28 PM PT] Arielle Popstar: if you on the beta viewer r-click on a folder and you are given the option of taking a preview image
| |
| [12:28 PM PT] Ubit Umarov: and then viewer does nothing with it on opensim..
| |
| [12:28 PM PT] Arielle Popstar: this will be a huge boon to residents with browsing their inventory
| |
| [12:29 PM PT] Ubit Umarov: because it was not added to that API we use
| |
| [12:29 PM PT] Arielle Popstar: well because it requires you adding some code?
| |
| [12:29 PM PT] Ubit Umarov: no no point o adding code on our side ( and mess up inventory dbs with useless mess )
| |
| [12:29 PM PT] Ubit Umarov: so no point..
| |
| [12:29 PM PT] Arielle Popstar: no, it helps people with their inventory
| |
| [12:30 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Didn't need it for a decade, why now, name your things properly to remember what they are
| |
| [12:30 PM PT] Arielle Popstar: ok for people with only one outfit but for those of us with lots of clothes it will be a huge improvement
| |
| [12:30 PM PT] Orbert.Tatham @hg.zetaworlds.com: Arielle, as always, if you want the feature, write it and submit it. That is how this works, it is called open source.
| |
| [12:30 PM PT] Ubit Umarov: yeah extra lag everytime viewers decide to cache it
| |
| [12:31 PM PT] Arielle Popstar: there is also lag when one has to rezz out a whole clothing item to see what it is rather then a small preview image
| |
| [12:31 PM PT] Lyr Lobo: I'm going to have to downsize my inventory if we offer it or become the lag beast
| |
| [12:31 PM PT] Ubit Umarov: well as i said, current viewers do not have the code to update it on out inventory API
| |
| [12:31 PM PT] Orbert.Tatham @hg.zetaworlds.com: Yeah, but you chose to rezz it out
| |
| [12:31 PM PT] Andrew Hellershanks: Vincent, naming things properly and using folders to help keep things organized.
| |
| [12:32 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Something worth doing for anything, not just inventory
| |
| [12:32 PM PT] Andrew Hellershanks: Very true
| |
| [12:32 PM PT] Arielle Popstar: the viewer you are likely using Ubit has it
| |
| [12:32 PM PT] Ubit Umarov: well im not going to repeat what i already told
| |
| [12:32 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: hi cuga
| |
| [12:32 PM PT] Arielle Popstar: shrugs men change once a year if that, for some of us it is multiple times a day
| |
| [12:32 PM PT] Cuga.Rajal @rajal.org:9000: Hi, sorry late
| |
| [12:33 PM PT] Andrew Hellershanks: Welcome, Cuga.
| |
| [12:33 PM PT] Ubit Umarov: mayve dayturn will add the missing api functions ;)
| |
| [12:33 PM PT] Ubit Umarov: well tyhe api is there.. not the extra fileds
| |
| [12:33 PM PT] Gavin.Hird @grid.xmir.org:8002: nobody in opensim have huge amounts of clothes
| |
| [12:34 PM PT] Arielle Popstar: it looks to me like it has to be added server side?
| |
| [12:34 PM PT] Ubit Umarov: fields
| |
| [12:34 PM PT] Arielle Popstar: yeah right Gavin
| |
| [12:34 PM PT] Gavin.Hird @grid.xmir.org:8002: have you seen anyone where chaning clothes the last 10 years?
| |
| [12:34 PM PT] Ubit Umarov: yes it wil need a lot of server side code... and DBs changes..
| |
| [12:34 PM PT] Ubit Umarov: usless if VIEWERS DO NOT USE IT!
| |
| [12:34 PM PT] Arielle Popstar: but the viewer is capable
| |
| [12:34 PM PT] Arielle Popstar: should I ask Beq?
| |
| [12:35 PM PT] Orbert.Tatham @hg.zetaworlds.com: Arielle, write it and submit it. We aren't going to, it is very simple
| |
| [12:35 PM PT] Arielle Popstar: no, it is something that needs to be added to core
| |
| [12:35 PM PT] Arielle Popstar: thats why i am here
| |
| [12:36 PM PT] Arielle Popstar: which is where these things are discussed
| |
| [12:36 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Well you be waiting a long time then.
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: And the core doesn't think we need to add it
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: Sorry about your luck (NOT)
| |
| [12:36 PM PT] Arielle Popstar: well then is Opensim a dead project?
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: You are free to leave
| |
| [12:36 PM PT] Arielle Popstar: I'll let everyone know
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: and call it dea
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: dead
| |
| [12:36 PM PT] Orbert.Tatham @hg.zetaworlds.com: but that doesn't make it dead
| |
| [12:36 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: it maybe if the voice plug is pulled
| |
| [12:37 PM PT] Lyr Lobo: Arielle, we will have a Viewer Panel at the OpenSimulator Community Conference to discuss the viewer and the future
| |
| [12:37 PM PT] Orbert.Tatham @hg.zetaworlds.com: Cliff, we have several time told you what it would take to deal with that
| |
| [12:37 PM PT] Arielle Popstar: i dont see any development from Unbits link in his profile
| |
| [12:37 PM PT] Arielle Popstar: Ubits
| |
| [12:37 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: i realise that
| |
| [12:37 PM PT] Lyr Lobo: It is at 12:30 pm on Saturday, December 9
| |
| [12:37 PM PT] Gavin.Hird @grid.xmir.org:8002: The difference Arielle is that opensim does not have 20 salaried developers working on server side only
| |
| [12:37 PM PT] Arielle Popstar: whose fault is that?
| |
| [12:37 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: is why i try to think out of the box
| |
| [12:38 PM PT] Orbert.Tatham @hg.zetaworlds.com: Like we have told you, if you want it, write it and submit it. Just because you want it does not mean that the core developers think it is needed
| |
| [12:38 PM PT] Arielle Popstar: isnt that because core is closed to other developers?
| |
| [12:38 PM PT] Orbert.Tatham @hg.zetaworlds.com: Not at all
| |
| [12:38 PM PT] Lyr Lobo: This is an opensource project
| |
| [12:38 PM PT] Orbert.Tatham @hg.zetaworlds.com: Core is not paid
| |
| [12:38 PM PT] Arielle Popstar: are you core Orbert?
| |
| [12:38 PM PT] Orbert.Tatham @hg.zetaworlds.com: You are welcome if you can develop
| |
| [12:38 PM PT] Orbert.Tatham @hg.zetaworlds.com: No, I am not good enough, I am just learning
| |
| [12:39 PM PT] Orbert.Tatham @hg.zetaworlds.com: I will contribute if and when I come up with something that works
| |
| [12:39 PM PT] Orbert.Tatham @hg.zetaworlds.com: And it will be up to the others to decide
| |
| [12:39 PM PT] Andrew Hellershanks: Arielle, You should have learned by now how development works and that it is being done by volunteers.
| |
| [12:39 PM PT] Orbert.Tatham @hg.zetaworlds.com: That is how this project works
| |
| [12:39 PM PT] Arielle Popstar: good luck getting them to accept it
| |
| [12:40 PM PT] Orbert.Tatham @hg.zetaworlds.com: Arielle, first I have to figure out what is really needed and what is fluff dreamed up by former Micro$haft twits at Linden
| |
| [12:40 PM PT] Arielle Popstar: so no new features for opensim?
| |
| [12:41 PM PT] Orbert.Tatham @hg.zetaworlds.com: We aren't doing them just because you demand them
| |
| [12:41 PM PT] Arielle Popstar: at least there is some new feature development
| |
| [12:41 PM PT] Lyr Lobo: We are going to discuss the software and viewer at the OpenSimulator Community Conference
| |
| [12:41 PM PT] Arielle Popstar: its supposed to be discussed here pprior to that
| |
| [12:41 PM PT] Orbert.Tatham @hg.zetaworlds.com: There are ways to get things done, Arielle. Demanding them isn't one of them
| |
| [12:42 PM PT] Arielle Popstar: are core spokesperson Orbert?
| |
| [12:42 PM PT] Andrew Hellershanks: Arielle, Even if there was it seems likely it wouldn't a feature you are interested in. If you really want a particular feature and think money is the way to get it you can try and hire someone to implement whatever feature you want to see added.
| |
| [12:42 PM PT] Lyr Lobo: No, we discuss current changes, future directions, and the plans and needs of our viewer developers and the community
| |
| [12:42 PM PT] Orbert.Tatham @hg.zetaworlds.com: I am someone with a brain, Arielle
| |
| [12:42 PM PT] Lyr Lobo: it is a little different. This is a public log for community involvement
| |
| [12:42 PM PT] Arielle Popstar: well i am community :)
| |
| [12:43 PM PT] Lyr Lobo: and yes
| |
| [12:43 PM PT] Orbert.Tatham @hg.zetaworlds.com: Then perhaps it would benefit you to try listening
| |
| [12:43 PM PT] Arielle Popstar: I been coming here about 12 years so have heard it
| |
| [12:43 PM PT] Orbert.Tatham @hg.zetaworlds.com: Ok, then when are you going to understand it
| |
| [12:44 PM PT] Orbert.Tatham @hg.zetaworlds.com: ?
| |
| [12:44 PM PT] Arielle Popstar: i already do and know how it works beyond what you are saying
| |
| [12:44 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Evidently not
| |
| [12:44 PM PT] Orbert.Tatham @hg.zetaworlds.com: Quite obviously false statement
| |
| [12:45 PM PT] Lyr Lobo: well it is good to know that you like the thumbnail feature in SL and find it useful
| |
| [12:45 PM PT] Lyr Lobo: let us know whether you experience any changes in performance in congested areas, etc.
| |
| [12:45 PM PT] Arielle Popstar: same ol same ol, the non core pople would like to dictate how it should work
| |
| [12:45 PM PT] Lyr Lobo: that would be you, Arielle
| |
| [12:45 PM PT] Orbert.Tatham @hg.zetaworlds.com: Yes, you are trying to
| |
| [12:46 PM PT] Arielle Popstar: saw loading in lbsa taking longer
| |
| [12:46 PM PT] Lyr Lobo: Your information is invaluable as without testing, we would not know how well it works
| |
| [12:46 PM PT] Arielle Popstar: but then so is sl
| |
| [12:46 PM PT] Lyr Lobo: that's good to know
| |
| [12:46 PM PT] Orbert.Tatham @hg.zetaworlds.com: As expected
| |
| [12:46 PM PT] Lyr Lobo: you discover very useful usability issues
| |
| [12:46 PM PT] Lyr Lobo: like that log file from a few months back
| |
| [12:46 PM PT] Arielle Popstar: well i did test the image preview function and it isnt working
| |
| [12:47 PM PT] Gavin.Hird @grid.xmir.org:8002: it is not working, but we already knew that
| |
| [12:47 PM PT] Arielle Popstar: ok good so then we should expect changes to resolve it soon?
| |
| [12:47 PM PT] Gavin.Hird @grid.xmir.org:8002: no
| |
| [12:47 PM PT] Orbert.Tatham @hg.zetaworlds.com: Ask SL, they are the ones that care
| |
| [12:48 PM PT] Gavin.Hird @grid.xmir.org:8002: ...does it not need AIS to work?
| |
| [12:48 PM PT] Andrew Hellershanks: Arielle, When LL comes up with some new thing it doesn't mean that the OpenSim code and viewers will immediately implement that latest feature. You should know that by now.
| |
| [12:48 PM PT] Arielle Popstar: and Opensim chooses to follow sl's footsteps
| |
| [12:48 PM PT] Cuga.Rajal @rajal.org:9000: no, there is a calculated evaluation first
| |
| [12:49 PM PT] Ubit Umarov: yes, they only added it to AIS code paths
| |
| [12:49 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: Orbert, I hear what you say about telling me what needs doing, my point is that that is a good starting point, but I worry thay it doen not seem to have a high prioity, we have residents worried about the future of voice?
| |
| [12:49 PM PT] Arielle Popstar: to see if it is convenient for the devs and not too nmuch work?
| |
| [12:49 PM PT] Ubit Umarov: not to the llUPD ones
| |
| [12:49 PM PT] Gavin.Hird @grid.xmir.org:8002: right, so we are not going to have AIS support - probalby ever Arielle
| |
| [12:50 PM PT] Andrew Hellershanks: Can we drop this for now? We are near the top of the hour.
| |
| [12:50 PM PT] Arielle Popstar: tAIS?
| |
| [12:50 PM PT] Arielle Popstar: AIS?
| |
| [12:50 PM PT] Orbert.Tatham @hg.zetaworlds.com: Cliff, voice is something that you are worried about - the current server/backend venddor has chosen to raise prices beyond your pain threshold, but we can't fix that
| |
| [12:50 PM PT] Gavin.Hird @grid.xmir.org:8002: yesw AIS, LL's inventory interface API
| |
| [12:50 PM PT] Andrew Hellershanks: I would like to have Lyr give us an update about the upcoming OSCC event that is now just a few weeks away.
| |
| [12:50 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: I do need to heads out very soon, it is not a reflection on this meeting
| |
| [12:51 PM PT] Andrew Hellershanks: If everyone will hold off on further comments for the moment. Go ahead Lyr.
| |
| [12:51 PM PT] Lyr Lobo: Great! The community conference is Dec 9-10 with a starting party at noon on Friday, the 8th
| |
| [12:51 PM PT] Andrew Hellershanks: (I'll brb. RL is calling)
| |
| [12:51 PM PT] Lyr Lobo: we have 30 sessions from 7 am until 6 pm and dancing in the venings
| |
| [12:51 PM PT] Lyr Lobo: thanks, Andrew
| |
| [12:51 PM PT] Lyr Lobo: Core Dev speaks at 7 am on the 9th and we have a VIP Core Dev session at 11:45 on that saturday. The Viewer panel is right after it
| |
| [12:52 PM PT] Arielle Popstar: whats the theme?
| |
| [12:52 PM PT] Lyr Lobo: We have quite a few research, education, entertainment, and the arts sessions as well as a few tool integrations with other worlds and technologies
| |
| [12:52 PM PT] Lyr Lobo: It is the OpenSimulator Community Conference, so all topics related to Opensim are welcome, including the future, ARielle
| |
| [12:53 PM PT] Lyr Lobo: Unlike my other conferences, we do not limit it to a theme
| |
| [12:53 PM PT] Arielle Popstar: in past there was a particular theme
| |
| [12:53 PM PT] Lyr Lobo: in 2015, we did 5 tracks
| |
| [12:53 PM PT] Arielle Popstar: ok
| |
| [12:53 PM PT] Lyr Lobo: for business, technology, research, education, creativity and the arts
| |
| [12:53 PM PT] Lyr Lobo: but they ran at the same time
| |
| [12:53 PM PT] Lyr Lobo: this way, everything is visible to all from the 4 regions on the OSCC Keynotes
| |
| [12:54 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: thanks everyone, i will read the logs to find more on the conf
| |
| [12:54 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: ty Lyr
| |
| [12:54 PM PT] Lyr Lobo: the program is being developed and will be online in a couple of weeks. Here's the link to register
| |
| [12:54 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: thanks everyone
| |
| [12:54 PM PT] Lyr Lobo: https://conference.opensimulator.org/
| |
| [12:54 PM PT] Lyr Lobo: come join us *grins* It is not a community without you
| |
| [12:54 PM PT] Clifford.Hanger @alternatemetaverse.com:8002: bye
| |
| [12:54 PM PT] Lyr Lobo: bye Clifford
| |
| [12:55 PM PT] Lyr Lobo: This is our 11th year
| |
| [12:55 PM PT] Lyr Lobo: our goal is to strengthen the community, see what everyone is doing and where we are growing
| |
| [12:56 PM PT] Lyr Lobo: Maria will have a State of the Metaverse results, but we need more people to participate in it
| |
| [12:56 PM PT] Lyr Lobo: from Hypergrid Business, she hosts a survey
| |
| [12:57 PM PT] Cuga.Rajal @rajal.org:9000: Looking forward to that
| |
| [12:57 PM PT] Lyr Lobo: We are excited to have everyone participate *grins*
| |
| [12:57 PM PT] Lyr Lobo: a few new releases will be unveiled at the conference. Will let the presenters share that
| |
| [12:59 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Back on topic of weekly updates and things, we had a mantis ticket come in that seems to show migrations not running properly between updates
| |
| [12:59 PM PT] Vincent.Sylvester @hg.zetaworlds.com: This has me digging into that again thinking perhaps it might be a good idea to add a check to startup to verify table schema
| |
| [12:59 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Didn't help that the wiki is out of date on the table schema, but that is an easy fix
| |
| [1:00 PM PT] Ubit Umarov: the invalid cast issue?
| |
| [1:00 PM PT] Cuga.Rajal @rajal.org:9000: def good idea to check table schema on startup
| |
| [1:00 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Yeah that
| |
| [1:01 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Turns out the double to float part of that table migration never ran or somehow got missed
| |
| [1:01 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Not sure how, but I been looking at migrations being a sort of fire and forget affair in the first place
| |
| [1:01 PM PT] Vincent.Sylvester @hg.zetaworlds.com: If you have a broken table when it tries to run it'll make a bigger mess
| |
| [1:02 PM PT] Vincent.Sylvester @hg.zetaworlds.com: I did look into ways in sql to "if field not exist add it" instead of just blindly adding it, but that's only really a bandaid me thinks
| |
| [1:02 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Telling the user "hey the table doesn't match what I need" might prevent this
| |
| [1:03 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Should not be too hard to implement either, run some sql to get table schema and compare it, error if mismatch
| |
| [1:04 PM PT] Ubit Umarov: no idea.. those migrtations did work fine
| |
| [1:04 PM PT] Vincent.Sylvester @hg.zetaworlds.com: They usually do as well I agree
| |
| [1:04 PM PT] Gavin.Hird @grid.xmir.org:8002: did you test in MariaDB or "real" MySQL Vincent?
| |
| [1:05 PM PT] Vincent.Sylvester @hg.zetaworlds.com: I did not test this. It was what I found through the ticket and comparing what the migrations do that I found the field type mismatch
| |
| [1:05 PM PT] Gavin.Hird @grid.xmir.org:8002: ah, ok
| |
| [1:06 PM PT] Vincent.Sylvester @hg.zetaworlds.com: I been looking at migrations in the past thinking there has to be a better way to migrate things or at least have it check before adding fields to tables
| |
| [1:06 PM PT] Gavin.Hird @grid.xmir.org:8002: Has anyone tried MySQL 8.1 yet?
| |
| [1:06 PM PT] Lyr Lobo: : There is a behind the scenes look at our events
| |
| [1:06 PM PT] Lyr Lobo: Not the program, my planning view
| |
| [1:06 PM PT] Vincent.Sylvester @hg.zetaworlds.com: When I moved to dotnet for some regions I did have one fail because I had altered the table for another test and as a result the migrations failed and then all hell broke loose
| |
| [1:07 PM PT] Vincent.Sylvester @hg.zetaworlds.com: I did find some sql for "if not exist create" rather than just create
| |
| [1:07 PM PT] Andrew Hellershanks: (I'm back)
| |
| [1:08 PM PT] Cuga.Rajal @rajal.org:9000: would a schema check at startup simplify the process?
| |
| [1:09 PM PT] Vincent.Sylvester @hg.zetaworlds.com: What it would do is if there is no table at all just create it from a sql file directly, no need to do the whole migration thing. If the table schema doesn't match just stop startup and tell the user something is wrong
| |
| [1:09 PM PT] Andrew Hellershanks: Vincent, there is also an INSERT IGNORE option for loading tables with data.
| |
| [1:10 PM PT] Andrew Hellershanks: Vincent, that could be useful. One would certainly hope the database schema matches what is expected for the migration levels of the various tables.
| |
| [1:11 PM PT] Cuga.Rajal @rajal.org:9000: it could avoid data corruption and Mantis tickets :)
| |
| [1:11 PM PT] Vincent.Sylvester @hg.zetaworlds.com: My ultimate plan for this would be a system that checks the "state" of a table and only run the migrations it needs and otherwise fail if it cannot correct the table to the proper structure.
| |
| [1:12 PM PT] Vincent.Sylvester @hg.zetaworlds.com: "Detected table version X, will run migrations..." "Could not update table schema" "Malformed table structure, please correct" type deal
| |
| [1:12 PM PT] Gavin.Hird @grid.xmir.org:8002: Isn't that what the migrations table is for. If a migration set is already at the latest level it does nothing?
| |
| [1:12 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Yes
| |
| [1:12 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Problem is it can blindly run even if the sql fails to execute and set migrations as done
| |
| [1:12 PM PT] Orbert.Tatham @hg.zetaworlds.com: I assume there is no field in a table somewhere that has the version of the database. Perhaps that would make a useful addition also?
| |
| [1:13 PM PT] Vincent.Sylvester @hg.zetaworlds.com: That's in the migrations table
| |
| [1:13 PM PT] Orbert.Tatham @hg.zetaworlds.com: So is it not showing the correct version that is causing this problem?
| |
| [1:14 PM PT] Gavin.Hird @grid.xmir.org:8002: the migration and setting the level per migration should be in a transaction then so if the transaction fails, the migration level is not incremented?
| |
| [1:14 PM PT] Andrew Hellershanks: If it updates the migrations table even if the SQL statements doing the migrations fail that is a problem that needs to be fixed.
| |
| [1:15 PM PT] Gavin.Hird @grid.xmir.org:8002: but maybe setting the migration level is done in code and not SQL?
| |
| [1:15 PM PT] Orbert.Tatham @hg.zetaworlds.com: The migration also needs to be atomic, with a rollback if it fails part way through
| |
| [1:15 PM PT] Cuga.Rajal @rajal.org:9000: do you run into the issue of different DBs (postgres, Maria, etc) requiring diff migration SQL?
| |
| [1:15 PM PT] Orbert.Tatham @hg.zetaworlds.com: All in one TRANSACTION
| |
| [1:15 PM PT] Gavin.Hird @grid.xmir.org:8002: exactly Orbert
| |
| [1:15 PM PT] Andrew Hellershanks: That is how I would expect it to work, Orbert.
| |
| [1:16 PM PT] Vincent.Sylvester @hg.zetaworlds.com: If the migration level in migrations table is lower it runs the migrations to bring it up to date, that is the plan at least
| |
| [1:16 PM PT] Vincent.Sylvester @hg.zetaworlds.com: However if those migrations fail it just continues bootup regardless
| |
| [1:16 PM PT] Vincent.Sylvester @hg.zetaworlds.com: It doesn't check at the end if the table is now in the proper format
| |
| [1:16 PM PT] Cuga.Rajal @rajal.org:9000: seems stopping startup on fail would be better
| |
| [1:16 PM PT] Ubit Umarov: well he has several fields as DOUBLE when there was a migration changing those to flOAT
| |
| [1:17 PM PT] Gavin.Hird @grid.xmir.org:8002: but each tmigration should be in a transaction where the last commit is updating the migration table. If anything in the transaction fails, it should be rolled back and the migration stopped
| |
| [1:17 PM PT] Ubit Umarov: possible he had a crash during that migration, and it is flaged as done, and wasn't ?
| |
| [1:17 PM PT] Orbert.Tatham @hg.zetaworlds.com: If we fail to start up, we need to supply the users with some sort of tool to fix the problem, too
| |
| [1:17 PM PT] Andrew Hellershanks: Cuga, there are different migration files for different database systems.
| |
| [1:17 PM PT] Cuga.Rajal @rajal.org:9000: ah ok
| |
| [1:18 PM PT] Vincent.Sylvester @hg.zetaworlds.com: I wanted to include a message that states where the schema diverges and direct them to examine their database and manually make the adjustments according to a structure sql file
| |
| [1:18 PM PT] Vincent.Sylvester @hg.zetaworlds.com: Or well, output the proper schema vs what they have something like that
| |
| [1:19 PM PT] Andrew Hellershanks: Orbert, Another thing I've been wanting to implement is to fail startup if it can't connect to the database when it tries to use the connection strings. | | [1:19 PM PT] Andrew Hellershanks: Orbert, Another thing I've been wanting to implement is to fail startup if it can't connect to the database when it tries to use the connection strings. |
| [1:19 PM PT] Orbert.Tatham @hg.zetaworlds.com: Yeah, that is what I was thinking | | [1:19 PM PT] Orbert.Tatham @hg.zetaworlds.com: Yeah, that is what I was thinking |
