hmm… data from /var/lib/pgsql/data/pg_log/postgresql-Fri.log
2014-07-18 00:40:18.750 MSK LOG: received fast shutdown request 2014-07-18 00:40:18.750 MSK LOG: aborting any active transactions 2014-07-18 00:40:18.750 MSK LOG: autovacuum launcher shutting down 2014-07-18 00:40:18.754 MSK LOG: shutting down 2014-07-18 00:40:32.141 MSK LOG: database system is shut down 2014-07-18 00:40:37.899 MSK LOG: database system was shut down at 2014-07-18 00:40:32 MSK 2014-07-18 00:40:38.078 MSK LOG: database system is ready to accept connections 2014-07-18 00:40:38.079 MSK LOG: autovacuum launcher started 2014-07-18 01:37:53.832 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 01:37:53.832 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (2879, (select id from rhnChecksumType where label = 'sha256'), '81bff035d495ee67f779edb98bebab8a4b112721e46bd3124450b11c79c90477') 2014-07-18 01:37:53.839 MSK ERROR: query returned no rows 2014-07-18 01:37:53.839 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 01:37:53.839 MSK STATEMENT: select lookup_checksum(E'sha256', E'81bff035d495ee67f779edb98bebab8a4b112721e46bd3124450b11c79c90477') id from dual 2014-07-18 01:37:57.767 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 01:37:57.767 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (2935, (select id from rhnChecksumType where label = 'sha256'), '711ba25b47743a4d1630ff823a4c096fa63d25bb84921f2d1cdedfe7eb329e54') 2014-07-18 01:37:57.768 MSK ERROR: query returned no rows 2014-07-18 01:37:57.768 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 01:37:57.768 MSK STATEMENT: select lookup_checksum(E'sha256', E'711ba25b47743a4d1630ff823a4c096fa63d25bb84921f2d1cdedfe7eb329e54') id from dual 2014-07-18 01:42:23.951 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 01:42:23.951 MSK STATEMENT: select 1 2014-07-18 01:42:28.665 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 01:42:28.665 MSK STATEMENT: select 1 2014-07-18 01:59:27.544 MSK ERROR: duplicate key value violates unique constraint "rhn_pkg_cap_name_version_uq" 2014-07-18 01:59:27.544 MSK STATEMENT: insert into rhnPackageCapability(id, name, version) values (19338, 'boost-devel(x86-64)', '1.41.0-18.el6') 2014-07-18 01:59:27.558 MSK ERROR: query returned no rows 2014-07-18 01:59:27.558 MSK CONTEXT: PL/pgSQL function "lookup_package_capability" line 34 at SQL statement 2014-07-18 01:59:27.558 MSK STATEMENT: select lookup_package_capability(E'boost-devel(x86-64)', E'1.41.0-18.el6') as id from dual 2014-07-18 02:00:15.387 MSK ERROR: duplicate key value violates unique constraint "rhn_pkg_cap_name_version_uq" 2014-07-18 02:00:15.387 MSK STATEMENT: insert into rhnPackageCapability(id, name, version) values (20353, 'boost-python-devel', '1.41.0-18.el6') 2014-07-18 02:00:15.389 MSK ERROR: query returned no rows 2014-07-18 02:00:15.389 MSK CONTEXT: PL/pgSQL function "lookup_package_capability" line 34 at SQL statement 2014-07-18 02:00:15.389 MSK STATEMENT: select lookup_package_capability(E'boost-python-devel', E'1.41.0-18.el6') as id from dual 2014-07-18 02:05:42.545 MSK ERROR: duplicate key value violates unique constraint "rhn_pn_name_uq" 2014-07-18 02:05:42.545 MSK STATEMENT: insert into rhnPackageName(id, name) values (214, 'boost-devel') 2014-07-18 02:05:42.546 MSK ERROR: query returned no rows 2014-07-18 02:05:42.546 MSK CONTEXT: PL/pgSQL function "lookup_package_name" line 20 at SQL statement 2014-07-18 02:05:42.546 MSK STATEMENT: select LOOKUP_PACKAGE_NAME(E'boost-devel') id from dual 2014-07-18 02:06:18.339 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:06:18.339 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (10914, (select id from rhnChecksumType where label = 'sha256'), '3dbc381a76778d34cd4e9f3ac0ba4eaf0fc39f30300c3cf705aaf2904e40a313') 2014-07-18 02:06:18.341 MSK ERROR: query returned no rows 2014-07-18 02:06:18.341 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:06:18.341 MSK STATEMENT: select lookup_checksum(E'sha256', E'3dbc381a76778d34cd4e9f3ac0ba4eaf0fc39f30300c3cf705aaf2904e40a313') id from dual 2014-07-18 02:06:31.426 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:06:31.426 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (11108, (select id from rhnChecksumType where label = 'sha256'), '380065ad87ddd9c7fa0cfe267c6333c0443493f4eef8dcf1df955387f0003c5e') 2014-07-18 02:06:31.428 MSK ERROR: query returned no rows 2014-07-18 02:06:31.428 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:06:31.428 MSK STATEMENT: select lookup_checksum(E'sha256', E'380065ad87ddd9c7fa0cfe267c6333c0443493f4eef8dcf1df955387f0003c5e') id from dual 2014-07-18 02:10:31.975 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:10:31.975 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (14811, (select id from rhnChecksumType where label = 'sha256'), '21fe61cde5d055a691e1d69cb97bd2359b25a5137611fd449b67afb5899c561b') 2014-07-18 02:10:31.976 MSK ERROR: query returned no rows 2014-07-18 02:10:31.976 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:10:31.976 MSK STATEMENT: select lookup_checksum(E'sha256', E'21fe61cde5d055a691e1d69cb97bd2359b25a5137611fd449b67afb5899c561b') id from dual 2014-07-18 02:10:42.714 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:10:42.714 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (14956, (select id from rhnChecksumType where label = 'sha256'), '637d64a90096ac466a84a6830fc6b12e7f999e5ce702d147855cb367b7e95f6f') 2014-07-18 02:10:42.715 MSK ERROR: query returned no rows 2014-07-18 02:10:42.715 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:10:42.715 MSK STATEMENT: select lookup_checksum(E'sha256', E'637d64a90096ac466a84a6830fc6b12e7f999e5ce702d147855cb367b7e95f6f') id from dual 2014-07-18 02:10:55.984 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:10:55.984 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (15118, (select id from rhnChecksumType where label = 'sha256'), '135bd367f7615dd4610fbef5f04e40e69b8490fe3d56d6e0a9282884f8ade945') 2014-07-18 02:10:55.986 MSK ERROR: query returned no rows 2014-07-18 02:10:55.986 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:10:55.986 MSK STATEMENT: select lookup_checksum(E'sha256', E'135bd367f7615dd4610fbef5f04e40e69b8490fe3d56d6e0a9282884f8ade945') id from dual 2014-07-18 02:11:14.090 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.091 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.159 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.161 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.163 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.164 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.192 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.196 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.203 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.205 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.208 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.211 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.211 MSK LOG: could not receive data from client: Connection reset by peer 2014-07-18 02:11:14.211 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.218 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.223 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.228 MSK LOG: unexpected EOF on client connection 2014-07-18 02:11:14.237 MSK LOG: unexpected EOF on client connection 2014-07-18 02:18:54.515 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:18:54.515 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (18161, (select id from rhnChecksumType where label = 'sha256'), 'be4bb5576a46303f7e64b80ab297827e4f32654500768a8a4bdd4a0081afa581') 2014-07-18 02:18:54.516 MSK ERROR: query returned no rows 2014-07-18 02:18:54.516 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:18:54.516 MSK STATEMENT: select lookup_checksum(E'sha256', E'be4bb5576a46303f7e64b80ab297827e4f32654500768a8a4bdd4a0081afa581') id from dual 2014-07-18 02:19:02.494 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:19:02.494 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (18287, (select id from rhnChecksumType where label = 'sha256'), 'a87de4d3db1eab8195465010c57e9625e1f320fdf75a413e4afd24f2309217cb') 2014-07-18 02:19:02.495 MSK ERROR: query returned no rows 2014-07-18 02:19:02.495 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:19:02.495 MSK STATEMENT: select lookup_checksum(E'sha256', E'a87de4d3db1eab8195465010c57e9625e1f320fdf75a413e4afd24f2309217cb') id from dual 2014-07-18 02:22:40.970 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:22:40.970 MSK STATEMENT: select 1 2014-07-18 02:22:59.758 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:22:59.758 MSK STATEMENT: select 1 2014-07-18 02:26:03.426 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:26:03.426 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (20827, (select id from rhnChecksumType where label = 'sha256'), '260df5aeb9c0a564e93d21d8b301372706b48e0dc76ae62de0835c597189149b') 2014-07-18 02:26:03.427 MSK ERROR: query returned no rows 2014-07-18 02:26:03.427 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:26:03.427 MSK STATEMENT: select lookup_checksum(E'sha256', E'260df5aeb9c0a564e93d21d8b301372706b48e0dc76ae62de0835c597189149b') id from dual 2014-07-18 02:26:09.723 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:26:09.723 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (20912, (select id from rhnChecksumType where label = 'sha256'), '3691ca156779f016677743f32a2073aed7bb037ad8c09f23ac66e9050f56ee73') 2014-07-18 02:26:09.724 MSK ERROR: query returned no rows 2014-07-18 02:26:09.724 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:26:09.724 MSK STATEMENT: select lookup_checksum(E'sha256', E'3691ca156779f016677743f32a2073aed7bb037ad8c09f23ac66e9050f56ee73') id from dual 2014-07-18 02:34:43.440 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:34:43.440 MSK STATEMENT: select 1 2014-07-18 02:34:58.949 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:34:58.949 MSK STATEMENT: select 1 2014-07-18 02:49:40.285 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:49:40.285 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (27411, (select id from rhnChecksumType where label = 'sha256'), '868ad1309c2fe18b4c68157b25b62bd95a9e4c41a39f502a17febdf1b3eb984f') 2014-07-18 02:49:40.286 MSK ERROR: query returned no rows 2014-07-18 02:49:40.286 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:49:40.286 MSK STATEMENT: select lookup_checksum(E'sha256', E'868ad1309c2fe18b4c68157b25b62bd95a9e4c41a39f502a17febdf1b3eb984f') id from dual 2014-07-18 02:49:46.299 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:49:46.299 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (27507, (select id from rhnChecksumType where label = 'sha256'), '5b43cc518811dbed9ad8a5bddfdf28a647cab18a67285c713cbdd5b4a06b8c4f') 2014-07-18 02:49:46.300 MSK ERROR: query returned no rows 2014-07-18 02:49:46.300 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:49:46.300 MSK STATEMENT: select lookup_checksum(E'sha256', E'5b43cc518811dbed9ad8a5bddfdf28a647cab18a67285c713cbdd5b4a06b8c4f') id from dual 2014-07-18 02:52:27.358 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:52:27.358 MSK STATEMENT: select 1 2014-07-18 02:52:31.639 MSK ERROR: current transaction is aborted, commands ignored until end of transaction block 2014-07-18 02:52:31.639 MSK STATEMENT: select 1 2014-07-18 02:58:32.316 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:58:32.316 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (31223, (select id from rhnChecksumType where label = 'sha256'), 'fc15a81113ffb95666fbfc471c512b7256e6bf1e863737334fd1583e2ce2e8a9') 2014-07-18 02:58:32.319 MSK ERROR: query returned no rows 2014-07-18 02:58:32.319 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:58:32.319 MSK STATEMENT: select lookup_checksum(E'sha256', E'fc15a81113ffb95666fbfc471c512b7256e6bf1e863737334fd1583e2ce2e8a9') id from dual 2014-07-18 02:58:39.265 MSK ERROR: duplicate key value violates unique constraint "rhnchecksum_chsum_uq" 2014-07-18 02:58:39.265 MSK STATEMENT: insert into rhnChecksum (id, checksum_type_id, checksum) values (31323, (select id from rhnChecksumType where label = 'sha256'), '2781936d94b405f487dbbf8cdf3e551875621ac84484336583285cefdd6d4e3b') 2014-07-18 02:58:39.267 MSK ERROR: query returned no rows 2014-07-18 02:58:39.267 MSK CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at SQL statement 2014-07-18 02:58:39.267 MSK STATEMENT: select lookup_checksum(E'sha256', E'2781936d94b405f487dbbf8cdf3e551875621ac84484336583285cefdd6d4e3b') id from dual Artem 18 июля 2014 г., в 2:49, Paul Robert Marino <[email protected]> написал(а): > PostgreSQL closed the connection for some reason. look at the > PostgreSQL logs for answers > > On Thu, Jul 17, 2014 at 6:32 PM, sirin <[email protected]> wrote: >> hi, >> >> how i can fix this? >> >> ~]# rhnpush -v —channel=<channel-name> --server=http://<hostname>/APP >> --dir=/mnt/Packages/ >> >> … >> Waiting 3 seconds and trying again... >> Uploading package /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm >> Using POST request >> Internal server error 500 Internal Server Error >> Error pushing /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm: (500) >> Waiting 4 seconds and trying again... >> Uploading package /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm >> Using POST request >> Internal server error 500 Internal Server Error >> Error pushing /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm: (500) >> Waiting 4 seconds and trying again... >> Giving up after 3 attempts >> … >> >> from /var/log/httpd/error_log >> >> … >> Fri Jul 18 02:22:40 2014] [error] Spacewalk 1530 2014/07/18 02:22:40 +04:00: >> ("DATABASE CONNECTION TO 'rhnschema' LOST", "Exception information: (99999, >> 'ERROR: current transaction is aborted, commands ignored until end of >> transaction block', '', InternalError('current transaction is aborted, >> commands ignored until end of transaction block\\\\n',))") >> [Fri Jul 18 02:22:59 2014] [error] Spacewalk 1536 2014/07/18 02:22:59 >> +04:00: ("DATABASE CONNECTION TO 'rhnschema' LOST", "Exception information: >> (99999, 'ERROR: current transaction is aborted, commands ignored until end >> of transaction block', '', InternalError('current transaction is aborted, >> commands ignored until end of transaction block\\\\n',))") >> >> >> [Fri Jul 18 02:26:03 2014] [error] Exception reported from spwalk-core1 >> [Fri Jul 18 02:26:03 2014] [error] Time: Fri Jul 18 02:26:03 2014 >> [Fri Jul 18 02:26:03 2014] [error] Exception type <class >> 'spacewalk.server.rhnSQL.sql_base.SQLSchemaError'> >> [Fri Jul 18 02:26:03 2014] [error] Exception while handling function >> server.apacheUploadServer._wrapper >> [Fri Jul 18 02:26:03 2014] [error] Request object information: >> [Fri Jul 18 02:26:03 2014] [error] URI: /PACKAGE-PUSH >> [Fri Jul 18 02:26:03 2014] [error] Remote Host: spwalk-core1 >> [Fri Jul 18 02:26:03 2014] [error] Server Name: spwalk-core1:80 >> [Fri Jul 18 02:26:03 2014] [error] Headers passed in: >> [Fri Jul 18 02:26:03 2014] [error] \tAccept-Encoding: identity >> [Fri Jul 18 02:26:03 2014] [error] \tCONTENT_LENGTH: 1090724 >> [Fri Jul 18 02:26:03 2014] [error] \tCONTENT_TYPE: application/x-rpm >> [Fri Jul 18 02:26:03 2014] [error] \tDOCUMENT_ROOT: /var/www/html >> [Fri Jul 18 02:26:03 2014] [error] \tGATEWAY_INTERFACE: CGI/1.1 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_ACCEPT_ENCODING: identity >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_HOST: spwalk-core1 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_USER_AGENT: rhnpush >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_AUTH_SESSION: >> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM: >> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM_TYPE: >> sha256 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FORCE: 0 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_ARCH: noarch >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_NAME: >> cim-schema >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_RELEASE: >> 2.1.el6 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_VERSION: >> 2.22.0 >> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGING: rpm >> [Fri Jul 18 02:26:03 2014] [error] \tHost: spwalk-core1 >> [Fri Jul 18 02:26:03 2014] [error] \tPATH_INFO: >> [Fri Jul 18 02:26:03 2014] [error] \tQUERY_STRING: >> [Fri Jul 18 02:26:03 2014] [error] \tREMOTE_ADDR: 192.168.0.150 >> [Fri Jul 18 02:26:03 2014] [error] \tREMOTE_PORT: 34568 >> [Fri Jul 18 02:26:03 2014] [error] \tREQUEST_METHOD: POST >> [Fri Jul 18 02:26:03 2014] [error] \tREQUEST_URI: /PACKAGE-PUSH >> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_FILENAME: >> /usr/share/rhn/wsgi/package_push.py >> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_NAME: /PACKAGE-PUSH >> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_URI: >> http://spwalk-core1/PACKAGE-PUSH >> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_URL: /PACKAGE-PUSH >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_ADDR: 192.168.0.150 >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_ADMIN: root@localhost >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_NAME: spwalk-core1 >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_PORT: 80 >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_PROTOCOL: HTTP/1.1 >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_SIGNATURE: <address>Apache >> Server at spwalk-core1 Port 80</address> >> [Fri Jul 18 02:26:03 2014] [error] >> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_SOFTWARE: Apache >> [Fri Jul 18 02:26:03 2014] [error] \tUser-Agent: rhnpush >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Auth-Session: >> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-File-Checksum: >> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-File-Checksum-Type: sha256 >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Force: 0 >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Arch: noarch >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Name: cim-schema >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Release: 2.1.el6 >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Version: 2.22.0 >> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Packaging: rpm >> [Fri Jul 18 02:26:03 2014] [error] \tmod_ssl.is_https: <built-in method >> ssl_is_https of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:03 2014] [error] \tmod_ssl.var_lookup: <built-in method >> ssl_var_lookup of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.application_group: >> 192.168.0.150|/package-push >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.callable_object: application >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.handler_script: >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.input_chunked: 0 >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.listener_host: >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.listener_port: 80 >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.process_group: >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.request_handler: wsgi-script >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.script_reloading: 1 >> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.version: (3, 2) >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.errors: <mod_wsgi.Log object at >> 0x7f9ddeb46bf0> >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.file_wrapper: <built-in method >> file_wrapper of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.input: <mod_wsgi.Input object at >> 0x7f9ddee71870> >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.multiprocess: True >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.multithread: False >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.run_once: False >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.url_scheme: http >> [Fri Jul 18 02:26:03 2014] [error] \twsgi.version: (1, 1) >> [Fri Jul 18 02:26:03 2014] [error] >> [Fri Jul 18 02:26:03 2014] [error] Exception Handler Information >> [Fri Jul 18 02:26:03 2014] [error] Traceback (most recent call last): >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/apacheUploadServer.py", >> line 100, in _wrapper >> [Fri Jul 18 02:26:03 2014] [error] ret = function(req) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/share/rhn/upload_server/handlers/package_push/package_push.py", line >> 124, in handler >> [Fri Jul 18 02:26:03 2014] [error] relative_path=self.rel_package_path, >> org_id=self.org_id) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnPackageUpload.py", >> line 143, in push_package >> [Fri Jul 18 02:26:03 2014] [error] importer.run() >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", >> line 649, in run >> [Fri Jul 18 02:26:03 2014] [error] self.fix() >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >> line 299, in fix >> [Fri Jul 18 02:26:03 2014] [error] ChannelPackageSubscription.fix(self) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >> line 74, in fix >> [Fri Jul 18 02:26:03 2014] [error] >> self.backend.lookupChecksums(self.checksums) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", >> line 505, in lookupChecksums >> [Fri Jul 18 02:26:03 2014] [error] h.execute(ctype=ctype, csum=csum) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line >> 147, in execute >> [Fri Jul 18 02:26:03 2014] [error] return >> self._execute_wrapper(self._execute, *p, **kw) >> [Fri Jul 18 02:26:03 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", >> line 292, in _execute_wrapper >> [Fri Jul 18 02:26:03 2014] [error] raise >> sql_base.SQLSchemaError(error_code, e.pgerror, e) >> [Fri Jul 18 02:26:03 2014] [error] SQLSchemaError: (99999, 'ERROR: query >> returned no rows', 'CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at >> SQL statement\\n', InternalError('query returned no rows\\nCONTEXT: >> PL/pgSQL function "lookup_checksum" line 23 at SQL statement\\n',)) >> [Fri Jul 18 02:26:03 2014] [error] >> [Fri Jul 18 02:26:03 2014] [error] Spacewalk 1527 2014/07/18 02:26:03 >> +04:00: ('Unhandled exception',) >> [Fri Jul 18 02:26:09 2014] [error] Exception reported from spwalk-core1 >> [Fri Jul 18 02:26:09 2014] [error] Time: Fri Jul 18 02:26:09 2014 >> [Fri Jul 18 02:26:09 2014] [error] Exception type <class >> 'spacewalk.server.rhnSQL.sql_base.SQLSchemaError'> >> [Fri Jul 18 02:26:09 2014] [error] Exception while handling function >> server.apacheUploadServer._wrapper >> [Fri Jul 18 02:26:09 2014] [error] Request object information: >> [Fri Jul 18 02:26:09 2014] [error] URI: /PACKAGE-PUSH >> [Fri Jul 18 02:26:09 2014] [error] Remote Host: spwalk-core1 >> [Fri Jul 18 02:26:09 2014] [error] Server Name: spwalk-core1:80 >> [Fri Jul 18 02:26:09 2014] [error] Headers passed in: >> [Fri Jul 18 02:26:09 2014] [error] \tAccept-Encoding: identity >> [Fri Jul 18 02:26:09 2014] [error] \tCONTENT_LENGTH: 1090724 >> [Fri Jul 18 02:26:09 2014] [error] \tCONTENT_TYPE: application/x-rpm >> [Fri Jul 18 02:26:09 2014] [error] \tDOCUMENT_ROOT: /var/www/html >> [Fri Jul 18 02:26:09 2014] [error] \tGATEWAY_INTERFACE: CGI/1.1 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_ACCEPT_ENCODING: identity >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_HOST: spwalk-core1 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_USER_AGENT: rhnpush >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_AUTH_SESSION: >> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM: >> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM_TYPE: >> sha256 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FORCE: 0 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_ARCH: noarch >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_NAME: >> cim-schema >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_RELEASE: >> 2.1.el6 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_VERSION: >> 2.22.0 >> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGING: rpm >> [Fri Jul 18 02:26:09 2014] [error] \tHost: spwalk-core1 >> [Fri Jul 18 02:26:09 2014] [error] \tPATH_INFO: >> [Fri Jul 18 02:26:09 2014] [error] \tQUERY_STRING: >> [Fri Jul 18 02:26:09 2014] [error] \tREMOTE_ADDR: 192.168.0.150 >> [Fri Jul 18 02:26:09 2014] [error] \tREMOTE_PORT: 34570 >> [Fri Jul 18 02:26:09 2014] [error] \tREQUEST_METHOD: POST >> [Fri Jul 18 02:26:09 2014] [error] \tREQUEST_URI: /PACKAGE-PUSH >> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_FILENAME: >> /usr/share/rhn/wsgi/package_push.py >> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_NAME: /PACKAGE-PUSH >> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_URI: >> http://spwalk-core1/PACKAGE-PUSH >> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_URL: /PACKAGE-PUSH >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_ADDR: 192.168.0.150 >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_ADMIN: root@localhost >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_NAME: spwalk-core1 >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_PORT: 80 >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_PROTOCOL: HTTP/1.1 >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_SIGNATURE: <address>Apache >> Server at spwalk-core1 Port 80</address> >> [Fri Jul 18 02:26:09 2014] [error] >> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_SOFTWARE: Apache >> [Fri Jul 18 02:26:09 2014] [error] \tUser-Agent: rhnpush >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Auth-Session: >> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-File-Checksum: >> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-File-Checksum-Type: sha256 >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Force: 0 >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Arch: noarch >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Name: cim-schema >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Release: 2.1.el6 >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Version: 2.22.0 >> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Packaging: rpm >> [Fri Jul 18 02:26:09 2014] [error] \tmod_ssl.is_https: <built-in method >> ssl_is_https of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:09 2014] [error] \tmod_ssl.var_lookup: <built-in method >> ssl_var_lookup of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.application_group: >> 192.168.0.150|/package-push >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.callable_object: application >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.handler_script: >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.input_chunked: 0 >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.listener_host: >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.listener_port: 80 >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.process_group: >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.request_handler: wsgi-script >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.script_reloading: 1 >> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.version: (3, 2) >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.errors: <mod_wsgi.Log object at >> 0x7f9dc794dbf0> >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.file_wrapper: <built-in method >> file_wrapper of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.input: <mod_wsgi.Input object at >> 0x7f9ddee548b0> >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.multiprocess: True >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.multithread: False >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.run_once: False >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.url_scheme: http >> [Fri Jul 18 02:26:09 2014] [error] \twsgi.version: (1, 1) >> [Fri Jul 18 02:26:09 2014] [error] >> [Fri Jul 18 02:26:09 2014] [error] Exception Handler Information >> [Fri Jul 18 02:26:09 2014] [error] Traceback (most recent call last): >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/apacheUploadServer.py", >> line 100, in _wrapper >> [Fri Jul 18 02:26:09 2014] [error] ret = function(req) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/share/rhn/upload_server/handlers/package_push/package_push.py", line >> 124, in handler >> [Fri Jul 18 02:26:09 2014] [error] relative_path=self.rel_package_path, >> org_id=self.org_id) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnPackageUpload.py", >> line 143, in push_package >> [Fri Jul 18 02:26:09 2014] [error] importer.run() >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", >> line 649, in run >> [Fri Jul 18 02:26:09 2014] [error] self.fix() >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >> line 299, in fix >> [Fri Jul 18 02:26:09 2014] [error] ChannelPackageSubscription.fix(self) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >> line 74, in fix >> [Fri Jul 18 02:26:09 2014] [error] >> self.backend.lookupChecksums(self.checksums) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", >> line 505, in lookupChecksums >> [Fri Jul 18 02:26:09 2014] [error] h.execute(ctype=ctype, csum=csum) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line >> 147, in execute >> [Fri Jul 18 02:26:09 2014] [error] return >> self._execute_wrapper(self._execute, *p, **kw) >> [Fri Jul 18 02:26:09 2014] [error] File >> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", >> line 292, in _execute_wrapper >> [Fri Jul 18 02:26:09 2014] [error] raise >> sql_base.SQLSchemaError(error_code, e.pgerror, e) >> [Fri Jul 18 02:26:09 2014] [error] SQLSchemaError: (99999, 'ERROR: query >> returned no rows', 'CONTEXT: PL/pgSQL function "lookup_checksum" line 23 at >> SQL statement\\n', InternalError('query returned no rows\\nCONTEXT: >> PL/pgSQL function "lookup_checksum" line 23 at SQL statement\\n',)) >> [Fri Jul 18 02:26:09 2014] [error] >> [Fri Jul 18 02:26:10 2014] [error] Spacewalk 1534 2014/07/18 02:26:10 >> +04:00: ('Unhandled exception’,) >> … >> >> Artem >> >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
