I got a global cache group, and I had loaded data into it.
Now I need to refresh the cache group with new data. I did like this (since refresh cache group is not supported for global cache group):
1. unload cache group xxx; [works well]
2. load cache group xxx where ... commit every 10000 rows; [works BAD]
Then, I tried to load the previous data into cache group, also the data cannot be loaded again.
There is no error message printed, and I cannot stop the "load cache group" command in ttisql, I need to use "pidof ttIsqlCmd" to get the pid and kill it.
So, I want to restart the entire ttdaemonadmin process, when I tried to call ttcachestop after detaching the node from grid, the command hangs there again.
I ignored this and then I tried this:
[tta@xingyong70 bin]$ ./ttdaemonadmin -stop
ttDaemonAdmin: timed out waiting for daemon to go away.
Daemon process 11461 is still running.
Seems that I also cannot stop the daemon, the user "tta" is the one I installed TimesTen with.
So, I login as root, and get the pid of ttdaemonadmin by issuing "netstat -lnp", and tried to kill 11461 with " kill 11461", but the process is still there.
I can only kill it by "kill -9 11461".
After I restarted the ttdaemonadmin, I can successfully load the cache group.
I want to know what caused the "load cache group " command and "call ttcachestop" command hangs there. Or any possible incorrect actions may cause that.