postgresql空闲 [英] postgresql idle

问题描述

我有一个奇怪的错误。


当我做ps aux时我得到：


postgres 15018 0.0 0.6 9192 7396？ S 09:20 0:00 / usr / bin / perl

/ www / nexum / cgi-bin / accounting / posting / automatic_posting

postgres 15019 0.0 0.3 25696 4176？ S 09:20 0:00 postgres：

postgres nexum [local]：idle


a关于系统的一点点。


这是戴尔Power Edge 500 sc 1G Mem和PIII 1Ghz处理器40G硬盘

运行RHEL 3.0 with apache 2.0.46


这个perl脚本旨在处理我们开发的应用程序的付款过帐。它在我们的开发服务器上正常运行，运行apache

1.3.27在ES 2.1上


脚本挂起的生产服务器上我们看到上面的消息在ps

aux


我们为程序写了一个包装器，它将从命令行执行它

和一切都运行得很好


还有其他任何人都喜欢这样的东西吗？我应该降级

安装apache吗？


脚本使用Pg.pm并在
$ b一侧进行许多数据库调用$ b交易会话。从postgresql打开max debug没有yeilded

任何错误并放入我们自己的调试语句打印到STDERR到

转到apache日志也没事，因为我们可以'什么都看不见我们

杀了这个过程。那么它记得的内容会被转移到错误日志中。


Jon Pastore RHCE，总裁

IDE Tech，Inc。

（ 954）360-0393办公室

[phone]传真

公钥：< http://www.idetech.net/keys/jpastore.asc>
http://www.idetech.net/keys/jpastore。 asc

解决方案

2004年4月21日星期三下午09：12：27 -0400，Jon Pastore写道：

此perl脚本旨在处理我们开发的应用程序的付款过帐。它在我们的开发服务器上正常运行，该服务器在生成服务器上运行apache
1.3.27，脚本挂起，我们在ps
中看到上面的消息我们为程序编写了一个包装器，它将从命令行执行它
并且一切都运行起来

还有其他任何人都喜欢这样的东西吗？我应该降级apache的安装吗？

这是一个Perl脚本，为什么你不关心Perl版本？

如果你可以通过Perl调试器运行它，你应该可以看到

它挂在哪里。这可能是你最好的行动方案。

除此之外，开始在那里放一些printf'，看看它是挂在哪里的b $ b。 />

Michael

-

Michael Darrin Chaney
md ****** @ michaelchaney.com
http://www.michaelchaney.com/

---------------------- -----（播出结束）---------------------------

提示7：唐'别忘了增加你的免费空间地图设置

2004年4月21日星期三下午09:12:27 -0400，Jon Pastore写道：< blockquote class =post_quotes>此perl脚本旨在处理我们开发的应用程序的付款过帐。它在我们的开发服务器上正常运行，该服务器在生成服务器上运行apache
1.3.27，脚本挂起，我们在ps
中看到上面的消息我们为程序编写了一个包装器，它将从命令行执行它
并且一切都运行起来

还有其他任何人都喜欢这样的东西吗？我应该降级apache的安装吗？

这是一个Perl脚本，为什么你不关心Perl版本？

如果你可以通过Perl调试器运行它，你应该可以看到

它挂在哪里。这可能是你最好的行动方案。

除此之外，开始在那里放一些printf'，看看它是挂在哪里的b $ b。 />

Michael

-

Michael Darrin Chaney
md ****** @ michaelchaney.com
http://www.michaelchaney.com/

---------------------- -----（播出结束）---------------------------

提示7：唐'不要忘记增加你的可用空间地图设置

感谢你的回复......你说的是正确的

担心但是经过很多挫折之后我们发现pgsql认为那里

是一个正在进行中的交易，正在等待它完成时

事实上提交已经已经发生了。


我们最终做的是在提交或rollb之后确认我们会这样做。
undef

I have a strange error.

when I do a ps aux I get:

postgres 15018 0.0 0.6 9192 7396 ? S 09:20 0:00 /usr/bin/perl
/www/nexum/cgi-bin/accounting/posting/automatic_posting
postgres 15019 0.0 0.3 25696 4176 ? S 09:20 0:00 postgres:
postgres nexum [local]: idle

a little bit about the system.

It''s a Dell Power Edge 500 sc with 1G Mem and a PIII 1Ghz processor 40G HDD
running RHEL 3.0 with apache 2.0.46

This perl script is designed to handle payment posting for an application we
developed. It runs fine on our development server which is running apache
1.3.27 on ES 2.1

on the production server the script hangs and we see the above msg in "ps
aux"

we wrote a wrapper for the program that will exec it from the command line
and everything runs a-o-k

has anyone else encounted something like this? should I downgrade the
installation of apache?

the script is using Pg.pm and makes many database calls in side of a
transaction session. turning on max debug from postgresql has not yeilded
any errors and putting in our own debug statements to print to STDERR to
goto the apache log also yeilds nothing since we can''t see anything until we
kill the process. then what it remembers gets dumped to the error log.

Jon Pastore RHCE, President
IDE Tech, Inc.
[phone] Office
[phone] Fax
Public Key: <http://www.idetech.net/keys/jpastore.asc>
http://www.idetech.net/keys/jpastore.asc

解决方案

On Wed, Apr 21, 2004 at 09:12:27PM -0400, Jon Pastore wrote:

This perl script is designed to handle payment posting for an application we
developed. It runs fine on our development server which is running apache
1.3.27 on ES 2.1

on the production server the script hangs and we see the above msg in "ps
aux"

we wrote a wrapper for the program that will exec it from the command line
and everything runs a-o-k

has anyone else encounted something like this? should I downgrade the
installation of apache?

It''s a Perl script, so why aren''t you concerned about the Perl version?
If you can run it through the Perl debugger, you should be able to see
where it''s hanging. That''s probably your best course of action.
Barring that, start putting some printf''s in there to see where it''s
hanging.

Michael
--
Michael Darrin Chaney
md******@michaelchaney.com
http://www.michaelchaney.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings

On Wed, Apr 21, 2004 at 09:12:27PM -0400, Jon Pastore wrote:

This perl script is designed to handle payment posting for an application we
developed. It runs fine on our development server which is running apache
1.3.27 on ES 2.1

on the production server the script hangs and we see the above msg in "ps
aux"

we wrote a wrapper for the program that will exec it from the command line
and everything runs a-o-k

has anyone else encounted something like this? should I downgrade the
installation of apache?

It''s a Perl script, so why aren''t you concerned about the Perl version?
If you can run it through the Perl debugger, you should be able to see
where it''s hanging. That''s probably your best course of action.
Barring that, start putting some printf''s in there to see where it''s
hanging.

Michael
--
Michael Darrin Chaney
md******@michaelchaney.com
http://www.michaelchaney.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings

Thank you for your response...and you are correct that is something to be
concerned about but after much frustration we found that pgsql thought there
was a transaction in progress and was waiting for it to complete when in
fact the commit had already taken place.

What we ended up doing was after a commit or rollback we would

undef

这篇关于postgresql空闲的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！