Comments (6)
For me it worked using:
tran.ExecuteAsync("UPDATE Settlement SET Completed = 1 WHERE DamagedObjectId = ?", settlement.DamagedObjectId);
from sqlite-net.
I also get this issue on Metro using sqlite3.dll (3.7.13)
from sqlite-net.
For those hitting this can you try one of the options below and see if it helps?
Adding this code right after opening the database produces the expected
result:
verifySQLResult(SQLite3.Execute(_db, "PRAGMA temp_store = memory;", 0, 0, 0));
Alternatively, the following code could be used (also right after opening the
database):
var TempPath = Windows.Storage.ApplicationData.Current.TemporaryFolder.Path;
verifySQLResult(SQLite3.Execute(_db, string.Format(
"PRAGMA temp_store_directory = '{0}';", TempPath), 0, 0, 0));
from sqlite-net.
As already said, try using executeAsync() instead of execute().
Tim Heuer [email protected] schrieb:
For those hitting this can you try one of the options below and see if it helps?
Adding this code right after opening the database produces the expected
result:
verifySQLResult(SQLite3.Execute(_db, "PRAGMA temp_store = memory;", 0, 0, 0));
Alternatively, the following code could be used (also right after opening the
database):
var TempPath = Windows.Storage.ApplicationData.Current.TemporaryFolder.Path;
verifySQLResult(SQLite3.Execute(_db, string.Format(
"PRAGMA temp_store_directory = '{0}';", TempPath), 0, 0, 0));
—
Reply to this email directly or view it on GitHubhttps://github.com//issues/78#issuecomment-7985751.
from sqlite-net.
Kornelis - I'm just trying to determine/help with perhaps a more fundamental issue with WinRT app usage and SQLite (and specifically those using this lib as well). If the temp_store works it will help continue to isolate (and perhaps change something we need in SQLite to expose an export for this option)
from sqlite-net.
Tim, you are right. If I add either
Execute("PRAGMA temp_store = memory;");
or
var TempPath = Windows.Storage.ApplicationData.Current.TemporaryFolder.Path;
Execute(String.Format("PRAGMA temp_store_directory = '{0}';", TempPath));
to the SQLiteConnection
constructor right after the call to SQLite3.Open
I get the expected behavior - the issue doesn't occur any more.
Kornelis, while your workaround avoids this issue, it's generally not a good idea to call SQLiteAsyncConnection
methods inside RunInTransactionAsync
. As I described in issue #73 this can result in a deadlock when the call ends up running in a different thread. It happened to me in application code. That's way I marked SQLiteAsyncConnection.RunInTransactionAsync(Action<SQLiteAsyncConnection>)
as obsolete and added the override accepting Action<SQLiteConnection>
instead.
from sqlite-net.
Related Issues (20)
- Insert large data (over 2GB) occurs OverflowException, how to solve it?
- SQLite version and how to upgrade it HOT 1
- Query with Where() returns no results, fails only with UWP release build
- Support for ORDER BY CASE WHEN? HOT 1
- SQLiteAsyncConnection Support for REGEXP
- LINQ Where() Does Not Work Well With Enums Decorated With the StoreAsTextAttribute
- Problem with .NET MAUI Blazor SQL app
- Debug local iphone result in file is not a database HOT 1
- Android 10 release version results in file is not a database error HOT 1
- Cannot get SQL for: Subtract
- e_sqlite3.dll not included in single file output with Native AOT compilation HOT 2
- Exception: Library e_sqlite3 not found, is seen when application is run in x64 or AnyCPU.
- "Where" clause doesn't work with bool when record is migrated until the record is updated
- e_sqlite.dll is created but not showing an error when using it.
- Using sqlite-net-base with SQLitePCLRaw.provider.winsqlite3 HOT 2
- The UniqueAttribute is not used in the DDL
- Using versions that support standard .net in an old .NET 4.X project doesn't work
- ExecuteAsync and RunInTransactionAsync are not safe together. HOT 1
- Mixing Connection-Types? (async and sync connections on same database)
- DllNotFoundException
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlite-net.