Hey Michele!
Now it's working... The indexes are crashing web2py on apache.
With a list of indexes I can execute sql in a for:
for i in indices:
try:
db.executesql(i)
except:pass
Thx for all help!
2013/11/12 Diogo Munaro <diogo.mvie...@gmail.com>
> 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.
