With a little side of applesauce...

Tuesday, April 28, 2009

Eclipse - Cannot find a solution satisfying the following requirements org.eclipse.swt [3.4.0.v3448f].

If you are the recipient of the above error, here is the cause:
"This is most likely an error from P2 (Eclipse's update mechanism in Eclipse 3.4 and higher). The problem seems to be that the Mylyn update site is not enabled in your copy of Eclipse. There is a bug in Eclipse that these sites may not be automatically enabled even though we specify that we require them for installation.

If any of the installed features have unsatisfied dependencies or if features were previously installed from the extras or incubator update site, P2 may fail with an error similar to the one above."

Here is the fix.

With the related bug:

Postgresql - using AS and WHERE together

I found this neat trick to perform the following, (which won't work due to the this):

SELECT fname || ' ' || lname AS fullname
FROM users
WHERE fullname LIKE 'Joe%'

The example is:

SELECT fullname
SELECT fname || ' ' || lname
AS fullname
FROM users
) as a
WHERE fullname LIKE 'Joe%'

This was stolen from here:

Wednesday, April 15, 2009

Vista - explorer.exe using 99% of CPU

I was experiencing high cpu usage since installing Vista Service Pack 1, and had difficulty finding leads as to what the problem was. Right before deciding to uninstall Service Pack 1, I pulled up ProcessExplorer, and delved into the detailed information which it provides for us. After a hint from this post, I started watching the Threads tab in the explorer.exe properties windows, in which I saw multiple SHLWAPI.dll!Ordinal197+0x57 threads chewing up most of the CPU cycles. After another search for 'shlwapi.dll high cpu', I hit on this post which has the answer.

Right-click on your Start Menu->Properties->Customize...

Find "Search Files", (which is towards the bottom of the list), and change "Search this User's files", to "Don't search for files".

This killed explorer, and when it restarted, it began using an appropriate amount of CPU cycles.

Thursday, April 2, 2009

Vista - vpn debug log and tracefmt.exe

I found that the easiest way to get tracefmt.exe from the Windows XP Service Pack Support Tools is to use cabextract in Cygwin, and bypass the msi package.

1. Download the exe package from Microsoft.
2. Unzip the exe (ie WindowsXP-KB838079-SupportTools-ENU.exe). I used 7zip
3. Open Cygwin, and cd to the extraction dir.
4. cabextract.exe *.cab
5. chmod 755 *
6. cp /c/Windows/System32/Ikeext.etl .
7. ./tracefmt.exe Ikeext.etl