laravel-oci8
laravel-oci8 copied to clipboard
oci_rollback(): ORA-01012: not logged on
Summary of problem or feature request
I am using laravel-oci8 to connect my laravel app to a 12c oracle db. my app is working fine but in my log files I have an error "production.ERROR: oci_rollback(): ORA-01012: not logged on"
Code snippet of problem
[2021-10-06 07:22:03] production.ERROR: oci_rollback(): ORA-01012: not logged on
Process ID: 20756
Session ID: 1592 Serial number: 62307 {"exception":"[object] (ErrorException(code: 0): oci_rollback(): ORA-01012: not logged on
Process ID: 20756
Session ID: 1592 Serial number: 62307 at /myapp/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:198)
[stacktrace]
#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, 'oci_rollback():...', '/home/diwaneser...', 198, Array)
#1 /myapp/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(198): oci_rollback(Resource id #488)
#2 /myapp/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(208): Yajra\\Pdo\\Oci8->rollBack()
#3 /myapp/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(189): Illuminate\\Database\\Connection->performRollBack(0)
#4 /myapp/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(74): Illuminate\\Database\\Connection->rollBack()
#5 /myapp/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(39): Illuminate\\Database\\Connection->handleTransactionException(Object(Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception), 1, 1)
#6 /myapp/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(197): Illuminate\\Database\\Connection->transaction(Object(Closure))
#7 /myapp/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(246): Illuminate\\Queue\\DatabaseQueue->pop('default')
#8 /myapp/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(107): Illuminate\\Queue\\Worker->getNextJob(Object(Illuminate\\Queue\\DatabaseQueue), 'default')
#9 /myapp/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Worker->daemon('database', 'default', Object(Illuminate\\Queue\\WorkerOptions))
#10 /myapp/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(85): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'default')
#11 [internal function]: Illuminate\\Queue\\Console\\WorkCommand->handle()
#12 /myapp/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)
#13 /myapp/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#14 /myapp/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#15 /myapp/vendor/laravel/framework/src/Illuminate/Container/Container.php(564): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#16 /myapp/vendor/laravel/framework/src/Illuminate/Console/Command.php(179): Illuminate\\Container\\Container->call(Array)
#17 /myapp/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#18 /myapp/vendor/laravel/framework/src/Illuminate/Console/Command.php(166): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#19 /myapp/vendor/symfony/console/Application.php(1009): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 /myapp/vendor/symfony/console/Application.php(273): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#21 /myapp/vendor/symfony/console/Application.php(149): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 /myapp/vendor/laravel/framework/src/Illuminate/Console/Application.php(89): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 /myapp/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#24 /myapp/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#25 {main}
System details
- Linux
- PHP 7.4
- Laravel 5.6
- Laravel-OCI8 5.6.5
Config
[
'driver' => 'oracle',
'tns' => env('DB_TNS', ''),
'host' => env('DB_HOST', ''),
'port' => env('DB_PORT', '1521'),
'database' => env('DB_DATABASE', ''),
'username' => env('DB_USERNAME', ''),
'password' => env('DB_PASSWORD', ''),
'charset' => env('DB_CHARSET', 'AL32UTF8'),
'prefix' => env('DB_PREFIX', ''),
'prefix_schema' => env('DB_SCHEMA_PREFIX', ''),
'server_version' => env('DB_SERVER_VERSION', '11g'),
'options' => [
PDO::ATTR_CASE => PDO::CASE_LOWER,
PDO::ATTR_PERSISTENT => true
]
]
DB Resources

I think this has thing to do with pooling or session at the oracle side what should I do to solve this problem? :)
Haven't encountered a similar issue yet. Can you please provide snippets to reproduce the issue?
This issue is stale because it has been open for 30 days with no activity.
This issue was closed because it has been inactive for 7 days since being marked as stale.