Archive

Archive for March, 2012

ERROR 1005 (HY000): Can’t create table ‘socialmm.#sql-7993_d’ (errno: 121)

March 15, 2012 Leave a comment

I run a patching script for my MySQL DB, it shows the following errors. I search the scripts and find no create table ddl. Why the errors comes out ?.

ERROR 1005 (HY000): Can’t create table ‘socialmm.#sql-7993_d’ (errno: 121)

Finally,  I find out some hints from ” http://www.linuxidc.com/Linux/2011-09/43489.htm”. try to run the command below. The cause of the problem can be found out.

MYSQL> SHOW ENGINE INNODB STATUS\G

 

————————

LATEST FOREIGN KEY ERROR

————————

120314 15:53:49 Error in foreign key constraint creation for table `socialmm`.<result 2 when explaining filename ‘#sql-7993_d’>.

A foreign key constraint of name `socialmm`.`fk_CASE_REPLIES_CASES`

already exists. (Note that internally InnoDB adds ‘databasename’

 

Advertisements
Categories: mySQL troubleshooting

ERROR 1146 (42S02)

March 15, 2012 Leave a comment

Today, I duplicate a production database for testing updating script. Once I apply the script, it shows  errors below. I am sure that all tables are existing.

mysql> source 1b2aScriptAlter.sql

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table ‘socialMM.TEAM_USER’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.AUDIT_ACTIONS’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.MSGSTATE_0001’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.SIP_OFFLINE_MSG’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.PERSONAL_MESSAGES’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.PRIVILEGE’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.USERS’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.IM_ACCOUNTS’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.IM_ACCOUNTS’ doesn’t exist

ERROR 1146 (42S02): Table ‘socialMM.REALM_USER’ doesn’t exist

Finally, I compare the setting between my testing db and the production database. The variable “lower_case_table_names” in the production is set to “1”, but in my testing db default value is “0”. Finally, I see that default table_names is case sensitive. So that I set the variable to ‘1’ and restart the testing database. The errors are gone.

 

 

 

 

 

Categories: mySQL troubleshooting

root.sh failed when installing 11GR2 Grid Infrastructure

March 2, 2012 Leave a comment

Fixed Procedure

1. De-configure nodes except the last one

#$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force

2: Clean up OCR and Voting disk at the last node

$GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode.

3. Rerun the root.sh command at each node

 

 

Categories: Oracle Installation