postgres error after upgrade: permission denied for relation nodes

[slmeyer]

Upgrading from 1.4.2 to 1.6.2 postgres 8.3.5 on Archlinux
First entry in log:
4746:20090204:132723 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: permission denied for relation nodes

I have run the upgrade script without any errors, I have reentered my password for the db in the zabbix_server.conf file.

I see that the upgrade scripts did something to the users table.

Does anyone see any hint on this ?

[gullevek]

I have exactly the same problem

The reason is the previously working connection user "zabbix" has no longer rights to do anything.

What I really do not understand, that even after I do a grant all for the database to the user zabbix he still could not read anything. Only after I would give all tables explicit grants it worked.

alternative is to change the database owner to zabbix.

This is really very strange and I have not yet found out why.

[gullevek]

Solution and Reasion

I upgraded on debian, and it seems it runs the upgrade script as postgres, so the other tables were owned by zabbix, but the new were not.

login with:

$> psql -U postgres zabbix

and a

zabbix=> \d

and you will see some have "postgres" as an owner. You need to change them (one by one) with the command

zabbix=> alter table <table name> owner to zabbix;

[slmeyer]

Thanks but not enough here

The access problems solved OK thanks, but I have further errors after startup:

15194:20090224:134541 Expression [{15700}>150000] for item [23582][Hp4050-kaleido:ifInOctets1] cannot be evaluated: unable to get function value: lastvalue IS NULL for function [15700][Hp4050-kaleido:ifInOctets1.delta(0)]
15194:20090224:134542 Expression [{15841}>100] for item [23522][Hp4050-kaleido:icmpOutEchos] cannot be evaluated: unable to get function value: lastvalue IS NULL for function [15841][Hp4050-kaleido:icmpOutEchos.delta(0)]
15209:20090224:134542 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: INSERT has more expressions than target columns
[insert into history (clock,itemid,value) values (1235479542,28238,19076,000000)]
15209:20090224:134542 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of transaction block
[select num,value_min,value_avg,value_max from trends where itemid=28238 and clock=1235476800]
15183:20090224:134542 One child process died. Exiting ...
15183:20090224:134544 ZABBIX Server stopped. ZABBIX 1.6.2.

It seems to me that the upgrade did not run well

[slmeyer]

PGRES_FATAL_ERROR:ERROR: INSERT has more expressions than target columns
[insert into history (clock,itemid,value) values (1235479542,28238,19076,000000)]

It seems that the three columns mentioned are OK, but then it presents 4 data - is it something with language and decimal separator?