ia64/sqlite problems
David Relson
relson at osagesoftware.com
Mon Jul 4 20:52:34 CEST 2005
On Mon, 04 Jul 2005 20:37:13 +0200
Matthias Andree wrote:
> Matthias Andree <matthias.andree at gmx.de> 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
More information about the bogofilter-dev
mailing list