On Thu, Dec 23, 2010 at 3:49 AM, Brett Spurrier <brett.spurrier@gmail.com> wrote:

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.com> wrote:

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.nl> wrote:

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