[BlueOnyx:09962] Re: CCE DNS Hanging

[Matt James]

Hi Greg,

Thanks again for some great information.

I have a backup of the codb directory from before I began messing around with DNS scripts.  If I copy it back into position, will that work or is there more involved that I need to think about?

-Matt

On Mar 30, 2012, at 10:36 PM, Greg Kuhnert wrote:

> Hi Matt.
> 
> The cobalt object databases has three main components
> 
> 1. The actual objects. These are stored in a directory structure.
> 2. codb.oids - You already found and fixed a problem with the data in 
> this file.
> 3. db.classes - This file maintains a cross reference of class names to 
> object numbers - and is used to help with search routines. Eg show me a 
> list of oid's for DNS records
> 
> I have never seen a corruption with #1. We've fixed #2. #3 is the only 
> remaining area of concern. Bad news: This file is a bit of a black art. 
> I dont think anyone has done any detailed research on this index - its 
> structure, or how it is maintained. It has been on my to-do list to do 
> some research on it - but I have not succeeded in finding some time yet.
> 
> Short term advice: Cmu export / import to a new server.
> 
> Long term - someone needs to find some time/bandwidth to research and 
> understand this file - and create a tool to do a rebuild if it gets 
> corrupt... but dont hold your breath.
> 
> On 3/31/2012 1:44 AM, Matt James wrote:
>> Hi Greg,
>> 
>> Thanks again for your help.  I've run the script and here's what happened for me:
>> 
>> * I ran the script and the output was almost identical except for the second number -- not sure if that matters
>> * I stopped CCE (this took a few minutes, which made me nervous, but it eventually worked without erroring)
>> * I updated the /usr/sausalito/codb/codb.oids file with the first line of information from the script
>> * I restarted CCE
>> * I went into the GUI and viewed the list of Secondary DNS.
>> * This list contained 68 empty records.
>> * I attempted to delete a record, which had no error, but also no affect.
>> * I ran my script again hoping that it would remove all records and re-add them from the master list -- the script hung like before.
>> * While waiting for the script to finish, I scanned down the list of records noting that the first had its own target id, while the others shared the same id (I had not reloaded the page since starting my script, so this was the output after the update to the oids index file).
>> * Eventually my script actually finished (though it could have been kicked out when I restarted CCED in an attempt to stop it from hanging).
>> * Unfortunately, now clicking the "Edit Secondary Services" button in the GUI hangs (I've left it for 12 minutes with no response).
>> 
>> Any thoughts?
>> 
>> Of note:
>> 	* We're using a BQ box at this time (planning to move it to BlueOnyx in the coming 1-2 months).
>> 	* I ran the corruption checker script again and the oids are the same still, so that's good.
>> 
>> Again, thank you for your help!
>> 
>> --
>> Matt James
>> Web Programmer
>> RainStorm Consulting
>> (207) 866-3908
>> 
>> 
>> On Mar 30, 2012, at 7:32 AM, Greg Kuhnert wrote:
>> 
>>> On 3/30/2012 8:04 AM, Matt James wrote:
>>>> Now, no matter what I do, I'm unable to make any changes to the CCE
>>>> database even directly through the GUI.  If I attempt to edit and save
>>>> the remaining Secondary DNS record, the GUI hangs upon save.  If I
>>>> attempt to run my script, the script hangs.  If I attempt to use the
>>>> dns cleaner script written in Perl (found here
>>>> http://oldonce.gknsonline.com/bq-dnsImport.php), the script hangs.  If
>>>> I even attempt to disable DNS in the GUI, saving that hangs.
>>>> 
>>> One more thing - That page is a static archive that I created ages ago
>>> to preserve some of the work of nuonce - the script is out of date, and
>>> its probably time to take that site offline.
>>> 
>>> The replacement scripts are now in an RPM that you can install
>>> 
>>> yum install blueonyx-dnstoolbox
>>> 
>>> The  scripts will be installed in /usr/sausalito/sbin
>>> 
>>> Regards,
>>> Greg.
>>> _______________________________________________
>>> Blueonyx mailing list
>>> Blueonyx at mail.blueonyx.it
>>> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>> 
>> _______________________________________________
>> Blueonyx mailing list
>> Blueonyx at mail.blueonyx.it
>> http://mail.blueonyx.it/mailman/listinfo/blueonyx
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx