[Opensim-dev] Added fields to OpenSim tables

[Frisby, Adam]

Try it ten times, and it will work.

It loops through the list of connections, it will have to reset all of them before it gets one that works again.


Adam

> -----Original Message-----
> From: opensim-dev-bounces at lists.berlios.de [mailto:opensim-dev-
> bounces at lists.berlios.de] On Behalf Of Mic Bowman
> Sent: Monday, 1 September 2008 10:46 AM
> To: opensim-dev at lists.berlios.de
> Subject: Re: [Opensim-dev] Added fields to OpenSim tables
>
> i'm just getting an exception thrown right now (reading the mysql
> stream fails because the connection was closed). if there is an
> attempt at reconnection, it must fail because all future login
> attempts fail. note that i don't appear to see this problem with
> grid/asset/inventory, but that could just be because i can't get
> logged in (or some other background thread continues to touch the
> database).
>
> --mic
>
>
> On Mon, Sep 1, 2008 at 10:39 AM, Frisby, Adam <adam at deepthink.com.au>
> wrote:
> > It should reconnect the individual thread in question - it won't
> reconnect all of them however (and if they timeout, they will all
> timeout at once). Maybe that needs to be fixed? Otherwise you will have
> 10 disconnects before it all reconnects.
> >
> > Adam
> >
> >> -----Original Message-----
> >> From: opensim-dev-bounces at lists.berlios.de [mailto:opensim-dev-
> >> bounces at lists.berlios.de] On Behalf Of Mic Bowman
> >> Sent: Monday, 1 September 2008 10:07 AM
> >> To: opensim-dev at lists.berlios.de
> >> Subject: Re: [Opensim-dev] Added fields to OpenSim tables
> >>
> >> not sure if this is related... but the connection re-establishment
> >> code in mysql seems to have broken with the multithreaded fix. i'm
> not
> >> in a position to debug any time soon, but if no one gets to it i'll
> >> probably have a look later this week.
> >>
> >> --mic
> >>
> >>
> >> On Sun, Aug 31, 2008 at 12:31 PM, Teravus Ovares <teravus at gmail.com>
> >> wrote:
> >> > One of those bugs is:
> >> >
> >> > http://opensimulator.org/mantis/view.php?id=2048
> >> >
> >> > Best Regards
> >> >
> >> > Teravus
> >> >
> >> >
> >> > On 8/31/08, Homer Horwitz <homerhorwitz at googlemail.com> wrote:
> >> >>
> >> >> That particular field was added by a patch done by me. I paid
> >> special
> >> >> attention to backwards-compatibility (if you don't have that
> field
> >> or
> >> >> it's LLUUID.Zero, the old way of computing home-location, via
> >> >> region-handle instead of region-id, is used. So, if there are any
> >> >> problems, I'd consider them a bug and would like to have some
> mantis
> >> +
> >> >> logs, please.
> >> >>
> >> >> Homer
> >> >>
> >> >> On Sun, Aug 31, 2008 at 6:32 PM, Charles Krinke <cfk at pacbell.net>
> >> wrote:
> >> >> > I need to back off my "many accounts" and change it to "a few
> >> accounts".
> >> >> > I
> >> >> > was relying on reports from others.
> >> >> >
> >> >> > But, my point is not the failure being reported, but the fact
> that
> >> I
> >> >> > would
> >> >> > really, really appreciate a wiki paragraph whenever a field is
> >> added to
> >> >> > any
> >> >> > table in OpenSim so that existing users, grids and early
> adopters
> >> can
> >> >> > more
> >> >> > easily move forward.
> >> >> >
> >> >> > In addition, this has the added benefit of making our
> >> documentation more
> >> >> > complete, so it is a win-win situation.
> >> >> >
> >> >> > Charles
> >> >> >
> >> >> > ----- Original Message ----
> >> >> > From: "Frisby, Adam" <adam at deepthink.com.au>
> >> >> > To: "opensim-dev at lists.berlios.de" <opensim-
> dev at lists.berlios.de>
> >> >> > Sent: Sunday, August 31, 2008 4:12:19 PM
> >> >> > Subject: Re: [Opensim-dev] Added fields to OpenSim tables
> >> >> >
> >> >> > It may be possible that the multithreading patch I did could be
> >> having
> >> >> > some
> >> >> > impact here - perhaps there's something dependant or relying on
> a
> >> >> > particular
> >> >> > order of operations? (I cant think of anything myself, but that
> >> doesn't
> >> >> > preclude the possibility)
> >> >> >
> >> >> >
> >> >> >
> >> >> > Adam
> >> >> >
> >> >> >
> >> >> >
> >> >> > From: opensim-dev-bounces at lists.berlios.de
> >> >> > [mailto:opensim-dev-bounces at lists.berlios.de] On Behalf Of
> Charles
> >> >> > Krinke
> >> >> > Sent: Sunday, 31 August 2008 8:55 AM
> >> >> > To: opensim-dev at lists.berlios.de
> >> >> > Subject: [Opensim-dev] Added fields to OpenSim tables
> >> >> >
> >> >> >
> >> >> >
> >> >> > I really dont like to complain as it tends to inhibit forward
> >> motion,
> >> >> > but
> >> >> > this morning several folks are spending time working on the
> fact
> >> that
> >> >> > many
> >> >> > accounts cannot log onto OSGrid and I suspect this problem
> affects
> >> other
> >> >> > grids as well.
> >> >> >
> >> >> > It seems there are a number of recently added fields in our
> >> OpenSim
> >> >> > tables.
> >> >> > Lets concentrate on homeRegionID for a minute.
> >> >> >
> >> >> > I am told that 20% of the logins to OSGrid are failing this
> >> morning
> >> >> > becuase
> >> >> > this field is all zeros for existing accounts. Certainly, the
> grid
> >> >> > admin's
> >> >> > can set this field to some value, such as a plaza. But, that is
> >> not my
> >> >> > issue.
> >> >> >
> >> >> > My issue is a request that when new fields are added to tables
> in
> >> >> > OpenSim
> >> >> > that the adder of the new field add a paragraph to our wiki
> >> explaining
> >> >> > what
> >> >> > this change is and offer enough data so that existing grids can
> >> >> > accomodate
> >> >> > side affects with existing users.
> >> >> >
> >> >> > This morning, I look closely at the users table and I can see
> five
> >> >> > fields
> >> >> > added since the last time I looked closely. These five fields
> are
> >> >> > homeRegionID, userFlags, godLevel, customType and partner.
> There
> >> may be
> >> >> > other fields added to other tables. I dont know offhand.
> >> >> >
> >> >> > All I am requesting is that when fields are added to our tables
> >> that
> >> >> > some
> >> >> > sort of trail of clues is left on our wiki to help our users
> and
> >> early
> >> >> > adopters move forward.
> >> >> >
> >> >> > Charles
> >> >> >
> >> >> > _______________________________________________
> >> >> > Opensim-dev mailing list
> >> >> > Opensim-dev at lists.berlios.de
> >> >> > https://lists.berlios.de/mailman/listinfo/opensim-dev
> >> >> >
> >> >> >
> >> >> _______________________________________________
> >> >> Opensim-dev mailing list
> >> >> Opensim-dev at lists.berlios.de
> >> >> https://lists.berlios.de/mailman/listinfo/opensim-dev
> >> >
> >> >
> >> > _______________________________________________
> >> > Opensim-dev mailing list
> >> > Opensim-dev at lists.berlios.de
> >> > https://lists.berlios.de/mailman/listinfo/opensim-dev
> >> >
> >> >
> >> _______________________________________________
> >> Opensim-dev mailing list
> >> Opensim-dev at lists.berlios.de
> >> https://lists.berlios.de/mailman/listinfo/opensim-dev
> > _______________________________________________
> > Opensim-dev mailing list
> > Opensim-dev at lists.berlios.de
> > https://lists.berlios.de/mailman/listinfo/opensim-dev
> >
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev