Attachment 951905 Details for Bug 1082805 – upgrade-with-migration.log

upgrade-with-migration.log

upgrade_with_migration.log (text/plain), 75.54 KB, created by Armine Hovsepyan on 2014-10-29 19:47:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Armine Hovsepyan

Created: 2014-10-29 19:47:08 UTC

Size: 75.54 KB

patch

obsolete

>[hudson@jon312up ~]$ ./jon-server-3.3.0.ER05/bin/rhqctl upgrade --run-data-migrator --from-server-dir /home/hudson/jon-server-3.1.2.GA
>15:30:53,677 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>15:30:53,879 INFO  [org.rhq.server.control.command.Upgrade] Stopping any running RHQ components...
>RHQ Server (no pid file) is NOT running
>15:30:53,989 INFO  [org.rhq.server.control.command.Upgrade] The old installation components have been stopped
>15:30:53,992 INFO  [org.rhq.server.control.command.Upgrade] Preparing to install RHQ storage node.
>Starting RHQ Storage Installer ...
>15:30:54,569 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>15:30:54,714 INFO  [org.rhq.storage.installer.StorageInstaller] Running RHQ Storage Node installer...
>15:30:54,742 INFO  [org.rhq.storage.installer.StorageInstaller] Checking perms for ../../../rhq-data/saved_caches
>15:30:54,743 INFO  [org.rhq.storage.installer.StorageInstaller] Checking perms for ../../../rhq-data/commit_log
>15:30:54,744 INFO  [org.rhq.storage.installer.StorageInstaller] Checking perms for ../../../rhq-data/data
>15:30:54,748 INFO  [org.rhq.cassandra.Deployer] Unzipping storage node to /home/hudson/jon-server-3.3.0.ER05/rhq-storage
>15:30:55,114 INFO  [org.rhq.cassandra.Deployer] Applying configuration changes to /home/hudson/jon-server-3.3.0.ER05/rhq-storage/conf/cassandra.yaml
>15:30:55,232 INFO  [org.rhq.cassandra.Deployer] Applying configuration changes to /home/hudson/jon-server-3.3.0.ER05/rhq-storage/conf/log4j-server.properties
>15:30:55,246 INFO  [org.rhq.cassandra.Deployer] Applying configuration changes to /home/hudson/jon-server-3.3.0.ER05/rhq-storage/conf/cassandra-jvm.properties
>15:30:55,257 INFO  [org.rhq.cassandra.Deployer] Updating file permissions in /home/hudson/jon-server-3.3.0.ER05/rhq-storage/bin
>15:30:55,269 INFO  [org.rhq.storage.installer.StorageInstaller] Updating rhq-server.properties...
>15:30:55,309 INFO  [org.rhq.storage.installer.StorageInstaller] Starting RHQ Storage Node
>15:31:06,641 INFO  [org.rhq.storage.installer.StorageInstaller] RHQ Storage Node is up and running and ready to service client requests
>15:31:06,642 INFO  [org.rhq.storage.installer.StorageInstaller] Installation of the storage node has completed successfully.
>15:31:06,667 INFO  [org.rhq.server.control.command.Upgrade] The storage node installer has finished with an exit value of 0
>15:31:06,948 INFO  [org.rhq.server.control.command.Upgrade] Looks like the new server already has an Oracle driver: /home/hudson/jon-server-3.3.0.ER05/modules/org/rhq/oracle/main/ojdbc6-12.1.0.1.0.jar
>15:31:07,017 INFO  [org.rhq.server.control.command.Upgrade] The RHQ Server must be started to complete its installation. Starting the RHQ server in preparation of running the server installer...
>15:31:07,051 INFO  [org.rhq.server.control.command.Upgrade] Waiting for the RHQ Server to start in preparation of running the server installer...
>Trying to start the RHQ Server...
>RHQ Server                     (pid 4210   ) is starting
>15:31:14,094 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>15:31:14,329 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] The server is preconfigured and ready for auto-install.
>15:31:14,446 INFO  [org.xnio] XNIO Version 3.0.10.GA-redhat-1
>15:31:14,456 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.10.GA-redhat-1
>15:31:14,489 INFO  [org.jboss.remoting] JBoss Remoting version (unknown)
>15:31:15,312 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Installing into app server version [7.4.0.Final-redhat-19]
>15:31:15,506 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Database is supported: postgresql8.4(postgresql:8.4)
>15:31:15,539 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] This [[name=jon312up.bc.jonqe.lab.eng.bos.redhat.com, address=10.16.23.99, port=7080, secureport=7443]] will be considered a reinstallation of an existing server [[name=jon312up.bc.jonqe.lab.eng.bos.redhat.com, address=10.16.23.99, port=7080, secureport=7443]]
>15:31:15,540 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] The app server where the installation will go is found at: /home/hudson/jon-server-3.3.0.ER05
>15:31:15,540 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] It looks like everything is OK and you can start the installation.
>15:31:15,547 INFO  [org.rhq.server.control.command.Upgrade] The RHQ Server is ready to be upgraded by the server installer.
>15:31:15,549 INFO  [org.rhq.server.control.command.Upgrade] Upgrading RHQ Server
>15:31:15,550 INFO  [org.rhq.server.control.command.Upgrade] The RHQ Server installer is running
>15:31:15,718 INFO  [org.xnio] XNIO Version 3.0.10.GA-redhat-1
>15:31:15,734 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.10.GA-redhat-1
>15:31:15,782 INFO  [org.jboss.remoting] JBoss Remoting version (unknown)
>15:31:16,446 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>15:31:16,622 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] The server is preconfigured and ready for auto-install.
>15:31:16,705 INFO  [org.xnio] XNIO Version 3.0.10.GA-redhat-1
>15:31:16,716 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.10.GA-redhat-1
>15:31:16,741 INFO  [org.jboss.remoting] JBoss Remoting version (unknown)
>15:31:17,276 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Installing into app server version [7.4.0.Final-redhat-19]
>15:31:17,524 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Database is supported: postgresql8.4(postgresql:8.4)
>15:31:17,552 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Database setup log file directory: /home/hudson/jon-server-3.3.0.ER05/logs
>15:31:17,597 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Database schema exists - it will now be updated.
>15:31:20,420 INFO  [org.rhq.cassandra.schema.VersionManager] Preparing to check storage schema compatibility.
>15:31:20,797 INFO  [org.rhq.cassandra.schema.VersionManager] Completed storage schema compatibility check.
>15:31:20,798 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Install RHQ schema along with updates to storage nodes.
>15:31:20,799 INFO  [org.rhq.cassandra.schema.VersionManager] Preparing to install storage schema
>15:31:20,800 INFO  [org.rhq.cassandra.schema.AbstractManager] Shutting down existing cluster connections
>15:31:20,832 INFO  [org.rhq.cassandra.schema.AbstractManager] Shutting down existing cluster connections
>15:31:21,851 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/create/0001.xml
>15:31:23,589 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/create/0001.xml
>15:31:23,590 INFO  [org.rhq.cassandra.schema.AbstractManager] Shutting down existing cluster connections
>15:31:24,142 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/create/0002.xml
>15:31:24,276 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/create/0002.xml
>15:31:24,337 INFO  [org.rhq.cassandra.schema.VersionManager] Installed storage schema version is 0
>15:31:24,337 INFO  [org.rhq.cassandra.schema.VersionManager] Required storage schema version is 7
>15:31:24,337 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema requires udpates. Updating from version 0 to version 7.
>15:31:24,338 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0001.xml
>15:31:28,434 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0001.xml
>15:31:28,438 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0001.xml applied.
>15:31:28,438 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0002.xml
>15:31:32,109 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0002.xml
>15:31:32,118 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0002.xml applied.
>15:31:32,118 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0003.xml
>15:31:32,121 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0003.xml
>15:31:32,124 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0003.xml applied.
>15:31:32,124 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0004.xml
>15:31:33,096 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0004.xml
>15:31:33,099 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0004.xml applied.
>15:31:33,099 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0005.xml
>15:31:33,212 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Migrating aggregate metrics for 7852 schedule ids
>15:31:33,214 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Migrating one_hour data for 7852 schedules
>15:31:33,216 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] There are 7852 remaining schedules for the one_hour data migration
>15:31:43,465 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Finished migrating one_hour data
>15:31:43,513 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Migrating six_hour data for 7852 schedules
>15:31:43,514 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] There are 7852 remaining schedules for the six_hour data migration
>15:31:46,835 INFO  [org.rhq.server.control.command.Upgrade] Still waiting for server to start...
>15:31:48,738 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Finished migrating six_hour data
>15:31:48,739 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Migrating twenty_four_hour data for 7852 schedules
>15:31:48,740 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] There are 7852 remaining schedules for the twenty_four_hour data migration
>15:31:52,305 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Finished migrating twenty_four_hour data
>15:31:52,305 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Finished aggregate metrics migration in 19 seconds
>15:31:52,314 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Dropping table one_hour_metrics
>15:31:53,022 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Dropping table six_hour_metrics
>15:31:53,844 INFO  [org.rhq.cassandra.schema.MigrateAggregateMetrics] Dropping table twenty_four_hour_metrics
>15:31:54,810 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0005.xml
>15:31:54,812 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0005.xml applied.
>15:31:54,813 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0006.xml
>15:31:55,416 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0006.xml
>15:31:55,418 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0006.xml applied.
>15:31:55,418 INFO  [org.rhq.cassandra.schema.AbstractManager] Applying update file: schema/update/0007.xml
>15:31:55,531 INFO  [org.rhq.cassandra.schema.ReplaceIndex] Preparing to replace metrics_index
>15:31:55,537 INFO  [org.rhq.cassandra.schema.ReplaceRHQ411Index] Updating raw index
>15:31:55,596 INFO  [org.rhq.cassandra.schema.ReplaceRHQ411Index] Updating one_hour index
>15:31:55,611 INFO  [org.rhq.cassandra.schema.ReplaceRHQ411Index] Updating six_hour index
>15:31:55,619 INFO  [org.rhq.cassandra.schema.ReplaceRHQ411Index] Dropping table metrics_index
>15:31:56,388 INFO  [org.rhq.cassandra.schema.AbstractManager] Applied update file: schema/update/0007.xml
>15:31:56,390 INFO  [org.rhq.cassandra.schema.VersionManager] Storage schema update schema/update/0007.xml applied.
>15:31:56,396 INFO  [org.rhq.cassandra.schema.TopologyManager] Applying topology updates...
>15:31:56,397 INFO  [org.rhq.cassandra.schema.TopologyManager] Starting to execute UpdateReplicationFactor task.
>15:31:56,398 INFO  [org.rhq.cassandra.schema.TopologyManager] No need to update replication factor. Replication factor already 1
>15:31:56,399 INFO  [org.rhq.cassandra.schema.TopologyManager] Successfully executed UpdateReplicationFactor task.
>15:31:56,399 INFO  [org.rhq.cassandra.schema.TopologyManager] Starting to execute UpdateGCGrace task.
>15:31:58,979 INFO  [org.rhq.cassandra.schema.TopologyManager] Updated gc_grace_seconds to 0
>15:31:58,979 INFO  [org.rhq.cassandra.schema.TopologyManager] Successfully executed UpdateGCGrace task.
>15:31:59,019 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Admin user password is already set, property [rhq.autoinstall.server.admin.password] will be ignored.
>15:31:59,029 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Persisting to database new storage nodes for values specified in server configuration property [rhq.storage.nodes]
>15:31:59,592 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] RHQ Vault created
>15:31:59,593 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [ajp] to [${rhq.server.socket.binding.port.ajp:7009}]
>15:31:59,735 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [http] to [${rhq.server.socket.binding.port.http:7080}]
>15:31:59,869 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [https] to [${rhq.server.socket.binding.port.https:7443}]
>15:32:00,032 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [jacorb] to [${rhq.server.socket.binding.port.jacorb:2528}]
>15:32:00,137 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [jacorb-ssl] to [${rhq.server.socket.binding.port.jacorb-ssl:2529}]
>15:32:00,306 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [messaging] to [${rhq.server.socket.binding.port.messaging:4449}]
>15:32:00,414 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [messaging] to use interface [management]
>15:32:00,511 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [messaging-throughput] to [${rhq.server.socket.binding.port.messaging-throughput:4455}]
>15:32:00,613 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [messaging-throughput] to use interface [management]
>15:32:00,747 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [management-http] to [${jboss.management.http.port:6990}]
>15:32:00,878 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [management-https] to [${jboss.management.https.port:6443}]
>15:32:01,062 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [management-native] to [${jboss.management.native.port:6999}]
>15:32:01,225 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [remoting] to [${rhq.server.socket.binding.port.remoting:3447}]
>15:32:01,334 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [remoting] to use interface [management]
>15:32:01,468 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [txn-recovery-environment] to [${rhq.server.socket.binding.port.txn-recovery-environment:3712}]
>15:32:01,605 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Setting socket binding [txn-status-manager] to [${rhq.server.socket.binding.port.txn-status-manager:3713}]
>15:32:01,817 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Deployment scanner turned off.
>15:32:01,918 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Default transaction timeout set to 600 seconds.
>15:32:02,121 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Logging category org.rhq set to [${rhq.server.log-level:INFO}]
>15:32:03,835 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] New keystore created [/home/hudson/jon-server-3.3.0.ER05/jbossas/standalone/configuration/rhq.keystore] with cert domain name of [CN=10.16.23.99, OU=RHQ, O=rhq-project.org, C=US]
>15:32:03,841 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Creating https connector...
>15:32:04,285 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] https connector created.
>15:32:04,646 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Security domain [RHQDSSecurityDomainXa] created
>15:32:04,810 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Security domain [RHQDSSecurityDomainNoTx] created
>15:32:04,918 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Cache container [rhq] created
>15:32:05,065 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Local Cache [rhqCache] created
>15:32:05,223 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Local Cache [rhqRestCache] created
>15:32:05,328 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Deployed Postgres JDBC driver
>15:32:05,564 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Deployed Oracle JDBC driver for future use
>15:32:05,739 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Created datasources
>15:32:06,353 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Enabled datasources
>15:32:06,686 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] JMS queue [AlertConditionQueue] created
>15:32:06,967 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] JMS queue [DriftChangesetQueue] created
>15:32:07,204 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] JMS queue [DriftFileQueue] created
>15:32:07,314 INFO  [org.rhq.enterprise.server.installer.ServerInstallUtil] Mail service has been configured.
>15:32:07,628 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Installing RHQ EAR startup subsystem extension
>15:32:07,971 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Will now ask the app server to reload its configuration
>15:32:07,997 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] App server has been successfully asked to reload its configuration
>15:32:10,283 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] Installing RHQ EAR subsystem
>15:32:17,441 INFO  [org.rhq.server.control.command.Upgrade] Still waiting for server to start...
>15:32:48,063 INFO  [org.rhq.server.control.command.Upgrade] Still waiting for server to start...
>15:32:50,593 INFO  [org.rhq.enterprise.server.installer.Installer] Installation is complete. The server should be ready shortly.
>15:32:53,110 INFO  [org.rhq.server.control.command.Upgrade] Upgrading RHQ agent located at: /home/hudson/rhq-agent
>======================================
>ANT target [backup-agent]
>Wed Oct 29 15:32:53 EDT 2014
>======================================
>[backup-agent] [echo] === BACKING UP CURRENT AGENT ===
>[backup-agent] [echo] From: /home/hudson/rhq-agent
>[backup-agent] [echo] To: /tmp/rhq-agent-update-backup
>[backup-agent] [copy] Copying 110 files to /tmp/rhq-agent-update-backup
>[backup-agent] [copy] Copied 16 empty directories to 3 empty directories under /tmp/rhq-agent-update-backup
>[backup-agent] [echo] === BACKUP OF CURRENT AGENT COMPLETE ===
>======================================
>ANT target [(default)]
>Wed Oct 29 15:32:53 EDT 2014
>======================================
>[header-for-update] [echo] 
>===== RHQ AGENT UPDATE =====
>Agent To Be Updated: /home/hudson/rhq-agent
>Version: 4.12.0.JON330ER05
>Build Number: 2cdb528
>Jar File: /home/hudson/jon-server-3.3.0.ER05/modules/org/rhq/server-startup/main/deployments/rhq.ear/rhq-downloads/rhq-agent/rhq-enterprise-agent-4.12.0.JON330ER05.jar
>[update] [echo] Extract the agent distro zip from the agent update binary, place in temporary update dir
>[update] [unjar] Expanding: /home/hudson/jon-server-3.3.0.ER05/modules/org/rhq/server-startup/main/deployments/rhq.ear/rhq-downloads/rhq-agent/rhq-enterprise-agent-4.12.0.JON330ER05.jar into /home/hudson/rhq-agent/update-2cdb528
>[update] [echo] Unzip the agent distro into the temporary update directory
>[update] [unzip] Expanding: /home/hudson/rhq-agent/update-2cdb528/rhq-enterprise-agent-4.12.0.JON330ER05.zip into /home/hudson/rhq-agent/update-2cdb528
>[update] [echo] Remove the agent distro zip
>[update] [delete] Deleting: /home/hudson/rhq-agent/update-2cdb528/rhq-enterprise-agent-4.12.0.JON330ER05.zip
>[update] [echo] 
>      At this point, we have the new (but raw) agent extracted to: /home/hudson/rhq-agent/update-2cdb528/rhq-agent
>      The old, existing agent (the one we are upgrading) is at: /home/hudson/rhq-agent
>      
>[update] [echo] Copy existing failover list from the old agent to the new agent
>[update] [copy] Copying 1 file to /home/hudson/rhq-agent/update-2cdb528/rhq-agent/data
>[update] [echo] Copy existing keystore and truststore files from the old agent to the new agent
>[update] [echo] Copy existing Java Service Wrapper configuration files from the old agent to the new agent
>[update] [echo] Copy Windows environment script - keep the old copy in effect and backup the new copy
>[update] [copy-with-backup] files differ, keeping old, backing up new
>[update] [echo] Copy UNIX environment script - keep the old copy in effect and backup the new copy
>[update] [copy-with-backup] files differ, keeping old, backing up new
>[update] [echo] Copy Windows wrapper launch script - use the new copy and backup the old copy
>[update] [copy-with-backup] files differ, keeping new, backing up old
>[update] [echo] Copy UNIX wrapper launch script - use the new copy and backup the old copy
>[update] [copy-with-backup] files differ, keeping new, backing up old
>[update] [echo] Copy Java Service Wrapper configuration - use the new copy and backup the old copy
>[update] [copy-with-backup] files differ, keeping new, backing up old
>[update] [echo] Copy custom scripts that may have existed in the agent bin directory
>[update] [echo] Ensure any custom scripts that were copied retain execute permissions
>[update] [echo] Copy agent configuration file - use the old copy and backup the new copy
>[update] [copy-with-backup] files differ, keeping old, backing up new
>[update] [echo] Copy log4j configuration file - use the old copy and backup the new copy
>[update] [copy-with-backup] files differ, keeping old, backing up new
>[update] [echo] 
>      Everything is done; _update.tmp.dir/rhq-agent has our new agent.
>      The old agent is still intact, albeit with a new update subdirectory with the new agent in it.
>      Start moving things around to get the new agent in the old agent's directory.
>      If anything fails going forward, bad things will happen because the old agent will be ruined.
>      
>[update] [echo] Define where we are going to put the old agent - this is where the old agent will be backed up
>[update] [echo] Purge any previously backed-up old agent
>[update] [echo] Move the old agent to the backup location
>[update] [echo] Make sure the location where the new agent is going to be is empty
>[update] [echo] Put the new agent in its new location: [/home/hudson/rhq-agent-OLD/update-2cdb528/rhq-agent] to [/home/hudson/rhq-agent]
>[update] [echo] Clean up the temporary location where the new agent was located (but no longer is)
>[update] [delete] Deleting directory /home/hudson/rhq-agent-OLD/update-2cdb528
>[update] [echo] 
>      At this point, the new agent should now be at the old agent's location.
>      The old agent is backed up to the rhq-agent-OLD directory next to new agent
>      
>[update] [echo] chmod +x on executables under /home/hudson/rhq-agent
>[update] [echo] The agent is updated and we don't need the backup anymore, so remove the first backup we made
>[update] [delete] Deleting directory /tmp/rhq-agent-update-backup
>[update] [echo] 
>      FINISHED UPDATING THE AGENT SUCCESSFULLY!
>      The new agent is now located at: /home/hudson/rhq-agent
>      
>15:32:55,283 INFO  [org.rhq.server.control.command.Upgrade] The agent installer finished updating with exit value 0
>15:32:55,284 INFO  [org.rhq.server.control.command.Upgrade] The agent has been upgraded and placed in: /home/hudson/rhq-agent
>15:32:55,285 INFO  [org.rhq.server.control.command.Upgrade] 
>
>========== UPGRADE SUMMARY ==========
>15:32:55,285 INFO  [org.rhq.server.control.command.Upgrade] Topology Versions
>15:32:56,051 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>15:32:56,573 INFO  [org.rhq.cassandra.schema.VersionManager] Preparing to check storage schema compatibility.
>15:32:57,727 INFO  [org.rhq.cassandra.schema.VersionManager] Completed storage schema compatibility check.
>15:32:57,727 INFO  [org.rhq.enterprise.server.installer.InstallerServiceImpl] 
>
>Installed Server Versions
>Server Name
>jon312up.bc.jonqe.lab.eng.bos.redhat.com	Version = 4.12.0.JON330ER05
>
>Installed Storage Node Versions
>Storage Node Address
>jon312up.bc.jonqe.lab.eng.bos.redhat.com	Version = 4.12.0.JON330ER05
>
>  ==> All Servers and Storage Nodes are at the same version. No upgrades required.
>
>Checking Storage Cluster Schema Version...
>
>  ==> The Storage Cluster version is up to date. No update required.
>
>Trying to stop the RHQ Server...
>RHQ Server (pid=4210) is stopping...
>RHQ Server has stopped.
>/home/hudson/jon-server-3.3.0.ER05/bin/rhq-server-env.sh
>Starting RHQ Data Migration ...
>15:33:01,251 INFO  [org.jboss.modules] JBoss Modules version 1.3.3.Final-redhat-1
>1066 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Server configuration file system property detected. Loading the file: /home/hudson/jon-server-3.3.0.ER05/bin/rhq-server.properties
>1206 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Server configuration file loaded based on system properties options.
>1206 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Running migration with the following optons: 
>1206 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-1h-migration : false
>1207 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-port : 5432
>1207 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-host : localhost
>1207 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   delete-data : false
>1207 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-password : <obscured value>
>1207 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-1d-migration : false
>1208 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-user : bnjcqghr
>1208 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-user : rhqadmin
>1208 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-hosts : [jon312up.bc.jonqe.lab.eng.bos.redhat.com]
>1208 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   experimental-export : false
>1208 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-port : 9142
>1209 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   estimate-only : false
>1209 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   cassandra-password : <obscured value>
>1209 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-db : rhq
>1209 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-raw-migration : false
>1209 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-connection-url : jdbc:postgresql://127.0.0.1:5432/rhq
>1210 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   sql-server-type : Postgres
>1210 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   disable-6h-migration : false
>1210 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  -   delete-only : false
>1210 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating Entity Manager
>1216 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating entity manager with the following configuration:
>1217 [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}
>2937 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Done creating Entity Manager
>2937 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Creating Cassandra session
>3023 [main] DEBUG com.datastax.driver.core.Cluster  - Starting new cluster with contact points [jon312up.bc.jonqe.lab.eng.bos.redhat.com/10.16.23.99]
>3339 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Refreshing node list and token map
>3574 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Refreshing schema
>3707 [main] DEBUG com.datastax.driver.core.ControlConnection  - [Control connection] Successfully connected to jon312up.bc.jonqe.lab.eng.bos.redhat.com/10.16.23.99
>3713 [Cassandra Java Driver worker-0] DEBUG com.datastax.driver.core.Session  - Adding jon312up.bc.jonqe.lab.eng.bos.redhat.com/10.16.23.99 to list of queried hosts
>3976 [main] DEBUG org.rhq.server.metrics.migrator.DataMigratorRunner  - Done creating Cassandra session
>Estimation process - starting
>
>4080 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:04,514 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>4167 [Thread-2] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>4168 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4173 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R00 -- 626
>4174 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4175 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R01 -- 0
>4175 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4177 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R02 -- 0
>4177 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4178 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R03 -- 0
>4179 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4180 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R04 -- 0
>4180 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4182 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R05 -- 0
>4182 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4183 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R06 -- 0
>4184 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4185 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R07 -- 0
>4187 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4188 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R08 -- 0
>4188 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4190 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R09 -- 0
>4190 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4191 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R10 -- 0
>4192 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4193 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R11 -- 0
>4193 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4195 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R12 -- 0
>4195 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4197 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R13 -- 0
>4197 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>4198 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Retrieved record count for table RHQ_MEAS_DATA_NUM_R14 -- 0
>4201 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4202 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4212 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:04,559 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>4212 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>4213 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4269 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:05,238 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R00 - 626 -
>4891 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R00 - 626 -
>4892 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 626 to 30626
>4892 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 626 to 30626
>4897 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4898 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4911 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,258 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>4911 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>4911 [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
>4912 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4914 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4916 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,265 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>4918 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>4919 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4919 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4920 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4925 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4927 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,275 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>4928 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>4931 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4931 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4931 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4932 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4935 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,284 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>4937 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>4938 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4938 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4939 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4941 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4951 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,298 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>4951 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>4952 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4952 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4952 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4953 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4954 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,301 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>4954 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>4955 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4955 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4957 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4959 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4960 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,308 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>4961 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>4963 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4964 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4964 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4966 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4970 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,317 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>4970 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>4970 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4970 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4971 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4971 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4973 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,322 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>4975 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>4975 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4975 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4976 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4977 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4978 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,325 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>4978 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>4978 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4988 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4988 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4989 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4996 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,343 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>4996 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>4997 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>4997 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>4998 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>4998 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>4999 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,347 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>5000 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>5000 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5000 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5001 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5006 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5008 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,355 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>5008 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>5008 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5008 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5009 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5010 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5013 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>15:33:05,360 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>5013 [Thread-2] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>5013 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5014 [Thread-2] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5014 [Thread-2] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 615 entries
>5618 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:06,019 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.
>5672 [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.
>15:33:06,027 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5680 [Thread-4] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5682 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>5684 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table one_hour_metrics -- 0
>5684 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5685 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5697 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>5697 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5697 [Thread-4] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5698 [Thread-4] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>5698 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:06,053 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.
>5706 [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.
>15:33:06,062 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5715 [Thread-5] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5716 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>5719 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table six_hour_metrics -- 0
>5719 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5719 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5721 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>5722 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5722 [Thread-5] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5722 [Thread-5] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>15:33:06,104 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5757 [Thread-6] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>5758 [Thread-6] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>5760 [Thread-6] DEBUG org.rhq.server.metrics.migrator.workers.AggregateDataMigrator  - Retrieved record count for table twenty_four_hour_metrics -- 0
>5760 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5760 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with 150000 results.
>5765 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with 150000 results.
>5765 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5765 [Thread-6] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>5765 [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 159 milliseconds)
>
>Estimation process - ended
>
>
>Migration process - starting
>
>5766 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:06,124 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>5777 [Thread-7] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.RawDataMigrator
>5782 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>5784 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>5789 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,136 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>5789 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R00
>5789 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>5832 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,430 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] - RHQ_MEAS_DATA_NUM_R00 - 626 -
>6083 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - - RHQ_MEAS_DATA_NUM_R00 - 626 -
>6084 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 626 to 30626
>6084 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 626 to 30626
>15:33:06,431 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R00---------------------
>6084 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R00---------------------
>6085 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6086 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6087 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,434 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>6087 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R01
>6088 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6088 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,435 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R01---------------------
>6088 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R01---------------------
>6089 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6090 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6091 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,438 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>6091 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R02
>6092 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6092 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,439 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R02---------------------
>6092 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R02---------------------
>6093 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6094 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6095 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,442 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>6095 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R03
>6095 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6096 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,443 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R03---------------------
>6096 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R03---------------------
>6097 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6097 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6098 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,445 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>6098 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R04
>6099 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6099 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,446 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R04---------------------
>6099 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R04---------------------
>6100 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6100 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6101 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,448 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>6101 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R05
>6103 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6104 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,451 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R05---------------------
>6104 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R05---------------------
>6110 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6111 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6112 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,459 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>6112 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R06
>6113 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6113 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,460 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R06---------------------
>6113 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R06---------------------
>6114 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6114 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6115 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,463 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>6116 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R07
>6116 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6116 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,463 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R07---------------------
>6116 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R07---------------------
>6117 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6117 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6118 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,466 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>6119 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R08
>6119 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6119 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,466 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R08---------------------
>6119 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R08---------------------
>6120 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6121 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6122 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,469 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>6122 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R09
>6122 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6122 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,470 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R09---------------------
>6123 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R09---------------------
>6123 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6124 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6125 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,472 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>6125 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R10
>6126 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6126 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,473 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R10---------------------
>6126 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R10---------------------
>6127 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6127 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6128 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,476 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>6129 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R11
>6129 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6129 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,476 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R11---------------------
>6129 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R11---------------------
>6130 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6131 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6132 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,479 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>6132 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R12
>6132 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6133 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,480 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R12---------------------
>6133 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R12---------------------
>6133 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6134 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6135 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,482 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>6135 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R13
>6136 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6136 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,483 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R13---------------------
>6136 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R13---------------------
>6137 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6137 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6138 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>15:33:06,486 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>6139 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Start migrating raw table: RHQ_MEAS_DATA_NUM_R14
>6139 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6139 [Thread-7] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>15:33:06,486 INFO  [org.rhq.server.metrics.migrator.workers.RawDataMigrator] Done migrating raw tableRHQ_MEAS_DATA_NUM_R14---------------------
>6139 [Thread-7] INFO org.rhq.server.metrics.migrator.workers.RawDataMigrator  - Done migrating raw tableRHQ_MEAS_DATA_NUM_R14---------------------
>6140 [Thread-7] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 615 entries
>6580 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:06,935 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.
>6588 [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.
>15:33:06,944 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6597 [Thread-8] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6598 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6599 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6600 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>6600 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6600 [Thread-8] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>6600 [Thread-8] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>6601 [main] DEBUG org.rhq.server.metrics.migrator.workers.AbstractMigrationWorker  - Preparing SQL connection with timeout: 6000000
>15:33:06,951 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.
>6604 [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.
>15:33:06,952 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6605 [Thread-9] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6605 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6606 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6607 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>6607 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6607 [Thread-9] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>6607 [Thread-9] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>15:33:06,955 INFO  [org.rhq.server.metrics.migrator.DataMigrator] class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6608 [Thread-10] INFO org.rhq.server.metrics.migrator.DataMigrator  - class org.rhq.server.metrics.migrator.workers.AggregateDataMigrator
>6609 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing SQL connection with timeout: 6000000
>6609 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Preparing the query with all the results.
>6610 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Query prepared with all the results.
>6610 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Reading lines 0 to 30000
>6611 [Thread-10] DEBUG org.rhq.server.metrics.migrator.datasources.ScrollableDataSource  - Read lines 0 to 30000
>6611 [Thread-10] DEBUG org.rhq.server.metrics.migrator.workers.MetricsIndexMigrator  - Draining metrics index accumulator with 0 entries
>The migration process took: 0 minutes (or 845 milliseconds)
>
>Migration process - ended
>
>6611 [main] DEBUG com.datastax.driver.core.Cluster  - Shutting down
>6614 [main] DEBUG com.datastax.driver.core.HostConnectionPool  - Shutting down pool
>15:33:06,987 INFO  [org.rhq.server.control.command.Upgrade] The data migrator finished with exit value 0
>

Actions: View

Attachments on bug 1082805: 949388 | 949820 | 951552 | 951905