Re: Error when performing heavy queries (pentaho)
Posted by: Filipe Silva
Date: July 25, 2014 04:40AM


Can you check pentaho logs? If some kind of timeout occurred in the Connector/J there must be an SQLException stack trace somewhere.

Also, net_write_timeout sets the time MySQL will wait for a block to be written to a connection before aborting the write. If this timeout is happening you must be facing serious problems in your network structure and I would recommend you to start searching there.

My best guess however, is that there could be a timeout setting in pentaho that sets the time this application is willing to wait for displaying results.

Options: ReplyQuote

Written By
Re: Error when performing heavy queries (pentaho)
July 25, 2014 04:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.