-
Bug
-
Resolution: Fixed
-
Medium
-
1.0 Beta1
-
None
After completing the setup steps, something is not fully configured. This causes problems that persist until the first full restart:
- users not being fully saved (vanishing after the restart)
- exceptions editing user profiles
CONF-360 - occasional errors importing data
The workaround is to fully restart Confluence after completing the setup steps.
- incorporates
-
-
- Closed
-
[CONFSERVER-493] Confluence not fully set up until first restart
david valentine
added a comment - confluence database script with duplicate entries david valentine
added a comment - - grep confluence.user.last.login database/confluencedb.script
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',2,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:17:22.223')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:18:35.795')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',1,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:23:07.52')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 11:05:54.424')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',2,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:27:14.35')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:28:27.75')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:29:45.203')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',4,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:30:39.818')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:31:17.242')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=4 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',4,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:31:59.445')
david valentine
added a comment -
grep confluence.user.last.login database/confluencedb.script
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',2,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:17:22.223')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:18:35.795')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',1,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 10:23:07.52')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 11:05:54.424')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',2,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:27:14.35')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:28:27.75')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:29:45.203')
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',4,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:30:39.818')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=3 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:31:17.242')
DELETE FROM OS_PROPERTYENTRY WHERE ENTITY_NAME='OSUser_user' AND ENTITY_ID=4 AND ENTITY_KEY='confluence.user.last.login.date'
INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',4,'confluence.user.last.login.date',7,false,0.0E0,NULL,0,0,'2004-01-16 12:31:59.445')
david valentine
added a comment - forums not up. So post here.
Could not log in as adminstrator. read this, rebooted.
now confluence will not load.
Hibernate whines about a unqiue constriant violation.
looking at conflunce/database/confluencedb.script, it's right.
only problem is that I can't delete the damn line in vi or ed (line is too long).
Caused by: org.springframework.orm.hibernate.HibernateJdbcException: JDBC exception on Hibernate data access: Cannot open connection; nested exception is:
java.sql.SQLException: Violation of unique index: Violation of unique index: SYS_PK_OS_PROPERTYENTRY in statement [INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.previous.login.date',7,false,0.0E0,NULL,0,0,NULL)]
david valentine
added a comment - forums not up. So post here.
Could not log in as adminstrator. read this, rebooted.
now confluence will not load.
Hibernate whines about a unqiue constriant violation.
looking at conflunce/database/confluencedb.script, it's right.
only problem is that I can't delete the damn line in vi or ed (line is too long).
Caused by: org.springframework.orm.hibernate.HibernateJdbcException: JDBC exception on Hibernate data access: Cannot open connection; nested exception is:
java.sql.SQLException: Violation of unique index: Violation of unique index: SYS_PK_OS_PROPERTYENTRY in statement [INSERT INTO OS_PROPERTYENTRY VALUES('OSUser_user',3,'confluence.user.previous.login.date',7,false,0.0E0,NULL,0,0,NULL)]
No need to restart Confluence after setup now