MySQL Forums
Forum List  »  Performance

its getting stuck
Posted by: Srivats Chandrasekaran
Date: December 02, 2005 05:39AM

Create table nb_pool_master
(
nb_pool_number Char(6) NOT NULL,
nb_pool_type Char(2) NOT NULL,
nb_issue_date Date NOT NULL,
nb_cusip Char(9) NOT NULL,
nb_maturity_date Date NOT NULL,
nb_original_balance Double NOT NULL,
nb_coupon Double NOT NULL,
nb_seller_code Integer NOT NULL,
nb_original_wac Double NOT NULL,
nb_original_warm Integer NOT NULL,
nb_legend_1 Char(60) NOT NULL,
nb_legend_2 Char(60) NOT NULL,
nb_investor_tax_flag_1984 Char(1) NOT NULL,
nb_investor_tax_flag_1985 Char(1) NOT NULL,
nb_percent_unpaid_balance_pre_1984 Double NOT NULL,
nb_percent_unpaid_balance_pre_1985 Double NOT NULL,
nb_loan_longest_maturity_date Date NOT NULL,
nb_original_nol_est Integer NOT NULL,
nb_original_nol Integer NOT NULL,
nb_original_wala Integer NOT NULL,
nb_original_loan_size Integer NOT NULL,
nb_original_loan_size_est Integer NOT NULL
) ENGINE = InnoDB;


when i try to insert a record

INSERT INTO nb_pool_master(nb_pool_number,nb_pool_type,nb_issue_date,nb_maturity_date,nb_original_balance,nb_coupon,nb_seller_code,nb_original_wac,nb_original_warm,nb_cusip,nb_legend_1,nb_legend_2)VALUES('1B2417','1B','2005-10-01','2035-11-01','10810346.00','5.036','10','5.511','360','3128JMSF5','','')//


The db is just getting stuck, and
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
In the above insert statement when i try to execute with different pool_number keeping all the other data same its getting execute, which is kind of starnge.

This insert is happening inside a store procedure , which is getting stuck ibecause of this insert statement. Some times its taking about 45 seconds, but most of the times its getting stuck and the lock wait time is exceeded.

I am calling the store proc from java in a loop . Its executing for some thousand records after which the java process just hangs because the store procedure doesnt return any value. The previous records also call the same store proc albeit with different values. Any pointers onto what might be the problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
its getting stuck
1751
December 02, 2005 05:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.