Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIV


#1

Running 13.12 on CentOS 6.4 (Used tar build/install to 5 node cluster. All regressions passed)
Installed shimsvc from RPMs for (R Integration).
Using R-Studio (Web UI) 0.98.501

Getting the following error in R-Studio…
[color=#0000FF]> scidbconnect(host=“10.211.25.111”, port=“8082”, “ds_dsidlo”, “…”)[/color]
[color=#FF0000]Error in function (type, msg, asError = TRUE) : SSL connect error[/color]

[scidb@prdslsldsafht01 scidb-13.12.0.6872]$ cat /var/lib/shim/conf

Shim configuration file

Uncomment and change any of the following values. Restart shim for

your changes to take effect (default values are shown).

auth=login
ports=8082,8083s
scidbport=1239
tmp=/dev/shm/
user=root

Testing via wget….
wget -q --no-check-certificate -O - "https://prdslsldsafht01:8083/login?username=ds_dsidlo&password=…"
6397335672253439741
wget -q --no-check-certificate -O - "https://prdslsldsafht01:8083/new_session?auth=6397335672253439741"
10
wget -q --no-check-certificate -O - “https://prdslsldsafht01:8083/execute_query?id=10&query=list(‘functions’)&save=dcsv&auth=6397335672253439741

Results…
tail -f /var/log/messages
[color=#0000FF]Mar 30 13:56:16 prdslsldsafht01 shim: new_session session id=10 ibuf=/dev/shm//scidb_input_buf_AeusiI obuf=/dev/shm//scidb_output_buf_JvKc86
Mar 30 13:56:32 prdslsldsafht01 shim: (SSL) /execute_query?id=10&query=list(‘functions’)&save=dcsv&auth=6397335672253439741
Mar 30 13:56:32 prdslsldsafht01 shim: execute_query for session id 10
Mar 30 13:56:32 prdslsldsafht01 shim: execute_query s->con = 0x7ff0000056e0 save(list(‘functions’),’/dev/shm//scidb_output_buf_JvKc86’,0,‘dcsv’)
Mar 30 13:56:32 prdslsldsafht01 shim: execute_query connected
Mar 30 13:56:32 prdslsldsafht01 shim: execute_query scidb queryid = 1100907897168
Mar 30 13:56:32 prdslsldsafht01 abrt[29478]: abrtd is not running. If it crashed, /proc/sys/kernel/core_pattern contains a stale value, consider resetting it to ‘core’[/color]
[color=#FF0000]Mar 30 13:56:32 prdslsldsafht01 shim: execute_prepared_query error SystemException in file: src/network/BaseConnection.h function: receive line: 294#012Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIVE#012Error description: Network error. Cannot send or re.[/color]
[color=#0000FF]Mar 30 13:56:32 prdslsldsafht01 shim: cleanup_session releasing 10
Mar 30 13:56:32 prdslsldsafht01 shim: cleanup_session unlinking /dev/shm//scidb_output_buf_JvKc86[/color]

Also, on tailing scidb.log and the first instance…
It seems like the instance restarts.
Any idea what’s going on here?

[color=#0000BF]2014-03-30 14:09:49,577 [0x7fb5185f1700] [DEBUG]: Inferred schema for operator save: not empty functionsname:string,profile:string,deterministic:bool,library:string [No=0:227,228,0]
2014-03-30 14:09:49,577 [0x7fb5185f1700] [DEBUG]: The query is prepared
2014-03-30 14:09:49,577 [0x7fb5185f1700] [DEBUG]: Prepared query(1100907997965): save(list(‘functions’),’/dev/shm//scidb_output_buf_fZOjZm’,0,‘dcsv’)
2014-03-30 14:09:49,577 [0x7fb5185f1700] [DEBUG]: The result preparation of query is sent to the client
2014-03-30 14:09:49,586 [0x7fb519449840] [INFO ]: [/color][color=#008000]Start [/color][color=#0000BF]SciDB instance (pid=30379). SciDB Version: 13.12.6872. Build Type: Debug. Copyright © 2008-2013 SciDB, Inc.
2014-03-30 14:09:49,586 [0x7fb519449840] [INFO ]: Configuration:
precision : 6
catalog : host=10.211.25.111 port=5432 dbname=mydb user=mydb password=mydb[/color]

Thanks.


#2

Sometimes when your network is not stable,it will give this.you can restart the scidb with scidb.py stopall [dbame] and scidb.py startall [dbname],and check the network ,and if that doesn’t work,you can restart the operating system.and that will be ok.


#3

Thanks for the reply fate_testarossa.

But, I can’t imagine that its the network.
I have other services that use the network and work fine.
Also, queries via iquery on an off the control server don’t cause the error.
The only activity that causes the error is when scidbconnect() is run from R.
It is not flakey, sometimes working sometime not working, it just alway fails.

I’ll take a look at the difference in messaging between iquery and shimsvc via tcpdump.
Maybe there’s a difference there that is significant.


#4

Trying to debug the shimsvc…

Using the http:// port so that I can read text over tcpdump…

1) Get a session id…
[MYFAMILY\dsidlo@prdslsldsafht05 ~]$ wget -q -O - ‘http://prdslsldsafht01:8082/new_session

2) Execute a simple function…
wget ‘http://prdslsldsafht01:8082/execute_query?id=7&query=select * from list(“arrays”)’

--2014-03-30 23:56:34-- http://prdslsldsafht01:8082/execute_query?id=7&query=select%20*%20from%20list(%22arrays%22) Resolving prdslsldsafht01... 10.211.25.111 Connecting to prdslsldsafht01|10.211.25.111|:8082... connected. HTTP request sent, awaiting response... 500 ERROR 2014-03-30 23:56:34 ERROR 500: ERROR.

tcpdump from 2) above…

==> Incomming Request...
23:56:34.284048 IP prdslsldsafht05.myfamilysouth.com.35759 > prdslsldsafht01.myfamilysouth.com.us-cli: Flags [P.], seq 1:182, ack 1, win 115, options [nop,nop,TS val 3359956403 ecr 4002533785], length 181
        0x0000:  047d 7bae 337c 047d 7ba5 6a34 0800 4500  .}{.3|.}{.j4..E.
        0x0010:  00e9 b0dc 4000 4006 40ab 0ad3 1973 0ad3  ....@.@.@....s..
        0x0020:  196f 8baf 1f92 3456 6d6a 8976 5dc8 8018  .o....4Vmj.v]...
        0x0030:  0073 f715 0000 0101 080a c844 ddb3 ee91  .s.........D....
        0x0040:  d199 4745 5420 2f65 7865 6375 7465 5f71  ..GET./execute_q
        0x0050:  7565 7279 3f69 643d 3726 7175 6572 793d  uery?id=7&query=
        0x0060:  7365 6c65 6374 2532 302a 2532 3066 726f  select%20*%20fro
        0x0070:  6d25 3230 6c69 7374 2825 3232 6172 7261  m%20list(%22arra
        0x0080:  7973 2532 3229 2048 5454 502f 312e 300d  ys%22).HTTP/1.0.
        0x0090:  0a55 7365 722d 4167 656e 743a 2057 6765  .User-Agent:.Wge
        0x00a0:  742f 312e 3132 2028 6c69 6e75 782d 676e  t/1.12.(linux-gn
        0x00b0:  7529 0d0a 4163 6365 7074 3a20 2a2f 2a0d  u)..Accept:.*/*.
        0x00c0:  0a48 6f73 743a 2070 7264 736c 736c 6473  .Host:.prdslslds
        0x00d0:  6166 6874 3031 3a38 3038 320d 0a43 6f6e  afht01:8082..Con
        0x00e0:  6e65 6374 696f 6e3a 204b 6565 702d 416c  nection:.Keep-Al
        0x00f0:  6976 650d 0a0d 0a                        ive....
23:56:34.284055 IP prdslsldsafht01.myfamilysouth.com.us-cli > prdslsldsafht05.myfamilysouth.com.35759: Flags [.], ack 182, win 122, options [nop,nop,TS val 4002533785 ecr 3359956403], length 0
        0x0000:  047d 7ba5 6a34 047d 7bae 337c 0800 4500  .}{.j4.}{.3|..E.
        0x0010:  0034 8c51 4000 4006 65eb 0ad3 196f 0ad3  .4.Q@.@.e....o..
        0x0020:  1973 1f92 8baf 8976 5dc8 3456 6e1f 8010  .s.....v].4Vn...
        0x0030:  007a 92a1 0000 0101 080a ee91 d199 c844  .z.............D
        0x0040:  ddb3                                     ..

==> Response...
23:56:34.286866 IP prdslsldsafht01.myfamilysouth.com.us-cli > prdslsldsafht05.myfamilysouth.com.35759: Flags [P.], seq 1:69, ack 182, win 122, options [nop,nop,TS val 4002533788 ecr 3359956403], length 68
        0x0000:  047d 7ba5 6a34 047d 7bae 337c 0800 4500  .}{.j4.}{.3|..E.
        0x0010:  0078 8c52 4000 4006 65a6 0ad3 196f 0ad3  .x.R@.@.e....o..
        0x0020:  1973 1f92 8baf 8976 5dc8 3456 6e1f 8018  .s.....v].4Vn...
        0x0030:  007a 48f2 0000 0101 080a ee91 d19c c844  .zH............D
        0x0040:  ddb3 4854 5450 2f31 2e30 2035 3030 2045  ..HTTP/1.0.500.E
        0x0050:  5252 4f52 0d0a 436f 6e74 656e 742d 4c65  RROR..Content-Le
        0x0060:  6e67 7468 3a20 3334 310d 0a43 6f6e 7465  ngth:.341..Conte
        0x0070:  6e74 2d54 7970 653a 2074 6578 742f 6874  nt-Type:.text/ht
        0x0080:  6d6c 0d0a 0d0a                           ml....
23:56:34.286940 IP prdslsldsafht01.myfamilysouth.com.us-cli > prdslsldsafht05.myfamilysouth.com.35759: Flags [FP.], seq 69:410, ack 182, win 122, options [nop,nop,TS val 4002533788 ecr 3359956403], length 341
        0x0000:  047d 7ba5 6a34 047d 7bae 337c 0800 4500  .}{.j4.}{.3|..E.
        0x0010:  0189 8c53 4000 4006 6494 0ad3 196f 0ad3  ...S@.@.d....o..
        0x0020:  1973 1f92 8baf 8976 5e0c 3456 6e1f 8019  .s.....v^.4Vn...
        0x0030:  007a 4a03 0000 0101 080a ee91 d19c c844  .zJ............D
        0x0040:  ddb3 5573 6572 5175 6572 7945 7863 6570  ..UserQueryExcep
        0x0050:  7469 6f6e 2069 6e20 6669 6c65 3a20 7372  tion.in.file:.sr
        0x0060:  632f 7175 6572 792f 7061 7273 6572 2f51  c/query/parser/Q
        0x0070:  7565 7279 5061 7273 6572 2e63 7070 2066  ueryParser.cpp.f
        0x0080:  756e 6374 696f 6e3a 2070 6172 7365 206c  unction:.parse.l
        0x0090:  696e 653a 2038 320a 4572 726f 7220 6964  ine:.82.Error.id
        0x00a0:  3a20 7363 6964 623a 3a53 4349 4442 5f53  :.scidb::SCIDB_S
        0x00b0:  455f 5041 5253 4552 3a3a 5343 4944 425f  E_PARSER::SCIDB_
        0x00c0:  4c45 5f51 5545 5259 5f50 4152 5349 4e47  LE_QUERY_PARSING
        0x00d0:  5f45 5252 4f52 0a45 7272 6f72 2064 6573  _ERROR.Error.des
        0x00e0:  6372 6970 7469 6f6e 3a20 4572 726f 7220  cription:.Error.
        0x00f0:  6475 7269 6e67 2071 7565 7279 2070 6172  during.query.par
        0x0100:  7369 6e67 2e20 5175 6572 7920 7061 7273  sing..Query.pars
        0x0110:  6572 2066 6169 6c65 6420 7769 7468 2065  er.failed.with.e
        0x0120:  7272 6f72 2027 7379 6e74 ...

I Tried to capture packets coming from an R-Studio session, but there was no data hitting port 8082 from the following R function…
[color=#0040FF]scidbconnect(host=“prdslsldsafht01”, port=8082L)[/color]
[color=#FF0000]Error in scidbquery(query = “setopt(‘precision’,‘16’)”, release = 1, resp = TRUE) :
SystemException in file: src/network/BaseConnection.h function: receive line: 294
Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIVE[/color]

R-Studio runs on prdslsldsafht02 and shim is running on the controller host prdslsldsafht01.
So it does not look like the scidbconnect() function is getting packets out the the appropriate shim host/port.
I also get the same results when I use IP addresses instead of host names.

Any ideas? Anything else I should look at?


#5

The following is a Tcpdump of what happens at the shim.
Where we are connecting…
> scidbconnect(host=“10.211.25.111”, port=“8082”)
[color=#BF0000]Error in scidbquery(query = “setopt(‘precision’,‘16’)”, release = 1, resp = TRUE) :
SystemException in file: src/network/BaseConnection.h function: receive line: 294
Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIVE
Error description: Network error. Cannot send or receive network messages.[/color]

[code]

00:42:49.478560 IP prdslsldsafht02.myfamilysouth.com.52974 > prdslsldsafht01.myfamilysouth.com.us-cli: Flags [P.], seq 1:131, ack 1, win 115, options [nop,nop,TS val 4005312157 ecr 4005308979], length 130
0x0000: 047d 7bae 337c 089e 015a 2986 0800 4500 .}{.3|…Z)…E.
0x0010: 00b6 a1c8 4000 4006 4ff5 0ad3 1970 0ad3 …@.@.O…p…
0x0020: 196f ceee 1f92 b38e 975c f87e 87c4 8018 .o…~…
0x0030: 0073 c006 0000 0101 080a eebc 369d eebc .s…6…
0x0040: 2a33 4745 5420 2f2f 6578 6563 7574 655f 3GET.//execute_
0x0050: 7175 6572 793f 6964 3d32 3326 7265 6c65 query?id=23&rele
0x0060: 6173 653d 3126 7361 7665 3d26 7175 6572 ase=1&save=&quer
0x0070: 793d 7365 746f 7074 2827 7072 6563 6973 y=setopt(‘precis
0x0080: 696f 6e27 2c27 3136 2729 2661 666c 3d31 ion’,‘16’)&afl=1
0x0090: 2048 5454 502f 312e 310d 0a48 6f73 743a .HTTP/1.1…Host:
0x00a0: 2031 302e 3231 312e 3235 2e31 3131 3a38 .10.211.25.111:8
0x00b0: 3038 320d 0a41 6363 6570 743a 202a 2f2a 082…Accept:.
/*
0x00c0: 0d0a 0d0a …
00:42:49.478570 IP prdslsldsafht01.myfamilysouth.com.us-cli > prdslsldsafht02.myfamilysouth.com.52974: Flags [.], ack 131, win 122, options [nop,nop,TS val 4005308980 ecr 4005312157], length 0
0x0000: 089e 015a 2986 047d 7bae 337c 0800 4500 …Z)…}{.3|…E.
0x0010: 0034 adf0 4000 4006 444f 0ad3 196f 0ad3 .4…@.@.DO…o…
0x0020: 1970 1f92 ceee f87e 87c4 b38e 97de 8010 .p…~…
0x0030: 007a 3542 0000 0101 080a eebc 2a34 eebc .z5B…*4…
0x0040: 369d 6.

==> ERROR…
00:42:49.487588 IP prdslsldsafht01.myfamilysouth.com.us-cli > prdslsldsafht02.myfamilysouth.com.52974: Flags [P.], seq 1:69, ack 131, win 122, options [nop,nop,TS val 4005308989 ecr 4005312157], length 68
0x0000: 089e 015a 2986 047d 7bae 337c 0800 4500 …Z)…}{.3|…E.
0x0010: 0078 adf1 4000 4006 440a 0ad3 196f 0ad3 .x…@.@.D…o…
0x0020: 1970 1f92 ceee f87e 87c4 b38e 97de 8018 .p…~…
0x0030: 007a 48ef 0000 0101 080a eebc 2a3d eebc .zH…*=…
0x0040: 369d 4854 5450 2f31 2e30 2035 3030 2045 6.HTTP/1.0.500.E
0x0050: 5252 4f52 0d0a 436f 6e74 656e 742d 4c65 RROR…Content-Le
0x0060: 6e67 7468 3a20 3231 380d 0a43 6f6e 7465 ngth:.218…Conte
0x0070: 6e74 2d54 7970 653a 2074 6578 742f 6874 nt-Type:.text/ht
0x0080: 6d6c 0d0a 0d0a ml…[/code]

Getting an error.


#6

Here’s what I get from /var/log/messages when I connect to the Shim web ui…
[color=#0000FF]Mar 31 12:24:38 prdslsldsafht01 shim: new_session 0
Mar 31 12:24:38 prdslsldsafht01 shim: new_session session id=11 ibuf=/dev/shm//shim_input_buf_Jxn14m obuf=/dev/shm//shim_output_buf_xWbvGq
Mar 31 12:24:38 prdslsldsafht01 shim: /execute_query?id=11&query=list(%27instances%27)&save=dcsv&auth=null&=1396290278269
Mar 31 12:24:38 prdslsldsafht01 shim: execute_query for session id 11
Mar 31 12:24:38 prdslsldsafht01 shim: execute_query s->con = 0x7f369c004de0 save(list(‘instances’),’/dev/shm//shim_output_buf_xWbvGq’,0,‘dcsv’)
Mar 31 12:24:38 prdslsldsafht01 shim: execute_query connected
Mar 31 12:24:38 prdslsldsafht01 shim: execute_query scidb queryid = 1100907998054
Mar 31 12:24:38 prdslsldsafht01 abrt[23201]: abrtd is not running. If it crashed, /proc/sys/kernel/core_pattern contains a stale value, consider resetting it to 'core’
Mar 31 12:24:38 prdslsldsafht01 shim: execute_prepared_query error SystemException in file: src/network/BaseConnection.h function: receive line: 294#012Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIVE#012Error description: Network error. Cannot send or receive.
Mar 31 12:24:38 prdslsldsafht01 shim: cleanup_session releasing 11
Mar 31 12:24:38 prdslsldsafht01 shim: cleanup_session unlinking /dev/shm//shim_output_buf_xWbvGq
Mar 31 12:24:38 prdslsldsafht01 shim: /release_session?id=11&auth=null&
=1396290278337
Mar 31 12:24:38 prdslsldsafht01 shim: release_session[/color]

Could there be something wrong with writing output to /dev/shm?
Permissions?


#7

Compiled shim for source.
But, still getting a restart from the SciDB instance that shim communicates with (instance 0).

When I run save(list(‘instances’),’/dev/shm//shim_output_buf_xWbvGq’,0,‘dcsv’); in “iquery -a”, it works fine.
But, via Shim, the command seems to crash the instance that Shim is attached to.


#8

It’s going to take me a while to diagnose this, but note that in your 1st post you’re using a different (non-ssl) port in your R code than in your wget example. That’s what led to the SSL error in that case (authentication is only supported on SSL/TLS ports).


#9

Yes, my prior examples may be incorrect.
It took a while to understand how to hit the ports with the appropriate parameters.
It seems that SSL is assumed as soon as user/password is added to the scidbconnect() parameters.
Actually, this may be a function of what parameters are posted to the Shim service.

Thanks.


#10

The shim API is documented here:

htmlpreview.github.io/?https://r … t/api.html

in particular: “The shim API uses PAM-based authentication for most API functions over SSL connections.”

The SciDB crashing problem is something else, though. I can’t replicate it, and I haven’t seen this before.

Can you issue iquery-based queries on the machine SciDB is installed on successfully? Something like:

iquery -aq “list(‘functions’)”

for example?

You might also try changing the shim I/O directory from /dev/shm/ to /tmp. If shim is running as a service, you can edit the /var/lib/shim/conf file and set option:

/tmp=/tmp

or some other directory writable by SciDB.


#11

Hmmm. I don’t think the shim I/O directory setting is the problem. I intentionally set it to a place not writable by SciDB and I get a more graceful error report. I can’t figure out why SciDB is crashing on you.


#12

iquery works fine…
iquery -aq "list(‘functions’)"
and returns a list of 227 functions.

I changed tmp=/tmp, but still get an error in the server…
[color=#FF0000]Apr 1 23:13:27 prdslsldsafht01 shim: new_session 0
Apr 1 23:13:27 prdslsldsafht01 shim: new_session session id=1 ibuf=/tmp/shim_input_buf_Mm5oDk obuf=/tmp/shim_output_buf_25UQZz
Apr 1 23:13:27 prdslsldsafht01 shim: /execute_query?id=1&query=list(%27instances%27)&save=dcsv&auth=null&=1396415607843
Apr 1 23:13:27 prdslsldsafht01 shim: execute_query for session id 1
Apr 1 23:13:27 prdslsldsafht01 shim: execute_query s->con = 0x7fea10004de0 save(list(‘instances’),’/tmp/shim_output_buf_25UQZz’,0,‘dcsv’)
Apr 1 23:13:27 prdslsldsafht01 shim: execute_query connected
Apr 1 23:13:27 prdslsldsafht01 shim: execute_query scidb queryid = 1100908143383
Apr 1 23:13:27 prdslsldsafht01 abrt[462]: Unrecognized variable ‘OpenGPGCheck’ in '/etc/abrt/abrt.conf’
Apr 1 23:13:27 prdslsldsafht01 abrt[462]: abrtd is not running. If it crashed, /proc/sys/kernel/core_pattern contains a stale value, consider resetting it to 'core’
Apr 1 23:13:27 prdslsldsafht01 shim: execute_prepared_query error SystemException in file: src/network/BaseConnection.h function: receive line: 294#012Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CANT_SEND_RECEIVE#012Error description: Network error. Cannot send or receive netwo.
Apr 1 23:13:27 prdslsldsafht01 shim: cleanup_session releasing 1
Apr 1 23:13:27 prdslsldsafht01 shim: cleanup_session unlinking /tmp/shim_output_buf_25UQZz
Apr 1 23:13:28 prdslsldsafht01 shim: /release_session?id=1&auth=null&
=1396415608003
Apr 1 23:13:28 prdslsldsafht01 shim: release_session[/color]

The commands the the web ui sends to scidb don’t fail in iquery…
[root@prdslsldsafht01 shim]# iquery -aq “save(list(‘instances’),’/tmp/shim_output_buf_25UQZz’,0,‘dcsv’)”
{No} name,port,instance_id,online_since,instance_path
{0} ‘10.211.25.111’,1239,0,‘2014-04-02 05:13:28’,’/ogfs/scidb-001/mydb-DB/000/0’
{1} ‘10.211.25.111’,1240,1,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/000/1’
{2} ‘10.211.25.112’,1240,2,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/001/1’
{3} ‘10.211.25.112’,1241,3,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/001/2’
{4} ‘10.211.25.113’,1240,4,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/002/1’
{5} ‘10.211.25.113’,1241,5,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/002/2’
{6} ‘10.211.25.114’,1240,6,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/003/1’
{7} ‘10.211.25.114’,1241,7,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/003/2’
{8} ‘10.211.25.115’,1240,8,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/004/1’
{9} ‘10.211.25.115’,1241,9,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/004/2’
[root@prdslsldsafht01 shim]# cat /tmp/shim_output_buf_25UQZz
{No} name,port,instance_id,online_since,instance_path
{0} ‘10.211.25.111’,1239,0,‘2014-04-02 05:13:28’,’/ogfs/scidb-001/mydb-DB/000/0’
{1} ‘10.211.25.111’,1240,1,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/000/1’
{2} ‘10.211.25.112’,1240,2,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/001/1’
{3} ‘10.211.25.112’,1241,3,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/001/2’
{4} ‘10.211.25.113’,1240,4,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/002/1’
{5} ‘10.211.25.113’,1241,5,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/002/2’
{6} ‘10.211.25.114’,1240,6,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/003/1’
{7} ‘10.211.25.114’,1241,7,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/003/2’
{8} ‘10.211.25.115’,1240,8,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/004/1’
{9} ‘10.211.25.115’,1241,9,‘2014-03-29 21:55:39’,’/ogfs/scidb-001/mydb-DB/004/2’


#13

Would data from the Trace logs be of help?
Is it possible for me to turn on log4j TRACE mode?


#14

Yes, the logging configuration is normally found in

/opt/scidb/<SCIDB_VERSION>/share/scidb/log4cxx.properties

(although this can be redirected in the scidb config.ini file to another location).

I’m sorry you’re running in to this. I’m thinking about adding some simple command-line driven shim tests to help diagnose this problem. It’s really odd that we’re getting past prepare query and failing at execute query…