issues when using pycassa with uwsgi

Question

We are using pycassa with uwsgi. There are about 16 uwsgi processes.

It is strange that one process can get the data which is queried by another process. e.g. there is one row in column family A, looks like:

{row_key, {'column_a': 1, 'column_b': 2}}

process 1 run: get(row_key, columns=['column_a', ])

process 2 run: get(row_key, columns=['column_b', ])

but, sometimes, process 1 got value of column_b, process 2 got value of column_a.

Is this a known issue of connection pool?

Any response is appreciated.

score 2 · Accepted Answer · edited Apr 17 '12 at 07:08

2

Open a connection for every worker using the uwsgi.post_fork_hook api function

import uwsgi

def myconnect(...):

global_connection = ...

uwsgi.post_fork_hook = myconnect

edited Apr 17 '12 at 07:08

sra

answered Mar 30 '11 at 12:36

roberto

>>> import uwsgi Traceback (most recent call last): File "", line 1, in ImportError: No module named uwsgi Is uwsgi module for python needed? – Zhongwei Sun Mar 30 '11 at 13:15
when you run an app under uwsgi it get access to the uwsgi module. – roberto Mar 30 '11 at 15:06
And I add a judgement, "if not global_connection: global_connection = ..." in case a worker is restarted. – Zhongwei Sun Mar 30 '11 at 17:49

1 Answers1