User name does not exist: admin

[silenr0c]

Hi guys,

I know it sounds funny, but my admin user is missing out of the blue.
one day i can't login using username:admin , password:admin
luckily i had already create another user with admin role before that.

So I check in Administration Console -> Manage System Users
1. the user admin is still there
2. I try to change password for admin it says:
    Please correct the errors below then click Finish.
    A system error happened during the operation: 02150039 User name does not exist: admin
3. I try to create another user with username:admin, password:admin it says:
    Please correct the errors below then click Finish.
    Failed to create Person due to error: 02150081 Person 'admin' already exists.
4. I check in the MySql database using this query
select node_id,qname_id,string_value from alf_node_properties
WHERE qname_id in (
SELECT id from alf_qname where local_name='password'
)
AND node_id in (
    SELECT node_id
    FROM alf_node_properties
    WHERE qname_id in (SELECT id from alf_qname where local_name='username')
    AND string_value = 'admin'
);
there is no record return

I am using Version 3.3.0 (2765) community edition

Thanks

[silenr0c]

I check the log, don't know whether it is related or not
00:00:00,027 WARN  [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] User registry synchronization already running in another thread. Synchronize aborted
03:00:00,840 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.indexBackupJobDetail threw an unhandled Exception:
org.alfresco.error.AlfrescoRuntimeException: 01230047 Failed to copy Lucene index root:
   Index root: /index/lucene-indexes
   Target: /index/backup-lucene-indexes
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent$BackUpWithAllWriteLocksWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1225)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$CoreLockWork$1.doWork(AbstractLuceneIndexerAndSearcherFactory.java:2001)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$CoreLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1995)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2456)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2376)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithWriteLock(IndexInfo.java:2362)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.doWithWriteLock(AbstractLuceneBase.java:338)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$NestingLockWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1972)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.doWithAllWriteLocks(AbstractLuceneIndexerAndSearcherFactory.java:1935)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.backupImpl(AbstractLuceneIndexerAndSearcherFactory.java:1190)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.access$000(AbstractLuceneIndexerAndSearcherFactory.java:1036)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent$1.execute(AbstractLuceneIndexerAndSearcherFactory.java:1152)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:321)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:228)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.backup(AbstractLuceneIndexerAndSearcherFactory.java:1156)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupJob.execute(AbstractLuceneIndexerAndSearcherFactory.java:1559)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.io.IOException: Destination '/index/.indexbackup_temp' directory cannot be created
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent$BackUpWithAllWriteLocksWork.copyDirectory(AbstractLuceneIndexerAndSearcherFactory.java:1289)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent$BackUpWithAllWriteLocksWork.backupDirectory(AbstractLuceneIndexerAndSearcherFactory.java:1250)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent$BackUpWithAllWriteLocksWork.doWork(AbstractLuceneIndexerAndSearcherFactory.java:1220)
   … 46 more

Thanks

[stevegreenbaum]

I don't know how to fix this, but I have seen something similar before in an earlier version.  It occurred for me after I modified the admin user account data using the Explorer UI.  It was a throw away dev environment so I just reinstalled.

[silenr0c]

Hi Steve,

Thanks for your reply, there are a lot of data involved so reinstalled is my last option.
I'm thinking of directly insert/update the admin data in mysql table, I'm not sure whether it's possible or not, has anyone try this before?

Thanks

[stevegreenbaum]

In that you have another user account with admin privileges, at least you can continue to operate the system as-is.  But I understand that it would be best to resolve this issue.  To gather a little more info, use the node browser and drill into the userstore and spacestore and find the admin user.  If you have a test environment, look in that one first so you know what you are looking for in the production site.  Maybe you'll see something that leads you to an answer.