[es] - Problem sa velikom tabelom !!!!

mysqlNuts

Član broj: 59349
Poruke: 28
*.ns.ac.yu.

Profil

^{25.05.2005. u 14:31}

Baza - MYSQL 3.23
Web server - Tomcat 4.x
Client app - jsp,dbforms

Tabela ima 100-nak polja koja su uglavnom blob , i oko 2000 slogova. Velicina tabele je 25 Mb. Stranica koja izlistava sve slogove iz table je radila normalno sve dok nije presla 1700-1800 slogova. Tomcat sada izbacuje internal error HTTP 500 sa uopstenom porukom pa nisam siguran da li mysql izbacuje zbog timeouta ili max_allowed_packet ili pak Tomcat.
Kad smanjim u dbforms da prikazuje prvih 1500 slogova sve radi OK , kad stavim * PUCA. Negde sam pronasao da je u Mysql 3.23 max_allowed_packet = 16mb ali nisam siguran da je u tome problem. Takodje sam povecao sve variable koji imaju veze sa time,timeout,size ali nepomaze.
IMA LI NEKO IDEJU!!!!!!!!!!!!!!!!!!!!!!

^{25.05.2005. u 14:31}

markom
Marko Milivojević
Senior Technical Instructor at IPexpert,
Inc.
64°08´N - 21°56´W

Član broj: 18427
Poruke: 4213
*.213.158.108.in.is.

Jabber: markom@gmail.com
ICQ: 2354227
Sajt: cisco.markom.info

Profil

Re: Problem sa velikom tabelom !!!!

^{25.05.2005. u 14:37}

Možda ne bi bilo loše da pogledaš šta piše u tomcatovim logovima?

Marko.

OV SM
LA PK

^{25.05.2005. u 14:37}

mysqlNuts

Član broj: 59349
Poruke: 28
*.ns.ac.yu.

Profil

Re: Problem sa velikom tabelom !!!!

^{26.05.2005. u 07:37}

U trnutku kad zatrazim problematicnu stranicu u log se upise sledece :

2005-05-26 08:23:05 StandardHost[localhost]: Mapping request URI '/karton2'
2005-05-26 08:23:05 StandardHost[localhost]: Trying the longest context path prefix
2005-05-26 08:23:05 StandardHost[localhost]: Mapped to context '/karton2'
2005-05-26 08:23:05 StandardHost[localhost]: Mapping request URI '/karton2/'
2005-05-26 08:23:05 StandardHost[localhost]: Trying the longest context path prefix
2005-05-26 08:23:05 StandardHost[localhost]: Mapped to context '/karton2'
2005-05-26 08:23:05 StandardHost[localhost]: Mapping request URI '/karton2/menu.jsp'
2005-05-26 08:23:05 StandardHost[localhost]: Trying the longest context path prefix
2005-05-26 08:23:05 StandardHost[localhost]: Mapped to context '/karton2'
2005-05-26 08:23:05 StandardHost[localhost]: Mapping request URI '/karton2/dbforms.css'
2005-05-26 08:23:05 StandardHost[localhost]: Trying the longest context path prefix
2005-05-26 08:23:05 StandardHost[localhost]: Mapped to context '/karton2'
2005-05-26 08:23:07 StandardHost[localhost]: Mapping request URI '/karton2/servlet/control'
2005-05-26 08:23:07 StandardHost[localhost]: Trying the longest context path prefix
2005-05-26 08:23:07 StandardHost[localhost]: Mapped to context '/karton2'
2005-05-26 08:23:10 HostConfig[localhost]: Deploying discovered web applications
2005-05-26 08:23:12 ApplicationDispatcher[/karton2] Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
.
.
.

i dalje kilometarski log

^{26.05.2005. u 07:37}