android - Want to know database behavior when Maximum cache size is exceeded -

-

after extensive use of email database (there more 1000 mails), email app crashed. if come app again mails started deleting automatically.

the error logs obtained below:

e/androidruntime(  417): java.lang.outofmemoryerror e/androidruntime(  417):    @ java.lang.string.<init>(string.java:468) e/androidruntime(  417):    @ java.lang.abstractstringbuilder.tostring(abstractstringbuilder.java:659) e/androidruntime(  417):    @ java.lang.stringbuilder.tostring(stringbuilder.java:664) e/androidruntime(  417):    @ com.android.email.mail.transport.discourselogger.addreceivinglinetobuffer(discourselogger.java:57) e/androidruntime(  417):    @ com.android.email.mail.transport.discourselogger.addreceivedbyte(discourselogger.java:70) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.readbyte(imapresponseparser.java:71) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.expect(imapresponseparser.java:332) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.parsetoken(imapresponseparser.java:199) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.readtoken(imapresponseparser.java:165) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.readtokens(imapresponseparser.java:141) e/androidruntime(  417):    @ com.android.email.mail.store.imapresponseparser.readresponse(imapresponseparser.java:92) e/androidruntime(  417):    @ com.android.email.mail.store.imapstore$imapconnection.readresponse(imapstore.java:1491) e/androidruntime(  417):    @ com.android.email.mail.store.imapstore$imapfolder.fetchinternal(imapstore.java:887) e/androidruntime(  417):    @ com.android.email.mail.store.imapstore$imapfolder.fetch(imapstore.java:810) e/androidruntime(  417):    @ com.android.email.messagingcontroller.synchronizemailboxgeneric(messagingcontroller.java:898) e/androidruntime(  417):    @ com.android.email.messagingcontroller.synchronizemailboxsynchronous(messagingcontroller.java:396) e/androidruntime(  417):    @ com.android.email.messagingcontroller.access$2(messagingcontroller.java:384) e/androidruntime(  417):    @ com.android.email.messagingcontroller$2.run(messagingcontroller.java:372) e/androidruntime(  417):    @ com.android.email.messagingcontroller.run(messagingcontroller.java:171) e/androidruntime(  417):    @ java.lang.thread.run(thread.java:1096)

w/database( 497): reached max size compiled-sql statement cache database /data/data/com.android.email/databases/emailprovider.db; i.e., no space sql statement in cache: select _id attachment messagekey=996. please change sql statements use '?' bindargs, instead of using actual values

i want know behavior above error.

i mean android if maximum cache size exceeded? if tell implementation done, helpful.

this issue. message says all: "reached max size compiled-sql statement cache database"

basically emaill application using hardcoded values in queries. instead should use prepared statements in order cache prepared statements.

hope helps.


Comments

Post a Comment

Popular posts from this blog

ruby - When to use an ORM (Sequel, Datamapper, AR, etc.) vs. pure SQL for querying -

-
a colleague of mine designing sql queries 1 below produce reports, displayed in excel files through external data query. @ present, reporting processes on db required (no crud operations). i trying convince him better use ruby orm in order able display data in rails/sinatra app. despite obvious advantages in displaying data, advantages there him in learning use orm sequel or datamapper? the sql queries writing quite complex, , being relatively new sql, complains time-consuming , confusing. possible write extremely complex queries orm? , if so, suitable(i have heard sequel legacy dbs)? , advantages of learning ruby , using orm versus sticking plain sql, in making complex database queries? i'm datamapper maintainer, , think complex reporting should use sql. while think someday we'll have dsl provides power , conciseness of sql, i've seen far requires write more ruby code sql complex queries. rather maintain 5 line sql query 10-15 lines of ruby code desc...
Read more

php - PHPDoc: @return void necessary? -

-
is necessary this: /** * ... * * @return void */ i have quite few methods don't have return value, , seems redundant put in comment. considered bad form leave out? if makes clear documentation, leave in, isn't strictly necessary. it's entirely subjective decision. personally, leave out. edit stand corrected. after little googling, wikipedia page says: @return [type description] tag should not used constructors or methods defined void return type. the phpdoc.org website says: @return datatype description @return datatype1|datatype2 description the @return tag used document return value of functions or methods. @returns alias @return support tag formats of other automatic documentors the datatype should valid php type (int, string, bool, etc), class name type of object returned, or "mixed". if want explicitly show multiple possible return types, list them pipe-delimited without spaces (e.g. "@retur...
Read more

c++ - Convert big endian to little endian when reading from a binary file -

-
this question has answer here: how convert between big-endian , little-endian values in c++? 28 answers i've been looking around how convert big-endian little-endians. didn't find solve problem. seem there's many way can conversion. anyway following code works ok in big-endian system. how should write conversion function work on little-endian system well? this homework, since systems @ school running big-endian system. it's got curious , wanted make work on home computer also #include <iostream> #include <fstream> using namespace std; int main() { ifstream file; file.open("file.bin", ios::in | ios::binary); if(!file) cerr << "not able read" << endl; else { cout << "opened" << endl; int i_var; double d_var; while(!file.eof()) {...
Read more