Fórum

How to disable Journal Article queries right after server start

Ashish Ashok, modificado 8 Anos atrás.

How to disable Journal Article queries right after server start

New Member Postagens: 11 Data de Entrada: 18/06/13 Postagens Recentes
I have around 590000 Journal Articles in my database. When ever I start my liferay server, I see a continuous log of Hibernate queries (I have the property hibernate.show_sql set to true). I want it to be set to true for some investigation regarding my workflow.

In portal-ext.properties I have also set

hibernate.show_sql=true
index.on.startup=false
database.indexes.update.on.startup=false
journal.article.check.interval=500
lucene.optimize.interval=100
journal.sync.content.search.on.startup=false


I don't understand why the below queries are run by some process ( I'm unable to figure out which process that is) right after server start. Please let we know what property that I need to set in order to disable this process from taking place during startup.



Queries in my log

Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? ) order by  journalart0_.version ASC
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? )AND(journalart0_.status=? ) order by  journalart0_.articleId ASC , journalart0_.version DESC limit ?
Hibernate: select assetentry0_.entryId as entryId378_, assetentry0_.groupId as groupId378_, assetentry0_.companyId as companyId378_, assetentry0_.userId as userId378_, assetentry0_.userName as userName378_, assetentry0_.createDate as createDate378_, assetentry0_.modifiedDate as modified7_378_, assetentry0_.classNameId as classNam8_378_, assetentry0_.classPK as classPK378_, assetentry0_.classUuid as classUuid378_, assetentry0_.classTypeId as classTy11_378_, assetentry0_.visible as visible378_, assetentry0_.startDate as startDate378_, assetentry0_.endDate as endDate378_, assetentry0_.publishDate as publish15_378_, assetentry0_.expirationDate as expirat16_378_, assetentry0_.mimeType as mimeType378_, assetentry0_.title as title378_, assetentry0_.description as descrip19_378_, assetentry0_.summary as summary378_, assetentry0_.url as url378_, assetentry0_.layoutUuid as layoutUuid378_, assetentry0_.height as height378_, assetentry0_.width as width378_, assetentry0_.priority as priority378_, assetentry0_.viewCount as viewCount378_ from AssetEntry assetentry0_ where (assetentry0_.classNameId=? )AND(assetentry0_.classPK=? )
Hibernate: SELECT AssetTag.tagId as tagId380_0_, AssetTag.groupId as groupId380_0_, AssetTag.companyId as companyId380_0_, AssetTag.userId as userId380_0_, AssetTag.userName as userName380_0_, AssetTag.createDate as createDate380_0_, AssetTag.modifiedDate as modified7_380_0_, AssetTag.name as name380_0_, AssetTag.assetCount as assetCount380_0_ FROM AssetTag INNER JOIN AssetEntries_AssetTags ON (AssetEntries_AssetTags.tagId = AssetTag.tagId) WHERE (AssetEntries_AssetTags.entryId = ?) ORDER BY AssetTag.name ASC
Hibernate: update AssetEntry set groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, classUuid=?, classTypeId=?, visible=?, startDate=?, endDate=?, publishDate=?, expirationDate=?, mimeType=?, title=?, description=?, summary=?, url=?, layoutUuid=?, height=?, width=?, priority=?, viewCount=? where entryId=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? ) order by  journalart0_.version ASC
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? )AND(journalart0_.status=? ) order by  journalart0_.articleId ASC , journalart0_.version DESC limit ?
Hibernate: select assetentry0_.entryId as entryId378_, assetentry0_.groupId as groupId378_, assetentry0_.companyId as companyId378_, assetentry0_.userId as userId378_, assetentry0_.userName as userName378_, assetentry0_.createDate as createDate378_, assetentry0_.modifiedDate as modified7_378_, assetentry0_.classNameId as classNam8_378_, assetentry0_.classPK as classPK378_, assetentry0_.classUuid as classUuid378_, assetentry0_.classTypeId as classTy11_378_, assetentry0_.visible as visible378_, assetentry0_.startDate as startDate378_, assetentry0_.endDate as endDate378_, assetentry0_.publishDate as publish15_378_, assetentry0_.expirationDate as expirat16_378_, assetentry0_.mimeType as mimeType378_, assetentry0_.title as title378_, assetentry0_.description as descrip19_378_, assetentry0_.summary as summary378_, assetentry0_.url as url378_, assetentry0_.layoutUuid as layoutUuid378_, assetentry0_.height as height378_, assetentry0_.width as width378_, assetentry0_.priority as priority378_, assetentry0_.viewCount as viewCount378_ from AssetEntry assetentry0_ where (assetentry0_.classNameId=? )AND(assetentry0_.classPK=? )
Hibernate: SELECT AssetTag.tagId as tagId380_0_, AssetTag.groupId as groupId380_0_, AssetTag.companyId as companyId380_0_, AssetTag.userId as userId380_0_, AssetTag.userName as userName380_0_, AssetTag.createDate as createDate380_0_, AssetTag.modifiedDate as modified7_380_0_, AssetTag.name as name380_0_, AssetTag.assetCount as assetCount380_0_ FROM AssetTag INNER JOIN AssetEntries_AssetTags ON (AssetEntries_AssetTags.tagId = AssetTag.tagId) WHERE (AssetEntries_AssetTags.entryId = ?) ORDER BY AssetTag.name ASC
Hibernate: update AssetEntry set groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, classUuid=?, classTypeId=?, visible=?, startDate=?, endDate=?, publishDate=?, expirationDate=?, mimeType=?, title=?, description=?, summary=?, url=?, layoutUuid=?, height=?, width=?, priority=?, viewCount=? where entryId=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? ) order by  journalart0_.version ASC
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? )AND(journalart0_.status=? ) order by  journalart0_.articleId ASC , journalart0_.version DESC limit ?
Hibernate: select assetentry0_.entryId as entryId378_, assetentry0_.groupId as groupId378_, assetentry0_.companyId as companyId378_, assetentry0_.userId as userId378_, assetentry0_.userName as userName378_, assetentry0_.createDate as createDate378_, assetentry0_.modifiedDate as modified7_378_, assetentry0_.classNameId as classNam8_378_, assetentry0_.classPK as classPK378_, assetentry0_.classUuid as classUuid378_, assetentry0_.classTypeId as classTy11_378_, assetentry0_.visible as visible378_, assetentry0_.startDate as startDate378_, assetentry0_.endDate as endDate378_, assetentry0_.publishDate as publish15_378_, assetentry0_.expirationDate as expirat16_378_, assetentry0_.mimeType as mimeType378_, assetentry0_.title as title378_, assetentry0_.description as descrip19_378_, assetentry0_.summary as summary378_, assetentry0_.url as url378_, assetentry0_.layoutUuid as layoutUuid378_, assetentry0_.height as height378_, assetentry0_.width as width378_, assetentry0_.priority as priority378_, assetentry0_.viewCount as viewCount378_ from AssetEntry assetentry0_ where (assetentry0_.classNameId=? )AND(assetentry0_.classPK=? )
Hibernate: SELECT AssetTag.tagId as tagId380_0_, AssetTag.groupId as groupId380_0_, AssetTag.companyId as companyId380_0_, AssetTag.userId as userId380_0_, AssetTag.userName as userName380_0_, AssetTag.createDate as createDate380_0_, AssetTag.modifiedDate as modified7_380_0_, AssetTag.name as name380_0_, AssetTag.assetCount as assetCount380_0_ FROM AssetTag INNER JOIN AssetEntries_AssetTags ON (AssetEntries_AssetTags.tagId = AssetTag.tagId) WHERE (AssetEntries_AssetTags.entryId = ?) ORDER BY AssetTag.name ASC
Hibernate: update AssetEntry set groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, classUuid=?, classTypeId=?, visible=?, startDate=?, endDate=?, publishDate=?, expirationDate=?, mimeType=?, title=?, description=?, summary=?, url=?, layoutUuid=?, height=?, width=?, priority=?, viewCount=? where entryId=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? ) order by  journalart0_.version ASC
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: update JournalArticle set uuid_=?, resourcePrimKey=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, articleId=?, version=?, title=?, urlTitle=?, description=?, content=?, type_=?, structureId=?, templateId=?, layoutUuid=?, displayDate=?, expirationDate=?, reviewDate=?, indexable=?, smallImage=?, smallImageId=?, smallImageURL=?, status=?, statusByUserId=?, statusByUserName=?, statusDate=? where id_=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? )AND(journalart0_.status=? ) order by  journalart0_.articleId ASC , journalart0_.version DESC limit ?
Hibernate: select assetentry0_.entryId as entryId378_, assetentry0_.groupId as groupId378_, assetentry0_.companyId as companyId378_, assetentry0_.userId as userId378_, assetentry0_.userName as userName378_, assetentry0_.createDate as createDate378_, assetentry0_.modifiedDate as modified7_378_, assetentry0_.classNameId as classNam8_378_, assetentry0_.classPK as classPK378_, assetentry0_.classUuid as classUuid378_, assetentry0_.classTypeId as classTy11_378_, assetentry0_.visible as visible378_, assetentry0_.startDate as startDate378_, assetentry0_.endDate as endDate378_, assetentry0_.publishDate as publish15_378_, assetentry0_.expirationDate as expirat16_378_, assetentry0_.mimeType as mimeType378_, assetentry0_.title as title378_, assetentry0_.description as descrip19_378_, assetentry0_.summary as summary378_, assetentry0_.url as url378_, assetentry0_.layoutUuid as layoutUuid378_, assetentry0_.height as height378_, assetentry0_.width as width378_, assetentry0_.priority as priority378_, assetentry0_.viewCount as viewCount378_ from AssetEntry assetentry0_ where (assetentry0_.classNameId=? )AND(assetentry0_.classPK=? )
Hibernate: SELECT AssetTag.tagId as tagId380_0_, AssetTag.groupId as groupId380_0_, AssetTag.companyId as companyId380_0_, AssetTag.userId as userId380_0_, AssetTag.userName as userName380_0_, AssetTag.createDate as createDate380_0_, AssetTag.modifiedDate as modified7_380_0_, AssetTag.name as name380_0_, AssetTag.assetCount as assetCount380_0_ FROM AssetTag INNER JOIN AssetEntries_AssetTags ON (AssetEntries_AssetTags.tagId = AssetTag.tagId) WHERE (AssetEntries_AssetTags.entryId = ?) ORDER BY AssetTag.name ASC
Hibernate: update AssetEntry set groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, classNameId=?, classPK=?, classUuid=?, classTypeId=?, visible=?, startDate=?, endDate=?, publishDate=?, expirationDate=?, mimeType=?, title=?, description=?, summary=?, url=?, layoutUuid=?, height=?, width=?, priority=?, viewCount=? where entryId=?
Hibernate: select journalart0_.id_ as id1_410_, journalart0_.uuid_ as uuid2_410_, journalart0_.resourcePrimKey as resource3_410_, journalart0_.groupId as groupId410_, journalart0_.companyId as companyId410_, journalart0_.userId as userId410_, journalart0_.userName as userName410_, journalart0_.createDate as createDate410_, journalart0_.modifiedDate as modified9_410_, journalart0_.classNameId as classNa10_410_, journalart0_.classPK as classPK410_, journalart0_.articleId as articleId410_, journalart0_.version as version410_, journalart0_.title as title410_, journalart0_.urlTitle as urlTitle410_, journalart0_.description as descrip16_410_, journalart0_.content as content410_, journalart0_.type_ as type18_410_, journalart0_.structureId as structu19_410_, journalart0_.templateId as templateId410_, journalart0_.layoutUuid as layoutUuid410_, journalart0_.displayDate as display22_410_, journalart0_.expirationDate as expirat23_410_, journalart0_.reviewDate as reviewDate410_, journalart0_.indexable as indexable410_, journalart0_.smallImage as smallImage410_, journalart0_.smallImageId as smallIm27_410_, journalart0_.smallImageURL as smallIm28_410_, journalart0_.status as status410_, journalart0_.statusByUserId as statusB30_410_, journalart0_.statusByUserName as statusB31_410_, journalart0_.statusDate as statusDate410_ from JournalArticle journalart0_ where (journalart0_.groupId=? )AND(journalart0_.articleId=? ) order by  journalart0_.version ASC
thumbnail
Amos Fong, modificado 8 Anos atrás.

RE: How to disable Journal Article queries right after server start

Liferay Legend Postagens: 2047 Data de Entrada: 07/10/08 Postagens Recentes
During server startup, all the scheduled jobs are initiated and usually also do their first run. This is the scheduled job that journal.article.check.interval refers to.

You probably don't want to disable this job completely. The only way I can think of is to customize liferay-portlet.xml using ext plugin and change the trigger to a cron type so you can specify what time you want it to run.