[horde] Memory size problem with file manager

[Wolfgang Rauchholz]

  There muust be something I don't uunderstand. I went to the  
configuraiton of Horde and set Virutal File system to 'No'.
I continue getting the error message:
 
  Feb 27 11:20:50 home HORDE: [gollem] SQL QUERY FAILED: Got a packet  
bigger than 'max_allowed_packet' bytes  #012#011INSERT INTO  
`horde_vfs` (`vfs_type`, `vfs_path`, `vfs_name`,#012#011  
 `vfs_modified`, `vfs_owner`, `vfs_data`) VALUES (1,#012#011  
 'home/Administrator', 'Expenses 2017 01.pdf', 1488190850,#012#011  
 'Administrator', '%PDF-1.4 %âãÏÓ 10 0 obj <</Parent 15 0#012#011  
 R/Type/Page/Contents[125 0 R]/Resources<</XObject<</Im1 126 0#012#011  
 R>>/ProcSet[/PDF/ImageC]>>/MediaBox[0 0 578.16 824.40]>> endobj 11  
0#012#011  obj <</Parent 127 0 R/Type/Page/Contents[128 0#012#011  
 R]/Resources<</XObject<</Im1 129 0#012#011  
 R>>/ProcSet[/PDF/ImageC]>>/MediaBox[0 0 578.16 824.40]>> endobj 125  
0#012#011  obj <</Length 45>>stream q 578.16 0 0 824.40 0 0 cm /Im1 Do  
Q#012#011  endstream endobj 126 0 obj#012#011  
 <</Type/XObject/Subtype/Image/ColorSpace/DeviceRGB/Width#012#011  
 1205/BitsPerComponent 8/Length 187191/Height#012#011  
 1718/Filter/DCTDecode>>stream ÿØÿà
  Feb 27 11:20:50 home HORDE: [gollem] SQL QUERY FAILED: MySQL server  
has gone away 

Wolfgang

  Quoting Jan Schneider <jan at horde.org>:

> Zitat von Wolfgang Rauchholz <wp.rauchholz at wo-lar.com>:
>
>> Thank you Hendrik.
>> This solved one of my problems. Thank you.
>>
>> I still get message: A fatal error has occurred QUERY FAILED: MySQL  
>> server has gone away SELECT alarm_id, a.......
>>
>> I looked in the log files and got this error: Feb 25 10:59:31 home  
>> HORDE: [gollem] SQL QUERY FAILED: Got a packet bigger than  
>> 'max_allowed_packet' bytes  #012#011INSERT INTO `horde_vfs`  
>> (`vfs_type`, `vfs_path`, 
>>
>> I successive steps, I set max_allowed_packet=1024M in  
>> /etc/mysql.cnf and restarted the server. Problem still presists.
>
> Don't use a SQL vFS backend.
>
>> Quoting Hendrik Noack <hn at axxedia-it.de>:
>>
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: horde [mailto:horde-bounces at lists.horde.org] Im Auftrag von
>>>> Wolfgang Rauchholz
>>>> Gesendet: Freitag, 24. Februar 2017 16:58
>>>> An: horde at lists.horde.org
>>>> Betreff: [horde] Memory size problem with file manager
>>>>
>>>> I got a problem with the file manager.
>>>>
>>>> When uploading a file (1,1MB) , I get the following message:
>>>> ALLOWED MEMORY SIZE OF 134217728 BYTES EXHAUSTED (TRIED TO
>>>> ALLOCATE
>>>> 101518171 BYTES)
>>>>
>>>> max_allowed_packet is set to 32M and memory_limit in php.ini is set to
>>>> 128M.
>>>
>>> Hi Wolfgang,
>>>
>>> this is pretty straight forward: 134217728 BYTES means exactly 128  
>>> MB of available RAM for php are in use and the system tried to  
>>> reserve 101518171 BYTES = 96.82 MB more. You have to increase your  
>>> memory limit to at least 256 MB, but to be safe I would go for 512  
>>> MB or even 1 G if possible (been at 1 G for  a while, works good  
>>> for me)
>>>
>>>> Any idea what goes worng?
>>>>
>>>> Thank you, Wolfgang
>>>>
>>>> --
>>>> Wolfgang
>>>> --
>>>> Horde mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail:
>>>> horde-unsubscribe at lists.horde.org
>>>
>>> Mit freundlichen Grüßen / Best regards
>>>
>>> Hendrik Noack
>>>
>>> --
>>> Axxedia IT GmbH
>>>
>>> Schwabstr. 30
>>> 71106 Magstadt
>>>
>>> Tel +49 7159 4979763
>>> Fax +49 7159 4979775
>>>
>>> Mail hn at axxedia-it.de
>>>
>>> Sitz der Gesellschaft: Schwabstr. 30, 71106  
>>> MagstadtGeschäftsführer: Hendrik Noack . Amtsgericht: Stuttgart  
>>> HRB 727296
>>
>> --
>> Wolfgang
>
> --
> Jan Schneider
> The Horde Project
> https://www.horde.org/
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,  
> mail: horde-unsubscribe at lists.horde.org
-- 
Wolfgang