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

morpheus_xx

Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    • 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,553
    3,934
    Lehmden
    Home Country
    Germany Germany
    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

    Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    • 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

    Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    • 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,553
    3,934
    Lehmden
    Home Country
    Germany Germany
    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

    Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    • 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)
    Home Country
    Germany Germany
    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

    Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    • 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

    Portal Pro
    February 15, 2011
    694
    216
    57
    Home Country
    Belgium Belgium
    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

    Top Bottom