![]() ![]() Rerun the transaction.Ĭaused by: : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. nested exception is : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. : Hibernate operation: could not delete: SQL Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. url: /confluence/pages/docreatepage.action | userName: tstcreator3 17:01:21,359 ERROR onThrowable Invoking rollback for transaction on action '/pages/docreatepage.action (CreatePageAction.doAdd())' due to throwable: : Hibernate operation: could not delete: SQL Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 17:01:21,357 ERROR execute Could not synchronize database state with session 17:01:21,355 ERROR logExceptions Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. url: /confluence/pages/docreatepage.action | userName: tstcreator3 | action: docreatepage But nevertheless, IIS_IUSRS and AppPool Identity have Full Control of upload directory, moodle data directory and temp directory.17:01:21,355 ERROR logExceptions Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. The fact that it works sometimes lead me to thank that folder permission isn't an issue. PHP error log (developer debug mode enabled) shows:Įrror code: restore_not_executable_awaiting_required Windows Event log show FCGI timeout error. Restore of course works only occationally. Instead I am getting FCGI request timeout error. We are a Windows shop so I didn't use mySQL. After days of trying to figure this out I finally gave up on a local SQL database but instead, got my DBA to fire up a MS SQL server for my development use. I tried but couldn't find good detail description of the functional differences (if there's any) between that too. But using MS SQL Server Studio I am able to connect to SQLEXPRESS. On Windows programs list, I see SQL 2019 installed but not SQL Express 2019. SQLEpxress 2019 except that it is a free version of MS SQL for development purpose so we don't have to pay tons of money to sprint up a development server everytime. But I had changed many settings since the basic install. I had restored course to it before so I knew it worked. I hope there are Windows folks who can weight in. Other than restoring, other operation seems fine including backup. I tested 3 different course mbz with same error. ![]() I granted access (except for Full Control) to the corresponding application pool identity for the moodle site and IIS_IUSRS for the error log folder, temp upload file folder and the moodle data folder that is outside of wwwroot. I completed the transition with the transition tool in Moodle Site Admin. PHP info on Moodle is showing the correct php.ini being loaded.īoth http and https are enabled. Handler mapping on IIS is setup with the argument C:\PHP\v7.4.29\php-cgi.exe|-c c:\php\LocalMoodle\php.ini. I use fastcgi application setting with argument so I can load a different php.ini so I don't fiddle with the default one in the php folder. I get as far as the xml_deadlock_report on SQL Server Management Studio that tell me which processes are fighting for the object. Updated ODBC Driver 17 (version 17.10.3.1) and 18 (version 18.1.2.1) for SQL Server. Rerun the transaction.Įnvironment: Windows 10, IIS 10, PHP 7.4.29 Message: Transaction (Process ID 56) was deadlocked on lock | generic waitable object resources with another process and has been chosen as the deadlock victim. I tested restore of a backup file about 5Mb in size and everytime it failed within 10 seconds with this error. I am setting up a local site on my Windows 10 PC to test everything before I mimic it on a development Windows server that I share with another fellow worker. Any help or direction would be appreciated. I have been trying to figure it out with no luck for 2 days. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |