I think it's easy - don't use database sessions. I've never seen it work properly with anything more than a trivial site. The massive amount of activity quickly brings the database down.
Installing and upgrading help
The session partition is full, Moodle 2.9
This discussion has been locked so you can no longer reply to it.