Advertisement
Guest User

postgredetails

a guest
Dec 1st, 2021
25
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [root@dbaasjump002 deploy]# kubectl get all -n possu2
  2. NAME READY STATUS RESTARTS AGE
  3. pod/pgo-deploy-lp5td 0/1 Completed 0 63m
  4. pod/postgres-operator-6d8c847594-skhwd 4/4 Running 0 62m
  5.  
  6. NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
  7. service/postgres-operator ClusterIP 10.255.17.139 <none> 8443/TCP,4171/TCP,4150/TCP 63m
  8.  
  9. NAME READY UP-TO-DATE AVAILABLE AGE
  10. deployment.apps/postgres-operator 1/1 1 1 62m
  11.  
  12. NAME DESIRED CURRENT READY AGE
  13. replicaset.apps/postgres-operator-6d8c847594 1 1 1 62m
  14.  
  15. NAME COMPLETIONS DURATION AGE
  16. job.batch/pgo-deploy 1/1 56s 63m
  17.  
  18. Logs (or some of the latest rows) from operator "kubectl logs postgres-operator-6d8c847594-skhwd operator -n possu2":
  19. time="2021-12-01T07:24:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pods in the Core API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:370" version=0.2.0
  20. time="2021-12-01T07:24:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource jobs in the Batch API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:382" version=0.2.0
  21. time="2021-12-01T07:24:56Z" level=error msg="Namespace Controller: error syncing Namespace 'possu2': Controller Manager: cannot start controller group for namespace possu2 because it does not have the required privs, will attempt to start on the next ns refresh interval" func="github.com/percona/percona-postgresql-operator/internal/controller/namespace.(*Controller).processNextWorkItem()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/namespace/namespacecontroller.go:151" version=0.2.0
  22. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: serviceaccounts is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot create resource \"serviceaccounts\" in API group \"\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileServiceAccounts()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:132" version=0.2.0
  23. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: serviceaccounts is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot create resource \"serviceaccounts\" in API group \"\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileServiceAccounts()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:132" version=0.2.0
  24. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: serviceaccounts is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot create resource \"serviceaccounts\" in API group \"\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileServiceAccounts()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:132" version=0.2.0
  25. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: serviceaccounts is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot create resource \"serviceaccounts\" in API group \"\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileServiceAccounts()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:132" version=0.2.0
  26. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: roles.rbac.authorization.k8s.io \"pgo-pg-role\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"roles\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoles()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:95" version=0.2.0
  27. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: roles.rbac.authorization.k8s.io \"pgo-target-role\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"roles\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoles()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:95" version=0.2.0
  28. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: roles.rbac.authorization.k8s.io \"pgo-backrest-role\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"roles\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoles()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:95" version=0.2.0
  29. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: rolebindings.rbac.authorization.k8s.io \"pgo-backrest-role-binding\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"rolebindings\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoleBindings()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:112" version=0.2.0
  30. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: rolebindings.rbac.authorization.k8s.io \"pgo-pg-role-binding\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"rolebindings\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoleBindings()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:112" version=0.2.0
  31. time="2021-12-01T07:25:56Z" level=error msg="operator is unable to reconcile RBAC resource: rolebindings.rbac.authorization.k8s.io \"pgo-target-role-binding\" is forbidden: User \"system:serviceaccount:possu2:postgres-operator\" cannot get resource \"rolebindings\" in API group \"rbac.authorization.k8s.io\" in the namespace \"possu2\"" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).reconcileRoleBindings()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/rbac.go:112" version=0.2.0
  32. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pgtasks in the pg.percona.com API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:357" version=0.2.0
  33. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pgclusters in the pg.percona.com API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:357" version=0.2.0
  34. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pgreplicas in the pg.percona.com API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:357" version=0.2.0
  35. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pgpolicies in the pg.percona.com API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:357" version=0.2.0
  36. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource pods in the Core API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:370" version=0.2.0
  37. time="2021-12-01T07:25:56Z" level=error msg="Controller Manager: Controller Group for namespace possu2 does not have the required list privileges for resource jobs in the Batch API" func="github.com/percona/percona-postgresql-operator/internal/controller/manager.(*ControllerManager).hasListerPrivs()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/manager/controllermanager.go:382" version=0.2.0
  38. time="2021-12-01T07:25:56Z" level=error msg="Namespace Controller: error syncing Namespace 'possu2': Controller Manager: cannot start controller group for namespace possu2 because it does not have the required privs, will attempt to start on the next ns refresh interval" func="github.com/percona/percona-postgresql-operator/internal/controller/namespace.(*Controller).processNextWorkItem()" file="/go/src/github.com/percona/percona-postgresql-operator/internal/controller/namespace/namespacecontroller.go:151" version=0.2.0
  39.  
  40. Detailed information about cluster:
  41. [root@dbaasjump002 deploy]# kubectl describe PerconaPGCluster cluster1 -n possu2
  42. Name: cluster1
  43. Namespace: possu2
  44. Labels: crunchy-pgha-scope=cluster1
  45. deployment-name=cluster1
  46. name=cluster1
  47. pg-cluster=cluster1
  48. pgo-version=1.0.0
  49. pgouser=admin
  50. Annotations: current-primary: cluster1
  51. API Version: pg.percona.com/v1
  52. Kind: PerconaPGCluster
  53. Metadata:
  54. Creation Timestamp: 2021-12-01T06:24:02Z
  55. Generation: 1
  56. Managed Fields:
  57. API Version: pg.percona.com/v1
  58. Fields Type: FieldsV1
  59. fieldsV1:
  60. f:metadata:
  61. f:annotations:
  62. .:
  63. f:current-primary:
  64. f:kubectl.kubernetes.io/last-applied-configuration:
  65. f:labels:
  66. .:
  67. f:crunchy-pgha-scope:
  68. f:deployment-name:
  69. f:name:
  70. f:pg-cluster:
  71. f:pgo-version:
  72. f:pgouser:
  73. f:spec:
  74. .:
  75. f:backup:
  76. .:
  77. f:backrestRepoImage:
  78. f:image:
  79. f:resources:
  80. .:
  81. f:requests:
  82. .:
  83. f:memory:
  84. f:schedule:
  85. f:volumeSpec:
  86. .:
  87. f:accessmode:
  88. f:size:
  89. f:storageclass:
  90. f:storagetype:
  91. f:database:
  92. f:disableAutofail:
  93. f:namespace:
  94. f:pause:
  95. f:pgBadger:
  96. .:
  97. f:enabled:
  98. f:image:
  99. f:port:
  100. f:pgBouncer:
  101. .:
  102. f:expose:
  103. .:
  104. f:serviceType:
  105. f:image:
  106. f:resources:
  107. .:
  108. f:limits:
  109. .:
  110. f:cpu:
  111. f:memory:
  112. f:requests:
  113. .:
  114. f:cpu:
  115. f:memory:
  116. f:size:
  117. f:pgPrimary:
  118. .:
  119. f:expose:
  120. .:
  121. f:serviceType:
  122. f:image:
  123. f:resources:
  124. .:
  125. f:requests:
  126. .:
  127. f:memory:
  128. f:tolerations:
  129. f:volumeSpec:
  130. .:
  131. f:accessmode:
  132. f:size:
  133. f:storageclass:
  134. f:storagetype:
  135. f:pgReplicas:
  136. .:
  137. f:hotStandby:
  138. .:
  139. f:enableSyncStandby:
  140. f:expose:
  141. .:
  142. f:serviceType:
  143. f:resources:
  144. .:
  145. f:requests:
  146. .:
  147. f:memory:
  148. f:size:
  149. f:volumeSpec:
  150. .:
  151. f:accessmode:
  152. f:size:
  153. f:storageclass:
  154. f:storagetype:
  155. f:pmm:
  156. .:
  157. f:enabled:
  158. f:image:
  159. f:pmmSecret:
  160. f:resources:
  161. .:
  162. f:requests:
  163. .:
  164. f:cpu:
  165. f:memory:
  166. f:serverHost:
  167. f:serverUser:
  168. f:port:
  169. f:standby:
  170. f:tlsOnly:
  171. f:user:
  172. f:userLabels:
  173. .:
  174. f:pgo-version:
  175. Manager: kubectl-client-side-apply
  176. Operation: Update
  177. Time: 2021-12-01T06:24:02Z
  178. Resource Version: 3438312
  179. UID: 11785a67-e02d-4ae2-add0-a0105cc821c0
  180. Spec:
  181. Backup:
  182. Backrest Repo Image: percona/percona-postgresql-operator:1.0.0-ppg13-pgbackrest-repo
  183. Image: percona/percona-postgresql-operator:1.0.0-ppg13-pgbackrest
  184. Resources:
  185. Requests:
  186. Memory: 48Mi
  187. Schedule:
  188. Keep: 3
  189. Name: sat-night-backup
  190. Schedule: 0 0 * * 6
  191. Storage: local
  192. Type: full
  193. Volume Spec:
  194. Accessmode: ReadWriteOnce
  195. Size: 1G
  196. Storageclass:
  197. Storagetype: dynamic
  198. Database: pgdb
  199. Disable Autofail: false
  200. Namespace: possu2
  201. Pause: false
  202. Pg Badger:
  203. Enabled: false
  204. Image: percona/percona-postgresql-operator:1.0.0-ppg13-pgbadger
  205. Port: 10000
  206. Pg Bouncer:
  207. Expose:
  208. Service Type: ClusterIP
  209. Image: percona/percona-postgresql-operator:1.0.0-ppg13-pgbouncer
  210. Resources:
  211. Limits:
  212. Cpu: 2
  213. Memory: 512Mi
  214. Requests:
  215. Cpu: 1
  216. Memory: 128Mi
  217. Size: 1
  218. Pg Primary:
  219. Expose:
  220. Service Type: ClusterIP
  221. Image: percona/percona-postgresql-operator:1.0.0-ppg13-postgres-ha
  222. Resources:
  223. Requests:
  224. Memory: 128Mi
  225. Tolerations:
  226. Volume Spec:
  227. Accessmode: ReadWriteOnce
  228. Size: 1G
  229. Storageclass:
  230. Storagetype: dynamic
  231. Pg Replicas:
  232. Hot Standby:
  233. Enable Sync Standby: false
  234. Expose:
  235. Service Type: ClusterIP
  236. Resources:
  237. Requests:
  238. Memory: 128Mi
  239. Size: 2
  240. Volume Spec:
  241. Accessmode: ReadWriteOnce
  242. Size: 1G
  243. Storageclass:
  244. Storagetype: dynamic
  245. Pmm:
  246. Enabled: false
  247. Image: percona/pmm-client:2.15.1
  248. Pmm Secret: cluster1-pmm-secret
  249. Resources:
  250. Requests:
  251. Cpu: 500m
  252. Memory: 200M
  253. Server Host: monitoring-service
  254. Server User: admin
  255. Port: 5432
  256. Standby: false
  257. Tls Only: false
  258. User: pguser
  259. User Labels:
  260. Pgo - Version: 1.0.0
  261. Events: <none>
  262.  
Advertisement
RAW Paste Data Copied
Advertisement