Hi Peter,
is the database in discussion your own ? i mean are you managing db
server yourself ?
Thanks
Syed
On 08/03/2011 15:27, Peter Stevenson wrote:
I'm using v0.7 and sometimes getting errors similar to the example in the stack
trace below.
I have only noticed it in linked dataset queries.
For this particular query, results are returned OK for 10 rows, or 20 rows but
asking for 50 rows of
results sets off the exception.
It seems to be data dependent, so that the same set of filters and attributes
with different input
values will run without error.
Any thoughts on why this might be happening?
Stack trace below:-
Serious Error: Error during query execution: Got a packet bigger than
'max_allowed_packet' bytes
ERROR: caught BioMart::Exception::Database: Error during query execution: Got a
packet bigger than
'max_allowed_packet' bytes
If you repeatedly get directed to this error page, there may be a problem with
your current session
parameters. To clear your session and start with a clean slate, please click
the New button below.
Stacktrace:
Exception::Class::Base::throw
/export/system0/biomart/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith
/export/system0/biomart/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable
/export/system0/biomart/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable
/export/system0/biomart/biomart-perl/lib/BioMart/ResultTable.pm:195
BioMart::ResultTable::_getBatch
/export/system0/biomart/biomart-perl/lib/BioMart/ResultTable.pm:247
BioMart::ResultTable::hasMoreRows
/export/system0/biomart/biomart-perl/lib/BioMart/ResultTable.pm:248
BioMart::ResultTable::hasMoreRows
/export/system0/biomart/biomart-perl/lib/BioMart/AttributeTable.pm:169
BioMart::AttributeTable::nextRow
/export/system0/biomart/biomart-perl/lib/BioMart/ResultTable.pm:256
BioMart::ResultTable::nextRow
/export/system0/biomart/biomart-perl/lib/BioMart/Formatter/HTML.pm:103
BioMart::Formatter::HTML::nextRow
/export/system0/biomart/biomart-perl/lib/BioMart/QueryRunner.pm:259
BioMart::QueryRunner::printResults
/export/system0/biomart/biomart-perl/lib/BioMart/Web.pm:2439
(eval) /export/system0/biomart/biomart-perl/lib/BioMart/Web.pm:2198
BioMart::Web::handle_request
/export/system0/biomart/biomart-perl/cgi-bin/martview:100
(eval) /export/system0/biomart/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::export_system0_biomart_biomart_2dperl_cgi_2dbin_martview::handler
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval)
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0
Regards,
Peter.
_______________________________________________
Users mailing list
[email protected]
https://lists.biomart.org/mailman/listinfo/users
