Skip to content

Instantly share code, notes, and snippets.

@remeniuk
Created February 11, 2013 08:26
Show Gist options
  • Save remeniuk/4753238 to your computer and use it in GitHub Desktop.
Save remeniuk/4753238 to your computer and use it in GitHub Desktop.
./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