Another - although non-trivial - option would be to migrate to another database system, say PostgreSQL. comment:6 Changed 2 years ago by schwa Description modified (diff) comment:7 Changed 2 years ago by schwa I tried running the query SELECT name,value FROM session_attribute WHERE sid='schwa' and authenticated=1; (basically Find a way, at least a workaround, to avoid the errors. Other websites on the same virtual server work fine. useful reference
share|improve this answer answered Jul 3 '12 at 11:34 bruno desthuilliers 22.3k22536 2 And code.google.com/p/modwsgi/wiki/DebuggingTechniques tells you how to raise the log level. –Martijn Pieters♦ Jul 3 '12 at 11:40 How to unlink (remove) the special hardlink "." created for a folder? If you're running your code with apache/mod_wsgi, the simplest solution is to configure your logger(s) to log to sys.stderr using a StreamHandler (cf http://docs.python.org/howto/logging.html#configuring-logging), and define the error log path, name Join them; it only takes a minute: Sign up How to debug/log wsgi python app?
The solved the problem. Requesting ticket reports, especially longer ones. One other thing that might be useful info: Even if there's an "Internal Server Error", the database operation usually succeeds despite the error message (possibly after a database recovery?). I've seen the same for changes in the Trac admin interface, for example adding a new version number.
Why mount doesn't respect option ro Flour shortage in baking How can I remove a scratch from a mirror? I found this error in the "C:\Program Files\BitNami Trac Stack\apache2\logs\error.log" Please Help!!!!! [Tue Mar 12 08:01:01 2013] [warn] [client 10.0.64.76]  auth_ldap authenticate: user ayee authentication failed; URI /svn [LDAP: ldap_simple_bind_s() Can a GM prohibit players from using external reference materials (like PHB) during play? up vote 3 down vote favorite 1 I tried this: #!/usr/bin/python from wsgiref.simple_server import make_server from cgi import parse_qs, escape import logging import os import sys html = """
Even I reboot the server several times but the problem stills. snakez 2013-03-18 14:13:31 UTC #3 Yes I have Trac configured to use LDAP authentication from my primary domain controller. Note: See TracTickets for help on using tickets. Several days ago suddenly start to show problems when you try to login.
Like I recently start to work as systems admin in my current workplace, Trac was already installed and configured by the old systems admin and never explained me how this solution However, I'll first keep an eye on the table to see whether and possibly how fast it will fill up again. This version is supposed to have the "database is locked" problem solved (see http://trac.edgewall.org/ticket/3446). http://www.sqlite.org/lockingv3.html mentions in the section "How To Corrupt Your Database Files" that SQLite uses advisory locking which So I just change the name of the server and reboot the services and responds beautifully.
This virtual machine mount may be a reason for the problems we see. http://renderq.net/internal-server/internal-server-error-500-virtual-server.php comment:5 Changed 2 years ago by schwa About five hours later the number of sessions was about 350. How I backup the configuration or content to import it in the latest one. comment:8 Changed 2 years ago by schwa I just tried an experiment: Stop webserver Make database backup Copy the backup of the old database with the big session/session_attribute tables and without
When inspecting the generated log file my.log after an Internal Server Error, I noticed that the last entry was
Should a spacecraft be launched towards the East? Also consider these: http://wiki.bitnami.com/Native_Installers_Quick_Start_Guide#How_can_I_create_a_full_backup_of_a_Stack.3f http://wiki.bitnami.com/Components/MySQL#How_to_create_a_database_backup.3f Scavokovich 2013-03-19 04:42:22 UTC #6 @Edwin re:backup--why not use the MySQL command line program mysqldump? Actually the query takes about 1 millisecond, both without and with the indexes on session_attribute. logger = logging.getLogger(__name__) request_body = environ['wsgi.input'].read(request_body_size) d = parse_qs(request_body) age = d.get('age', ['']) # Returns the first age value.
After checking http://trac.edgewall.org/wiki/TracDev/DatabaseSchema and making a backup of the database, I stopped the webserver and deleted all rows from session_attribute, session and auth_cookie. Do web searches, again. Visit the Trac open source project athttp://trac.edgewall.com/ Get More Info Next I'm investigating if I can do anything to improve robustness on the SQLite side.
hobbies = d.get('hobbies', ) # Returns a list of hobbies. # Always escape user input to avoid script injection age = escape(age) hobbies = [escape(hobby) for hobby in hobbies] response_body = try: import pysqlite2.dbapi2 as sqlite have_pysqlite = 2 except ImportError: try: import sqlite3 as sqlite have_pysqlite = 2 except ImportError: have_pysqlite = 0 # NEW mylog = open("/var/local/trac/ftputil/log/my.log", "w") if have_pysqlite