0xDBE 142.3723.2 on Mac OS X to Postgres (9.x)

I've been using 0xDBE flawlessly for a few months now.  Since this latest build has come out I've been unable to synchornize with any of my connections.   I can connect to each database, filter schemas, run queries, etc, however the Database tool window is displaying 0 objects under all schemas.  When I try to synchronize an error window pops up with:

String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
  at java.lang.String.charAt(String.java:646)
  at com.intellij.openapi.util.text.StringUtilRt.lastIndexOf(StringUtilRt.java:298)
  at com.intellij.openapi.util.text.StringUtil.lastIndexOf(StringUtil.java:1978)
  at com.intellij.database.model.DataType.createEnumOrRet(DataType.java:148)
  at com.intellij.database.model.DataType.of(DataType.java:110)
  at com.intellij.dbm.postgre.PostgreIntrospector.a(PostgreIntrospector.java:759)
  at com.intellij.dbm.postgre.PostgreIntrospector.access$2600(PostgreIntrospector.java:30)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.i(PostgreIntrospector.java:550)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.access$900(PostgreIntrospector.java:176)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever$6.run(PostgreIntrospector.java:264)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.a(PostgreIntrospector.java:202)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.retrieve(PostgreIntrospector.java:260)
  at com.intellij.dbm.postgre.PostgreIntrospector$2.run(PostgreIntrospector.java:168)
  at org.jetbrains.jdba.core.BaseSession.inTransaction(BaseSession.java:88)
  at org.jetbrains.jdba.core.BaseFacade$2.run(BaseFacade.java:93)
  at org.jetbrains.jdba.core.BaseFacade.inSession(BaseFacade.java:125)
  at org.jetbrains.jdba.core.BaseFacade.inTransaction(BaseFacade.java:89)
  at com.intellij.dbm.postgre.PostgreIntrospector.a(PostgreIntrospector.java:164)
  at com.intellij.dbm.postgre.PostgreIntrospector.b(PostgreIntrospector.java:152)
  at com.intellij.dbm.postgre.PostgreIntrospector.introspect(PostgreIntrospector.java:85)
  at com.intellij.database.dataSource.NativeSchemaLoader.a(NativeSchemaLoader.java:107)
  at com.intellij.database.dataSource.NativeSchemaLoader.introspectAndAdapt(NativeSchemaLoader.java:61)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadDataSourceState(DatabaseSchemaLoader.java:107)
  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.AbstractDataSource.performJdbcOperation(AbstractDataSource.java:110)
  at com.intellij.database.dataSource.AbstractDataSource.refreshMetaData(AbstractDataSource.java:32)
  at com.intellij.database.dataSource.DataSourceUiUtil$2.run(DataSourceUiUtil.java:167)
  at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:563)
  at com.intellij.openapi.progress.impl.CoreProgressManager$2.run(CoreProgressManager.java:142)
  at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:446)
  at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:392)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:54)
  at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:127)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl$1.run(ProgressManagerImpl.java:126)
  at com.intellij.openapi.application.impl.ApplicationImpl$8.run(ApplicationImpl.java:368)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at java.lang.Thread.run(Thread.java:745)
  at org.jetbrains.ide.PooledThreadExecutor$1$1.run(PooledThreadExecutor.java:55)



I'm connecting with a superuser account which works fine in other clients and previously in 0xDBE.  I've invalidated caches and restarted while grasping at straws.  

Any ideas?

14 comments
Comment actions Permalink

Hello Don,

Could you please check with last build from https://confluence.jetbrains.com/display/DBE/0xDBE+1.0+EAP . If problem remains, please attach full idea.log https://intellij-support.jetbrains.com/hc/en-us/articles/206827517 after error occurs. Thanks.

0
Comment actions Permalink

I'm also getting this error when trying to connect to our redshift instance.

In addition, I've lost the ability to browse the DB structure. Everything is set up correctly in the connection dialog and tables/scheme tab.

I've been using 0xDBE with the same redshift instance for the past six months, and I'm getting these problems all of a sudden.

Tried changing the connection properties to use both the amazon redshift drive and the included postgres driver - same results.

0
Comment actions Permalink

I'm also getting this error when trying to connect to our redshift instance.

In addition, I've lost the ability to browse the DB structure. Everything is set up correctly in the connection dialog and tables/scheme tab.

I've been using 0xDBE with the same redshift instance for the past six months, and I'm getting these problems all of a sudden.

Tried changing the connection properties to use both the amazon redshift drive and the included postgres driver - same results.

0
Comment actions Permalink

Hi Elik,

If using last EAP build gives the same result, please attach idea.log and specify output information from Test Connection action for your Data Source. Thanks!

0
Comment actions Permalink

I can't seem to upload files to the forum.

Any other way to send you the log file?

0
Comment actions Permalink

@Andrey - I've downloaded and run 0xdbe-142.3925.2.dmg with the same results.

The idea.log is attached to this post.



Attachment(s):
idea.log.gz
0
Comment actions Permalink

These logs do not contain StringIndexOutOfBoundsException error. Do you still see it?

Could you please try to delete ~/Library/Preferences/.0xDBE10/projects/<project_name>/.idea/dataSources.ids file (where <project_name> is either default project or the project, created via File | Project action where you have this Data Source) then press Synchronize button for this Data Source or try to create new Data Source for this connection and check if it helps. If not, would you please attach new idea.log file after synchronization. Thank you in advance for collaboration.

0
Comment actions Permalink

To answer your question, I am still getting the out of bounds exception.

I deleted the datasources.ids file as requested and restarted 0xDBE, reconnected and synchronized.  Same problem exists.   This error is thrown:

String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
  at java.lang.String.charAt(String.java:646)
  at com.intellij.openapi.util.text.StringUtilRt.lastIndexOf(StringUtilRt.java:298)
  at com.intellij.openapi.util.text.StringUtil.lastIndexOf(StringUtil.java:1978)
  at com.intellij.database.model.DataType.createEnumOrRet(DataType.java:148)
  at com.intellij.database.model.DataType.of(DataType.java:110)
  at com.intellij.dbm.postgre.PostgreIntrospector.a(PostgreIntrospector.java:766)
  at com.intellij.dbm.postgre.PostgreIntrospector.access$2800(PostgreIntrospector.java:31)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.i(PostgreIntrospector.java:557)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.access$900(PostgreIntrospector.java:177)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever$6.run(PostgreIntrospector.java:265)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.a(PostgreIntrospector.java:203)
  at com.intellij.dbm.postgre.PostgreIntrospector$SchemaRetriever.retrieve(PostgreIntrospector.java:261)
  at com.intellij.dbm.postgre.PostgreIntrospector$2.run(PostgreIntrospector.java:169)
  at org.jetbrains.jdba.core.BaseSession.inTransaction(BaseSession.java:88)
  at org.jetbrains.jdba.core.BaseFacade$2.run(BaseFacade.java:93)
  at org.jetbrains.jdba.core.BaseFacade.inSession(BaseFacade.java:125)
  at org.jetbrains.jdba.core.BaseFacade.inTransaction(BaseFacade.java:89)
  at com.intellij.dbm.postgre.PostgreIntrospector.a(PostgreIntrospector.java:165)
  at com.intellij.dbm.postgre.PostgreIntrospector.b(PostgreIntrospector.java:153)
  at com.intellij.dbm.postgre.PostgreIntrospector.introspect(PostgreIntrospector.java:86)
  at com.intellij.database.dataSource.NativeSchemaLoader.a(NativeSchemaLoader.java:113)
  at com.intellij.database.dataSource.NativeSchemaLoader.introspectAndAdapt(NativeSchemaLoader.java:67)
  at com.intellij.database.dataSource.DatabaseSchemaLoader.loadDataSourceState(DatabaseSchemaLoader.java:107)
  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.AbstractDataSource.performJdbcOperation(AbstractDataSource.java:110)
  at com.intellij.database.dataSource.AbstractDataSource.refreshMetaData(AbstractDataSource.java:32)
  at com.intellij.database.dataSource.DataSourceUiUtil$2.run(DataSourceUiUtil.java:167)
  at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:563)
  at com.intellij.openapi.progress.impl.CoreProgressManager$2.run(CoreProgressManager.java:142)
  at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:446)
  at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:392)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:54)
  at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:127)
  at com.intellij.openapi.progress.impl.ProgressManagerImpl$1.run(ProgressManagerImpl.java:126)
  at com.intellij.openapi.application.impl.ApplicationImpl$8.run(ApplicationImpl.java:367)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at java.lang.Thread.run(Thread.java:745)
  at org.jetbrains.ide.PooledThreadExecutor$1$1.run(PooledThreadExecutor.java:55)

idea.log for this session attached

Also, the collaboration is completely welcome.  This is the best and most stable admin/dev client I've come across for Postgres yet (with some caveats :-) ).  I'm looking forward to its release.



Attachment(s):
idea.log.gz
0
Comment actions Permalink

Thnaks! Created the https://youtrack.jetbrains.com/issue/DBE-1475 for fixing this. Please follow for progress. Also, forgot to ask, could you please provide the output from Test Connection button for the Data Source. Thanks.

0
Comment actions Permalink

Sure, here's the screen shot of the connection test for this datasource.



Attachment(s):
Screen Shot 2015-08-14 at 8.10.54 AM.png
0
Comment actions Permalink

Thank you, added information to YouTrack issue.

0

Please sign in to leave a comment.