Hi
Kaltura was running fine from last one month but today when I was uploading video I got an error “error 202: Internal Database Error” (screenshot attached).
Kaltura v12.13.0
OS: CentOS 6.8
Mysql v5.6.35
Cluster(Mysql on other server)
Below is the result of rpm -qa "kaltura"*
kaltura-libopencore-amr-0.1.2-2.x86_64
kaltura-ffmpeg-3.2-1.x86_64
kaltura-postinst-1.0.33-5.noarch
kaltura-segmenter-1.0-2.x86_64
kaltura-base-12.13.0-10.noarch
kaltura-kdp-v2.7.0-1.noarch
kaltura-flexwrapper-v1.2-1.noarch
kaltura-front-12.13.0-1.noarch
kaltura-mencoder-3.4.6-9.x86_64
kaltura-x264-0.140-2.20140104.x86_64
kaltura-libass-0.9.11-2.x86_64
kaltura-a52dec-0.7.4-11.x86_64
kaltura-ffmpeg-aux-2.1.3-1.x86_64
kaltura-sshpass-1.05-1.x86_64
kaltura-libmcrypt-2.5.7-5.x86_64
kaltura-sphinx-2.2.1-20.x86_64
kaltura-librtmp-2.3-3.x86_64
kaltura-libmediainfo-0.7.61-4.x86_64
kaltura-monit-5.19.0-1.x86_64
kaltura-kupload-v1.2.16-2.noarch
kaltura-krecord-1.0.0-1.noarch
kaltura-html5lib-v2.54-1.noarch
kaltura-kdp3wrapper-v37.0-1.noarch
kaltura-kclip-v1.1.2.1-2.noarch
kaltura-kcw-1.0.0-6.noarch
kaltura-kvpm-v1.0.6-1.noarch
kaltura-widgets-1.0.0-8.noarch
kaltura-batch-12.13.0-2.noarch
kaltura-dwh-11.3.0-1.noarch
kaltura-nginx-1.10.2-7.x86_64
kaltura-release-11.8.0-1.noarch
kaltura-lame-3.99.5-3.x86_64
kaltura-html5-studio-v2.0.9-1.noarch
kaltura-libmcrypt-devel-2.5.7-5.x86_64
kaltura-libfaac-1.26-1.x86_64
kaltura-mediainfo-0.7.61-4.x86_64
kaltura-kmc-v5.41.2-5.noarch
kaltura-clipapp-1.3-2.noarch
kaltura-kdpwrapper-v11.0-1.noarch
kaltura-kdp3-v3.9.9-2.noarch
kaltura-pentaho-4.2.1-2.x86_64
Result of “tail -f /opt/kaltura/log/.log /opt/kaltura/log/batch/.log | grep -A 1 -B 1 --color “ERR:|PHP|trace|CRIT|[error]””
–
2017-07-26 06:47:00 [0.003382] [180.151.85.198] [74733117] [44] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.0030970573425293 seconds
2017-07-26 06:47:00 [0.000885] [180.151.85.198] [372687161] [51] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 6 - requested flavor was not found’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:47:00 [0.018878] [180.151.85.198] [673178650] [39] [PS2] [DbManager::connectFallbackLogic] DEBUG: connected to propel3
2017-07-26 06:47:00 [0.000319] [180.151.85.198] [74733117] [51] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 6 - requested flavor was not found’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:47:00 [0.000491] [180.151.85.198] [1010160588] [35] [PS2] [DbManager::connectFallbackLogic] DEBUG: connected to propel2
2017-07-26 06:47:00 [0.000776] [180.151.85.198] [673178650] [51] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 6 - requested flavor was not found’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:47:00 [0.000980] [180.151.85.198] [1010160588] [50] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00075483322143555 seconds
2017-07-26 06:47:00 [0.000406] [180.151.85.198] [1010160588] [51] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 6 - requested flavor was not found’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:47:01 [0.001130] [180.151.85.198] [2076282074] [12] [API] [KalturaStatement->execute] DEBUG: Sql took - 0.00085997581481934 seconds
2017-07-26 06:47:01 [0.001285] [180.151.85.198] [1520506382] [42] [API] [BasePeer::doInsert] ERR: exception ‘Exception’ with message ‘SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err(‘SQLSTATE[HY000]…’)
2017-07-26 06:47:01 [0.000300] [180.151.85.198] [1520506382] [45] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value]’ in /opt/kaltura/app/vendor/propel/util/BasePeer.php:299
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/om/BaseassetPeer.php(876): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
Output of kaltlog
–
2017-07-26 06:51:41 [0.000799] [180.151.85.198] [1423900292] [38] [PS2] [kFileSyncUtils::getReadyFileSyncForKey] NOTICE: FileSync was not found
2017-07-26 06:51:41 [0.000579] [180.151.85.198] [1423900292] [39] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 11 - processing capture thumbnail’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:51:41 [0.001883] [180.151.85.198] [1423900292] [40] [PS2] [KExternalErrors::terminateDispatch] DEBUG: Dispatch took - 0.10493493080139 seconds, memory: 6815744
2017-07-26 06:51:41 [0.001293] [180.151.85.198] [2085203962] [39] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 11 - processing capture thumbnail’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:51:41 [0.000496] [180.151.85.198] [107239360] [34] [PS2] [kFileSyncUtils::getReadyFileSyncForKey] DEBUG: key [object_type:[1], object_id:[0_t08yv5wv], version:[0], object_sub_type[3], partner_id[101]], fetch_from_remote_if_no_local [], strict []
2017-07-26 06:51:41 [0.000815] [180.151.85.198] [88854257] [39] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 11 - processing capture thumbnail’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
2017-07-26 06:51:41 [0.000267] [180.151.85.198] [107239360] [38] [PS2] [kFileSyncUtils::getReadyFileSyncForKey] NOTICE: FileSync was not found
2017-07-26 06:51:41 [0.000555] [180.151.85.198] [107239360] [39] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 11 - processing capture thumbnail’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
==> /opt/kaltura/log/kaltura_api_v3.log <==
2017-07-26 06:51:41 [0.000874] [180.151.85.198] [831856367] [42] [API] [BasePeer::doInsert] ERR: exception ‘Exception’ with message ‘SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err(‘SQLSTATE[HY000]…’)
2017-07-26 06:51:41 [0.000270] [180.151.85.198] [831856367] [45] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field ‘description’ doesn’t have a default value]’ in /opt/kaltura/app/vendor/propel/util/BasePeer.php:299
Stack trace:
#0 /opt/kaltura/app/alpha/lib/model/om/BaseassetPeer.php(876): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
2017-07-26 06:51:41 [0.001386] [180.151.85.198] [1494518737] [50] [PS2] [KalturaStatement->execute] DEBUG: Sql took - 0.00086092948913574 seconds
2017-07-26 06:51:41 [0.000510] [180.151.85.198] [1494518737] [51] [PS2] [KExternalErrors::dieError] ERR: exception ‘Exception’ with message ‘exiting on error 6 - requested flavor was not found’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/KExternalErrors.class.php(128): KalturaLog::err(‘exiting on erro…’)
Waiting for your response.