286948 - public talkback server gives database errors when processing queries

Status: VERIFIED FIXED

(mozilla.org :: Talkback Server & Webtool, task)

Description

[Marc Bejarano]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050225 Firefox/1.0.1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050225 Firefox/1.0.1

currently, when i attempt any queries as http://talkback-public.mozilla.org , i
get errors like:

DB Error processing query: SELECT d.bbid from blackboxes_by_deployment d,
fc__keytable_1048 s WHERE lower(s.keyvalue) LIKE '%:%' AND d.bbid = s.bbid AND
d.dttm_created BETWEEN to_date('03 20 2005 11 24 00', 'MM DD YYYY HH24 MI SS')
AND to_date('03 20 2005 11 31 00', 'MM DD YYYY HH24 MI SS') ORDER BY
LOWER(s.keyvalue)

judging from http://bugzilla.mozilla.org/show_bug.cgi?id=210251#c45, this has
been going on for quite a while :(  perhaps it is load-related?

Reproducible: Sometimes

Steps to Reproduce:

Comment 1

[simon annear]

Tried to connect to server (http://talkback-public.mozilla.org), but get a http
500 error as follows

type Exception report

message

description The server encountered an internal error () that prevented it from
fulfilling this request.

exception

org.apache.jasper.JasperException
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.lang.NullPointerException
	org.apache.jsp.fastfind_jsp._jspService(fastfind_jsp.java:248)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

Comment 2

[Jay Patel [:jay]]

The db went down this morning, so that was probably why you saw the error.  I
need to add a more user friendly downtime page when these types of errors happen. 

Marc:  Are you still seeing this problem?  I'm able to run queries fine.

Comment 3

[Jay Patel [:jay]]

*** This bug has been marked as a duplicate of 261674 ***

Comment 4

[Marc Bejarano]

now that the db server is back up, i'm no longer seeing the problem i reported.
 i'm going to revert the summary from "Check for DB errors and load a more
user-friendly downtime page (public talkback server gives database errors when
processing queries)" back to the original "public talkback server gives database
errors when processing queries", undupe, and mark fixed.  i wasn't worried about
friendly error messages when i reported this problem.  i was worried about
broken queries.  now that the root cause (db server outage) has been rectified,
we're set :)