I have taken a look in the database and I saw this:
- 3:05 Alfresco start
- Starting sysAdmin, Authentication subsystem
- 3:19 no more log in catalina.out till 5:29!
- 3:28 Here it starts doing the query below till 7:47
- 5:29 restart log: Startup of Search, thirdparty, OOoDirect, Transformers subsystems
- 5:40 no more log in catalina.out again till 7:47!
- 7:47 restart log: Starting fileServers, imap, email, Subscriptions subsystems
- 7:48 Alfresco startup completed
The query is this:
select
node.id as node_id,
node.version as node_version,
prop.qname_id as qname_id,
prop.locale_id as locale_id,
prop.list_index as list_index,
prop.actual_type_n as actual_type_n,
prop.persisted_type_n as persisted_type_n,
prop.boolean_value as boolean_value,
prop.long_value as long_value,
prop.float_value as float_value,
prop.double_value as double_value,
prop.string_value as string_value,
prop.serializable_value as serializable_value
from
alf_node node
join alf_node_properties prop on (prop.node_id = node.id)
WHERE node_id in
( $1, ..., $256 )
Why is it doing so many queries like that? It is possible that it is reindexing all the documents?
What can I do to understand what is it doing?
