Deleted USER_PREFERENCES table while performing jmeter tests

[drodralv]

Hello,

We were launching performance tests using jmeter, some genericinterface get connections. They were done today early morning and after receiving some errors, we realized we were not able to get to the admin rights web and the USER_PREFERENCES data was deleted.

The log shows:

Code: Select all

[Fri Jan 29 07:00:01 2021][Error][Kernel::System::Main::FileWrite][534] Can't write '/opt/otrs/var/tmp/CacheFileStorable/User/9/b/9b88d74b3ad28b22c41ac0b08148d3ec': No such file or directory
[Fri Jan 29 07:00:02 2021][Error][Kernel::System::Main::FileWrite][534] Can't write '/opt/otrs/var/tmp/CacheFileStorable/User/6/6/66d63281c4ea307e02184209e1950e9e': No such file or directory
[Fri Jan 29 07:00:25 2021][Error][Kernel::System::User::Preferences::DB::SetPreferences][72] ORA-00060: detectado interbloqueo mientras se esperaba un recurso (DBD ERROR: OCIStmtExecute), SQL: '
            DELETE FROM user_preferences
            WHERE user_id = ?
                AND preferences_key = ?'

We are trying to restore the DB, do you know what could have been the reason? Any scheduled task performed at the same time that our tests were done?

Thank you a lot

[drodralv]

Hello,

I wanted to say what just happened:

We were reviewing further than we should...

The issue was solved rebuilding the caché as the issue was related to the DA not being synchronized again. Probably DB user was blocked and once unblocked, OTRS needed to apply the commands to delete and generate cache. Then, user roles were linked and we were able to use OTRS properly.

I hope i explained myself. Such a shame