Problem in ScrumWorks Pro installation process

Edit Subject

Hello,

What version of MySQL are you using, and what language is your system set to? Is your MySQL install on the same server as the Scrumworks install?

Please go through this documentation carefully, and make sure you have correctly setup the require MySQL connector, and have enabled InnoDB and UTF-8 character set.

http://www.danube.com/docs/scrumworks...

Mark,

I am running into the same issue. I have MySQL 5.5.16.0 and my system is English (US). I double checked the two parameters in the db and they are both checked. Here's the WARN and ERROR from my scrumworks-updater.log file:

17:48:01,923 WARN [SchemaUpdater] Error migrating database:
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-f0c_3e' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:109)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:137)
at com.danube.scrumworks.upgrader.UpdateDatabase.main(UpdateDatabase.java:367)
17:48:01,939 WARN [SchemaUpdater] error code: 1025
17:48:01,939 WARN [SchemaUpdater] sql state: HY000
17:48:01,939 WARN [SchemaUpdater] cause: null
17:48:01,939 WARN [SchemaUpdater] next exception: null
17:48:01,939 WARN [SchemaUpdater] sql state: HY000
17:48:01,939 ERROR [UpdateDatabase] Error updating database
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-f0c_3e' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:109)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:137)
at com.danube.scrumworks.upgrader.UpdateDatabase.main(UpdateDatabase.java:367)

Currently we only recommend using MySQL 5.0 or 5.1.

Could you try downgrading to 5.1 and seeing if it reproduces the error?

Also, a MySQL user must also be supplied with permissions to drop and create tables inside that database. Note that general MySQL security practices recommend creating users with special permissions rather than using the "root" user directly. Please be sure the user referenced in the error has those permissions.

Mark,

I'm also having the same issue.
I have testet with both Windows 2008r2 server and Win7. Have tried MySQL 5.1 x32 and x64 and even 5.5.
The result is always the same: Failed updating the database. Please see ...scrumworks-updater.log....

The final lines in the log says:

13:26:51,029 DEBUG [UpdateDatabase] SET foreign_key_checks = 1
13:26:51,029 DEBUG [UpdateDatabase] --- End of failed batch
13:26:51,029 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `db` ENGINE = InnoDB
13:26:51,029 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `general_log` ENGINE = InnoDB
13:26:51,029 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `host` ENGINE = InnoDB
13:26:51,029 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `slow_log` ENGINE = InnoDB
13:26:51,029 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `user` ENGINE = InnoDB
13:26:51,029 WARN [SchemaUpdater] Error migrating database:
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-464_d' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.sql.DefaultSQLRunner.executeBatch(DefaultSQLRunner.java:59)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:122)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:108)
at com.danube.scrumworks.upgrader.Updater.main(Updater.java:109)
13:26:51,029 WARN [SchemaUpdater] error code: 1025
13:26:51,029 WARN [SchemaUpdater] sql state: HY000
13:26:51,029 WARN [SchemaUpdater] cause: null
13:26:51,029 WARN [SchemaUpdater] next exception: null
13:26:51,029 WARN [SchemaUpdater] sql state: HY000
13:26:51,075 ERROR [Updater] Error updating database
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-464_d' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.sql.DefaultSQLRunner.executeBatch(DefaultSQLRunner.java:59)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:122)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:108)
at com.danube.scrumworks.upgrader.Updater.main(Updater.java:109)

Any idea?

Have you configured the Database to use the InnoDB format? As of version 5.0+ of our software you can no longer use MyISAM with Scrumworks. As MyISAM is the default used by MySQL, you may need to manually enable it.

Please look over out instructions here: http://www.danube.com/docs/scrumworks...

You can use them to double check to make sure that InnoDB is enabled.

Yes, I think MySQL is correct configured. I have also tried to create a new user in the database before installing. MY.INI looks like this (comments removed):

[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=52M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=103M
key_buffer_size=9M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=7M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_size=313M
innodb_log_file_size=157M
innodb_thread_concurrency=8
log-output = TABLE
innodb = ON

I Have done everything said in this post and I'm still having the same issue has
AsgeirK, dan.meeks and R.Karthickumar can you please give us another solution It would be great to use your product.

Any solution to this problem?

Well,

I am investigating some issues with our up grader. Could you send a copy of your upgrade.log file, which should be with your Scrumworks logs? That might better tell us what went wrong. You can send it to mlovell@collab.net.

Hi everyone,

I got the same issue on Win 7 with MySQL server 5.5 and on Win Server 2008 R2 with MySQL server 5.1. For both, it was mysql-connector-java-5.1.18.

Here's the log:

10:19:37,233 WARN [Updater] url: jdbc:mysql://localhost:3306/MySQL
10:19:37,608 DEBUG [UpdateDatabase] Current db version: 5.1.0
10:19:37,640 INFO [UpdateDatabase] Running migration from
10:19:37,662 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@44a613f8
10:19:37,662 DEBUG [SchemaUpdater] Executing: set sql_mode=NO_ENGINE_SUBSTITUTION
10:19:37,663 DEBUG [SchemaUpdater] Closing statement
10:19:37,663 DEBUG [SchemaUpdater] Closed
10:19:37,663 DEBUG [SchemaUpdater] Checking to see if changes were made..
10:19:37,679 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@4eedf3f6
10:19:37,685 INFO [UpdateDatabase] Skipping Version200to210.consolidateTeamMemberNames(), migration already done.
10:19:37,704 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@811978b
10:19:37,706 DEBUG [SchemaUpdater] Executing: set sql_mode=NO_ENGINE_SUBSTITUTION
10:19:37,706 DEBUG [SchemaUpdater] Closing statement
10:19:37,706 DEBUG [SchemaUpdater] Closed
10:19:37,706 DEBUG [SchemaUpdater] Checking to see if changes were made..
10:19:37,708 INFO [UpdateDatabase] Running migration from ProToBasicToProUpgrade
10:19:37,727 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@6d3f7281
10:19:37,737 DEBUG [SafeQuery] getQueryString(Connection) - : boolean needsToRun=true, q=alter table taskejb alter column taskboardstatusrank double
10:19:37,738 DEBUG [SchemaUpdater] upgrade(SafeQuery[]) - : String query=alter table taskejb modify column taskboardstatusrank double
10:19:37,739 DEBUG [SchemaUpdater] Executing: set sql_mode=NO_ENGINE_SUBSTITUTION
10:19:37,739 DEBUG [SchemaUpdater] Executing: alter table taskejb modify column taskboardstatusrank double
10:19:37,951 DEBUG [SchemaUpdater] Closing statement
10:19:37,952 DEBUG [SchemaUpdater] Closed
10:19:37,952 DEBUG [SchemaUpdater] Checking to see if changes were made..
10:19:37,961 DEBUG [SafeQuery] getQueryString(Connection) - : boolean needsToRun=true, q=alter table taskejb alter column taskboardstatusrank double
10:19:37,977 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@5488e2dd
10:19:38,040 DEBUG [ProToBasicToProUpgrade] query = delete from shorturlejb where lastaccessedtime < 1312363178040
10:19:38,046 INFO [ProToBasicToProUpgrade] 0 old (not accessed in 6 months) short urls deleted.
10:19:38,499 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@7d95d4fe
10:19:38,499 DEBUG [SchemaUpdater] Executing: set sql_mode=NO_ENGINE_SUBSTITUTION
10:19:38,499 DEBUG [SchemaUpdater] Closing statement
10:19:38,499 DEBUG [SchemaUpdater] Closed
10:19:38,499 DEBUG [SchemaUpdater] Checking to see if changes were made..
10:19:38,504 DEBUG [MysqlIndexManipulator] index 'idx_sequence_name' exists? true
10:19:38,506 DEBUG [MysqlIndexManipulator] index 'idx_changelogdata_type' exists? false
10:19:38,506 INFO [MysqlIndexManipulator] creating index idx_changelogdata_type
10:19:39,073 DEBUG [MysqlIndexManipulator] index 'idx_changelogdata_entryid' exists? true
10:19:39,074 DEBUG [MysqlIndexManipulator] index 'idx_mytasksrank_taskid' exists? true
10:19:39,075 DEBUG [MysqlIndexManipulator] index 'idx_changelog_productid' exists? true
10:19:39,076 DEBUG [MysqlIndexManipulator] index 'idx_user_username' exists? true
10:19:39,077 DEBUG [MysqlIndexManipulator] index 'idx_usercollapseditem_user_and_product' exists? true
10:19:39,079 DEBUG [MysqlIndexManipulator] index 'idx_themes_by_pbi' exists? true
10:19:39,082 DEBUG [MysqlIndexManipulator] index 'idx_task_pbi' exists? true
10:19:39,084 DEBUG [MysqlIndexManipulator] index 'idx_taskestimate_task' exists? true
10:19:39,085 DEBUG [MysqlIndexManipulator] index 'idx_setting_user_product' exists? true
10:19:39,086 DEBUG [MysqlIndexManipulator] index 'idx_admins_products_products' exists? true
10:19:39,087 DEBUG [MysqlIndexManipulator] index 'idx_admins_products_users' exists? true
10:19:39,088 DEBUG [MysqlIndexManipulator] index 'idx_productrole_user' exists? true
10:19:39,089 DEBUG [MysqlIndexManipulator] index 'idx_productrole_product' exists? true
10:19:39,092 DEBUG [MysqlIndexManipulator] index 'idx_pbi_sprint' exists? true
10:19:39,094 DEBUG [MysqlIndexManipulator] index 'idx_pbi_release' exists? true
10:19:39,097 DEBUG [MysqlIndexManipulator] index 'idx_pbi_product' exists? true
10:19:39,103 DEBUG [MysqlIndexManipulator] index 'idx_pbi_parenthistory' exists? true
10:19:39,104 DEBUG [MysqlIndexManipulator] index 'idx_pbiestimate_pbi' exists? true
10:19:39,106 DEBUG [MysqlIndexManipulator] index 'idx_sprint_product' exists? true
10:19:39,107 DEBUG [MysqlIndexManipulator] index 'idx_impediment_product' exists? true
10:19:39,108 DEBUG [MysqlIndexManipulator] index 'idx_release_product' exists? true
10:19:39,109 DEBUG [MysqlIndexManipulator] index 'idx_theme_product' exists? true
10:19:39,112 DEBUG [MysqlIndexManipulator] index 'idx_backlogitem_active' exists? true
10:19:39,113 DEBUG [MysqlIndexManipulator] index 'idx_sprint_active' exists? true
10:19:39,114 DEBUG [MysqlIndexManipulator] index 'idx_release_active' exists? true
10:19:39,115 DEBUG [MysqlIndexManipulator] index 'idx_programs_products_program' exists? true
10:19:39,116 DEBUG [MysqlIndexManipulator] index 'idx_programs_products_product' exists? true
10:19:39,117 DEBUG [MysqlIndexManipulator] index 'idx_theme_program' exists? false
10:19:39,117 INFO [MysqlIndexManipulator] creating index idx_theme_program
10:19:39,442 DEBUG [MysqlIndexManipulator] index 'idx_theme_programepic' exists? false
10:19:39,443 INFO [MysqlIndexManipulator] creating index idx_theme_programepic
10:19:39,758 DEBUG [MysqlIndexManipulator] index 'idx_release_program' exists? true
10:19:39,760 DEBUG [MysqlIndexManipulator] index 'idx_programcollapseditem_usr_program' exists? true
10:19:39,762 DEBUG [MysqlIndexManipulator] index 'idx_backlogitemstatus_product' exists? true
10:19:39,783 DEBUG [SchemaUpdater] conn = com.mysql.jdbc.JDBC4Connection@45d6a56e
10:19:39,785 INFO [UpdateDatabase] baseUrls: {http://jira2.bellevue.danube.com:8080...}
10:19:39,785 INFO [UpdateDatabase] adding query: update backlogitemsourceejb set fieldvalue = 'http://jira2.bellevue.danube.com:8080' where fieldvalue = 'http://jira2.bellevue.danube.com:8080'
10:19:39,788 INFO [DatabaseMaintenance] Removed 0 changelog entries with no changes.
10:19:39,866 DEBUG [DatabaseMaintenance] Updated 0 null task statuses.
10:19:39,867 DEBUG [DatabaseMaintenance] Number of orphan program epics deleted: 0
10:19:39,867 DEBUG [DatabaseMaintenance] 0 sprint names changed from null
10:20:14,072 DEBUG [UpdateDatabase] failed batch:
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-2b9c_c' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.sql.DefaultSQLRunner.executeBatch(DefaultSQLRunner.java:59)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:122)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:108)
at com.danube.scrumworks.upgrader.Updater.main(Updater.java:118)
10:20:14,074 DEBUG [UpdateDatabase] SET foreign_key_checks = 0
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `admins_products` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `attachment` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogestimateejb` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitem_attachment` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemejb` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemejb_aud` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemparenthistoryejb` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitems_programthemes` ENGINE = InnoDB
10:20:14,074 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemsourceejb` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemstatus` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemstatus_aud` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `backlogitemstatushistory` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `businessweighthistoryejb` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `changelog` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `changelogdata` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `columns_priv` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `comment` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `comment_backlogitem` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `comment_task` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `db` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `event` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `func` ENGINE = InnoDB
10:20:14,075 DEBUG [UpdateDatabase] ALTER TABLE `general_log` ENGINE = InnoDB
10:20:14,076 DEBUG [UpdateDatabase] ALTER TABLE `help_category` ENGINE = InnoDB
10:20:14,076 DEBUG [UpdateDatabase] ALTER TABLE `help_keyword` ENGINE = InnoDB
10:20:14,076 DEBUG [UpdateDatabase] ALTER TABLE `help_relation` ENGINE = InnoDB
10:20:14,076 DEBUG [UpdateDatabase] ALTER TABLE `help_topic` ENGINE = InnoDB
10:20:14,076 DEBUG [UpdateDatabase] ALTER TABLE `host` ENGINE = InnoDB
10:20:14,112 DEBUG [UpdateDatabase] ALTER TABLE `impedimentejb` ENGINE = InnoDB
10:20:14,112 DEBUG [UpdateDatabase] ALTER TABLE `licenseejb` ENGINE = InnoDB
10:20:14,112 DEBUG [UpdateDatabase] ALTER TABLE `mytasksrank` ENGINE = InnoDB
10:20:14,112 DEBUG [UpdateDatabase] ALTER TABLE `ndb_binlog_index` ENGINE = InnoDB
10:20:14,112 DEBUG [UpdateDatabase] ALTER TABLE `notification` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `notificationsubscription` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `permalinksettingejb` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `plugin` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `proc` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `procs_priv` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `product_programepic` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `product_programepic_aud` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `productejb` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `productejb_aud` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `productepic` ENGINE = InnoDB
10:20:14,113 DEBUG [UpdateDatabase] ALTER TABLE `productepic_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `productroleejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programcollapseditem` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programejb_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programepic` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programepic_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programs_products` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `programs_products_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `releaseejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `releaseejb_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `releaserank` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `releaserank_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `revisioninfo` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `revisionsequence` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `roleejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `scrumworksversion` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `sequenceejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `servers` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `settingejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `shorturlejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `slow_log` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `sprintejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `sprintejb_aud` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `sprintestimateejb` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `sprintnonworkingday` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `tables_priv` ENGINE = InnoDB
10:20:14,114 DEBUG [UpdateDatabase] ALTER TABLE `taskejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `taskejb_aud` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `taskestimateejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `taskhoursspentejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `teamejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `teamejb_aud` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `teams_products` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `teams_products_aud` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `teams_users` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `themeejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `themeejb_aud` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `themeejb_backlogitems_backlogitemejb_themes` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `themeejb_backlogitems_backlogitemejb_themes_aud` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `time_zone` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `time_zone_leap_second` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `time_zone_name` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `time_zone_transition` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `time_zone_transition_type` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `uncategorizedbudget` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `user` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `usercollapseditemejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `userejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `userejb_roles_roleejb_users` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `users_productroles` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `users_programs` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `webreportgroundejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] ALTER TABLE `webreportwholeejb` ENGINE = InnoDB
10:20:14,115 DEBUG [UpdateDatabase] SET foreign_key_checks = 1
10:20:14,115 DEBUG [UpdateDatabase] --- End of failed batch
10:20:14,116 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `db` ENGINE = InnoDB
10:20:14,116 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `general_log` ENGINE = InnoDB
10:20:14,116 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `host` ENGINE = InnoDB
10:20:14,116 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `slow_log` ENGINE = InnoDB
10:20:14,116 DEBUG [UpdateDatabase] Failed query: ALTER TABLE `user` ENGINE = InnoDB
10:20:14,116 WARN [SchemaUpdater] Error migrating database:
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-2b9c_c' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.sql.DefaultSQLRunner.executeBatch(DefaultSQLRunner.java:59)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:122)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:108)
at com.danube.scrumworks.upgrader.Updater.main(Updater.java:118)
10:20:14,117 WARN [SchemaUpdater] error code: 1025
10:20:14,117 WARN [SchemaUpdater] sql state: HY000
10:20:14,117 WARN [SchemaUpdater] cause: null
10:20:14,117 WARN [SchemaUpdater] next exception: null
10:20:14,117 WARN [SchemaUpdater] sql state: HY000
10:20:14,134 ERROR [Updater] Error updating database
java.sql.BatchUpdateException: Error on rename of '.\mysql\#sql-2b9c_c' to '.\mysql\user' (errno: -1)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1139)
at com.danube.scrumworks.upgrader.sql.DefaultSQLRunner.executeBatch(DefaultSQLRunner.java:59)
at com.danube.scrumworks.upgrader.migration.MigrationCommand.executeBatch(MigrationCommand.java:122)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.setInnoDbTableTypes(DatabaseMaintenance.java:335)
at com.danube.scrumworks.upgrader.migration.DatabaseMaintenance.execute(DatabaseMaintenance.java:100)
at com.danube.scrumworks.upgrader.SchemaUpdater.migrate(SchemaUpdater.java:101)
at com.danube.scrumworks.upgrader.UpdateDatabase.execute(UpdateDatabase.java:108)
at com.danube.scrumworks.upgrader.Updater.main(Updater.java:118)

Please let me know when a solution has been found.
Thanks,
Gwena gwenael@stereograph.fr

The MySQL log file may help as well

120130 9:51:49 [Note] Plugin 'FEDERATED' is disabled.
120130 9:51:50 InnoDB: Initializing buffer pool, size = 973.0M
120130 9:51:50 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
120130 9:51:50 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120130 9:51:56 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 487 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400
120130 9:52:26 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 487 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
120130 9:52:54 InnoDB: Started; log sequence number 0 0
120130 9:52:54 [Note] Event Scheduler: Loaded 0 events
120130 9:52:54 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.61-community' socket: '' port: 3306 MySQL Community Server (GPL)
InnoDB: Error: trying to create a MySQL system table mysql/db of type InnoDB.
InnoDB: MySQL system tables must be of the MyISAM type!
120130 10:19:45 InnoDB: Error: table `mysql`.`db` does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.1/e...
InnoDB: Error: trying to create a MySQL system table mysql/host of type InnoDB.
InnoDB: MySQL system tables must be of the MyISAM type!
120130 10:19:47 InnoDB: Error: table `mysql`.`host` does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.1/e...
InnoDB: Error: trying to create a MySQL system table mysql/user of type InnoDB.
InnoDB: MySQL system tables must be of the MyISAM type!
120130 10:20:12 InnoDB: Error: table `mysql`.`user` does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.1/e...

Well the primary connector file that we require is found here: http://dev.mysql.com/downloads/connec...

Alternate versions will likely fail, or are untested with Scrumworks.

Also, Be sure you have setup an Empty MySQL database that is UTF-8 character set ready and is using the InnoDB settings with a user created with full permissions in that database. If you do not have that database present you may accidentally point Scrumworks to your core MySQL tables database, and that would then cause all kinds of issues.

Take a look here: http://www.danube.com/docs/scrumworks...
to make sure your database has been setup correctly for us to use MySQL.