Error 202: Internal Database Error


#1

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.


#2

Waiting for your reply.

Thanks


#3

Hi @ankit-devops-oodles

Your issue starts here:

Go to the log and locate the full query that was executed, then try to run it manually from your MySQL client and see why it fails.
Paste the full query and the error here if you require additional assistance.


#4

Thanks for replying Jess.

Below is the output of queried entered in Mysql shell.

mysql> INSERT INTO scheduler_status (ID,CREATED_AT,UPDATED_AT,SCHEDULER_ID,SCHEDULER_CONFIGURED_ID,TYPE,VALUE) VALUES (NULL,‘2017-07-27 11:18:54’,‘2017-07-27 11:18:54’,‘1’,‘3598’,‘7’,‘1’);
ERROR 1364 (HY000): Field ‘worker_configured_id’ doesn’t have a default value

mysql> INSERT INTO flavor_asset (ID,INT_ID,PARTNER_ID,TAGS,CREATED_AT,UPDATED_AT,ENTRY_ID,FLAVOR_PARAMS_ID,STATUS,VERSION,WIDTH,HEIGHT,BITRATE,FRAME_RATE,IS_ORIGINAL,CONTAINER_FORMAT,VIDEO_CODEC_ID,TYPE) VALUES (‘0_6iy191fk’,NULL,‘101’,‘source’,‘2017-07-27 11:20:19’,‘2017-07-27 11:20:19’,‘0_1ykw0yee’,‘0’,‘0’,‘2’,‘0’,‘0’,‘0’,‘0’,‘1’,’’,’’,‘1’);
ERROR 1364 (HY000): Field ‘description’ doesn’t have a default value

Waiting for your reply.


#5

Hi @ankit-devops-oodles,

The most probable cause is you’ve upgraded your MySQL DB to 5.6 or 5.7 and strict mode is enabled.
Is that the case? which MySQL version are you running against?


#6

Hi Jess

Thanks for giving me a direction. That was to strict mode in mysql 5.6.

I have replaced

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
to
sql_mode=""

& restarted mysql service.

It’s working fine now.

Thanks again.