[jira] [Commented] (FINERACT-1276) Unknown table 'TABLE_NAMES' in information_schema

["Michael Vorburger (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17248378#comment-17248378 ] 

Michael Vorburger commented on FINERACT-1276:
---------------------------------------------

[~francisguchie] this seems to be some problem with your database.. note that others and the CI/CD tests and Travis are not hitting this problem (and I'm not seeing it locally). Are you perhaps using a newer version of MySQL (perhaps it got automatically updated without you realizing?) or did you manually add another version of the MySQL JDBC driver? Could you post a full complete stack trace, not just the top line, to see if that could help to clarify what's going on here?

> Unknown table 'TABLE_NAMES' in information_schema
> -------------------------------------------------
>
>                 Key: FINERACT-1276
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1276
>             Project: Apache Fineract
>          Issue Type: Bug
>            Reporter: Francis Guchie
>            Assignee: Francis Guchie
>            Priority: Major
>
> After building the latest develop branch, I can not spring boot fineract i get the error below
> *Error creating bean with name '(inner bean)#707f107c': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantDatabaseUpgradeService': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback;* 
>  *bad SQL grammar [SHOW TABLES LIKE 'schema_version';];* 
>  *nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'TABLE_NAMES' in information_schema*
> *Query being executed when exception was thrown:*
>  *SHOW FULL COLUMNS FROM `information_schema`.`TABLE_NAMES`*
> *if you look at  org\apache\fineract\infrastructure\core\service\TenantDatabaseUpgradeService.java*
>  *line 133 this is where it all starts* 
> But i cannot figure out where the SHOW FULL COLUMNS FROM `information_schema`.`TABLE_NAMES` line is 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)