1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Greetings Guest!!

    In order to combat SPAM on the forums, all users are required to have a minimum of 2 posts before they can submit links in any post or thread.

    Dismiss Notice

NEWS [UO.Com] Publish Day to all Shards

Discussion in 'UHall' started by UO News, Mar 20, 2014.

  1. UO News

    UO News RSS Feed
    RSS Feed Stratics Veteran

    Joined:
    Jan 30, 2009
    Messages:
    1,174
    Likes Received:
    1,258
    Patch Notes
    2014 Mar 20 16:03 GMT
    Greetings everyone,

    We will be taking all the shards except for Origin and Izumo down today at approx 1:30 for approx 3 hours. If your shard has not gone thru your normal maintenance cycle it will not be going thru one consider this your cycle for the day.

    We will be publishing all the items from Publish 85.4 to all shards today with the addition of one client fix to the classic client that was causing the client to hang up when you tried to exit out of the client while preforming a seach. You will now be able to right click anywhere on the game screen to access the exit gump.

    We hope you enjoy Vendor Search and look forward to any feedback you may have. Talk to you soon!

    UO Team

    Continue reading...
     
    G.v.P, startle, Storm and 5 others like this.
  2. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    Setting up my vendors now!
     
  3. DJAd

    DJAd Stratics Legend
    Stratics Veteran

    Joined:
    Aug 17, 2007
    Messages:
    7,929
    Likes Received:
    3,574
    Busy weekend then!
     
  4. Rieley

    Rieley Journeyman
    Stratics Veteran

    Joined:
    Jul 2, 2008
    Messages:
    108
    Likes Received:
    83
    Thank you I read that bug, nice communication and service.
     
  5. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    Yep... I thought that was a quick turnaround on the vendor search window.

    Here's to hoping more open communications with us the players and quick response on reported bugs. :pint:
     
  6. Ludes

    Ludes Babbling Loonie
    Stratics Veteran Alumni Stratics Legend

    Joined:
    Feb 25, 2004
    Messages:
    2,382
    Likes Received:
    648
    So for those of us that have never tried it yet.. how do you do it?
     
  7. Dr Hawk

    Dr Hawk Adventurer

    Joined:
    Feb 24, 2014
    Messages:
    96
    Likes Received:
    70
    I'm still waiting for the patch that will reduce the lag.
     
    Rieley, xxrod17xx and Promathia like this.
  8. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    Glad I reported that bug - best turnaround on a non crasher that I've ever seen from UO! :)
     
    Rieley likes this.
  9. startle

    startle Siege... Where the fun begins.
    Stratics Veteran Stratics Legend Gilfane

    Joined:
    Feb 29, 2004
    Messages:
    3,279
    Likes Received:
    1,263
    It's been a long time comin', and has no doubt been a challenge for the team. Thank you very much for persevering and making it happen. Oh, and CONGRATULATIONS !:danceb:
     
    Rhiannon likes this.
  10. Promathia

    Promathia EM Bennu Fanclub
    Premium Stratics Veteran

    Joined:
    Aug 30, 2009
    Messages:
    3,425
    Likes Received:
    2,114
    I cant seem to get the Vendor Search to work on Atlantic. It just hangs at the please wait, and never brings up any results.
     
    Nails Warstein likes this.
  11. Storm

    Storm UO Forum Moderator
    Moderator Professional Premium Wiki Moderator Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2004
    Messages:
    7,469
    Likes Received:
    361
    You right click on your picture/health bar and select vendor search
     
    Ludes likes this.
  12. Uriah Heep

    Uriah Heep Crazed Zealot
    Stratics Veteran Alumni

    Joined:
    May 26, 2008
    Messages:
    3,813
    Likes Received:
    2,330
    When does the plaque show up at the banks?
     
  13. Storm

    Storm UO Forum Moderator
    Moderator Professional Premium Wiki Moderator Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2004
    Messages:
    7,469
    Likes Received:
    361
    mine is doing same thing but i think they said it could take up to 3 hours before all the vendors are in the system...I may be wrong
     
  14. flappy6

    flappy6 Sage
    Stratics Veteran Stratics Legend

    Joined:
    Jan 17, 2005
    Messages:
    605
    Likes Received:
    141
    this search thing looks like it was made in the 80's, sorry just being honest
     
    Cetric, Nails Warstein and kRUXCg7 like this.
  15. Ludes

    Ludes Babbling Loonie
    Stratics Veteran Alumni Stratics Legend

    Joined:
    Feb 25, 2004
    Messages:
    2,382
    Likes Received:
    648
    Thank you.
     
    Storm likes this.
  16. Storm

    Storm UO Forum Moderator
    Moderator Professional Premium Wiki Moderator Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2004
    Messages:
    7,469
    Likes Received:
    361
    That was when I started playing ultima :)
     
  17. Smoot

    Smoot Grand Poobah
    Stratics Veteran

    Joined:
    Nov 17, 2009
    Messages:
    6,754
    Likes Received:
    3,543
    Well... looks like vendor search is broken. i tried 2 characters. same thing.

    vendor search was white, i was in my house, i brought up the menue and typed something in
    got a messege that "i must be in justice region or my hour or a inn" (i was in my house)
    now vendor search under menue is grey and i cant access it at all.

    So i guess its broken. lol
     
    Nails Warstein likes this.
  18. DJAd

    DJAd Stratics Legend
    Stratics Veteran

    Joined:
    Aug 17, 2007
    Messages:
    7,929
    Likes Received:
    3,574
    Please wait for your search to complete......Then takes about a minute before kicking me back to the first screen to search again.
     
  19. Kyronix

    Kyronix UO Designer
    VIP

    Joined:
    Aug 24, 2012
    Messages:
    1,039
    Likes Received:
    2,606
    Players will not see these improvements for the first 3 hours until the data base has been rebuilt.
     
  20. Storm

    Storm UO Forum Moderator
    Moderator Professional Premium Wiki Moderator Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2004
    Messages:
    7,469
    Likes Received:
    361
    That is what I thought thank you for confirming
     
  21. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    @Kyronix, even though they were already published, are you guys also rebuilding the indexes on Origin and Izumo? Getting no results at all on Izumo at the moment.
     
    #21 BrianFreud, Mar 20, 2014
    Last edited: Mar 20, 2014
  22. Larisa

    Larisa Reporting Manager
    Editor Reporter Moderator Professional Wiki Moderator Stratics Veteran Stratics Legend Editor Fallen Lords

    Joined:
    Sep 8, 2006
    Messages:
    4,325
    Likes Received:
    1,925
    Same for Origin, Vendor Search just keeps bringing me back to the main screen after a search.
     
  23. Bleak

    Bleak UO Software Engineer
    VIP Stratics Veteran

    Joined:
    Feb 18, 2010
    Messages:
    369
    Likes Received:
    720
    This will be resolved after the database has been populated by the newly published shards.
     
  24. startle

    startle Siege... Where the fun begins.
    Stratics Veteran Stratics Legend Gilfane

    Joined:
    Feb 29, 2004
    Messages:
    3,279
    Likes Received:
    1,263
    Thanks for the continuing clarification, Bleak... This is gonna be great!;)
     
  25. 4gregu

    4gregu Slightly Crazed
    Stratics Veteran Stratics Legend

    Joined:
    Feb 25, 2004
    Messages:
    1,399
    Likes Received:
    520
    This is the longest 3 hours in history ;)
     
  26. MissEcho

    MissEcho Slightly Crazed
    Stratics Veteran

    Joined:
    May 14, 2008
    Messages:
    1,427
    Likes Received:
    765
    Oceania has no Broadsword pick up at the bank, there is one on Atlantic, is there some delay on this per shard?

    Is this three hour wait for the vendor search to work from the time the shard came up? or is it per account to 'build' the data base, and if so surely you don't have to be logged in for three hours?
     
  27. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    I'm getting search results for Balhae searches, but it's taking roughly 17 minutes from when I click "search" before I get a window of results... and if I try to load more results, it bombs out.

    EDIT: 17 minutes per search was doing a simple name search. Next I tried the slightly harder "price 0-100000"; clicked search at 10:19:19, got results at 10:45:20, so a wait of 26 minutes 1 second... Something tells me the search SQL needs some serious tuning and love... :)
     
    #27 BrianFreud, Mar 20, 2014
    Last edited: Mar 20, 2014
  28. old gypsy

    old gypsy Grand Poobah
    Professional Stratics Veteran Campaign Patron PITMUCK

    Joined:
    Dec 18, 2010
    Messages:
    5,836
    Likes Received:
    5,274
    I must be doing something wrong. I put in the item name, search, wait a few minutes, then go back to the original screen with no results at all. I know I'm a slow study sometimes, but I didn't think I was this slow!
     
    #28 old gypsy, Mar 20, 2014
    Last edited: Mar 21, 2014
  29. Bobar

    Bobar Babbling Loonie
    Stratics Veteran Stratics Legend

    Joined:
    May 20, 2004
    Messages:
    2,043
    Likes Received:
    577
    I get something similar and don't get any results - last time I tried it (in my house) it told me I needed to be in my house. Go figure!
     
  30. Smoot

    Smoot Grand Poobah
    Stratics Veteran

    Joined:
    Nov 17, 2009
    Messages:
    6,754
    Likes Received:
    3,543
    it just doesnt work. times out every time for me. hopefully it will be fixed soon enough.
     
  31. Tomarke

    Tomarke Seasoned Veteran
    Stratics Veteran D^A

    Joined:
    Oct 22, 2011
    Messages:
    373
    Likes Received:
    182
    Same here, no worky...
     
  32. Bleak

    Bleak UO Software Engineer
    VIP Stratics Veteran

    Joined:
    Feb 18, 2010
    Messages:
    369
    Likes Received:
    720
    We are aware of the timeout issue. I'm investigating.
     
    startle, Tomarke, OvenBird and 3 others like this.
  33. Storm

    Storm UO Forum Moderator
    Moderator Professional Premium Wiki Moderator Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2004
    Messages:
    7,469
    Likes Received:
    361
    Thanks again bleak
     
  34. Dol'Gorath

    Dol'Gorath Grand Inquisitor
    Stratics Veteran Stratics Legend

    Joined:
    Mar 18, 2003
    Messages:
    4,331
    Likes Received:
    238
    Thank you for vendor search devs! =]
     
    startle and Storm like this.
  35. MissEcho

    MissEcho Slightly Crazed
    Stratics Veteran

    Joined:
    May 14, 2008
    Messages:
    1,427
    Likes Received:
    765
    sorry but this vendor search is not working on Oceania at all. Shard has been up for well over 12 or more hours since the easter gifts came in, and i have yet to 'see' the results screen. All I get is a box saying please wait while we search, then it reverts to the original search screen then nothing. I have yet to see a 'result' screen. I am searching for Essence Of Order which I can 'see' on a vendor to test it. I have tried it as written which is the actual title on the item, also in all lower case in case it is case sensitive. I know the stuff is there as I am looking at it.

    Seems vendor search is totally FUBAR on our shard.

    Someone else said they ran a search and 4 hours later a result screen came up. But everyone else I have asked says they get NOTHING, the same as me.

    EDIT: Ok, after starting a search again for the 20th time, after 45-50 minutes later just as I am logging out I finally got a 'result' screen. I got the map, went to the vendor, and then tried to return. It says please 'accept' to return to where I came from, only thing is there is NO accept button, on the gump, just a 'create waypoint here' Trammel or Felucca button. Even tho I was in Tokuno. (I am in the EC (with pinko's))
     
    #35 MissEcho, Mar 21, 2014
    Last edited: Mar 21, 2014
  36. MissEcho

    MissEcho Slightly Crazed
    Stratics Veteran

    Joined:
    May 14, 2008
    Messages:
    1,427
    Likes Received:
    765
    You may find, like I did, if you WAIT for close to an hour or more without logging your char out you might get a result screen. LOL, just hope you don't want to search for half a dozen items you will need a packed lunch and sleeping bag in front of your computer.

    Pretty dismal, why do we have 'origin' isn't this stuff supposed to be tested on that shard before it goes to everyone?
     
  37. Promathia

    Promathia EM Bennu Fanclub
    Premium Stratics Veteran

    Joined:
    Aug 30, 2009
    Messages:
    3,425
    Likes Received:
    2,114
    It was working fine on Origin.
     
  38. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    It worked fine on Origin and TC... BEFORE they put a patch in for the CC stuck search gump. Perhaps the changed code should have been tested on TC/Origin before pushing to full production shards. Anything that gets changed should be tested on TC/Origin first.
     
    Prose Edda likes this.
  39. MissEcho

    MissEcho Slightly Crazed
    Stratics Veteran

    Joined:
    May 14, 2008
    Messages:
    1,427
    Likes Received:
    765
    How long is the search 'supposed' to take. I mean at the moment on Oceania waiting nearly an hour to get the results of ONE search is not gonna fly. When I price stuff and want a comparison guide I may want to price 20-30 items in an hour, not ONE. The way it is working at the moment it would take me 30 hours and there are only 24 in a day.

    Is it supposed to be in the time it would take a web page to load normally? If so is it that quick on your shards?

    One guy waited 4 hours for one of his searches to appear. It is unusable as it is right now.
     
  40. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    I don't think the problem has anything to do with the client patch. I think this was untestable until it hit all shards; the database with just Origin and Izumo was quite small - neither has much of a vendor population. Then 23 other shards, including Atlantic were added, and that database is suddenly exponentially larger. Thus searches which were quick on a small dataset suddenly bog down on a massively larger dataset.
     
  41. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    Nonsense.

    The vendor search is supposed to search only one shard - the one your character is on. Test Center used Atlantic for the vendor search tests, so your point about Origin and Izumo databases being small doesn't quite hold up. There is no reason to believe that the database increased exponentially, unless for some reason the code is searching all shards on a single cloud server - which isn't supposed to happen.
     
  42. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    Something is obviously broken. Searches on TC which used the Atlantic database only took about 10 seconds to complete. It was very fast.
     
    Tjalle likes this.
  43. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    You're assuming that each shard is a separate database. I'm not; I'm assuming everything's in a single database, and that each item simply has a shard column as one of its fields. That'd explain why Iz and Origin stopped working yesterday, if they had to be rebuilt into this master dataset at the same time as all of the other shards' data. My guess is that the code is doing exactly as you suggest - searching across all shards, and only then limiting down that results set to the specific shard's results. Either that, or it's doing an AND search, with the shard field as one of the components of that initial search, in which case it still would be searching through everything, it'd just be the database engine itself doing the filtering before it ever returned a results set.

    Personally, I doubt it'll be made public, but I'd be REALLY interested to see the schema being used behind the scenes here. :D
     
  44. MissEcho

    MissEcho Slightly Crazed
    Stratics Veteran

    Joined:
    May 14, 2008
    Messages:
    1,427
    Likes Received:
    765
    I rarely go to the test center as the lag totally kills me, just trying to open a pack or move an item is excruciating and walking/moving around is hopeless, so generally need to rely on the US players to actually 'test' stuff. Glad to know that it is supposed to be quick and just hope they work out and fix what is making it impossible and unusable right now.
     
  45. BrianFreud

    BrianFreud Lead Wiki Mod & Doer of Crazy Things
    Professional Wiki Editor Wiki Moderator Campaign Supporter

    Joined:
    Oct 2, 2013
    Messages:
    7,080
    Likes Received:
    2,907
    When did test use a database based on Atlantic? I only ever saw it using Great Lakes (and only Great Lakes) as a source.
     
  46. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    If you are correct, and I pray to God that you are wrong, then there is no hope for the vendor search and the original developer who designed that system should be ridiculed and someone should post disparaging remarks on their Facebook page. I can't imagine anyone who would design code like that.

    I hope you are wrong!
     
  47. Winter

    Winter Lore Keeper

    Joined:
    Mar 19, 2013
    Messages:
    996
    Likes Received:
    716
    *scratches head* Okay, you could be correct about that. I don't play Atlantic or GL, so created a new character for TC.
     
  48. The Zog historian

    The Zog historian Babbling Loonie
    Stratics Veteran

    Joined:
    Feb 25, 2010
    Messages:
    2,165
    Likes Received:
    870
    It couldn't have been said better! There's no reason that, when shards are separate and distinct with regard to characters, items and houses, that their vendor databases would be joined. It unnecessarily overcomplicates things. And even if someone who shouldn't be doing database architecture threw together a massive one, when things should have been kept discrete, the most basic query (SQL or whatever) is still not that slow when returning results. At least, it shouldn't be...
     
  49. Arroth Thaiel

    Arroth Thaiel Seasoned Veteran
    Stratics Veteran Stratics Legend

    Joined:
    Feb 10, 2006
    Messages:
    331
    Likes Received:
    264

    Unless you purposefully set it up that way for future use. Why build 24 (however many shards there are) separate databases, when you can just build and maintain 1.

    If you eventually plan on merging shards, you wouldn't have to merge databases.

    If you eventually plan on allowing cross shard searching (or purchasing), the database would already be built.

    If you wanted to open a player run item store, and take say 10% of all sales, the database would already be present.

    Maybe a single database for all UO data is actually future proofing???
     
    Lorax_Pacific and BrianFreud like this.
  50. the_gooch

    the_gooch Lore Keeper
    Stratics Veteran

    Joined:
    Feb 4, 2005
    Messages:
    873
    Likes Received:
    98
    Any idea when Vendor Search is supposed to start working?
     
    Prose Edda likes this.