Hi!
The size limit in InnoDB is 64 TB.
You have probably mixed up ibdata files or ib_logfiles. The ib_logfiles that you are using are probably completely zero-filled. No checkpoint info in them.
What does
mysqld-nt --console
print if you move the ib_logfiles away?
When creating new ibdata files, ib_logfiles, or moving those files to new locations, precisely follow the instructions at
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
http://dev.mysql.com/doc/mysql/en/Backing_up.html (a cold backup is like moving the files to a new location).
Keep in mind that in InnoDB, ib_logfiles are as important as ibdata files. You must not forget ib_logfiles.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL support from http://www.mysql.com/support/index.html
/************************************************************ Looks for the maximum consistent checkpoint from the log groups. */ static ulint recv_find_max_checkpoint( /*=====================*/ /* out: error code or DB_SUCCESS */ log_group_t** max_group, /* out: max group */ ulint* max_field) /* out: LOG_CHECKPOINT_1 or LOG_CHECKPOINT_2 */ { log_group_t* group; dulint max_no; dulint checkpoint_no; ulint field; byte* buf;
group = UT_LIST_GET_FIRST(log_sys->log_groups);
max_no = ut_dulint_zero; *max_group = NULL;
buf = log_sys->checkpoint_buf;
while (group) { group->state = LOG_GROUP_CORRUPTED;
for (field = LOG_CHECKPOINT_1; field <= LOG_CHECKPOINT_2;
field += LOG_CHECKPOINT_2 - LOG_CHECKPOINT_1) {
log_group_read_checkpoint_info(group, field);
if (!recv_check_cp_is_consistent(buf)) { if (log_debug_writes) { fprintf(stderr, "InnoDB: Checkpoint in group %lu at %lu invalid, %lu\n", group->id, field, mach_read_from_4(buf + LOG_CHECKPOINT_CHECKSUM_1));
}
goto not_consistent; }
group->state = LOG_GROUP_OK;
group->lsn = mach_read_from_8(buf + LOG_CHECKPOINT_LSN); group->lsn_offset = mach_read_from_4(buf + LOG_CHECKPOINT_OFFSET); checkpoint_no = mach_read_from_8(buf + LOG_CHECKPOINT_NO);
if (log_debug_writes) {
fprintf(stderr,
"InnoDB: Checkpoint number %lu found in group %lu\n",
ut_dulint_get_low(checkpoint_no), group->id);
}
if (ut_dulint_cmp(checkpoint_no, max_no) >= 0) { *max_group = group; *max_field = field; max_no = checkpoint_no; }
not_consistent: ; }
group = UT_LIST_GET_NEXT(log_groups, group); }
if (*max_group == NULL) {
fprintf(stderr, "InnoDB: No valid checkpoint found.\n" "InnoDB: If this error appears when you are creating an InnoDB database,\n" "InnoDB: the problem may be that during an earlier attempt you managed\n" "InnoDB: to create the InnoDB data files, but log file creation failed.\n" "InnoDB: If that is the case, please refer to\n" "InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html\n");
return(DB_ERROR); }
return(DB_SUCCESS); } .... MySQL 4.0.14 InnoDB (File size as it stands at present) = 6 GB We have tried move the data folder from one hard disk to another still the same problem. We really are in need of help here. Is there any size limit in InnoDB?
I did ask this before, I did get some reponse thank you. But due to the nature of the problem I'm give it another try.
On trying to start Mysqld-nt --console the following appears.
InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to section 3.1 of InnoDB: http://www.innodb.com/ibman.html 041123 13:38:36 Can't init databases 041123 13:38:36 Aborting
041123 13:38:36 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! 041123 13:38:36 mysqld-nt: Shutdown Complete
regards
___________________________________________________________
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]