dbeaver: Exception when browsing PostgreSQL 15 table
Description
We recently upgrade PostgreSQL version from 10 to 15. Some of the tables throw this exception when we try to browse them:
Cannot invoke "org.jkiss.dbeaver.ext.postgresql.model.PostgreDataType.getTypeID()" because "this.dataType" is null
org.jkiss.dbeaver.DBException: Cannot invoke "org.jkiss.dbeaver.ext.postgresql.model.PostgreDataType.getTypeID()" because "this.dataType" is null
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:232)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5068)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.lang.NullPointerException: Cannot invoke "org.jkiss.dbeaver.ext.postgresql.model.PostgreDataType.getTypeID()" because "this.dataType" is null
at org.jkiss.dbeaver.ext.postgresql.model.PostgreAttribute.loadInfo(PostgreAttribute.java:175)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreAttribute.<init>(PostgreAttribute.java:91)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreTableColumn.<init>(PostgreTableColumn.java:55)
at org.jkiss.dbeaver.ext.postgresql.model.impls.PostgreServerExtensionBase.createTableColumn(PostgreServerExtensionBase.java:328)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreSchema$TableCache.fetchChild(PostgreSchema.java:812)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreSchema$TableCache.fetchChild(PostgreSchema.java:1)
at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructCache.loadChildren(JDBCStructCache.java:129)
at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructCache.getChildren(JDBCStructCache.java:221)
at org.jkiss.dbeaver.ext.postgresql.model.PostgreTableBase.getAttributes(PostgreTableBase.java:200)
at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readRequiredMeta(JDBCTable.java:910)
at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:134)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:173)
... 4 more

DBeaver Version
DBeaver 22.3.4 Community
Operating System
Windows 11
Database and driver
Database: PostgreSQL 10.23 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
Driver: org.postgresql:postgresql:RELEASE 42.5.0
Steps to reproduce
Trying to browse some tables.
Additional context
No response
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 19 (12 by maintainers)
Commits related to this issue
- #19097 Fix NPE on attribute info loading in PostgreSQL — committed to dbeaver/dbeaver by E1izabeth a year ago
- #19097 Fix NPE on attribute info loading in PostgreSQL (#20138) — committed to dbeaver/dbeaver by E1izabeth a year ago
Thank you for bug report.