Re: ia64/sqlite problems

On Mon, 04 Jul 2005 20:37:13 +0200
Matthias Andree wrote:

> Matthias Andree <[email protected]> writes:
> 
> > happens deep in the sqlite3 code, when db_set_dbvalue calls
> > sql_fastpath, which in turn calls sqlite3_stmt. The same machine is fine
> 
> make that   ... which in turn calls sqlite3_step. ...

As a further attempt, I built bogofilter+sqlite3 on sourceforge's
PPC-MacOSX machine, where it seems that 

  sqlite3_exec( .... 'BEGIN EXCLUSIVE TRANSACTION' ...) 

doesn't return.

I'm using a patched version of datastore_sqlite.c for additional debug
info, specifically:

static int sqlexec(sqlite3 *db, const char *cmd) {
    char *e = NULL;
    int rc;

    fprintf(stderr, "%s:%d '%s'\n", __FILE__, __LINE__, cmd);
    rc = sqlite3_exec(db, cmd, NULL, NULL, &e);
    fprintf(stderr, "%s:%d -> %d\n", __FILE__, __LINE__, rc);
    if (rc) {
        print_error(__FILE__, __LINE__,
                "Error executing \"%s\": %s (#%d)\n",
                cmd, e ? e : "NULL", rc);
        if (e)
            sqlite3_free(e);
    }
    return rc;
}

And here's the output of a simple command sequence to create a new wordlist:

+ rm -rf tmp
+ mkdir tmp
+ ./bogofilter -C -D -x d -vvvv -d tmp -n -I tests/inputs/msg.1.txt
SQLite: db_open(tmp/wordlist.db)
datastore_sqlite.c:144 'BEGIN EXCLUSIVE TRANSACTION;'
SQLite[19729]: BEGIN EXCLUSIVE TRANSACTION;

David

CC: sqlite's developer
_______________________________________________
Bogofilter-dev mailing list
[email protected]
http://www.bogofilter.org/mailman/listinfo/bogofilter-dev