Ok... this error has just started popping up in my .err log file...
070618 14:31:10 InnoDB: ERROR: the age of the last checkpoint is
237821842,
InnoDB: which exceeds the log group capacity 237813351.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
070618 14:39:17 InnoDB: ERROR: the age of the last checkpoint is
237829009,
InnoDB: which exceeds the log group capacity 237813351.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
On 18/06/2007, at 12:09 PM, Baron Schwartz wrote:
I'm out of ideas right now. I don't actually use mysqldump that
much and have never had this happen. Hopefully someone else on the
mailing list can help, or perhaps you can try #mysql on Freenode IRC.
Baron
Hartleigh Burton wrote:
No there is no indication of that at all. The server service
appears to be in perfect order, does not drop/restart and my other
applications continue to function without any interruption.
It appears as if the mysqldump connection to the server is
interrupted or maybe there is something in row 1 of `trackdata`
that it does not like. This table contains a long blob field which
at present does not contain any more than ~80MB per row. I also
use the --hex-blob flag for mysqldump to try and get around any
possible problems with exporting this data... I have no
descriptive error messages anywhere and it is driving me nuts :|
On 18/06/2007, at 11:27 AM, Baron Schwartz wrote:
Is there any indication that the mysqldump crash is killing the
server and causing it to restart? For example, "ready for
connections" notifications just after you try a mysqldump?
Hartleigh Burton wrote:
Hmmmm no there are no new errors in there. Nothing out of the
ordinary thats for sure. Just notifications that MySQL has
started and is accepting connections etc. :|
On 18/06/2007, at 11:06 AM, Baron Schwartz wrote:
How about in c:\Program Files\MySQL\MySQL Server 5.0\data
\<hostname>.err?
Cheers
Baron
Hartleigh Burton wrote:
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test
phase. It is containing uncompressed audio and is expected
to reach 1.5TB in no time at all. I am just running some
backup tests and I have been having lots of problems
creating an accurate backup.
I have tried both MySQL Administrator & mysqldump, both
applications drop out on the same table, the table
`trackdata` which contains ~9GB worth of data. There is no
single row any larger than 50MB, most average around 40MB.
Windows 2000 Server, MySQL v5.0.37-community-nt and all
tables are InnoDB.
[snip]
-- Retrieving rows...
-- Retrieving table structure for table trackdata...
-- Sending SELECT query...
-- Retrieving rows...
mysqldump: Error 2013: Lost connection to MySQL server
during query when dumping
table `trackdata` at row: 1
You might be able to find more information about the precise
error in the server's error logs. That will give us a better
idea what might be wrong, if there is an error server-side,
which seems likely to me.
Baron
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
--MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!