abhishes
07-05-2010, 05:48 AM
Hello,
I am running a kettle package on a remote server via ssh shell.
the source table has 9 million rows on mysql database.
when I run my package and log the output to a file, I can see that the package runs for 6 hours and loads more than 1 million rows. but then no further rows are getting loaded.
in the output file, the package has not completed execution.
The last 4 lines in the log file are
NFO 03-07 22:20:01,934 - Table input 2.0 - linenr 5500000
INFO 03-07 22:20:37,761 - Database lookup.0 - linenr 5500000
INFO 03-07 22:21:52,455 - LocationMap.0 - linenr 4600000
INFO 03-07 22:22:54,384 - Table input 2.0 - linenr 5550000
INFO 03-07 22:23:32,959 - Database lookup.0 - linenr 5550000
INFO 03-07 22:25:06,056 - LocationMap.0 - linenr 4650000
I want to know why did my package stop loading more rows? there are no errors in the log file. But even after waiting for 24 hours, no further rows were loaded.
What is going on?
I am running a kettle package on a remote server via ssh shell.
the source table has 9 million rows on mysql database.
when I run my package and log the output to a file, I can see that the package runs for 6 hours and loads more than 1 million rows. but then no further rows are getting loaded.
in the output file, the package has not completed execution.
The last 4 lines in the log file are
NFO 03-07 22:20:01,934 - Table input 2.0 - linenr 5500000
INFO 03-07 22:20:37,761 - Database lookup.0 - linenr 5500000
INFO 03-07 22:21:52,455 - LocationMap.0 - linenr 4600000
INFO 03-07 22:22:54,384 - Table input 2.0 - linenr 5550000
INFO 03-07 22:23:32,959 - Database lookup.0 - linenr 5550000
INFO 03-07 22:25:06,056 - LocationMap.0 - linenr 4650000
I want to know why did my package stop loading more rows? there are no errors in the log file. But even after waiting for 24 hours, no further rows were loaded.
What is going on?