sqlite disk I/O problem

Posted by scognito

sqlite disk I/O problem
July 13, 2009 09:34PM

Registered: 15 years ago
Posts: 48

Hi all,
I'm trying to build a sqlite3 helloworld, but I'm having a strange problem.
My helloworld application is built using latest stable libogc and dekitppc rev16.
Compilation goes fine, database is opened ok, but when trying to do a simple select from a table with just one record I get a disk I/O error, and can't find the cause.
I'm using default fat library and sqlite3 lib taken from [wiimp.googlecode.com] and also compiled the source thinking it could be a compatibility problem.
Anyway to make it compile with devkitPPC16 I had to do a quick hack:
comment
int _EXFUN(gettimeofday, (struct timeval *__p, void *__tz));
on
devkitPro\devkitPPC\powerpc-gekko\include\sys\time.h
and adding gettimeofday function you see in the db.c file.
but I don't think the problem can be there (I hope :P).
The example is pretty easy to read, any help is appreciated:

main.c

#include 
#include 
#include 
#include 
#include "db.h"
#include "sqlite3.h"

static void *xfb = NULL;
static GXRModeObj *rmode = NULL;

sqlite3 *db;

//---------------------------------------------------------------------------------
int main(int argc, char **argv) {
//---------------------------------------------------------------------------------
	VIDEO_Init();
	WPAD_Init();
	rmode = VIDEO_GetPreferredMode(NULL);
	xfb = MEM_K0_TO_K1(SYS_AllocateFramebuffer(rmode));
	console_init(xfb,20,20,rmode->fbWidth,rmode->xfbHeight,rmode->fbWidth*VI_DISPLAY_PIX_SZ);
	VIDEO_Configure(rmode);
	VIDEO_SetNextFramebuffer(xfb);
	VIDEO_SetBlack(FALSE);
	VIDEO_Flush();
	VIDEO_WaitVSync();
	if(rmode->viTVMode&VI_NON_INTERLACE) VIDEO_WaitVSync();

	fatInitDefault();
	printf("\x1b[2;0H");
	

	printf("Hello World!");

	DB_Open();
	execQuery("select * from game", db);
	DB_Close();

	while(1) {
		WPAD_ScanPads();
		u32 pressed = WPAD_ButtonsDown(0);
		if ( pressed & WPAD_BUTTON_HOME ) exit(0);
		VIDEO_WaitVSync();
	}

	return 0;
}

db.c

#include "db.h"

extern sqlite3 *db;

//
// HACK
//
// comment int _EXFUN(gettimeofday, (struct timeval *__p, void *__tz));
// in C:\devkitPro\devkitPPC\powerpc-gekko\include\sys\time.h
//
int gettimeofday(struct timeval *tp, struct timezone *tz) {
 
	if (tp != NULL) {
		tp->tv_sec = time(NULL);
		tp->tv_usec = 0;
	}
	if (tz != NULL) {
		tz->tz_minuteswest = 0;
		tz->tz_dsttime = 0;
 
	}
	return 0;
}

int DB_callback(void *NotUsed, int argc, char **argv, char **azColName)
{
	NotUsed=0;
	int i;
	char merlo[255];
	
	for(i=0; i, argv ? argv: "NULL");
 		sprintf(merlo, "%s = %s\n", azColName, argv ? argv: "NULL");
 	}
 
 	//WindowPrompt("OK?", merlo, 0, &okButton);
 	printf("done\n");
 	
 	return 0;
 }
 
 void execQuery(char* command, sqlite3* db)
 {
 	char *zErrMsg = 0;
 	//printf("%s", command);
 	
 	printf("pre\n");
 	int rc = sqlite3_exec(db, command, DB_callback, 0, &zErrMsg);
 		//return;
 	printf("post\n");	
 	if(rc != SQLITE_OK)
 	{
 		//WindowPrompt("execQuery error", zErrMsg, 0, &okButton);
 		printf("execQuery error %s\n", zErrMsg);
         /* This will free zErrMsg if assigned */
 		//if (zErrMsg)
 		//	free(zErrMsg);
 	}
 	else
 		printf("DB QUERY OK\n");
 }
 
 void DB_Open()
 {
 	int rc;
 	
 	rc = sqlite3_open(DB_FILE, &db);
 	
 	if(rc)
 	{
 		printf("cannot open %s\n", (char*)sqlite3_errmsg(db));
 		//WindowPrompt("CANNOT OPEN", (char*)sqlite3_errmsg(db), 0, &okButton);
 		sqlite3_close(db);
 	}
 	else
 		printf("DB OPENED OK\n");
 	//else
 	//	WindowPrompt("OPEN OK", "Database opened!", 0, &okButton);
 }
 
 
 void DB_Close()
 {
 	sqlite3_close(db);
 }

db.h

 #ifndef __DB__
 #define __DB__
 
 #include "sqlite3.h"
 #include "time.h"
 #include <sys/time.h>
#include 
#include 
#include 

#define DB_FILE "sd:/wiitdb.db"

int DB_callback(void *NotUsed, int argc, char **argv, char **azColName);
void execQuery(char* command, sqlite3* db);
int gettimeofday(struct timeval *tp, struct timezone *tz);
void DB_Open();
void DB_Close();

#endif

Makefile is the usual one with these modifications

LIBS	:=	-lfat -lwiiuse -lbte -logc -lm -lsqlite3
LIBDIRS	:= $(CURDIR)/libs/sqlite

The dbfile is very small (20K) and contains few tables with 1 rows each, I'll attach if needed.
The dbfile also is opened and used ok using sqllitebrowser.

The output I get is:

Hello World!DB OPENED OK!
pre
post
execQuery error disk I/O error

Any clue? Maybe DrTwox if you are reading this you can help...
Sorry for big post, and thanks in advance.

Scognito

EDIT: The code works on linux (with the obvious changes) since it is not a problem of how I coded it.

Edited 1 time(s). Last edit at 07/13/2009 10:55PM by scognito.