473,320 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem with merge tables in 4.1

Hi,

I was working on some merge tables this morning and it worked fine, but
after a few unsuccessful table creation requests (I was making some
tests), I could not alter or select from a table for the following reason:

mysql> create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE
UNION=(countries);
Query OK, 0 rows affected (0.00 sec)

mysql> select * from test_table;
ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143)

mysql> check table test_table;
+-------------------------+-------+----------+-------------------------------------------------+
| Table | Op | Msg_type |
Msg_text |
+-------------------------+-------+----------+-------------------------------------------------+
| statscounter.test_table | check | error | Can't open file:
'test_table.MRG'. (errno: 143) |
+-------------------------+-------+----------+-------------------------------------------------+
1 row in set (0.00 sec)

mysql> repair table test_table;
+-------------------------+--------+----------+-------------------------------------------------+
| Table | Op | Msg_type |
Msg_text |
+-------------------------+--------+----------+-------------------------------------------------+
| statscounter.test_table | repair | error | Can't open file:
'test_table.MRG'. (errno: 143) |
+-------------------------+--------+----------+-------------------------------------------------+
1 row in set (0.00 sec)

I then dropped the table and attempted to create a new one, with no
success. Also tried another table name, or putting the table in another
database, and that did not work either. Since it worked earlier, I tried
restarting the MySQL server, but that didn't correct the problem either.

Do you have any idea of what I'm doing wrong, or what needs to be done
to get rid of that error?

I thought about submitting a bug report but do not know how this error
could be reproduced on another machine.

I am running 4.1.0 on dual-CPU debian box with SCSI RAID hard drives, if
that can help.

Thanks!

Pierre-Luc Soucy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1764

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Bruce Stockwell | last post by:
the setup: Webservice/WinClient application/SQL server. VS.Net (visual basic) winform wizard creates a simple form with load cancel cancelall and datagrid bound to a simple Dataset with one...
5
by: Grim Reaper | last post by:
I know this should be easy (I think), but I can not figure out how to do it. Basically, I have 4 tables (2 tables with 2 subordinate tables) that have an INQ_ID key that was created by using...
0
by: Allen | last post by:
We converted our app from 1.1 to 2 and some code was no longer working. The case: From a non typed datatable, convert it to a typed one. How to reproduce the bug: -------------------------------...
0
by: mbbostwick | last post by:
I have a problem with a mail merge procedure I used to use with Access '97. We recently converted to Office XP (2002) and I now have an issue I am unfamilliar with and have been unable to...
16
by: UDBDBA | last post by:
Hi All: I need some clarification on a MERGE statement. The database is on V8 FP12 (AIX) 64bit. The source table is tableA. The target is a View "FACT" with UNION ALL because of the 512 Gig...
5
by: Mark Chambers | last post by:
Hi there, Can anyone explain the following (very) simple scenario. 1) I make an exact copy of my "DataSet" and delete one record from a given table (in the copy) 2) I invoke...
7
by: giladp1 | last post by:
I found Albert Kallal's great "Super easy Word Merge" code in his site at: http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html Thanks Albert so much for sharing this. I am looking...
0
by: Dave.Womer | last post by:
All, I'm having an issue merging datasets. It seems everytime I peform a merge of new data on existing data all of the rows of the existing data are modified even if the new data does not...
1
by: joproulx | last post by:
Hello all, Here is my problem: I am trying to merge 2 datasets but I don't want to overwrite rows that are already modified in my working dataset. Example: I have one Dataset with only one...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.