[postfix-jp: 4202] Re: 451 4.3.0 Error:queue file write error という現象について

[ettodesu@xxxxxxxxxxxxxx]

さとう　様

ご連絡ありがとうございます。


> mysql_table(5) の内容はどんな感じになっていますか?
> (パスワード等、隠したい情報は隠してくださいね)

下記内容であってますか？（mysql_table(5) って？な状態です・・・）
$ cat /etc/postfix/mysql_virtual_mailbox_maps.cf
hosts    = localhost
dbname   = postfix
user     = postfix
password = aiueo
query    = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1'

$ cat /etc/postfix/mysql_virtual_alias_maps.cf
hosts    = localhost
dbname   = postfix
user     = postfix
password = aiueo
query    = SELECT goto FROM alias WHERE address='%s' AND active = '1'

$ cat /etc/postfix/mysql_virtual_domains_maps.cf
hosts    = localhost
dbname   = postfix
user     = postfix
password = aiueo
query    = SELECT description FROM domain WHERE domain='%s' AND active = '1'

port を記述していないのがマズいんでしょうか？



> wait_timeout を増やすと多少改善されませんかね?

wait_timeout を 60 ⇒ 120 に少しあげました。
ちょっとだけマシになったような気がします (^^;)



ところで新たなる発見です。
mysql の Threads_connected 数は最大でも今のところ33 、平均で12 程度ですが mysql のスレッド数はいくつくらいだろう？
と思い下記コマンドを打つと・・・
$ ps -efL | grep -e mysqld -e PID | grep -v grep
UID        PID  PPID   LWP  C NLWP STIME TTY          TIME CMD
root      3817     1  3817  0    1  2012 ?        00:00:00 /bin/sh /usr/local/mysql5/bin/mysqld_safe…
mysql     4516  3817  4516  0  110  2012 ?        00:00:59 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4518  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4519  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4520  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4521  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4522  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4523  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4524  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4525  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4526  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4527  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4529  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4530  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4531  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4532  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4535  0  110  2012 ?        00:00:00 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4542  0  110  2012 ?        00:00:22 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4980  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4988  0  110  2012 ?        00:06:01 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  4991  0  110  2012 ?        00:00:24 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  7192  0  110  2012 ?        00:00:24 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  9689  0  110  2012 ?        00:00:21 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  9705  0  110  2012 ?        00:00:21 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 15357  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 15358  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 12328  0  110  2012 ?        00:00:23 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 16715  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  8055  0  110  2012 ?        00:00:21 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 13848  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 28656  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 28394  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 28395  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 11641  0  110  2012 ?        00:00:22 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 11642  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 11643  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 11646  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 27815  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 27823  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1110  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1111  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1142  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1263  0  110  2012 ?        00:00:22 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1340  0  110  2012 ?        00:01:35 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1347  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1354  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1357  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1360  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1362  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1366  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1367  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1372  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  1373  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 32474  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  3704  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  3707  0  110  2012 ?        00:00:20 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  3708  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  3736  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  3929  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 14942  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 19975  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20048  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20078  0  110  2012 ?        00:00:16 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20079  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20749  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20750  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20752  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20753  0  110  2012 ?        00:00:18 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20754  0  110  2012 ?        00:00:16 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20755  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20765  0  110  2012 ?        00:00:16 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20766  0  110  2012 ?        00:00:16 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20768  0  110  2012 ?        00:00:21 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20769  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20771  0  110  2012 ?        00:00:19 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20772  0  110  2012 ?        00:00:16 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20806  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20807  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 20840  0  110  2012 ?        00:00:17 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21516  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21517  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21540  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21541  0  110 Jan08 ?        00:00:11 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21544  0  110 Jan08 ?        00:00:10 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21545  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21550  0  110 Jan08 ?        00:00:10 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21551  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21554  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21555  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21558  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21560  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21562  0  110 Jan08 ?        00:00:10 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21563  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21566  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21567  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21571  0  110 Jan08 ?        00:00:10 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21572  0  110 Jan08 ?        00:00:12 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21574  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 21575  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 24064  0  110 Jan08 ?        00:00:09 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 25646  0  110 Jan08 ?        00:00:08 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 25647  0  110 Jan08 ?        00:00:08 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 25650  0  110 Jan08 ?        00:00:11 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 25651  0  110 Jan08 ?        00:00:08 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 30807  0  110 Apr02 ?        00:00:03 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 30808  0  110 Apr02 ?        00:00:03 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  7049  0  110 Apr02 ?        00:00:03 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817  7204  0  110 Apr02 ?        00:00:06 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 31651  0  110 Apr02 ?        00:00:04 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 31653  0  110 Apr02 ?        00:00:03 /usr/local/mysql5/bin/mysqld …
mysql     4516  3817 31724  0  110 Apr02 ?        00:00:02 /usr/local/mysql5/bin/mysqld …

と 112 個ものスレッドが　(゜ロ゜;
Jan08　の日付がありますが、logwatch で　-- deferring delivery のエラーが出だしたのが 1/9 からなので、
ピッタリあう！（4/2 もありますが、これは不明）

mysql のゾンビスレッドが原因だったんでしょうか？
これは、postfix を停止して mysql を再起動するしかないでしょうか？(;´ρ`)

postfix のML なのに mysql の話題になってしまい申し訳ないです。
よろしくお願いします。

_______________________________________________
Postfix-jp-list mailing list
Postfix-jp-list@xxxxxxxxxxxxxxxxxxxx
http://lists.sourceforge.jp/mailman/listinfo/postfix-jp-list