Hi Ken,
 
 Thanks for your Reply ! 
 
 I am not able to run it on my PPC Architecture with this ISSUE i.e. "
BFOS:root> ./sqlite3 bhanu.db
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> .databases
seq  name             file
---  ---------------
----------------------------------------------------------
0    main             /root/bhanu.db
sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
SQL error: database or disk is full

 
I will Summarize on How i am using SQLITE:
 
1. Cross Compiled SQLITE3.5.7 for PPC Architecture
2. Copied all the dependent libraries and the executable to my PPC
machine
3. Exported LD_LIBRAY_PATH to the working directory where I copied the
libraries
4. Created db I.e. ./sqlite3 my.db
5. Started Executing SQLITE QUERIES.
 
I could see in the code:
** If the journal file could not be written because the disk is full,
** then this routine returns SQLITE_FULL and does an immediate rollback.
** All subsequent write attempts also return SQLITE_FULL until there
** is a call to sqlite3PagerCommit() or sqlite3PagerRollback() to
** reset.
*/

 
Can I know where/HOW  the Journal file is being written so that i can
check on my switch whether I have 
sufficient write privileges enabled for journal file.
 
Moreover I am using ext3 tinyfilesystem ....somewhat similar to busybox
file system !
 
Attached are the Makefile and libtoo which I have modified for CROSS
COMPILATION RULES;
 
Can you please point out if I need to Include/exclude some Flags/Rules
if I compile it for a different Architecture!
 
If you have used SQLITE for PPC or any please help me with some pointers
to resolve these issues !
 
Thanks in Advance
Bhanu  

________________________________

From: Ken [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 26, 2008 9:54 PM
To: BanuPrakash G
Subject: RE: [sqlite] SQL error: SQL logic error or missing database


maybe a ulimit on the file size??
Have you check you systems log files (linux: /var/log/messages)

HTH,
Ken


BanuPrakash G <[EMAIL PROTECTED]> wrote: 

        yes i have write permissions ! 
        
        
        
        -----Original Message-----
        From: [EMAIL PROTECTED]
        [mailto:[EMAIL PROTECTED] On Behalf Of Ken
        Sent: Wednesday, March 26, 2008 7:55 PM
        To: General Discussion of SQLite Database
        Subject: Re: [sqlite] SQL error: SQL logic error or missing
database
        
        do you have write permissions on mdiadb and the directory???
        
        BanuPrakash G wrote: Database or disk is full is
        the Error message i get from the sqlite 
        
        :root> ./sqlite3 mediadb.sql
        SQLite version 3.5.7
        Enter ".help" for instructions
        sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
        SQL error: database or disk is full
        
        sqlite> BFOS:root> df
        Filesystem 1k-blocks Used Available Use% Mounted on
        /dev/root 495016 190848 278616 41% /
        /dev/hda1 494984 141452 327984 30% /mnt
        :root> 
        
        
        ????
        
        -----Original Message-----
        From: [EMAIL PROTECTED]
        [mailto:[EMAIL PROTECTED] On Behalf Of
BanuPrakash G
        Sent: Wednesday, March 26, 2008 12:19 PM
        To: General Discussion of SQLite Database
        Subject: Re: [sqlite] SQL error: SQL logic error or missing
database
        
        Even create a database i.e. ./sqlite mydb.db3 
        
        when i attemt to execute any command i.e. create tables,insert
etc i see
        the ERROR Message SQL error: SQL logic error or missing
database.
        
        I think because of some library dependency this issue is being
observed
        ...any pointers ??
        
        
        Thanks
        /BP 
        
        -----Original Message-----
        From: [EMAIL PROTECTED]
        [mailto:[EMAIL PROTECTED] On Behalf Of Prabowo
Murti
        Sent: Tuesday, March 25, 2008 9:18 PM
        To: General Discussion of SQLite Database
        Subject: Re: [sqlite] SQL error: SQL logic error or missing
database
        
        BanuPrakash G wrote:
        > Hi,
        >
        > I have used the latest verision of sqlite i.e. sqlite-3.5.7 
        > Amalgamation release for PPC Arch.
        >
        > I was able to cross compile it successfull and when i use the
db to 
        > create tables I see on the SQLITE shell the ERROR message as
"SQL
        > error: SQL logic error or missing database".
        >
        > i.e.
        >
        > ./sqlite3
        > SQLite version 3.5.7
        > Enter ".help" for instructions
        > sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
        > SQL error: SQL logic error or missing database
        >
        >
        >
        > Can anybody point me out where exactly I am wrong ?
        >
        >
        > Thanks
        > /BP
        >
        > 
        >
        > _______________________________________________
        > sqlite-users mailing list
        > sqlite-users@sqlite.org
        > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
        >
        > 
        Hi
        You have to create a database first. Create a table before a
database is
        like build a window without house :) I am using sqlite3 on
Ubuntu.
        
        $ sqlite3 mydb.db3
        
        I am new in sqlite. Cmiiw.
        _______________________________________________
        sqlite-users mailing list
        sqlite-users@sqlite.org
        http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
        _______________________________________________
        sqlite-users mailing list
        sqlite-users@sqlite.org
        http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
        _______________________________________________
        sqlite-users mailing list
        sqlite-users@sqlite.org
        http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
        
        _______________________________________________
        sqlite-users mailing list
        sqlite-users@sqlite.org
        http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
        


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to