| Pages: 1 2 3 4 5 [6] :: one page |
| Author |
Thread Statistics | Show CCP posts - 5 post(s) |
Azerrad InExile
   |
Posted - 2006.10.23 00:36:00 -
[151]
Missing items
reported by: GM Grimmi | 2006.10.22 23:42:33
Dear customers, we had some database issues earlier tonight and some of you
may be missing items bought off the market or minerals from refining. Please file
reimbursement petitions with details on what you are missing and the items will be
returned as soon as possible. Sorry for the inconvenience. EVE Online Customer Support!
|
|
Valar
|
Posted - 2006.10.23 00:36:00 -
[152]
Postmortem as usual.
First of all, the items that were supposed to be created during this time will not appear automatically. To get whatever item you did not get during the time TQ was broken, you will have to petition.
Now to explain the issue.
On friday, I defragmented the indexes of all tables on the RAMSAN.
This frees up a lot of space on the RAMSAN, but its quickly consumed as the indexes get fragmented again.
I did leave a lot of free space in the datafile, lots more then is normally consumed over a weekend, but for some reason the space was consumed much faster then usually.
Under normal circumstances, this would not have mattered at all, because the datafile will automatically grow when needed.
However, something cause the tempdb, a system database thats located on the RAMSAN, to fill up the rest of the free space before the datafile tried to grow, so when the datafile tried to grow, there was no free space for it, causing tonights issue.
At downtime today, there was enough space on the RAMSAN, so the issue is not that I overlooked that the partition was filling up, like someone suggested, the tempdb only needs a few minutes and a couple of lines of bad SQL/bad query plan to consume this space.
On Monday, 30th of October, I, two other guys from the operations department, a tech from IBM and a guy from Icelandic telecom are heading to London to make the changes Oveur announced in this news item.
The space on the RAMSAN will be doubled and that should give us a bigger buffer to address issues like this before its too late.
------
Valar
Database admin - Server operations team
CCP Games
How to write a good bugreport |
|
|
Serathu
Forum Moderator
Interstellar Services Department
|
Posted - 2006.10.23 00:38:00 -
[153]
 Originally by: Kasibee'an
Edited by: Kasibee''an on 23/10/2006 00:33:24
Any official response?
(regarding lost items)
Yes, you should petition for any items/ships lost as a result of the TQ reboot earlier although there could be a longer than usual wait due to the extra petition load this has generated. As before, please be patient and know that the GMs are on the case. It is also worth remembering that petitioning multiple times or filing one in the wrong category will slow the queues down as each has to be looked at individually.
Thank you!
|
|
Kasibee'an
Gallente
The Scope
|
Posted - 2006.10.23 00:40:00 -
[154]
Edited by: Kasibee''an on 23/10/2006 00:42:56
Originally by: Serathu
Originally by: Kasibee'an
Edited by: Kasibee''an on 23/10/2006 00:33:24
Any official response?
(regarding lost items)
Yes, you should petition for any items/ships lost as a result of the TQ reboot earlier although there could be a longer than usual wait due to the extra petition load this has generated. As before, please be patient and know that the GMs are on the case. It is also worth remembering that petitioning multiple times or filing one in the wrong category will slow the queues down as each has to be looked at individually.
Thank you!
This isn't meant rudely but we ALL KNOW the reimbursement queues are ridicously long enough as it is without all the extra petitions sent in the last hour have extra personnel been assigned cause normally it takes good 7-14days (if your lucky!!)....
|
Eilie
Minmatar
|
Posted - 2006.10.23 00:50:00 -
[155]
Originally by: Valar
Postmortem as usual.
First of all, the items that were supposed to be created during this time will not appear automatically. To get whatever item you did not get during the time TQ was broken, you will have to petition.
Now to explain the issue.
On friday, I defragmented the indexes of all tables on the RAMSAN.
This frees up a lot of space on the RAMSAN, but its quickly consumed as the indexes get fragmented again.
I did leave a lot of free space in the datafile, lots more then is normally consumed over a weekend, but for some reason the space was consumed much faster then usually.
Under normal circumstances, this would not have mattered at all, because the datafile will automatically grow when needed.
However, something cause the tempdb, a system database thats located on the RAMSAN, to fill up the rest of the free space before the datafile tried to grow, so when the datafile tried to grow, there was no free space for it, causing tonights issue.
At downtime today, there was enough space on the RAMSAN, so the issue is not that I overlooked that the partition was filling up, like someone suggested, the tempdb only needs a few minutes and a couple of lines of bad SQL/bad query plan to consume this space.
On Monday, 30th of October, I, two other guys from the operations department, a tech from IBM and a guy from Icelandic telecom are heading to London to make the changes Oveur announced in this news item.
The space on the RAMSAN will be doubled and that should give us a bigger buffer to address issues like this before its too late.
I love how you guys always tell us exactly what happened (even though many people don't understand a thing you just said) because other games wouldn't tell us anything when they have problems. Keep up the good work! 
To anyone quitting due to a little downtime: Good Riddance. We don't want or need impatient whiners here.
|
Kasibee'an
Gallente
The Scope
|
Posted - 2006.10.23 01:11:00 -
[156]
Eilie im guessing you didnt lose few hundred mil or implants or ships?
|
Eilie
Minmatar
|
Posted - 2006.10.23 01:34:00 -
[157]
Originally by: Kasibee'an
Eilie im guessing you didnt lose few hundred mil or implants or ships?
Hehe, I got home right after the server came back up so I missed all the problems. But if I had lost a few hundred mil, I would just petition it.
If someone quits over something like this, than they probably didn't really like EVE much and are one of those "I'm only playing EVE until something better comes along" people who were going to quit anyway.
|
Kasibee'an
Gallente
The Scope
|
Posted - 2006.10.23 01:45:00 -
[158]
O sorry i'm just saying you shouldn't put down the people who got screwed over by it ive been saving awhile for stuff which i bought.. and i know all i can do is sit in station waiting for GMs to answer and spawn my stuff.
|
lillypad yar
|
Posted - 2006.10.23 02:14:00 -
[159]
Originally by: Admai Sket
LINKAGE TO THE CORE OF TONIGHT'S PROBLEMS!
omg..lol..omg..lmfao..heheheheheheheheehehehe...
|
Dao 2
Generals Of Destruction Syndicate
Axiom Empire
|
Posted - 2006.10.23 02:56:00 -
[160]
wot should we do if we have 2 things to petition ><? wont let me make another one and i woulda made it in one but the first one happened before the second one and i filed a petition right after ><
------------------------------------------------
NEWLY ADDED ON 1/19 (though applies to all posts before ;p)
the usual "I don't represent my corp or alliance" and stuffs like that
Also the gal |
Greyboi
|
Posted - 2006.10.23 02:56:00 -
[161]
Originally by: Valar
verbage...
i would also like to extend a thanks on the very descriptive path to reboot, status update from the devs. on a weekend night, sunday be it.
never played a mmog that had this level of commitment. thanks. ALOT.
im trying to think what soe would have done in a situations similar to this in swg...
~j
|
nickky01
No Quarter.
Axiom Empire
|
Posted - 2006.10.23 03:19:00 -
[162]
Originally by: Dao 2
wot should we do if we have 2 things to petition ><? wont let me make another one and i woulda made it in one but the first one happened before the second one and i filed a petition right after ><
use alts.
|
Andargor theWise
Disbelievers of Fate
The SUdden Death Squad
|
Posted - 2006.10.23 03:50:00 -
[163]
Originally by: Valar
At downtime today, there was enough space on the RAMSAN, so the issue is not that I overlooked that the partition was filling up, like someone suggested, the tempdb only needs a few minutes and a couple of lines of bad SQL/bad query plan to consume this space.
You put the tempdb... in a sodastream? 
SELECT * FROM tempdb WHERE sodastream = 1;
*cluster crash*
-
Got grief?
|
Uglyone
Deep Can Mining Inc.
|
Posted - 2006.10.23 06:39:00 -
[164]
so..... you are saying that this problem will be here everyday until the 1st?
when you add more ramsan?
|
Zubenelgenubi
Interstellar eXodus
R0ADKILL
|
Posted - 2006.10.23 06:54:00 -
[165]
Hrmm,
I bought 30 cruisers and a wad of t1 stuff for them. Is it easy for you guys to reimburse or do ya need to trawl through wallet transactions?
I mean, crap.... the queue must be 20 thousand peeps long.
If its quicker you could always drop 250mil(ish) in my wallet :P
Signature file size to big, please keep it under 24000 bytes. Please e-mail us at [email protected] with any questions - Petwraith |
KayaYautja
Caldari
Ore Mongers
Pirate Coalition
|
Posted - 2006.10.23 09:09:00 -
[166]
Thank crap i didn't buy anything, all i lost was a condor to then navy in Villore.... and even then it was quite funny, i got the kill and insurance mail..... and my shields started recharging. They got me again when the server came back up though
--------------------------
I'm the omega baby! |
|
Valar
|
Posted - 2006.10.23 10:35:00 -
[167]
Originally by: Uglyone
so..... you are saying that this problem will be here everyday until the 1st?
when you add more ramsan?
No, this just happened because two bad things happened at once. When we add to the RAMSAN, we'll have a bigger buffer IF something like this happens again.
------
Valar
Database admin - Server operations team
CCP Games
How to write a good bugreport |
|
Tas Devil
JUDGE DREAD Inc.
Forces of Freedom
|
Posted - 2006.10.23 11:21:00 -
[168]
Valar is in London ! Camp heathrow gate !
Tas
The best Laugh ever ... Credit goes to Killer8 for this !
This includes bad language... so beware |
Kasibee'an
Gallente
The Scope
|
Posted - 2006.10.23 11:23:00 -
[169]
Originally by: Tas Devil
Valar is in London ! Camp heathrow gate !
Gatwick... Luton.... Standstead....
|
Tas Devil
JUDGE DREAD Inc.
Forces of Freedom
|
Posted - 2006.10.23 11:40:00 -
[170]
Originally by: Kasibee'an
Originally by: Tas Devil
Valar is in London ! Camp heathrow gate !
Gatwick... Luton.... Standstead....
Know your ennemy ... Icelandic Fleets come through Heathrow gate !
Tas
The best Laugh ever ... Credit goes to Killer8 for this !
This includes bad language... so beware |
DroppedAschild
|
Posted - 2006.10.23 13:01:00 -
[171]
Originally by: Tas Devil
Originally by: Kasibee'an
Originally by: Tas Devil
Valar is in London ! Camp heathrow gate !
Gatwick... Luton.... Standstead....
Know your ennemy ... Icelandic Fleets come through Heathrow gate !
Stansted if he flies Iceland Express
|
Skarsnik
Caldari
A.W.M
|
Posted - 2006.10.23 13:54:00 -
[172]
Originally by: Tas Devil
Originally by: Kasibee'an
Originally by: Tas Devil
Valar is in London ! Camp heathrow gate !
Gatwick... Luton.... Standstead....
Know your ennemy ... Icelandic Fleets come through Heathrow gate !
Sorry Tas, got your pirate gate camping dealt with. I've bribed the Concord Officials (Heathrow Security) to flank Valar as he comes through the gate and warp to freedom. 
-------------
EVE-CCG Pre-orders
EVE-Ink Tattoo Project |
| |
|
| Pages: 1 2 3 4 5 [6] :: one page |
| First page | Previous page | Next page | Last page |