API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 4th, 2015
465
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.58 KB | None | 0 0
raw download clone embed print report
  1. 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute S_1: BEGIN
  2. 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from logging.clear_log_id() as result
  3. 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
  4. 2015-02-25 16:44:51 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '117'
  5. 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
  6. 2015-02-25 16:44:51 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '117', $3 = NULL
  7. 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
  8. 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute S_1: BEGIN
  9. 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from logging.clear_log_id() as result
  10. 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
  11. 2015-02-25 16:44:52 CET susemanager susemanager 31445 DETAIL: parameters: $1 = '1000010000', $2 = '117'
  12. 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
  13. 2015-02-25 16:44:52 CET susemanager susemanager 31445 DETAIL: parameters: $1 = '1000010000', $2 = '117', $3 = NULL
  14. 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
  15. 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute S_1: BEGIN
  16. 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute <unnamed>: select * from rhn_server.update_needed_cache($1) as result
  17. 2015-02-25 16:44:53 CET susemanager susemanager 31446 DETAIL: parameters: $1 = '1000010000'
  18. 2015-02-25 16:45:05 CET susemanager susemanager 31423 LOG: statement: rollback;
  19.  
  20. 2015-02-25 16:45:06 CET susemanager susemanager 31397 LOG: unexpected EOF on client connection
  21. 2015-02-25 16:45:06 CET susemanager susemanager 31420 LOG: statement: SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 2278
  22. 2015-02-25 16:45:06 CET susemanager susemanager 31420 LOG: statement: SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
  23. FROM pg_type WHERE oid=2278
  24. 2015-02-25 16:45:10 CET susemanager susemanager 31420 LOG: statement: rollback;
  25.  
  26. 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute S_2: COMMIT
  27. 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
  28. 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute S_1: BEGIN
  29. 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute <unnamed>: select * from rhn_server.update_needed_cache($1) as result
  30. 2015-02-25 16:45:11 CET susemanager susemanager 31446 DETAIL: parameters: $1 = '1000010000'
  31. 2015-02-25 16:45:11 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
  32. 2015-02-25 16:45:11 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '118'
  33. 2015-02-25 16:45:11 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
  34. 2015-02-25 16:45:11 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '118', $3 = NULL
  35. 2015-02-25 16:45:12 CET susemanager susemanager 31446 ERROR: deadlock detected
  36. 2015-02-25 16:45:12 CET susemanager susemanager 31446 DETAIL: Process 31446 waits for ShareLock on transaction 2960664; blocked by process 31444.
  37. Process 31444 waits for ShareLock on transaction 2960666; blocked by process 31446.
  38. Process 31446: select * from rhn_server.update_needed_cache($1) as result
  39. Process 31444: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
  40. 2015-02-25 16:45:12 CET susemanager susemanager 31446 HINT: See server log for query details.
  41. 2015-02-25 16:45:12 CET susemanager susemanager 31446 CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."rhnserver" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
  42. SQL statement "insert into rhnServerNeededCache
  43. (server_id, errata_id, package_id, channel_id)
  44. (select distinct sp.server_id, x.errata_id, p.id, x.channel_id
  45. FROM (SELECT sp_sp.server_id, sp_sp.name_id,
  46. sp_sp.package_arch_id, max(sp_pe.evr) AS max_evr
  47. FROM rhnServerPackage sp_sp
  48. join rhnPackageEvr sp_pe ON sp_pe.id = sp_sp.evr_id
  49. GROUP BY sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id) sp
  50. join rhnPackage p ON p.name_id = sp.name_id
  51. join rhnPackageEvr pe ON pe.id = p.evr_id AND sp.max_evr < pe.evr
  52. join rhnPackageUpgradeArchCompat puac
  53. ON puac.package_arch_id = sp.package_arch_id
  54. AND puac.package_upgrade_arch_id = p.package_arch_id
  55. join rhnServerChannel sc ON sc.server_id = sp.server_id
  56. join rhnChannelPackage cp ON cp.package_id = p.id
  57. AND cp.channel_id = sc.channel_id
  58. left join (SELECT ep.errata_id, ce.channel_id, ep.package_id
  59. FROM rhnChannelErrata ce
  60. join rhnErrataPackage ep
  61. ON ep.errata_id = ce.errata_id
  62. join rhnServerChannel sc_sc
  63. ON sc_sc.channel_id = ce.channel_id
  64. WHERE sc_sc.server_id = server_id_in) x
  65. ON x.channel_id = sc.channel_id AND x.package_id = cp.package_id
  66. where sp.server_id = server_id_in)"
  67. PL/pgSQL function "update_needed_cache" line 5 at SQL statement
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!