CMDBuild Forum

Psql exception in upgrade da 2.0.3 a 2.1.5

Old Versions
#1

Buongiorno,

stiamo testando l'upgrade di una installazione di cmdbuild 2.0.3 alla 2.1.5, ma incorriamo in un errore psql al momento dell'applicazione delle patch.

Il sistema è una centos5, con tomcat6 e postgres 8.4 (tutto aggiornato via epel a questa mattina).

L'errore da UI è: 

Call: services/json/configure/applypatches
-------------------------------------------
Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:842)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand.executeAndReturnKey(EntryInsertCommand.java:95)
	at org.cmdbuild.dao.driver.postgres.PostgresDriver.create(PostgresDriver.java:163)
	at org.cmdbuild.dao.entry.DBEntry.saveOnly(DBEntry.java:128)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:49)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:7)
	at org.cmdbuild.services.DefaultPatchManager.createPatchCard(DefaultPatchManager.java:270)
	at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:240)
	at org.cmdbuild.servlets.json.Configure.applyPatches(Configure.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:701)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:448)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:532)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:415)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand$1.createPreparedStatement(EntryInsertCommand.java:99)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)
	... 41 more

 

Mentre il tail di logs/cmdbuild.log dà:

INFO  2013-12-03 10:44:44 [cmdbuild] Initializer custom ParameterBuilders
INFO  2013-12-03 10:44:49 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:44:49 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:44:49 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:44:55 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:44:56 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2013-12-03 10:45:26 [jsonrpc ] Calling url /configure/testconnection
INFO  2013-12-03 10:45:28 [jsonrpc ] Calling url /configure/apply
INFO  2013-12-03 10:45:28 [cmdbuild] Saving configuration
INFO  2013-12-03 10:45:28 [cmdbuild] inside addLastPatchIfEmptyDb method but before if. Database type: existing
INFO  2013-12-03 10:45:31 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:45:31 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:45:31 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:45:32 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:45:33 [jsonrpc ] Calling url /configure/getpatches
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/applypatches
INFO  2013-12-03 10:45:35 [cmdbuild] Applying patch 2.1.0-01
ERROR 2013-12-03 10:45:35 [jsonrpc ] A org.springframework.jdbc.UncategorizedSQLException occurred calling method class org.cmdbuild.servlets.json.Configure.applyPatches: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/getpatches

 

 

Cosa possiamo fare per far andare queste patch?

#2

Buongiorno,

 

ci sono aggiornamenti?

 

Previously Mauro wrote:

Buongiorno,

stiamo testando l'upgrade di una installazione di cmdbuild 2.0.3 alla 2.1.5, ma incorriamo in un errore psql al momento dell'applicazione delle patch.

Il sistema è una centos5, con tomcat6 e postgres 8.4 (tutto aggiornato via epel a questa mattina).

L'errore da UI è: 

Call: services/json/configure/applypatches
-------------------------------------------
Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:842)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand.executeAndReturnKey(EntryInsertCommand.java:95)
	at org.cmdbuild.dao.driver.postgres.PostgresDriver.create(PostgresDriver.java:163)
	at org.cmdbuild.dao.entry.DBEntry.saveOnly(DBEntry.java:128)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:49)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:7)
	at org.cmdbuild.services.DefaultPatchManager.createPatchCard(DefaultPatchManager.java:270)
	at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:240)
	at org.cmdbuild.servlets.json.Configure.applyPatches(Configure.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:701)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:448)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:532)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:415)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand$1.createPreparedStatement(EntryInsertCommand.java:99)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)
	... 41 more

 

 

Mentre il tail di logs/cmdbuild.log dà:

INFO  2013-12-03 10:44:44 [cmdbuild] Initializer custom ParameterBuilders
INFO  2013-12-03 10:44:49 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:44:49 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:44:49 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:44:55 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:44:56 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2013-12-03 10:45:26 [jsonrpc ] Calling url /configure/testconnection
INFO  2013-12-03 10:45:28 [jsonrpc ] Calling url /configure/apply
INFO  2013-12-03 10:45:28 [cmdbuild] Saving configuration
INFO  2013-12-03 10:45:28 [cmdbuild] inside addLastPatchIfEmptyDb method but before if. Database type: existing
INFO  2013-12-03 10:45:31 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:45:31 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:45:31 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:45:32 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:45:33 [jsonrpc ] Calling url /configure/getpatches
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/applypatches
INFO  2013-12-03 10:45:35 [cmdbuild] Applying patch 2.1.0-01
ERROR 2013-12-03 10:45:35 [jsonrpc ] A org.springframework.jdbc.UncategorizedSQLException occurred calling method class org.cmdbuild.servlets.json.Configure.applyPatches: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/getpatches

 

 

Cosa possiamo fare per far andare queste patch?

 

#3

Previously Mauro wrote:

Buongiorno,

stiamo testando l'upgrade di una installazione di cmdbuild 2.0.3 alla 2.1.5, ma incorriamo in un errore psql al momento dell'applicazione delle patch.

Il sistema è una centos5, con tomcat6 e postgres 8.4 (tutto aggiornato via epel a questa mattina).

L'errore da UI è: 

Call: services/json/configure/applypatches
-------------------------------------------
Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:842)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand.executeAndReturnKey(EntryInsertCommand.java:95)
	at org.cmdbuild.dao.driver.postgres.PostgresDriver.create(PostgresDriver.java:163)
	at org.cmdbuild.dao.entry.DBEntry.saveOnly(DBEntry.java:128)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:49)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:7)
	at org.cmdbuild.services.DefaultPatchManager.createPatchCard(DefaultPatchManager.java:270)
	at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:240)
	at org.cmdbuild.servlets.json.Configure.applyPatches(Configure.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:701)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:448)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:532)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:415)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand$1.createPreparedStatement(EntryInsertCommand.java:99)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)
	... 41 more

 

 

Mentre il tail di logs/cmdbuild.log dà:

INFO  2013-12-03 10:44:44 [cmdbuild] Initializer custom ParameterBuilders
INFO  2013-12-03 10:44:49 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:44:49 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:44:49 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:44:55 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:44:56 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2013-12-03 10:45:26 [jsonrpc ] Calling url /configure/testconnection
INFO  2013-12-03 10:45:28 [jsonrpc ] Calling url /configure/apply
INFO  2013-12-03 10:45:28 [cmdbuild] Saving configuration
INFO  2013-12-03 10:45:28 [cmdbuild] inside addLastPatchIfEmptyDb method but before if. Database type: existing
INFO  2013-12-03 10:45:31 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:45:31 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:45:31 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:45:32 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:45:33 [jsonrpc ] Calling url /configure/getpatches
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/applypatches
INFO  2013-12-03 10:45:35 [cmdbuild] Applying patch 2.1.0-01
ERROR 2013-12-03 10:45:35 [jsonrpc ] A org.springframework.jdbc.UncategorizedSQLException occurred calling method class org.cmdbuild.servlets.json.Configure.applyPatches: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/getpatches

 

 

Cosa possiamo fare per far andare queste patch?

 

Buongiorno Mauro

 

Mi inserisco perchè anche io ho avuto il medesimo problema e ho risolto (empiricamnete) in questo modo:

 

Il problema è localizzato alla riga 41

(il messaggio è: 

nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

  Dove: SQL statement in PL/PgSQL function "patch_215_03" near line 41) ed è visibile in cmdbuild.log.

 

In particolare lo statement sql 'incriminato' era:

 

CREATE OR REPLACE VIEW system_privilegescatalog AS
        SELECT DISTINCT ON (permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."Notes", permission."IdRole", permission."IdGrantedClass") permission."Id", permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."BeginDate", permission."Notes", permission."IdRole", permission."IdGrantedClass", permission."Mode"
            FROM (
                SELECT "Grant"."Id", "Grant"."IdClass", "Grant"."Code", "Grant"."Description", "Grant"."Status", "Grant"."User", "Grant"."BeginDate", "Grant"."Notes", "Grant"."IdRole", "Grant"."IdGrantedClass", "Grant"."Mode"
                    FROM "Grant"
                UNION
                SELECT (-1), '"Grant"'::regclass AS regclass, ''::character varying AS "varchar", ''::character varying AS "varchar", 'A'::bpchar AS bpchar, 'admin'::character varying AS "varchar", now() AS now, NULL::text AS unknown, "Role"."Id", system_classcatalog.classid::regclass AS classid, '-'::character varying AS "varchar"
                    FROM system_classcatalog, "Role"
                    WHERE system_classcatalog.classid::regclass::oid <> '"Class"'::regclass::oid AND NOT ("Role"."Id"::text || system_classcatalog.classid::integer::text IN (SELECT "Grant"."IdRole"::text || "Grant"."IdGrantedClass"::oid::integer::text FROM "Grant"))) permission
                JOIN system_classcatalog ON permission."IdGrantedClass"::oid = system_classcatalog.classid AND (_cm_legacy_read_comment(system_classcatalog.classcomment::character varying::text, 'MODE'::character varying::text)::text = ANY (ARRAY['write'::character varying::text, 'read'::character varying::text]))
                ORDER BY permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."Notes", permission."IdRole", permission."IdGrantedClass";

 

 

Io ho fatto in questo modo:

 

a) copiato lo statement incriminato in un file testo, denominato statement.sql

b) connesso come utente al sistema linux (nel mio caso RH6)

c) entrato in psql interattivo: psql <nomedb>

d) eseguito il file  statement.sql con : \i statement.sql

e) verificato l'esito eseguendo \d system_privilegescatalog


Quindi ho commentato (--) nel file ./webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql tutto lo statement eseguito precedentemente. Rientrato in cmdbuild e tutto ha funzionato.

 

stefano

 

 

 

 

#4

Ciao, sono collega di Mauro che ha creato questo post:

l'errore non si risolve perchè è affetta la patch 2.1.0-01 e non la 2.1.5-03 su cui Stefano hai detto di commentare parte dello script.

Inoltre, se prendo la 2.1.0-01 e la eseguo manualmente va ok, ma si pianta sullo stesso errore la 2.1.0-02 (la successiva).

Mi viene il dubbio che non sia un problema di versione di Postgresql..perchè su un postgres 9.3 (in Ubuntu) ciò non accade

!

 

Altre possibili idee?

 

 

Previously Stefano wrote:
Previously Mauro wrote:

Buongiorno,

stiamo testando l'upgrade di una installazione di cmdbuild 2.0.3 alla 2.1.5, ma incorriamo in un errore psql al momento dell'applicazione delle patch.

Il sistema è una centos5, con tomcat6 e postgres 8.4 (tutto aggiornato via epel a questa mattina).

L'errore da UI è: 

Call: services/json/configure/applypatches
-------------------------------------------
Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:842)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand.executeAndReturnKey(EntryInsertCommand.java:95)
	at org.cmdbuild.dao.driver.postgres.PostgresDriver.create(PostgresDriver.java:163)
	at org.cmdbuild.dao.entry.DBEntry.saveOnly(DBEntry.java:128)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:49)
	at org.cmdbuild.dao.entry.DBCard.save(DBCard.java:7)
	at org.cmdbuild.services.DefaultPatchManager.createPatchCard(DefaultPatchManager.java:270)
	at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:240)
	at org.cmdbuild.servlets.json.Configure.applyPatches(Configure.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:622)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:701)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:448)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:532)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:415)
	at org.cmdbuild.dao.driver.postgres.EntryInsertCommand$1.createPreparedStatement(EntryInsertCommand.java:99)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)
	... 41 more

 

 

Mentre il tail di logs/cmdbuild.log dà:

INFO  2013-12-03 10:44:44 [cmdbuild] Initializer custom ParameterBuilders
INFO  2013-12-03 10:44:49 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:44:49 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:44:49 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:44:55 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:44:56 [jsonrpc ] Calling url /utils/listavailabletranslations
INFO  2013-12-03 10:45:26 [jsonrpc ] Calling url /configure/testconnection
INFO  2013-12-03 10:45:28 [jsonrpc ] Calling url /configure/apply
INFO  2013-12-03 10:45:28 [cmdbuild] Saving configuration
INFO  2013-12-03 10:45:28 [cmdbuild] inside addLastPatchIfEmptyDb method but before if. Database type: existing
INFO  2013-12-03 10:45:31 [cmdbuild] Number of fetched patches: 69
INFO  2013-12-03 10:45:31 [cmdbuild] Last patch /opt/tomcat6/webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql
INFO  2013-12-03 10:45:31 [cmdbuild] Last available patch is 2.1.5-03
INFO  2013-12-03 10:45:32 [jsonrpc ] Calling url /utils/gettranslationobject
INFO  2013-12-03 10:45:33 [jsonrpc ] Calling url /configure/getpatches
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/applypatches
INFO  2013-12-03 10:45:35 [cmdbuild] Applying patch 2.1.0-01
ERROR 2013-12-03 10:45:35 [jsonrpc ] A org.springframework.jdbc.UncategorizedSQLException occurred calling method class org.cmdbuild.servlets.json.Configure.applyPatches: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is not supported.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
INFO  2013-12-03 10:45:35 [jsonrpc ] Calling url /configure/getpatches

 

 

Cosa possiamo fare per far andare queste patch?

 

Buongiorno Mauro

 

Mi inserisco perchè anche io ho avuto il medesimo problema e ho risolto (empiricamnete) in questo modo:

 

Il problema è localizzato alla riga 41

(il messaggio è: 

nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

  Dove: SQL statement in PL/PgSQL function "patch_215_03" near line 41) ed è visibile in cmdbuild.log.

 

In particolare lo statement sql 'incriminato' era:

 

CREATE OR REPLACE VIEW system_privilegescatalog AS
        SELECT DISTINCT ON (permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."Notes", permission."IdRole", permission."IdGrantedClass") permission."Id", permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."BeginDate", permission."Notes", permission."IdRole", permission."IdGrantedClass", permission."Mode"
            FROM (
                SELECT "Grant"."Id", "Grant"."IdClass", "Grant"."Code", "Grant"."Description", "Grant"."Status", "Grant"."User", "Grant"."BeginDate", "Grant"."Notes", "Grant"."IdRole", "Grant"."IdGrantedClass", "Grant"."Mode"
                    FROM "Grant"
                UNION
                SELECT (-1), '"Grant"'::regclass AS regclass, ''::character varying AS "varchar", ''::character varying AS "varchar", 'A'::bpchar AS bpchar, 'admin'::character varying AS "varchar", now() AS now, NULL::text AS unknown, "Role"."Id", system_classcatalog.classid::regclass AS classid, '-'::character varying AS "varchar"
                    FROM system_classcatalog, "Role"
                    WHERE system_classcatalog.classid::regclass::oid <> '"Class"'::regclass::oid AND NOT ("Role"."Id"::text || system_classcatalog.classid::integer::text IN (SELECT "Grant"."IdRole"::text || "Grant"."IdGrantedClass"::oid::integer::text FROM "Grant"))) permission
                JOIN system_classcatalog ON permission."IdGrantedClass"::oid = system_classcatalog.classid AND (_cm_legacy_read_comment(system_classcatalog.classcomment::character varying::text, 'MODE'::character varying::text)::text = ANY (ARRAY['write'::character varying::text, 'read'::character varying::text]))
                ORDER BY permission."IdClass", permission."Code", permission."Description", permission."Status", permission."User", permission."Notes", permission."IdRole", permission."IdGrantedClass";

 

 

Io ho fatto in questo modo:

 

a) copiato lo statement incriminato in un file testo, denominato statement.sql

b) connesso come utente al sistema linux (nel mio caso RH6)

c) entrato in psql interattivo: psql <nomedb>

d) eseguito il file  statement.sql con : \i statement.sql

e) verificato l'esito eseguendo \d system_privilegescatalog


Quindi ho commentato (--) nel file ./webapps/cmdbuild/WEB-INF/patches/2.1.5-03.sql tutto lo statement eseguito precedentemente. Rientrato in cmdbuild e tutto ha funzionato.

 

stefano