Re: Confusion about SQL results - row counts and contents differ

Maybe you haven't committed some manual change on the server, so it isn't visible to other connections. On Thu, Jan 26, 2023 at 8:56 PM Steven Haigh via modperl < modperl@perl.apache.org> wrote: > > > On Fri, Jan 27 2023 at 09:50:42 +0800, demerphq > wrote: > > On Fri, 27 Jan 2023, 09:43 Steven

Re: mod_perl alternatives

I don't think there's any sudden urgency to switch to something else, since nothing has actually changed about the state of mod_perl. However, if you do want to migrate to something else, you should look at Plack: https://metacpan.org/pod/Plack Plack is not a drop-in replacement for mod_perl, but

Re: Does anyone know what MP_NEED_HASH_SEED_FIXUP is for?

Hi Steve, I remember the original problem with rand(), but not what this change was about. There used to be a problem with all mod_perl child processes producing the same series of random numbers, because the seed was initialized before forking. This sounds like a different problem. - Perrin On

Re: MP framework

You can run Dancer on mod_perl using Plack. The Dancer documentation covers it. Or there's Catalyst. These frameworks are trying to be independent of the web server they run on, so they don't tie in to mod_perl beyond taking advantage of the speed. That doesn't stop you from mixing them with

Re: Multiple documents/files with same subroutine name

Hmm, that's not expected behavior with the code you're showing here. Are you running this under ModPerl::Registry? It's supposed to generate a unique package name for every file that prevents subs from colliding. There are some things to watch out for when using subroutines in code you run under

Re: capture exception

https://www.effectiveperlprogramming.com/2011/03/know-the-different-evals/ On Tue, May 30, 2017 at 10:49 AM, Dirk-Willem van Gulik < di...@webweaving.org> wrote: > > On 30 May 2017, at 16:43, John Dunlap wrote: > > How is it a security hole? > > …. > > > my $ret = eval {

Re: Apparent memory leak

ill make the >> problem worse for my customers because this problem is only happening on >> heavily loaded servers. I can't reproduce it locally. >> >> On Tue, Sep 6, 2016 at 11:26 AM, Perrin Harkins <phark...@gmail.com> >> wrote: >> >>> Hi John, >

Re: Apparent memory leak

Hi John, The key is usually finding out what the request was that caused it. You can add the pid to your access logging, or write a more complete mod_perl handler to log the complete data input along with the pid. Then you just go back and look at what it was after you see which process was

Re: Bad rap

As mentioned in this article, nginx is a great reverse proxy for mod_perl sites. On Tue, Jun 14, 2016 at 10:28 AM, John Dunlap wrote: > https://www.nginx.com/blog/nginx-vs-apache-our-view/ > > On Tue, Jun 14, 2016 at 2:35 AM, André Warnier wrote: > >> On

Re: Bad rap

I invited him to stop by for help understanding what he's got running and what his options are. He doesn't know perl, so this is probably all a black box to him. On Sat, Jun 11, 2016 at 2:11 PM, Vincent Veyron wrote: > Hi all, > > See this post on reddit : > > >

Re: close connection for request, but continue

On Thu, Apr 21, 2016 at 9:48 AM, Iosif Fettich wrote: > I'm afraid that won't fit, actually. It's not a typical Cleanup I'm after > - I actually want to not abandon the request I've started, just for closing > the incoming original request. The cleanup handler could relaunch

Re: close connection for request, but continue

On Thu, Apr 21, 2016 at 5:20 AM, Iosif Fettich wrote: > > I'm trying to achieve the following: when there is an incoming request, I > want to set a time limit in which an answer should be delivered to the > client, no matter what. > > However, since the work triggered by the

Re: Thread-safe & vars scope clarification

Sounds like threads could have an interest, but according to your message, > should not be a general case. > > Thank you, > > Ben > > Le 4 avr. 2016 à 22:49, Perrin Harkins <phark...@gmail.com> a écrit : > > Hi Ben. > > Before you get too far into the deta

Re: Thread-safe & vars scope clarification

Hi Ben. Before you get too far into the details of using threads, can I ask why you're considering it? The memory footprint and performance of using forked processes with Perl is generally going to be better than that of threads, due to copy-on-write. - Perrin On Mon, Apr 4, 2016 at 4:44 PM,

Re: Weird variable scope problem

tiple lexical scopes for the same package? > > On Fri, Mar 25, 2016 at 3:58 PM, Perrin Harkins <phark...@gmail.com> > wrote: > >> On Fri, Mar 25, 2016 at 10:11 AM, John Dunlap <j...@lariat.co> wrote: >>> >>> Basically, I have a module which has a

Re: Weird variable scope problem

On Fri, Mar 25, 2016 at 10:11 AM, John Dunlap wrote: > > Basically, I have a module which has a some lexically scoped variables in > it. These variables are used by accessor methods in the package. The > problem is that, if I use this module in certain parts of my application, >

Re: memcache and perl question

On Tue, Nov 24, 2015 at 12:21 PM, Joseph Norris wrote: > process 1 -> set($tag1,$hash);data unique to process 1 > process 1 -> get($tag1,$hash); > process 2 -> set ($tag2,$hash); data unique to process 2 > process 2 -> get($tag2,$hash); > I'm not sure what you're

Re: memcache and perl question

On Tue, Nov 24, 2015 at 11:05 AM, Joseph Norris wrote: > if I set a tag to a value of a hash: > > $self->{cache}->set('tag',$hash); > > is the hash ref set in memcache that will point back to my hash or do I > have to actually have a %hash to be used in >

Re: memcached on systems with small RAM

You might want to look at alternatives in that kind of setup. For example, BerkeleyDB is quite a bit faster than memcached when your cache is just on one local system. The advantages of memcached come into play when you have a large cache across multiple machines. - Perrin On Mon, Apr 27, 2015

Re: memcached on systems with small RAM

of items in memcache Thanks for the tip, I definitely will consider it! Hans On Tue, Apr 28, 2015 at 2:43 PM, Perrin Harkins phark...@gmail.com wrote: You might want to look at alternatives in that kind of setup. For example, BerkeleyDB is quite a bit faster than memcached when your cache

Re: Apache::Reload versioning

Sorry Steve, I don't know what that's about. I don't see anything relevant in my dev mail archives. - Perrin On Wed, Apr 22, 2015 at 1:33 PM, Steve Hay steve.m@googlemail.com wrote: The current RELEASE notes for Apache::Reload say that after bumping the version number from X.YY-dev to

Re: Large File Download

Yeah, sendfile() is how I've done this in the past, although I was using mod_perl 1.x for it. On Sat, Mar 28, 2015 at 5:55 AM, André Warnier a...@ice-sa.com wrote: Randolf Richardson wrote: I know that it's possible(and arguably best practice) to use Apache to download large files

Re: mod_perl for multi-process file processing?

Cache::FastMmap is a great module for sharing read/write data, but it can't compete with the speed of loading it all into memory before forking as Alan said he plans to do. - Perrin On Tue, Feb 3, 2015 at 2:05 AM, Cosimo Streppone cos...@streppone.it wrote: Alan Raetz wrote: So I have a

Re: mod_perl for multi-process file processing?

I agree, either threads or Parallel::ForkManager, depending on your platform and your perl, will be a lot faster than mod_perl for this. Of course there might be other reasons to use mod_perl, e.g. it's useful to have this available as a remote service, or you want to call this frequently for

Re: Prototype mismatch

Hi Worik, This happens when you reload code that uses prototypes. In this case, those constants are using prototypes. It's similar to this: http://perl.apache.org/docs/1.0/guide/troubleshooting.html#Constant_subroutine_XXX_redefined Not really a problem, but it will not happen if you stop and

Re: Errors in the wrong place and wrong format

I think that only redirects errors logged with Apche2::Log, not all of STDERR. There might be a workaround for capturing STDERR. I'd try searching the mailing list archives. - Perrin On Mon, Nov 17, 2014 at 6:28 PM, worik worik.stan...@gmail.com wrote: My virtual host has errors redirected to:

Re: Disconnect database connection after idle timeout

On Fri, Nov 14, 2014 at 7:58 AM, Vincent Veyron vv.li...@wanadoo.fr wrote: If I understand correctly, I could also use Apache::DBI and a persistent connection for a similar result, modulo what you wrote in an earlier message regarding the connection being more explicit (which I don't quite

Re: Disconnect database connection after idle timeout

On Fri, Nov 14, 2014 at 1:32 PM, Xinhuan Zheng xzh...@christianbook.com wrote: Are you implying that the performance will be suffered when using mod_perl-enabled server processes as the front tier servers? Not performance, scalability. You can't handle as many requests per second if you use

Re: Disconnect database connection after idle timeout

Hi, Can you explain what problem you're trying to solve? Apache processes don't have the option of doing things when there is no request to serve, so you can't easily have them disconnect. It may be possible with alarms or cron jobs or something, but it's probably not a good idea. If you tune

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 10:29 AM, Xinhuan Zheng xzh...@christianbook.com wrote: We don’t have any front end proxy. I think I see the problem... ;) If you use a front-end proxy so that your mod_perl servers are only handling mod_perl requests, and tune your configuration so that idle mod_perl

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 11:29 AM, Dr James Smith j...@sanger.ac.uk wrote: From experience - and having chatted with our DBAs at work, with modern Oracle and with MySQL keeping persistent connections around is no real gain and usually lots of risks It's certainly good to know how long it

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 12:21 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: Nobody suggested using connect_cached, where the documentations says : The cached database handle is replaced with a new connection if it has been disconnected or if the ping method fails Would that not solve

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 12:19 PM, Xinhuan Zheng xzh...@christianbook.com wrote: Having another tier (like DBD::Gofer) looks like really messy in infrastructure plus it’s not certain who is going to maintain that module’s quality. I'd only recommend trying it after you set up a front-end

Re: Disconnect database connection after idle timeout

- Perrin On Thu, Nov 13, 2014 at 2:12 PM, Xinhuan Zheng xzh...@christianbook.com wrote: Hi Perrin, I don’t quite understand what you mean by setting up a front-end proxy. What would you expect this “proxy” do? Does it take HTTP request? Thanks, - xinhuan From: Perrin Harkins phark

Re: Disconnect database connection after idle timeout

? On Thu, Nov 13, 2014 at 2:23 PM, Perrin Harkins phark...@gmail.com wrote: Yes, it's an HTTP proxy. It handles sending out the bytes to remote clients, so that your mod_perl server doesn't have to. A popular high-performance choice these days is nginx. There's some discussion of why to use

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 2:48 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: But then, what is the point of using connect_cached? You can use it outside of mod_perl. You can also use instead of Apache::DBI if you don't want the connection to be more explicit (instead of magically overriding the

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 2:41 PM, Xinhuan Zheng xzh...@christianbook.com wrote: From the description of the document, the “proxy” server acts much like a memcache but it appears the difference is the “proxy” understands the HTTP protocol while memcache does not. Not exactly. While it is

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 5:29 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: I stash a reference to a DBI handle in pnotes during the HeaderParser phase of my requests; I then refer to this handle for every request in my PerlResponseHandlers. This seems to have been working fine for several

Re: Disconnect database connection after idle timeout

On Thu, Nov 13, 2014 at 5:38 PM, Xinhuan Zheng xzh...@christianbook.com wrote: We have load balancer cache that can cache images and JavaScripts. This functions seems a bit duplicate. It's not about caching. Here's a quote from that link I sent earlier: Another drawback of this approach is

Re: Shared Dirty memory of Apache parent process

On Thu, Sep 18, 2014 at 5:35 AM, Nageswara rao Gurram nageshgurra...@gmail.com wrote: As the traffic is increasing shared memory in parent is increasing , thats what puzzling me ! If childs write into shared of parent, then it should come into private of child(copy on write) but why shared of

Re: Shared Dirty memory of Apache parent process

On Wed, Sep 17, 2014 at 1:18 PM, Mark Hedges mark.hed...@ticketmaster.com wrote: For example, you could use a tied DBM/MLDBM hash, DBD::SQLite or another file-based database with access locking for your cache, and save it in a shared memory filesystem like /dev/shm. I would suggest that too,

Re: Shared Dirty memory of Apache parent process

Hi, Loading data in the parent process is a common strategy for data that you won't modify. Do you need to change this data from the child processes? If so, does it matter if the other child processes see the changes? - Perrin On Tue, Sep 16, 2014 at 10:28 AM, Nageswara rao Gurram

Re: ModPerl::RegistryCooker default_handler returned status

HI Pavel, Your messages include a lot of good details, but they are a bit long. I'd suggest trying to keep things as short as you can. Remember that everyone working on open source is a volunteer, spending their own personal time to read and answer your messages. On Sun, Aug 31, 2014 at 4:15

Re: ModPerl::RegistryCooker default_handler returned status

Hi Pavel, You might get more interesting answers on the users mailing list, but there's lots of discussion about this in the archives. For example: http://www.gossamer-threads.com/lists/modperl/modperl/45559?search_string=registry%20status;#45559

Re: Something wrong with CPAN ?

The address for reporting technical issues is cpansea...@perl.org, although I'm sure they've heard about it by now. There's a good alternate search at https://metacpan.org/. - Perrin On Mon, Jun 9, 2014 at 7:23 AM, André Warnier a...@ice-sa.com wrote: Hi guys. Is it only me, or does the

Re: Trouble with script execution

On Sun, May 18, 2014 at 9:47 PM, Worik Stanton worik.stan...@gmail.com wrote: I am sure I read somewhere that mod_perl monitors scripts and reloads them if the modification date changes. You're probably thinking of Apache::Registry/ModPerl::Registry. They do that with your CGI scripts. -

Re: API Docs

The $r there is the Apache2::RequestRec object. It gets passed to your handler. See the handler example in the overview: https://perl.apache.org/docs/2.0/user/intro/start_fast.html - Perrin On Wed, May 14, 2014 at 7:52 PM, Worik Stanton worik.stan...@gmail.com wrote: I am still trying to

Re: Trouble with mod_perl API: E.g., Apache2::Directive::conftree()

Hi Worik, Your ErrorLog question isn't really a mod_perl issue, but I'd suggest you check for warnings at startup. You may not have APACHE_LOG_DIR defined, etc. I don't use Apache2::Directive, so I can't vouch for it. I prefer simpler things like PerlSetVar. There is an automated test for

Re: Apache::DBI and Pgbouncer

Interesting. Why did you have to install PgBouncer? Can't Postgres handle remote connections from your web server? I don't use Postgres, but reading the description of PgBouncer I can see some things you'd want to consider. First, Apache::DBI prevents you from making persistent connections

Re: Apache::DBI and Pgbouncer

the pool on the web server eliminates the overhead of establishing new connections(DNS lookups, establishing TCP connections, authentication, waiting for the database to spool up a new process, etc). On Tue, Apr 22, 2014 at 12:18 PM, Perrin Harkins phark...@gmail.com wrote: Interesting. Why

Re: Apache::DBI and Pgbouncer

::DBI and benchmarking. - Perrin On Tue, Apr 22, 2014 at 12:33 PM, John Dunlap j...@lariat.co wrote: use Apache::DBI (); appears in our startup.pl but the application code uses DBI directly. On Tue, Apr 22, 2014 at 12:30 PM, Perrin Harkins phark...@gmail.com wrote: Thanks John. Were you

Re: support for Apache 2.4

On Fri, Feb 14, 2014 at 8:01 PM, Jie Gao j@sydney.edu.au wrote: The link http://svn.apache.org/snapshots/modperl-2.0/ on page http://perl.apache.org/download/source.html#Development_mod_perl_2_0_Source_Distribution returns 404; http://perl.apache.org/dist/ is full of broken links.

Re: Singleton Persistence

On Sat, Feb 1, 2014 at 8:14 PM, John Dunlap j...@lariat.co wrote: In mod_perl, can instantiated singletons survive requests? Sure, anything you put in a global will survive until the httpd child process is shut down. How many requests each child serves depends on your configuration. When a new

Re: Singleton Persistence

On Mon, Feb 3, 2014 at 5:33 PM, Chris Bennett ch...@bennettconstruction.us wrote: Right now I am using pg_1_.pl and pg_2.pl on the different hosts, but the code is identical, except that some data is pulled in from a config file for the different databases, etc used. Can I safely use pg.pl on

Re: Returning 200 status from my handler

Hi John, I notice, in the getting started documentation, that I am supposed to return Apache2::Const::OK to indicate an HTTP 200 success status Actually, that's not about sending a HTTP 200 success status. You return Apache2::Const::OK to tell httpd that your handler ran correctly. When I

Re: Interaction with ORM software

Hi Ted, DBIx::DataModel doesn't use memcached and isn't really related to it. You can certainly store things in memcached yourself, but your DBIx::DataModel won't know anything about it. You'd have to add a caching layer on top yourself. If having that built into your ORM is important to you,

Re: Please delete old releases from mirroring system

if I can fix them soon. My feeling is that everyone gets mod_perl from CPAN, so it doesn't make much difference, but it looks bad. - Perrin On Wed, Jan 1, 2014 at 7:22 PM, Perrin Harkins per...@elem.com wrote: On Tue, Dec 31, 2013 at 1:05 PM, sebb seb...@gmail.com wrote: Are the -current artifacts

Re: Please delete old releases from mirroring system

wrote: On 2 January 2014 00:26, Perrin Harkins per...@elem.com wrote: FYI. I deleted the -current stuff and fixed the other issues. The links on our download page on perl.apache.org are currently pretty broken, but they were broken long before I made these changes. Looks like they were

Re: Please delete old releases from mirroring system

Hi, I've deleted 2.0.7 from https://dist.apache.org/repos/dist/release/perl/. Please let us know if anything further is required. Sorry for the delay on this. We've only just switched to svnpubsub and are still figuring it out. - Perrin On Tue, Dec 31, 2013 at 9:55 AM, sebb seb...@gmail.com

Re: Apache::DBI connect

On Fri, Nov 8, 2013 at 2:58 PM, Xinhuan Zheng xzh...@christianbook.comwrote: The query is from the application code not the 'select 1' test query. OK, then it seems like Apache::DBI may not have a problem. While most of time I saw Apache::DBI-connect is called but sometime from a process,

Re: Apache::DBI connect

On Thu, Nov 7, 2013 at 11:06 PM, Xinhuan Zheng xzh...@christianbook.comwrote: As I turned on more debugging, when the problem occurs, the Apache cached connection reference is different than the database handle reference the query is using. Which query are you talking about? The ping in

Re: Apache::DBI connect

From: Perrin Harkins phark...@gmail.com Date: Wednesday, November 6, 2013 5:54 PM To: Xinhuan Zheng xzh...@christianbook.com Cc: mod_perl list modperl@perl.apache.org Subject: Re: Apache::DBI connect On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng xzh

Re: Apache::DBI connect

On Thu, Nov 7, 2013 at 9:46 AM, Xinhuan Zheng xzh...@christianbook.com wrote: The $ok is undef. In the case if the test does succeed (like the first select), $ok returns 0E0. That all sounds good. 0E0 is a true value in Perl. It means zero but true. And undef is a false value. You don't need

Re: Apache::DBI connect

do you distinguish? - xinhuan From: Xinhuan Zheng xzh...@christianbook.com mailto:xzh...@christianbook.com Date: Thursday, November 7, 2013 11:12 AM To: Perrin Harkins phark...@gmail.com mailto:phark...@gmail.com Cc: mod_perl list modperl@perl.apache.org mailto:modperl

Re: Apache::DBI connect

ran it multiple times and every time it reconnects OK. But Apache::DBI doesn't work. You saw the previous debugging info. Where is the problem? - xinhuan From: Perrin Harkins phark...@gmail.com Date: Thursday, November 7, 2013 1:00 PM To: Xinhuan Zheng xzh...@christianbook.com Cc: Adam

Re: Apache::DBI connect

of or instead of and? - xinhuan From: Perrin Harkins phark...@gmail.com Date: Thursday, November 7, 2013 3:05 PM To: Xinhuan Zheng xzh...@christianbook.com Cc: Adam Prime adam.pr...@utoronto.ca, modperl@perl.apache.org modperl@perl.apache.org Subject: Re: Apache::DBI connect Sorry

Re: Apache::DBI connect

On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng xzh...@christianbook.comwrote: I wonder this line of code should be changed to 'DBI-connect(@args) if ($@)'. If ping failed, that means the connection is already closed, $drh may be no longer valid, will $drh-connect always return a valid new

Re: mysql connection pooling

. I have Apache httpd with mod_perl and DBI. Without many code changes, what does the proxy server look like to achieve the database connection pooling? What is Apache running DBI Gofer as shown in the slides page 26? Thanks, - xinhuan From: Perrin Harkins phark...@gmail.com Date: Thursday

Re: Qu: installing mod_perl2 outside of apache2 and perl install directories

I suspect there's a way to fix the issue, but my general advice is this: don't be a slave to running the tests if you already have some way to know if the module is working. It's fine to force install rather than spend hours fighting with a test setup. - Perrin On Tue, Sep 10, 2013 at 8:11 PM,

Re: best way to copy a innodb table

On Thu, Dec 1, 2011 at 5:54 PM, Miguel Angel Nieto miguel.ni...@percona.com wrote: You should check pt-archiver. +1. It works very well for this type of job. - Perrin

Re: httpd24 branch now works with both httpd-2.2 and httpd-2.4

That's great. Thank you, Jan. - Perrin On Thu, Jun 27, 2013 at 6:55 AM, Jan Kaluža jkal...@redhat.com wrote: Hi, I have done some work on httpd24 branch today. Already done: - xs/tables are now divided into two separate directories: xs/tables/current and xs/tables/current24 (2.2 vs.

Re: mysql connection pooling

Hi, There is nothing exactly like the database pool in JDBC. However, there are solutions for this problem. The first thing you should do is run a reverse proxy in front of your mod_perl server. That typically reduces the number of mod_perl processes by a factor of 10, i.e. 1000 mod_perl

Re: Apache::DBI connection lost contact error

, read the docu !! message at all. It appears this new version only works with Apache2 but not Apache1. Is that possible to fix it with Apache1? Thanks, - xinhuan From: Perrin Harkins phark...@gmail.com Date: Wednesday, June 12, 2013 5:53 AM To: Fred Moyer f...@redhotpenguin.com Cc

Re: Apache::DBI connection lost contact error

Thanks Fred! On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer f...@redhotpenguin.com wrote: Apache-DBI 1.12 was just pushed to CPAN with this update. Thanks for the great work on the fix Perrin. On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins phark...@gmail.com wrote: That's great! I'll commit

Re: svn commit: r1490648 - in /perl/Apache-DBI/trunk: Changes lib/Apache/DBI.pm

. -1.12-dev +1.12 + + - Fix detection of server startup in mod_perl 2, to avoid caching +connections in the parent process. Perrin Harkins +per...@elem.com 1.11 October 7, 2011 Modified: perl/Apache-DBI/trunk/lib/Apache/DBI.pm URL: http://svn.apache.org/viewvc/perl/Apache-DBI/trunk

Re: svn commit: r1490648 - in /perl/Apache-DBI/trunk: Changes lib/Apache/DBI.pm

:54 AM, Perrin Harkins per...@elem.com wrote: Thanks! Do you know what needs to happen to roll a new release of Apache::DBI? It's a separate CPAN dist from mod_perl. - Perrin On Fri, Jun 7, 2013 at 2:17 PM, Fred Moyer f...@redhotpenguin.com wrote: Perrin++ On Jun 7, 2013 6

Re: Apache::DBI connection lost contact error

On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng xzh...@christianbook.com wrote: The database handle that is created in startup.pl needs to be really disconnected (not overloaded disconnect) so that won't leave an idle server process running on the database side. Once it's really disconnected, the

Re: Apache::DBI connection lost contact error

good to me. Thanks, - xinhuan From: Perrin Harkins phark...@gmail.com Date: Thursday, June 6, 2013 3:02 PM To: Xinhuan Zheng xzh...@christianbook.com Cc: modperl@perl.apache.org modperl@perl.apache.org Subject: Re: Apache::DBI connection lost contact error On Thu, Jun 6, 2013 at 12:22

Re: Apache::DBI connection lost contact error

On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan Zheng xzh...@christianbook.com wrote: I have seen in other web servers when apachectl starts, there is no connect lost contact error but it did happen when apachectl stops. If your server does not receive constant requests, you may see this error on

Re: Apache::DBI connection lost contact error

On Mon, Jun 3, 2013 at 4:36 PM, Dave Morgan dave.mor...@100.com wrote: As an administrator I still rely and depend on Apache::DBI, even if it is unsupported. Can we kill this rumor please? Apache::DBI is supported. - Perrin

Re: Apache::DBI connection lost contact error

On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng xzh...@christianbook.com wrote: Will the new connection that's created be cached after then and the connection that's not ping-able will be discarded? Yes. Will this cached the new connection last until the child process exit? Yes, unless it times

Apache::DBI connection lost contact error

On Monday, June 3, 2013, Xinhuan Zheng wrote: What is the check to see if the server is restarting? Is that new child processes spawning? It's a test for whether or not we're running in the parent process, used to skip caching connections during startup. It's this, line 128: if

Re: Apache::DBI connection lost contact error

On Fri, May 31, 2013 at 5:45 PM, Xinhuan Zheng xzh...@christianbook.com wrote: 2520 Apache::DBI skipping connection during server startup, read the docu !! 2520 Apache::DBI skipping connection during server startup, read the docu !! That's good. 2521 Apache::DBI

Re: Apache::DBI connection lost contact error

that error. Don't know why. - xinhuan On 5/30/13 8:31 AM, Jim Schueler jschue...@eloquency.com wrote: Did this solve your problem? -Jim On Wed, 29 May 2013, Perrin Harkins wrote: Hi, Apache::DBI is supposed to skip caching if you connect during startup. You should just need

Re: Apache::DBI connection lost contact error

. But fundamentally, I'd say that you're confusing 'local' and 'my' variable scoping: http://www.perlmonks.org/?**node_id=94007http://www.perlmonks.org/?node_id=94007 -Jim On Fri, 31 May 2013, Perrin Harkins wrote: Try an explicit disconnect() call. - Perrin On Thu, May 30, 2013 at 7:46 PM

Re: Apache::DBI

that is the following: Edmund Mergl was the original author of Apache::DBI. It is now supported and maintained by the modperl mailinglist, see the mod_perl documentation for instructions on how to subscribe. Unless Perrin Harkins agreed to take over support for this module

Re: Apache::DBI

appropriate answer for the poster of the original thread. I owe you a :) from a couple posts ago. :) -Jim On Fri, 31 May 2013, Perrin Harkins wrote: Hi Jim, I appreciate the thought, but I'm not the mod_perl list. If you look at who has done the most support around here recently, it's

Re: [OT] Apache::DBI

been superceded by newer modules. Especially if no one responds and explicitly accepts the responsibility, this seems like the most appropriate answer for the poster of the original thread. I owe you a :) from a couple posts ago. :) -Jim On Fri, 31 May 2013, Perrin Harkins wrote: Hi

Re: Apache::DBI connection lost contact error

Hi, Apache::DBI is supposed to skip caching if you connect during startup. You should just need to disconnect your database handle after you finish with it. It sounds like you're opening it and then leaving it open. - Perrin On Wed, May 29, 2013 at 3:24 PM, Xinhuan Zheng

Re: Time for 2.0.8?

+1 On Mon, Mar 18, 2013 at 5:32 AM, Steve Hay steve@verosoftware.com wrote: The mod_perl trunk now contains a bunch of fixes for recent versions of perl, especially with respect to changes to rehashing. These changes will be necessary for mod_perl to build with the forthcoming perl

Re: Website update?

Hi Gerald, Sorry for the delay. I haven't done any work on the website, but I think I can figure out what we need to do in order to update it. I'll try to investigate it this weekend. - Perrin On Sun, Nov 11, 2012 at 8:43 AM, rich...@ecos.de wrote: Hi, I like to update

Re: How best to get my mod_perl programs to run under CGI for non-mod_perl users?

Hi Chris, One approach would be to modify your applications so they use some kind of abstraction layer, like Plack, that runs on top of both CGI and mod_perl. There's more on Plack here: http://plackperl.org/ Another option, since you used Registry, would be to change your use of

Re: Does mod_perl-2.0.4 support threads?

All of the 2.x series supports threads. Your Perl has to be compiled for threads though. - Perrin On Fri, Dec 14, 2012 at 2:58 AM, Grant emailgr...@gmail.com wrote: I'm stuck on mod_perl-2.0.4 for now and I'm seeing something in Gentoo which makes me think it doesn't support threads. Is

Re: use global data in handler (was : custom proxy setup with mod_perl)

It sounds like you have it right. If you don't define the package variable $URLS during startup, it will be undef when the child process handles the first request and will keep whatever data you put into it after that. - Perrin On Sat, Nov 24, 2012 at 8:09 AM, André Warnier a...@ice-sa.com

Re: Questions about memcached in general and failover

On Mon, Oct 22, 2012 at 5:09 AM, SAE simsimil...@googlemail.com wrote: But as explained above. If one of the memcached servers goes down. Some users experience the problem, that they not only get logged out but also have problems browsing the site at all or logging back in. Every page needs

Re: Questions about memcached in general and failover

On Tue, Oct 16, 2012 at 12:59 PM, Les Mikesell lesmikes...@gmail.com wrote: If you are going to be stuck with this restriction - and have to build your own fail-over, is there any advantage to using memcache compared to redis with its much larger feature set? I agree. If you need durability

Re: Can I measure the use of index?

On Mon, Oct 15, 2012 at 11:24 AM, Carlos Eduardo Caldi ce_ca...@hotmail.com wrote: Somebody knows how can I log or measure the index use ? http://www.percona.com/doc/percona-toolkit/2.1/pt-index-usage.html - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Coupling Plack/PSGI with mod_perl, or an alternate architecture?

On Sun, Oct 14, 2012 at 2:56 PM, Tatsuhiko Miyagawa miyag...@gmail.com wrote: I think Lars meant no proxy required with *mod_perl* rather than plack stuff, but yes, Starman is recommended to put behind proxy otherwise your precious worker process is bound to slow networked clients, and gets

Re: X-Forwarded-For

On Sat, Oct 13, 2012 at 7:41 AM, pangj pa...@riseup.net wrote: In nginx's config file we have added the x-forwarded-for header. With modperl (MP2) how to get this header? Use headers_in(): http://perl.apache.org/docs/2.0/api/Apache2/RequestRec.html#C_headers_in_ - Perrin

Re: Coupling Plack/PSGI with mod_perl, or an alternate architecture?

On Wed, Oct 10, 2012 at 3:57 PM, Lars Dɪᴇᴄᴋᴏᴡ 迪拉斯 da...@cpan.org wrote: reasons to pick a mod_perl approach over a plack runner approach Requires no proxying. Isn't Starman normally run with a proxy in front of it? If not, it should be. Otherwise, you'd be tying up large processes sending

  1   2   3   4   5   6   7   8   9   10   >