Ingres Community Forums Login Register Ingres.com  

Ingres Community Forum


Go Back   Ingres Community Forums > Community > Newsgroups & Mailing Lists > Comp.Databases.Ingres
 

Reply
 
LinkBack Thread Tools Display Modes
Old 2010-02-08   #1 (permalink)
Martin Bowes
Guest
 
Posts: n/a
Default [Info-Ingres] infodb iidbdb freezes

Hi All,



I have a windows installation (I'm sorry...) II 9.2.0 (int.w32/143) +
p13595.



The system just bevaed in a very strange manner over the weekend.



An attempt to do infodb iidbdb would freeze. At the time a backup of
iidbdb had occurred but would not conclude. At all times the server was
accessible and you could connect to iidbdb and run queries.



I was forced to user taskkill to remove infodb requests and the
checkpoint process. After I managed to stop ingres the
files/memory/lglkdata.mem file was not deleted.



I restarted ingres and reran the backup and once more it froze on iidbdb
having completed the creation of the checkpoint. Ditto infodb iidbdb
would freeze. And again after the shutdown the lglkdata.mem file
remained.



I restarted the installation and altered my backup script to not use
'#m2'. It now appears to be ok in backups...but there have been several
backups with this flag in effect, its only the last weekend where there
appears to have been a problem.



Has anyone seen anything like this or have any suggestions to offer?



Martin Bowes




  Reply With Quote

Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


© 2009 Ingres Corporation. All Rights Reserved