[Vtigercrm-developers] MySql Crashing (help me)

[Rodrigo Souza]

Hi Adam,

I'm just here to give feedback on the subject, I think the problem was
compatibility between MySQL with Windows itself, because now put the Vtiger
in a virtual machine with Linux and is operating normally.

Thanks for your attention.


Atte,
*Rodrigo Souza de Oliveira*
*Consultor de TI
*Hostplan Informática Ltda
Telefones: (21) 9217-7909 e/ou (21) 8153-5287
website: www.hostplan.com.br
e-mail/msn: rodrigo at hostplan.com.br




2012/6/14 Adam Heinz <amh at metricwise.net>

> On Thu, Jun 14, 2012 at 1:09 PM, Rodrigo Souza <rodrigo at hostplan.com.br>wrote:
>
>> I read that this error may be due to many files being opened
>> simultaneously by Mysql, have any tips to restrict it?
>>
>>
> That is an interesting theory.  I have heard of such a problem happening
> on Linux, where you exhaust the total pool of file descriptors and get an
> error like, "too many open files."  Is it possible you could be seeing
> something similar on Windows?  If so, perhaps you could increase that limit
> in Windows  and make this problem go away?  I think that decreasing the
> limit in Mysql sounds like the wrong thing to do.  Wouldn't that result in
> Mysql constantly opening and closing files to stay under the limit?  I
> imagine that would abuse disk I/O.  I think giving Mysql the resources it
> wants is probably the safer solution.
>
>
>> Another thing that occurred, is that before this error, the access
>> permissions to the vtiger is lost, ie, the price is only seen by the person
>> responsible, and this error occurs before this restriction simply
>> disappears, leaving the prices visible to all . This occurs with all the
>> modules that have this restriction (calendar, sales order, invoice ...)
>>
>>
> This sounds like a symptom to me, not a cause.  I suspect if you fix the
> underlying problem, this will go away.
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20120803/3dcb43fe/attachment.html