I'm running web2py in production and I use a Redis server to store a couple 
of millons sessions, but I'm facing a memory problem that I haven't been 
able to fix.

I use session_expiry=172800 (two days). The application load is very stable 
(it handles about 60 requests per second). I thought that after a few weeks 
running I would know how much memory I need for Redis. However the memory 
used by Redis keeps increasing indefinitely.

I don't use sessions for anything more than a very small percentage of 
users that can login and do some administrative tasks. The vast majority of 
users can't login. 

Just in case, I checked and every key in redis has an expiration time:
$ redis-cli info keyspace
# Keyspace
db0:keys=1549547,expires=1548249,avg_ttl=89380135

I've also checked a few session keys and I saw that a session ocuppies 
about 250 bytes. However, the memory used by Redis grows slowly and 
constantly: in a whole year it reached the 24 gigabytes of RAM that the 
server has, which is insane, right? 

I had Redis configured to limit the amount of RAM it can use:
maxmemory 20gb
maxmemory-policy volatile-lru

However, as I commented before, after a whole year it reached that limit, 
and my app started throwing this error:

Traceback (most recent call last): File "/var/www/medios/gluon/main.py", 
line 462, in wsgibase session._try_store_in_db(request, response) File 
"/var/www/medios/gluon/globals.py", line 1226, in _try_store_in_db 
record_id = table.insert(**dd) File 
"/var/www/medios/gluon/contrib/redis_session.py", line 138, in insert newid 
= str(self.db.r_server.incr(self.serial)) File 
"/var/www/medios/venv_medios/lib/python2.7/site-packages/redis/client.py", 
line 651, in incr return self.execute_command('INCRBY', name, amount) File 
"/var/www/medios/venv_medios/lib/python2.7/site-packages/redis/client.py", 
line 394, in execute_command return self.parse_response(connection, 
command_name, **options) File 
"/var/www/medios/venv_medios/lib/python2.7/site-packages/redis/client.py", 
line 404, in parse_response response = connection.read_response() File 
"/var/www/medios/venv_medios/lib/python2.7/site-packages/redis/connection.py", 
line 316, in read_response raise response ResponseError: OOM command not 
allowed when used memory > 'maxmemory'.


I thought that error was impossible giving that Redis has a maxmemory limit 
and it is instructed to evict keys when the limit is reached. However I 
realised that these types of scenarios (lot of keys being written and also 
lot of keys being deleted) can lead to memory fragmentation. And redis has 
a defragmentation option, so I made some changes.

I reduced the maxmemory Redis limit and activated the auto defragmentation:
maxmemory 1gb
maxmemory-policy volatile-lru
activedefrag yes

Redis auto defragmentation works like a charm: when it wasn't active I 
could see that the mem_fragmentation_ratio was slowly increasing. After 
activating it, it stayed in a stable and optimal value of 1.05.

After a week running (remember all the sessions expire in two days) Redis 
was using about 600mb of RAM. But the usage kept growing and reached the 
maxmemory limit a few days later. 
At that point, I could verify that Redis started evicting keys to make 
space (that was expected accordingly to the configuration). 
However a few days later my apps again started to throw the error with the 
exact same traceback I posted before :/

What could be happening? I'm pretty sure that I don't need more than 1 or 
2gb of RAM for handling the sessions with Redis. So why does it crash? 
Could it be a memory leak in gluon/contrib/redis_session.py adapter?

One thing: I've never run sessions2trash.py
But if I understand the documentation 
<http://web2py.com/books/default/chapter/29/13?search=cache#Sessions-in-Redis> 
right, I don't need to run it as I set an expiration time for every session.

Let me know what you think, any help will be much appreciated.
Thanks!
Warm regards,
Lisandro

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/9775cb12-e932-4223-aedd-f1fd5feae1f6n%40googlegroups.com.

Reply via email to