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

morpheus_xx

Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,399
    6,970
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #21
    Hi.
    Tried MySQL Plugin with Alpha 2 Pre-Release. It did not work, server crashes. Crash- Logs attached.
    I wanted to try MySQL instead of SQLite to get not that much trouble when testing TVE3.5. Now I've switched back to SQLite again...
    What MySql version do you use? There are limits for creating unique indexes for the supported column length, especially when using InnoDB engine with Utf-8.

    I wonder why it worked before, as there were no db model changes. We already reduce some field sizes.
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,085
    3,685
    Lehmden
    Germany Germany
    Country flag
    Hi.
    I'm using MySQL (Community) 5.6.10.1 working great with MP1.4 TV Server running on the same machine.

    Since SQLite plugin exists I'm using it as it gives most performance with minimum effort. But this isn't working together with TVE3.5 so I need something different to test TVE 3.5 further on. I had MySQL running earlier and I think (also I'm not totally sure) this was with MySQL 5.1 (the version that comes with MP1). It was before I got my new MP2 and MP1-TV Server up and running. Back there it works for me also. But that was with Winter Release, not with Alpha 2. This was my first attempt with Alpha2 and MySQL.
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,399
    6,970
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #23
    Hi Claus,

    I just tested the MySQL plugin from first post with Alpha 2 and MySQL 5.5 (InnoDB). It worked without issue:[collapse]
    [2013-06-12 21:54:58,259] [576 ] [Main ] [INFO ] - DatabaseManager: Creating subschema 'MediaPortal-Basis'
    [2013-06-12 21:54:58,285] [602 ] [Main ] [INFO ] - DatabaseManager: Subschema 'MediaPortal-Basis' present in version 1.0
    [2013-06-12 21:54:58,291] [608 ] [Main ] [DEBUG] - DatabaseManager: Creating subschema 'MediaLibrary' version 1.0...
    [2013-06-12 21:54:58,320] [637 ] [Main ] [INFO ] - DatabaseManager: Subschema 'MediaLibrary' present in version 1.0
    [2013-06-12 21:54:58,321] [638 ] [Main ] [DEBUG] - DatabaseManager: Updating subschema 'MediaLibrary' from version 1.0 to version 1.1...
    [2013-06-12 21:54:58,328] [645 ] [Main ] [INFO ] - DatabaseManager: Subschema 'MediaLibrary' present in version 1.1
    [2013-06-12 21:54:58,329] [646 ] [Main ] [INFO ] - DatabaseSubSchemaManager: Subschema 'MediaLibrary' present in version 1.1
    [2013-06-12 21:54:58,333] [650 ] [Main ] [INFO ] - MediaLibrary: Client '652f0068-4747-47bc-a4fb-8840dbe41181' is online at system 'morpheus7'
    [2013-06-12 21:54:58,335] [652 ] [Main ] [DEBUG] - DatabaseManager: Creating subschema 'ClientManager' version 1.0...
    [2013-06-12 21:54:58,339] [656 ] [Main ] [INFO ] - DatabaseManager: Subschema 'ClientManager' present in version 1.0
    [2013-06-12 21:54:58,339] [656 ] [Main ] [INFO ] - DatabaseSubSchemaManager: Subschema 'ClientManager' present in version 1.0
    [2013-06-12 21:54:58,343] [660 ] [Main ] [INFO ] - UPnP server: HTTP listener for IPv4 protocol started at port 2539
    [2013-06-12 21:54:58,343] [660 ] [Main ] [INFO ] - UPnP server: HTTP listener for IPv6 protocol started at port 2540
    [2013-06-12 21:54:58,346] [663 ] [Main ] [DEBUG] - UPnPServer: Initializing IP endpoint '127.0.0.1'
    [2013-06-12 21:54:58,360] [677 ] [Main ] [INFO ] - UPnPServerController: SSDP enabled for IP endpoint '127.0.0.1', search port is 1900
    [2013-06-12 21:54:58,361] [678 ] [Main ] [DEBUG] - UPnPServer: Initializing IP endpoint 'fe80::c47d:9d5a:a38e:7704'
    [2013-06-12 21:54:58,362] [679 ] [Main ] [INFO ] - UPnPServerController: SSDP enabled for IP endpoint 'fe80::c47d:9d5a:a38e:7704', search port is 1900
    [2013-06-12 21:54:58,363] [680 ] [Main ] [DEBUG] - UPnPServer: Initializing IP endpoint '192.168.1.103'
    [2013-06-12 21:54:58,364] [681 ] [Main ] [INFO ] - UPnPServerController: SSDP enabled for IP endpoint '192.168.1.103', search port is 1900
    [2013-06-12 21:54:58,367] [684 ] [Main ] [INFO ] - UPnP server online hosting 1 UPnP root devices
    [2013-06-12 21:54:58,369] [686 ] [Main ] [DEBUG] - DatabaseManager: Creating subschema 'UserProfileDataManagement' version 1.0...
    [2013-06-12 21:54:58,381] [698 ] [Main ] [INFO ] - DatabaseManager: Subschema 'UserProfileDataManagement' present in version 1.0
    [2013-06-12 21:54:58,381] [698 ] [Main ] [INFO ] - DatabaseSubSchemaManager: Subschema 'UserProfileDataManagement' present in version 1.0
    [2013-06-12 21:54:58,390] [707 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'ProviderResource' (id '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed')
    [2013-06-12 21:54:58,487] [804 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_PROVIDERRESOURCE' for media item aspect '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed'
    [2013-06-12 21:54:58,493] [810 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX' for media item aspect '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed'
    [2013-06-12 21:54:58,502] [819 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_0' for inline attribute 'System-Id' in media item aspect '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed'
    [2013-06-12 21:54:58,508] [825 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_1' for inline attribute 'Path' in media item aspect '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed'
    [2013-06-12 21:54:58,514] [831 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_2' for inline attribute 'ParentDirectory' in media item aspect '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed'
    [2013-06-12 21:54:58,519] [836 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '0a296acd-f95b-4a28-90a2-e4fd2a4cc4ed' (name 'ProviderResource') was added
    [2013-06-12 21:54:58,520] [837 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'ImportedItem' (id 'cc0163fe-55a5-426c-a29c-f1d64af7e683')
    [2013-06-12 21:54:58,521] [838 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_IMPORTEDITEM' for media item aspect 'cc0163fe-55a5-426c-a29c-f1d64af7e683'
    [2013-06-12 21:54:58,525] [842 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_3' for media item aspect 'cc0163fe-55a5-426c-a29c-f1d64af7e683'
    [2013-06-12 21:54:58,531] [848 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_4' for inline attribute 'Dirty' in media item aspect 'cc0163fe-55a5-426c-a29c-f1d64af7e683'
    [2013-06-12 21:54:58,537] [854 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type 'cc0163fe-55a5-426c-a29c-f1d64af7e683' (name 'ImportedItem') was added
    [2013-06-12 21:54:58,537] [854 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'Directory' (id '1eeef2d0-d52f-40f7-a12a-9908c2daed1a')
    [2013-06-12 21:54:58,538] [855 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_DIRECTORY' for media item aspect '1eeef2d0-d52f-40f7-a12a-9908c2daed1a'
    [2013-06-12 21:54:58,542] [859 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_5' for media item aspect '1eeef2d0-d52f-40f7-a12a-9908c2daed1a'
    [2013-06-12 21:54:58,548] [865 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '1eeef2d0-d52f-40f7-a12a-9908c2daed1a' (name 'Directory') was added
    [2013-06-12 21:54:58,548] [865 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'MediaItem' (id '17af940c-66ce-4d23-9d06-bf7f21c04201')
    [2013-06-12 21:54:58,549] [866 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_MEDIAITEM' for media item aspect '17af940c-66ce-4d23-9d06-bf7f21c04201'
    [2013-06-12 21:54:58,556] [873 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_6' for media item aspect '17af940c-66ce-4d23-9d06-bf7f21c04201'
    [2013-06-12 21:54:58,562] [879 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_7' for inline attribute 'Title' in media item aspect '17af940c-66ce-4d23-9d06-bf7f21c04201'
    [2013-06-12 21:54:58,569] [886 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_8' for inline attribute 'Rating' in media item aspect '17af940c-66ce-4d23-9d06-bf7f21c04201'
    [2013-06-12 21:54:58,574] [891 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '17af940c-66ce-4d23-9d06-bf7f21c04201' (name 'MediaItem') was added
    [2013-06-12 21:54:58,575] [892 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'VideoItem' (id 'fea2da04-1fdc-4836-b669-f3ca73adf120')
    [2013-06-12 21:54:58,578] [895 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_VIDEOITEM' for media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,582] [899 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_9' for media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,585] [902 ] [5 ] [DEBUG] - Setting up EventWaitHandle with name: Global\MPTVServiceInitializedEvent
    [2013-06-12 21:54:58,592] [909 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_GENRES' for attribute 'Genres' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,597] [914 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_GENRES' for MTM attribute 'Genres' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,602] [919 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_10' to main MIA table for MTM attribute 'Genres' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,608] [925 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_11' to value table for MTM attribute 'Genres' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,617] [934 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_12' for MTM attribute 'Genres' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,627] [944 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_AUDIOLANGUAGES' for attribute 'AudioLanguages' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,630] [947 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_AUDIOLANGUAGES' for MTM attribute 'AudioLanguages' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,635] [952 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_13' to main MIA table for MTM attribute 'AudioLanguages' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,644] [961 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_14' to value table for MTM attribute 'AudioLanguages' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,652] [969 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_15' for MTM attribute 'AudioLanguages' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,665] [982 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_ACTORS' for attribute 'Actors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,668] [985 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_ACTORS' for MTM attribute 'Actors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,672] [989 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_16' to main MIA table for MTM attribute 'Actors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,682] [999 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_17' to value table for MTM attribute 'Actors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,691] [1008 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_18' for MTM attribute 'Actors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,702] [1019 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_DIRECTORS' for attribute 'Directors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,704] [1021 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_DIRECTORS' for MTM attribute 'Directors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,709] [1026 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_19' to main MIA table for MTM attribute 'Directors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,715] [1032 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_20' to value table for MTM attribute 'Directors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,724] [1041 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_21' for MTM attribute 'Directors' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,748] [1065 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_WRITERS' for attribute 'Writers' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,752] [1069 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_WRITERS' for MTM attribute 'Writers' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,756] [1073 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_22' to main MIA table for MTM attribute 'Writers' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,763] [1080 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_23' to value table for MTM attribute 'Writers' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,774] [1091 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_24' for MTM attribute 'Writers' in media item aspect 'fea2da04-1fdc-4836-b669-f3ca73adf120'
    [2013-06-12 21:54:58,782] [1099 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type 'fea2da04-1fdc-4836-b669-f3ca73adf120' (name 'VideoItem') was added
    [2013-06-12 21:54:58,782] [1099 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'AudioItem' (id '493f2b3b-8025-4db1-80dc-c3cd39683c9f')
    [2013-06-12 21:54:58,785] [1102 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_AUDIOITEM' for media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,790] [1107 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_25' for media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,801] [1118 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_ARTISTS' for attribute 'Artists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,804] [1121 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_ARTISTS' for MTM attribute 'Artists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,809] [1126 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_26' to main MIA table for MTM attribute 'Artists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,816] [1133 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_27' to value table for MTM attribute 'Artists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,817] [1134 ] [34 ] [INFO ] - TV service: Starting
    [2013-06-12 21:54:58,819] [1136 ] [TVService] [DEBUG] - TVService v2.0.0.1306 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
    [2013-06-12 21:54:58,821] [1138 ] [PowerEventThread] [DEBUG] - TV service PowerEventThread message loop is running
    [2013-06-12 21:54:58,825] [1142 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_28' for MTM attribute 'Artists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,856] [1173 ] [Main ] [DEBUG] - MIA_Management: Creating index 'IDX_29' for inline attribute 'Album' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,867] [1184 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_GENRES_0' for attribute 'Genres' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,869] [1186 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_GENRES_0' for MTM attribute 'Genres' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,874] [1191 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_30' to main MIA table for MTM attribute 'Genres' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,880] [1197 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_31' to value table for MTM attribute 'Genres' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,887] [1204 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IProgramCategoryService' succesfully started.
    [2013-06-12 21:54:58,889] [1206 ] [Main ] [DEBUG] - MIA_Management: Creating value index 'IDX_32' for MTM attribute 'Genres' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,893] [1210 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IConflictService' succesfully started.
    [2013-06-12 21:54:58,900] [1217 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/ICardService' succesfully started.
    [2013-06-12 21:54:58,900] [1217 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_ALBUMARTISTS' for attribute 'AlbumArtists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,901] [1218 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/ICanceledScheduleService' succesfully started.
    [2013-06-12 21:54:58,903] [1220 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_ALBUMARTISTS' for MTM attribute 'AlbumArtists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,907] [1224 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_33' to main MIA table for MTM attribute 'AlbumArtists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,912] [1229 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IChannelService' succesfully started.
    [2013-06-12 21:54:58,914] [1231 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_34' to value table for MTM attribute 'AlbumArtists' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,923] [1240 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IProgramService' succesfully started.
    [2013-06-12 21:54:58,925] [1242 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/ISettingService' succesfully started.
    [2013-06-12 21:54:58,927] [1244 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_COMPOSERS' for attribute 'Composers' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,928] [1245 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IRecordingService' succesfully started.
    [2013-06-12 21:54:58,930] [1247 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_COMPOSERS' for MTM attribute 'Composers' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,933] [1250 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IScheduleService' succesfully started.
    [2013-06-12 21:54:58,935] [1252 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_35' to main MIA table for MTM attribute 'Composers' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,936] [1253 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IChannelGroupService' succesfully started.
    [2013-06-12 21:54:58,942] [1259 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_36' to value table for MTM attribute 'Composers' in media item aspect '493f2b3b-8025-4db1-80dc-c3cd39683c9f'
    [2013-06-12 21:54:58,954] [1271 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '493f2b3b-8025-4db1-80dc-c3cd39683c9f' (name 'AudioItem') was added
    [2013-06-12 21:54:58,954] [1271 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'ImageItem' (id '2e6c3c20-0b0b-4ee3-8a0c-550c6791ead0')
    [2013-06-12 21:54:58,957] [1274 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_IMAGEITEM' for media item aspect '2e6c3c20-0b0b-4ee3-8a0c-550c6791ead0'
    [2013-06-12 21:54:58,962] [1279 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_37' for media item aspect '2e6c3c20-0b0b-4ee3-8a0c-550c6791ead0'
    [2013-06-12 21:54:58,968] [1285 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '2e6c3c20-0b0b-4ee3-8a0c-550c6791ead0' (name 'ImageItem') was added
    [2013-06-12 21:54:58,969] [1286 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'SeriesItem' (id '88cfe0a8-df0b-4e2f-ae26-17c9478af703')
    [2013-06-12 21:54:58,970] [1287 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_SERIESITEM' for media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:58,978] [1295 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_38' for media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:58,989] [1306 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_EPISODE' for attribute 'Episode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:58,991] [1308 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_EPISODE' for MTM attribute 'Episode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:58,996] [1313 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_39' to main MIA table for MTM attribute 'Episode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:58,999] [1316 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IControllerService' succesfully started.
    [2013-06-12 21:54:59,003] [1320 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_40' to value table for MTM attribute 'Episode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:59,009] [1326 ] [TVService] [DEBUG] - Service 'net.tcp://localhost:8001/TVService/IEventService' succesfully started.
    [2013-06-12 21:54:59,015] [1332 ] [TVService] [DEBUG] - Service 'http://localhost:8000/TVService/IDiscoverService' succesfully started.
    [2013-06-12 21:54:59,016] [1333 ] [TVService] [INFO ] - Controller: Initializing TVServer
    [2013-06-12 21:54:59,017] [1334 ] [TVService] [INFO ] - Controller: 1 init attempt
    [2013-06-12 21:54:59,019] [1336 ] [Main ] [DEBUG] - MIA_Management: Creating MTM value table 'V_DVDEPISODE' for attribute 'DvdEpisode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:59,022] [1339 ] [Main ] [DEBUG] - MIA_Management: Creating N:M table 'NM_DVDEPISODE' for MTM attribute 'DvdEpisode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:59,025] [1342 ] [TVService] [DEBUG] - ----------------------------
    [2013-06-12 21:54:59,026] [1343 ] [TVService] [DEBUG] - Detecting Cards
    [2013-06-12 21:54:59,027] [1344 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_41' to main MIA table for MTM attribute 'DvdEpisode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:59,035] [1352 ] [Main ] [DEBUG] - MIA_Management: Creating foreign index 'IDX_42' to value table for MTM attribute 'DvdEpisode' in media item aspect '88cfe0a8-df0b-4e2f-ae26-17c9478af703'
    [2013-06-12 21:54:59,043] [1360 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '88cfe0a8-df0b-4e2f-ae26-17c9478af703' (name 'SeriesItem') was added
    [2013-06-12 21:54:59,043] [1360 ] [TVService] [DEBUG] - Detected MediaPortal IP TV Card 0
    [2013-06-12 21:54:59,043] [1360 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'MovieItem' (id '07067796-3398-4d9c-9012-12070eae350a')
    [2013-06-12 21:54:59,046] [1363 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_MOVIEITEM' for media item aspect '07067796-3398-4d9c-9012-12070eae350a'
    [2013-06-12 21:54:59,051] [1368 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_43' for media item aspect '07067796-3398-4d9c-9012-12070eae350a'
    [2013-06-12 21:54:59,057] [1374 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '07067796-3398-4d9c-9012-12070eae350a' (name 'MovieItem') was added
    [2013-06-12 21:54:59,058] [1375 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'ThumbnailSmall' (id 'a61846e9-0910-499d-9868-a1fabce7ccfd')
    [2013-06-12 21:54:59,059] [1376 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_THUMBNAILSMALL' for media item aspect 'a61846e9-0910-499d-9868-a1fabce7ccfd'
    [2013-06-12 21:54:59,064] [1381 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_44' for media item aspect 'a61846e9-0910-499d-9868-a1fabce7ccfd'
    [2013-06-12 21:54:59,072] [1389 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type 'a61846e9-0910-499d-9868-a1fabce7ccfd' (name 'ThumbnailSmall') was added
    [2013-06-12 21:54:59,073] [1390 ] [Main ] [INFO ] - MIA_Management: Adding media library storage for media item aspect 'ThumbnailLarge' (id '1fda5774-9ac5-4873-926c-e84e3c36a966')
    [2013-06-12 21:54:59,074] [1391 ] [Main ] [DEBUG] - MIA_Management: Creating main table 'M_THUMBNAILLARGE' for media item aspect '1fda5774-9ac5-4873-926c-e84e3c36a966'
    [2013-06-12 21:54:59,079] [1396 ] [Main ] [DEBUG] - MIA_Management: Creating primary key index 'IDX_45' for media item aspect '1fda5774-9ac5-4873-926c-e84e3c36a966'
    [2013-06-12 21:54:59,085] [1402 ] [Main ] [INFO ] - MediaLibrary: Media item aspect storage for MIA type '1fda5774-9ac5-4873-926c-e84e3c36a966' (name 'ThumbnailLarge') was added
    [/collapse]
    Will make more tests with 5.6 later this week...
     
    Last edited by a moderator:

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,399
    6,970
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #24
    Just installed MySQL 5.6.12 and now I can confirm this issue :(

    So for now I can only recommend to stick with MySQL 5.5 and wait for a fix. The problem is, that we would need to shorten the "Path" column only to fit for MySQL unique-index-key-length limit, which is not really good.

    Maybe we should put more effort into full SqlLite support...
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,085
    3,685
    Lehmden
    Germany Germany
    Country flag
    Hi
    ...Maybe we should put more effort into full SqlLite support...
    As it's faster than MySQL and did not need any extra installation I would recommend that too. I'm using SQLite daily without issues. Only thing that did not work is TVE 3.5...
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,399
    6,970
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #27
    I already tested some settings, but it didn't work yet. Probably it's not enough to change the settings, but also something inside the "create table" definitions.
    set global innodb_large_prefix = ON;
    set global innodb_file_format = Barracuda;
    set global innodb_file_per_table = ON;
     

    Hawkeye

    Portal Pro
    January 29, 2005
    548
    87
    Halle (Saale)
    Germany Germany
    Country flag
    I already tested some settings, but it didn't work yet. Probably it's not enough to change the settings, but also something inside the "create table" definitions.
    set global innodb_large_prefix = ON;
    set global innodb_file_format = Barracuda;
    set global innodb_file_per_table = ON;
    As these are boolean, did you try:
    Code:
    set global innodb_large_prefix = 1;
    set global innodb_file_per_table = 1;
     

    morpheus_xx

    Lead Dev MP2
  • Team MediaPortal
  • March 24, 2007
    11,399
    6,970
    Germany Germany
    Country flag
    • Thread starter
    • Moderator
    • #29
    Little follow up. I tried also "set ... = 1", which internally gets translated into "ON". So parameters should be fine.

    But there seems to be different behaviour in differnt MySQL versions: http://bugs.mysql.com/bug.php?id=68453
    I also am having the same issue on the Windows version of MySQL 5.6.10. However, the linux version of MySQL 5.6.10 operates with a silent truncation and still creates the index. Current documentation stipulates that the server will silently truncate the column.
     

    jehe

    Test Group
  • Team MediaPortal
  • February 15, 2011
    694
    216
    54
    Belgium Belgium
    Country flag
    Hi,
    Has anyone tested the MySQL plugin with MP2 alpha 3?
    So what I have done;
    MySQL 5.5 installed.
    MP2 installed
    MP2 server stopped
    SQLCEDatabase replaced by Mysql Database from first page. (C: \ Program Files (x86) \ Team MediaPortal \ MP2-Server \ Plugins).
    Probably I did something stupid, but the server crashed.
    Here are my server logs.
     

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

    OP Similar threads Forum Replies Date
    joecrow 1.25.0 Radio Time plugin fails after Resume from Sleep with MP 1.25 Bugreports 4
    P MP2: US user, OTA - can NOT get SchedulesDirect plugin to work on MP1 or MP2 --> how do I get OTA schedule? General 5
    E aktuelle englische Forums Webseite von - Showtime Plugin v3 Plugins & Erweiterungen 4
    mrmojo666 [Tv Server Plugin ]Direct Show Video Control Plugin 0.0.0.1 for Hauppauge PVR cards MediaPortal 1 Plugins 0
    joecrow MultiShortcut Plugin (Uavailable) in DWHD skin General Support 58
    vapourEyes Building TV Plugin General Development (no feature request here!) 49
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    joecrow How about a Launcher plugin for MP1? MediaPortal 1 6
    D [solved] TVServer Plugin must be missing something. General Development (no feature request here!) 1
    framug Nouveau plugin XmlTvFR pour récupérer le guide télé français Kazer / ZguideTv (WebEPGfr) 11
    emphatic Allow remote control mapping of all plugins Improvement Suggestions 0
    D Where should plugins be located on hard drive? General Support 0
    D how to disengage from one version of a plugin to use another Newcomers Forum 0
    cbr954rr How to disable a pre-configured plugin? General 2
    mrmojo666 [Plugin]Marantz Control Plugin 0.0.0.2 MediaPortal 1 Plugins 2
    mrmojo666 beginner: trying to write a plugin, need help to catch event General Development (no feature request here!) 3
    framug [Rejected] Fix PowerScheduler plugin for MP2 single seat Submit: Code Patches 9
    doskabouter [Question] Stale plugins Developer Discussions 9
    M MP1 stops responding after Starting Plugins General Support 14
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10
    L Mediaportal 1.21 and Windows 10: user schedules de-activated when powerscheduler plugin is selected General Support 1
    C Can the XmlTv Plugin handle 600+ channels? General 3
    M Online Video Plugin V.2.32 keine Installtion unter MediaPortal 1.22 ? TV / Streaming 3
    emphatic Pictures in the cloud - would a plugin be possible for services like Google Photos MediaPortal 1 Plugins 1
    C where is the Online Videos plugin General Support 1
    Similar threads

























    Top Bottom