Error in table: powa_statements_src_tmp

[feddeMurua]

Hi !

Can you tell me why powa shows me this error? o where I can find the complete log to analyze??

Thanks you very much!

Best regards,

[rjuju]

Hi,

I think the issue is caused by having a different major powa version (X.Y) on the remote server and the repository server. There's already a patch in the dev version of powa-collector to explicitly check for that and raise an proper error message, it will be release soon.

[feddeMurua]

Hi Julien, Yes, you are right, in one server I have centos with postgres 15, same all extensions and in the other hand I have postgres 14 including powa. What should I do? Can I downgrade only powa version ? Or I must equals all packages (postgres and extensions) from 14 to 15?

Thanks.

Lic. Murua Federico Nicolás RW - Chubut

El El sáb, 9 dic 2023 a la(s) 14:28, Julien Rouhaud < @.***> escribió:

Hi,

I think the issue is caused by having a different major powa version (X.Y) on the remote server and the repository server. There's already a patch in the dev version of powa-collector to explicitly check for that and raise an proper error message, it will be release soon.

— Reply to this email directly, view it on GitHub https://github.com/powa-team/powa-web/issues/188#issuecomment-1848588991, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACH2CARIU3LXW6VCKOF4LF3YISNT3AVCNFSM6AAAAABAN5ORUKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBYGU4DQOJZGE . You are receiving this because you authored the thread.Message ID: @.***>

[rjuju]

Having different postgres versions is not a problem at all, the powa extension takes care of it. What you can't do is have powa in different major versions, but that's usually not a problem to upgrade it on all servers.

Maybe you have powa 4.1.x on one side and powa 4.2.x on the other side?

[feddeMurua]

Yes, that was the problem. Thanks you very much !