Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The Playlist service update method is running an insert statement #1842

Open
ElGabbu opened this issue Nov 4, 2014 · 0 comments
Open

The Playlist service update method is running an insert statement #1842

ElGabbu opened this issue Nov 4, 2014 · 0 comments

Comments

@ElGabbu
Copy link

ElGabbu commented Nov 4, 2014

It would seem that the Playlist service update method is running an insert statement of the same entry, after having successfully updated the playlist. Below is the stack trace leading to the database error:

*/ INSERT INTO entry (ID,NAME,TYPE,MEDIA_TYPE,DATA,TAGS,STATUS,CREATED_AT,UPDATED_AT,DISPLAY_IN_SEARCH,CUSTOM_DATA,DESCRIPTION,MODERATION_STATUS,MODERATION_COUNT,MODIFIED_AT,ACCESS_CONTROL_ID,AVAILABLE_FROM) VALUES ('0_22urvzjr','Playlist Update Test','5','10','100000.xml','','4','2014-10-30 13:52:52','2014-11-04 15:03:30','1','a:3:{s:16:"partnerSortValue";i:0;s:21:"entitledUserPuserEdit";s:6:"a:0:{}";s:24:"entitledUserPuserPublish";s:6:"a:0:{}";}','The latest releases','6','0','2014-11-04 15:08:43','2000083','2014-10-30 13:52:52')
2014-11-04 15:08:43 [0.000773] [192.168.8.170] [1585533160] [API] [BasePeer::doInsert] ERR: exception 'Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0_22urvzjr' for key 'PRIMARY'' in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err('SQLSTATE[23000]...')
#1 /opt/kaltura/app/vendor/propel/util/BasePeer.php(298): Propel::log('SQLSTATE[23000]...', 3)
#2 /opt/kaltura/app/alpha/lib/model/om/BaseentryPeer.php(2354): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#3 /opt/kaltura/app/alpha/lib/model/om/Baseentry.php(3237): BaseentryPeer::doInsert(Object(entry), Object(KalturaPDO))
#4 /opt/kaltura/app/alpha/lib/model/om/Baseentry.php(3122): Baseentry->doSave(Object(KalturaPDO))
#5 /opt/kaltura/app/alpha/lib/model/entry.php(281): Baseentry->save(NULL)
#6 /opt/kaltura/app/alpha/lib/model/entry.php(985): entry->save()
#7 [internal function]: entry->setDataContent('<?xml version="...')
#8 /opt/kaltura/app/api_v3/lib/types/KalturaObject.php(382): call_user_func_array(Array, Array)
#9 /opt/kaltura/app/api_v3/lib/types/entry/KalturaBaseEntry.php(398): KalturaObject->toObject(Object(entry), Array)
#10 /opt/kaltura/app/api_v3/lib/types/entry/KalturaPlaylist.php(113): KalturaBaseEntry->toObject(Object(entry))
#11 /opt/kaltura/app/api_v3/services/PlaylistService.php(153): KalturaPlaylist->toObject(NULL)
#12 [internal function]: PlaylistService->updateAction('0_22urvzjr', Object(KalturaPlaylist), false)
#13 /opt/kaltura/app/api_v3/lib/KalturaActionReflector.php(233): call_user_func_array(Array, Array)
#14 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(117): KalturaActionReflector->invoke(Array)
#15 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(111): KalturaDispatcher->dispatch('playlist', 'update', Array)
#16 /opt/kaltura/app/api_v3/web/index.php(20): KalturaFrontController->run()
#17 {main}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant