[rt-users] Mysql Searchbuilder?

[Brent Geach]

Converted all tables over to innodb and upgraded mysql to 4.0.1

Now am seeing this:

[Mon Jun  2 13:12:47 2003] [warning]: DBD::mysql::st execute failed: Lock wait
timeout exceeded; Try restarting transaction at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 385.
 (/export/www/new/rt3/lib/RT.pm:226)
[Mon Jun  2 13:12:47 2003] [warning]: RT::Handle=HASH(0x90e5d3c) couldn't
execute the query 'INSERT INTO Tickets (Subject, Status, Queue, Creator,
Owner, LastUpdatedBy, Type, Starts, Resolved, Created, Priority, Due,
LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 392.
 (/export/www/new/rt3/lib/RT.pm:226)

Am I still missing something in my mysql config. I set the buffers and cache
etc for innodb to 512M etc etc

On Mon, 02 Jun 2003, Reini Urban wrote:

> This is because of mysql's MyISAM architecture.
> I would suggest to convert the table to type=InnoDB which does only 
> row-level locking, instead of table-locking on every update.
> 
> Here any previous update query is too slow (attachments are quite large) 
> and the insert is refused. Select's are also refused on MyISAM, but not 
> on InnoDB.
> 
> Brent Geach wrote:
> >Not sure what this is telling me but I see it every now and then in my rt
> >logs:
> >
> >[Fri May 30 10:30:26 2003] [warning]: DBD::mysql::st execute failed: MySQL
> >server has gone away at
> >/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 385.
> > (/export/www/new/rt3/lib/RT.pm:226)
> >[Fri May 30 10:30:26 2003] [warning]: RT::Handle=HASH(0x9d83d60) couldn't
> >execute the query 'INSERT INTO Attachments (Subject, ContentType, Filename,
> >Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId)
> >VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
> >/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 392.
> > (/export/www/new/rt3/lib/RT.pm:226)
> >[Fri May 30 10:30:26 2003] [info]: RT::Scrip=HASH(0x9f53b58): Couldn't 
> >prepare
> >Open Tickets (/export/www/new/rt3/lib/RT/Scrip_Overlay.pm:338)
> >
> >This is when someone is trying to email an attachment into rt and the
> >attachments then fail 
> >this is on rt3.0.2 and DBISearchbuilder0.81_04
> -- 
> Reini Urban - Programmer - http://inode.at
> 

-- 
Regards,

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