请问sqlite3在Solaris平台上建立的db文件为什么不能突破2G?

iceground 发布于 2013/11/22 17:30
阅读 435
收藏 0

请问sqlite3在Solaris平台上建立的db文件为什么不能突破2G?

在Solaris10上应用了sqlite3生成的db文件,但是运行达到2G大小以后就无法读取和写入了,这是怎么回事?有人碰到过类似问题吗?如何解决?db文件用Windows和自行编译的Solaris版本的sqlite3都试过,都是到了2G就出错了,信息如下。求大神帮助,不胜感激。

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)
====================================


以下是问题补充:

@iceground:该系统不存在文件大小限制: bash-3.00# du -hs logs/* 7.0G logs/SilentAlarm.log 25K logs/SilentAlarmError.log 10M logs/systemErr1.txt 4.4M logs/systemErr10.txt 10M logs/systemErr2.txt 10M logs/systemErr3.txt 10M logs/systemErr4.txt 10M logs/systemErr5.txt 10M logs/systemErr6.txt 10M logs/systemErr7.txt 10M logs/systemErr8.txt 10M logs/systemErr9.txt 256K logs/systemOut1.txt bash-3.00# ls -lt database/* -rw-r--r-- 1 root root 1544 Nov 25 15:25 database/silentalarm.db-journal -rw-r--r-- 1 root root 2147483648 Nov 25 15:25 database/silentalarm.db bash-3.00# ulimit -a core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files (-n) 8192 pipe size (512 bytes, -p) 10 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 29995 virtual memory (kbytes, -v) unlimited bash-3.00# (2013/11/25 10:12)
加载中
返回顶部
顶部