MySQL Database Integration issue. No columns shown for autocomplete

Note: This was asked earlier but by mistake I marked a reply as correct answer
I am trying to connect my database with the database tool of PHPStorm. After adding the data source, I get the table names, but the column names are  not being displayed. When writing queries in the database console I used to get suggestions for the column names as well, but now i am not getting any of these. All this happened after I executed a query which took around 2.5 hours to execute, after this the setting for my deployment server, subversion support,project directory, databse support  were messed up. I fixed other issues but unable to fix the database support issue. Please let me know how to troubleshoot this. Note while synchronising I used to get an error(when things were working perfectly) and even now i get it. I dont think that this is reason for the issue. Here is the stack trace


craigresults.*
java.sql.SQLException: View 'craigresults.daily_tracking_statistics_for_tapanalytics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2783)
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)
  at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2718)
  at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2605)
  at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
  at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2604)
  at com.intellij.database.remote.jdbc.impl.RemoteDatabaseMetaDataImpl.getColumns(RemoteDatabaseMetaDataImpl.java:170)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:322)
  at sun.rmi.transport.Transport$1.run(Transport.java:177)
  at sun.rmi.transport.Transport$1.run(Transport.java:174)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:173)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:556)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:811)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:670)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:745)
  at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:275)
  at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:252)
  at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161)
  at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:194)
  at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:148)
  at com.sun.proxy.$Proxy104.getColumns(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:124)
  at com.intellij.execution.rmi.RemoteUtil.access$100(RemoteUtil.java:36)
  at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:227)
  at com.sun.proxy.$Proxy105.getColumns(Unknown Source)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadTableBasicsInner(DatabaseSchemaLoader.java:1145)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadTableBasics(DatabaseSchemaLoader.java:1108)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadElementDetails(DatabaseSchemaLoader.java:1038)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadDataSourceStateInner(DatabaseSchemaLoader.java:151)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadDataSourceState(DatabaseSchemaLoader.java:83)
  at com.intellij.database.dataSource.AbstractDataSource.refreshMetaData(AbstractDataSource.java:59)
  at com.intellij.database.dataSource.AbstractDataSource$1.perform(AbstractDataSource.java:34)
  at com.intellij.database.dataSource.AbstractDataSource$1.perform(AbstractDataSource.java:32)
  at com.intellij.database.dataSource.DataSource.performJdbcOperation(DataSource.java:367)
  at com.intellij.database.dataSource.AbstractDataSource.refreshMetaData(AbstractDataSource.java:32)
  at com.intellij.database.dataSource.DataSourceUiUtil$2.run(DataSourceUiUtil.java:175)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl$TaskRunnable.run(ProgressManagerImpl.java:478)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl$2.run(ProgressManagerImpl.java:177)
  at com.intellij.openapi.progress.ProgressManager.executeProcessUnderProgress(ProgressManager.java:193)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:211)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl.runProcess(ProgressManagerImpl.java:164)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl$8.run(ProgressManagerImpl.java:387)
  at com.intellij.openapi.application.impl.ApplicationImpl$9.run(ApplicationImpl.java:447)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:745)
  at com.intellij.openapi.application.impl.ApplicationImpl$1$1.run(ApplicationImpl.java:149)

2 comments
Comment actions Permalink

Seems to be the known issue: https://youtrack.jetbrains.com/issue/DBE-829 . Please vote/comment for it on tracker. See http://intellij-support.jetbrains.com/entries/23368682 if you are not familiar with YouTrack.

0
Comment actions Permalink

Thanks for the reply. I tried dropping the views and the synchronization worked perfectly.

0

Please sign in to leave a comment.