POPFile トラブル

id:amatubu:20040908#c さんとこにコメントした件の続き。


[fuga-PowerBook:~] hoge% cd /Library/POPFile/
[fuga-PowerBook:/Library/POPFile] hoge% sudo perl -Ilib popfile.pl
Password:
まずはコマンドラインから起動。

POPFile Engine loading

Loading...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

POPFile Engine v0.22.0 starting

Initializing...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

Starting...


A copy of POPFile appears to be running.
Attempting to signal the previous copy.
Waiting 10 seconds for a reply.

A copy of POPFile is running.
It has signaled that it is alive with process ID: 3107
Failed to start while starting the config module at /POPFile/Loader.pm line 647.
{core:[fuga-PowerBook:/Library/POPFile] hoge% ls -ltr | grep popfile.pid
-rw-r--r-- 1 root staff 5 9 Sep 20:46 popfile.pid

他に起動してる…?プロセスは起動してないはずなんだけど、pidファイルはあるなぁ。

[fuga-PowerBook:/Library/POPFile] hoge% cat popfile.pid
3107
[fuga-PowerBook:/Library/POPFile] hoge% mv popfile.pid popfile.pid_old
[fuga-PowerBook:/Library/POPFile] hoge% cat popfile.pid
3107
[fuga-PowerBook:/Library/POPFile] hoge% ls -ltr | grep popfile.pid
-rw-r--r-- 1 root staff 5 9 Sep 20:46 popfile.pid_old
-rw-r--r-- 1 root staff 5 9 Sep 20:47 popfile.pid
あれ?cpじゃなくてmvしたのに…?

[fuga-PowerBook:/Library/POPFile] hoge% ps auxww|grep perl
root 3107 0.3 0.4 38016 4236 std- S 10:05AM 7:49.85 perl -Ilib ./popfile.pl
hoge 16804 0.0 0.0 18172 336 std S+ 8:47PM 0:00.00 grep perl
[fuga-PowerBook:/Library/POPFile] hoge% sudo kill 3107
kill: 3107: No such process
あれ?なんかおかしいな。

[fuga-PowerBook:/Library/POPFile] hoge% sudo perl -Ilib popfile.pl

POPFile Engine loading

Loading...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

POPFile Engine v0.22.0 starting

Initializing...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

Starting...


A copy of POPFile appears to be running.
Attempting to signal the previous copy.
Waiting 10 seconds for a reply.

The other POPFile (3107) failed to signal back, starting new copy (17054)
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html}
{proxy: nntp pop3 smtp}
{services: imap}

POPFile Engine v0.22.0 running

なんとか起動したみたいだなぁ。とりあえず再起動してみるか。

[fuga-PowerBook:~] hoge% ps auxww|grep pop
root 296 0.5 1.1 35408 11776 ?? S 8:54PM 0:07.59 perl -Ilib ./popfile.pl
hoge 956 0.0 0.0 8860 8 std R+ 9:01PM 0:00.00 grep pop
動いてる。受信してみると……

[fuga-PowerBook:~] hoge% ps auxww | grep pop
hoge 3414 0.0 0.0 8860 8 std R+ 9:21PM 0:00.00 grep pop
落ちた。

[fuga-PowerBook:~] hoge% cd /Library/POPFile/
[fuga-PowerBook:/Library/POPFile] hoge% sudo perl -Ilib popfile.pl
Password:

POPFile Engine loading

Loading...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

POPFile Engine v0.22.0 starting

Initializing...
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html xmlrpc}
{proxy: nntp pop3 smtp}
{services: imap}

Starting...


A copy of POPFile appears to be running.
Attempting to signal the previous copy.
Waiting 10 seconds for a reply.

The other POPFile (296) failed to signal back, starting new copy (3468)
{core: config history logger mq}
{classifier: bayes wordmangle}
{interface: html}
{proxy: nntp pop3 smtp}
{services: imap}

POPFile Engine v0.22.0 running

で受信すると…

Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 6.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 6.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 6.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 6.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 6.
DBD::SQLite::db do failed: database is locked at /POPFile/History.pm line 326, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 6.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 6.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 6.
DBD::SQLite::db do failed: database is locked at /POPFile/History.pm line 326, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 6.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 6.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 6.
DBD::SQLite::st execute failed: database is locked at /Classifier/Bayes.pm line 3155, <$reader> line 2.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 6.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 7.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 7.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 6.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 7.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 7.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 7.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 7.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 7.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 7.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 8.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 8.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 8.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 8.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 8.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 8.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 8.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 8.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 9.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 9.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 9.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 9.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 9.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 9.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 9.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 9.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 10.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 10.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 10.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 10.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 10.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 10.
DBD::SQLite::st execute failed: database is locked at /Classifier/Bayes.pm line 3155, <$reader> line 2.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 10.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 10.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 11.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 11.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 11.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 11.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 11.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 11.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 11.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 11.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 12.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 12.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 12.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 12.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 12.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 12.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 12.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 12.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 13.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 13.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 13.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 13.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 13.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 13.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 13.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 13.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 14.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 14.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 14.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 14.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 14.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 14.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 14.
DBD::SQLite::st execute failed: database is locked at /Classifier/Bayes.pm line 3155.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 14.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 15.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 15.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 15.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 15.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 15.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 15.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 15.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 15.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 16.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 16.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 16.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 16.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 16.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 16.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 16.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 16.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 17.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 17.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 17.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 17.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 17.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 17.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 17.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 17.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 18.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 18.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 18.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 18.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 18.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 18.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 18.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 18.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 19.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 19.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 19.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 19.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 19.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 19.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 19.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 19.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 20.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 20.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 20.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 20.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 20.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 20.
DBD::SQLite::st execute failed: database is locked at /Classifier/Bayes.pm line 3155, <$reader> line 3.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755, <$reader> line 3.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 20.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 20.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 21.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 21.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 21.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 21.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 21.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 21.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 21.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 21.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 22.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 22.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 22.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 22.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 22.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 22.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 22.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 22.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 314, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 314, line 6.
Use of uninitialized value in subroutine entry at /POPFile/History.pm line 331, line 6.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 331, line 6.
Use of uninitialized value in concatenation (.) or string at /POPFile/History.pm line 336, line 6.
Use of uninitialized value in sprintf at /POPFile/History.pm line 755, line 6.
Use of uninitialized value in concatenation (.) or string at /Classifier/Bayes.pm line 2522, line 6.
Use of uninitialized value in join or string at /POPFile/MQ.pm line 374, line 6.
Argument "" isn't numeric in sprintf at /POPFile/History.pm line 755.
DBD::SQLite::db do failed: near ";": syntax error at /POPFile/History.pm line 643.
となりメーラーからは接続が切れたように見える様。
POPFile自体は落ちていないようなので、もう一度受信すると大丈夫。*1
こんなとこです。わかりずらくてごめんなさい。

あ、Webインターフェイスにアクセスすると落ちる。これがトリガーかな?


Use of uninitialized value in subroutine entry at /POPFile/History.pm line 996.
DBD::SQLite::db selectrow_arrayref failed: at /POPFile/History.pm line 996.
Can't use an undefined value as an ARRAY reference at /POPFile/History.pm line 996.

*1:4つのアカウントを同時に受信するのが悪いのだろうか?1アカウントづつ受信すると落ちない。