On Tuesday 07 February 2006 12:27, Marcus Rueckert wrote:

On 2006-02-06 19:56:13 +0100, Branko F. Gračnar wrote:

...

I just couldn't login to my dovecot imap (1.0-beta2). Dovecot authenticates from mysql database.

Feb 6 19:47:33 elfstone dovecot: auth-worker(default_with_listener): sql(damirh@noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:47:52 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes) Feb 6 19:47:52 elfstone dovecot: auth-worker(default_with_listener): sql(bfg@noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes) Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): sql(bfg@noviforum.si): User query failed: MySQL client run out of memory Feb 6 19:48:19 elfstone dovecot: auth-worker(default_with_listener): ^GOut of memory (Needed 8164 bytes)

Restarting dovecot solved the problem. Ofcourse, machine didn't run into memory problems.

Slackware 9.1, linux 2.6.

what was the memory usage of the auth process?

Honestly, i don't know, becouse i immediately restarted dovecot, becouse is in a production. I will report this when this issue will accour again.

Oh, i forgot to mention: i have mysql 4.0.17 installed.

do you have any ulimits set for it?

# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 12287 virtual memory (kbytes, -v) unlimited

Best regards, Brane