API tools faq
paste
Advertisement
Guest User

Keycloak MySQL log when default UTF-8

a guest
Aug 3rd, 2016
839
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.44 KB | None | 0 0
raw download clone embed print report
  1. =========================================================================
  2. 2016-08-03T11:40:01.971686936Z
  3. JBoss Bootstrap Environment
  4. JBOSS_HOME: /opt/jboss/keycloak
  5. JAVA: /usr/lib/jvm/java/bin/java
  6. JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MetaspaceSize=96M -XX:MaxMetaspaceSize=256m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
  7. =========================================================================
  8. 11:40:02,900 INFO [org.jboss.modules] (main) JBoss Modules version 1.5.1.Final
  9. 11:40:03,480 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final
  10. 11:40:03,628 INFO [org.jboss.as] (MSC service thread 1-2) WFLYSRV0049: Keycloak 1.9.2.Final (WildFly Core 2.0.10.Final) starting
  11. 11:40:07,388 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
  12. 11:40:07,469 INFO [org.xnio] (MSC service thread 1-1) XNIO version 3.3.4.Final
  13. 11:40:07,536 INFO [org.xnio.nio] (MSC service thread 1-1) XNIO NIO Implementation Version 3.3.4.Final
  14. 11:40:07,682 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) WFLYCLINF0001: Activating Infinispan subsystem.
  15. 11:40:07,748 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) WFLYNAM0001: Activating Naming Subsystem
  16. 11:40:07,768 INFO [org.jboss.as.security] (ServerService Thread Pool -- 42) WFLYSEC0002: Activating Security Subsystem
  17. 11:40:07,769 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 43) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique.
  18. 11:40:07,732 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 36) WFLYJSF0007: Activated the following JSF Implementations: [main]
  19. 11:40:07,956 INFO [org.wildfly.extension.io] (ServerService Thread Pool -- 29) WFLYIO001: Worker 'default' has auto-configured to 2 core threads with 16 task threads based on your 1 available processors
  20. 11:40:08,019 INFO [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 4.0.18.Final
  21. 11:40:08,120 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
  22. 11:40:08,267 INFO [org.jboss.as.naming] (MSC service thread 1-2) WFLYNAM0003: Starting Naming Service
  23. 11:40:08,328 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 44) WFLYUT0003: Undertow 1.3.15.Final starting
  24. 11:40:08,374 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0003: Undertow 1.3.15.Final starting
  25. 11:40:08,429 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
  26. 11:40:08,399 INFO [org.jboss.as.security] (MSC service thread 1-2) WFLYSEC0001: Current PicketBox version=4.9.4.Final
  27. 11:40:08,584 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]
  28. 11:40:08,714 INFO [org.jboss.as.connector] (MSC service thread 1-2) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.2.Final)
  29. 11:40:08,928 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0018: Started Driver service with driver-name = h2
  30. 11:40:08,937 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0018: Started Driver service with driver-name = mysql
  31. 11:40:09,091 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 44) WFLYUT0014: Creating file handler for path '/opt/jboss/keycloak/welcome-content' with options [directory-listing: 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-paths: '[]']
  32. 11:40:09,589 INFO [org.jboss.as.ejb3] (MSC service thread 1-1) WFLYEJB0481: Strict pool slsb-strict-max-pool is using a max instance size of 16 (per class), which is derived from thread worker pool sizing.
  33. 11:40:09,598 INFO [org.jboss.as.ejb3] (MSC service thread 1-1) WFLYEJB0482: Strict pool mdb-strict-max-pool is using a max instance size of 4 (per class), which is derived from the number of CPUs on this host.
  34. 11:40:09,763 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0012: Started server default-server.
  35. 11:40:09,912 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0018: Host default-host starting
  36. 11:40:10,090 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0006: Undertow HTTP listener default listening on 0.0.0.0:8080
  37. 11:40:10,406 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS]
  38. 11:40:10,409 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:jboss/datasources/KeycloakDS]
  39. 11:40:11,115 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-1) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final
  40. 11:40:11,292 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) WFLYSRV0027: Starting deployment of "keycloak-server.war" (runtime-name: "keycloak-server.war")
  41. 11:40:12,735 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 49) WFLYCLINF0002: Started loginFailures cache from keycloak container
  42. 11:40:12,736 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) WFLYCLINF0002: Started users cache from keycloak container
  43. 11:40:12,737 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 48) WFLYCLINF0002: Started offlineSessions cache from keycloak container
  44. 11:40:12,737 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 51) WFLYCLINF0002: Started work cache from keycloak container
  45. 11:40:12,738 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 46) WFLYCLINF0002: Started realms cache from keycloak container
  46. 11:40:12,740 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 47) WFLYCLINF0002: Started sessions cache from keycloak container
  47. 11:40:13,112 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 50) WFLYCLINF0002: Started realmVersions cache from keycloak container
  48. 11:40:15,302 INFO [org.keycloak.services] (ServerService Thread Pool -- 50) KC-SERVICES0001: Loading config from /opt/jboss/keycloak/standalone/configuration/keycloak-server.json
  49. 11:40:23,254 INFO [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 50) Updating database
  50. 11:40:23,594 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 50) Change Set META-INF/jpa-changelog-1.9.1.xml::1.9.1::keycloak failed. Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  51. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  52. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  53. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  54. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  55. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  56. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  57. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  58. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  59. at liquibase.Liquibase.update(Liquibase.java:210)
  60. at liquibase.Liquibase.update(Liquibase.java:190)
  61. at liquibase.Liquibase.update(Liquibase.java:186)
  62. at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
  63. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:179)
  64. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:66)
  65. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:54)
  66. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  67. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:51)
  68. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:33)
  69. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  70. at org.keycloak.models.cache.infinispan.RealmCacheSession.getDelegate(RealmCacheSession.java:161)
  71. at org.keycloak.models.cache.infinispan.RealmCacheSession.getMigrationModel(RealmCacheSession.java:154)
  72. at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:40)
  73. at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:165)
  74. at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:101)
  75. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  76. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  77. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  78. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  79. at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
  80. at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
  81. at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
  82. at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
  83. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
  84. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
  85. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
  86. at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
  87. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
  88. at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
  89. at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
  90. at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
  91. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
  92. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
  93. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  94. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  95. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  96. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  97. at java.lang.Thread.run(Thread.java:745)
  98. at org.jboss.threads.JBossThread.run(JBossThread.java:320)
  99. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
  100. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  101. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  102. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  103. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  104. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  105. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  106. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  107. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
  108. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  109. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
  110. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
  111. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
  112. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
  113. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
  114. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
  115. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
  116. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  117. ... 47 more
  118. 11:40:23,614 ERROR [org.keycloak.services] (ServerService Thread Pool -- 50) KC-SERVICES0002: Failed to migrate datamodel: java.lang.RuntimeException: Failed to update database
  119. at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:90)
  120. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:179)
  121. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:66)
  122. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:54)
  123. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  124. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:51)
  125. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:33)
  126. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  127. at org.keycloak.models.cache.infinispan.RealmCacheSession.getDelegate(RealmCacheSession.java:161)
  128. at org.keycloak.models.cache.infinispan.RealmCacheSession.getMigrationModel(RealmCacheSession.java:154)
  129. at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:40)
  130. at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:165)
  131. at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:101)
  132. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  133. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  134. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  135. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  136. at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
  137. at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
  138. at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
  139. at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
  140. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
  141. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
  142. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
  143. at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
  144. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
  145. at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
  146. at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
  147. at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
  148. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
  149. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
  150. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  151. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  152. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  153. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  154. at java.lang.Thread.run(Thread.java:745)
  155. at org.jboss.threads.JBossThread.run(JBossThread.java:320)
  156. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.9.1.xml::1.9.1::keycloak:
  157. Reason: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  158. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
  159. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  160. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  161. at liquibase.Liquibase.update(Liquibase.java:210)
  162. at liquibase.Liquibase.update(Liquibase.java:190)
  163. at liquibase.Liquibase.update(Liquibase.java:186)
  164. at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
  165. ... 36 more
  166. Caused by: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  167. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  168. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  169. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  170. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  171. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  172. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  173. ... 42 more
  174. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
  175. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  176. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  177. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  178. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  179. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  180. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  181. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  182. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
  183. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  184. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
  185. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
  186. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
  187. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
  188. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
  189. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
  190. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
  191. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  192. ... 47 more
  193. 11:40:23,650 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 50) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
  194. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85)
  195. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  196. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  197. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  198. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  199. at java.lang.Thread.run(Thread.java:745)
  200. at org.jboss.threads.JBossThread.run(JBossThread.java:320)
  201. Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
  202. at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:162)
  203. at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
  204. at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
  205. at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
  206. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
  207. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
  208. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
  209. at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
  210. at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
  211. at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
  212. at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
  213. at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
  214. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
  215. at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
  216. ... 6 more
  217. Caused by: java.lang.RuntimeException: Failed to update database
  218. at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:90)
  219. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:179)
  220. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:66)
  221. at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:54)
  222. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  223. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:51)
  224. at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:33)
  225. at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:101)
  226. at org.keycloak.models.cache.infinispan.RealmCacheSession.getDelegate(RealmCacheSession.java:161)
  227. at org.keycloak.models.cache.infinispan.RealmCacheSession.getMigrationModel(RealmCacheSession.java:154)
  228. at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:40)
  229. at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:165)
  230. at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:101)
  231. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  232. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  233. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  234. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  235. at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
  236. ... 19 more
  237. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.9.1.xml::1.9.1::keycloak:
  238. Reason: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  239. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
  240. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  241. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  242. at liquibase.Liquibase.update(Liquibase.java:210)
  243. at liquibase.Liquibase.update(Liquibase.java:190)
  244. at liquibase.Liquibase.update(Liquibase.java:186)
  245. at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
  246. ... 36 more
  247. Caused by: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  248. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  249. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  250. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  251. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  252. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  253. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  254. ... 42 more
  255. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
  256. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  257. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  258. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  259. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  260. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  261. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  262. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  263. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
  264. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
  265. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
  266. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
  267. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
  268. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
  269. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
  270. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
  271. at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
  272. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  273. ... 47 more
  274. 11:40:23,687 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "keycloak-server.war")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.undertow.deployment.default-server.default-host./auth" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
  275. Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
  276. Caused by: java.lang.RuntimeException: Failed to update database
  277. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.9.1.xml::1.9.1::keycloak:
  278. Reason: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  279. Caused by: liquibase.exception.DatabaseException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs [Failed SQL: ALTER TABLE keycloak.REALM MODIFY CERTIFICATE VARCHAR(4000)]
  280. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"}}
  281. 11:40:23,823 INFO [org.jboss.as.server] (ServerService Thread Pool -- 45) WFLYSRV0010: Deployed "keycloak-server.war" (runtime-name : "keycloak-server.war")
  282. 11:40:23,828 INFO [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
  283. WFLYCTL0186: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
  284. 11:40:24,195 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
  285. 11:40:24,196 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://127.0.0.1:9990
  286. 11:40:24,203 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: Keycloak 1.9.2.Final (WildFly Core 2.0.10.Final) started (with errors) in 22068ms - Started 414 of 783 services (2 services failed or missing dependencies, 526 services are lazy, passive or on-demand)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!