Re: D2W locking error
Re: D2W locking error
- Subject: Re: D2W locking error
- From: Chuck Hill <email@hidden>
- Date: Wed, 1 Dec 2010 19:10:09 -0800
On Dec 1, 2010, at 6:56 PM, Andrew R. Kinnie wrote:
> OK, well I did that, and even re-booted the machine. No change.
>
> In other news if I eliminate my second sort ordering, the previously missing booking appears.
That sounds like maybe you have a inner join where you want an outer join.
> I changed it to use ERXSortOrdering and get the same result.
>
> I need a beer.
Under these circumstances I'd suggest Brennivín and lots of it. I'll leave the inclusion of fermented shark to your own discretion.
Chuck
> On Dec 1, 2010, at 9:39 PM, Pascal Robert wrote:
>
>> At a minimum, create a file called my.cnf in /etc , and add this text in the file:
>>
>> [mysqld]
>> lower_case_table_names = 1
>> default-storage-engine = InnoDB
>>
>> And restart MySQL. EOF will be more happy. The default table type in MySQL is MyISAM, which is fast but is not transactions safe (and it auto commit).
>>
>>> OK, so InnoDB appears to be part of the MySQL Community Server. I'll have a look. Thanks.
>>>
>>>
>>> On Dec 1, 2010, at 9:24 PM, Chuck Hill wrote:
>>>
>>>> It is free. Look in the community edition.
>>>>
>>>>
>>>> On Dec 1, 2010, at 6:24 PM, Andrew R. Kinnie wrote:
>>>>
>>>>> eesh. I'm not being paid for my time (except in beer and wings) so I don't think I can do a commercial transaction engine. :-/
>>>>>
>>>>> Is there something else that is effectively free for something this small?
>>>>>
>>>>> On Dec 1, 2010, at 9:09 PM, Chuck Hill wrote:
>>>>>
>>>>>>
>>>>>> On Dec 1, 2010, at 6:06 PM, Andrew R. Kinnie wrote:
>>>>>>
>>>>>>> I don't know what InnoDB is, so I'd have to say no.
>>>>>>
>>>>>> I don't use MySQL. But I do know that MySQL without InnoDB is... not something I would trust data to. Check the Wiki or search for posts on this by Kieran.
>>>>>>
>>>>>>
>>>>>>> I did delete all the bookings and add new ones. No change. :-/
>>>>>>>
>>>>>>> The bookings for the feature are still not appearing either, even though they are new, but I assume that's a different issue.
>>>>>>
>>>>>> Could be lack of InnoDB, but more likely something wrong in your app or model.
>>>>>>
>>>>>>
>>>>>> Chuck
>>>>>>
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> On Dec 1, 2010, at 9:01 PM, Chuck Hill wrote:
>>>>>>>
>>>>>>>> On Dec 1, 2010, at 5:58 PM, Andrew R. Kinnie wrote:
>>>>>>>>> On Dec 1, 2010, at 8:42 PM, Chuck Hill wrote:
>>>>>>>>> On Dec 1, 2010, at 5:35 PM, Andrew R. Kinnie wrote:
>>>>>>>>>>
>>>>>>>>>>> Hmm. That was checked, but set as false. In any event, I was using an auto-increment. I gather I should remove this? EOF will do the right thing and create it's own pk?
>>>>>>>>>>
>>>>>>>>>> Yes. Auto-increment does not mix well with data created from EOF.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> I changed the debug enabled to true and got this in the console when I tried to delete a duplicate:
>>>>>>>>>>
>>>>>>>>>>> ...
>>>>>>>>>>> SELECT t0.AGENT_ID, t0._rowid, t0.COMIC_ID FROM BOOKING t0 FOR UPDATE
>>>>>>>>>>> ...
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> That is a pretty clear sign that EOF is visibly upset. :-) See if removing the auto-increment helps.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> I already tried that and it didn't help. :-/
>>>>>>>>>
>>>>>>>>> Of course now the other issue is that the bookings for the feature act are not showing up at all.
>>>>>>>>>
>>>>>>>>> This is a new site. Am I better off just deleting all the bookings and adding new ones? (there's only about 25 of them)
>>>>>>>>
>>>>>>>>
>>>>>>>> That is worth a try. If you created data with auto-increment and don't have the FK constraints enforced in the database, the relationships might be broken (bad data).
>>>>>>>>
>>>>>>>> Are you running MySQL with InnoDB?
>>>>>>>>
>>>>>>>>
>>>>>>>> Chuck
>>>>>>>>
>>>>>>>> --
>>>>>>>> Chuck Hill Senior Consultant / VP Development
>>>>>>>>
>>>>>>>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>>>>>>>> http://www.global-village.net/products/practical_webobjects
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Chuck Hill Senior Consultant / VP Development
>>>>>>
>>>>>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>>>>>> http://www.global-village.net/products/practical_webobjects
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>> --
>>>> Chuck Hill Senior Consultant / VP Development
>>>>
>>>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>>>> http://www.global-village.net/products/practical_webobjects
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden