#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    1
    Rep Power
    0

    Alter table alter column throwing FATAL: terminating connection due to administrator


    pcwh=# ALTER TABLE cdr_denormalized
    pcwh-# ALTER COLUMN orig_mlqk_mn TYPE DOUBLE PRECISION;


    When I run the above command for a table which has around 60 partition table, where each partition has more than 1 lakh records, it fails with the below error after some time.


    FATAL: terminating connection due to administrator command
    FATAL: terminating connection due to administrator command
    The connection to the server was lost. Attempting reset: Failed.
    !>

    How can this be fixed ?

    Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    10
    FATAL: terminating connection due to administrator command
    How long does it take before you get this error? Are you running into a max query duration limit?

IMN logo majestic logo threadwatch logo seochat tools logo