SHARE
TWEET

Untitled

a guest Mar 4th, 2015 218 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
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
 
Top