Bug 134148

Summary: databases/mysql50-server: InnoDB fails after upgrading MySQL from 5.0.51 to 5.077 on FreeBSD 6.2
Product: Ports & Packages Reporter: Mark Stosberg <mark>
Component: Individual Port(s)Assignee: Alex Dupre <ale>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   

Description Mark Stosberg 2009-05-01 23:20:00 UTC 
There is a bug when upgrading MySQL from 5.0.55 to MySQL 5.0.77 on FreeBSD, such that InnoDB no longer works.  The error when starting is:

InnoDB: Unable to lock ./ibdata1, error: 22

Several others have experienced this issue and reported it to the MySQL project here:

http://bugs.mysql.com/bug.php?id=40621

But so far, the upstream project has not taken interest in a resolution.

Fix: 

Manually downgrading works around the issue.
How-To-Repeat: Upgrade the mysql50 port the usual way on FreeBSD 6.2
Comment 1 Mark Linimon freebsd_committer freebsd_triage 2009-05-02 08:45:41 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->ale

Fix synopsis and assign.
Comment 2 Michael Scheidell 2009-05-26 16:47:56 UTC 
Ping... but mostly will need to close this.  Freebsd 6.2 isn't supported 
anymore.  if this doesn't work in Freebsd 6.4, you should resubmit.


-- 
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
 > *| *SECNAP Network Security Corporation

    * Certified SNORT Integrator
    * 2008-9 Hot Company Award Winner, World Executive Alliance
    * Five-Star Partner Program 2009, VARBusiness
    * Best Anti-Spam Product 2008, Network Products Guide
    * King of Spam Filters, SC Magazine 2008

_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r). 
For Information please see http://www.secnap.com/products/spammertrap/
_________________________________________________________________________
Comment 3 Martin Wilke freebsd_committer freebsd_triage 2009-07-18 10:50:53 UTC 
State Changed
From-To: open->closed

Freebsd 6.2 isn't supported anymore. if this doesn't work in Freebsd 
6.4, you should resubmit.