org.jkiss.dbeaver.model.exec.DBCException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • GitHub comment 1138#271858213
    via GitHub by alextakitani
    ,
  • GitHub comment 501#223305017
    via GitHub by Jeetah
    ,
  • GitHub comment 598#230475073
    via GitHub by dosimeta
    ,
  • GitHub comment 7865#233204148
    via GitHub by samlotti2
    ,
  • Java/Postgres: Deadlock with Flyway clean
    via Stack Overflow by crusy
    ,
  • GitHub comment 48#269015368
    via GitHub by kopax
    ,
    • org.jkiss.dbeaver.model.exec.DBCException: Error executing row count at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.countData(SQLEditor.java:1731) at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.transferData(DatabaseTransferProducer.java:99) at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.transferData(DatabaseTransferProducer.java:1) at org.jkiss.dbeaver.tools.transfer.wizard.DataTransferJob.transferData(DataTransferJob.java:96) at org.jkiss.dbeaver.tools.transfer.wizard.DataTransferJob.run(DataTransferJob.java:65) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Caused by: org.jkiss.dbeaver.model.exec.DBCException: SQL Error [42803]: ERROR: column "orders.created_at" must appear in the GROUP BY clause or be used in an aggregate function Position: 124 at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:205) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.countData(SQLEditor.java:1713) ... 6 more Caused by: org.postgresql.util.PSQLException: ERROR: column "orders.created_at" must appear in the GROUP BY clause or be used in an aggregate function Position: 124 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.execute(JDBCPreparedStatementImpl.java:258) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeStatement(JDBCPreparedStatementImpl.java:202) ... 7 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    guizmaiiguizmaii
    131 times, last one,
    johnxflyjohnxfly
    3 times, last one,
    kjhdofjosvskjhdofjosvs
    25 times, last one,
    serious2monkeysserious2monkeys
    4 times, last one,
    91 more bugmates