Update 1.8.001 to 1.8.004 on PostgreSQL 9.2

[roman.laube]

Hello,
I am lookig for solution for following problem. During upgrade from 1.8.001 to 1.8.004 I have got following error messages:

DropTable(‘egw_links’) sql=Array ( [0] => DROP TABLE “egw_links” )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateTableSQL(‘egw_links’,‘link_id I AUTOINCREMENT NOTNULL PRIMARY, link_app1 C(25) NOTNULL, link_id1 C(50) NOTNULL, link_app2 C(25) NOTNULL, link_id2 C(50) NOTNULL, link_remark C(100), link_lastmod I8 NOTNULL, link_owner I4 NOTNULL, deleted T’) sql=Array ( [0] => CREATE TABLE “egw_links” ( “link_id” SERIAL, “link_app1” VARCHAR(25) NOT NULL, “link_id1” VARCHAR(50) NOT NULL, “link_app2” VARCHAR(25) NOT NULL, “link_id2” VARCHAR(50) NOT NULL, “link_remark” VARCHAR(100), “link_lastmod” INT8 NOT NULL, “link_owner” INT4 NOT NULL, “deleted” TIMESTAMP, PRIMARY KEY (“link_id”) ) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateIndexSQL(NULL,‘egw_links’,‘deleted’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_deleted” ON “egw_links” (“deleted”) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app1 [1] => link_id1 [2] => link_lastmod ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_app1_id1_lastmod” ON “egw_links” (“link_app1”, “link_id1”, “link_lastmod”) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app2 [1] => link_id2 [2] => link_lastmod ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_app2_id2_lastmod” ON “egw_links” (“link_app2”, “link_id2”, “link_lastmod”) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
AlterColumnSQL(‘egw_addressbook’,‘adr_one_countrycode’,Array ( [type] => varchar [precision] => 2 ) ) sql=Array ( [0] => ALTER TABLE “egw_addressbook” ADD COLUMN “adr_one_countrycode” VARCHAR(2) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
AlterColumnSQL(‘egw_addressbook’,‘adr_two_countrycode’,Array ( [type] => varchar [precision] => 2 ) ) sql=Array ( [0] => ALTER TABLE “egw_addressbook” ADD COLUMN “adr_two_countrycode” VARCHAR(2) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateIndexSQL(NULL,‘egw_access_log’,‘li’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_li” ON “egw_access_log” (“li”) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
DropTable(‘egw_app_sessions’) sql=Array ( [0] => DROP TABLE “egw_app_sessions” )
ERROR: current transaction is aborted, commands ignored until end of transaction block
DropTable(‘egw_sessions’) sql=Array ( [0] => DROP TABLE “egw_sessions” )
ERROR: current transaction is aborted, commands ignored until end of transaction block
DropTable(‘egw_vfs’) sql=Array ( [0] => DROP TABLE “egw_vfs” )
ERROR: current transaction is aborted, commands ignored until end of transaction block
AlterColumnSQL(‘egw_addressbook’,‘carddav_name’,Array ( [type] => varchar [precision] => 64 [comment] => name part of CardDAV URL, if specified by client ) ) sql=Array ( [0] => ALTER TABLE “egw_addressbook” ADD COLUMN “carddav_name” VARCHAR(64) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateIndexSQL(NULL,‘egw_addressbook’,‘carddav_name’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_carddav_name” ON “egw_addressbook” (“carddav_name”) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
AlterColumnSQL(‘egw_categories’,‘cat_owner C(255) NOTNULL DEFAULT ‘0’’,‘cat_owner C(255) NOTNULL DEFAULT ‘0’’) sql=
Array
(
[0] => BEGIN
[1] => SELECT * INTO TEMPORARY TABLE egw_categories_tmp FROM egw_categories
[2] => DROP TABLE “egw_categories”
[3] => CREATE TABLE “egw_categories” (
“cat_owner” VARCHAR(255) DEFAULT ‘0’ NOT NULL
)
[4] => INSERT INTO egw_categories SELECT FROM egw_categories_tmp
[5] => DROP TABLE egw_categories_tmp
[6] => COMMIT
)

Does anybody know how to fix it?
Thank you for your reply.
Sincerely
Roman Laube

[webratz]

Hello,

i’m experiencing the same problem while upgrading on PostgreSQL 9.1.
The SQL queries itself are working fine except the last one when directly executed. (Missing SELECT parameters).
Altough the upgrade is still not working for me.

[Leithoff_Klaus]

I checked. This seems to happen when Refreshing the table egw_links.
Refreshing with pgsql is done in several steps:
creating a temp table with SELECT * INTO TEMPORARY TABLE xyz FROM egw_links;
then dropping egw_links;
then recreating egw_links with the new definition
and then refilling the table.

Your transaction seemed to have failed while copying the data into the TEMPORARY Table,
because it refuses to cooperate after that statement.

kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

[webratz]

Hi,

in my case it happens on this query:

BEGIN;
SELECT * INTO TEMPORARY TABLE egw_categories_tmp FROM egw_categories;
DROP TABLE “egw_categories”;
CREATE TABLE “egw_categories” (“cat_owner” VARCHAR(255) DEFAULT ‘0’ NOT
NULL);
INSERT INTO egw_categories SELECT FROM egw_categories_tmp;
DROP TABLE egw_categories_tmp;
COMMIT;

As you can see the 3rd line from bottom is wrong:

INSERT INTO egw_categories SELECT FROM egw_categories_tmp;

Sure, something after the select is missing:

INSERT INTO egw_categories SELECT * FROM egw_categories_tmp;

But that does also fail with the following error:

ERROR: INSERT has more expressions than target columns

So it seems the select only should use some fields to map it into the
new table. Just which fields?

[Leithoff_Klaus]

knowing how egw_categories should look like, even line

CREATE TABLE “egw_categories” (“cat_owner” VARCHAR(255) DEFAULT ‘0’ NOT
NULL);

is wrong (from the point of view what is expected to be the result).

---

kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

[roman.laube]

I seems that version 1.8.005 solves this issue. Upgrade is without problem now.

Roman Laube