“That day has arrived?”

Quoting my wife’s words this morning when she saw me with the server in my hands…..

Yes! The server is laying in my friend’s office from now on.

I might haven’t wrote here yet, but unfortunately I couldn’t receive the Dell PowerEgde that PS3EdOlkkola donated to me.

This is due to stupid brazilian custom’s law! Turns out it’s impossible to import a refurbished (or used) equipment to Brazil. Why? God knows why! Even that he (or even I’d do so) agreed to pay all the needed taxes… Crappy laws we have down here………………

Well.. After that my plan became to buy some new hardware in my trip to Canada, that happened in the last 3 weeks. I started saving some money to buy PSU, CPU, motherboard, memory and 2 SSDs.

Problem is that sometimes the world seems to turn in the other direction for you. 2017 is being a hard year for me! Not only I’m paying huge bills because my company bankrupted, but also my wife was kidnapped and our car was stolen together with laptop, cell phone and everything inside the car.

She’s alive and well, but the car did not haven’t insurance (it’d cost half car per year). So I’m paying the debt for a car I don’t have anymore and needed to buy another one. Or two in the case, since we bought a good one and a really cheap one.

That’s where all the money I was saving had to be used.

What’s the actual status?

Server is still a Core2Duo E8400 with 4GB of RAM (if you know where to buy 4GB DDR2 cards that works in a Gigabyte motherboard, let me know) and two old 160GB SATA HDDs in RAID 0.

Yes, it’s dangerous! But that’s what we got for now! I’m configuring an old laptop I have with a 2TB HDD to sync scripts and backups daily at least.

If something burn, then we figure it out! That’s how we live down here! 🙂



Kakao went down!

Hi everyone!

You might have noticed that Kakao is down. This is because power went down in my home and server is not running over UPS.

If I remember correct, I configured the server MB to power up automatically. If this is not true we’ll need to wait until my wife go back home, since I’m traveling in a customer.

According to my monitoring power went down during an update. Let’s hope that database is still ok. Also the hardware… You might remember that it’s running in an old hardware.

I’ll keep you posted.


Low memory

Hi all,

I woke up this morning with a message in the forum from Arto saying that his news users wasn’t showing anywhere.

After digging for a while I could find out that actual server has not enough memory to import the files. This now explains me why laptop is taking 30 minutes to import them and server only 5 minutes. True is that it was only importing data for already existing users and when doing calculations that include create new users interface ran out of memory and crashed.

First thing to fix was set the webservice to use laptop database instead. Then I was planning to out and buy more memory. If you read earlier posts you might remember that current server is a Core2 Duo E8400, this means memory DDR2. And this fuckers are hard to find, especially in 4GB pieces.

I could not find in any local store, so I created a swap file to add more swap memory. This fixed temporarily, but increased quite a lot importation time.

So I went to internet and bought 2x 4GB DDR2-800. Quite expensive for its age, but that’s what we have now. Till now customs have not released the server Mr. Ed donated, but this is another story!



Restore Finished! :)


At 21/09/2016 roundly 00:00 UTC time restore was finished!

Took extra time for two reasons:

  • Old Atom D2500 motherboard was screwed and it was showing some kernel errors from time to time that froze the OS. One friend gave me an Intel 775 motherboard, it was still in the box never used, so I bought a cheap Core2Duo E8400 plus 4GiB of memory in some kind of eBay we have in Brazil. It’s currently overclocked at 3.6GHz getting close to 90°C because it came without cooler and is relying on a Celeron 430 cooler. I bought a new one already, but did not receive yet.
  • Because sometimes there’s no user or data file from Stanford, restore script always got stuck on that and stopped. Of course first Murphy’s law is unmerciful and the first time it happened was during weekend while I was on the beach without internet access. Almost tree days without restore running. Aaaand I sleep from time to time, so happened few times during that either.

I was checking yesterday the source code of KakaoStats everyone knew, and I guess I know how to get it running again. I’ll travel for training today and I’ll have some spare time in hotel today and tomorrow evening so I already started up a virtual machine to play on it.

What do you think? Should I do it? Which version you liked more? Should I get both running? Let me know…!

Restoring…. :(


You might have noticed that since 13/09/2016 @ 15:20 UTC there’s no updates.

At first I was assuming this was just another time without new files. It happens from time to time. Then I connected the server to check and somehow it’s downloading the files and importing correctly without any errors.

Since I was already working on a script to restore the database with backup files in the coming soon Dell PowerEdge, I started doing this in a computer I have here. Pretty simple, it’s an Atom D2500 with 4GB of RAM, but works (or seems so). This one is serving new domain already.

While it started restoring I got back to current server and begin to investigate WTH no new data in the data base. No clue so far!

So I gave up for now, because I have other stuffs to do (like work) and decided to run the restore script in the old server. No data will be lost since even with the script running new files are being downloaded.



New domain!

Hi all,

I just registered a new domain to KakaoStats, soon I’ll migrate from http://kakaostats.alexbueno.me/ to http://www.kakaostats.net/ . Forum and blog will also be migrated!

Unfortunately someone already registered the .com domain and it’s for sale for something like $10k. No way!

Also I detected some problems in the database after this long period without new files. The interface that download new files wasn’t downloading nothing because it detected that it was still the same file, but it was importing this file hourly.

This seems to create a little mess in the database, some donor names are showing wrong. I’ll begin to implement this checking in the interface to avoid problem, and will restore the database to fix it. Restore script is also needed.

Keep you posted…


Good news, bad news….

What do you want first? Good news or bad news?

Let’s go with chronological order… Good news first!

Last Friday (02/08/2016) I got an email from Ed and he offered a whole new server to host KakaoStats. I wasn’t really expecting that! Really!! When I read the email with a link for the proposed server I was expecting something like a PC (what I was planning to replace the actual laptop), but then I opened the link and became speechless… A Dell PowerEdge R710 with 3x 1TiB HDD (hot swap), 96GiB of RAM and 2x Xeon 6 cores (don’t remember the model), plus everything else that comes in this kind of server. Not even in my hottest dreams I ever imagined a server like this to run KakaoStats!!

Don’t even need to talk about its reliability, but the power of this server opens a whole new world to KakaoStats. I already had the plan to re-write KakaoStats codes from front and backend, and rebuild its DataBase. But now it can be done in a new level, and that’s the plan. Stay tuned for news!!

Aaand the bad news…

Later in the same day someone broke my car to steal the spare tire and also stole both my laptops! Some documents were also lost, some were found, but still no clue of laptops and even my little daughter clothes that I bought couple of hours before that. My HTPC was also there and they didn’t steal, my RayBan glasses, phone charger, 5 liters of 2 stroke oil to my go-kart wasn’t steal also. I’m really sad because, not only I lost my brand new laptop (other one belong to the company I work for), but the contents inside. Most stuff was saved in OneDrive (piece of shit, don’t use it) but 2 external HDDs with 1TiB was stole and my MP3 folder from 20 years of downloads (some was still downloaded with Napster) was in secondary HDD and I’m not sure if I have backup.

But anyways… Life still goes on!