API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 18th, 2020
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.77 KB | None | 0 0
raw download clone embed print report
  1. INFO 2/18/20 10:20 AM: liquibase: assemblyChangelog.xml: /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_add_aud_trigger.xml::add_aud_trigger::alexander.kuznetsov: ChangeSet /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_add_aud_trigger.xml::add_aud_trigger::alexander.kuznetsov ran successfully in 6218ms
  2. SEVERE 2/18/20 10:20 AM: liquibase: assemblyChangelog.xml: /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_execute_grant_all.xml::execute_grant_all_v4::alexander.kuznetsov: Change Set /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_execute_grant_all.xml::execute_grant_all_v4::alexander.kuznetsov failed. Error: ERROR: must be owner of schema public
  3. Where: SQL statement "alter schema "public" owner to app_group_master"
  4. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  5. declare
  6. i record;
  7. db text;
  8. begin
  9. select CURRENT_CATALOG into db;
  10. --схемы
  11. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  12. and nspname not like 'pg_%' loop
  13. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  14. end loop;
  15. --таблицы
  16. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  17. and schemaname not like 'pg_%' loop
  18. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  19. end loop;
  20. --представления
  21. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  22. and schemaname not like 'pg_%' loop
  23. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  24. end loop;
  25. --мат.представления
  26. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  27. and schemaname not like 'pg_%' loop
  28. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  29. end loop;
  30. --функции
  31. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  32. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  33. and nspname not like 'pg_%' loop
  34. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  35. end loop;
  36. --последовательности
  37. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  38. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  39. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  40. end loop;
  41. --типы
  42. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  43. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  44. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  45. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  46. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  47. end loop;
  48. --права для коннекта lsd_slave
  49. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  50. and nspname not like 'pg_%' loop
  51. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  52. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  53. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  54. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  55. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  56. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  57. end loop;
  58. end $$]
  59. liquibase.exception.DatabaseException: ERROR: must be owner of schema public
  60. Where: SQL statement "alter schema "public" owner to app_group_master"
  61. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  62. declare
  63. i record;
  64. db text;
  65. begin
  66. select CURRENT_CATALOG into db;
  67. --схемы
  68. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  69. and nspname not like 'pg_%' loop
  70. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  71. end loop;
  72. --таблицы
  73. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  74. and schemaname not like 'pg_%' loop
  75. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  76. end loop;
  77. --представления
  78. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  79. and schemaname not like 'pg_%' loop
  80. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  81. end loop;
  82. --мат.представления
  83. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  84. and schemaname not like 'pg_%' loop
  85. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  86. end loop;
  87. --функции
  88. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  89. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  90. and nspname not like 'pg_%' loop
  91. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  92. end loop;
  93. --последовательности
  94. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  95. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  96. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  97. end loop;
  98. --типы
  99. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  100. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  101. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  102. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  103. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  104. end loop;
  105. --права для коннекта lsd_slave
  106. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  107. and nspname not like 'pg_%' loop
  108. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  109. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  110. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  111. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  112. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  113. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  114. end loop;
  115. end $$]
  116. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  117. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  118. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  119. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  120. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  121. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  122. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  123. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  124. at liquibase.Liquibase.update(Liquibase.java:210)
  125. at liquibase.Liquibase.update(Liquibase.java:190)
  126. at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
  127. at liquibase.integration.commandline.Main.run(Main.java:180)
  128. at liquibase.integration.commandline.Main.main(Main.java:99)
  129. Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of schema public
  130. Where: SQL statement "alter schema "public" owner to app_group_master"
  131. PL/pgSQL function inline_code_block line 10 at EXECUTE
  132. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
  133. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
  134. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
  135. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  136. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  137. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
  138. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
  139. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
  140. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
  141. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  142. ... 12 more
  143. INFO 2/18/20 10:20 AM: liquibase: /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_execute_grant_all.xml::execute_grant_all_v4::alexander.kuznetsov: Successfully released change log lock
  144. Unexpected error running Liquibase: ERROR: must be owner of schema public
  145. Where: SQL statement "alter schema "public" owner to app_group_master"
  146. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  147. declare
  148. i record;
  149. db text;
  150. begin
  151. select CURRENT_CATALOG into db;
  152. --схемы
  153. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  154. and nspname not like 'pg_%' loop
  155. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  156. end loop;
  157. --таблицы
  158. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  159. and schemaname not like 'pg_%' loop
  160. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  161. end loop;
  162. --представления
  163. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  164. and schemaname not like 'pg_%' loop
  165. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  166. end loop;
  167. --мат.представления
  168. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  169. and schemaname not like 'pg_%' loop
  170. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  171. end loop;
  172. --функции
  173. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  174. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  175. and nspname not like 'pg_%' loop
  176. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  177. end loop;
  178. --последовательности
  179. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  180. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  181. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  182. end loop;
  183. --типы
  184. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  185. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  186. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  187. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  188. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  189. end loop;
  190. --права для коннекта lsd_slave
  191. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  192. and nspname not like 'pg_%' loop
  193. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  194. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  195. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  196. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  197. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  198. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  199. end loop;
  200. end $$]
  201.  
  202. SEVERE 2/18/20 10:20 AM: liquibase: /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_execute_grant_all.xml::execute_grant_all_v4::alexander.kuznetsov: ERROR: must be owner of schema public
  203. Where: SQL statement "alter schema "public" owner to app_group_master"
  204. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  205. declare
  206. i record;
  207. db text;
  208. begin
  209. select CURRENT_CATALOG into db;
  210. --схемы
  211. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  212. and nspname not like 'pg_%' loop
  213. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  214. end loop;
  215. --таблицы
  216. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  217. and schemaname not like 'pg_%' loop
  218. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  219. end loop;
  220. --представления
  221. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  222. and schemaname not like 'pg_%' loop
  223. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  224. end loop;
  225. --мат.представления
  226. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  227. and schemaname not like 'pg_%' loop
  228. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  229. end loop;
  230. --функции
  231. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  232. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  233. and nspname not like 'pg_%' loop
  234. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  235. end loop;
  236. --последовательности
  237. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  238. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  239. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  240. end loop;
  241. --типы
  242. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  243. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  244. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  245. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  246. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  247. end loop;
  248. --права для коннекта lsd_slave
  249. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  250. and nspname not like 'pg_%' loop
  251. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  252. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  253. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  254. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  255. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  256. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  257. end loop;
  258. end $$]
  259. liquibase.exception.MigrationFailedException: Migration failed for change set /opt/rmis/liquibase-app/liquibase/db/changelog/000000000000_execute_grant_all.xml::execute_grant_all_v4::alexander.kuznetsov:
  260. Reason: liquibase.exception.DatabaseException: ERROR: must be owner of schema public
  261. Where: SQL statement "alter schema "public" owner to app_group_master"
  262. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  263. declare
  264. i record;
  265. db text;
  266. begin
  267. select CURRENT_CATALOG into db;
  268. --схемы
  269. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  270. and nspname not like 'pg_%' loop
  271. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  272. end loop;
  273. --таблицы
  274. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  275. and schemaname not like 'pg_%' loop
  276. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  277. end loop;
  278. --представления
  279. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  280. and schemaname not like 'pg_%' loop
  281. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  282. end loop;
  283. --мат.представления
  284. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  285. and schemaname not like 'pg_%' loop
  286. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  287. end loop;
  288. --функции
  289. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  290. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  291. and nspname not like 'pg_%' loop
  292. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  293. end loop;
  294. --последовательности
  295. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  296. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  297. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  298. end loop;
  299. --типы
  300. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  301. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  302. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  303. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  304. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  305. end loop;
  306. --права для коннекта lsd_slave
  307. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  308. and nspname not like 'pg_%' loop
  309. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  310. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  311. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  312. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  313. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  314. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  315. end loop;
  316. end $$]
  317. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
  318. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  319. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  320. at liquibase.Liquibase.update(Liquibase.java:210)
  321. at liquibase.Liquibase.update(Liquibase.java:190)
  322. at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
  323. at liquibase.integration.commandline.Main.run(Main.java:180)
  324. at liquibase.integration.commandline.Main.main(Main.java:99)
  325. Caused by: liquibase.exception.DatabaseException: ERROR: must be owner of schema public
  326. Where: SQL statement "alter schema "public" owner to app_group_master"
  327. PL/pgSQL function inline_code_block line 10 at EXECUTE [Failed SQL: do $$
  328. declare
  329. i record;
  330. db text;
  331. begin
  332. select CURRENT_CATALOG into db;
  333. --схемы
  334. for i in select nspname from pg_catalog.pg_namespace where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  335. and nspname not like 'pg_%' loop
  336. execute 'alter schema '||'"'||i.nspname||'"'||' owner to app_group_master';
  337. end loop;
  338. --таблицы
  339. for i in select tablename, schemaname from pg_catalog.pg_tables where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  340. and schemaname not like 'pg_%' loop
  341. execute 'alter table '||'"'||i.schemaname||'"'||'."'||i.tablename||'" owner to app_group_master';
  342. end loop;
  343. --представления
  344. for i in select viewname, schemaname from pg_catalog.pg_views where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  345. and schemaname not like 'pg_%' loop
  346. execute 'alter view '||'"'||i.schemaname||'"'||'."'||i.viewname||'" owner to app_group_master';
  347. end loop;
  348. --мат.представления
  349. for i in select matviewname, schemaname from pg_catalog.pg_matviews where schemaname not in('supp', 'jenkins', 'information_schema', 'eyes')
  350. and schemaname not like 'pg_%' loop
  351. execute 'alter materialized view '||'"'||i.schemaname||'"'||'."'||i.matviewname||'" owner to app_group_master';
  352. end loop;
  353. --функции
  354. for i in select pg_get_function_identity_arguments(p.oid) as arg, proname, nspname from pg_catalog.pg_namespace n
  355. join pg_catalog.pg_proc p on pronamespace = n.oid where nspname not in('supp', 'jenkins', 'information_schema', 'eyes')
  356. and nspname not like 'pg_%' loop
  357. execute 'alter function '||'"'||i.nspname||'"'||'."'||i.proname||'"('||i.arg||') owner to app_group_master';
  358. end loop;
  359. --последовательности
  360. for i in select c.relname, nspname from pg_catalog.pg_class c join pg_catalog.pg_namespace n on relnamespace = n.oid
  361. where c.relkind = 'S' and nspname not in('supp', 'jenkins', 'eyes') loop
  362. execute 'alter sequence '||i.nspname||'."'||i.relname||'" owner to app_group_master';
  363. end loop;
  364. --типы
  365. for i in select n.nspname, t.typname from pg_type t left join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  366. where (t.typrelid = 0 or (select c.relkind = 'c' from pg_catalog.pg_class c where c.oid = t.typrelid))
  367. and not exists(select 1 from pg_catalog.pg_type el where el.oid = t.typelem and el.typarray = t.oid)
  368. and n.nspname NOT IN ('pg_catalog', 'information_schema', 'supp', 'jenkins', 'eyes') loop
  369. execute 'alter type '||'"'||i.nspname||'"'||'."'||i.typname||'" owner to app_group_master';
  370. end loop;
  371. --права для коннекта lsd_slave
  372. for i in select nspname from pg_catalog.pg_namespace where nspname not in('information_schema', 'eyes')
  373. and nspname not like 'pg_%' loop
  374. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_slave';
  375. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_slave';
  376. execute 'alter default privileges in schema '||'"'||i.nspname||'"'||' grant select on tables to app_group_slave';
  377. execute 'grant usage on schema '||'"'||i.nspname||'"'||' to app_group_master';
  378. execute 'grant select on all tables in schema '||'"'||i.nspname||'"'||' to app_group_master';
  379. execute 'grant create on database '||'"'||db||'"'||' to app_group_master';
  380. end loop;
  381. end $$]
  382. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  383. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  384. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  385. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  386. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  387. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  388. ... 7 more
  389. Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of schema public
  390. Where: SQL statement "alter schema "public" owner to app_group_master"
  391. PL/pgSQL function inline_code_block line 10 at EXECUTE
  392. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
  393. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
  394. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
  395. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  396. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  397. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
  398. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
  399. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
  400. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
  401. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  402. ... 12 more
  403.  
  404.  
  405. For more information, use the --logLevel flag
  406. Build step 'Execute shell' marked build as failure
  407. Finished: FAILURE
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!