POLALA.COM
welcome to my space
X
Welcome to:polala.com
Search:  
NAVIGATION: Home >>

SQL DB is deleted on memalloc error

Published by: rose 2009-01-09

  • MySQL Bugs: Search::
    (271 days), S1, community-5.1.23-0.rhel4, Linux (redhat enterprise 4 x86_64), ndbd gives malloc error when starting up with SharedGlobalMemory > 1012M
    http://bugs.mysql.com/saved/Cluster Issues (open)
    HOME
    When xbmc runs out of memory and trys to open a database (which fails) it assumes its due to an old db version and deletes/attempts conversion which results in it being deleted.
    SQLite Optimization FAQ::
    When information is deleted in the database, and a btree page becomes empty, The size of the data in the database can be determined using SQL queries:
    http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
    HOME

    Would it be possible to add some error checking to prevent deletion of the db
    mysociety: mysociety/cvswww/src/cvstrac-1.1.5/db.c 1.1::
    Exit with an error message if the database will not open. */ sqlite *db_open( void){ char .. The following SQL ** code converts the schema to version 1.1.
    http://secure.mysociety.org/cvstrac/fileview?f=mysociety/cvswww/src/cvstrac-1.1.5/db.c&v=1.1
    HOME

    Log at this link
    http://pastebin.ca/513714


  • sorry, gotta dig this one up again

    I am quite sure memory is becoming an issue when searching the db. While viewing (and playing) the search results and changing the criteria and re-searching multiple times seems to induce this problem. Still trying to find a method to reproduce reliably or a workaround to prevent db deletion
    Looking for Error Codes « Terra Informatica Forums::
    6 postsMessageId: E_SQLITE_ERROR // // MessageText: // // SQL error or missing database . // #define E_SQLITE_ERROR ((DWORD)0xC0000201L) // 0x01+0x0200
    http://terrainformatica.com/forums/topic.php?id=222&page
    HOME

    I'm falling victim to this 3 or 4 times a week, very frusterating :(

    Another log for viewing pleasure
    http://pastebin.ca/569326


  • ack! thanks nuka :rofl:


  • From the log June 14.

    Revision: 9317 fixed: Database could be deleted if an exception (eg out of memory) occured.





  • Where's The Advantage In Windows Genuine Advantage?
    Stocks Bounce After S&P Joins Bear Market

    You are looking at:polala.com's SQL DB is deleted on memalloc error, click polala.com to home
    #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about SQL DB is deleted on memalloc error , Please add it free.
    About us |Contact us |Advertisement |Site map |Exchange links
    Copyright© 2008polala.com All Rights Reserved