You are viewing the RapidMiner Server documentation for version 9.3 - Check here for latest version

Troubleshooting

This article outlines common problems while upgrading RapidMiner Server.

Timeout during RapidMiner Server start

You might see the following log lines in the server.log file within the RapidMiner Server home directory:

ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS013412: Timeout after [300] seconds waiting for service container stability. Operation will roll back. Step that first updated the service container was 'add' at address '[
    ("core-service" => "management"),
    ("management-interface" => "native-interface")
]'
ERROR [org.jboss.as.controller.client] (Controller Boot Thread) JBAS014781: Step handler org.jboss.as.server.DeployerChainAddHandler$FinalRuntimeStepHandler@2821a6c1 for operation {"operation" => "add-deployer-chains","address" => []} at address [] failed handling operation rollback -- java.util.concurrent.TimeoutException

Explanation: JBoss requires a lot of time to start after the initial upgrade and then times out. This can happen because a column has been added in the new version and the existing table needs to be migrated. When such tables are large, the migration can take a lot of time and exceed the JBoss deployment time which is 300 seconds by default.

Solution: The property jboss.as.management.blocking.timeout is used to determine how long a deployment might take before JBoss aborts the deployment. A solution to the problem is to temporarily increase the default timeout. Please use the following statement (.bat on Windows) to start RapidMiner Server for a temporary timeout increase: ./bin/standalone.sh -Djboss.as.management.blocking.timeout=3600. After the upgrade completed successfully the timeout increase is not required anymore.

Migrating RapidMiner Server Database from MySQL 5.x to 8.x

With version 8.x, MySQL added system as a new reserved key word that cannot be used as table name neither can it be used as column name. RapidMiner Server database schema contains a table column named system. So creating RapidMiner Server database dump from MySQL 5.x without renaming the column named system and importing the dump in MySQL 8.x will fail with an error message like:

SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'system ...'

In order to avoid this error, we recommend you do the following changes to your RapidMiner Server database before creating the dump:

Backup your RapidMiner Server database

Rename ra_ent_dbconnectionentry.system column name to databaseSystem

 ALTER TABLE `<YOUR_RM_SERVER_DATABASE>`.`ra_ent_dbconnectionentry`
 RENAME COLUMN `system` TO `databaseSystem`

Check if your RapidMiner Server database contains the table ra_ent_migration. If this table does not exist please run this SQL command:

 CREATE TABLE `<YOUR_RM_SERVER_DATABASE>`.`ra_ent_migration` (
   `migrationStep` varchar(255) NOT NULL,
   `executedAt` datetime DEFAULT NULL,
   `serverVersion` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`migrationStep`)
 )

Insert a new data entry to the ra_ent_migration table by running this sql command

 INSERT INTO `<YOUR_RM_SERVER_DATABASE>`.`ra_ent_migration` (`migrationStep`)
 VALUES ('MIGRATE_SYSTEM_COLUMN');

Now create a SQL dump for your MySQL 5.x databases used by RapidMiner Server
Import the SQL dump into MySQL 8.x RapidMiner Server database

Categories

Versions

Troubleshooting

Timeout during RapidMiner Server start

Migrating RapidMiner Server Database from MySQL 5.x to 8.x