Hello *
reproducable Problem:
Content of UNION:
logs_20040608,logs_20040609,logs_20040611,logs_20040612,logs_20040613,logs_20040614,
logs_20040615
results: 0E0
DBD::mysql::db do failed: Can't open file: '#sql-13c1_12.MRG'. (errno: 144) at
/usr/local/sbin/new_MERGE_table.pl line 276.
Unable to ALTER TABLE logs UNION=(
logs_20040608,logs_20040609,logs_20040611,logs_20040612,logs_20040613,logs_20040614,
logs_20040615 ) INSERT_METHOD=LAST: !Can't open file: '#sql-13c1_12.MRG'. (errno: 144)
Can anyone see a conceptional misunderstandig, i make ?
in pseudocode do the following using perl dbi:
1. FLUSH TABLES
# take out all "old tables from merge in order to compress the most recent
2. ALTER TABLE logs UNION (log_"today) INSERT_METHOD=LAST;
3. FLUSH TABLES; # make mysql use the new merge table
3. mysiampack / mysiamcheck (log_yesterday)
4. FLUSH TABLES # just in case
5. ALTER TABLE logs UNION ( last_tenlogs, log_today) INSERT_METHOD=LAST;
<- here the problem arises, i assume triggered by "yesterdays table" in the list of
last_tenlogs
>@commands = ( "FLUSH TABLES", "ALTER TABLE $LOGTABLE UNION=( $COMMA_TABLE_SET
>$newTABLE ) INSERT_METHOD=LAST");
>for ( @commands){
> $results=$dbh->do($_) or die "Unable to $_: !" . $dbh->errstr . "\n";
(COMMA_TABLE_SET is a list of commaseparated table names, ending with a comma)
TIA
Micha
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
