Looks like the log file didn't attach. Here it is. -Brett
On Thu, Dec 23, 2010 at 3:48 AM, Brett Spurrier brett.spurrier@gmail.comwrote:
Hi Stefan and Fabian,
I'll try to answer both of you here. (By the way, I really appreciate your help).
I am using "MonetDB server v5.22.3 (64-bit), based on kernel v1.40.3 (64-bit oids)" on my Mac OSX 10.6.
The DB schema looks as follows: Columns
title VARCHAR(200) guid VARCHAR(50) D0 FLOAT D1 FLOAT ... D63 FLOAT
An example INSERT statement looks as follows: INSERT INTO imagesignatures VALUES ('BK-2000000105000.png', '9e5a1c52-6dd7-4b29-8c88-db1a67b73b6e', 0.0012992, -0.00648533, 0.0160408, 0.0194895, -0.00426406, -0.00972571, 0.0160934, 0.0273353, 0.0011832, -0.00841318, 0.00864345, 0.0160668, -0.000174525, -0.0103183, 0.0114333, 0.0213318, -0.0123529, 0.117436, 0.0747747, 0.169459, 0.00168713, 0.237856, 0.196901, 0.293636, -0.00689568, 0.172451, 0.144271, 0.207795, 0.00808731, 0.0852854, 0.0685582, 0.251899, 0.0527458, -0.00125575, 0.108289, 0.100469, -0.0694842, 0.0841492, 0.32303, 0.199593, -0.0168043, -0.00444074, 0.423218, 0.137524, -0.0467394, 0.00776669, 0.151014, 0.19008, 0.0505521, 0.00327318, 0.0949606, 0.125157, -0.0277652, -0.0367558, 0.108567, 0.11868, -0.0942212, -0.000443912, 0.189012, 0.177837, 0.0256825, -0.0204917, 0.112957, 0.111767);
I have attached the LOG file (merovingian.log). I'm not sure what I am looking for in there, but there doesn't seem to be any major errors sticking out.
Any thoughts? The set up is "out of the box" as is.
Thanks a million, Brett
On Thu, Dec 23, 2010 at 3:10 AM, Fabian Groffen Fabian.Groffen@cwi.nlwrote:
On 23-12-2010 03:04:37 -0500, Brett Spurrier wrote:
No, I don't get any distinguishable messages from the server. However, I
am
using merovingian, so everything is in the background. The merovingian
log
file however, is empty.
I guess you mean it doesn't show anything special for you. This log should always contain some chattering about when connections are being made and more.
Any other thoughts? At a loss here.
You may hit a stack limit, and get disconnected without warning. How does INSERT_INTO_STATEMENT look like?
MapiHdl query(Mapi dbh, char *q) { MapiHdl ret = NULL; if ((ret = mapi_query(dbh, q)) == NULL || mapi_error(dbh) != MOK) die(dbh, ret); return(ret); }
void update(Mapi dbh, char *q) { MapiHdl ret = query(dbh, q); if (mapi_close_handle(ret) != MOK) die(dbh, ret); }
void main() { dbh = mapi_connect("localhost", 50000, "monetdb", "monetdb", "sql", "dbname"); if (mapi_error(dbh)) { die(dbh, hdl); }
for (int i=0; i< 2500; i++) { char *p = INSERT_INTO_STATEMENT; update(dbh, p); }}
Does anyone see any reason that the MAPI would choke mid way through the
For
loop?
Any help would be majorly appreciated. I am at a loss.
Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users