[MDEV-9875] ERROR 1050 Table already exists Created: 2016-04-06 Updated: 2016-05-09 Resolved: 2016-05-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Procedure |
| Affects Version/s: | 5.5.47 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Blocker |
| Reporter: | anuj dhiman | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Ubuntu 14.04.1 |
||
| Description |
|
I Want to create table family Using this command : CREATE TABLE `FAMILY` ( `FAMILY_ID` bigint(20) NOT NULL, `PERSON_ID` bigint(20) DEFAULT NULL, `CREATED_BY` varchar(45) DEFAULT NULL, `LAST_UPDATED_BY` varchar(45) DEFAULT NULL, `LAST_UPDATED_DT` datetime DEFAULT NULL, `STATUS` varchar(45) DEFAULT NULL, PRIMARY KEY (`FAMILY_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; I got the result : > desc FAMILY; I got result : ERROR 1146 (42S02): Table 'bfm.FAMILY' doesn't exist I use show tables command and got family table doesn't exist. * But I am not able to create family table .* |
| Comments |
| Comment by Elena Stepanova [ 2016-04-08 ] |
|
Please check your error log for errors and warnings. This usually happens if the table used to be there, and remains of it still are, but on some reason it is not readable anymore. |
| Comment by Elena Stepanova [ 2016-05-09 ] |
|
Please comment to re-open if you have further information on the issue. |