<< Back to previous view |
[QB-3001] Upgrade from 4.0.65 to 7.0.17 version fails
|
|
Status: | Closed |
Project: | QuickBuild |
Component/s: | None |
Affects Version/s: | 7.0.17 |
Fix Version/s: | None |
Type: | Bug | Priority: | Blocker |
Reporter: | Artur Shnayder | Assigned To: | Robin Shen |
Resolution: | Fixed | Votes: | 0 |
Remaining Estimate: | Unknown | Time Spent: | Unknown |
Original Estimate: | Unknown |
Description |
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, |
Comments |
Comment by 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. |
Comment by 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, |
Comment by 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 |
Comment by 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, |
Comment by Robin Shen [ 01/Jul/17 12:16 AM ] |
Thanks for the info. It will be of great help to other users using Oracle |