You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by JOSE FELIX HERNANDEZ BARRIO <jo...@isthari.com> on 2010/04/19 17:14:33 UTC
Datastore in windows with microsoft sql server hangs !!
Hi all,
I'm using win 2008 with microsoft sql server and a datastore
when i insert large files (bigger than 50kb only !!) in the repository the
server hangs, with 0% cpu usage but the call doesn't return.
any tip ?
my repository.xml
<Repository>
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
<DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
<param name="minRecordLength" value="1000"/>
</DataStore>
<Security appName="Jackrabbit">
<SecurityManager
class="org.apache.jackrabbit.core.DefaultSecurityManager"
workspaceName="security">
<UserManager
class="org.apache.jackrabbit.core.security.user.UserManagerImpl"/>
</SecurityManager>
<AccessManager
class="org.apache.jackrabbit.core.security.DefaultAccessManager"/>
<LoginModule
class="org.apache.jackrabbit.core.security.authentication.DefaultLoginModule"/>
</Security>
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<Workspace name="${wsp.name}">
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url" value="jdbc:sqlserver://10.0.129.47
;databaseName=...."/>
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
<param name="tableSpace" value=""/>
<param name="bundleCacheSize" value="8"/>
</PersistenceManager>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the
respective
persistence manager
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version" />
</FileSystem>
<!--
Configures the persistence manager to be used for persisting
version state.
Please note that the current versioning implementation is based
on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url" value="jdbc:sqlserver://10.0.129.47
;databaseName=..."/>
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="version_"/>
<param name="externalBLOBs" value="false"/>
<param name="tableSpace" value=""/>
<param name="bundleCacheSize" value="8"/>
</PersistenceManager>
</Versioning>
<!--
Search index for content that is shared repository wide
(/jcr:system tree, contains mainly versions)
-->
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Repository>
--
Jose Hernandez
675599600
Isthari
http://www.isthari.com
Re: Datastore in windows with microsoft sql server hangs !!
Posted by JOSE FELIX HERNANDEZ BARRIO <jo...@isthari.com>.
correction about previous mail,
in 2.0.0 the server hangs forever . . .
in 2.1.0 every thing works fine.
2010/4/19 Thomas Müller <th...@day.com>
> Hi,
>
> Could you create a full thread dump and post it? Also, please provide
> the jackrabbit version number (the easiest is probably the list of jar
> files in the classpath). How do you upload the file - using WebDAV?
>
> Regards,
> Thomas
>
--
Jose Hernandez
675599600
Isthari
http://www.isthari.com
Re: Datastore in windows with microsoft sql server hangs !!
Posted by Thomas Müller <th...@day.com>.
Hi,
Could you create a full thread dump and post it? Also, please provide
the jackrabbit version number (the easiest is probably the list of jar
files in the classpath). How do you upload the file - using WebDAV?
Regards,
Thomas
Re: Datastore in windows with microsoft sql server hangs !!
Posted by Alexander Klimetschek <ak...@day.com>.
On Mon, Apr 19, 2010 at 17:54, JOSE FELIX HERNANDEZ BARRIO
<jo...@isthari.com> wrote:
> this bug affect the client only or also the server ?
I think it's in the server part, but I am not sure.
Regards,
Alex
--
Alexander Klimetschek
alexander.klimetschek@day.com
Re: Datastore in windows with microsoft sql server hangs !!
Posted by JOSE FELIX HERNANDEZ BARRIO <jo...@isthari.com>.
Thank you for the quick response,
but i'm using the version 2.1.0 from the repository (
https://repository.apache.org/content/repositories/orgapachejackrabbit-034)
should i test with the trunk version directly ?
this bug affect the client only or also the server ?
2010/4/19 Alexander Klimetschek <ak...@day.com>
> On Mon, Apr 19, 2010 at 17:14, JOSE FELIX HERNANDEZ BARRIO
> <jo...@isthari.com> wrote:
> > I'm using win 2008 with microsoft sql server and a datastore
> > when i insert large files (bigger than 50kb only !!) in the repository
> the
> > server hangs, with 0% cpu usage but the call doesn't return.
>
> Looks like this issue, if you happen to use JCR-RMI 2.0:
>
> https://issues.apache.org/jira/browse/JCR-2531
> http://markmail.org/thread/wegqunft5o3om4qy
>
> Regards,
> Alex
>
> --
> Alexander Klimetschek
> alexander.klimetschek@day.com
>
--
Jose Hernandez
675599600
Isthari
http://www.isthari.com
Re: Datastore in windows with microsoft sql server hangs !!
Posted by Alexander Klimetschek <ak...@day.com>.
On Mon, Apr 19, 2010 at 17:14, JOSE FELIX HERNANDEZ BARRIO
<jo...@isthari.com> wrote:
> I'm using win 2008 with microsoft sql server and a datastore
> when i insert large files (bigger than 50kb only !!) in the repository the
> server hangs, with 0% cpu usage but the call doesn't return.
Looks like this issue, if you happen to use JCR-RMI 2.0:
https://issues.apache.org/jira/browse/JCR-2531
http://markmail.org/thread/wegqunft5o3om4qy
Regards,
Alex
--
Alexander Klimetschek
alexander.klimetschek@day.com