asked 4 years ago viewed 8030 times active 4 years ago Blog Stack Overflow Podcast #91 - Can You Stump Nick Craver? 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 Get them now! Other websites on the same virtual server work fine. http://colvertgroup.com/internal-server/internal-server-error-trac-login.php
This virtual machine mount may be a reason for the problems we see. However, I'll first keep an eye on the table to see whether and possibly how fast it will fill up again. After enabling logging for the Trac instance, I got 2014-06-09 11:34:40,322 Trac[env] ERROR: Exception caught while checking for upgrade: Traceback (most recent call last): File "/usr/lib/python2.6/dist-packages/trac/env.py", line 664, in open_environment needs_upgrade So after a lot of search into the installation folder C:\Program Files\BitNami Trac Stack\apache2\conf over "httpd.conf" file I found several lines of LDAP configuration pointing to my old domain controller. weblink
Why mount doesn't respect option ro Flour shortage in baking How can I remove a scratch from a mirror? Even if the operation succeeds, the messages are annoying for all affected users, including me. comment:5 Changed 2 years ago by schwa About five hours later the number of sessions was about 350. How to unlink (remove) the special hardlink "." created for a folder?
If all else fails, try going back to basic cgi deployment. (As it turned out, it was a database issue, so changing the deployment method wouldn't have helped. A "query" for the indixes gives sqlite> .schema session CREATE TABLE session ( sid text, authenticated integer, last_visit integer, UNIQUE (sid,authenticated) ); CREATE INDEX session_authenticated_idx ON session (authenticated); CREATE INDEX session_last_visit_idx Since the ftputil website is hosted on a "virtual root" server, I have no control over how the file system visible from inside the environment is mounted. check over here 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.
Ideas: Check all log files, again. Another - although non-trivial - option would be to migrate to another database system, say PostgreSQL. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Can a GM prohibit players from using external reference materials (like PHB) during play?
Why does Mal change his mind? http://stackoverflow.com/questions/28351886/apache-wsgi-trac-random-http-500-internal-server-error Scavokovich 2013-03-18 19:53:44 UTC #5 @Edwin: I presume you can log-in to the machine, stop the servers and create a tarball (or WinZip .zip file) with the full "/opt/bitnami" folder (or Should a spacecraft be launched towards the East? Join them; it only takes a minute: Sign up How to debug/log wsgi python app?
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() useful reference 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. Linked 0 Apache + WSGI + Trac: Random HTTP 500 Internal Server Error Related 2725How do I check whether a file exists using Python?1Debug/Monitor middleware for python wsgi applications127How Python web Scavokovich 2013-03-18 19:50:04 UTC #4 @victor and/or @Beltran: re: @Edwin's new question--FYI there's no mention of backing-up Trac on its Wiki page: http://wiki.bitnami.com/Applications/BitNami_Trac So it's either Really Simple To Do or
Last edited 2 years ago by schwa (previous) (diff) comment:2 Changed 2 years ago by schwa By the way, from my experience the following actions cause "Internal Server Error"s relatively often: Find a way, at least a workaround, to avoid the errors. My question is, seems like this is an old version that I could update it to the latest one. my review here Often the operation actually succeeded despite the error message, but sometimes not.
The funny thing here is that I haven't touch or configured any LDAP configuration over the new domain controller "Windows server 2008R2". Is it legal to bring board games (made of wood) to Australia? Browse other questions tagged python debugging logging wsgi or ask your own question.
I just added indices for the above-mentioned query to session_attribute: sqlite> create index session_attribute_sid_idx on session_attribute (sid); sqlite> create index session_attribute_authenticated_idx on session_attribute (authenticated); For what it's worth, I discovered that Not the answer you're looking for? The timeout is still used up, and 40 seconds is too long anyway. Any answer will be highly appreciated.
When inspecting the generated log file my.log after an Internal Server Error, I noticed that the last entry was
What could make an area of land be accessible only at certain times of the year? 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 And/or use phpMyAdmin to create a backup of the database. 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
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? Several days ago suddenly start to show problems when you try to login. It was just coincidence that made it seem that the situation had gotten this bad because of the switch to FastCGI.) Change History comment:1 Changed 2 years ago by schwa In I'm trying to display/log the value on webpage or in a file /var/log/apache2/myapp.log What's the best way to do this?
Child process is ending. [Tue Mar 12 08:09:05 2013] [notice] Child 2376: Released the start mutex [Tue Mar 12 08:09:06 2013] [notice] Child 2376: All worker threads have exited. [Tue Mar Even I reboot the server several times but the problem stills. I quickly went into the server to check if the services were running and restart both services "Apache and TracSubversion" but didn't resolve the issue. 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
I can see a warning in the log that it can not access to the LDAP server. 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?). Requesting ticket reports, especially longer ones. I can get through the internet browser to the main project site but after hit the login option and I entered my user credential never progress and stop showing a "Internal
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 = I discovered that the login error problem begun exactly when I demote my old primary domain controller. Check new/updated deployment documentation for Trac.
Download in other formats: Comma-delimited Text Tab-delimited Text RSS Feed Powered by Trac 0.12.5 By Edgewall Software.