[rt-users] Mysql Searchbuilder?

Brent Geach brent at telecom1.com
Wed Jun 4 05:25:07 EDT 2003


Yeah.
What Ive found now is

I send an email in (MTA is exim 4.20) usually when the attachment is 500k +, I
see it being acceppted into rt as:
Exim log:
2003-06-03 10:22:32 19N7zz-0000fF-P9 <= brent at telecom1.com
H=shadow.telecom1.com (shadow) [10.0.0.160] P=esmtp S=2795187 id=2003060309225

rt.log:
[Tue Jun  3 09:22:46 2003] [info]:
<rt-3.0.2pre6-5630-8706.0.491173828535807 at telecom1.com> #5630/8706 - Scrip 3
(/export/www/new/rt3/lib/RT/Action/SendEmail.pm:91)

then I wait for a while with no activity in either logs until
In exim log:
2003-06-03 10:25:35 19N7zz-0000fF-P9 ** |/export/www/new/rt3/bin/rt-mailgate
--queue sysadmin --action correspond --url http://localhost/
<rt-sysadmin at rt.telecom1.com> R=system_aliases T=address_pipe: Child process
of address_pipe transport returned 75 (could mean temporary error) from
command: /export/www/new/rt3/bin/rt-mailgate

And what gets mailed back to me is:


This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:

  pipe to |/export/www/new/rt3/bin/rt-mailgate --queue sysadmin --action
correspond --url http://localhost/
    generated by rt-sysadmin at rt.telecom1.com
    local delivery failed
    
The following text was generated during the delivery attempt:

------ pipe to |/export/www/new/rt3/bin/rt-mailgate --queue sysadmin --action
correspond --url http://localhost/
       generated by rt-sysadmin at rt.telecom1.com ------

An Error Occurred
=================

500 read timeout

------ This is a copy of the message, including all the headers. ------
------ The body of the message is 2794521 characters long; only the first
------ 106496 or so are included here.


I still dont get anything into the rt.log at this point
If I try goto ticket number 5630
In log I obviously see this
[Tue Jun  3 09:28:07 2003] [error]: WebRT: Could not load ticket 5630 ()
(/export/www/new/rt3/share/html/Elements/Error:54)

Now the odd part is (I was testing this extensivley yesterday with various
my.cnf options and somethimes I would get all the above but the ticket would
still be created with the attachment :-/ )

I was working yesterday on the presumption that something is locking up/timing
out somewhere, but I couldnt figure out where?

My current my.cnf file is as follows:

[client]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
thread_concurrency=8
log-bin
server-id       = 1
skip-locking
key_buffer = 512M
max_allowed_packet = 16M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 64M
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
set-variable = innodb_buffer_pool_size=1024M
set-variable = innodb_additional_mem_pool_size=128M
set-variable = innodb_log_file_size=256M
set-variable = innodb_log_buffer_size=64M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=100
[mysqldump]
quick
set-variable    = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

I just managed to get the mysql log working again and have seen that when I
send the attachment in mysql update log I can see the attachments starting to
be inserted and then I lose it all in binary and nothing in the error log.

I cant think of anything else that might help at the moment and am also stuck
as where else to look for the problem.

Brent


On Mon, 02 Jun 2003, Jesse Vincent wrote:

> 
> 
> On Mon, Jun 02, 2003 at 02:16:33PM +0100, Brent Geach wrote:
> > Converted all tables over to innodb and upgraded mysql to 4.0.1
> 
> you mean mysql 4.0.13, right?
>  
> 
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
Regards,

Brent              /"\
                   \ /
Linux Registered    X  ASCII Ribbon Campaign
User #309941       / \ Against HTML Mail




More information about the rt-users mailing list