Description of problem: Deleting data from the metric tables in the database (after migration) using rhq-data-migration.sh script with --delete-only option does not happen. Tried the following: ********************************************************************* $ ./rhq-data-migration.sh --sql-user=<my_username> --sql-password=<my_password> --sql-connection-url=<my_oracle_connection_url> --delete-only=true --sql-server-oracle and $ ./rhq-data-migration.sh --sql-user=<my_username> --sql-password=<my_password> --sql-connection-url=<my_oracle_connection_url> --estimate-only=false --delete-only=true --sql-server-oracle ********************************************************************** Version-Release number of selected component (if applicable): JBoss ON 3.2.0 How reproducible: Always Steps to Reproduce: 1. Install JBoss ON 3.1.2 using Oracle database (didn't check with Postgres - but I'm guessing that it would behave in the same way) 2. Migrate to JBoss ON 3.2 3. Confirm that metric tables below still contain data: RHQ_MEASUREMENT_DATA_NUM_1H RHQ_MEASUREMENT_DATA_NUM_6H RHQ_MEASUREMENT_DATA_NUM_1D RHQ_MEAS_DATA_NUM_R14 RHQ_MEAS_DATA_NUM_R11 RHQ_MEAS_DATA_NUM_R10 RHQ_MEAS_DATA_NUM_R09 RHQ_MEAS_DATA_NUM_R08 RHQ_MEAS_DATA_NUM_R07 RHQ_MEAS_DATA_NUM_R06 RHQ_MEAS_DATA_NUM_R05 RHQ_MEAS_DATA_NUM_R04 RHQ_MEAS_DATA_NUM_R03 RHQ_MEAS_DATA_NUM_R02 RHQ_MEAS_DATA_NUM_R01 RHQ_MEAS_DATA_NUM_R00 4. Execute the following script to delete the data: $ ./rhq-data-migration.sh --sql-user=<my_username> --sql-password=<my_password> --sql-connection-url=<my_oracle_connection_url> --delete-only=true --sql-server-oracle Actual results: Nothing happens - the data is still in the metric tables. Expected results: Data from the metric tables is deleted. Additional info:
The --delete-only parameter was not parsed from the command line. Fixed in commit 56c6891 (tested with postgres)
Moving to ON_QA as this is available for test in JON 3.2.3 ER01 build: http://jon01.mw.lab.eng.bos.redhat.com:8042/dist/release/jon/3.2.3.GA/8-14-14/
Moving to VERIFIED. Tested both with Postgres and Oracle databases. In both cases only 4 of the tables contained data before running rhq-data-migration.sh script. Postgres: RHQ_MEASUREMENT_DATA_NUM_1H, RHQ_MEASUREMENT_DATA_NUM_6H, RHQ_MEASUREMENT_DATA_NUM_1D, RHQ_MEAS_DATA_NUM_R10 Oracle: RHQ_MEASUREMENT_DATA_NUM_1H, RHQ_MEASUREMENT_DATA_NUM_6H, RHQ_MEASUREMENT_DATA_NUM_1D, RHQ_MEAS_DATA_NUM_R04 After running rhq-data-migration.sh --delete-only --sql-server-postgres (or --sql-server-oracle) no data were present in the tables.