Nextcloud Box Issue 1: can not open uploaded JPG files

ℹ️ Support
1
  1. Taken pictures with a Samsung Galaxy S5 and uploaded them, using the PC client (after copying to PC with USB Cable)
  2. Opened NC Box web interface and tried to view the pictures -> some open, some no (error: cannot create preview…).

Now you can download all those pictures and view them. I bought the box to archive the pictures of our growing daughter and share them with friends and relatives. But it simply does not do the job like that. Every third or so picture is not viewable without downloading it first.

Do you need any logs, which show what happens in the background, when trying to open this file?
If so, please instruct me how to get them, I do not know.
I mean, that is why I bought that box, I thought it is zero maintenance.

2

Logs are generally very welcome for issues, we can’t see what’s happening on your system without them :slight_smile:

3

Dear @JasonBayton, I am really willing to provide you with all you need. But I really bought that Nextcloud Box because I do not know deeply what is going on into the system.
Can you please tell me the path of the log files and I will generate them for you asap?

4

Let’s try the simple one first:

Log into Nextcloud > Click your user picture in the top-right > Admin > Logging

5

Error PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) at /snap/nextcloud/863/htdocs/lib/private/legacy/image.php#450 2017-03-08T16:13:51+0200 Error PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) at /snap/nextcloud/863/htdocs/lib/private/legacy/image.php#450 2017-03-08T16:13:40+0200 Error PHP Unknown: send of 5 bytes failed with errno=32 Broken pipe at Unknown#0 2017-03-08T16:13:38+0200 Error PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) at /snap/nextcloud/863/htdocs/lib/private/legacy/image.php#450 2017-03-08T16:13:31+0200 Error core Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECTuid,displaynameFROMoc_usersWHERE LOWER(uid) = LOWER(?)' with params ["oliver"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-03-08T16:13:00+0200 Error core Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECTuid,displaynameFROMoc_usersWHERE LOWER(uid) = LOWER(?)' with params ["oliver"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-03-08T16:13:00+0200 Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECTuid,displaynameFROMoc_usersWHERE LOWER(uid) = LOWER(?)' with params ["oliver"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-03-08T16:13:00+0200 Error PHP Error while sending QUERY packet. PID=9298 at /snap/nextcloud/863/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-03-08T16:12:59+0200 Error remote Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECTid,numeric_id,available,last_checkedFROMoc_storagesWHEREidIN (?)' with params ["local::\/var\/snap\/nextcloud\/common\/nextcloud\/data\/oliver\/"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-03-08T16:12:59+0200 Error PHP PDOStatement::execute(): Error reading result set's header at /snap/nextcloud/863/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-03-08T16:12:59+0200 Error PHP PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/863/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-03-08T16:12:59+0200

6

OK, when seeing those logs, I found this entry on the forum:

I then could resolve most of the error messages with the going away MySQL server.

Now we are down to this error:

Error PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) at /snap/nextcloud/863/htdocs/lib/private/legacy/image.php#450 2017-03-08T16:50:24+0200 Error PHP Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) at /snap/nextcloud/863/htdocs/lib/private/legacy/image.php#450 2017-03-08T16:43:39+0200

This always shows up, when it fails to open the picture in the web interface.

7

And now we are stuck here:

So as of today there is no solution for my problem?

8

Indeed not, it is still not possible to change the allocated memory at this point. There are however improvements coming that we can expect around v.12 and if you don’t have it already, you should install the preview generator app to improve thumbnail generation.

9

Wow, that sucks :slight_smile:
Bought that box for pictures.

App is installed.

10

Ping @oparoz for suggestions.

11

Just read this on the Gallery app:
Important: To enable pre-generation of previews you must add ./occ preview:pre-generate to a system cron job that runs at times of your choosing.

This Nextcloud Box is simply not a finished product. I am a beta tester :-/

12

That’s an app, not the core system. That said the snap install is weirdly inflexible and would benefit dramatically from a better spec board.