Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`
-
All,
I keep having this issue when uploading files to my newly installed NextCloud instance.
I have tried all of the fixes I could find online and still have no success.
Here is the error that I am getting and it is occurring with a lot of files. Obviously, I have modified the log to remove any personal information (mainly just file names).
7/30/2018 8:22:41 PM, first-part-of-path/e00/d00/e00009c8.au, Nextcloud,Error transferring nextcloud_server/e00/d00/e00009c8.au - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO
oc_file_locks(key,lock,ttl) SELECT ?,?,? FROMoc_file_locksWHEREkey= ? HAVING COUNT(*) = 0' with params ["files/3b33f6717fb598e9c795ae575b379005", 1, 1533000159, "files/3b33f6717fb598e9c795ae575b379005"]:SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
I can not figure out for the life of me what is wrong. I have attempted to switch to the other methods of Memcache. I attempted to stop my apache server and clear out the oc_file_lock table among other things that I found to try online.
All still result in having this issue.
Any help is appreciated! it is driving me nuts!
-Xylems
-
Just to make sure -- are NextCloud and MySQL on the same box?
-
Yes they are
-
Destroy it and start over. This is very abnormal.
-
@jaredbusch Not really a solution to the problem.
This was already a fresh installation. I also verified the download as well.
-
@xylems said in Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`:
@jaredbusch Not really a solution to the problem.
This was already a fresh installation. I also verified the download as well.
You are getting an error that I have never had and I have installed many of these.
You could easily have done something wrong unintentionally. Reinstalling is by far the best thing to do for a new install with weird unknown issues.
-
@xylems He means you installed it wrong, and that you wont be able to fix it.
I agree.
If you want the easy way to make this get the Ubuntu 1804 server iso and choose Nextcloud at the end. It will install nextcloud for you.
https://www.ubuntu.com/download/server
Or follow @JaredBusch guide verbatim. -
Don't be afraid of having to reinstall. Nextcloud makes it easy to keep use settings and data.
-
@travisdh1 said in Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`:
Don't be afraid of having to reinstall. Nextcloud makes it easy to keep use settings and data.
He has none yet anyway.
-
@momurda said in Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`:
If you want the easy way to make this get the Ubuntu 1804 server iso and choose Nextcloud at the end. It will install nextcloud for you.
Is it a snap app version?
-
@black3dynamite Dunno its the screen at the end similar to other distros where you can choose to install different desktops, ssh, cups, etc. Nextcloud is a choice now in ubuntu
-
@momurda said in Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`:
@xylems He means you installed it wrong, and that you wont be able to fix it.
I agree.
If you want the easy way to make this get the Ubuntu 1804 server iso and choose Nextcloud at the end. It will install nextcloud for you.
https://www.ubuntu.com/download/server
Or follow @JaredBusch guide verbatim.It's included now? Very nice.
-
@momurda said in Nextcloud: An exception occurred while executing 'INSERT INTO `oc_file_locks`:
@black3dynamite Dunno its the screen at the end similar to other distros where you can choose to install different desktops, ssh, cups, etc. Nextcloud is a choice now in ubuntu
Just confirm it. Nextcloud is installed via snap. The rest apps like PowerShell is from using snap.
-
@black3dynamite Yes i just did install nc and powershell from this iso, it is from snaps.
It does seem to work as i have this now at server ip
-
I am running this on Fedora and Ubuntu is not really an option as I have other items hosted on this server.
I did install it via the Snap package. Update though, once the initial upload of files finished it seems that it went back and got the files it missed due to the exception. I restarted the service (which I did try prior to posting) and the errors no longer showed up. Only ignored files show and other files that I know previously had an issue uploading did upload.
Strange that the issue just went away though.
