History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-3001
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Robin Shen
Reporter: Artur Shnayder
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

Upgrade from 4.0.65 to 7.0.17 version fails

Created: 27/Jun/17 06:44 PM   Updated: 01/Jul/17 12:16 AM
Component/s: None
Affects Version/s: 7.0.17
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown


 Description  « Hide
Relevant error messages are below:

{code}
[quickbuild@st-qb-nprd03 bin]$ ./upgrade.sh /opt/quickbuild/quickbuild-4.0.65
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)
===========================================================
2017-06-27 14:18:35,446 INFO - Upgrading /opt/quickbuild/quickbuild-4.0.65...
2017-06-27 14:18:35,849 INFO - >>> 2017-06-27 14:18:35,784 INFO - Cleaning cached plugin libraries...
2017-06-27 14:18:35,854 INFO - >>> 2017-06-27 14:18:35,854 INFO - Cleaning temp directory...
2017-06-27 14:18:35,870 INFO - >>> 2017-06-27 14:18:35,870 INFO - Booting QuickBuild from '/opt/quickbuild/quickbuild-4.0.65'...
2017-06-27 14:18:35,871 INFO - >>> 2017-06-27 14:18:35,871 INFO - Starting framework...
2017-06-27 14:18:35,911 INFO - >>> 2017-06-27 14:18:35,911 INFO - Caching plugin libraries...
2017-06-27 14:18:37,566 INFO - >>> 2017-06-27 14:18:37,554 INFO - Starting QuickBuild server...
2017-06-27 14:19:13,058 INFO - >>> 2017-06-27 14:19:13,057 INFO - QuickBuild version table found. Catalog: null, Schema: QB_NPRD, Name: QB_SETTING, Type: TABLE
2017-06-27 14:19:13,068 INFO - >>> 2017-06-27 14:19:13,068 INFO - Stopping plugin manager...
2017-06-27 14:19:13,213 INFO - >>> 2017-06-27 14:19:13,213 INFO - Stopping QuickBuild server...
2017-06-27 14:19:13,214 INFO - >>> 2017-06-27 14:19:13,213 INFO - Stopping plugins...
2017-06-27 14:19:13,214 INFO - >>> 2017-06-27 14:19:13,214 INFO - Stopping task scheduler...
2017-06-27 14:19:13,218 INFO - >>> 2017-06-27 14:19:13,217 INFO - QuickBuild server stopped.
2017-06-27 14:19:13,218 INFO - Db version: 53
2017-06-27 14:19:13,543 INFO - >>> 2017-06-27 14:19:13,478 INFO - Cleaning cached plugin libraries...
2017-06-27 14:19:13,548 INFO - >>> 2017-06-27 14:19:13,548 INFO - Cleaning temp directory...
2017-06-27 14:19:13,565 INFO - >>> 2017-06-27 14:19:13,565 INFO - Booting QuickBuild from '/opt/quickbuild/quickbuild-7.0.10'...
2017-06-27 14:19:13,566 INFO - >>> 2017-06-27 14:19:13,566 INFO - Starting framework...
2017-06-27 14:19:13,621 INFO - >>> 2017-06-27 14:19:13,620 INFO - Caching plugin libraries...
2017-06-27 14:19:16,813 INFO - >>> 2017-06-27 14:19:16,813 INFO - Starting QuickBuild server...
2017-06-27 14:19:17,810 INFO - >>> 2017-06-27 14:19:17,810 INFO - Stopping QuickBuild server...
2017-06-27 14:19:18,201 INFO - >>> 2017-06-27 14:19:18,200 INFO - Stopping plugins...
2017-06-27 14:19:18,206 INFO - >>> 2017-06-27 14:19:18,206 INFO - Stopping task scheduler...
2017-06-27 14:19:18,257 INFO - >>> 2017-06-27 14:19:18,257 INFO - QuickBuild server stopped.
2017-06-27 14:19:18,258 INFO - App version: 94
2017-06-27 14:19:18,594 INFO - Backing up database as /opt/quickbuild/quickbuild-4.0.65/dbbackup~2017-06-27_14-19-18.zip...
2017-06-27 14:19:18,901 INFO - >>> 2017-06-27 14:19:18,841 INFO - Cleaning cached plugin libraries...
2017-06-27 14:19:18,934 INFO - >>> 2017-06-27 14:19:18,934 INFO - Cleaning temp directory...
2017-06-27 14:19:18,950 INFO - >>> 2017-06-27 14:19:18,950 INFO - Booting QuickBuild from '/opt/quickbuild/quickbuild-4.0.65'...
2017-06-27 14:19:18,951 INFO - >>> 2017-06-27 14:19:18,951 INFO - Starting framework...
2017-06-27 14:19:18,989 INFO - >>> 2017-06-27 14:19:18,989 INFO - Caching plugin libraries...
2017-06-27 14:19:20,640 INFO - >>> 2017-06-27 14:19:20,639 INFO - Starting QuickBuild server...
2017-06-27 14:21:07,941 INFO - >>> 2017-06-27 14:21:07,940 INFO - Stopping plugin manager...
2017-06-27 14:21:07,941 INFO - >>> 2017-06-27 14:21:07,940 INFO - Stopping QuickBuild server...
2017-06-27 14:21:07,941 INFO - >>> 2017-06-27 14:21:07,941 INFO - Stopping plugins...
2017-06-27 14:21:07,942 INFO - >>> 2017-06-27 14:21:07,941 INFO - Stopping task scheduler...
2017-06-27 14:21:08,043 INFO - >>> 2017-06-27 14:21:08,043 INFO - QuickBuild server stopped.
2017-06-27 14:21:08,044 ERROR - >>> Exception in thread "main" java.lang.ExceptionInInitializerError
2017-06-27 14:21:08,045 ERROR - >>> at com.pmease.quickbuild.Quickbuild.exportData(Quickbuild.java:799)
2017-06-27 14:21:08,045 ERROR - >>> at com.pmease.quickbuild.bootstrap.Bootstrap$3.execute(Bootstrap.java:170)
2017-06-27 14:21:08,045 ERROR - >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:552)
2017-06-27 14:21:08,046 ERROR - >>> at java.lang.Thread.run(Thread.java:745)
2017-06-27 14:21:08,053 ERROR - >>> Caused by: com.google.inject.ProvisionException: Guice provision errors:
2017-06-27 14:21:08,054 ERROR - >>>
2017-06-27 14:21:08,054 ERROR - >>> 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
2017-06-27 14:21:08,054 ERROR - >>> while locating com.pmease.quickbuild.persistence.SessionFactoryProvider
2017-06-27 14:21:08,054 ERROR - >>> at com.pmease.quickbuild.QuickbuildModule.configure(QuickbuildModule.java:29)
2017-06-27 14:21:08,055 ERROR - >>> while locating org.hibernate.SessionFactory
2017-06-27 14:21:08,055 ERROR - >>> for field at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.sessionFactory(DefaultDataManager.java:96)
2017-06-27 14:21:08,055 ERROR - >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.class(DefaultDataManager.java:96)
2017-06-27 14:21:08,055 ERROR - >>> while locating com.pmease.quickbuild.entitymanager.impl.DefaultDataManager
2017-06-27 14:21:08,056 ERROR - >>> while locating com.pmease.quickbuild.entitymanager.DataManager
2017-06-27 14:21:08,056 ERROR - >>>
2017-06-27 14:21:08,056 ERROR - >>> 1 error
2017-06-27 14:21:08,056 ERROR - >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
2017-06-27 14:21:08,057 ERROR - >>> at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
2017-06-27 14:21:08,057 ERROR - >>> at com.pmease.quickbuild.Quickbuild.getInstance(Quickbuild.java:713)
2017-06-27 14:21:08,057 ERROR - >>> at com.pmease.quickbuild.entitymanager.DataManager.<clinit>(DataManager.java:59)
2017-06-27 14:21:08,058 ERROR - >>> ... 4 more
2017-06-27 14:21:08,058 ERROR - >>> Caused by: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: Connection reset
2017-06-27 14:21:08,059 ERROR - >>> at com.pmease.quickbuild.bootstrap.BootstrapUtils.wrapAsUnchecked(BootstrapUtils.java:56)
2017-06-27 14:21:08,059 ERROR - >>> at com.pmease.quickbuild.util.ExceptionUtils.wrapAsUnchecked(ExceptionUtils.java:82)
2017-06-27 14:21:08,059 ERROR - >>> at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:101)
2017-06-27 14:21:08,059 ERROR - >>> at com.pmease.quickbuild.util.DbUtils.getDataVersion(DbUtils.java:129)
2017-06-27 14:21:08,060 ERROR - >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:64)
2017-06-27 14:21:08,060 ERROR - >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:35)
2017-06-27 14:21:08,061 ERROR - >>> at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
2017-06-27 14:21:08,061 ERROR - >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
2017-06-27 14:21:08,061 ERROR - >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
2017-06-27 14:21:08,061 ERROR - >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
2017-06-27 14:21:08,062 ERROR - >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
2017-06-27 14:21:08,062 ERROR - >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
2017-06-27 14:21:08,062 ERROR - >>> at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53)
2017-06-27 14:21:08,062 ERROR - >>> at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
2017-06-27 14:21:08,062 ERROR - >>> at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
2017-06-27 14:21:08,063 ERROR - >>> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
2017-06-27 14:21:08,063 ERROR - >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
2017-06-27 14:21:08,063 ERROR - >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
2017-06-27 14:21:08,063 ERROR - >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
2017-06-27 14:21:08,063 ERROR - >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
2017-06-27 14:21:08,064 ERROR - >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
2017-06-27 14:21:08,064 ERROR - >>> at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:737)
2017-06-27 14:21:08,064 ERROR - >>> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
2017-06-27 14:21:08,064 ERROR - >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
2017-06-27 14:21:08,064 ERROR - >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
2017-06-27 14:21:08,065 ERROR - >>> ... 7 more
2017-06-27 14:21:08,065 ERROR - >>> Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset
2017-06-27 14:21:08,065 ERROR - >>> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:428)
2017-06-27 14:21:08,065 ERROR - >>> at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
2017-06-27 14:21:08,065 ERROR - >>> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
2017-06-27 14:21:08,065 ERROR - >>> at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
2017-06-27 14:21:08,066 ERROR - >>> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
2017-06-27 14:21:08,066 ERROR - >>> at java.sql.DriverManager.getConnection(DriverManager.java:571)
2017-06-27 14:21:08,066 ERROR - >>> at java.sql.DriverManager.getConnection(DriverManager.java:215)
2017-06-27 14:21:08,066 ERROR - >>> at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:96)
2017-06-27 14:21:08,066 ERROR - >>> ... 29 more
2017-06-27 14:21:08,067 ERROR - >>> Caused by: java.net.SocketException: Connection reset
2017-06-27 14:21:08,067 ERROR - >>> at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118)
2017-06-27 14:21:08,067 ERROR - >>> at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
2017-06-27 14:21:08,067 ERROR - >>> at oracle.net.ns.DataPacket.send(DataPacket.java:199)
2017-06-27 14:21:08,067 ERROR - >>> at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
2017-06-27 14:21:08,068 ERROR - >>> at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
2017-06-27 14:21:08,068 ERROR - >>> at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
2017-06-27 14:21:08,068 ERROR - >>> at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
2017-06-27 14:21:08,068 ERROR - >>> at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
2017-06-27 14:21:08,068 ERROR - >>> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
2017-06-27 14:21:08,069 ERROR - >>> at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
2017-06-27 14:21:08,069 ERROR - >>> at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
2017-06-27 14:21:08,069 ERROR - >>> at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
2017-06-27 14:21:08,069 ERROR - >>> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
2017-06-27 14:21:08,069 ERROR - >>> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
2017-06-27 14:21:08,070 ERROR - >>> at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
2017-06-27 14:21:08,070 ERROR - >>> at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
2017-06-27 14:21:08,070 ERROR - >>> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
2017-06-27 14:21:08,070 ERROR - >>> ... 36 more
2017-06-27 14:21:08,274 ERROR - Unable to upgrade specified installation due to above error
{code}

Please advise ASAP.

Thank you,

 All   Comments   Work Log   Change History      Sort Order:
Robin Shen [28/Jun/17 12:59 AM]
Looks like that there are some issues connecting to your Oracle database according to the "connection reset" error.

Artur Shnayder [28/Jun/17 01:47 AM]
The old QB can can connect to the same DB with no problem. Both use the same oracle driver. This seems to be a bug in Guice libraries or Hibernate configuration.
What would be the next step to troubleshoot?

Thanks,

Robin Shen [29/Jun/17 12:56 AM]
Please perform below steps to see if it helps:
1. Backup QB4 database to a zip file via QB administration interface
2. Set up a new QB7 instance and connect to a new Oracle database
3. Restore the backup to the new QB7 instance

Artur Shnayder [30/Jun/17 01:09 AM]
Hi Robin,

This worked . I have migrated DB to MySQL at the same opportunity and installed 7.0.18 version.
It used to complain on duplicated users (low and upper cases), so I had to delete extra users.

We're good now.. BTW, in regards to oracle, I think we faced this bug: http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty/ . When I updated update.sh script, it has progressed much father, but after your response, I decided to switch to MySQL.

 
Thank you very much,

Robin Shen [01/Jul/17 12:16 AM]
Thanks for the info. It will be of great help to other users using Oracle