[MarkLogic Dev General] Getting connection timeout error when using xqsync

Fri Apr 24 09:13:53 PDT 2009

Ghulam,

It looks like the JVM can't connect to the server via 24.92.152.219 port 
8007. Normally I'd suspect a misconfiguration of the XDBC server, but in 
this case I see that it's a timeout after 45 seconds. So I suspect a 
firewall problem, or some other network connectivity problem. It's also 
possible that you have the wrong IP address for your server.

In any case, this problem is at a lower level than XQSync, and you will 
have to fix it at the OS or network level. You seem to be using some 
flavor of Windows, so I can't help there. Once you can successfully 
connect to your XDBC server via TCP/IP, you can try XQSync again.

thanks,
-- Mike

On 2009-04-24 06:48, Ghulam Baloch wrote:
> Hi guys,
> i was using xqsync to get contents from a data base and putting in a zip package.
>
> here is the command line argument i used.
>
> java -cp xcc.jar;xpp3-1.1.3_8.jar;xstream-1.2.jar;xqsync.jar \
> -DOUTPUT_CONNECTION_STRING=xcc://admin:admin@location:8006\databasename
> -DINPUT_PACKAGE=documents.zip \
> com.marklogic.ps.xqsync.XQSync
>
> this command fails with the following erros.
> i have tried this xcc://admin:admin@location:8006\databasename with out database name at the end as well no matter what i do I'm getting connection timed out erros.
> any help would be reatly appriciated.
> thanks
>
> ghulam baloch
>
> and here is the log message; note i have replaced password
>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.SimpleLogger configureLogger
> INFO: setting up com.marklogic.ps.SimpleLogger at 69b332<mailto:com.marklogic.ps.SimpleLogger at 69b332>  for: com.marklogic.ps<http://com.marklogic.ps>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.XQSync main
> INFO: XQSync starting: version 2009-03-02.1 on 1.6.0_07 (Java(TM) SE Runtime Environment)
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.XQSync main
> INFO: XCC version = 3.2-10
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.SimpleLogger configureLogger
> INFO: setting up com.marklogic.ps.SimpleLogger at 69b332<mailto:com.marklogic.ps.SimpleLogger at 69b332>  for: com.marklogic.ps<http://com.marklogic.ps>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.Configuration setProperties
> INFO: first-time setup
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.SimpleLogger configureLogger
> INFO: setting up com.marklogic.ps.SimpleLogger at 69b332<mailto:com.marklogic.ps.SimpleLogger at 69b332>  for: com.marklogic.ps<http://com.marklogic.ps>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.AbstractConfiguration validateProperties
> INFO: using OUTPUT_PACKAGE=documents.zip
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.AbstractConfiguration validateProperties
> INFO: using INPUT_CONNECTION_STRING=xcc://admin:password@24.92.152.219:8007/ClinicalStudiesDemo<http://admin:password@24.92.152.219:8007/ClinicalStudiesDemo>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.AbstractConfiguration validateProperties
> WARNING: unknown key: skipping awt.toolkit
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.Configuration configureInput
> INFO: input from connection: xcc://admin:password@24.92.152.219:8007/ClinicalStudiesDemo<http://admin:password@24.92.152.219:8007/ClinicalStudiesDemo>
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.Configuration configureOutput
> INFO: output to package: documents.zip
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.XQSync main
> INFO: XQSync starting: version 2009-03-02.1 on 1.6.0_07 (Java(TM) SE Runtime Environment)
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.XQSync main
> INFO: XCC version = 3.2-10
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.XQSyncManager run
> INFO: starting pool of 1 threads, queue size = 100000
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.TaskFactory<init>
> INFO: creating 1 writer(s)
> Apr 24, 2009 9:31:56 AM com.marklogic.ps.xqsync.Monitor run
> INFO: starting
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.SimpleLogger logException
> SEVERE: fatal error
> com.marklogic.xcc.exceptions.ServerConnectionException: Connection timed out: connect
>   [Session: user=admin, cb=ClinicalStudiesDemo [ContentSource: user=admin, cb=ClinicalStudiesDemo [provider: address=/24.92.152.219:8007<http://24.92.152.219:8007>, pool=0/64]]]
>   at com.marklogic.xcc.impl.handlers.AbstractRequestController.runRequest(AbstractRequestController.java:99)
>   at com.marklogic.xcc.impl.SessionImpl.submitRequest(SessionImpl.java:280)
>   at com.marklogic.xcc.impl.CBMetaDataImpl.refreshServerVersion(CBMetaDataImpl.java:168)
>   at com.marklogic.xcc.impl.CBMetaDataImpl.getServerVersionString(CBMetaDataImpl.java:128)
>   at com.marklogic.ps.xqsync.XQSyncManager.run(XQSyncManager.java:177)
>   at com.marklogic.ps.xqsync.XQSync.main(XQSync.java:84)
> Caused by: java.net.ConnectException: Connection timed out: connect
>   at sun.nio.ch.Net.connect(Native Method)
>   at sun.nio.ch.SocketChannelImpl.connect(Unknown Source)
>   at java.nio.channels.SocketChannel.open(Unknown Source)
>   at com.marklogic.xcc.impl.SocketPoolProvider.obtainConnection(SocketPoolProvider.java:64)
>   at com.marklogic.xcc.impl.handlers.AbstractRequestController.runRequest(AbstractRequestController.java:70)
>   ... 5 more
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.xqsync.UriQueue halt
> INFO: halting queue
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.SimpleLogger logException
> SEVERE: halting
> com.marklogic.xcc.exceptions.ServerConnectionException: Connection timed out: connect
>   [Session: user=admin, cb=ClinicalStudiesDemo [ContentSource: user=admin, cb=ClinicalStudiesDemo [provider: address=/24.92.152.219:8007<http://24.92.152.219:8007>, pool=0/64]]]
>   at com.marklogic.xcc.impl.handlers.AbstractRequestController.runRequest(AbstractRequestController.java:99)
>   at com.marklogic.xcc.impl.SessionImpl.submitRequest(SessionImpl.java:280)
>   at com.marklogic.xcc.impl.CBMetaDataImpl.refreshServerVersion(CBMetaDataImpl.java:168)
>   at com.marklogic.xcc.impl.CBMetaDataImpl.getServerVersionString(CBMetaDataImpl.java:128)
>   at com.marklogic.ps.xqsync.XQSyncManager.run(XQSyncManager.java:177)
>   at com.marklogic.ps.xqsync.XQSync.main(XQSync.java:84)
> Caused by: java.net.ConnectException: Connection timed out: connect
>   at sun.nio.ch.Net.connect(Native Method)
>   at sun.nio.ch.SocketChannelImpl.connect(Unknown Source)
>   at java.nio.channels.SocketChannel.open(Unknown Source)
>   at com.marklogic.xcc.impl.SocketPoolProvider.obtainConnection(SocketPoolProvider.java:64)
>   at com.marklogic.xcc.impl.handlers.AbstractRequestController.runRequest(AbstractRequestController.java:70)
>   ... 5 more
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.xqsync.XQSync main
> INFO: completed 0 in 21047 ms (0 docs/s)
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.SimpleLogger logException
> SEVERE: interrupted
> java.lang.InterruptedException
>   at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown Source)
>   at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source)
>   at java.util.concurrent.LinkedBlockingQueue.poll(Unknown Source)
>   at com.marklogic.ps.xqsync.UriQueue.run(UriQueue.java:86)
> Apr 24, 2009 9:32:18 AM com.marklogic.ps.xqsync.Monitor run
> INFO: exiting after 0/0, 0 events/s, 0 kB/s
>