Hi,
Roxen 5.0.0-cvs.
Sometimes, mostly when flushing cash, or wenn multiple users
are doing database queries, the sql connection to postgresql
crashes. Afterwards, the connection is not restored, and I have
to restart roxen server.
It seems to occur more often if the server is heavy loaded, and queries
begin to slow down.
In the logfiles I get:
16:11:49 : Internal server error: Indexing the NULL value with "error".
0m12.7s : RXML frame backtrace:
: | <emit query="SELECT data,mimetype FROM staticcontent \n"
: " WHERE staticid='118'" scope="db" source="sql">
: /usr/local/pike/7.7.39/lib/modules/Sql.pmod/Sql.pike
(version 1.89):
378: 7.6::Sql.Sql()->error()
: modules/database/sqltag.pike:283:
RoxenModule(securetheworks.nl/sqlt
ag#0)->do_sql_query(mapping[3],RequestID(/img/get.rxml?contentid=118),1,UNDEFINE
D)
0m12.7s : modules/tags/rxmltags.pike:4692:
RXML.Frame(emit)->do_enter(@0)
: etc/modules/RXML.pmod/module.pmod:4344:
RXML.Frame(emit)->_eval(RXML.Context(),RXML.PCode(RXML.t_html(xml),RXML.TagSet(securetheworks.nl,rxml_tag_set)),RXML.t_html(xml))
: etc/modules/RXML.pmod/module.pmod:8430:
RXML.PCode(RXML.t_html(xml),RXML.TagSet(securetheworks.nl,rxml_tag_set))->_eval(@1=RXML.Context(),0)
: etc/modules/RXML.pmod/module.pmod:7942:
RXML.PCode(RXML.t_html(xml),RXML.TagSet(securetheworks.nl,rxml_tag_set))->eval(@1,UNDEFINED)
: modules/tags/rxmlparse.pike:161:
RoxenModule(securetheworks.nl/rxmlparse#0)->handle_file_extension(7.4::Stdio.File("/data/sites/securetheworksevents.com/www/img/get.rxml",
"r", 666 /* fd=25 */),"rxml",@0)
16:11:49 : base_server/configuration.pike:2297:
Configuration(securetheworks.nl)->low_get_file(@0,UNDEFINED)
0m12.7s : base_server/configuration.pike:2431:
Configuration(securetheworks.nl)->get_file(@0,UNDEFINED,UNDEFINED)
: base_server/configuration.pike:2406:
Configuration(securetheworks.nl)->handle_request(@0,UNDEFINED)
: protocols/http.pike:2315:
RequestID(/img/get.rxml?contentid=118)->handle_request()
: base_server/roxen.pike:653: roxen->handler_thread(1)
:
16:11:53 : Internal server error: Indexing the NULL value with "error".
|