You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nutch.apache.org by "James Sullivan (JIRA)" <ji...@apache.org> on 2012/10/20 00:18:12 UTC
[jira] [Created] (NUTCH-1479) nutch readhostdb and updatehostdb do
not work with MySQL
James Sullivan created NUTCH-1479:
-------------------------------------
Summary: nutch readhostdb and updatehostdb do not work with MySQL
Key: NUTCH-1479
URL: https://issues.apache.org/jira/browse/NUTCH-1479
Project: Nutch
Issue Type: Bug
Components: storage
Affects Versions: 2.2
Environment: Nutch 2.x MySQL Ubuntu 12.04
Reporter: James Sullivan
Priority: Minor
bin/nutch readhostdb and bin/nutch updatehostdb commands do not work with MySQL backend. For example readhostdb throw the following exception -- HostDBReader: org.apache.gora.util.GoraException: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 512 bytes
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (NUTCH-1479) nutch readhostdb and updatehostdb do
not work with MySQL
Posted by "James Sullivan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/NUTCH-1479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Sullivan closed NUTCH-1479.
---------------------------------
Resolution: Not A Problem
Fix Version/s: 2.2
This is only an issue when using MySQL with UTF-8 settings and can be overcome by setting the size of the primarykey of the host table to an appropriate size.
> nutch readhostdb and updatehostdb do not work with MySQL
> --------------------------------------------------------
>
> Key: NUTCH-1479
> URL: https://issues.apache.org/jira/browse/NUTCH-1479
> Project: Nutch
> Issue Type: Bug
> Components: storage
> Affects Versions: 2.2
> Environment: Nutch 2.x MySQL Ubuntu 12.04
> Reporter: James Sullivan
> Priority: Minor
> Labels: 2.1.0, MySQL
> Fix For: 2.2
>
>
> bin/nutch readhostdb and bin/nutch updatehostdb commands do not work with MySQL backend. For example readhostdb throw the following exception -- HostDBReader: org.apache.gora.util.GoraException: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 512 bytes
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira