Hi Ronald, On 01-12-2006 05:59:24 -0800, Ronald Oussoren wrote:
Hi,
I'm using monetdb's SQL frontend through the python bindings (with minor patches to make it behave more like the DB-API specifies, and a patch to print error information because MonetSQLdb raises 'RuntimeError, None' when the database returns an error).
Can you contribute this patch? If it's nice we might put it in before the release, because it sounds like a fix.
I'm now running into yet another problem: I have an import process that imports large sets of records in a single transaction per dataset. This works fine (after fixing some problems in my code). However, when I perform other transactions during an "import" transactions the import tranaction fails hard even if those transactions only read from the database and only touch tables that aren't touched by the import script.
This sounds like a problem with our FULLY_SERIALIZABLE transaction mode. Whether you like it or not, you probably (indirectly) touch tables that are in common with the running import, hence the last transaction to finish gets aborted.
I'm not at my development machine at the moment, but I'll post an example script and the exact error I'm getting when I'm back.