ia64/sqlite problems

[David Relson]

On Mon, 04 Jul 2005 21:30:17 +0200
Matthias Andree wrote:

> David Relson <relson at osagesoftware.com> writes:
> 
> > 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've tried to build sqlite 3.2.2 for Solaris 8/sparc64 but shelved the
> task since I don't have a sparc64 enabled Tcl.

I, too, encountered the lack of Tcl, but the sqlite build seemed to
continue without it.

> > 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;
> > }
> 
> Well, MacOS X is for later. Let's get it to work on the real Unixen
> first, before looking into systems that are further off from the
> mainstream.

I'm not truly concerned about MacOSX, but since the only PPC machine at
sourceforge is running it, I thought something might be learned.  I
didn't learn what I wanted, but I did learn something.

As far as I'm concerned, sqlite is on hold until we hear from its
developer.

David