<font><font face="verdana,sans-serif"><div>Hi Adam,</div><div><br></div><div>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.</div>
<div><br></div><div>Thanks for your attention.</div><div><br></div><div><br></div></font></font>Atte,<br><b>Rodrigo Souza de Oliveira</b><div><b>Consultor de TI<br></b>Hostplan Informática Ltda<br><div>Telefones: (21) 9217-7909 e/ou (21) 8153-5287<div>
website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br><img src="http://www.hostplan.com.br/logo.jpg" height="137" width="200"><br>
</div></div></div><br>
<br><br><div class="gmail_quote">2012/6/14 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="gmail_quote"><div class="im">On Thu, Jun 14, 2012 at 1:09 PM, Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><font><font face="verdana,sans-serif">I read that this error may be due to many files being opened simultaneously by Mysql, have any tips to restrict it? </font></font></div><div><font><font face="verdana,sans-serif"><br>
</font></font></div></blockquote><div><br></div></div><div>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.</div>
<div class="im">
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><font><font face="verdana,sans-serif">
</font></font></div><div><font><font face="verdana,sans-serif">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 ...) </font></font></div>
<div><font face="verdana, sans-serif"><br></font></div></blockquote><div><br></div></div><div>This sounds like a symptom to me, not a cause. I suspect if you fix the underlying problem, this will go away. </div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br>