View Incident Report

Serious

Reported By: Bruno Riviere
Reported On: 9/3/2010
For: Version 2.04 Build 2

# 3306 UPDATE Statements that Use Sub-Queries for Assignment Can Cause Dangling Catalog Read Lock

I have found a problem when I do this :

I Have two Database :
- Database 1 : BIBLE_ESTIM
- Database 2 : AFFAIRE_ESSAI AJOUT 1_ESTIM

I do the following query in the database BIBLE_ESTIM. This query is working good

Now, I want to create a view in the database AFFAIRE_ESSAI AJOUT 1_ESTIM

When I execute the CREATE VIEW, I have this error message :

ElevateDB Error #300 Cannot lock the catalog AFFAIRE_ESSAI AJOUT 1_ESTIM in the database AFFAIRE_ESSAI AJOUT 1_ESTIM for write access

Query:

UPDATE Per SET
Montant = (SELECT SUM(VALEUR) AS SomV FROM "AFFAIRE_ESSAI AJOUT 1_ESTIM".ListePerso
WHERE (CODE = 'A.') OR (CODE = 'B.') OR (CODE = 'C.'))
WHERE (Projet = 'ESSAI AJOUT 1')

View:

CREATE VIEW Vue1 AS SELECT CODE
FROM ListePerso
WHERE (CODE LIKE 'A.11%') AND (Etat = 'SF')

Resolution

Fixed Problem on 9/5/2010 in version 2.04 build 3

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap