Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Done
Priority: Critical
Fix Version/s: None
Affects Version/s: None
Component/s: None
Labels:
- support

Blocked:
False
Blocked Reason:
None
Ready:
False
Affects:

Migration
Docs QE Status:
NEW
QE Status:
NEW
Workaround Description:
Hide

Workatound is to set lower_case_tables_names=1 at DB side as described in the KCS
https://access.redhat.com/solutions/6955355

But this can't be applyed for all of environment, especially on Prouction as described in this document.

https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html#:~:text=lower_case_table_names%20can%20only%20be%20configured,server%20is%20initialized%20is%20prohibited.&text=Table%20and%20database%20names%20are%20stored%20on%20disk%20using%20the,TABLE%20or%20CREATE%20DATABASE%20statement.

lower_case_table_names can only be configured when initializing the server. Changing the lower_case_table_names setting after the server is initialized is prohibited.
Show
Workatound is to set lower_case_tables_names=1 at DB side as described in the KCS https://access.redhat.com/solutions/6955355 But this can't be applyed for all of environment, especially on Prouction as described in this document. https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html#:~:text=lower_case_table_names%20can%20only%20be%20configured,server%20is%20initialized%20is%20prohibited.&text=Table%20and%20database%20names%20are%20stored%20on%20disk%20using%20the,TABLE%20or%20CREATE%20DATABASE%20statement . lower_case_table_names can only be configured when initializing the server. Changing the lower_case_table_names setting after the server is initialized is prohibited.
Git Pull Request:
https://github.com/kiegroup/jbpm-wb/pull/1575, https://github.com/kiegroup/jbpm-wb/pull/1576, https://github.com/kiegroup/jbpm-wb/pull/1577
[QE] How to address?:
---
[QE] Why QE missed?:
---

SFDC Cases Counter:
SFDC Cases Links:

Description

When using MySQL DB or Maria DB, after upgrading to 7.12.0 or later the following ERROR happens in kie-server log:

04:48:20,036 ERROR [org.kie.server.services.jbpm.JbpmKieServerExtension] (ServerService Thread Pool -- 84) Error when loading default query definitions from defau
lt-query-definitions.json: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithAdminExtended
at deployment.ROOT.war//org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:189)
at deployment.ROOT.war//org.jbpm.kie.services.impl.query.QueryServiceImpl.replaceQuery(QueryServiceImpl.java:205)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.lambda$loadAndRegisterQueryDefinitions$4(JbpmKieServerExtension.java:842)
at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4390)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.loadAndRegisterQueryDefinitions(JbpmKieServerExtension.java:840)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.registerDefaultQueryDefinitions(JbpmKieServerExtension.java:858)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:214)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:184)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:142)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerLocator$KieServerLocatorHelper.<clinit>(KieServerLocator.java:25)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerLocator.getInstance(KieServerLocator.java:32)
at deployment.ROOT.war//org.kie.server.remote.rest.common.Bootstrap.contextInitialized(Bootstrap.java:51)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:219)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:187)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.j
ava:42)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
$create$0(UndertowDeploymentInfoService.java:1551)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
$create$0(UndertowDeploymentInfoService.java:1551)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
$create$0(UndertowDeploymentInfoService.java:1551)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
$create$0(UndertowDeploymentInfoService.java:1551)
at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:255)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentServi
ce.java:96)
at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java
:78)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
at java.base/java.lang.Thread.run(Thread.java:829)
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513)
Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: (conn=1234293) Table 'rhpam.taskEvent' doesn't exist
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.model.Select.fetch(Select.java:197)
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getColumns(SQLDataSetProvider.java:415)
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getDataSetMetadata(SQLDataSetProvider.java:327)
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider.getDataSetMetadata(SQLDataSetProvider.java:260)
at deployment.ROOT.war//org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:187)
... 31 more
Caused by: java.sql.SQLSyntaxErrorException: (conn=1234293) Table 'rhpam.taskEvent' doesn't exist
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:177)
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228)
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:334)
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:505)
at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final-redhat-00001//org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.JDBCUtils.executeQuery(JDBCUtils.java:123)
at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.model.Select.fetch(Select.java:190)
... 35 more
Caused by: java.sql.SQLException: Table 'rhpam.taskEvent' doesn't exist
Query is: SELECT * FROM (select t.activationTime, t.actualOwner, t.createdBy, t.createdOn, t.deploymentId, t.description, t.dueDate, t.name, t.parentId, t.priority, t.pr
ocessId, t.processInstanceId, t.processSessionId, t.status, t.taskId, t.workItemId, t.lastModificationDate, pil.correlationKey, pil.processInstanceDescription ,oe.id, ni
l.sla_due_date, nil.slaCompliance,(select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.ACTIVITY_ID = t.taskId and errInfo.PROCESS_INST_ID = pil.proces
sInstanceId and errInfo.ERROR_ACK = 0 and errInfo.ERROR_TYPE = 'Task') as errorCount, i18n.text  as subject, i18n.language as language, task.formname as formname, (SELEC
T te1.userId FROM taskEvent te1 LEFT JOIN taskEvent te2 ON te1.id < te2.id WHERE te2.id IS NULL) as lastUser from AuditTaskImpl t  left join ProcessInstanceLog pil on pi
l.processInstanceId = t.processInstanceId left join PeopleAssignments_BAs ba on t.taskId = ba.task_id left join OrganizationalEntity oe on ba.entity_id = oe.id left join
 NodeInstanceLog ...
at org.mariadb//org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:119)
at org.mariadb//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:200)
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:328)
... 39 more

Attachments

Issue Links

clones

RHPAM-4578 ERROR "Table 'rhpam.taskEvent' doesn't exist" happens after upgrading to 7.12.0 or later

Closed

Activity

People

Assignee:: Enrique Gonzalez Martinez (Inactive)

Reporter:: Hiroko Miura

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022/11/15 8:33 AM

Updated:: 2022/11/24 1:39 AM

Resolved:: 2022/11/24 1:39 AM