Hello,
I tried with both the SQL server 2000 and 2005 with tomcat 6.0.16 and JDK 1.6. With 2000 there are more issues, seems I cannot register the users.
With 2005, I can register the users. But I see the following error message. I can not create the subcommunity, it says system error. That's all. There is no error message in the log file.
I have only one following error message in the jive.error.log while clearspace starting up .
[error] WARNING: failed to obtain next ID block due to thread contention. Trying again...
Thank you,
-Sreeni.
What version of Clearspace Community is this?
It's 2.0. Is that official not supporting the MS SQL server for clear space community 2.0?
Thanks
-Sreeni.
SQL Server 2005 is a supported database.
Is that the entire error log?
Was the database empty before installing Clearspace?
Yes. It's fresh empty database on MS SQL server 2005. Yes. I have only one error message in the log file.
Thanks
-Sreeni.
Hi Sreeni,
I'm sorry about the long delay in replies. I am still not sure what's wrong, but I've got a couple questions/requests if you're still experiencing problems with this:
Please let me know what you find out.
Thanks,
Vinh
Hi Vinh,
Now I am trying with the JDK1.5 on tomcat 5.5.26 with database sql server 2005.
I am running into the same issues as earlier, could not create the sub communities at all.
I see the following message in the jive.info.log
2008.05.08 14:58:27 Page cache initialized with maximum size: 1000 and expiration: 30 seconds
2008.05.08 14:59:37 User 'sreenivas' not found.
I was trying to create the sub community named 'sreenivas' from admin tool. Community->Management->Summary.
But I see the info message as user 'sreenivas' not found. That does not sound correct to me.
Here is the Thread dump, I am running from eclipse.
2872 javaw.exe session:0 threads:44 parent:5144
Thu May 08 14:48:19 2008
Full thread dump Java HotSpot(TM) Client VM (1.5.0_03-b07 mixed mode):
"StackTrace Remote Thread" prio=5 tid=0x4b9c4808 nid=0x10e4 runnable [0x00000000..0x4c4efa44]
"pool-3-thread-1" prio=5 tid=0x4bc561a0 nid=0x1410 waiting on condition [0x4c35f000..0x4c35fb68]
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.park(Unknown Source)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unk nown Source)
at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
"pool-2-thread-1" prio=5 tid=0x4b399ad8 nid=0x1390 waiting on condition [0x4c11f000..0x4c11fbe8]
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.park(Unknown Source)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unk nown Source)
at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
"TP-Monitor" daemon prio=5 tid=0x4bac42f0 nid=0x760 in Object.wait() [0x4dadf000..0x4dadfc68]
at java.lang.Object.wait(Native Method)
- waiting on <0x077605c0> (a org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:5 64)
- locked <0x077605c0> (a org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Unknown Source)
"TP-Processor4" daemon prio=5 tid=0x4b86dc18 nid=0x10d8 runnable [0x4da9f000..0x4da9fce8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x07760620> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.apache.jk.common.ChannelSocket.accept(ChannelSocket.java:312)
at org.apache.jk.common.ChannelSocket.acceptConnections(ChannelSocket.java:666)
at org.apache.jk.common.ChannelSocket$SocketAcceptor.runIt(ChannelSocket.java:876)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 89)
at java.lang.Thread.run(Unknown Source)
"TP-Processor3" daemon prio=5 tid=0x00a51c80 nid=0xe58 in Object.wait() [0x4da5f000..0x4da5fd68]
at java.lang.Object.wait(Native Method)
- waiting on <0x07760850> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x07760850> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"TP-Processor2" daemon prio=5 tid=0x4b2f6ad8 nid=0x834 in Object.wait() [0x4da1f000..0x4da1f9e8]
at java.lang.Object.wait(Native Method)
- waiting on <0x07760870> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x07760870> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"TP-Processor1" daemon prio=5 tid=0x4b3b9a88 nid=0x1480 in Object.wait() [0x4d9df000..0x4d9dfa68]
at java.lang.Object.wait(Native Method)
- waiting on <0x07760890> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x07760890> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"http-8080-Monitor" prio=5 tid=0x4b979560 nid=0x1184 in Object.wait() [0x4d99f000..0x4d99fae8]
at java.lang.Object.wait(Native Method)
- waiting on <0x077608b0> (a org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:5 64)
- locked <0x077608b0> (a org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Unknown Source)
"http-8080-Processor4" daemon prio=5 tid=0x4badb588 nid=0x125c in Object.wait() [0x4d95f000..0x4d95fb68]
at java.lang.Object.wait(Native Method)
- waiting on <0x077608c8> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x077608c8> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"http-8080-Processor3" daemon prio=5 tid=0x4badb008 nid=0x115c runnable [0x4d91f000..0x4d91fbe8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x0aee72e0> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(DefaultServe rSocketFactory.java:61)
at org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.java:40 8)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorke rThread.java:71)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 89)
at java.lang.Thread.run(Unknown Source)
"http-8080-Processor2" daemon prio=5 tid=0x4bb3b300 nid=0x710 in Object.wait() [0x4d8df000..0x4d8dfc68]
at java.lang.Object.wait(Native Method)
- waiting on <0x077609f0> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x077609f0> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"http-8080-Processor1" daemon prio=5 tid=0x4bb3b180 nid=0x9e4 in Object.wait() [0x4d89f000..0x4d89fce8]
at java.lang.Object.wait(Native Method)
- waiting on <0x07760a10> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 61)
- locked <0x07760a10> (a org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Unknown Source)
"ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=5 tid=0x4b9f0d68 nid=0xaa4 waiting on condition [0x4c3df000..0x4c3dfd68]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Contain erBase.java:1548)
at java.lang.Thread.run(Unknown Source)
"pool-6-thread-1" prio=5 tid=0x4b1aed10 nid=0x6e0 waiting on condition [0x4c85f000..0x4c85f9e8]
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNano s(Unknown Source)
at java.util.concurrent.DelayQueue.take(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
"PopularityDeterminationWorker" prio=5 tid=0x4bca2048 nid=0xf38 waiting on condition [0x4c81f000..0x4c81fa68]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.DbActivityManager$PopularityDeterminationWorker .run(DbActivityManager.java:804)
at java.lang.Thread.run(Unknown Source)
"ActivityQueueWorker" prio=5 tid=0x4bb51ae8 nid=0x1728 waiting on condition [0x4c7df000..0x4c7dfae8]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.DbActivityManager$ActivityWorker.run(DbActivity Manager.java:635)
at java.lang.Thread.run(Unknown Source)
"cloudRepeatingTimer" prio=5 tid=0x4b328dd0 nid=0x14e4 in Object.wait() [0x4c45f000..0x4c45f9e8]
at java.lang.Object.wait(Native Method)
- waiting on <0x0bbc2a98> (a java.util.TaskQueue)
at java.util.TimerThread.mainLoop(Unknown Source)
- locked <0x0bbc2a98> (a java.util.TaskQueue)
at java.util.TimerThread.run(Unknown Source)
"cloudSingleShotTimer" prio=5 tid=0x4b909b90 nid=0x1408 in Object.wait() [0x4c41f000..0x4c41fa68]
at java.lang.Object.wait(Native Method)
- waiting on <0x0bbc1c28> (a java.util.TaskQueue)
at java.util.TimerThread.mainLoop(Unknown Source)
- locked <0x0bbc1c28> (a java.util.TaskQueue)
at java.util.TimerThread.run(Unknown Source)
"Update Manager" daemon prio=5 tid=0x4b9f0ee8 nid=0x1574 waiting on condition [0x4c15f000..0x4c15fbe8]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.base.update.UpdateManager$1.waitForNextCheck(UpdateManager.jav a:196)
at com.jivesoftware.base.update.UpdateManager$1.run(UpdateManager.java:129)
"EmailHandler 4" prio=5 tid=0x4b4b0950 nid=0x11d8 waiting on condition [0x4c31f000..0x4c31fce8]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.EmailManagerImpl$EmailHandler.run(EmailManagerI mpl.java:174)
"EmailHandler 3" prio=5 tid=0x4b96bd28 nid=0xd9c waiting on condition [0x4c2df000..0x4c2dfd68]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.EmailManagerImpl$EmailHandler.run(EmailManagerI mpl.java:174)
"EmailHandler 2" prio=5 tid=0x4b211d58 nid=0x1130 waiting on condition [0x4c29f000..0x4c29f9e8]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.EmailManagerImpl$EmailHandler.run(EmailManagerI mpl.java:174)
"EmailHandler 1" prio=5 tid=0x4b932d30 nid=0xffc waiting on condition [0x4c25f000..0x4c25fa68]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.EmailManagerImpl$EmailHandler.run(EmailManagerI mpl.java:174)
"EmailHandler 0" prio=5 tid=0x4b8cb9d0 nid=0x14fc waiting on condition [0x4c21f000..0x4c21fae8]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.impl.EmailManagerImpl$EmailHandler.run(EmailManagerI mpl.java:174)
"Cache Stats" daemon prio=5 tid=0x4b8fc9b0 nid=0x6fc waiting on condition [0x4c1df000..0x4c1dfb68]
at java.lang.Thread.sleep(Native Method)
at com.jivesoftware.community.cache.CacheFactory$1.run(CacheFactory.java:437)
"Logger@19298802 3.3/387" daemon prio=4 tid=0x4b89a820 nid=0x7d4 in Object.wait() [0x4c19f000..0x4c19fbe8]
at java.lang.Object.wait(Native Method)
- waiting on <0x0b21f258> (a com.tangosol.coherence.component.application.console.Coherence$Logger$Queue)
at com.tangosol.coherence.component.util.Daemon.onWait(Daemon.CDB:11)
- locked <0x0b21f258> (a com.tangosol.coherence.component.application.console.Coherence$Logger$Queue)
at com.tangosol.coherence.component.util.Daemon.run(Daemon.CDB:32)
at java.lang.Thread.run(Unknown Source)
"Task Engine Worker 2" daemon prio=5 tid=0x4b403448 nid=0x133c in Object.wait() [0x4c0df000..0x4c0dfd68]
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Unknown Source)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.nextTask(TaskEngine.java :332)
- locked <0x0b1cfe38> (a java.lang.Object)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.run(TaskEngine.java:359)
"Task Engine Worker 1" daemon prio=5 tid=0x4b4c7198 nid=0xa9c in Object.wait() [0x4c09f000..0x4c09f9e8]
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Unknown Source)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.nextTask(TaskEngine.java :332)
- locked <0x0b1cfe38> (a java.lang.Object)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.run(TaskEngine.java:359)
"Task Engine Worker 0" daemon prio=5 tid=0x4b442048 nid=0xf18 in Object.wait() [0x4c05f000..0x4c05fa68]
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Unknown Source)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.nextTask(TaskEngine.java :332)
- locked <0x0b1cfe38> (a java.lang.Object)
at com.jivesoftware.util.task.TaskEngine$TaskEngineWorker.run(TaskEngine.java:359)
"Timer-0" daemon prio=5 tid=0x4b4d2940 nid=0x1348 in Object.wait() [0x4c01f000..0x4c01fae8]
at java.lang.Object.wait(Native Method)
- waiting on <0x0b1cfe58> (a java.util.TaskQueue)
at java.util.TimerThread.mainLoop(Unknown Source)
- locked <0x0b1cfe58> (a java.util.TaskQueue)
at java.util.TimerThread.run(Unknown Source)
"taskTimer" prio=5 tid=0x4b28b9e0 nid=0x1568 in Object.wait() [0x4bfdf000..0x4bfdfb68]
at java.lang.Object.wait(Native Method)
- waiting on <0x0b1cb9a0> (a java.util.TaskQueue)
at java.lang.Object.wait(Unknown Source)
at java.util.TimerThread.mainLoop(Unknown Source)
- locked <0x0b1cb9a0> (a java.util.TaskQueue)
at java.util.TimerThread.run(Unknown Source)
"Prototyper" daemon prio=5 tid=0x4b7be7f8 nid=0x1150 in Object.wait() [0x4bf6f000..0x4bf6fbe8]
at java.lang.Object.wait(Native Method)
- waiting on <0x0b0f3958> (a org.logicalcobwebs.proxool.PrototyperThread)
at java.lang.Object.wait(Unknown Source)
at org.logicalcobwebs.proxool.PrototyperThread.doWait(PrototyperThread.java:69)
- locked <0x0b0f3958> (a org.logicalcobwebs.proxool.PrototyperThread)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:58)
"HouseKeeper" daemon prio=5 tid=0x4b2a7d10 nid=0xd0c waiting on condition [0x4bf2f000..0x4bf2fc68]
at java.lang.Thread.sleep(Native Method)
at org.logicalcobwebs.proxool.HouseKeeperThread.run(HouseKeeperThread.java:46)
"Low Memory Detector" daemon prio=5 tid=0x00a4cd68 nid=0x10ec runnable [0x00000000..0x00000000]
"CompilerThread0" daemon prio=10 tid=0x00a40e10 nid=0x15d8 waiting on condition [0x00000000..0x4b05f74c]
"Signal Dispatcher" daemon prio=10 tid=0x00a4a340 nid=0x15a0 runnable [0x00000000..0x00000000]
"JDWP Command Reader" daemon prio=5 tid=0x00a487d0 nid=0x174c runnable [0x00000000..0x00000000]
"JDWP Event Helper Thread" daemon prio=5 tid=0x00a47928 nid=0x12f8 runnable [0x00000000..0x00000000]
"JDWP Transport Listener: dt_socket" daemon prio=5 tid=0x00a46140 nid=0x11e8 runnable [0x00000000..0x4af5f9f0]
"Finalizer" daemon prio=9 tid=0x00a38188 nid=0x300 in Object.wait() [0x4af1f000..0x4af1fc68]
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
- locked <0x0ad1f6f0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
"Reference Handler" daemon prio=10 tid=0x00a36cf8 nid=0x172c in Object.wait() [0x4aedf000..0x4aedfce8]
at java.lang.Object.wait(Native Method)
- waiting on <0x0ad1f710> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Unknown Source)
at java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)
- locked <0x0ad1f710> (a java.lang.ref.Reference$Lock)
"main" prio=5 tid=0x00357db8 nid=0x1090 runnable [0x0006f000..0x0006fc08]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
- locked <0x07760a98> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at org.apache.catalina.core.StandardServer.await(StandardServer.java:379)
at org.apache.catalina.startup.Catalina.await(Catalina.java:616)
at org.apache.catalina.startup.Catalina.start(Catalina.java:576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
"VM Thread" prio=10 tid=0x009f7be0 nid=0x1460 runnable
"VM Periodic Task Thread" prio=10 tid=0x00a4dfb0 nid=0xa48 waiting on condition
=================
System Properties
=================
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
sun.boot.library.path=C:\sreeni\Program Files\Java\jre1.5.0_03\bin
java.vm.version=1.5.0_03-b07
shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
java.vm.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
path.separator=;
tomcat.util.buf.StringCache.byte.enabled=true
java.vm.name=Java HotSpot(TM) Client VM
file.encoding.pkg=sun.io
user.country=US
sun.os.patch.level=Service Pack 2
java.vm.specification.name=Java Virtual Machine Specification
user.dir=C:\Tomcat55
java.runtime.version=1.5.0_03-b07
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.endorsed.dirs=C:\Tomcat55\common\endorsed
os.arch=x86
java.io.tmpdir=C:\Tomcat55\temp
line.separator=
java.vm.specification.vendor=Sun Microsystems Inc.
java.naming.factory.url.pkgs=org.apache.naming
user.variant=
os.name=Windows XP
httpclient.useragent=Clearspace v2.0.0
sun.jnu.encoding=Cp1252
java.library.path=C:\sreeni\Program Files\Java\jre1.5.0_03\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\sreeni\Program Files\Java\jdk1.5.0_03\bin;C:\sreeni\src\dialogue_47\Recipio\3rdparty\ant\bin;C :\sreeni\sygwin\bin;C:\Perl\bin\;C:\Program Files\ThinkPad\Utilities;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbe m;C:\Program Files\Intel\Wireless\Bin\;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\PC-Doctor for Windows\;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\Program Files\Diskeeper Corporation\Diskeeper\;C:\CCAST;C:\sreeni\PROGRA~1\Tcl\bin;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\SSH Communications Security\SSH Secure Shell
java.specification.name=Java Platform API Specification
java.class.version=49.0
sun.management.compiler=HotSpot Client Compiler
os.version=5.1
user.home=C:\Documents and Settings\sreeni.gaddam
catalina.useNaming=true
user.timezone=America/Los_Angeles
java.awt.printerjob=sun.awt.windows.WPrinterJob
file.encoding=Cp1252
java.specification.version=1.5
catalina.home=C:\Tomcat55
java.class.path=C:\Tomcat55\bin\bootstrap.jar
user.name=sreeni.gaddam
java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apach e.tomcat.,org.apache.jasper.
java.vm.specification.version=1.0
java.home=C:\sreeni\Program Files\Java\jre1.5.0_03
sun.arch.data.model=32
user.language=en
java.specification.vendor=Sun Microsystems Inc.
awt.toolkit=sun.awt.windows.WToolkit
java.vm.info=mixed mode
java.version=1.5.0_03
java.ext.dirs=C:\sreeni\Program Files\Java\jre1.5.0_03\lib\ext
sun.boot.class.path=C:\sreeni\Program Files\Java\jre1.5.0_03\lib\rt.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\lib\i18n.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\lib\sunrsasign.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\lib\jsse.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\lib\jce.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\lib\charsets.jar;C:\sreeni\Program Files\Java\jre1.5.0_03\classes
server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar
java.vendor=Sun Microsystems Inc.
catalina.base=C:\Tomcat55
file.separator=\
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
common.loader=${catalina.home}/common/classes,${catalina.home}/common/i18n/.jar,${catalina.home}/common/endorsed/.jar,${catalina.home}/common/lib/*.jar
sun.io.unicode.encoding=UnicodeLittle
sun.cpu.endian=little
package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat., org.apache.jasper.,sun.beans.
sun.desktop=windows
sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
============
Command line
============
"C:\sreeni\Program Files\Java\jre1.5.0_03\bin\javaw.exe" -Dcatalina.home=C:\Tomcat55 -Djava.endorsed.dirs=C:\Tomcat55\common\endorsed -Dcatalina.base=C:\Tomcat55 -Djava.io.tmpdir=C:\Tomcat55\temp -Xms1024m -Xmx1024m -XX:MaxPermSize=128M -XX:SurvivorRatio=3 -XX:MaxNewSize=128M -XX:NewSize=128M -classpath C:\Tomcat55\bin\bootstrap.jar -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:3796 org.apache.catalina.startup.Bootstrap -config C:\Tomcat55\conf\server.xml start
======
Memory
======
Used: 118632960 (~113MB)
Free: 928304640 (~885MB)
Total: 1046937600 (~998MB)
Max: 1046937600 (~998MB)
[###########==================================================================== =====================]
Available Processors: 1
Thank you Sreeni. I assume the error log still just says, "error WARNING: failed to obtain next ID block due to thread contention. Trying again..." at the time of the error?
Thanks,
Vinh
Vinh,
Yes, you are correct. The log file has only one error
[error] WARNING: failed to obtain next ID block due to thread contention. Trying again...
There are no errors in the tomcat log files.
I am missing any special permissions? I am not sure.
Thanks
-Sreeni.
HI Vinh,
I see the following exception while restarting the clearspace, after the initial setup process. I am using clearspace community 2.0.2 war file, under tomcat 5.5.26, JDK 1.5 SQL server 2005.
May 9, 2008 10:18:32 AM com.jivesoftware.community.impl.OptimizeIndexTask run
INFO: Finished OptimizeIndexTask
Exception in thread "timerFactory" java.lang.NullPointerException
at com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)
at com.microsoft.sqlserver.jdbc.AppDTVImpl.setValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.setValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Parameter.setValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setNull(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$a015e508.setNull(<generated>)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:173)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:88)
at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:771)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:566)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:767)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:825)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:833)
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:237)
at com.jivesoftware.base.database.dao.JiveJdbcOperationsTemplate.update(JiveJdbcOperationsTemplate.java:202)
at com.jivesoftware.community.impl.dao.AvatarDAOImpl.insert(AvatarDAOImpl.java:233)
at com.jivesoftware.community.impl.DbAvatar.insertIntoDb(DbAvatar.java:276)
at com.jivesoftware.community.impl.DbAvatar.<init>(DbAvatar.java:49)
at com.jivesoftware.community.impl.DbAvatarManager.createAvatar(DbAvatarManager.java:60)
at com.jivesoftware.community.action.setup.AvatarInstallTask.run(AvatarInstallTask.java:66)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Can you try with the jTDS jdbc driver instead of using the microsoft driver? I've never had much luck with the MS drivers, especially the older ones.
Regards,
Bruce Ritchie
Bruce,
Thanks for your great suggestion. Using the jTds driver instead of SQL server driver resolved the issues. I do not see any more problems now using with SQL server.
Vinh,
Thanks for trying and helping me on this.
-Sreeni,
Thanks for being so patient, Sreeni.
Vinh
(And thanks for the suggestion, Bruce
)
Vinh,
Is it possible to check the issues with SQL server driver ? we are using SQL server dirver in our product, so we want to use the same driver if possible.
Thanks.
-Sreeni.
I've talked to Bruce about it and it seems the code for Microsoft's JDBC driver leaves a little to be desired. I'm not sure no the specifics, but I think the latest Microsoft JDBC driver is more stable than the older ones, but the jTDS driver is your best choice by far for Clearspace.
Thanks,
Vinh