It's not working...
1- I tried pool_size with n = 2, 3, 6;
2- apache with prefork
I just need to restart apache once a time when de database is created.
It's really strange... but works...
2013/11/12 Michele Comitini <michele.comit...@gmail.com>
> Seem a threading issue.
> Try :
> 1) pass a pool_size=n option with different values of n
> 2) use preforking instead of threading in apache configuration
>
>
>
>
> 2013/11/12 Diogo Munaro <diogo.mvie...@gmail.com>
>
>> Yes, thanks Michele!
>>
>> Omg, I was using web2py with apache. With the same code and using rocket
>> server no errors occurs and the databases was created.
>>
>> I configured apache with web2py script. Someone knows whats happen?
>>
>> Anyway, now I can configure database with rocket than manage with apache.
>> It's working now!
>>
>> I think some index makes apache/mysql crazy and returned this error:
>>
>>
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>>
>>
>>
>> Traceback (most recent call last):
>> File "/var/www/sistema/gluon/main.py", line 550, in wsgibase
>>
>>
>>
>>
>> BaseAdapter.close_all_instances('rollback')
>> File "/var/www/sistema/gluon/dal.py", line 558, in close_all_instances
>>
>>
>>
>>
>> db._adapter.close(action)
>> File "/var/www/sistema/gluon/dal.py", line 538, in close
>>
>>
>>
>>
>> getattr(self, action)()
>> File "/var/www/sistema/gluon/dal.py", line 1789, in rollback
>>
>>
>>
>>
>> return self.connection.rollback()
>> ProgrammingError: (2014, "Commands out of sync; you can't run this command
>> now")
>>
>> Thanks Michele, if I have some news I'll post here. I'll try using
>> commits at each index creation.
>>
>> Em 12/11/2013 07:33, "Michele Comitini" <michele.comit...@gmail.com>
>> escreveu:
>>
>> The error you sent seems to point to some statement that has not been
>>> properly closed. The commit/rollback happens in the middle of an open
>>> statement? That is what mysql seems to say. The problem could be earlier
>>> than when the error raises.
>>>
>>> Hard to say where. You could try to force db.commit/rollback in
>>> different places to see where you start see errors.
>>>
>>>
>>>
>>> 2013/11/12 Diogo Munaro <diogo.mvie...@gmail.com>
>>>
>>>> The error continues, but without index :(
>>>>
>>>> The indexes are successful created
>>>>
>>>>
>>>> 2013/11/11 Michele Comitini <michele.comit...@gmail.com>
>>>>
>>>>> What happens if you remove the index creation inside the try/except
>>>>> block?
>>>>>
>>>>>
>>>>> 2013/11/11 Diogo Munaro <diogo.mvie...@gmail.com>
>>>>>
>>>>>> It's not a simple function, but putting the model definition inside
>>>>>> the function.
>>>>>>
>>>>>> Here the code: http://pastebin.com/rN7gvAT8
>>>>>>
>>>>>> Attached the error ticket
>>>>>>
>>>>>>
>>>>>> Em segunda-feira, 11 de novembro de 2013 08h34min44s UTC-2, Michele
>>>>>> Comitini escreveu:
>>>>>>
>>>>>>> If you define a function like
>>>>>>> def f():
>>>>>>> pass
>>>>>>>
>>>>>>> in a model, you should have no problems.
>>>>>>> Just show us an extract of code that causes the problem, without
>>>>>>> violating any reserved information or IP.
>>>>>>> That way we can help you...
>>>>>>>
>>>>>>> mic
>>>>>>>
>>>>>>>
>>>>>>> Il giorno lunedì 11 novembre 2013 10:43:49 UTC+1, Diogo Munaro ha
>>>>>>> scritto:
>>>>>>>>
>>>>>>>> Hi guys, first the problem:
>>>>>>>>
>>>>>>>> I need some databases with identical structure, but with different
>>>>>>>> data. These databases must be stored with the clients because they want
>>>>>>>> (different locations), but the auth system is unique.
>>>>>>>>
>>>>>>>> So, my structure by now is: a centralized auth system and some
>>>>>>>> disyributed databases. The centralized system controls access to other
>>>>>>>> databases.
>>>>>>>>
>>>>>>>> Teoricaly web2py works great with it, because I defined a function
>>>>>>>> that I pass connection string, access control db and its made a lot of
>>>>>>>> databases replicas with foreign keys to access control database.
>>>>>>>>
>>>>>>>> Without the function it works great, but with, it make a complete
>>>>>>>> first client database and then crash all of web2py. It returns a ciclic
>>>>>>>> ticket error when I try access any application of that web2py, either
>>>>>>>> Welcome application.
>>>>>>>>
>>>>>>>> Im using web2py 2.7.4 with mysql on ubuntu. So, whats happening? I
>>>>>>>> cant define model with function. Oh, my function is in the same model
>>>>>>>> file.
>>>>>>>>
>>>>>>>> BR, Diogo
>>>>>>>>
>>>>>>> --
>>>>>> Resources:
>>>>>> - http://web2py.com
>>>>>> - http://web2py.com/book (Documentation)
>>>>>> - http://github.com/web2py/web2py (Source code)
>>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "web2py-users" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to web2py+unsubscr...@googlegroups.com.
>>>>>>
>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>
>>>>>
>>>>> --
>>>>> Resources:
>>>>> - http://web2py.com
>>>>> - http://web2py.com/book (Documentation)
>>>>> - http://github.com/web2py/web2py (Source code)
>>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>>> ---
>>>>> You received this message because you are subscribed to a topic in the
>>>>> Google Groups "web2py-users" group.
>>>>> To unsubscribe from this topic, visit
>>>>> https://groups.google.com/d/topic/web2py/_OnWZGMqkE0/unsubscribe.
>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>> web2py+unsubscr...@googlegroups.com.
>>>>>
>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>
>>>>
>>>> --
>>>> Resources:
>>>> - http://web2py.com
>>>> - http://web2py.com/book (Documentation)
>>>> - http://github.com/web2py/web2py (Source code)
>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "web2py-users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to web2py+unsubscr...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/_OnWZGMqkE0/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/_OnWZGMqkE0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
