문제가 됐던
EBF_CUSTOMERPROFILEINFO 테이블의 타입을 MYISAM으로
바꾸니까 별 문제 없이 되는군요..
음...결국 Transaction의 문제였는데...쩝~
>>때미리 님께서 쓰시길<<
:: BDB 타입으로 모든 테이블을 만든후
:: Query 에서 이상한 에러가 생기는데요..
:: 아래 쿼리를 잘 보시면
:: select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
:: 란 쿼리를 날리기전의 쿼리가 결과가 있으면 위의 쿼리는 에러가
:: 없지만, 날리기전의 쿼리의 결과 없으면 위의 쿼리는 에러가
:: 납니다.
:: outer join이 트랜잭션과 관련이 있어서 그런가요?
:: 여하튼 이유를 잘 모르겠습니다...
::
::
:: mysql> select p.*,
:: -> a.addressno,
:: -> a.customerid,
:: -> a.customername1,
:: -> a.customername2,
:: -> a.customername3,
:: -> a.street1,
:: -> a.street2,
:: -> a.street3,
:: -> a.city,
:: -> a.state,
:: -> a.country,
:: -> a.zipcode,
:: -> a.phone1,
:: -> a.phone2,
:: -> a.fax,
:: -> a.email,
:: -> a.address,
:: -> c.*
:: -> from EBF_CUSTOMER c,
:: -> EBF_ADDRESSBOOK a
:: -> left join EBF_CUSTOMERPROFILE p on c.customerid=p.customerid
:: -> where c.customerid=a.customerid and
:: -> c.customerid='admin';
:: +------------+-------------+-----------+------------+---------------+----------
:: .......어쩌구저쩌구 결과.....
:: -----+------+-------+---------+---------+-------------+--------+------+-------1 row in set (0.01
:: sec)
::
:: mysql> select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
:: Empty set (0.01 sec) <=== 에러가 안나죠..
::
:: mysql> select p.*,
:: -> a.addressno,
:: -> a.customerid,
:: -> a.customername1,
:: -> a.customername2,
:: -> a.customername3,
:: -> a.street1,
:: -> a.street2,
:: -> a.street3,
:: -> a.city,
:: -> a.state,
:: -> a.country,
:: -> a.zipcode,
:: -> a.phone1,
:: -> a.phone2,
:: -> a.fax,
:: -> a.email,
:: -> a.address,
:: -> c.*
:: -> from EBF_CUSTOMER c,
:: -> EBF_ADDRESSBOOK a
:: -> left join EBF_CUSTOMERPROFILE p on c.customerid=p.customerid
:: -> where c.customerid=a.customerid and
:: -> c.customerid='WWWanonymous';
:: Empty set (0.00 sec)
::
:: mysql> select profilename,displayname from EBF_CUSTOMERPROFILEINFO ;
:: ERROR 1015: Can't lock file (errno: -30989) <==에러가 납니다.
|