Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

Quickbuild 4.0 and mySQL 5.1.61 #1873

ssrivastava ·
Hello,
I am having trouble setting up Qb 4.0 and mySQL 5.1.61 on AIX.

I followed the steps of configuring mysql as mentioned in hibernate.properties. However, i get the following error while starting qb:

jvm 1 | !ENTRY org.eclipse.osgi 4 0 2012-05-29 14:38:39.023
jvm 1 | !MESSAGE Error reading configuration: Unable to create lock manager.
jvm 1 | !STACK 0
jvm 1 | java.io.IOException: Unable to create lock manager.


The error above seems like an access issue and that's why i created users within mysql DB and gave all necessary permissions.
Does anyone have a more detailed mysql setup documentation?

Any help in this regard would be appreciated.

Thanks,
Sumit
  • replies 10
  • views 5865
  • stars 0
robinshen ADMIN ·
Can you please post full stack trace of the error?
ssrivastava ·
Hi Robin.. Here it is!

./server.sh console
Running QuickBuild Server...
wrapper | --> Wrapper Started as Console
wrapper | Java Service Wrapper Standard Edition 64-bit 3.5.12
wrapper | Copyright (C) 1999-2011 Tanuki Software, Ltd. All Rights Reserved.
wrapper | http://wrapper.tanukisoftware.com
wrapper | Licensed to PMEase Inc. for QuickBuild
wrapper |
wrapper | Launching a JVM...
jvm 1 | WrapperManager: Initializing...
jvm 1 | 2012-05-29 21:20:24,059 INFO - Cleaning temp directory...
jvm 1 | 2012-05-29 21:20:24,216 INFO - Benchmarking...
jvm 1 | 2012-05-29 21:20:28,280 INFO - Booting QuickBuild from '/usr/local/apps/qb4.0/quickbuild-4.0.30'...
jvm 1 | 2012-05-29 21:20:28,283 INFO - Starting framework...
jvm 1 | !SESSION 2012-05-29 21:20:28.601 -----------------------------------------------
jvm 1 | eclipse.buildId=unknown
jvm 1 | java.fullversion=J2RE 1.5.0 IBM J9 2.3 AIX ppc-32 j9vmap3223ifx-20110209 (JIT enabled)
jvm 1 | J9VM - 20110202_74536_bHdSMr
jvm 1 | JIT - 20100623_16197ifx3_r8
jvm 1 | GC - 20100211_AA
jvm 1 | BootLoader constants: OS=aix, ARCH=ppc, WS=motif, NL=en_US
jvm 1 |
jvm 1 | !ENTRY org.eclipse.osgi 4 0 2012-05-29 21:20:28.603
jvm 1 | !MESSAGE The -clean (osgi.clean) option was not successful. Unable to clean the storage area: /usr/local/apps/qb4.0/quickbuild-4.0.30/framework/configuration/org.eclipse.osgi
jvm 1 |
jvm 1 | !ENTRY org.eclipse.osgi 4 0 2012-05-29 21:20:28.622
jvm 1 | !MESSAGE Error reading configuration: Unable to create lock manager.
jvm 1 | !STACK 0
jvm 1 | java.io.IOException: Unable to create lock manager.
jvm 1 | at org.eclipse.osgi.storagemanager.StorageManager.open(StorageManager.java:688)
jvm 1 | at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initFileManager(BaseStorage.java:220)
jvm 1 | at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initialize(BaseStorage.java:154)
jvm 1 | at org.eclipse.osgi.baseadaptor.BaseAdaptor.initializeStorage(BaseAdaptor.java:123)
jvm 1 | at org.eclipse.osgi.framework.internal.core.Framework.initialize(Framework.java:189)
jvm 1 | at org.eclipse.osgi.framework.internal.core.Framework.<init>(Framework.java:161)
jvm 1 | at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:261)
jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 1 | at java.lang.reflect.Method.invoke(Method.java:618)
jvm 1 | at com.pmease.quickbuild.bootstrap.Bootstrap.boot(Bootstrap.java:537)
jvm 1 | at com.pmease.quickbuild.bootstrap.Bootstrap.main(Bootstrap.java:127)
jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 1 | at java.lang.reflect.Method.invoke(Method.java:618)
jvm 1 | at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:264)
jvm 1 | at java.lang.Thread.run(Thread.java:811)
jvm 1 | WrapperStartStopApp:
jvm 1 | WrapperStartStopApp Error: Encountered an error running start main: java.lang.reflect.InvocationTargetException
jvm 1 | WrapperStartStopApp Error: java.lang.reflect.InvocationTargetException
jvm 1 | WrapperStartStopApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 1 | WrapperStartStopApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
jvm 1 | WrapperStartStopApp Error: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 1 | WrapperStartStopApp Error: at java.lang.reflect.Method.invoke(Method.java:618)
jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.boot(Bootstrap.java:537)
jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.main(Bootstrap.java:127)
jvm 1 | WrapperStartStopApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jvm 1 | WrapperStartStopApp Error: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
jvm 1 | WrapperStartStopApp Error: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
jvm 1 | WrapperStartStopApp Error: at java.lang.reflect.Method.invoke(Method.java:618)
jvm 1 | WrapperStartStopApp Error: at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:264)
jvm 1 | WrapperStartStopApp Error: at java.lang.Thread.run(Thread.java:811)
jvm 1 | Caused by: WrapperStartStopApp Error: java.lang.RuntimeException: Unable to create lock manager.
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.framework.internal.core.Framework.initialize(Framework.java:191)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.framework.internal.core.Framework.<init>(Framework.java:161)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:261)
jvm 1 | WrapperStartStopApp Error: ... 12 more
jvm 1 | Caused by: WrapperStartStopApp Error: java.io.IOException: Unable to create lock manager.
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.storagemanager.StorageManager.open(StorageManager.java:688)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initFileManager(BaseStorage.java:220)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initialize(BaseStorage.java:154)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.baseadaptor.BaseAdaptor.initializeStorage(BaseAdaptor.java:123)
jvm 1 | WrapperStartStopApp Error: at org.eclipse.osgi.framework.internal.core.Framework.initialize(Framework.java:189)
jvm 1 | WrapperStartStopApp Error: ... 14 more
wrapper | <-- Wrapper Stopped
robinshen ADMIN ·
Please make sure that the OS user running QuickBuild process has full permission against directory "/usr/local/apps/qb4.0/quickbuild-4.0.30" and all its sub directories.
ssrivastava ·
Hi,
Thanks for your response.

The user owns the entire filesystem and has 775 permissions on it.
One thing that i'm not sure of is the mySQL setup. Do you have any document that captures the step by step of mysql configuration?

I couldn't find much info on that in the QB upgrade doc.
robinshen ADMIN ·
MySQL setup guide is documented in hibernate.properties and I quote it here:

# 1. Download MySQL JDBC driver package from 
# "http://www.mysql.com/downloads/connector/j/", and put the file
# "mysql-connector-java-xxx.jar" (you'll get it after the package has been
# extracted) under the "plugins/com.pmease.quickbuild.libs" sub directory of
# QuickBuild server's installation directory.
# IMPORTANT: Do not use MySQL JDBC driver version 3.x as it has bugs when operating
# large binary data.
# 2. Uncomment MySQL settings below and comment out settings for other databases.
# 3. Create an empty QuickBuild schema at MySQL side.
# 4. Change the property "hibernate.connection.url", "hibernate.connection.username",
# and "hibernate.connection.password" so that QuickBuild can connect and write to
# the database created in step 3.
# 5. Make sure the default storage engine of the MySQL server is set to "innodb". On
# Unix systems, this normally can be done by editing "/etc/my.cnf" and set entry
# "default-storage-engine=innodb".
# 6. After QuickBuild starts up, checks the QuickBuild schema with MySQL toosl to make
# sure all tables are of innodb type.


However this error does not related to MySQL. The other reason I can think of is that you are placing QuickBuild on a network mounted file system which JVM has problem to create lock files on. If so, please place QB installation to a local driver to see if it works.
ssrivastava ·
Hi,

I actually figured that the QB user was unable to write in a directory that was owned by "mysql" . I corrected that issue.
Now, when i'm trying to start it.. i get this:

No data version found in database

:/usr/local/apps/qb4.0/quickbuild-4.0.30/bin>./server.sh console
Running QuickBuild Server...
wrapper | --> Wrapper Started as Console
wrapper | Java Service Wrapper Standard Edition 64-bit 3.5.12
wrapper | Copyright (C) 1999-2011 Tanuki Software, Ltd. All Rights Reserved.
wrapper | http://wrapper.tanukisoftware.com
wrapper | Licensed to PMEase Inc. for QuickBuild
wrapper |
wrapper | Launching a JVM...
jvm 1 | WrapperManager: Initializing...
jvm 1 | 2012-06-04 16:32:08,241 INFO - Cleaning temp directory...
jvm 1 | 2012-06-04 16:32:08,439 INFO - Benchmarking...
jvm 1 | 2012-06-04 16:32:11,933 INFO - Booting QuickBuild from '/usr/local/apps/qb4.0/quickbuild-4.0.30'...
jvm 1 | 2012-06-04 16:32:11,945 INFO - Starting framework...
jvm 1 | 2012-06-04 16:32:15,577 INFO - Starting QuickBuild server...
jvm 1 | 2012-06-04 16:32:15,578 INFO - Starting IOC container...
jvm 1 | 2012-06-04 16:32:15,988 INFO - Initializing velocity...
jvm 1 | 2012-06-04 16:32:16,976 INFO - Checking data version...
jvm 1 | 2012-06-04 16:32:17,491 INFO - QuickBuild version table found. Catalog: rxc_qb, Schema: null, Name: QB_SETTING, Type: TABLE
jvm 1 | 2012-06-04 16:32:17,557 ERROR - Error starting QuickBuild.
jvm 1 | com.pmease.quickbuild.QuickbuildException: No data version found in database.
jvm 1 | at com.pmease.quickbuild.util.DbUtils.getDataVersion(DbUtils.java:148)
jvm 1 | at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:283)
jvm 1 | at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:226)
jvm 1 | at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:161)
jvm 1 | at java.lang.Thread.run(Thread.java:811)
jvm 1 | 2012-06-04 16:32:17,558 INFO - Stopping QuickBuild server...
jvm 1 | 2012-06-04 16:32:18,256 INFO - Stopping task scheduler...
jvm 1 | 2012-06-04 16:32:18,258 INFO - QuickBuild server stopped.
jvm 1 | 2012-06-04 16:32:19,268 INFO - Stopping QuickBuild server...
jvm 1 | 2012-06-04 16:32:19,269 INFO - Stopping task scheduler...
jvm 1 | 2012-06-04 16:32:19,269 INFO - QuickBuild server stopped.
wrapper | <-- Wrapper Stopped
:/usr/local/apps/qb4.0/quickbuild-4.0.30/bin>./server.sh status
QuickBuild Server is not running.
robinshen ADMIN ·
The database is populated incorrectly (due to previous errors). Please recreate the database (drop the schema and create a blank one) and QB should be able to be started.
ssrivastava ·
I did exactly what you mentioned.. and now after re-creating the schema with the new user "dsladmin".. I am getting the following error:

Access denied for user 'dsladmin'@'localhost' (using password: YES)

Do I have to do anything with the user setup?

jvm 1 | java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'dsladmin'@'localhost' (using password: YES)
jvm 1 | at com.pmease.quickbuild.bootstrap.BootstrapUtils.wrapAsUnchecked(BootstrapUtils.java:58)
jvm 1 | at com.pmease.quickbuild.util.ExceptionUtils.wrapAsUnchecked(ExceptionUtils.java:82)
jvm 1 | at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:101)
jvm 1 | at com.pmease.quickbuild.util.DbUtils.getDataVersion(DbUtils.java:129)
jvm 1 | at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:283)
jvm 1 | at com.pmease.quickbuild.Quickbuild.access$3(Quickbuild.java:226)
jvm 1 | at com.pmease.quickbuild.Quickbuild$2.run(Quickbuild.java:161)
jvm 1 | at java.lang.Thread.run(Thread.java:811)
jvm 1 | Caused by: java.sql.SQLException: Access denied for user 'dsladmin'@'localhost' (using password: YES)
jvm 1 | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
jvm 1 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
jvm 1 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
jvm 1 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951)
jvm 1 | at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4600)
jvm 1 | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1328)
jvm 1 | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395)
jvm 1 | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428)
jvm 1 | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213)
jvm 1 | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)
jvm 1 | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
jvm 1 | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
jvm 1 | at java.sql.DriverManager.getConnection(DriverManager.java:572)
jvm 1 | at java.sql.DriverManager.getConnection(DriverManager.java:196)
jvm 1 | at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:96)
jvm 1 | ... 5 more
jvm 1 | 2012-06-04 21:42:19,039 INFO - Stopping QuickBuild server...
jvm 1 | 2012-06-04 21:42:19,710 INFO - Stopping task scheduler...
jvm 1 | 2012-06-04 21:42:19,712 INFO - QuickBuild server stopped.
jvm 1 | 2012-06-04 21:42:20,724 INFO - Stopping QuickBuild server...
jvm 1 | 2012-06-04 21:42:20,725 INFO - Stopping task scheduler...
jvm 1 | 2012-06-04 21:42:20,725 INFO - QuickBuild server stopped.
robinshen ADMIN ·
The user you've specified in hibernate.properties does not have the permission to access your database. You may verify this by connecting to MySQL database with the same user at the QB machine using some external tool such as MySQL query analyzer.
ssrivastava ·
Thanks for your help Robin.
Turns out that mysql installation had some issues and I had to run mysql_install_db to re-create the system tables.


More importantly , I'm all set now - thanks again.