X-Kaltura-App: exiting on error 25 - wrong query attributes, This format is unsupported


#1

I kaltura set up on centos 7.

Remote storage is working ok, I have a delivery profile set up and while it works on the players for individual flavours in the flavours section I am getting the following error in the headers when I try play in the preview player:
X-Kaltura-App:

exiting on error 25 - wrong query attributes, This format is unsupported

This accompanies file not found.

I found some older solutions on github but they do not appear to be relevant anymore… Any help will be appreciated.


#2

Hi @michael_hall,

Please see Can't play video now.


#3

Great thanks, taking a look now.


#4

My log is different from the other thread.

It looks like it is having issues finding delivery id’s?

Stack trace:
#0 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(255): DropFolderService->initService('dropfolder_drop...', 'dropFolder', 'list')
--
2019-02-28 12:00:43 [0.000365] [79.135.107.81] [708561905] [41] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0002748966217041 seconds
2019-02-28 12:00:43 [0.000637] [79.135.107.81] [708561905] [42] [PS2] [DeliveryProfilePeer::getRemoteDeliveryByStorageId] ERR: exception 'Exception' with message 'Delivery ID can't be determined for storageId [1] ( PartnerId [102] ) and streamer type [ applehttp ]' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/DeliveryProfilePeer.php(457): KalturaLog::err('Delivery ID can...')
--
#18 {main}
2019-02-28 12:00:43 [0.000154] [79.135.107.81] [708561905] [43] [PS2] [KExternalErrors::dieError] ERR: exception 'Exception' with message 'exiting on error 25 - wrong query attributes, This format is unsupported' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(136): KalturaLog::err('exiting on erro...')
--
2019-02-28 12:00:43 [0.000418] [79.135.107.81] [1123304883] [41] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00031709671020508 seconds
2019-02-28 12:00:43 [0.000522] [79.135.107.81] [1123304883] [42] [PS2] [DeliveryProfilePeer::getRemoteDeliveryByStorageId] ERR: exception 'Exception' with message 'Delivery ID can't be determined for storageId [1] ( PartnerId [102] ) and streamer type [ applehttp ]' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/DeliveryProfilePeer.php(457): KalturaLog::err('Delivery ID can...')
--
#18 {main}
2019-02-28 12:00:43 [0.000163] [79.135.107.81] [1123304883] [43] [PS2] [KExternalErrors::dieError] ERR: exception 'Exception' with message 'exiting on error 25 - wrong query attributes, This format is unsupported' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(136): KalturaLog::err('exiting on erro...')

#5

Hi @michael_hall,

What’s the output for?

# mysql -h$DB1_HOST -u$DB1_USER -p$DB1_PASS

mysql> select id,name,url,host_name from delivery_profile; 

Also, look at /opt/kaltura/log/kaltura_prod.log to find the actual query the code makes to determine the delivery profile to use.
If you haven’t already, increase the log verbosity in /opt/kaltura/app/configurations/logger.ini by setting all writers.*.filters.priority.priority directives to 7. Be sure to reload Apache after doing so.


#6

Hiya

MySQL output:

MariaDB [kaltura]> select id,name,url,host_name from delivery_profile;
+------+------------------------------------------------+------------------------------------------------+------------------------ 
-----------+
| id   | name                                           | url                                            | host_name                         |
+------+------------------------------------------------+------------------------------------------------+------------------------ 
-----------+
|    1 | Default HTTP Delivery Profile                  | kaltura.xxx.com              | NULL                              
|
|    2 | Default HTTP Delivery Profile                  | kaltura.xxx.com              | NULL                              
|
|    3 | Default HLS Live Delivery Profile              | NULL                                           | NULL                              
|
|    4 | Default HLS Network Live Delivery Profile      | NULL                                           | NULL                              
|
|    5 | Default HLS To Multicast Live Delivery Profile | NULL                                           | NULL                              
|
|  301 | Default MPEG-DASH Live Delivery Profile        | NULL                                           | NULL                              
|
|  302 | Default HD Network Live Delivery Profile       | NULL                                           | NULL                              
|
|  303 | Default HDS Live Delivery Profile              | NULL                                           | NULL                              
|
|  304 | Kaltura Live Packager Dash segmentation        | 
kaltura.xxxxxxt.com:88/live/dash | kaltura.xxxt.com |
|  305 | Kaltura Live Packager HDS segmentation         | 
kaltura.xxxxxx.com:88/live/hds  | kaltura.xxxx.com |
|  306 | Kaltura Live Packager HLS segmentation         | kaltura.xxxxx.com:88/live/hls  
| kaltura.xxxxx.com |
|  307 | Kaltura Live Packager MSS segmentation         | 
kaltura.xxxxx.com:88/live/mss  | kaltura.xxxxx.com |
|  308 | Default RTMP Live Delivery Profile             | NULL                                           | NULL                              
|
| 1001 | Kaltura HLS segmentation                       | kaltura.xxxxx.com:88/hls       | 
kaltura.xxxxxx.com |
| 1002 | Kaltura HDS segmentation                       | kaltura.xxxx.com:88/hds       | 
kaltura.xxxxx.com |
| 1003 | Kaltura DASH segmentation                      | kaltura.xxxxx.com:88/dash      | 
kaltura.xxxx.com |
| 1004 | S3 Http delivery                               | http://dx45n1oi2hg6ix.cloudfront.net/kaltura    | 
dx45n1oi2hg6ix.cloudfront.net      |
+------+------------------------------------------------+------------------------------------------------+------------------------ 
-----------+

Verbose log:

2019-02-28 12:40:10 [0.004264] [79.135.107.81] [599785149] [1] [PS2] [sfContext->initialize] INFO: {sfContext} initialization
2019-02-28 12:40:10 [0.000235] [79.135.107.81] [599785149] [2] [PS2] [sfController->initialize] INFO: {sfController} initialization
2019-02-28 12:40:10 [0.000252] [79.135.107.81] [599785149] [3] [PS2] [sfRouting->parse] INFO: {sfRouting} match route [default] "/:module/:action/*"
2019-02-28 12:40:10 [0.000105] [79.135.107.81] [599785149] [4] [PS2] [sfWebRequest->loadParameters] INFO: {sfRequest} request parameters array (  'referrer' => 'aHR0cDovL2thbHR1cmEuc2NhcmxldHRlbnRlcnRhaW5tZW50LmNvbQ==',  'ks' => 'MzEyNjA0NWRjMTZkNGMzZGI1MDI2ODgzMDJiMTZlNjM1ZTgxZjIxNXwxMDI7MTAyOzE1NTE0MzYyNTg7MjsxNTUxMzQ5ODU4LjgyMzttaWNoYWVsQHNjYXJsZXR0ZW50ZXJ0YWlubWVudC5jb207ZGlzYWJsZWVudGl0bGVtZW50LGFwcGlkOmttYzs7',  'playSessionId' => '3fa5c791-82ef-8fde-20d3-5d1de6e0caea',  'clientTag' => 'html5:v2.74.3',  'uiConfId' => '23448222',  'responseFormat' => 'jsonp',  'callback' => 'jQuery1111024599788496598451_1551357546675',  '_' => '1551357546676',  'module' => 'extwidget',  'action' => 'playManifest',  'entryId' => '0_lny95kk4',  'flavorIds' => '0_0m54qnxf,0_r74t6v3k,0_dsxy91jf,0_hies45s9',  'format' => 'applehttp',  'protocol' => 'http',)
2019-02-28 12:40:10 [0.000113] [79.135.107.81] [599785149] [5] [PS2] [sfFrontWebController->dispatch] INFO: {sfController} dispatch request
2019-02-28 12:40:10 [0.000519] [79.135.107.81] [599785149] [6] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfRenderingFilter"
2019-02-28 12:40:10 [0.000072] [79.135.107.81] [599785149] [7] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "myHealthCheckAndSecurityFilter"
2019-02-28 12:40:10 [0.000250] [79.135.107.81] [599785149] [8] [PS2] [myHealthCheckAndSecurityFilter->basicSecureRequest] WARN: basicSecureRequest: took [0.0001678466796875] seconds
2019-02-28 12:40:10 [0.000067] [79.135.107.81] [599785149] [9] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfCommonFilter"
2019-02-28 12:40:10 [0.000056] [79.135.107.81] [599785149] [10] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfFlashFilter"
2019-02-28 12:40:10 [0.000063] [79.135.107.81] [599785149] [11] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfExecutionFilter"
2019-02-28 12:40:10 [0.007375] [79.135.107.81] [599785149] [12] [PS2] [KalturaPDO->__construct] DEBUG: conn took - 0.005950927734375 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura;
2019-02-28 12:40:10 [0.000154] [79.135.107.81] [599785149] [13] [PS2] [Propel::initConnection] NOTICE: total conn took 0.006187915802002 mysql:host=127.0.0.1;port=3306;dbname=kaltura;
2019-02-28 12:40:10 [0.000317] [79.135.107.81] [599785149] [14] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT partner.ID, partner.PARTNER_NAME, partner.PARTNER_ALIAS, partner.URL1, partner.URL2, partner.SECRET, partner.ADMIN_SECRET, partner.MAX_NUMBER_OF_HITS_PER_DAY, partner.APPEAR_IN_SEARCH, partner.DEBUG_LEVEL, partner.CREATED_AT, partner.UPDATED_AT, partner.ANONYMOUS_KUSER_ID, partner.KS_MAX_EXPIRY_IN_SECONDS, partner.CREATE_USER_ON_DEMAND, partner.PREFIX, partner.ADMIN_NAME, partner.ADMIN_EMAIL, partner.DESCRIPTION, partner.COMMERCIAL_USE, partner.MODERATE_CONTENT, partner.NOTIFY, partner.CUSTOM_DATA, partner.SERVICE_CONFIG_ID, partner.STATUS, partner.CONTENT_CATEGORIES, partner.TYPE, partner.PHONE, partner.DESCRIBE_YOURSELF, partner.ADULT_CONTENT, partner.PARTNER_PACKAGE, partner.USAGE_PERCENT, partner.STORAGE_USAGE, partner.EIGHTY_PERCENT_WARNING, partner.USAGE_LIMIT_WARNING, partner.MONITOR_USAGE, partner.PRIORITY_GROUP_ID, partner.PARTNER_GROUP_TYPE, partner.PARTNER_PARENT_ID, partner.KMC_VERSION FROM `partner` WHERE partner.ID='102'
2019-02-28 12:40:10 [0.000604] [79.135.107.81] [599785149] [15] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00048208236694336 seconds
2019-02-28 12:40:10 [0.000641] [79.135.107.81] [599785149] [16] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT permission.ID, permission.TYPE, permission.NAME, permission.FRIENDLY_NAME, permission.DESCRIPTION, permission.PARTNER_ID, permission.STATUS, permission.DEPENDS_ON_PERMISSION_NAMES, permission.TAGS, permission.CREATED_AT, permission.UPDATED_AT, permission.CUSTOM_DATA FROM `permission` WHERE permission.PARTNER_ID IN ('102','0') AND permission.NAME='FEATURE_ENTITLEMENT' ORDER BY permission.STATUS ASC LIMIT 1
2019-02-28 12:40:10 [0.000520] [79.135.107.81] [599785149] [17] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00042390823364258 seconds
2019-02-28 12:40:10 [0.001321] [79.135.107.81] [599785149] [18] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT entry.ID, entry.KSHOW_ID, entry.KUSER_ID, entry.NAME, entry.TYPE, entry.MEDIA_TYPE, entry.DATA, entry.THUMBNAIL, entry.VIEWS, entry.VOTES, entry.COMMENTS, entry.FAVORITES, entry.TOTAL_RANK, entry.RANK, entry.TAGS, entry.ANONYMOUS, entry.STATUS, entry.SOURCE, entry.SOURCE_ID, entry.SOURCE_LINK, entry.LICENSE_TYPE, entry.CREDIT, entry.LENGTH_IN_MSECS, entry.CREATED_AT, entry.UPDATED_AT, entry.PARTNER_ID, entry.DISPLAY_IN_SEARCH, entry.SUBP_ID, entry.CUSTOM_DATA, entry.SCREEN_NAME, entry.SITE_URL, entry.PERMISSIONS, entry.GROUP_ID, entry.PLAYS, entry.PARTNER_DATA, entry.INT_ID, entry.INDEXED_CUSTOM_DATA_1, entry.DESCRIPTION, entry.MEDIA_DATE, entry.ADMIN_TAGS, entry.MODERATION_STATUS, entry.MODERATION_COUNT, entry.MODIFIED_AT, entry.PUSER_ID, entry.ACCESS_CONTROL_ID, entry.CONVERSION_PROFILE_ID, entry.CATEGORIES, entry.CATEGORIES_IDS, entry.START_DATE, entry.END_DATE, entry.FLAVOR_PARAMS_IDS, entry.AVAILABLE_FROM, entry.LAST_PLAYED_AT FROM `entry` WHERE entry.ID='0_lny95kk4'
2019-02-28 12:40:10 [0.000473] [79.135.107.81] [599785149] [19] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00037193298339844 seconds
2019-02-28 12:40:10 [0.001161] [79.135.107.81] [599785149] [20] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT access_control.ID, access_control.PARTNER_ID, access_control.NAME, access_control.SYSTEM_NAME, access_control.DESCRIPTION, access_control.CREATED_AT, access_control.UPDATED_AT, access_control.DELETED_AT, access_control.SITE_RESTRICT_TYPE, access_control.SITE_RESTRICT_LIST, access_control.COUNTRY_RESTRICT_TYPE, access_control.COUNTRY_RESTRICT_LIST, access_control.KS_RESTRICT_PRIVILEGE, access_control.PRV_RESTRICT_PRIVILEGE, access_control.PRV_RESTRICT_LENGTH, access_control.KDIR_RESTRICT_TYPE, access_control.CUSTOM_DATA, access_control.RULES FROM `access_control` WHERE access_control.ID IS NULL  AND access_control.DELETED_AT IS NULL
2019-02-28 12:40:10 [0.000333] [79.135.107.81] [599785149] [21] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00023412704467773 seconds
2019-02-28 12:40:10 [0.002264] [79.135.107.81] [599785149] [22] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT flavor_asset.ID, flavor_asset.INT_ID, flavor_asset.PARTNER_ID, flavor_asset.TAGS, flavor_asset.CREATED_AT, flavor_asset.UPDATED_AT, flavor_asset.DELETED_AT, flavor_asset.ENTRY_ID, flavor_asset.FLAVOR_PARAMS_ID, flavor_asset.STATUS, flavor_asset.VERSION, flavor_asset.DESCRIPTION, flavor_asset.WIDTH, flavor_asset.HEIGHT, flavor_asset.BITRATE, flavor_asset.FRAME_RATE, flavor_asset.SIZE, flavor_asset.IS_ORIGINAL, flavor_asset.FILE_EXT, flavor_asset.CONTAINER_FORMAT, flavor_asset.VIDEO_CODEC_ID, flavor_asset.TYPE, flavor_asset.CUSTOM_DATA FROM `flavor_asset` WHERE flavor_asset.ENTRY_ID='0_lny95kk4' AND (flavor_asset.STATUS='2' AND flavor_asset.STATUS<>'3') AND flavor_asset.TYPE IN ('1','10010','10009','10008','10011','3')
2019-02-28 12:40:10 [0.000582] [79.135.107.81] [599785149] [23] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00047111511230469 seconds
2019-02-28 12:40:10 [0.001213] [79.135.107.81] [599785149] [24] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_0m54qnxf' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000502] [79.135.107.81] [599785149] [25] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00037789344787598 seconds
2019-02-28 12:40:10 [0.000414] [79.135.107.81] [599785149] [26] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_r74t6v3k' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000432] [79.135.107.81] [599785149] [27] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00033879280090332 seconds
2019-02-28 12:40:10 [0.000402] [79.135.107.81] [599785149] [28] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_dsxy91jf' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000422] [79.135.107.81] [599785149] [29] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00032711029052734 seconds
2019-02-28 12:40:10 [0.000406] [79.135.107.81] [599785149] [30] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_hies45s9' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000435] [79.135.107.81] [599785149] [31] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00032615661621094 seconds
2019-02-28 12:40:10 [0.000596] [79.135.107.81] [599785149] [32] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT storage_profile.ID, storage_profile.CREATED_AT, storage_profile.UPDATED_AT, storage_profile.PARTNER_ID, storage_profile.NAME, storage_profile.SYSTEM_NAME, storage_profile.DESCIPTION, storage_profile.STATUS, storage_profile.PROTOCOL, storage_profile.STORAGE_URL, storage_profile.STORAGE_BASE_DIR, storage_profile.STORAGE_USERNAME, storage_profile.STORAGE_PASSWORD, storage_profile.STORAGE_FTP_PASSIVE_MODE, storage_profile.MIN_FILE_SIZE, storage_profile.MAX_FILE_SIZE, storage_profile.FLAVOR_PARAMS_IDS, storage_profile.MAX_CONCURRENT_CONNECTIONS, storage_profile.CUSTOM_DATA, storage_profile.PATH_MANAGER_CLASS, storage_profile.DELIVERY_PRIORITY, storage_profile.DELIVERY_STATUS FROM `storage_profile` WHERE storage_profile.PARTNER_ID='102' AND storage_profile.STATUS IN ('2','3') AND storage_profile.ID IN ('1')
2019-02-28 12:40:10 [0.000394] [79.135.107.81] [599785149] [33] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00029206275939941 seconds
2019-02-28 12:40:10 [0.000743] [79.135.107.81] [599785149] [34] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_0m54qnxf' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000471] [79.135.107.81] [599785149] [35] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00036978721618652 seconds
2019-02-28 12:40:10 [0.000491] [79.135.107.81] [599785149] [36] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_r74t6v3k' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000436] [79.135.107.81] [599785149] [37] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0003349781036377 seconds
2019-02-28 12:40:10 [0.000332] [79.135.107.81] [599785149] [38] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_dsxy91jf' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000438] [79.135.107.81] [599785149] [39] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00033402442932129 seconds
2019-02-28 12:40:10 [0.000331] [79.135.107.81] [599785149] [40] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[599785149][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_hies45s9' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000448] [79.135.107.81] [599785149] [41] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00035309791564941 seconds
2019-02-28 12:40:10 [0.000495] [79.135.107.81] [599785149] [42] [PS2] [DeliveryProfilePeer::getRemoteDeliveryByStorageId] ERR: exception 'Exception' with message 'Delivery ID can't be determined for storageId [1] ( PartnerId [102] ) and streamer type [ applehttp ]' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/DeliveryProfilePeer.php(457): KalturaLog::err('Delivery ID can...')
#1 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(832): DeliveryProfilePeer::getRemoteDeliveryByStorageId(Object(DeliveryProfileDynamicAttributes))
#2 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(944): playManifestAction->initDeliveryProfile()
#3 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(1264): playManifestAction->serveVodEntry()
#4 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(905): playManifestAction->execute()
#5 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfExecutionFilter->execute(Object(sfFilterChain))
#6 /opt/kaltura/app/vendor/symfony/filter/sfFlashFilter.class.php(50): sfFilterChain->execute()
#7 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfFlashFilter->execute(Object(sfFilterChain))
#8 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(830): sfFilterChain->execute()
#9 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfCommonFilter->execute(Object(sfFilterChain))
#10 /opt/kaltura/app/alpha/apps/kaltura/lib/filter/myHealthCheckAndSecurityFilter.class.php(65): sfFilterChain->execute()
#11 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): myHealthCheckAndSecurityFilter->execute(Object(sfFilterChain))
#12 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(974): sfFilterChain->execute()

#7

Verbose log continued

#13 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfRenderingFilter->execute(Object(sfFilterChain))
#14 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(576): sfFilterChain->execute()
#15 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(2228): sfController->forward('extwidget', 'playManifest')
#16 /opt/kaltura/app/alpha/bootstrap.php(28): sfFrontWebController->dispatch()
#17 /opt/kaltura/app/alpha/web/index.php(264): require_once('/opt/kaltura/ap...')
#18 {main}
2019-02-28 12:40:10 [0.000136] [79.135.107.81] [599785149] [43] [PS2] [KExternalErrors::dieError] ERR: exception 'Exception' with message 'exiting on error 25 - wrong query attributes, This format is unsupported' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(136): KalturaLog::err('exiting on erro...')
#1 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(1280): KExternalErrors::dieError(25, 'This format is ...')
#2 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(905): playManifestAction->execute()
#3 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfExecutionFilter->execute(Object(sfFilterChain))
#4 /opt/kaltura/app/vendor/symfony/filter/sfFlashFilter.class.php(50): sfFilterChain->execute()
#5 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfFlashFilter->execute(Object(sfFilterChain))
#6 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(830): sfFilterChain->execute()
#7 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfCommonFilter->execute(Object(sfFilterChain))
#8 /opt/kaltura/app/alpha/apps/kaltura/lib/filter/myHealthCheckAndSecurityFilter.class.php(65): sfFilterChain->execute()
#9 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): myHealthCheckAndSecurityFilter->execute(Object(sfFilterChain))
#10 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(974): sfFilterChain->execute()
#11 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfRenderingFilter->execute(Object(sfFilterChain))
#12 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(576): sfFilterChain->execute()
#13 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(2228): sfController->forward('extwidget', 'playManifest')
#14 /opt/kaltura/app/alpha/bootstrap.php(28): sfFrontWebController->dispatch()
#15 /opt/kaltura/app/alpha/web/index.php(264): require_once('/opt/kaltura/ap...')
#16 {main}
2019-02-28 12:40:10 [0.000088] [79.135.107.81] [599785149] [44] [PS2] [KExternalErrors::terminateDispatch] DEBUG: Dispatch took - 0.031312942504883 seconds, memory: 7077888
2019-02-28 12:40:10 [0.003427] [79.135.107.81] [437805211] [1] [PS2] [sfContext->initialize] INFO: {sfContext} initialization
2019-02-28 12:40:10 [0.000157] [79.135.107.81] [437805211] [2] [PS2] [sfController->initialize] INFO: {sfController} initialization
2019-02-28 12:40:10 [0.000225] [79.135.107.81] [437805211] [3] [PS2] [sfRouting->parse] INFO: {sfRouting} match route [default] "/:module/:action/*"
2019-02-28 12:40:10 [0.000098] [79.135.107.81] [437805211] [4] [PS2] [sfWebRequest->loadParameters] INFO: {sfRequest} request parameters array (  'referrer' => 'aHR0cDovL2thbHR1cmEuc2NhcmxldHRlbnRlcnRhaW5tZW50LmNvbQ==',  'ks' => 'MzEyNjA0NWRjMTZkNGMzZGI1MDI2ODgzMDJiMTZlNjM1ZTgxZjIxNXwxMDI7MTAyOzE1NTE0MzYyNTg7MjsxNTUxMzQ5ODU4LjgyMzttaWNoYWVsQHNjYXJsZXR0ZW50ZXJ0YWlubWVudC5jb207ZGlzYWJsZWVudGl0bGVtZW50LGFwcGlkOmttYzs7',  'playSessionId' => '3fa5c791-82ef-8fde-20d3-5d1de6e0caea',  'clientTag' => 'html5:v2.74.3',  'uiConfId' => '23448222',  'module' => 'extwidget',  'action' => 'playManifest',  'entryId' => '0_lny95kk4',  'flavorIds' => '0_0m54qnxf,0_r74t6v3k,0_dsxy91jf,0_hies45s9',  'format' => 'applehttp',  'protocol' => 'http',)
2019-02-28 12:40:10 [0.000118] [79.135.107.81] [437805211] [5] [PS2] [sfFrontWebController->dispatch] INFO: {sfController} dispatch request
2019-02-28 12:40:10 [0.000432] [79.135.107.81] [437805211] [6] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfRenderingFilter"
2019-02-28 12:40:10 [0.000070] [79.135.107.81] [437805211] [7] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "myHealthCheckAndSecurityFilter"
2019-02-28 12:40:10 [0.000214] [79.135.107.81] [437805211] [8] [PS2] [myHealthCheckAndSecurityFilter->basicSecureRequest] WARN: basicSecureRequest: took [0.00013303756713867] seconds
2019-02-28 12:40:10 [0.000065] [79.135.107.81] [437805211] [9] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfCommonFilter"
2019-02-28 12:40:10 [0.000055] [79.135.107.81] [437805211] [10] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfFlashFilter"
2019-02-28 12:40:10 [0.000061] [79.135.107.81] [437805211] [11] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfExecutionFilter"
2019-02-28 12:40:10 [0.001932] [79.135.107.81] [437805211] [12] [PS2] [KalturaPDO->__construct] DEBUG: conn took - 0.00060796737670898 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura;
2019-02-28 12:40:10 [0.000122] [79.135.107.81] [437805211] [13] [PS2] [Propel::initConnection] NOTICE: total conn took 0.00077986717224121 mysql:host=127.0.0.1;port=3306;dbname=kaltura;
2019-02-28 12:40:10 [0.000315] [79.135.107.81] [437805211] [14] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT partner.ID, partner.PARTNER_NAME, partner.PARTNER_ALIAS, partner.URL1, partner.URL2, partner.SECRET, partner.ADMIN_SECRET, partner.MAX_NUMBER_OF_HITS_PER_DAY, partner.APPEAR_IN_SEARCH, partner.DEBUG_LEVEL, partner.CREATED_AT, partner.UPDATED_AT, partner.ANONYMOUS_KUSER_ID, partner.KS_MAX_EXPIRY_IN_SECONDS, partner.CREATE_USER_ON_DEMAND, partner.PREFIX, partner.ADMIN_NAME, partner.ADMIN_EMAIL, partner.DESCRIPTION, partner.COMMERCIAL_USE, partner.MODERATE_CONTENT, partner.NOTIFY, partner.CUSTOM_DATA, partner.SERVICE_CONFIG_ID, partner.STATUS, partner.CONTENT_CATEGORIES, partner.TYPE, partner.PHONE, partner.DESCRIBE_YOURSELF, partner.ADULT_CONTENT, partner.PARTNER_PACKAGE, partner.USAGE_PERCENT, partner.STORAGE_USAGE, partner.EIGHTY_PERCENT_WARNING, partner.USAGE_LIMIT_WARNING, partner.MONITOR_USAGE, partner.PRIORITY_GROUP_ID, partner.PARTNER_GROUP_TYPE, partner.PARTNER_PARENT_ID, partner.KMC_VERSION FROM `partner` WHERE partner.ID='102'
2019-02-28 12:40:10 [0.000587] [79.135.107.81] [437805211] [15] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0004889965057373 seconds
2019-02-28 12:40:10 [0.000633] [79.135.107.81] [437805211] [16] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT permission.ID, permission.TYPE, permission.NAME, permission.FRIENDLY_NAME, permission.DESCRIPTION, permission.PARTNER_ID, permission.STATUS, permission.DEPENDS_ON_PERMISSION_NAMES, permission.TAGS, permission.CREATED_AT, permission.UPDATED_AT, permission.CUSTOM_DATA FROM `permission` WHERE permission.PARTNER_ID IN ('102','0') AND permission.NAME='FEATURE_ENTITLEMENT' ORDER BY permission.STATUS ASC LIMIT 1
2019-02-28 12:40:10 [0.000490] [79.135.107.81] [437805211] [17] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00039219856262207 seconds
2019-02-28 12:40:10 [0.001200] [79.135.107.81] [437805211] [18] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT entry.ID, entry.KSHOW_ID, entry.KUSER_ID, entry.NAME, entry.TYPE, entry.MEDIA_TYPE, entry.DATA, entry.THUMBNAIL, entry.VIEWS, entry.VOTES, entry.COMMENTS, entry.FAVORITES, entry.TOTAL_RANK, entry.RANK, entry.TAGS, entry.ANONYMOUS, entry.STATUS, entry.SOURCE, entry.SOURCE_ID, entry.SOURCE_LINK, entry.LICENSE_TYPE, entry.CREDIT, entry.LENGTH_IN_MSECS, entry.CREATED_AT, entry.UPDATED_AT, entry.PARTNER_ID, entry.DISPLAY_IN_SEARCH, entry.SUBP_ID, entry.CUSTOM_DATA, entry.SCREEN_NAME, entry.SITE_URL, entry.PERMISSIONS, entry.GROUP_ID, entry.PLAYS, entry.PARTNER_DATA, entry.INT_ID, entry.INDEXED_CUSTOM_DATA_1, entry.DESCRIPTION, entry.MEDIA_DATE, entry.ADMIN_TAGS, entry.MODERATION_STATUS, entry.MODERATION_COUNT, entry.MODIFIED_AT, entry.PUSER_ID, entry.ACCESS_CONTROL_ID, entry.CONVERSION_PROFILE_ID, entry.CATEGORIES, entry.CATEGORIES_IDS, entry.START_DATE, entry.END_DATE, entry.FLAVOR_PARAMS_IDS, entry.AVAILABLE_FROM, entry.LAST_PLAYED_AT FROM `entry` WHERE entry.ID='0_lny95kk4'
2019-02-28 12:40:10 [0.000489] [79.135.107.81] [437805211] [19] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0003659725189209 seconds
2019-02-28 12:40:10 [0.001003] [79.135.107.81] [437805211] [20] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT access_control.ID, access_control.PARTNER_ID, access_control.NAME, access_control.SYSTEM_NAME, access_control.DESCRIPTION, access_control.CREATED_AT, access_control.UPDATED_AT, access_control.DELETED_AT, access_control.SITE_RESTRICT_TYPE, access_control.SITE_RESTRICT_LIST, access_control.COUNTRY_RESTRICT_TYPE, access_control.COUNTRY_RESTRICT_LIST, access_control.KS_RESTRICT_PRIVILEGE, access_control.PRV_RESTRICT_PRIVILEGE, access_control.PRV_RESTRICT_LENGTH, access_control.KDIR_RESTRICT_TYPE, access_control.CUSTOM_DATA, access_control.RULES FROM `access_control` WHERE access_control.ID IS NULL  AND access_control.DELETED_AT IS NULL
2019-02-28 12:40:10 [0.000337] [79.135.107.81] [437805211] [21] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00023889541625977 seconds
2019-02-28 12:40:10 [0.001914] [79.135.107.81] [437805211] [22] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT flavor_asset.ID, flavor_asset.INT_ID, flavor_asset.PARTNER_ID, flavor_asset.TAGS, flavor_asset.CREATED_AT, flavor_asset.UPDATED_AT, flavor_asset.DELETED_AT, flavor_asset.ENTRY_ID, flavor_asset.FLAVOR_PARAMS_ID, flavor_asset.STATUS, flavor_asset.VERSION, flavor_asset.DESCRIPTION, flavor_asset.WIDTH, flavor_asset.HEIGHT, flavor_asset.BITRATE, flavor_asset.FRAME_RATE, flavor_asset.SIZE, flavor_asset.IS_ORIGINAL, flavor_asset.FILE_EXT, flavor_asset.CONTAINER_FORMAT, flavor_asset.VIDEO_CODEC_ID, flavor_asset.TYPE, flavor_asset.CUSTOM_DATA FROM `flavor_asset` WHERE flavor_asset.ENTRY_ID='0_lny95kk4' AND (flavor_asset.STATUS='2' AND flavor_asset.STATUS<>'3') AND flavor_asset.TYPE IN ('1','10010','10009','10008','10011','3')
2019-02-28 12:40:10 [0.000529] [79.135.107.81] [437805211] [23] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0004279613494873 seconds
2019-02-28 12:40:10 [0.001073] [79.135.107.81] [437805211] [24] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_0m54qnxf' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000469] [79.135.107.81] [437805211] [25] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00036406517028809 seconds
2019-02-28 12:40:10 [0.000427] [79.135.107.81] [437805211] [26] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_r74t6v3k' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000419] [79.135.107.81] [437805211] [27] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00032401084899902 seconds
2019-02-28 12:40:10 [0.000402] [79.135.107.81] [437805211] [28] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_dsxy91jf' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000417] [79.135.107.81] [437805211] [29] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00032281875610352 seconds
2019-02-28 12:40:10 [0.000379] [79.135.107.81] [437805211] [30] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT file_sync.ID, file_sync.PARTNER_ID, file_sync.OBJECT_TYPE, file_sync.OBJECT_ID, file_sync.VERSION, file_sync.OBJECT_SUB_TYPE, file_sync.DC, file_sync.ORIGINAL, file_sync.CREATED_AT, file_sync.UPDATED_AT, file_sync.READY_AT, file_sync.SYNC_TIME, file_sync.STATUS, file_sync.FILE_TYPE, file_sync.LINKED_ID, file_sync.LINK_COUNT, file_sync.FILE_ROOT, file_sync.FILE_PATH, file_sync.FILE_SIZE, file_sync.CUSTOM_DATA, file_sync.DELETED_ID FROM `file_sync` WHERE file_sync.OBJECT_ID='0_hies45s9' AND file_sync.OBJECT_TYPE='4' AND file_sync.OBJECT_SUB_TYPE='1' AND file_sync.VERSION='2' AND (file_sync.STATUS='2' AND file_sync.STATUS NOT IN ('3','4'))
2019-02-28 12:40:10 [0.000513] [79.135.107.81] [437805211] [31] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00041818618774414 seconds
2019-02-28 12:40:10 [0.000529] [79.135.107.81] [437805211] [32] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT storage_profile.ID, storage_profile.CREATED_AT, storage_profile.UPDATED_AT, storage_profile.PARTNER_ID, storage_profile.NAME, storage_profile.SYSTEM_NAME, storage_profile.DESCIPTION, storage_profile.STATUS, storage_profile.PROTOCOL, storage_profile.STORAGE_URL, storage_profile.STORAGE_BASE_DIR, storage_profile.STORAGE_USERNAME, storage_profile.STORAGE_PASSWORD, storage_profile.STORAGE_FTP_PASSIVE_MODE, storage_profile.MIN_FILE_SIZE, storage_profile.MAX_FILE_SIZE, storage_profile.FLAVOR_PARAMS_IDS, storage_profile.MAX_CONCURRENT_CONNECTIONS, storage_profile.CUSTOM_DATA, storage_profile.PATH_MANAGER_CLASS, storage_profile.DELIVERY_PRIORITY, storage_profile.DELIVERY_STATUS FROM `storage_profile` WHERE storage_profile.PARTNER_ID='102' AND storage_profile.STATUS IN ('2','3') AND storage_profile.ID IN ('1')
2019-02-28 12:40:10 [0.000401] [79.135.107.81] [437805211] [33] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00030899047851562 seconds
2019-02-28 12:40:10 [0.000690] [79.135.107.81] [437805211] [34] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_0m54qnxf' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000470] [79.135.107.81] [437805211] [35] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00037312507629395 seconds
2019-02-28 12:40:10 [0.000472] [79.135.107.81] [437805211] [36] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_r74t6v3k' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000448] [79.135.107.81] [437805211] [37] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00035309791564941 seconds
2019-02-28 12:40:10 [0.000317] [79.135.107.81] [437805211] [38] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_dsxy91jf' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000437] [79.135.107.81] [437805211] [39] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00034379959106445 seconds
2019-02-28 12:40:10 [0.000321] [79.135.107.81] [437805211] [40] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[437805211][propel] */ SELECT media_info.ID, media_info.CREATED_AT, media_info.UPDATED_AT, media_info.FLAVOR_ASSET_ID, media_info.FILE_SIZE, media_info.CONTAINER_FORMAT, media_info.CONTAINER_ID, media_info.CONTAINER_PROFILE, media_info.CONTAINER_DURATION, media_info.CONTAINER_BIT_RATE, media_info.VIDEO_FORMAT, media_info.VIDEO_CODEC_ID, media_info.VIDEO_DURATION, media_info.VIDEO_BIT_RATE, media_info.VIDEO_BIT_RATE_MODE, media_info.VIDEO_WIDTH, media_info.VIDEO_HEIGHT, media_info.VIDEO_FRAME_RATE, media_info.VIDEO_DAR, media_info.VIDEO_ROTATION, media_info.AUDIO_FORMAT, media_info.AUDIO_CODEC_ID, media_info.AUDIO_DURATION, media_info.AUDIO_BIT_RATE, media_info.AUDIO_BIT_RATE_MODE, media_info.AUDIO_CHANNELS, media_info.AUDIO_SAMPLING_RATE, media_info.AUDIO_RESOLUTION, media_info.WRITING_LIB, media_info.CUSTOM_DATA, media_info.RAW_DATA, media_info.MULTI_STREAM_INFO, media_info.FLAVOR_ASSET_VERSION, media_info.SCAN_TYPE, media_info.MULTI_STREAM FROM `media_info` WHERE media_info.FLAVOR_ASSET_ID='0_hies45s9' ORDER BY media_info.ID DESC LIMIT 1
2019-02-28 12:40:10 [0.000427] [79.135.107.81] [437805211] [41] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0003349781036377 seconds
2019-02-28 12:40:10 [0.000535] [79.135.107.81] [437805211] [42] [PS2] [DeliveryProfilePeer::getRemoteDeliveryByStorageId] ERR: exception 'Exception' with message 'Delivery ID can't be determined for storageId [1] ( PartnerId [102] ) and streamer type [ applehttp ]' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/DeliveryProfilePeer.php(457): KalturaLog::err('Delivery ID can...')
#1 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(832): DeliveryProfilePeer::getRemoteDeliveryByStorageId(Object(DeliveryProfileDynamicAttributes))
#2 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(944): playManifestAction->initDeliveryProfile()
#3 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(1264): playManifestAction->serveVodEntry()
#4 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(905): playManifestAction->execute()
#5 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfExecutionFilter->execute(Object(sfFilterChain))
#6 /opt/kaltura/app/vendor/symfony/filter/sfFlashFilter.class.php(50): sfFilterChain->execute()
#7 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfFlashFilter->execute(Object(sfFilterChain))
#8 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(830): sfFilterChain->execute()
#9 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfCommonFilter->execute(Object(sfFilterChain))
#10 /opt/kaltura/app/alpha/apps/kaltura/lib/filter/myHealthCheckAndSecurityFilter.class.php(65): sfFilterChain->execute()
#11 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): myHealthCheckAndSecurityFilter->execute(Object(sfFilterChain))
#12 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(974): sfFilterChain->execute()
#13 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfRenderingFilter->execute(Object(sfFilterChain))
#14 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(576): sfFilterChain->execute()
#15 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(2228): sfController->forward('extwidget', 'playManifest')
#16 /opt/kaltura/app/alpha/bootstrap.php(28): sfFrontWebController->dispatch()
#17 /opt/kaltura/app/alpha/web/index.php(264): require_once('/opt/kaltura/ap...')
#18 {main}
2019-02-28 12:40:10 [0.000135] [79.135.107.81] [437805211] [43] [PS2] [KExternalErrors::dieError] ERR: exception 'Exception' with message 'exiting on error 25 - wrong query attributes, This format is unsupported' in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(136): KalturaLog::err('exiting on erro...')
#1 /opt/kaltura/app/alpha/apps/kaltura/modules/extwidget/actions/playManifestAction.class.php(1280): KExternalErrors::dieError(25, 'This format is ...')
#2 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(905): playManifestAction->execute()
#3 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfExecutionFilter->execute(Object(sfFilterChain))
#4 /opt/kaltura/app/vendor/symfony/filter/sfFlashFilter.class.php(50): sfFilterChain->execute()
#5 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfFlashFilter->execute(Object(sfFilterChain))
#6 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(830): sfFilterChain->execute()
#7 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfCommonFilter->execute(Object(sfFilterChain))
#8 /opt/kaltura/app/alpha/apps/kaltura/lib/filter/myHealthCheckAndSecurityFilter.class.php(65): sfFilterChain->execute()
#9 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): myHealthCheckAndSecurityFilter->execute(Object(sfFilterChain))
#10 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(974): sfFilterChain->execute()
#11 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(1006): sfRenderingFilter->execute(Object(sfFilterChain))
#12 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(576): sfFilterChain->execute()
#13 /opt/kaltura/app/cache/alpha/kaltura/prod/config/config_core_compile.yml.php(2228): sfController->forward('extwidget', 'playManifest')
#14 /opt/kaltura/app/alpha/bootstrap.php(28): sfFrontWebController->dispatch()
#15 /opt/kaltura/app/alpha/web/index.php(264): require_once('/opt/kaltura/ap...')
#16 {main}
2019-02-28 12:40:10 [0.000102] [79.135.107.81] [437805211] [44] [PS2] [KExternalErrors::terminateDispatch] DEBUG: Dispatch took - 0.02380108833313 seconds, memory: 6815744

#8

I edited out the domain and changed the cf url for privacy reasons :slight_smile:


#9

Hi @michael_hall,

I don’t see the query used to discern which delivery profile to use in your output. It should be similar to the below :

SELECT delivery_profile.ID, delivery_profile.TYPE, delivery_profile.CREATED_AT, delivery_profile.UPDATED_AT, delivery_profile.PARTNER_ID, delivery_profile.NAME, delivery_profile.SYSTEM_NAME, delivery_profile.DESCRIPTION, delivery_profile.URL, delivery_profile.HOST_NAME, delivery_profile.IS_DEFAULT, delivery_profile.PARENT_ID, delivery_profile.RECOGNIZER, delivery_profile.TOKENIZER, delivery_profile.STATUS, delivery_profile.STREAMER_TYPE, delivery_profile.MEDIA_PROTOCOLS, delivery_profile.CUSTOM_DATA, delivery_profile.PRIORITY FROM `delivery_profile` WHERE delivery_profile.IS_DEFAULT='1' AND delivery_profile.PARTNER_ID='0' AND delivery_profile.STREAMER_TYPE='applehttp' AND delivery_profile.TYPE NOT IN ('10138','10139','1013','1002','1001','1003','1005','1006','1007','1008','1009','1010') AND delivery_profile.STATUS IN ('0','3') ORDER BY (delivery_profile.HOST_NAME is not null) DESC,(delivery_profile.TOKENIZER is not null) DESC,(delivery_profile.PARTNER_ID<>102) ASC,delivery_profile.PRIORITY ASC

and is logged in /opt/kaltura/log/kaltura_prod.log

Also, let’s see the full contents of deliver_profile [mask sensitive info as you’ve done before] and with an easier to read formatting, so:

mysql> select * from delivery_profile\G

#10

I couldn’t find a more recent entry in the log than this one:

2019-02-28 10:27:56 [0.001249] [79.135.107.81] [1765887607] [30] [PS2] [KalturaStatement->execute] DEBUG: /* ip-172-26-7-87.eu-west-2.compute.internal[1765887607][propel] */ SELECT delivery_profile.ID, delivery_profile.TYPE, delivery_profile.CREATED_AT, delivery_profile.UPDATED_AT, delivery_profile.PARTNER_ID, delivery_profile.NAME, delivery_profile.SYSTEM_NAME, delivery_profile.DESCRIPTION, delivery_profile.URL, delivery_profile.HOST_NAME, delivery_profile.IS_DEFAULT, delivery_profile.PARENT_ID, delivery_profile.RECOGNIZER, delivery_profile.TOKENIZER, delivery_profile.STATUS, delivery_profile.STREAMER_TYPE, delivery_profile.MEDIA_PROTOCOLS, delivery_profile.CUSTOM_DATA, delivery_profile.PRIORITY FROMdelivery_profileWHERE delivery_profile.IS_DEFAULT='1' AND delivery_profile.PARTNER_ID='0' AND delivery_profile.STREAMER_TYPE='applehttp' AND delivery_profile.TYPE NOT IN ('10138','10139','1013','1002','1001','1003','1005','1006','1007','1008','1009','1010') AND delivery_profile.STATUS IN ('0','3') ORDER BY (delivery_profile.HOST_NAME is not null) DESC,(delivery_profile.TOKENIZER is not null) DESC,(delivery_profile.PARTNER_ID<>102) ASC,delivery_profile.PRIORITY ASC

MySQL output:

MariaDB [kaltura]> select * from delivery_profile\G
*************************** 1. row ***************************
             id: 1
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HTTP Delivery Profile
           type: 10
    system_name: Default_Akamai_HLS_direct
    description: Default Akamai HLS direct
            url: kaltura.xxxxx.com
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: applehttp
     is_default: 0
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 2. row ***************************
             id: 2
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HTTP Delivery Profile
           type: 14
    system_name: Default HTTP Delivery Profile
    description: Default HTTP Delivery Profile
            url: kaltura.xxxxx.com
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: http
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 3. row ***************************
             id: 3
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HLS Live Delivery Profile
           type: 1001
    system_name: Default_HLS_Live_Delivery_Profile
    description: Default HLS Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: applehttp
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 4. row ***************************
             id: 4
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HLS Network Live Delivery Profile
           type: 1001
    system_name: Default_HLS_Network_Live_Delivery_Profile
    description: Default HLS Nework Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: hls
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 5. row ***************************
             id: 5
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HLS To Multicast Live Delivery Profile
           type: 1006
    system_name: Default_HLS_To_Multicast_Live_Delivery_Profile
    description: Default HLS To Multicast Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: applehttp_to_mc
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 6. row ***************************
             id: 301
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default MPEG-DASH Live Delivery Profile
           type: 1003
    system_name: Default MPEG-DASH Live Delivery Profile
    description: Default MPEG-DASH Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: mpegdash
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 7. row ***************************
             id: 302
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HD Network Live Delivery Profile
           type: 1002
    system_name: Default_HD_Network_Live_Delivery_Profile
    description: Default HD Network Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: hdnetworkmanifest
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 8. row ***************************
             id: 303
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default HDS Live Delivery Profile
           type: 1002
    system_name: Default_HDS_Live_Delivery_Profile
    description: Default HDS Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: hds
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 9. row ***************************
             id: 304
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura Live Packager Dash segmentation
           type: 1009
    system_name: LIVE_PACKAGER_DASH
    description: Kaltura Live Packager Dash segmentation
            url: kaltura.xxxxx.com:88/live/dash
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: mpegdash
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 10. row ***************************
             id: 305
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura Live Packager HDS segmentation
           type: 1008
    system_name: LIVE_PACKAGER_HDS
    description: Kaltura Live Packager HDS segmentation
            url: kaltura.xxxxx.com:88/live/hds
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: hds
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 11. row ***************************
             id: 306
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura Live Packager HLS segmentation
           type: 1007
    system_name: LIVE_PACKAGER_HLS
    description: Kaltura Live Packager HLS segmentation
            url: kaltura.xxxxx.com:88/live/hls
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: applehttp
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 12. row ***************************
             id: 307
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura Live Packager MSS segmentation
           type: 1010
    system_name: LIVE_PACKAGER_MSS
    description: Kaltura Live Packager MSS segmentation
            url: kaltura.xxxxx.com:88/live/mss
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: sl
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 13. row ***************************
             id: 308
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Default RTMP Live Delivery Profile
           type: 1005
    system_name: Default_RTMP_Live_Delivery_Profile
    description: Default RTMP Live Delivery Profile
            url: NULL
      host_name: NULL
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: rtmp
     is_default: 1
      parent_id: 0
    custom_data: a:1:{s:12:"enforceRtmpe";s:1:"0";}
       priority: 0
*************************** 14. row ***************************
             id: 1001
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura HLS segmentation
           type: 61
    system_name: Kaltura HLS segmentation
    description: Kaltura HLS segmentation
            url: kaltura.xxxxx.com:88/hls
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: applehttp
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 15. row ***************************
             id: 1002
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura HDS segmentation
           type: 63
    system_name: Kaltura HDS segmentation
    description: Kaltura HDS segmentation
            url: kaltura.xxxxx.com:88/hds
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: hdnetworkmanifest
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 16. row ***************************
             id: 1003
     partner_id: 0
     created_at: 2019-02-27 10:31:15
     updated_at: 2019-02-27 10:31:15
           name: Kaltura DASH segmentation
           type: 68
    system_name: Kaltura DASH segmentation
    description: Kaltura DASH segmentation
            url: kaltura.xxxxx.com:88/dash
      host_name: kaltura.xxxxx.com
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: NULL
  streamer_type: mpegdash
     is_default: 1
      parent_id: 0
    custom_data: NULL
       priority: 0
*************************** 17. row ***************************
             id: 1004
     partner_id: 102
     created_at: 2019-02-28 10:14:48
     updated_at: 2019-02-28 13:41:40
           name: S3 Http delivery
           type: 4
    system_name: NULL
    description: NULL
            url: http://dx45n1oi2hg6i.cloudfront.net/kaltura
      host_name: dx45n1oi2hg6i.cloudfront.net
     recognizer: NULL
      tokenizer: NULL
         status: 0
media_protocols: HTTP
  streamer_type: http
     is_default: 0
      parent_id: 0
    custom_data: NULL
       priority: 0
17 rows in set (0.00 sec)

#11

That query only seems to return a default hls delivery profile.

SELECT delivery_profile.ID, delivery_profile.TYPE, delivery_profile.CREATED_AT, delivery_profile.UPDATED_AT, delivery_profile.PARTNER_ID, delivery_profile.NAME, delivery_profile.SYSTEM_NAME, delivery_profile.DESCRIPTION, delivery_profile.URL, delivery_profile.HOST_NAME, delivery_profile.IS_DEFAULT, delivery_profile.PARENT_ID, delivery_profile.RECOGNIZER, delivery_profile.TOKENIZER, delivery_profile.STATUS, delivery_profile.STREAMER_TYPE, delivery_profile.MEDIA_PROTOCOLS, delivery_profile.CUSTOM_DATA, delivery_profile.PRIORITY FROM `delivery_profile` WHERE delivery_profile.IS_DEFAULT='1' AND delivery_profile.PARTNER_ID='0' AND delivery_profile.STREAMER_TYPE='applehttp' AND delivery_profile.TYPE NOT IN ('10138','10139','1013','1002','1001','1003','1005','1006','1007','1008','1009','1010') AND delivery_profile.STATUS IN ('0','3') ORDER BY (delivery_profile.HOST_NAME is not null) DESC,(delivery_profile.TOKENIZER is not null) DESC,(delivery_profile.PARTNER_ID<>102) ASC,delivery_profile.PRIORITY ASC

See below for similar queries


#12

These two are the only other similar ones:

SELECT delivery_profile.ID, delivery_profile.TYPE, delivery_profile.CREATED_AT, delivery_profile.UPDATED_AT, delivery_profile.PARTNER_ID, delivery_profile.NAME, delivery_profile.SYSTEM_NAME, delivery_profile.DESCRIPTION, delivery_profile.URL, delivery_profile.HOST_NAME, delivery_profile.IS_DEFAULT, delivery_profile.PARENT_ID, delivery_profile.RECOGNIZER, delivery_profile.TOKENIZER, delivery_profile.STATUS, delivery_profile.STREAMER_TYPE, delivery_profile.MEDIA_PROTOCOLS, delivery_profile.CUSTOM_DATA, delivery_profile.PRIORITY FROM `delivery_profile` WHERE delivery_profile.ID IN ('1004') AND delivery_profile.STATUS IN ('0','3')

SELECT delivery_profile.ID, delivery_profile.TYPE, delivery_profile.CREATED_AT, delivery_profile.UPDATED_AT, delivery_profile.PARTNER_ID, delivery_profile.NAME, delivery_profile.SYSTEM_NAME, delivery_profile.DESCRIPTION, delivery_profile.URL, delivery_profile.HOST_NAME, delivery_profile.IS_DEFAULT, delivery_profile.PARENT_ID, delivery_profile.RECOGNIZER, delivery_profile.TOKENIZER, delivery_profile.STATUS, delivery_profile.STREAMER_TYPE, delivery_profile.MEDIA_PROTOCOLS, delivery_profile.CUSTOM_DATA, delivery_profile.PRIORITY FROM `delivery_profile` WHERE delivery_profile.ID IN ('1004') AND delivery_profile.STATUS IN ('0','3')

Output:

±-----±-----±--------------------±--------------------±-----------±-----------------±------------±------------±--------------------------------------------±-----------------------------±-----------±----------±-----------±----------±-------±--------------±----------------±------------±---------+
| ID | TYPE | CREATED_AT | UPDATED_AT | PARTNER_ID | NAME | SYSTEM_NAME | DESCRIPTION | URL | HOST_NAME | IS_DEFAULT | PARENT_ID | RECOGNIZER | TOKENIZER | STATUS | STREAMER_TYPE | MEDIA_PROTOCOLS | CUSTOM_DATA | PRIORITY |
±-----±-----±--------------------±--------------------±-----------±-----------------±------------±------------±----------
----------------------------------±-----------------------------±-----------±----------±-----------±----------±-------±—
-----------±----------------±------------±---------+
| 1004 | 4 | 2019-02-28 10:14:48 | 2019-02-28 15:08:31 | 102 | S3 Http delivery | NULL |
NULL | http://dx45n1oi2hg6i.cloudfront.net/kaltura | dx45n1oi2hg6i.cloudfront.net | 0 |
0 | NULL | NULL | 0 | http | HTTP | NULL | 0 |
±-----±-----±--------------------±--------------------±-----------±-----------------±------------±------------±------
--------------------------------------±-----------------------------±-----------±----------±-----------±----------±-------
±--------------±----------------±------------±---------+


#13

Just to clarify I don’t think I explained properly in the beginning that I am trying to get s3 + cloudfront working.

The default install works fine. Only when I set up the cf delivery profile do I get the error. I can store in s3 no problem.


#14

Hi @michael_hall,

Please take a look at: https://github.com/kaltura/platform-install-packages/blob/Naos-14.15.0/doc/kaltura_s3_cf_integration.md#nginx-vod-configuration

Thanks,


#15

Hiya

On my first install attempt last week I followed the methodology linked above. I have just configured a fresh install and used the same instructions.

I still get a 404 in the console when previewing and the following in the response:

Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.4.16
X-Kaltura: error-25
X-Kaltura-App: exiting on error 25 - wrong query attributes, This format is unsupported
X-Kaltura-Session: 1953757959
X-Me: kaltura.xxxx.com
X-Powered-By: PHP/5.4.16

#16

Is the correct delivery_profile selected? You can check the query made for that in /opt/kaltura/log/kaltura_prod.log.


#17

Yes, I have tried a few different default delivery profiles as well as created a couple and when I grep the logs it is selecting whichever one is selected in my delivery profile.

The closest I have gotten to getting it working today is with my own apple_http profile pointing to cf, however with that one I get the following error rather than error 25:

streamerType : hls | message : {"type":"networkError","details":"manifestParsingError","fatal":true,"networkDetails":{}} | code : 1000 |

However in the network console with this profile I am seeing things like:
Request URL: http://dx45n1oi2hg6i.cloudfront.net/kaltura/content/entry/data/0/0/0_cp7rxemu_0_083gjl8o_2.mp4
Request Method: GET
Status Code: 200 OK
Remote Address: 143.204.194.197:80
Referrer Policy: no-referrer-when-downgrade

Which is positive.


#18

Also if I set up a delivery profile using vod_hls it seems to work to a point but then breaks as it gets a 404 from cloudfront when trying to read a manifest file

  1. Request URL:

http://dx45n1oi2xxxx.cloudfront.net/kaltura/content/entry/data/0/0/0_5eyv7vaa_0_g5y62zmk_2.mp4/manifest.f4m

  1. Request Method:

GET

  1. Status Code:

404 Not Found

  1. Remote Address:

143.204.194.55:80

  1. Referrer Policy:

no-referrer-when-downgrade


#19

Hiya

Error 25 is resolved by adding disableHLSOnJs = true to the html5 player ui vars when using the following delivery profile:

Delivery Profile Type: HTTP
Streamer Type: HTTP
Supported Media Protocols: http,https
Delivery Profile URL: http://your_cf_space.cloudfront.net

I have not gotten an HLS based profile working yet as the m3u8 returned contains the following:

#EXTM3U
#EXT-X-STREAM-INF:PROGRAM-ID=1,BANDWIDTH=780754,RESOLUTION=960x540
kaltura.xxxxx:88/hls/content/entry/data/0/0/0_0pz2n3m2_0_4mazwisj_2.mp4/index.m3u8
#EXT-X-STREAM-INF:PROGRAM-ID=1,BANDWIDTH=968034,RESOLUTION=1024x576
kaltura.xxxxx:88/hls/content/entry/data/0/0/0_0pz2n3m2_0_mgsz29qk_2.mp4/index.m3u8
#EXT-X-STREAM-INF:PROGRAM-ID=1,BANDWIDTH=1344688,RESOLUTION=1280x720
kaltura.xxxxx:88/hls/content/entry/data/0/0/0_0pz2n3m2_0_bkodnz1b_2.mp4/index.m3u8

And cloudfront rejects these urls as they do not exist.

Thanks for all the help.