[confirm] - DataBase Size Error | Page 2

Discussion in 'Older releases' started by guytpetj, March 4, 2012.

Page 2 of 4
  1. Smeulf
    • Team MediaPortal

    Smeulf Test Group

    Joined:
    October 27, 2010
    Messages:
    672
    Likes Received:
    227
    Location:
    France
    Ratings:
    +228 / 0
    Home Country:
    France France
    Show System Specs
    March 5, 2012 #11
    Please use MP2_Alpha_1 branch to avoid any problem ;)


     
    Smeulf, March 5, 2012

  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    March 6, 2012 #12
    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.
     
    guytpetj, March 6, 2012
    • Like Like x 3
  4. Albert
    • Premium Supporter

    Albert MP2 Developer

    Joined:
    February 18, 2008
    Messages:
    1,297
    Likes Received:
    1,125
    Gender:
    Male
    Occupation:
    Dipl.-Inform.
    Location:
    Freiburg im Breisgau, Germany
    Ratings:
    +1,130 / 1
    Home Country:
    Germany Germany
    March 7, 2012 #13
    Thanks guytpetj very much. Then I'll fix our code in that area.
     
    Albert, March 7, 2012
  5. Smeulf
    • Team MediaPortal

    Smeulf Test Group

    Joined:
    October 27, 2010
    Messages:
    672
    Likes Received:
    227
    Location:
    France
    Ratings:
    +228 / 0
    Home Country:
    France France
    Show System Specs
    March 9, 2012 #14
    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...
     
    Smeulf, March 9, 2012
  6. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    March 9, 2012 #15
    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.
     

    Attached Files:

    guytpetj, March 9, 2012
    • Like Like x 1
  7. Smeulf
    • Team MediaPortal

    Smeulf Test Group

    Joined:
    October 27, 2010
    Messages:
    672
    Likes Received:
    227
    Location:
    France
    Ratings:
    +228 / 0
    Home Country:
    France France
    Show System Specs
    March 10, 2012 #16
    Yes, you pulled the right branch, the code is the right one :)

    Thank you very much guytpetj for your time.

    Cheers.
     
    Smeulf, March 10, 2012
  8. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,082
    Likes Received:
    4,765
    Ratings:
    +6,823 / 11
    Home Country:
    Germany Germany
    Show System Specs
    April 12, 2012 #17
    morpheus_xx, April 12, 2012
  9. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    April 13, 2012 #18
    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.
     
    guytpetj, April 13, 2012
  10. morpheus_xx
    • Team MediaPortal

    morpheus_xx Lead Dev MP2

    Joined:
    March 24, 2007
    Messages:
    11,082
    Likes Received:
    4,765
    Ratings:
    +6,823 / 11
    Home Country:
    Germany Germany
    Show System Specs
    April 13, 2012 #19
    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
     
    morpheus_xx, April 13, 2012
  11. guytpetj
    • Premium Supporter

    guytpetj MP Donator

    Joined:
    March 24, 2005
    Messages:
    424
    Likes Received:
    53
    Gender:
    Male
    Occupation:
    Director - Oil and Gas Exploration
    Location:
    USA
    Ratings:
    +58 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    April 13, 2012 #20
    compressed with 7z the database is 634MB

    Is there a place/system you want me to use to upload?
     
    guytpetj, April 13, 2012
Page 2 of 4
Loading...
Similar Threads - DataBase Size Error
  1. HakanThn

    [solved] Video database genres, sort titles and collection thumbnails

    HakanThn, October 23, 2019, in forum: Newcomers Forum
    Replies:
    12
    Views:
    599
    HakanThn
    October 27, 2019
  2. GilDavis

    MP1 TV Server "failed to upgrade the database" using MS Sql Server

    GilDavis, October 21, 2019, in forum: Installation, configuration support
    Replies:
    3
    Views:
    235
    GilDavis
    October 26, 2019
  3. morpheus_xx

    Plugin: MySQL database provider - better performance and no size limit for your MP2-MediaLibrary

    morpheus_xx, November 28, 2012, in forum: Plugin Development
    Replies:
    34
    Views:
    15,473
    breese
    October 17, 2013
  4. MediaPortal-Bot

    0003812: Database size limit reached, connection string "max database size" is never used

    MediaPortal-Bot, March 4, 2012, in forum: Bugtracker Feed
    Replies:
    0
    Views:
    536
    MediaPortal-Bot
    March 4, 2012
  5. ozwombat

    Moving Pictures 1.3.1 Database Size

    ozwombat, February 15, 2012, in forum: Moving Pictures
    Replies:
    7
    Views:
    1,323
    Dodgy Bob
    February 17, 2012

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice

  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Quick Navigation

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!