[Kde-pim] Akonadi and Plasma Active

[Marco Martin]

On Thursday 24 January 2013, Marco Martin wrote:
> On Thursday 24 January 2013, Kevin Krammer wrote:
> > > I guess that from that revision it started to generate queries that
> > > can't be parsed by sqlite?
> > > 
> > > and any idea how and if this can be solved?
> > 
> > It seems SQLite has some limitations when it comes to prepared queries.
> > From the Qt documentation on QSqlQuery::prepare
> > "For SQLite, the query string can contain only one statement at a time.
> > If more than one statements are give, the function returns false."
> > 
> > Could you check if this is the case here? I.e. prepare returning false
> > but false not being handled?
> > 
> > Cheers,
> > Kevin
> 
> mQuery.prepare( statement ); at line 281 of querybuilder.cpp? seems to
> always return true
> 
> 

quite interesting finding:
in querybuilder.cpp, always there

 if ( QueryCache::contains( statement ) ) {
    mQuery = QueryCache::query( statement );
  } else {
    mQuery.prepare( statement );
    QueryCache::insert( statement, mQuery );
  }

if i make the else branch to always execute (ie never using the cache) it's 
still broken.
but, if i disable also QueryCache::insert( statement, mQuery );
so never inserting anything in the cache, all starts to work normally again.
ie even just saving those prepared queries somewhere makes it fail.

another interesting behavior: when is giving those problems, even akonadictl 
stop won't work, leaving all processes hang (will be necessary to kill them 
manually)

disabling the cache completely, it stops everything correctly.

-- 
Marco Martin