DBI/PostgreSQL/MySQL mod_perl intermittent problem
Hi, I've been having a problem using any Database with mod_perl. This problem has persisted across two separate platforms. I found it initially whilst working on one contract, and it has popped up again on a new contract. Firstly, the initial setup. I was using DBI with MySQL - and I had some scripts written up as modules. I had a simple main script which called these modules - so it was easy to set up an environment where one script defined handler for mod_perl, and the other was a standard #!/usr/bin/perl CGI script. I configured Apache/mod_perl so that through one location, the usual CGI script got run, and the other location ran through mod_perl. When running under the mod_perl location, DB calls would intermittently fail or succeed, with no variables that I could discern dictating when either would happen. However, the application ran 100% through the #!/usr/bin/perl CGI method. At the time, I gave up and just used #!/usr/bin/perl. I'm now on this new contract, and it's happening again. There's a session system going on, so that's where it shows itself first. The guys here are using Embperl, so there's no simple dual-script option. I switched on trace for the DBI module and couldn't find anything new from it. I might persist in this way as there are a lot of debug options. Thing is, this time the database is PostgreSQL. It's possible that this problem is only appearing when numerous calls are made to the server - as some people are using the Embperl written pages to input data, and they don't experience any problems. But me, when I'm clicking around, hitting reload again again, I get up it up on off. I've done searches through Altavista/Google and Northern Light - and searches through Geocrawler on this mailing list. I haven't been able to find anyone else sharing these problems - which is real strange to me 'cause these problems have persisted across completely different projects. I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Maybe it's PostgreSQL settings? I'll try increasing logging options and stuff. But any help someone can offer now would be greatly appreciated. Thanks for your time, Rajit
Re: DBI/PostgreSQL/MySQL mod_perl intermittent problem
- Original Message - From: "Rajit Singh" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 16, 2000 8:58 AM Subject: DBI/PostgreSQL/MySQL mod_perl intermittent problem I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Did it? One possibility, especially with Apache::DBI is that you are exceeding the maximum number of connections the database is configured to allow. With MySQL you can use 'mysqladmin status' or 'mysqladmin processlist' to see the number of backends and what they are doing. With PostgreSQL you may have to use ps and count the postgres processes. Les Mikesell [EMAIL PROTECTED]
Re: DBI/PostgreSQL/MySQL mod_perl intermittent problem
Hi, I've been having a problem using any Database with mod_perl. This problem has persisted across two separate platforms. I found it initially whilst working on one contract, and it has popped up again on a new contract. Which version of mod_perl you are using? Is mod_perl compiled as DSO? if Yes make sure you have at least mod_perl 1.22! Any errors in the logfiles? Gerald - Gerald Richterecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925151 WWW:http://www.ecos.de Fax: +49 6133 925152 - Firstly, the initial setup. I was using DBI with MySQL - and I had some scripts written up as modules. I had a simple main script which called these modules - so it was easy to set up an environment where one script defined handler for mod_perl, and the other was a standard #!/usr/bin/perl CGI script. I configured Apache/mod_perl so that through one location, the usual CGI script got run, and the other location ran through mod_perl. When running under the mod_perl location, DB calls would intermittently fail or succeed, with no variables that I could discern dictating when either would happen. However, the application ran 100% through the #!/usr/bin/perl CGI method. At the time, I gave up and just used #!/usr/bin/perl. I'm now on this new contract, and it's happening again. There's a session system going on, so that's where it shows itself first. The guys here are using Embperl, so there's no simple dual-script option. I switched on trace for the DBI module and couldn't find anything new from it. I might persist in this way as there are a lot of debug options. Thing is, this time the database is PostgreSQL. It's possible that this problem is only appearing when numerous calls are made to the server - as some people are using the Embperl written pages to input data, and they don't experience any problems. But me, when I'm clicking around, hitting reload again again, I get up it up on off. I've done searches through Altavista/Google and Northern Light - and searches through Geocrawler on this mailing list. I haven't been able to find anyone else sharing these problems - which is real strange to me 'cause these problems have persisted across completely different projects. I should probably note that I've used Apache::DBI on and off to see if it makes any difference. Maybe it's PostgreSQL settings? I'll try increasing logging options and stuff. But any help someone can offer now would be greatly appreciated. Thanks for your time, Rajit