Owncloud 10.0.3 error when sharing: "cannot commit transaction - SQL Statements in progress

help

#1

Hi,

I am running Owncloud 10.0.3 on a QNAP TS453A (Celeron N3160, 1.6 GHz, Firmware 4.3.4.0370, 8 GB RAM)
Owncloud mostly behaves as expected: I can sync Calendars and Contacts. I can upload & download documents – but I am not able to create a share.
When I try to do so, I get the error:
SQLSTATE[HY000]: General error: 1 cannot commit transaction - SQL statements in progress
and no share is created.

As getting Owncloud 10.0.1 to run on the TS453A was quite a challenge to me (I am a beginning Linuxer), I think I must have overlooked something during installation.

Operating system: QTS 4.3 (QNAP’s Linux distro)

Status:
installed true
maintenance false
needsDbUpgrade false
version 10.0.3.3
versionstring 10.0.3
edition Community
productname ownCloud
Web server: Apache
Database: MariaDB 5.5.57
PHP version: 5

Does anyone have an idea what went wrong here?
Thanks in advance, P


#2

Hi,

Have you tried setting your transaction isolation level in your database?

https://doc.owncloud.com/server/10.0/admin_manual/configuration/database/linux_database_configuration.html#mysql-mariadb-read-commited-transaction-isolation-level


#3

Thanks, dmitry - I'll give it a try.