Hello,
I upgrade my alfresco (Debian 64, Postgresql, Openldap authentication) server to 4.2.c.
I install the 4.2.c using this installer : alfresco-community-4.2.c-installer-linux-x64.bin
I use a Postgresql server on the same server as Alfresco (localhost). When i start my server for the first time, after few problems with my ldap auhtentication i success to login to my alfresco server and to access to my documents.
Problem is that my SOLR doesn't work with the SSL expiration issue (messages in catalina.out). So, i decide to disable SSL support with Solr for resolve quickly the problem. In fact, SSL support was yet disabled in my previous alfresco installation.
So, i begin to delete SOLR index (alf_data/solr/workspace and archive) et i follow instructions in this post http://deepak-keswani.blogspot.ca/2012/12/configure-solr-and-alfresco-to-use-http.html
When i restart my server, i can see that SOLR re-index well, with some error message on pdfbox (messages already known on my server so don't critical). But after maybe 4-5 mns, i've got some error message on my Postgresql table alf_node and Exception from executeScript - redirecting to status te
mplate error: 03030002.
I try to restart my server but re-indexing doesn't start and error messages still to appear. I continue to have access to my documents but not to SOLR results…
Please, somebody has an idea ?
alfresco-global.properties solr parameters :
index.subsystem.name=solr
solr.secureComms=none
solr.host=localhost
solr.port=8080
#solr.port.ssl=8443
solr.log content :
<code>
0:54:51,446 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
20:54:51,647 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
21:58:07,729 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
21:58:09,081 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
Errors i found in my catalina.out (join to this post) :
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4006
2013-04-03 20:56:35,946 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop reading corrupt stream due to a DataFormatException
2013-04-03 20:56:35,958 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop reading corrupt stream due to a DataFormatException
2013-04-03 20:56:35,958 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop
[…]
2013-04-03 21:00:09,061 ERROR [node.db.DeletedNodeCleanupWorker] [DefaultScheduler_Worker-3] Failed to purge nodes. If the purgable set is too large for the available DB resources
then the nodes can be purged manually as well.
Set log level to WARN for this class to get exception log:
Max commit time: 1362445200365
Error:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
### The error may involve alfresco.node.delete_NodesByTxnCommitTime-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
; SQL []; ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».; nested exception is org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4006
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
[…]
2013-04-03 21:01:55,435 INFO [web.site.EditionInterceptor] [http-apr-8080-exec-4] Successfully retrieved license information from Alfresco.
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
2013-04-03 21:02:08,038 INFO [web.scripts.ImapServerStatus] [http-apr-8080-exec-9] Successfully retrieved IMAP server status from Alfresco: disabled
2013-04-03 21:02:11,800 ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-11] Exception from executeScript - redirecting to status template error: 03030001 Wrapped Exception (with status template): 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm
ost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
org.springframework.extensions.webscripts.WebScriptException: 03030001 Wrapped Exception (with status template): 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fmost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")
at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:426)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.alfresco.scripts.ScriptException: 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TY
<code>
[….]
I upgrade my alfresco (Debian 64, Postgresql, Openldap authentication) server to 4.2.c.
I install the 4.2.c using this installer : alfresco-community-4.2.c-installer-linux-x64.bin
I use a Postgresql server on the same server as Alfresco (localhost). When i start my server for the first time, after few problems with my ldap auhtentication i success to login to my alfresco server and to access to my documents.
Problem is that my SOLR doesn't work with the SSL expiration issue (messages in catalina.out). So, i decide to disable SSL support with Solr for resolve quickly the problem. In fact, SSL support was yet disabled in my previous alfresco installation.
So, i begin to delete SOLR index (alf_data/solr/workspace and archive) et i follow instructions in this post http://deepak-keswani.blogspot.ca/2012/12/configure-solr-and-alfresco-to-use-http.html
When i restart my server, i can see that SOLR re-index well, with some error message on pdfbox (messages already known on my server so don't critical). But after maybe 4-5 mns, i've got some error message on my Postgresql table alf_node and Exception from executeScript - redirecting to status te
mplate error: 03030002.
I try to restart my server but re-indexing doesn't start and error messages still to appear. I continue to have access to my documents but not to SOLR results…
Please, somebody has an idea ?
alfresco-global.properties solr parameters :
index.subsystem.name=solr
solr.secureComms=none
solr.host=localhost
solr.port=8080
#solr.port.ssl=8443
solr.log content :
<code>
0:54:51,446 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
20:54:51,647 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
21:58:07,729 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
21:58:09,081 WARN [org.apache.solr.handler.component.SpellCheckComponent] No queryConverter defined, using default converter
Errors i found in my catalina.out (join to this post) :
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4006
2013-04-03 20:56:35,946 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop reading corrupt stream due to a DataFormatException
2013-04-03 20:56:35,958 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop reading corrupt stream due to a DataFormatException
2013-04-03 20:56:35,958 ERROR [pdfbox.filter.FlateFilter] [http-apr-8080-exec-2] FlateFilter: stop
[…]
2013-04-03 21:00:09,061 ERROR [node.db.DeletedNodeCleanupWorker] [DefaultScheduler_Worker-3] Failed to purge nodes. If the purgable set is too large for the available DB resources
then the nodes can be purged manually as well.
Set log level to WARN for this class to get exception log:
Max commit time: 1362445200365
Error:
### Error updating database. Cause: org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
### The error may involve alfresco.node.delete_NodesByTxnCommitTime-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
; SQL []; ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».; nested exception is org.postgresql.util.PSQLException: ERREUR: UPDATE ou DELETE sur la table « alf_node » viole la contrainte de clé étrangère
« fk_alf_nasp_n » de la table « alf_node_aspects »
Détail : La clé (id)=(52159) est toujours référencée à partir de la table « alf_node_aspects ».
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4006
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
[…]
2013-04-03 21:01:55,435 INFO [web.site.EditionInterceptor] [http-apr-8080-exec-4] Successfully retrieved license information from Alfresco.
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
Found a TextHeaderAtom not followed by a TextBytesAtom or TextCharsAtom: Followed by 4002
2013-04-03 21:02:08,038 INFO [web.scripts.ImapServerStatus] [http-apr-8080-exec-9] Successfully retrieved IMAP server status from Alfresco: disabled
2013-04-03 21:02:11,800 ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-11] Exception from executeScript - redirecting to status template error: 03030001 Wrapped Exception (with status template): 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm
ost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")org.springframework.extensions.webscripts.WebScriptException: 03030001 Wrapped Exception (with status template): 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TYPE:"fm:topic" -TYPE:"fm
ost" +(TYPE:"content" OR TYPE:"app:filelink" OR TYPE:"folder")at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:426)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.alfresco.scripts.ScriptException: 03030056 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 03030055 Failed to execute search: +PATH:"/app:company_home/st:sites//cm:*" +@cm\:modified:[2013\-3\-27T00\:00\:00.000 TO 2013\-4\-3T23\:59\:59.999] +@cm\:modifier:"cthibault@egyde.ca" +TYPE:"cm:content" -TYPE:"cm:systemfolder" -TYPE:"fm:forums" -TYPE:"fm:forum" -TY
<code>
[….]
