Column sorting throwing error

Question

Hi,

I have created a table widget which is having 3 lakh records and i added filter parameters by default date which will bring around 30000 records,if i am clicking on a column to sort it is throwing  an error as "Unable to load data from dataset ****
Please check dataset & widget config",but in other widgets which are having around 10000 records sorting is working fine.Could you what may be the problem.Please reply ASAP.

Thanks in Advance.

Comments

Please add log message and/or log file in you question. In this way we can help you.

Also, you could see which is the response of the rest service that is causing the error message.

---

Hi,

i cant send log file but i am giving the error which i got in knowage.log

Caused by: java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
    at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1928)
    at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3268)
    at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462)
    at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997)
    at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:123)
    ... 41 more

Answer 1

The error seems clear from your log. You probably need to increase the buffer size of mysql (e.g. in the /etc/mysql/my.cnf).

You could set sort_buffer_size to 256K

Anyway, this is an issue from third-party product. If you still have issue on that, please consider to use MySQL support.