You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Claus Köll (JIRA)" <ji...@apache.org> on 2006/09/19 08:50:22 UTC

[jira] Created: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

MsExcelTextFilter throws Exception. Repository is not startable
---------------------------------------------------------------

                 Key: JCR-574
                 URL: http://issues.apache.org/jira/browse/JCR-574
             Project: Jackrabbit
          Issue Type: Bug
          Components: indexing
    Affects Versions: 1.0.1
            Reporter: Claus Köll
            Priority: Critical
         Attachments: TEL.xls

If i try to add a Excel File (see attachment) i get this Exception

Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)

The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
get a blocker !

The stack from the restart after NumberFormatException

19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 

I think its very important that you can not block a whole repository if the indexer throws a exception.
thanks
claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Updated: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JCR-574?page=all ]

Marcel Reutegger updated JCR-574:
---------------------------------

    Fix Version/s: 1.2
                   1.1.1

> MsExcelTextFilter throws Exception. Repository is not startable
> ---------------------------------------------------------------
>
>                 Key: JCR-574
>                 URL: http://issues.apache.org/jira/browse/JCR-574
>             Project: Jackrabbit
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.0.1
>            Reporter: Claus Köll
>         Assigned To: Marcel Reutegger
>            Priority: Critical
>             Fix For: 1.2, 1.1.1
>
>         Attachments: TEL.xls
>
>
> If i try to add a Excel File (see attachment) i get this Exception
> Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
> 	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
> 	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
> 	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)
> The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
> get a blocker !
> The stack from the restart after NumberFormatException
> 19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
> 19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 
> I think its very important that you can not block a whole repository if the indexer throws a exception.
> thanks
> claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Resolved: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JCR-574?page=all ]

Marcel Reutegger resolved JCR-574.
----------------------------------

    Resolution: Fixed

Fixed the LazyReader class to also catch runtime exceptions when initializing the reader from the text filter implementation.

Fixed in revision 454360 of the text filter module.

Thank you for reporting this issue.

Please note that you can work around this issue by temporarily disable the text filters when restarting jackrabbit. Well, it's not a real workaround, because you'll get into this issue again when a similar excel file is uploaded and the text filters are enabled.

> MsExcelTextFilter throws Exception. Repository is not startable
> ---------------------------------------------------------------
>
>                 Key: JCR-574
>                 URL: http://issues.apache.org/jira/browse/JCR-574
>             Project: Jackrabbit
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.0.1
>            Reporter: Claus Köll
>         Assigned To: Marcel Reutegger
>            Priority: Critical
>         Attachments: TEL.xls
>
>
> If i try to add a Excel File (see attachment) i get this Exception
> Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
> 	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
> 	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
> 	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)
> The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
> get a blocker !
> The stack from the restart after NumberFormatException
> 19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
> 19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 
> I think its very important that you can not block a whole repository if the indexer throws a exception.
> thanks
> claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Assigned: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JCR-574?page=all ]

Marcel Reutegger reassigned JCR-574:
------------------------------------

    Assignee: Marcel Reutegger

> MsExcelTextFilter throws Exception. Repository is not startable
> ---------------------------------------------------------------
>
>                 Key: JCR-574
>                 URL: http://issues.apache.org/jira/browse/JCR-574
>             Project: Jackrabbit
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.0.1
>            Reporter: Claus Köll
>         Assigned To: Marcel Reutegger
>            Priority: Critical
>         Attachments: TEL.xls
>
>
> If i try to add a Excel File (see attachment) i get this Exception
> Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
> 	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
> 	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
> 	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)
> The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
> get a blocker !
> The stack from the restart after NumberFormatException
> 19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
> 19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 
> I think its very important that you can not block a whole repository if the indexer throws a exception.
> thanks
> claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Updated: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JCR-574?page=all ]

Claus Köll updated JCR-574:
---------------------------

    Attachment: TEL.xls

A sample xls file that produces the exception ...

> MsExcelTextFilter throws Exception. Repository is not startable
> ---------------------------------------------------------------
>
>                 Key: JCR-574
>                 URL: http://issues.apache.org/jira/browse/JCR-574
>             Project: Jackrabbit
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.0.1
>            Reporter: Claus Köll
>            Priority: Critical
>         Attachments: TEL.xls
>
>
> If i try to add a Excel File (see attachment) i get this Exception
> Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
> 	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
> 	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
> 	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)
> The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
> get a blocker !
> The stack from the restart after NumberFormatException
> 19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
> 19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 
> I think its very important that you can not block a whole repository if the indexer throws a exception.
> thanks
> claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Updated: (JCR-574) MsExcelTextFilter throws Exception. Repository is not startable

Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/JCR-574?page=all ]

Jukka Zitting updated JCR-574:
------------------------------

        Fix Version/s:     (was: 1.2)
    Affects Version/s: 1.0
                       1.1

> MsExcelTextFilter throws Exception. Repository is not startable
> ---------------------------------------------------------------
>
>                 Key: JCR-574
>                 URL: http://issues.apache.org/jira/browse/JCR-574
>             Project: Jackrabbit
>          Issue Type: Bug
>          Components: indexing
>    Affects Versions: 1.0, 1.0.1, 1.1
>            Reporter: Claus Köll
>         Assigned To: Marcel Reutegger
>            Priority: Critical
>             Fix For: 1.1.1
>
>         Attachments: TEL.xls
>
>
> If i try to add a Excel File (see attachment) i get this Exception
> Caused by: java.lang.NumberFormatException: You cannot get a string value from a numeric cell
> 	at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:800)
> 	at org.apache.jackrabbit.core.query.MsExcelTextFilter$1.initializeReader(MsExcelTextFilter.java:97)
> 	at org.apache.jackrabbit.core.query.LazyReader.read(LazyReader.java:79)
> The bad news is that if you add this file the repository is not startabel anymore because the file is in the redo.log and you
> get a blocker !
> The stack from the restart after NumberFormatException
> 19.09.2006 08:47:23 *ERROR* RepositoryImpl: Unable to start repository, forcing shutdown... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: Shutting down repository... 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: shutting down workspace 'default'... 
> 19.09.2006 08:47:23 *INFO * ObservationManagerFactory: Notification of EventListeners stopped. 
> 19.09.2006 08:47:23 *INFO * RepositoryImpl: workspace 'default' has been shutdown 
> I think its very important that you can not block a whole repository if the indexer throws a exception.
> thanks
> claus

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira