[biomart-users] SQL error when searching biomart on ensembl today (US east mirror)

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[biomart-users] SQL error when searching biomart on ensembl today (US east mirror)

Fabien Campagne
I get this error today, nothing works. Not sure if anybody is watching the logs. 

Using http://useast.ensembl.org/biomart/martview/

Serious Error: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

ERROR: caught BioMart::Exception::Database: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

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 /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2469
(eval) /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2221
BioMart::Web::handle_request /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_www_www_81_ensembl_2dwebcode_biomart_2dperl_cgi_2dbin_martview::handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] SQL error when searching biomart on ensembl today (US east mirror)

Arek Kasprzyk
Hi Fabien,

is it any particular query that is causing these problems? I just checked something random and it worked fine for me.

In any case, the questions regarding the US Ensembl mirror are probably best emailed to [hidden email]

a.

On 12 September 2015 at 16:21, Fabien Campagne <[hidden email]> wrote:
I get this error today, nothing works. Not sure if anybody is watching the logs. 


Serious Error: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

ERROR: caught BioMart::Exception::Database: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

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 /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2469
(eval) /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2221
BioMart::Web::handle_request /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_www_www_81_ensembl_2dwebcode_biomart_2dperl_cgi_2dbin_martview::handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.



--


“You have enemies? Good. 
That means you've stood up for something, sometime in your life.”

― Winston Churchill

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] SQL error when searching biomart on ensembl today (US east mirror)

Fabien Campagne
Thanks for the suggestion Arek, I have sent more information to the helpdesk. Note that I sent the message here because clicking on the Help button in the UI sends users here (see bottom link).

On Saturday, September 12, 2015 at 11:48:07 AM UTC-4, Arek Kasprzyk wrote:
Hi Fabien,

is it any particular query that is causing these problems? I just checked something random and it worked fine for me.

In any case, the questions regarding the US Ensembl mirror are probably best emailed to <a href="javascript:" style="font-size:12.8px" target="_blank" gdf-obfuscated-mailto="fp0gRo9_KwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">helpdesk@ensembl.org. 

a.

On 12 September 2015 at 16:21, Fabien Campagne <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="fp0gRo9_KwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">fac...@...> wrote:
I get this error today, nothing works. Not sure if anybody is watching the logs. 

Using <a href="http://useast.ensembl.org/biomart/martview/" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\75http%3A%2F%2Fuseast.ensembl.org%2Fbiomart%2Fmartview%2F\46sa\75D\46sntz\0751\46usg\75AFQjCNGqYMjSpDBV0EXcS84A3rsF-NtQPw&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\75http%3A%2F%2Fuseast.ensembl.org%2Fbiomart%2Fmartview%2F\46sa\75D\46sntz\0751\46usg\75AFQjCNGqYMjSpDBV0EXcS84A3rsF-NtQPw&#39;;return true;">http://useast.ensembl.org/biomart/martview/

Serious Error: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

ERROR: caught BioMart::Exception::Database: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

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 /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2469
(eval) /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2221
BioMart::Web::handle_request /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_www_www_81_ensembl_2dwebcode_biomart_2dperl_cgi_2dbin_martview::handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="fp0gRo9_KwAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">biomart-user...@googlegroups.com.
Visit this group at <a href="http://groups.google.com/group/biomart-users" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://groups.google.com/group/biomart-users&#39;;return true;" onclick="this.href=&#39;http://groups.google.com/group/biomart-users&#39;;return true;">http://groups.google.com/group/biomart-users.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.



--


“You have enemies? Good. 
That means you've stood up for something, sometime in your life.”

― Winston Churchill

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] SQL error when searching biomart on ensembl today (US east mirror)

Arek Kasprzyk
Hi Fabien,

it is perfectly fine to send your email to biomart-users. I suggested Ensembl helpdesk because I assumed that your problem was specific to the Ensembl US mirror

a.

On 12 September 2015 at 17:03, Fabien Campagne <[hidden email]> wrote:
Thanks for the suggestion Arek, I have sent more information to the helpdesk. Note that I sent the message here because clicking on the Help button in the UI sends users here (see bottom link).

On Saturday, September 12, 2015 at 11:48:07 AM UTC-4, Arek Kasprzyk wrote:
Hi Fabien,

is it any particular query that is causing these problems? I just checked something random and it worked fine for me.

In any case, the questions regarding the US Ensembl mirror are probably best emailed to helpdesk@ensembl.org

a.

On 12 September 2015 at 16:21, Fabien Campagne <[hidden email]> wrote:
I get this error today, nothing works. Not sure if anybody is watching the logs. 


Serious Error: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

ERROR: caught BioMart::Exception::Database: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Añc r@VŸ«­Øÿy@<ü5Y£¡c@' at line 1

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 /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:241
BioMart::Dataset::TableSet::_fillAttributeTableWith /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Dataset/TableSet.pm:124
BioMart::Dataset::TableSet::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/DatasetI.pm:1170
BioMart::DatasetI::getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:472
BioMart::QueryRunner::_processPath /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:374
BioMart::QueryRunner::_getResultTable /ensemblweb/www/www_81/biomart-perl/lib/BioMart/QueryRunner.pm:194
BioMart::QueryRunner::execute /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2469
(eval) /ensemblweb/www/www_81/biomart-perl/lib/BioMart/Web.pm:2221
BioMart::Web::handle_request /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:100
(eval) /ensemblweb/www/www_81/ensembl-webcode/biomart-perl/cgi-bin/martview:99
ModPerl::ROOT::ModPerl::Registry::ensemblweb_www_www_81_ensembl_2dwebcode_biomart_2dperl_cgi_2dbin_martview::handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
(eval) /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:204
ModPerl::RegistryCooker::run /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/RegistryCooker.pm:170
ModPerl::RegistryCooker::default_handler /localsw/lib/perl5/site_perl/5.14.2/x86_64-linux-thread-multi/ModPerl/Registry.pm:31
ModPerl::Registry::handler -e:0
(eval) -e:0

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.



--


“You have enemies? Good. 
That means you've stood up for something, sometime in your life.”

― Winston Churchill

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.



--


“You have enemies? Good. 
That means you've stood up for something, sometime in your life.”

― Winston Churchill

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at http://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.