#236 Base w/ Postgres unstable

[Anonymous]

base-version is 1.4.2
i tried both option, the errors occured in both casess:
$db_connect_method = 0|1;

for testing-purposes installed base w/ mysql and postgres-database, both catching the same alerts from some sensors. it seems that base using pg doesnt disconnect fully from the database or isnt able to use persisten connection: i get an error every 2nd/3rd click:

Database ERROR:Database ERROR:FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

the db is full of idle tasks, leading to a dos for the alerting sensors (no more alert-updates due to
too many connection-errors), when browsing to much with base:

snort=# SELECT * FROM pg_stat_activity;
datid | datname | procpid | usesysid | usename | current_query | waiting | xact_start | query_start | backend_start | client_addr | client_port
-------+---------+---------+----------+----------+---------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+-------------+-------------
16522 | snort | 5045 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:50:26.207241+01 | 2010-02-03 12:50:21.215826+01 | 127.0.0.1 | 57466
16522 | snort | 5094 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:50:49.742956+01 | 2010-02-03 12:50:49.417513+01 | 127.0.0.1 | 57467
16522 | snort | 5100 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:50:59.731045+01 | 2010-02-03 12:50:58.973919+01 | 127.0.0.1 | 57468
16522 | snort | 5105 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:51:07.765243+01 | 2010-02-03 12:51:07.060518+01 | 127.0.0.1 | 57469
16522 | snort | 5188 | 10 | postgres | SELECT * FROM pg_stat_activity; | f | 2010-02-03 12:57:41.829009+01 | 2010-02-03 12:57:41.829009+01 | 2010-02-03 12:51:10.807528+01 | | -1
16522 | snort | 5198 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:51:25.613381+01 | 2010-02-03 12:51:25.223475+01 | 127.0.0.1 | 57470
16522 | snort | 5206 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:52:01.611226+01 | 2010-02-03 12:51:57.162905+01 | 127.0.0.1 | 57471
16522 | snort | 5216 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:52:19.346438+01 | 2010-02-03 12:52:18.872989+01 | 127.0.0.1 | 57472
16522 | snort | 5229 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:53:04.178484+01 | 2010-02-03 12:53:02.381434+01 | 127.0.0.1 | 57474
16522 | snort | 5505 | 16386 | snortpg | <IDLE> | f | | 2010-02-03 12:57:10.903821+01 | 2010-02-03 12:57:09.982465+01 | 127.0.0.1 | 56331
(10 rows)

[Nobody/Anonymous]

I like what you guys are up also. Such smart work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my web site :) Cheap Miu Miu Bags for Sale http://miumiubags1.cabanova.com

[Nobody/Anonymous]

Irrrm a sucker for anything and everything with reference to these types Miu Miu Bags http://miumiuoutlet.v5s7.com!! (miumiuoutlet.v5s7.com!!) Buddy often gives you that company!! They're legal . deliver that company if it's preparing hail out of the house, but we still have possessed a whole bunch of sno wnad We do deliver that company in the snow!! Now designer in addition to awesome!! Excellent encouragement!!!