[Opensim-dev] Added fields to OpenSim tables

[Mic Bowman]

a few of the attachment calls in the mysql user code were not calling
checkconnection. i'm testing a patch that fixes that problem. will see
if it solves the db connection timeout issues.

--mic


On Mon, Sep 1, 2008 at 10:53 AM, Frisby, Adam <adam at deepthink.com.au> wrote:
> 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
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>