Pages: 1 [2] 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Mithfindel
Aseyakone
|
Posted - 2010.03.02 22:57:00 -
[31]
Edited by: Mithfindel on 02/03/2010 22:57:56
Originally by: Jason Edwards I see alot of "our vendor"
microsoft? cisco?
IIRC, Microsoft SQL Server 2008.
Edit: Time to don the asbestos suit, I guess.
|
Camios
Minmatar Insurgent New Eden Tribe Systematic-Chaos
|
Posted - 2010.03.02 23:01:00 -
[32]
As far as I can remember, CCP relied on Microsoft for MSSQL support. It sounded a good strategy, Microsoft would take of their product and help CCP that would only think about their game.
Now it's a bit strange, it's CCP helping microsoft.
BECAUSE OF MICROSOFT
|
Aalaria Black
Rogen's Heroes
|
Posted - 2010.03.02 23:18:00 -
[33]
Alot of people are pointing fingers at the database software when it could easily be the high availability software (like ServiceGuard on HPUX) that is falsely detecting a condition that causes it to initiate the fail over to the other cluster. Maybe a clock got off by a few seconds, maybe a cluster member failed to respond to a health check ping due to network issues ... there could be quite a number of reasons why a monitor decides to kick off a fail over sequence.
food for thought.
|
Vile rat
GoonWaffe SOLODRAKBANSOLODRAKBANSO
|
Posted - 2010.03.02 23:24:00 -
[34]
(6:22:33 PM) interval: I wish the vendor would have said that they can't help them, but they are sorry for the inconvenience (6:22:53 PM) vile_rat: no you see ccp are paying customers so
|
Lialem
|
Posted - 2010.03.02 23:26:00 -
[35]
http://www-01.ibm.com/software/data/db2/
|
Estamel Tarchon
|
Posted - 2010.03.02 23:32:00 -
[36]
Edited by: Estamel Tarchon on 02/03/2010 23:32:02 Because im a little interested in this (im a student), does your sql errors have anything to do with this? http://en.wikipedia.org/wiki/Isolation_level
|
Daminma2
Perkone
|
Posted - 2010.03.02 23:36:00 -
[37]
Originally by: Estamel Tarchon Edited by: Estamel Tarchon on 02/03/2010 23:32:02 Because im a little interested in this (im a student), does your sql errors have anything to do with this? http://en.wikipedia.org/wiki/Isolation_level
Quote:
Almost all of those were due to a bug in the networking subsystem that causes the SQL Server to fail over.
Doesn't seem like it. It's not even clear if the error is occurring on the database process at all.
|
Kerfira
Audaces Fortuna Iuvat
|
Posted - 2010.03.03 00:07:00 -
[38]
Originally by: Gimme Sugar Time to switch from SQL Server (Sybase) to Oracle RDBMS!
Why the hell would they switch from one monolithic database to another? They all have the exact same weaknesses.
If implementing something like EVE again, they should use a telco grade distributed X.500 directory server. Much faster and almost infinite data expansion capability (just add more server nodes).
Originally by: CCP Wrangler EVE isn't designed to just look like a cold, dark and harsh world, it's designed to be a cold, dark and harsh world.
|
Gerard Deneth
Caldari Pavlov Labs GmBH Independent Faction
|
Posted - 2010.03.03 01:26:00 -
[39]
Is there any possibility we might be looking at some more pervasive error in the system that is both causing this and under heavier load conditions some of the "lag" that's been seen in high number 0.0 combat?
---------------------------- The Game's always changing under your feet; don't start moaning when you get a toe caught in the gears. |
Hack Harrison
Caldari
|
Posted - 2010.03.03 02:35:00 -
[40]
Originally by: Estamel Tarchon Edited by: Estamel Tarchon on 02/03/2010 23:32:02 Because im a little interested in this (im a student), does your sql errors have anything to do with this? http://en.wikipedia.org/wiki/Isolation_level
No - Isolation level is something that effects transactions - what data you can see/update when another transaction is being applied etc... The result is that a transaction cannot complete due to another one, resulting in either the transaction blocking while the other one completes or a deadlock occuring if the same resources have to be accessed, but have been done so in a different order, so neither can complete.
The issue highlighted in the blog has nothing to do with transaction processing and is related to communication issues - too many database connections doing something to trigger the race condition.
|
|
Sinnbad Mayhem
|
Posted - 2010.03.03 03:52:00 -
[41]
This is one heck of a setup you have, I am sure you will find a solution. You better, losing T2 ships to lag sucks!
But I gotta say something about the Race condition answer - BULL****
I had to get that off my chest. Good luck gents. S&M |
HeliosGal
Caldari
|
Posted - 2010.03.03 06:24:00 -
[42]
its complex but im sure their diagnostic tools can work it out Signature - CCP what this game needs is more variance in PVE aspects and a little bit less PVP focus, more content more varied level 1-4 missions more than just 10 per faction high sec low sec and 00 |
Miraqu
Caldari
|
Posted - 2010.03.03 06:40:00 -
[43]
In the end, CCP will go the way the NYSE and the LSE went with their servers, vendors and used products.
By mid to end 2011 you will have to admit that your vendor microsoft can't deliver and you will finally look for a solution that works AND scales.
|
Charles Javeroux
Gallente INTERSTELLAR CREDIT
|
Posted - 2010.03.03 06:45:00 -
[44]
Good work, CCP!
Originally by: Orek Fear I guess the ultimate solution to inflation in EVE turned out to be an NPC stripper...
|
Frank Lonehorn
Gallente Lonehorn's Astral Mining Group
|
Posted - 2010.03.03 06:58:00 -
[45]
I think its the solid state drives on the database. and why is thier no catch on the thing so if u get a race, it will catch it for a sec?
|
Jei'son Bladesmith
The Storm Knights The Cool Kids Club
|
Posted - 2010.03.03 08:50:00 -
[46]
I blame rap music
|
Snorre Sturlasson
|
Posted - 2010.03.03 08:55:00 -
[47]
According to the blog, it's not the server itself but the underlying OS called windows. Maybe shifting to windows wasn't that good?
|
Freedom Netas
|
Posted - 2010.03.03 09:52:00 -
[48]
Originally by: Ender Flagrante In before some idiot suggests switching to MySQL.
In after some idiot defends MSSQL.
|
Typhado3
Minmatar
|
Posted - 2010.03.03 10:50:00 -
[49]
Quote: since our logs, surprisingly, showed nothing
boost logs
good luck, I don't envy your bughunters right now... or ever actually bughunting can be a b**** ------------------------------ God is an afk cloaker |
Grez
Fairlight Corp Rooks and Kings
|
Posted - 2010.03.03 11:17:00 -
[50]
FYI, Oracle and MySQL would be a terrible switch. MSSQL is perfect for what they need it to do, you'd probably see a performance decrease on this level of transactions when switching to Oracle, and MySQL still has data integrity issues. ---
|
|
Camios
Minmatar Insurgent New Eden Tribe Systematic-Chaos
|
Posted - 2010.03.03 11:35:00 -
[51]
Time to change the cartridge on the Helmoltz coil of your planck bubble stabilizer, tbh
|
Pilk
Mother Lovers
|
Posted - 2010.03.03 12:57:00 -
[52]
Edited by: Pilk on 03/03/2010 13:00:35
Originally by: Kerfira
Originally by: Gimme Sugar Time to switch from SQL Server (Sybase) to Oracle RDBMS!
Why the hell would they switch from one monolithic database to another? They all have the exact same weaknesses.
If implementing something like EVE again, they should use a telco grade distributed X.500 directory server. Much faster and almost infinite data expansion capability (just add more server nodes).
Cross-node transactions are expensive in that sort of system. To the degree that EVE does them, which is a *lot*, you'd end up right back where you started, with a single, monolithic server, unless you'd rather experience crippling performance problems.
DB2, on the other hand, would be fantastic for this sort of thing (massive, transactional DB full of inter-related data). Freddie Mac uses it to keep track of a few trillion dollars flowing between all of the banks it interacts with, itself, and the Federal Reserve. But I'm sure there's a downside of which I'm not aware; keep in mind, IBM is CCP's hardware vendor, so it's not like they've never been introduced to (and presumably rejected) the capabilities of DB2.
Originally by: Grez FYI, Oracle and MySQL would be a terrible switch. MSSQL is perfect for what they need it to do, you'd probably see a performance decrease on this level of transactions when switching to Oracle, and MySQL still has data integrity issues.
If you are having data integrity issues with MySQL, it's because you're using the wrong DB engine. MyISAM has been obsolete for years. InnoDB is fully-ACID. Just set "default_storage_engine=InnoDB" in your my.cnf.
--P
Kosh: The avalanche has already started. It is too late for the pebbles to vote. Tyrrax's bet status: PAID! |
Alex V0X2
Minmatar
|
Posted - 2010.03.03 14:32:00 -
[53]
We didn't want that server anyway.
|
Pesets
The Hunt Club
|
Posted - 2010.03.03 14:40:00 -
[54]
Originally by: Callic Veratar I hope it's not something as "simple" as a stack overflow. Too many connections and disconnections off the TCP stack, without prompt removal from the stack?
(Though, this was probably one of the first things you guys checked...)
"Stack overflow" refers to overflow of the call stack, a structure that stores the addresses where program should pick up from once the current procedure finishes. Stack overflow happens when too many procedures are called from within each other, and there is no more memory to put the next call's return address on top of the stack.
"TCP/IP stack" is a stack of abstraction layers, of which there is a definite number, and there is no way for it to overflow. "Connection stack" also cannot overflow because connections are not stored in a stack.
On a related note, this forum needs a facepalm smiley.
|
Ga'len
Hellhounds. HellFleet
|
Posted - 2010.03.03 15:01:00 -
[55]
Originally by: CCP Fallout As many of you have notice, Tranquility has been less than tranquil of late. CCP Valar fills us in on the progress being made towards keeping Tranquility well-behaved in his newest dev blog.
Good work guys, keep these technical updates coming. You have a great number of us techies that work with these technologies on a daily basis. Providing this information helps us to provide suggestions to you and your peers who are reaching out to the general techie community to resolve these issues.
Keep it up, we'll help you work through this stuff!
|
Shepard Book
Imperial Academy
|
Posted - 2010.03.03 15:06:00 -
[56]
Turning off recycling of idle sessions seems promising as a workaround that makes triggering the bug less likely.
I am not sure what you mean by sessions. Uncool if those sessions are customer clients. I have noticed an increasing number of discos during auto pilot in empire over past couple of months.I hope it is something else.
|
Silicon Buddha
Amarr Agony Unleashed Agony Empire
|
Posted - 2010.03.03 15:06:00 -
[57]
There is a better option to the traditional SQL clustering that has a failover and giveback type scenerio (and all the resulting issues).
There is a hardware vendor called Stratus that provides a hardware platform that promises (and delivers) very high availability. Essentially what happens is that there are 2 servers in a single stratus implementation. These servers are kept "lockstep" with each other from a CPU/Memory and Disk perspective so that if there is a failure on one slice of the server that it immediately and without missing a beat, fails over to the other slice.
We have very highly available MS SQL servers at my job which essentially requires 7x24 uptime.
During patch windows (applying patches to the Windows OS), we are able to break the mirroring, patch one side of the server, reboot it and make sure it comes up correctly, and then make the patched side active with no real impact to the systems or users. Essentially all we need to do is a quick restart of the MSSQL service (which the applications hardly notice).
We have this tied to our back-end SAN as well (as who in their reasonable mind would ever use local disk).
Feel free to contact me offline if you'd like more info on Highly available scenarios.
A concerned eve citizen _________________________________________________________ Click here for Fly Reckless Podcast
|
Louis deGuerre
Gallente Amicus Morte Void Alliance
|
Posted - 2010.03.03 15:08:00 -
[58]
Great job of you guys keeping the peons informed. Much appreciated.
Sol: A microwarp drive? In a battleship? Are you insane? They arenĘt built for this! Clear Skies - The Movie
|
Garr Anders
Minmatar Thukk U
|
Posted - 2010.03.03 16:06:00 -
[59]
Originally by: Silly Petey Lol
Ccp- that stuff you sold us keeps breaking Vendor- let me see the logs Ccp -errr they show nothing. Vendor- sorry for your loss. We hope you get back on your feet soon
Best response ever ! ----- Garr Anders
"The only winning move is not to play" is about the best damn advice anyone can get regarding arguing over the internet. - referring to the Movie WarGames 1983
|
Exie
Endless Possibilities Inc. Ushra'Khan
|
Posted - 2010.03.03 16:20:00 -
[60]
Edited by: Exie on 03/03/2010 16:20:35
Originally by: Garr Anders
Originally by: Silly Petey Lol
Ccp- that stuff you sold us keeps breaking Vendor- let me see the logs Ccp -errr they show nothing. Vendor- sorry for your loss. We hope you get back on your feet soon
Best response ever !
This
E...
We be Jammin' |
|
|
|
|
Pages: 1 [2] 3 4 :: one page |
First page | Previous page | Next page | Last page |