Page 1 of 2
tables can have at most 1600 columns
Posted:
Tue May 20, 2014 3:57 am
by hotrocket
Hello
I installed PT 4.11 and tried to update the cache when a message appeared: "...tables can have at most 1600 columns"
I have many self-programmed stats and don`t know how many columns I have. I like the idea, that the self-programmed stats are instantly ready in cache. But I don`t know how to update my database now.
Do I have to delete some columns? How do I explore how many columns I have? Is there a way to update the database without deleting some columns?
Thanks for any help!!
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 4:55 am
by WhiteRider
This is a PostgreSQL restriction on the number of columns in a table. I believe that the development team are investigating a way to work around this, but in the meantime you will need to restrict the number of custom columns which are cached to 1600. Each custom column now has a "Cache" checkbox - you can turn this off to prevent a column from being cached, and you will need to reduce the number of cached columns to less than 1600.
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 5:19 am
by hotrocket
Thanks for information. I have about 2600 columns which most are in use. So I try to reinstall an older version of PT4 untill the problem is solved by the the development team.
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 5:25 am
by WhiteRider
Please note that if the database has been updated and you revert to a previous version of PT4 you will need to restore a backup of your database from before the upgrade was run. If you use a backup made at the start of the upgrade process then you will need to rebuild the cache via Database > Database Management.
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 7:05 am
by hotrocket
i did rebuild cache in PT 10.6.
then my selfmade hud profiles were not there. i tried to reimport then the message came:
Unable to import profile.
Reason: PT4 Hud Profile Version 1020, Expected 1019 (file: H:\Cash - 2013b.pt4hud)
how can this be solved? TY
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 7:15 am
by kraada
That can't be solved; the HUD profile was updated. But that's ok because you want to upgrade to 4.11.
The 1600 column restriction only applies to columns you put in the cache. You'll be able to put something like 1590 columns in the cache (there are a few columns that are needed for internal use) and the rest will be uncached. But having 1590 cached columns and 1000 uncached columns is much, much better than having everything uncached! The cached columns will come as fast as the default stats and the uncached columns will come after just as they always have.
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 7:35 am
by hotrocket
ist there a way to make all custom stats to be uncached in one step or do i have to remove 1000 checkmarks one by one?
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 7:52 am
by kraada
I'll ask and see if there's an automated way but I'm not aware of one. But you'd probably be finished doing it by the time I get an answer if you started now.
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 12:22 pm
by js2002
I got "too many variables" erro during rebuild cache. So I guess it is the same 1600 limit. or the 999 parameter/variable limit at sql queries. Please inform the coders (with a whip^^).
Re: tables can have at most 1600 columns
Posted:
Tue May 20, 2014 12:35 pm
by kraada
They've been informed.