[confirm] DataBase Size Error (1 Viewer)

Smeulf

Retired Team Member
  • Premium Supporter
  • October 27, 2010
    672
    454
    France
    France France
    Please use MP2_Alpha_1 branch to avoid any problem ;)
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    OK,
    I've downloaded, modified and compiled the branch.
    Restored a copy of the original database that gave me the error.

    I'm happy to say that the line of code below fixed my problem.

    _connectionString = "Data Source='" + databaseFile + "'; Default Lock Timeout=" + LOCK_TIMEOUT + "; Max Buffer Size = " + MAX_BUFFER_SIZE + "; Max Database Size = " + 1024;


    I'll try to drastically increase my database size tommorow as test to see if it keeps working as expected.
     

    Smeulf

    Retired Team Member
  • Premium Supporter
  • October 27, 2010
    672
    454
    France
    France France
    Hi guytpetj,

    The issue should be solved in the "dev" branch, with the correct connection string and and auto increment of the value. If you have some time to pull the last commits on that one, build and try, that would be great to confirm it works...
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    Hi Smeulf,

    I've compiled with the files in the "dev" branch and run it with my now 284MB database, and all seems to work fine.

    Just to make sure that I did do the right thing I'm attching the "SQLCEDatabase.cs" I used for the test.
     

    Attachments

    Smeulf

    Retired Team Member
  • Premium Supporter
  • October 27, 2010
    672
    454
    France
    France France
    Yes, you pulled the right branch, the code is the right one :)

    Thank you very much guytpetj for your time.

    Cheers.
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,477
    7,014
    Germany Germany
    Country flag

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    Compacting the 1.2GB database did not do much.

    If you want I can delete the database and start from scratch to see if it ends up growing to the same size.

    Eventhough the database is this big, everything works fine, and it finaly stopped growing at 1.2GB, now if I have MP2 server running the database size remains the same.
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,477
    7,014
    Germany Germany
    Country flag
    Please keep the current (big) database. Can you share it with us? How big is it when packed with 7z?

    If it is too big, I would be interested in the contained tables and record counts of each table
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    56
    USA
    United States of America United States of America
    compressed with 7z the database is 634MB

    Is there a place/system you want me to use to upload?
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    ajs [WiP] 5030: Add UHD Thumb size to TV Server MediaPortal 1 0
    azzuro [fixed] 5011: Version label in Splash screen - pos, size from skin MediaPortal 1 61
    wizard123 [solved] Auto sizing buttons to text content MediaPortal 1 11
    M Change size of the splash screen Skins and Plugins Installer (MPEI) 2
    Similar threads

























    Top Bottom