半夜不睡覺

前幾天，半夜起來 debugging。想記錄點什麼，不過同事的 mail 中報告得更詳細，就先擋著先吧。


--------------------------------------------------------------------------------
From: 亞當
Sent: Wednesday, January 21, 2009 5:25 PM
To: 來恩; 費迪南
Cc: 亞當; 雞米; 大衛
Subject: globalcm upgrade from 3.5 to 5.0 process


Dear All

The following is what we did during the 1/19 and 1/20

1. 2009/1/19 around 10pm
來恩 gave me a call saying that the upgrade process failed for some reasons after we try to modify TMCM's schema.xml (since there are 3 columns missing from the DB). The upgrade process is not able to run some store procedure. Then 來恩 asked me to join his WebEx

2. From IIS settings I found that there was SSL port missing on the configuration, therefore I set it to port 443 then reinstalled the TMCM 5.0. The reinstall process went well until it reached the set folder permission (WebUI).

3. 來恩 then asked Ferdy's help to compare the good TMCM's folder setting with the globalcm machine. During the process, I was not able to monitor what 來恩 was modifying.

4. After the folder permissions had been set, the reinstall process didn't get finished and stucked at the end (setup.exe). I then checked the ccgi_install.log and noticed that ccgi was not reinstalled properly. I manually removed CCGI componenet and installed CCGI by silent install script.

5. We then run the reinstall TMCM again, and finally we saw the completion screen of TMCM installation. After trying to logon to the TMCM console, it displayed the CCGI 400 error.

6. I just did a quick check of all TMCM 3 services and 8 exe files which are all intact. At this point in time, I really had no idea why CCGI didn't work. I also checked all registry hive related to the CCGI and found one which couldn't be opened or deleted. I then called 雞米's (another QA) help around (3:00am). He then joined the WebEx session as well and took a close look the services and exes. He suggested that we could restart the OS. After rebooting the machine, that locked registry entry was gone. Then reinstalling the TMCM, we had reached the final stage of TMCM installation completion. However, we still had CCGI problems (cannot reach apphost). 雞米 also found that one of process was keep doing this behavior: dying and starting until it went timeout stage (MsgReceiever.exe). I also noticed that when MsgReceiever.exe die, Dr. Watson created dump.

7. In the morning, 雞米 and I went to office and tried to collect all debug logs and core dump and sent them to RD to analyze them.

8. Afternoon, RD (伊森) was analyzing the core dump. QA (亞當 and 雞米) were trying to install TMCM 5.0 by backing up the original DB and all product profiles. Around 1/20/2009 3:15pm, RD found the possible root cause from the core dump: since we had TMIC registered as one of the TMCM entity. TMIC registered a plugin to TMCM's MsgReceiever.exe (configured in InterceptorHandler.xml). I then backuped the file "InterceptorHandler.xml" to "InterceptorHandler-Backup.xml". And the plug-in "TMICPlugin4CM35.dll" is for TMCM version 3.5 not for 5.0, TMCM couldn't recognize 3.5 plug-in, TMIC team needs to provide a 5.0 build to be able to register to TMCM.

9. In the meantime, the original DB was backuped and so did the product profiles. I remarked the plugin name from the "InterceptorHandler.xml" and restarted the SQL server then all 3 TMCM services. Aafter several logon to TMCM console there was no CCGI error but waited a while, and re-logon to the console, CCGI error appeared again.
=> It seemed that MsgReciever.exe was still having the problem. I then turned on the debug log and collected MsgReceiever related logs and core dump for RD to alalyze the log.
RD (伊森) analyzed the log and core dump, and found the root cause.
=> If the templog is big enough, TMCM will write it to the file and then do the parsing, if at this moment debuglog is turned on and is writing to the debug log file, MsgReceiever will crash.
=> We just found a bug (I will fire a track for it along with the TMIC handler hooked to the MsgReceiever problem when upgrade 3.5 to 5.0)


In the meantime (around 5:00pm), 雞米 and I were backing up the old DB and started to restore the TMCM back online.

1. When we installed the TMCM 5.0, we choosed the re-use DB option in order to use the old DB, for some reasons the installer did not recognize the old installation cmkeybackup folder. The installer always came back to the DB selection. We could not continue to re-use the DB.

2. We then needed to use the really-really manual way to restore the DB back.
=> Install brand new TMCM 5.0, detach the DB, attach the old DB, restore the old profiles, and then merge all necessary xml files for use.

(Around 9:00pm) restart TMCM services and logon to TMCM console => no CCGI error


cheers

今天。天氣晴

這兩天，天氣真好。在著實冷了一整個禮拜後，露臉的太陽很是叫人開心，雖然吹到風還是冷，不過曬著太陽吹吹風，冷得很舒服。

打從去年九月返家之後，絲毫不曾來新增點東西。轉眼間，過了耶誕、元旦，農曆年也將來到，好快。生活又是一個轉折與開始。

返家

上週六颱風天，搭著高鐵返家。一週的時間，在平凡規律的生活中，過得特別快，轉眼又是一個新的週末，不一樣的是下禮拜便要回歸工作崗位，在台北生活。

抽了一天，到屏東看看許久沒見的外婆，印象中身體勇健的外婆，膝蓋也在歲月的流逝中不復當年勇。不方便到處趴趴走、串門子的外婆，一個人待在家靜養，想必很無聊吧。

照哥跟珠姐不用說，肯定也是希望我們多回去，雖然總是嘴裡碎碎唸著交通費貴，沒事不用常回來﹍

應該是高中時打定主意要上台北唸書的。唸完大學後，打算退伍後在台北工作發展。不知不覺中，在台北的生活已經佔了人生的十年有餘。

台北有比較好嗎？改天再來回答這個問題。

不過，有看過《我在墾丁天氣晴》跟《海角七號》的人，都會知道台北並不是人待的好地方。是不覺得台北有敗壞到如此地步，但是我知道故鄉始終有我最在乎跟重要的家人。

沒事多回家，多回家，多回家，多回家﹍

棒球與黑黨

這幾天最大的新聞有兩個。

一個是中華奧運成棒代表隊，表現不如多數人預期，網路、媒體上一堆謾罵聲。

在輸給中國隊後，連棒球國殤、國恥日出現了。搞不懂那麼多國際比賽才出現，號稱是中華隊的球迷，其實對棒球運動的關心，大抵就只是今天贏了誰，明天搶下哪一勝，結束後就消失不見的傢伙，真不知憑哪一點可以如此狗血淋頭的指責。一堆媒體與號稱球評的傢伙，更多數都是以結果論來鬼扯蛋，贏了就奇蒙子爽，說教練調度佳、球員表現棒，輸了就開始探討哪邊要檢討、哪邊戰術錯誤，哪顆球守備判斷失誤等﹍。說穿了，一堆都是在於妄想抒發個人的悲憤，也凸顯了自身的無知跟可悲。

大多數人何時曾捫心自問，我們究竟為台灣棒球做過什麼？有沒看過那些熱愛棒球的小孩們打球的環境跟設備？有沒看過那些退休後的棒球員下半輩子的人生？

大家應該要感謝在台灣社會亂象頻生的現在，能有如此一支球隊肩負著眾人的理想也為自己的夢想在努力著。看多了那些政治上的新聞笑話，棒球帶給我們的著實更多於實際上看到的分數與輸贏。

另一個大新聞，就是ㄚ扁的洗錢風波。這個也有很多感觸，不過，算了，多數媒體終於抓到如此大的話柄，笑話跟故事就讓他們去說了。

最後，感想簡單說說，這下子，果真青出於藍更勝於藍，誠摯建議藍綠兩黨可以考慮合併成黑黨，真正一黨獨大，反正大家也有共識，以後選舉可以關起門來喬一喬，利益分配好，省下選舉動員、造勢費用，人民也樂得耳根清淨，算響應節能減碳，也是功德一件。

還有，是的，這一篇要大聲一點。

一輩子的靠山

在爸媽眼中，我們永遠是長不大的孩子。相對的，在我們眼中，爸媽則是我們永遠的靠山。

時光飛逝，我們終會忿忿不平地嚷著我們已經長大，於此同時，別忘了爸媽也在我們成長的過程中年華老去。

Mei Melançon

最近在 MSN 上貼了張照片，引起許多人的詢問，好奇她是誰。(果然美女是引人注目的﹍果然男人是 @#!%X﹍)

其實這是在《恐怖解剖室》這部電影中發現的東方面孔的演員。是片中的配角，飾演多位病理解剖醫生的一員。不過對我而言，她就是女主角了。

Meiling Melançon (also known as Mei Melançon)

後來上網 google 一下，發現其實她也參與了不少電影，也曾在 CSI 某集中露臉。

十三號星期五

不記得多久前也有過十三號遇到星期五的情況，昨兒個，就是六月十三日，星期五。

以往拿到新一年的年曆時，除了看看特定的節目跟連續假期外，也會找找十三號星期五的日子。不過這次打上這個標題並不是想討論這個日子，其實是許久未到這裡，想來留個記錄罷了。

感覺在專案被暫停後，忙碌的感覺一點都沒有減少，事情也有增無減，做得無力，卻又無能為力。

好快，今年過一半了。有空，再來幫 glog 加個新專欄好了。