[GH-ISSUE #62] Duplicate entry error while scanning media path #44

Closed
opened 2026-02-26 02:31:54 +03:00 by kerem · 2 comments
Owner

Originally created by @reeslo on GitHub (Dec 15, 2015).
Original GitHub issue: https://github.com/koel/koel/issues/62

Full debug log

[2015-12-15 17:56:52] local.ERROR: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'D12 & Eminem' for key 'artists_name_unique'' in /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:390
Stack trace:
#0 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(390): PDOStatement->execute(Array)
#1 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(644): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'insert into `ar...', Array)
#2 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(611): Illuminate\Database\Connection->runQueryCallback('insert into `ar...', Array, Object(Closure))
#3 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(391): Illuminate\Database\Connection->run('insert into `ar...', Array, Object(Closure))
#4 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(347): Illuminate\Database\Connection->statement('insert into `ar...', Array)
#5 /koel/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `ar...', Array)
#6 /koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1799): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ar...', Array, 'id')
#7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 /koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(943): call_user_func_array(Array, Array)
#9 /koel/bootstrap/cache/compiled.php(10476): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#10 /koel/bootstrap/cache/compiled.php(10476): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id')
#11 /koel/bootstrap/cache/compiled.php(10465): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#12 /koel/bootstrap/cache/compiled.php(10422): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
#13 /koel/bootstrap/cache/compiled.php(10055): Illuminate\Database\Eloquent\Model->save()
#14 /koel/bootstrap/cache/compiled.php(10070): Illuminate\Database\Eloquent\Model::create(Array)
#15 /koel/app/Models/Artist.php(41): Illuminate\Database\Eloquent\Model::firstOrCreate(Array, Array)
#16 /koel/app/Services/Media.php(103): App\Models\Artist::get('D12 & Emine...')
#17 /koel/app/Services/Media.php(52): App\Services\Media->syncFile(Object(Symfony\Component\Finder\SplFileInfo))
#18 /koel/bootstrap/cache/compiled.php(6022): App\Services\Media->sync()
#19 /koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array)
#20 /koel/app/Http/Controllers/API/SettingController.php(25): App\Facades\Media::sync()
#21 [internal function]: App\Http\Controllers\API\SettingController->save(Object(App\Http\Requests\API\SettingRequest))
#22 /koel/bootstrap/cache/compiled.php(8866): call_user_func_array(Array, Array)
#23 /koel/bootstrap/cache/compiled.php(8935): Illuminate\Routing\Controller->callAction('save', Array)
#24 /koel/bootstrap/cache/compiled.php(8915): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\API\SettingController), Object(Illuminate\Routing\Route), 'save')
#25 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#26 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#27 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#29 /koel/bootstrap/cache/compiled.php(8916): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#30 /koel/bootstrap/cache/compiled.php(8901): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\API\SettingController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'save')
#31 /koel/bootstrap/cache/compiled.php(7855): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'save')
#32 /koel/bootstrap/cache/compiled.php(7826): Illuminate\Routing\Route->runWithCustomDispatcher(Object(Illuminate\Http\Request))
#33 /koel/bootstrap/cache/compiled.php(7479): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#34 [internal function]: Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#35 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#36 /koel/app/Http/Middleware/Authenticate.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#37 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#40 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#41 /koel/bootstrap/cache/compiled.php(7480): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#42 /koel/bootstrap/cache/compiled.php(7468): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#43 /koel/bootstrap/cache/compiled.php(7453): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#44 /koel/bootstrap/cache/compiled.php(2302): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#45 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#46 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#47 /koel/bootstrap/cache/compiled.php(2926): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#50 /koel/bootstrap/cache/compiled.php(12949): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#51 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#53 /koel/bootstrap/cache/compiled.php(11536): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#54 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#56 /koel/bootstrap/cache/compiled.php(12686): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#59 /koel/bootstrap/cache/compiled.php(12623): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#60 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#62 /koel/bootstrap/cache/compiled.php(2983): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 [internal function]: Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array)
#65 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#66 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#67 /koel/bootstrap/cache/compiled.php(2249): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#68 /koel/bootstrap/cache/compiled.php(2232): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#69 /koel/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#70 /koel/server.php(19): require_once('/ko...')
#71 {main}
Originally created by @reeslo on GitHub (Dec 15, 2015). Original GitHub issue: https://github.com/koel/koel/issues/62 Full debug log ``` [2015-12-15 17:56:52] local.ERROR: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'D12 & Eminem' for key 'artists_name_unique'' in /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:390 Stack trace: #0 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(390): PDOStatement->execute(Array) #1 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(644): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'insert into `ar...', Array) #2 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(611): Illuminate\Database\Connection->runQueryCallback('insert into `ar...', Array, Object(Closure)) #3 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(391): Illuminate\Database\Connection->run('insert into `ar...', Array, Object(Closure)) #4 /koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(347): Illuminate\Database\Connection->statement('insert into `ar...', Array) #5 /koel/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `ar...', Array) #6 /koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1799): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ar...', Array, 'id') #7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #8 /koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(943): call_user_func_array(Array, Array) #9 /koel/bootstrap/cache/compiled.php(10476): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #10 /koel/bootstrap/cache/compiled.php(10476): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id') #11 /koel/bootstrap/cache/compiled.php(10465): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #12 /koel/bootstrap/cache/compiled.php(10422): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) #13 /koel/bootstrap/cache/compiled.php(10055): Illuminate\Database\Eloquent\Model->save() #14 /koel/bootstrap/cache/compiled.php(10070): Illuminate\Database\Eloquent\Model::create(Array) #15 /koel/app/Models/Artist.php(41): Illuminate\Database\Eloquent\Model::firstOrCreate(Array, Array) #16 /koel/app/Services/Media.php(103): App\Models\Artist::get('D12 & Emine...') #17 /koel/app/Services/Media.php(52): App\Services\Media->syncFile(Object(Symfony\Component\Finder\SplFileInfo)) #18 /koel/bootstrap/cache/compiled.php(6022): App\Services\Media->sync() #19 /koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array) #20 /koel/app/Http/Controllers/API/SettingController.php(25): App\Facades\Media::sync() #21 [internal function]: App\Http\Controllers\API\SettingController->save(Object(App\Http\Requests\API\SettingRequest)) #22 /koel/bootstrap/cache/compiled.php(8866): call_user_func_array(Array, Array) #23 /koel/bootstrap/cache/compiled.php(8935): Illuminate\Routing\Controller->callAction('save', Array) #24 /koel/bootstrap/cache/compiled.php(8915): Illuminate\Routing\ControllerDispatcher->call(Object(App\Http\Controllers\API\SettingController), Object(Illuminate\Routing\Route), 'save') #25 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #26 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #27 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #29 /koel/bootstrap/cache/compiled.php(8916): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #30 /koel/bootstrap/cache/compiled.php(8901): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(App\Http\Controllers\API\SettingController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'save') #31 /koel/bootstrap/cache/compiled.php(7855): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'App\Http\Contro...', 'save') #32 /koel/bootstrap/cache/compiled.php(7826): Illuminate\Routing\Route->runWithCustomDispatcher(Object(Illuminate\Http\Request)) #33 /koel/bootstrap/cache/compiled.php(7479): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #34 [internal function]: Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #35 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #36 /koel/app/Http/Middleware/Authenticate.php(45): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #37 [internal function]: App\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #41 /koel/bootstrap/cache/compiled.php(7480): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #42 /koel/bootstrap/cache/compiled.php(7468): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #43 /koel/bootstrap/cache/compiled.php(7453): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #44 /koel/bootstrap/cache/compiled.php(2302): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #45 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #46 /koel/bootstrap/cache/compiled.php(9585): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #47 /koel/bootstrap/cache/compiled.php(2926): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #50 /koel/bootstrap/cache/compiled.php(12949): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #53 /koel/bootstrap/cache/compiled.php(11536): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #54 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #55 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #56 /koel/bootstrap/cache/compiled.php(12686): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #59 /koel/bootstrap/cache/compiled.php(12623): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #60 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #61 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #62 /koel/bootstrap/cache/compiled.php(2983): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #63 [internal function]: Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #64 /koel/bootstrap/cache/compiled.php(9577): call_user_func_array(Array, Array) #65 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #66 /koel/bootstrap/cache/compiled.php(9567): call_user_func(Object(Closure), Object(Illuminate\Http\Request)) #67 /koel/bootstrap/cache/compiled.php(2249): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #68 /koel/bootstrap/cache/compiled.php(2232): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #69 /koel/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #70 /koel/server.php(19): require_once('/ko...') #71 {main} ```
kerem closed this issue 2026-02-26 02:31:54 +03:00
Author
Owner

@phanan commented on GitHub (Dec 16, 2015):

Looks like this is related to #39.

<!-- gh-comment-id:164971000 --> @phanan commented on GitHub (Dec 16, 2015): Looks like this is related to #39.
Author
Owner

@phanan commented on GitHub (Dec 16, 2015):

It indeed is, so I'm gonna go a head and close this issue if you wouldn't mind. Feel free to discuss on the other.

<!-- gh-comment-id:164971635 --> @phanan commented on GitHub (Dec 16, 2015): It indeed is, so I'm gonna go a head and close this issue if you wouldn't mind. Feel free to discuss on the other.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#44
No description provided.