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

Key: QB-4067
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Unassigned
Reporter: Alexey Kuznetsov
Votes: 0
Watchers: 0
Operations

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

java.sql.SQLSyntaxErrorException when update from 13.0.37

Created: 12/Jan/24 08:34 AM   Updated: 17/Jan/24 12:10 PM
Component/s: None
Affects Version/s: 14.0.2
Fix Version/s: 14.0.4

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
File Attachments: 1. XML File log4j2.xml (1 kb)



 Description  « Hide
I got the following error at the end of QB update from version 13.0.37 to 14.0.2.
NOTE: There was no such issue on update to version 14.0.1.

INFO Copying new program files into /etc/quickbuild-8.0.20...
INFO Migrating exported data...
INFO >>> 2024-01-11 13:19:44,380 INFO Cleaning cached plugin libraries...
INFO >>> 2024-01-11 13:19:44,434 INFO Cleaning temp directory...
INFO >>> 2024-01-11 13:19:44,439 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-11 13:19:44,439 INFO Starting framework...
INFO >>> 2024-01-11 13:19:44,489 INFO Caching plugin libraries...
INFO >>> 2024-01-11 13:19:47,453 INFO Starting QuickBuild server...
INFO >>> 2024-01-11 13:20:07,828 INFO Stopping QuickBuild server...
INFO >>> 2024-01-11 13:20:08,271 INFO Stopping plugins...
INFO >>> 2024-01-11 13:20:08,274 INFO Stopping task scheduler...
INFO >>> 2024-01-11 13:20:08,409 INFO QuickBuild server stopped.
INFO >>> 2024-01-11 13:20:09,523 INFO Cleaning cached plugin libraries...
INFO >>> 2024-01-11 13:20:09,560 INFO Cleaning temp directory...
INFO >>> 2024-01-11 13:20:09,565 INFO Booting QuickBuild from '/etc/quickbuild-8.0.20'...
INFO >>> 2024-01-11 13:20:09,565 INFO Starting framework...
INFO >>> 2024-01-11 13:20:09,616 INFO Caching plugin libraries...
INFO >>> 2024-01-11 13:20:11,815 INFO Starting QuickBuild server...
INFO >>> 2024-01-11 13:20:19,590 INFO Stopping QuickBuild server...
INFO >>> 2024-01-11 13:20:19,604 INFO Stopping plugins...
INFO >>> 2024-01-11 13:20:19,607 INFO Stopping task scheduler...
INFO >>> 2024-01-11 13:20:19,624 INFO QuickBuild server stopped.
ERROR >>> Exception in thread "main" java.lang.ExceptionInInitializerError
ERROR >>> at com.pmease.quickbuild.Quickbuild.importData(Quickbuild.java:1166)
ERROR >>> at com.pmease.quickbuild.bootstrap.Bootstrap$6.execute(Bootstrap.java:201)
ERROR >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:872)
ERROR >>> at java.base/java.lang.Thread.run(Thread.java:829)
ERROR >>> Caused by: com.google.inject.ProvisionException: Guice provision errors:
ERROR >>>
ERROR >>> 1) Error in custom provider, java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> while locating com.pmease.quickbuild.persistence.SessionFactoryProvider
ERROR >>> at com.pmease.quickbuild.QuickbuildModule.configure(QuickbuildModule.java:36)
ERROR >>> while locating org.hibernate.SessionFactory
ERROR >>> for field at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.sessionFactory(DefaultDataManager.java:137)
ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.class(DefaultDataManager.java:137)
ERROR >>> while locating com.pmease.quickbuild.entitymanager.impl.DefaultDataManager
ERROR >>> while locating com.pmease.quickbuild.entitymanager.DataManager
ERROR >>>
ERROR >>> 1 error
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
ERROR >>> at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
ERROR >>> at com.pmease.quickbuild.Quickbuild.getInstance(Quickbuild.java:1061)
ERROR >>> at com.pmease.quickbuild.entitymanager.DataManager.<clinit>(DataManager.java:67)
ERROR >>> ... 4 more
ERROR >>> Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:122)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:99)
ERROR >>> at com.pmease.quickbuild.persistence.SessionFactoryProvider.get(SessionFactoryProvider.java:36)
ERROR >>> at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:55)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53)
ERROR >>> at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
ERROR >>> at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
ERROR >>> at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
ERROR >>> at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
ERROR >>> at com.google.inject.Scopes$1$1.get(Scopes.java:65)
ERROR >>> at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
ERROR >>> at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:737)
ERROR >>> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
ERROR >>> at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
ERROR >>> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
ERROR >>> ... 7 more
ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
ERROR >>> at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
ERROR >>> at com.pmease.quickbuild.util.DbUtils.execute(DbUtils.java:119)
ERROR >>> ... 28 more
ERROR Failed to upgrade /etc/quickbuild-8.0.20
INFO Now restoring old installation directory due to upgrade failure...
INFO Old installation directory is now restored.
WARN The database might be in an inconsistent state due to upgrade failure. In that case, you need to restore the database by first cleaning it, and then running below command:
INFO /etc/quickbuild-8.0.20/bin/restore.sh /etc/quickbuild-8.0.20/dbbackup~2024-01-11_13-00-44.zip

 All   Comments   Work Log   Change History      Sort Order:
No work has yet been logged on this issue.