[Opensim-dev] Added fields to OpenSim tables

[Mic Bowman]

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
>