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
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