BUG-4110: playing videos inside "pictures" section is not working well (1 Viewer)

The_Stig

Retired Team Member
  • Premium Supporter
  • April 5, 2005
    2,176
    428
    Tried v15 and can reproduce the MP blocking with fast F8. error.log looks like:

    Code:
    2012-12-25 09:08:34.372070 [ERROR][PicPrefetch(27)]: MediaPortal.Picture.Database exception err:Der Thread wurde abgebrochen. stack:  bei SQLite.NET.SQLiteClient.sqlite3_step(IntPtr pVm)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.GetRotation(String strPicture)
    2012-12-25 09:08:34.905273 [ERROR][PicPrefetch(27)]: MediaPortal.Picture.Database exception err:Der Thread wurde abgebrochen. stack:  bei SQLite.NET.SQLiteClient.sqlite3_step(IntPtr pVm)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.GetRotation(String strPicture)
    2012-12-25 09:08:35.460937 [ERROR][PicPrefetch(25)]: MediaPortal.Picture.Database exception err:Der Thread wurde abgebrochen. stack:  bei SQLite.NET.SQLiteClient.sqlite3_step(IntPtr pVm)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.GetRotation(String strPicture)
    2012-12-25 09:08:35.952148 [ERROR][PicPrefetch(25)]: MediaPortal.Picture.Database exception err:Der Thread wurde abgebrochen. stack:  bei SQLite.NET.SQLiteClient.sqlite3_step(IntPtr pVm)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.GetRotation(String strPicture)
    2012-12-25 09:08:36.449218 [ERROR][PicPrefetch(25)]: MediaPortal.Picture.Database exception err:Der Thread wurde abgebrochen. stack:  bei SQLite.NET.SQLiteClient.sqlite3_step(IntPtr pVm)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.GetRotation(String strPicture)
    2012-12-25 09:08:51.969726 [ERROR][PicPrefetch(25)]: SQLiteClient:  cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:commit
    2012-12-25 09:08:51.970703 [ERROR][PicPrefetch(25)]: PictureDatabaseSqlLite: exception err:SQLiteClient:  cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:commit stack:  bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
      bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.AddPicture(String strPicture, Int32 iRotation)
    2012-12-25 09:08:51.989257 [ERROR][MPMain(1)]: OnMessage exception:System.OutOfMemoryException: Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
      bei System.Threading.Thread.StartInternal(IPrincipal principal, StackCrawlMark& stackMark)
      bei System.Threading.Thread.Start()
      bei MediaPortal.GUI.Library.GUIWaitCursor.Show()
      bei MediaPortal.GUI.Pictures.GUIPictures.LoadDirectory(String strNewDirectory)
      bei MediaPortal.GUI.Pictures.GUIPictures.OnPageLoad()
      bei MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)
    2012-12-25 09:08:51.992187 [ERROR][PicPrefetch(25)]: SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096
    2012-12-25 09:08:51.993164 [ERROR][PicPrefetch(25)]: picture database exception err:SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096 stack:  bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()
    2012-12-25 09:08:52.014648 [ERROR][PicPrefetch(25)]: SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096
    2012-12-25 09:08:52.014648 [ERROR][PicPrefetch(25)]: picture database exception err:SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096 stack:  bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
      bei SQLite.NET.SQLiteClient.Execute(String query)
      bei MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)
      bei MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()

    And then the err:BUSY goes on for a lot of files...

    After after a while I get "MP not working anymore"...

    EDIT: This is on a pictures DB with around 17.000 pictures
     
    Last edited:

    jehe

    Portal Pro
    February 15, 2011
    694
    216
    58
    Home Country
    Belgium Belgium
    Hi,

    So we need to test on a folder with a rather large collection of slides, and go fast forward and backward.

    Now Recursive Slide Show on big folder start quickly
    What do you mean with it?
    Should we test that the slideshow starts again at the end(repeat)?
    (Sorry but my English is of poor quality, at school was French our second language, after 26 years, this language is also no longer an option)

    Hoi edterbak, ik heb U nog niet verwelkomt bij het team, Bij deze welkom tot het team. ;)
     
    Last edited:

    jehe

    Portal Pro
    February 15, 2011
    694
    216
    58
    Home Country
    Belgium Belgium
    Hi,
    EDIT: This is on a pictures DB with around 17.000 pictures

    Wow thats BIG .
    That size of database, i can not reproduce, if you need such a collection to test than i must pass.
     

    edterbak

    Portal Pro
    March 4, 2008
    2,114
    1,176
    Home Country
    Netherlands Netherlands
    If you need a BIG ^^ picture db.

    You could resize one image to 1 or 2 kb.
    Create a text file (rename afterwards to .bat)



    Code:
    For /l %%1 in (1,1,200) do (
        copy photo00000.jpg photo%%%%1.jpg > nul
    )

    You can edit the number in the batchfile. Now it is set at 200 for testing purpose.
    The original photo in the folder (to be present) is photo00000.jpg
     
    Last edited:

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,583
    10,403
    France
    Home Country
    France France
    • Thread starter
    • Moderator
    • #65
    Thank guys :)

    @jehe : Yes, need to retest from start because i do a big rework on code and fix slow start on r.slideslow on folder with many folder inside / inside it.
    @The_Stig : About db i think it's surely the same on master with arrow key (mine db was around 35000 files, size of my db was 4.5Mb) but we can't really test like picture/video is broken on master.
    @edterbak : thanks for the tip :).

    When i delete my db, it seems that F7/F8 right/left arrow is ok, so i would say it's an issue with big db, so i don't how to fix that.
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,569
    3,950
    Lehmden
    Home Country
    Germany Germany
    Hi.
    Wow thats BIG .
    I really can beat this as I have more than 500.000 pictures in my collection...This amount is a "little bit" too much for MP, as you have 1.000.000 thumbs in a single directory, something windows can not handle properly. The DB itself could handle this ofc, but the thumbs are not doing well..

    But I never ever have videos inside my pictures folders at all, so this is not really something I can participate. If I do photos I never videotape something and if I videotape something I never take pictures... Sometimes I had an assistant videotaping the photo shooting, but that's some kind of backstage material not to put in the same folder than the "main show"...
     

    jehe

    Portal Pro
    February 15, 2011
    694
    216
    58
    Home Country
    Belgium Belgium
    If you need a BIG ^^ picture db.

    You could resize one image to 1 or 2 kb.
    Create a text file (rename afterwards to .bat)



    Code:
    For /l %%1 in (1,1,200) do (
        copy photo00000.jpg photo%%%%1.jpg > nul
    )

    You can edit the number in the batchfile. Now it is set at 200 for testing purpose.
    The original photo in the folder (to be present) is photo00000.jpg

    Thanks for the tip


    So I have copied around 300 pictures from cd to a folder( I have more pictures bud copying takes quite a long time)
    Deleted my old pictures folder and database-->created new folder+database in mediaportalconf.
    I found no errors.
    I'll try to enlarge the database with the tip from edterbak.
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,583
    10,403
    France
    Home Country
    France France
    • Thread starter
    • Moderator
    • #68
    Hey,
    I think i've fixed the error :)

    In fact actual master code try to analyse video like a picture lol.
    I will up v16 ;)
     

    Sebastiii

    Development Group
  • Team MediaPortal
  • November 12, 2007
    16,583
    10,403
    France
    Home Country
    France France
    • Thread starter
    • Moderator
    • #70
    Hmm :) need to add some check again about db and i think we are good :)

    V17 in progress lol

    Edit : Uploaded :)
     
    Last edited:

    Users who are viewing this thread


    Write your reply...
    Top Bottom