Details
-
Bug
-
Resolution: Fixed
-
High
-
4.5.0, 4.6.0, 4.7.0, 5.0
-
None
-
RHEL + Oracle 11g
Description
When a site is under a load of requests, using eZDFS, over oracle database, ORA-0001 errors, leading to segmentation fault, may occur.
steps to reproduce
- Configure two nodes behind a load balancer
- Using jmeter (or a different tool of your choice) simulate several clients accessing the same page in concurrency.
- While the test is running, order cache clearing from the back end, in order to increase the damage
- Check your error.log. Entries such as the one below will start flooding it
Aug 13 2013 21:34:14 ] [192.168.3.4] Timing Point: Module end 'content' [ Aug 13 2013 21:34:14 ] [192.168.3.4] _storeContents(var/ezdemo_site/cache/designbase_e9cf5ecd5ac461977ad3639c58b5fbc6.php, ..., designbases, php)::_storeContents(var/ezdemo_site/cache/designbase_e9cf5ecd5ac461977ad3639c58b5fbc6.php, ..., designbases, php): Failed to execute SQL for function: INSERT INTO ezdfsfile (name, name_hash, datatype, scope, filesize, mtime, expired) VALUES ('var/ezdemo_site/cache/designbase_e9cf5ecd5ac461977ad3639c58b5fbc6.php', 'd9b6fdcd5805b811eeb9f673e767b411', 'php', 'designbases', '654', 1376422454, '0') 1 : ORA-00001: unique constraint (EZP.SYS_C00169727) violated [ Aug 13 2013 21:34:14 ] [192.168.3.4] : Failed to insert file metadata while storing contents. Possible race condition 1: ORA-00001: unique constraint (EZP.SYS_C00169727) violated
