Hi, everyone,
I meet some issue when use the sqlite on Solaris 10. The db file is made by the
sqlite R3.4.2 version and the sqlite3 is compiled on Solaris 10 platform (has
attached). When the db file meet 2147483648 bytes (2Gigabytes), the file size
can not increase anymore, and query/write also error. When query or write the
data, the exception as below. Who know the solution of this issue and can share
me, thanks very much.
bash-3.00# more /etc/release
Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC
Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
Assembled 11 August 2010
bash-3.00# ls -lt database/
total 4196372
-rw-r--r-- 1 root root 1544 Nov 23 14:54 silentalarm.db-journal
-rw-r--r-- 1 root root 2147483648 Nov 23 14:54 silentalarm.db
====================================
2013-11-23 14:55:41 -
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such
table: tasks)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sqlite.DB.newSQLException(DB.java:387)
at org.sqlite.DB.throwex(DB.java:374)
at org.sqlite.NestedDB.prepare(NestedDB.java:134)
at org.sqlite.DB.prepare(DB.java:123)
at org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
at org.sqlite.Conn.prepareStatement(Conn.java:404)
at org.sqlite.Conn.prepareStatement(Conn.java:399)
at org.sqlite.Conn.prepareStatement(Conn.java:383)
at
com.utstar.silentalarm3.server.database.impl.TaskDataImpl.getAllTasks(TaskDataImpl.java:456)
at
com.utstar.silentalarm3.server.database.impl.TaskDataImpl.getTaskByNameAndStatus(TaskDataImpl.java:347)
at
com.utstar.silentalarm3.common.impl.TaskOperationImpl.getTaskByNameAndStatus(TaskOperationImpl.java:86)
at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown
Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
====================================
Regards,
Liang Kunming.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
