Attachment 944580 Details for Bug 1013508 – migration.log

migration.log

migration.log (text/plain), 55.45 KB, created by Armine Hovsepyan on 2014-10-07 12:48:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Armine Hovsepyan

Created: 2014-10-07 12:48:03 UTC

Size: 55.45 KB

patch

obsolete

>hudson@jon312upgr ~]$ ./jon-server-3.3.0.ER04/bin/rhq-data-migration.sh --cassandra-hosts=10.16.23.76,10.16.23.157 --cassandra-user=sduikawe --cassandra-password=rhqadmin --cassandra-port=9142 --sql-port=5432 --sql-server-type=postgres --sql-db=rhq --estimate-only=false -X
>/home/hudson/jon-server-3.3.0.ER04/bin/rhq-server-env.sh
>Starting RHQ Data Migration ...
>08:46:41,163 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>1285 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Server configuration file system property detected. Loading the file: /home/hudson/jon-server-3.3.0.ER04/bin/rhq-server.properties
>1487 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Server configuration file loaded based on system properties options.
>1488 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Running migration with the following optons: 
>1489 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-1h-migration : false
>1489 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-port : 5432
>1489 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-host : localhost
>1490 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   delete-data : false
>1490 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-password : <obscured value>
>1490 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-1d-migration : false
>1490 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-user : sduikawe
>1490 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-user : rhqadmin
>1491 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-hosts : [10.16.23.76, 10.16.23.157]
>1491 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   experimental-export : false
>1491 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-port : 9142
>1491 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   estimate-only : false
>1491 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-password : <obscured value>
>1492 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-db : rhq
>1492 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-raw-migration : false
>1492 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-connection-url : jdbc:postgresql://127.0.0.1:5432/rhq
>1492 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-server-type : Postgres
>1492 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-6h-migration : false
>1493 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   delete-only : false
>1493 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating Entity Manager
>1500 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating entity manager with the following configuration:
>1501 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - {hibernate.driver_class=org.postgresql.Driver, hibernate.connection.username=rhqadmin, hibernate.connection.password=rhqadmin, javax.persistence.provider=org.hibernate.ejb.HibernatePersistence, hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect, hibernate.c3p0.timeout=6000000, hibernate.connection.url=jdbc:postgresql://127.0.0.1:5432/rhq, javax.persistence.query.timeout=6000000}
>2387 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Done creating Entity Manager
>2387 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating Cassandra session
>2446 [main] DEBUG com.datastax.driver.core.Cluster  - Starting new cluster with contact points [/10.16.23.76, /10.16.23.157]
>2745 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Refreshing node list and token map
>08:46:43,069 INFO  [com.datastax.driver.core.Cluster] Cassandra host /10.16.23.157 removed
>2970 [main] INFO com.datastax.driver.core.Cluster  - Cassandra host /10.16.23.157 removed
>2971 [main] DEBUG com.datastax.driver.core.Cluster  - Removing host /10.16.23.157
>2980 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Refreshing schema
>3285 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Successfully connected to /10.16.23.76
>3294 [Cassandra Java Driver worker-0] DEBUG com.datastax.driver.core.Session  - Adding /10.16.23.76 to list of queried hosts
>3870 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Done creating Cassandra session
>Estimation process - starting
>
>4014 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:44,422 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>4323 [Thread-2] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>4325 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4333 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R00 -- 227
>4334 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4336 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R01 -- 578
>4337 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4339 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R02 -- 0
>4340 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4342 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R03 -- 0
>4343 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4345 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R04 -- 0
>4345 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4348 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R05 -- 0
>4348 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4351 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R06 -- 0
>4352 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4355 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R07 -- 0
>4356 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4358 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R08 -- 0
>4359 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4361 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R09 -- 0
>4362 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4364 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R10 -- 0
>4365 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4367 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R11 -- 0
>4368 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4370 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R12 -- 0
>4371 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4373 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R13 -- 0
>4374 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4376 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R14 -- 0
>4390 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4391 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4407 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:44,507 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>4408 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>4408 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4457 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:44,890 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R00 - 227 -
>4791 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R00 - 227 -
>4792 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>4792 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>4796 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4797 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4803 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:44,902 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>4803 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>4803 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4912 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:45,601 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R01 - 578 -
>5502 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R01 - 578 -
>5503 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 578 to 30578
>5503 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 578 to 30578
>5504 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5504 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5514 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,613 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>5514 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>5514 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5514 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5514 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5515 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5516 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,615 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>5516 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>5517 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5517 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5517 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5518 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5526 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,625 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>5526 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>5527 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5527 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5527 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5528 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5529 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,628 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>5529 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>5530 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5530 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5530 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5530 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5532 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,631 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>5532 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>5532 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5532 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5533 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5533 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5534 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,634 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>5535 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>5535 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5535 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5535 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5536 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5542 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,642 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>5543 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>5543 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5543 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5543 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5544 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5545 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,644 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>5545 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>5546 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5546 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5546 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5547 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5551 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,650 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>5551 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>5552 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5552 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5552 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5553 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5554 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,653 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>5554 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>5554 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5555 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5555 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5556 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5585 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,684 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>5585 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>5586 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5586 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5586 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5587 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5589 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,688 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>5589 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>5589 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5589 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5589 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5590 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5591 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>08:46:45,690 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>5591 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>5592 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5592 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5592 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 776 entries
>5693 [Thread-2] DEBUG com.datastax.driver.core.HostConnectionPool  - Creating new connection on busy pool to /10.16.23.76
>6444 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:46,557 WARN  [com.datastax.driver.core.Cluster] Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>6458 [Cassandra Java Driver worker-0] WARN com.datastax.driver.core.Cluster  - Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>08:46:46,562 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6463 [Thread-4] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6464 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>6467 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table one_hour_metrics -- 227
>6468 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6469 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>6471 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>6471 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6532 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:46,783 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - one_hour_metrics - 227 -
>6684 [Thread-4] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - one_hour_metrics - 227 -
>6684 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>6685 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>6685 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 227 entries
>6842 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:46,945 WARN  [com.datastax.driver.core.Cluster] Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>6846 [Cassandra Java Driver worker-1] WARN com.datastax.driver.core.Cluster  - Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>08:46:46,953 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6854 [Thread-5] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6854 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>6860 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table six_hour_metrics -- 227
>6860 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6860 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>6862 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>6862 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6896 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,199 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - six_hour_metrics - 227 -
>7100 [Thread-5] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - six_hour_metrics - 227 -
>7100 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>7101 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>7101 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 227 entries
>08:46:47,384 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>7285 [Thread-6] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>7286 [Thread-6] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>7288 [Thread-6] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table twenty_four_hour_metrics -- 227
>7288 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7288 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>7290 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>7290 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7306 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,520 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - twenty_four_hour_metrics - 227 -
>7421 [Thread-6] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - twenty_four_hour_metrics - 227 -
>7421 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>7422 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>7422 [Thread-6] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>The migration process will take approximately: 0 minutes (or 142 milliseconds)
>
>Estimation process - ended
>
>
>Migration process - starting
>
>7422 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:47,525 WARN  [com.datastax.driver.core.Cluster] Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>7426 [Cassandra Java Driver worker-0] WARN com.datastax.driver.core.Cluster  - Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>08:46:47,532 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>7433 [Thread-7] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>7433 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7441 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7442 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,541 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>7442 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>7443 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7459 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,637 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R00 - 227 -
>7538 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R00 - 227 -
>7538 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>7538 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>08:46:47,637 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R00---------------------
>7538 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R00---------------------
>7539 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7540 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7544 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,643 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>7544 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>7545 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7604 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,954 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R01 - 578 -
>7855 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R01 - 578 -
>7855 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 578 to 30578
>7855 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 578 to 30578
>08:46:47,955 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R01---------------------
>7856 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R01---------------------
>7856 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7857 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7858 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,957 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>7858 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>7858 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7859 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,958 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R02---------------------
>7859 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R02---------------------
>7859 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7860 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7860 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,959 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>7860 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>7861 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7861 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,960 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R03---------------------
>7861 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R03---------------------
>7866 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7866 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7867 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,966 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>7867 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>7868 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7868 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,967 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R04---------------------
>7868 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R04---------------------
>7868 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7869 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7869 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,969 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>7870 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>7870 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7870 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,969 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R05---------------------
>7870 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R05---------------------
>7870 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7871 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7872 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,972 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>7873 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>7873 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7873 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,972 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R06---------------------
>7873 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R06---------------------
>7875 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7876 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7878 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,978 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>7879 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>7879 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7879 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,978 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R07---------------------
>7879 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R07---------------------
>7880 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7880 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7884 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,983 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>7884 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>7885 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7885 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,984 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R08---------------------
>7885 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R08---------------------
>7885 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7886 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7887 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,986 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>7887 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>7887 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7887 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,986 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R09---------------------
>7887 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R09---------------------
>7888 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7888 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7889 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,989 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>7890 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>7890 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7890 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,989 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R10---------------------
>7890 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R10---------------------
>7897 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7897 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7898 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,997 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>7898 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>7898 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7899 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:47,998 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R11---------------------
>7899 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R11---------------------
>7899 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7899 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7900 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:47,999 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>7900 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>7901 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7901 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:48,000 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R12---------------------
>7901 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R12---------------------
>7901 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7902 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7902 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:48,001 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>7902 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>7903 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7903 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:48,002 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R13---------------------
>7903 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R13---------------------
>7909 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>7910 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>7911 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>08:46:48,010 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>7911 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>7911 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>7911 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:48,011 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R14---------------------
>7912 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R14---------------------
>7912 [Thread-7] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 776 entries
>8603 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:48,706 WARN  [com.datastax.driver.core.Cluster] Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>8607 [Cassandra Java Driver worker-1] WARN com.datastax.driver.core.Cluster  - Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>08:46:48,717 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>8618 [Thread-8] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>8619 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>8620 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>8622 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>8622 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>8658 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:48,871 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - one_hour_metrics - 227 -
>8772 [Thread-8] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - one_hour_metrics - 227 -
>8773 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>8773 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>8773 [Thread-8] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 227 entries
>8921 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>08:46:49,024 WARN  [com.datastax.driver.core.Cluster] Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>8925 [Cassandra Java Driver worker-0] WARN com.datastax.driver.core.Cluster  - Re-preparing already prepared query INSERT INTO metrics_idx (bucket, partition, time, schedule_id) VALUES (?, ?, ?, ?) . Please note that preparing the same query more than once is generally an anti-pattern and will likely affect performance. Consider preparing the statement only once.
>08:46:49,029 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>8930 [Thread-9] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>8930 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>8935 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>8937 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>8937 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>8969 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:49,166 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - six_hour_metrics - 227 -
>9067 [Thread-9] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - six_hour_metrics - 227 -
>9067 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>9068 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>9068 [Thread-9] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 227 entries
>08:46:49,381 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>9282 [Thread-10] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>9283 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>9288 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>9290 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>9290 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>9307 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>08:46:49,473 INFO  [org.rhq.server.metrics.migrator.workers.AggregateDataMigrator] - twenty_four_hour_metrics - 227 -
>9374 [Thread-10] INFO org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - - twenty_four_hour_metrics - 227 -
>9374 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 227 to 30227
>9374 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 227 to 30227
>9375 [Thread-10] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>The migration process took: 0 minutes (or 1953 milliseconds)
>
>Migration process - ended
>
>9375 [main] DEBUG com.datastax.driver.core.Cluster  - Shutting down
>9375 [main] DEBUG com.datastax.driver.core.HostConnectionPool  - Shutting down pool
>

Actions: View

Attachments on bug 1013508: 944580