API tools faq
paste
Advertisement
Guest User

postgredetails

a guest
Dec 1st, 2021
63
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.28 KB | None | 0 0
raw download clone embed print report
  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
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!