Created
February 11, 2013 08:26
-
-
Save remeniuk/4753238 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
./run_etl_qa.sh t_user_session_load/initial_load | |
INFO 11-02 08:23:45,172 - Kitchen - Logging is at level : Detailed logging | |
INFO 11-02 08:23:45,174 - Kitchen - Start of run. | |
INFO 11-02 08:23:45,199 - RepositoriesMeta - Reading repositories XML file: /home/crm-user/.kettle/repositories.xml | |
INFO 11-02 08:23:45,407 - t_user_session_load/initial_load - Start of job execution | |
INFO 11-02 08:23:45,412 - t_user_session_load/initial_load - exec(0, 0, START.0) | |
INFO 11-02 08:23:45,414 - START - Starting job entry | |
INFO 11-02 08:23:45,415 - t_user_session_load/initial_load - Starting entry [Create empty table] | |
INFO 11-02 08:23:45,415 - t_user_session_load/initial_load - exec(1, 0, Create empty table.0) | |
INFO 11-02 08:23:45,416 - Create empty table - Starting job entry | |
INFO 11-02 08:23:45,432 - DWH QA - New database connection defined | |
INFO 11-02 08:23:45,754 - DWH QA - Connected to database. | |
INFO 11-02 08:23:45,755 - Create empty table - Running SQL :drop table if exists t_user_session; | |
CREATE TABLE `t_user_session` ( | |
`user_id` int(11) NOT NULL, | |
`platform` varchar(25) NULL, | |
`client_version` varchar(25) NULL, | |
`udid` varchar(128) NULL, | |
`login_date` datetime NULL, | |
`duration` int(11) NULL, | |
`operator_id` tinyint(4) NULL, | |
`ip` varchar(15) NULL, | |
`login_mode` tinyint(4) NULL | |
) ENGINE=MyISAM; | |
CREATE INDEX user_id_idx ON t_user_session(user_id); | |
CREATE INDEX platform_idx ON t_user_session(platform); | |
CREATE INDEX udid_idx ON t_user_session(udid); | |
CREATE INDEX operator_id_idx ON t_user_session(operator_id); | |
CREATE INDEX login_mode_idx ON t_user_session(login_mode); | |
INFO 11-02 08:23:45,755 - DWH QA - launch DDL statement: | |
drop table if exists t_user_session | |
INFO 11-02 08:23:45,783 - DWH QA - launch DDL statement: | |
CREATE TABLE `t_user_session` ( `user_id` int(11) NOT NULL, `platform` varchar(25) NULL, `client_version` varchar(25) NULL, `udid` varchar(128) NULL, `login_date` datetime NULL, `duration` int(11) NULL, `operator_id` tinyint(4) NULL, `ip` varchar(15) NULL, `login_mode` tinyint(4) NULL ) ENGINE=MyISAM | |
INFO 11-02 08:23:45,790 - DWH QA - launch DDL statement: | |
CREATE INDEX user_id_idx ON t_user_session(user_id) | |
INFO 11-02 08:23:45,798 - DWH QA - launch DDL statement: | |
CREATE INDEX platform_idx ON t_user_session(platform) | |
INFO 11-02 08:23:45,805 - DWH QA - launch DDL statement: | |
CREATE INDEX udid_idx ON t_user_session(udid) | |
INFO 11-02 08:23:45,812 - DWH QA - launch DDL statement: | |
CREATE INDEX operator_id_idx ON t_user_session(operator_id) | |
INFO 11-02 08:23:45,819 - DWH QA - launch DDL statement: | |
CREATE INDEX login_mode_idx ON t_user_session(login_mode) | |
INFO 11-02 08:23:45,826 - DWH QA - 7 statements executed | |
INFO 11-02 08:23:45,827 - DWH QA - Connection to database closed! | |
INFO 11-02 08:23:45,828 - t_user_session_load/initial_load - Starting entry [Shell] | |
INFO 11-02 08:23:45,828 - t_user_session_load/initial_load - exec(2, 0, Shell.0) | |
INFO 11-02 08:23:45,829 - Shell - Starting job entry | |
INFO 11-02 08:23:45,830 - Shell - Found 0 previous result rows | |
INFO 11-02 08:23:45,830 - Shell - Running on platform : Linux | |
INFO 11-02 08:23:45,847 - Shell - Executing command : /home/crm-user/null/kettle_5a5f5d26-7424-11e2-b212-bd64fc61e0ddshell | |
INFO 11-02 08:23:45,853 - Shell - (stderr) Error: Unable to access jarfile partition-manager.jar | |
INFO 11-02 08:23:45,854 - Shell - Command /home/crm-user/null/kettle_5a5f5d26-7424-11e2-b212-bd64fc61e0ddshell has finished | |
INFO 11-02 08:23:45,855 - Shell - Exit status of shell [null] was 1 | |
INFO 11-02 08:23:45,858 - t_user_session_load/initial_load - Finished job entry [Shell] (result=[false]) | |
INFO 11-02 08:23:45,858 - t_user_session_load/initial_load - Finished job entry [Create empty table] (result=[false]) | |
INFO 11-02 08:23:45,858 - t_user_session_load/initial_load - Job execution finished | |
INFO 11-02 08:23:45,859 - Kitchen - Finished! | |
ERROR 11-02 08:23:45,859 - Kitchen - Finished with errors | |
INFO 11-02 08:23:45,860 - Kitchen - Start=2013/02/11 08:23:45.174, Stop=2013/02/11 08:23:45.860 | |
INFO 11-02 08:23:45,860 - Kitchen - Processing ended after 0 seconds. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment