First of that http://drupal.org/node/1454352#comment-5651484 problem lead me to this question
my problem is can't load a particular node i.e. 152 using node_load method even though it exists in the database

 $node = node_load($nid, NULL, TRUE);
drupal_set_message(t('%n has been loaded.', array('%n' => $node->nid)));

it gives me only "has been loaded." message
any other node such 55, 153 get loaded and gives proper nid that "55 has been loaded"

I have even gone into detail of what query node_load executes and therefore I tried executing similar query into phpmyadmin

SELECT * 
FROM node
INNER JOIN users ON users.uid = node.uid
INNER JOIN node_revisions ON node_revisions.vid = node.vid
WHERE node.nid =152

and it returns the record I want to load.

So why is node_load not able to load the particular node?