pgBadger-
Global information
- Generated on Tue May 17 12:01:48 2022
- Log file: /data/pglog/huge_log_test/pgbouncer.log.1, ..., /data/pglog/huge_log_test/postgresql-Tue.log
- Parsed 199,632,421 log entries in 7m13s
- Log start from 2012-12-06 00:00:00 to 2012-12-12 00:00:00
-
Events
Log levels
Key values
- 92,863,696 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 3963 ERROR entries
- 2 WARNING entries
Most Frequent Errors/Events
Key values
- 3,930 Max number of times the same event was reported
- 3,965 Total events found
Rank Times reported Error 1 3,930 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 07 10 7 11 80 12 80 13 80 14 80 15 80 16 80 17 80 18 80 19 80 20 80 21 80 22 80 Dec 08 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 80 13 80 14 80 15 80 16 80 17 80 18 80 19 80 20 80 21 80 22 80 Dec 09 23 80 00 80 01 80 02 80 03 80 04 80 05 80 06 80 07 80 08 80 09 80 10 80 11 80 12 3 - ERROR: invalid input syntax for type date: "" at character 32
Statement: UPDATE ddtracker SET datestamp='' WHERE os='WINXP' AND arch='i686' AND branch='cuda_a' AND dbname='nightly';
Date: 2012-12-07 11:59:02 Database: inventory Application: User: lfriedman Remote:
2 15 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 06 04 8 Dec 07 04 5 05 1 06 1 - LOG: process 25246 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.101 ms
- LOG: process 25246 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.117 ms
- LOG: process 24824 still waiting for ExclusiveLock on extension of relation 485634 of database 16413 after 1000.115 ms
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 46115: ""2012-12-07 05:30:25","Root/Functional/Image/Arithmetic/ImageSqr_AC4R_Tests/Sqr_16u_AC4RSfs_Test/Int..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 05:31:19 Database: nightly Application: User: lfriedman Remote:
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 69762: ""2012-12-07 05:30:25","Root/Functional/Image/FilterTests/FilterSobelHoriz/8u_C4R/Source/Dst_Offset8"..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 05:31:49 Database: nightly Application: User: lfriedman Remote:
Context: SQL statement "INSERT INTO nppsmoketests_2012_12 VALUES (NEW.*)" PL/pgSQL function nppsmoketests_insert_trigger() line 30 at SQL statement COPY nppsmoketests, line 108128: ""2012-12-07 05:29:48","Root/Functional/Signal/ArithmeticTests/SignalAddCTests/AddC_16sc_Test/Integer..."
Statement: COPY nppsmoketests (last_update,testname,current_status,suiteid,regressioncl,testcl,os,arch,build_type,branch,gpu,subtest,osversion) FROM STDIN with CSV HEADER ESCAPE '~';Date: 2012-12-07 05:32:05 Database: nightly Application: User: lfriedman Remote:
3 13 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 06 07 1 08 1 09 1 17 1 18 2 Dec 07 00 1 08 1 09 1 11 2 12 1 Dec 11 19 1 - ERROR: syntax error at or near "GROUP" at character 17
- ERROR: syntax error at or near "selectpdu" at character 1
- ERROR: syntax error at or near "/" at character 1
Statement: SELECT cl FROM GROUP BY cl ORDER BY cl DESC LIMIT 7
Date: 2012-12-07 01:42:49 Database: nightly Application: User: lfriedman Remote:
Statement: selectpdu,lab from locations order by lab;
Date: 2012-12-07 09:29:42 Database: inventory Application: User: lfriedman Remote:
Statement: /d select * from locations;
Date: 2012-12-07 10:20:07 Database: inventory Application: User: lfriedman Remote:
4 2 ERROR: invalid input syntax for integer: ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 11 19 2 - ERROR: invalid input syntax for integer: "Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1" at character 46
- ERROR: invalid input syntax for integer: "Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1" at character 126
Statement: select count(id) from filterout WHERE (bug = 'Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1') AND last_update='2012-12-11';
Date: 2012-12-11 20:46:28 Database: nightly Application: User: lfriedman Remote:
Statement: select id,last_update,active,script,os,osversion,arch,gpu,branch,build,vc,testname,category,bug from filterout WHERE (bug = 'Root/Functional/Signal/ArithmeticTests/SignalLnTests/Ln_32f_Test/Sink/Size_1') AND last_update='2012-12-11' order by id desc offset 0 limit 500;
Date: 2012-12-11 20:46:28 Database: nightly Application: User: lfriedman Remote:
5 2 WARNING: pgstat wait timeout
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 06 08 1 Dec 11 06 1 - WARNING: pgstat wait timeout
Date: 2012-12-06 09:06:25
6 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Dec 06 17 1 Dec 07 10 1 - ERROR: column "system" does not exist at character 63
- ERROR: column "system" does not exist at character 82
Statement: update systems set active='f',comment='AP:reallocating' where system='cuda-mac64-build11' ;
Date: 2012-12-07 11:33:14 Database: cbs Application: User: lfriedman Remote:
Statement: update systems set active='f',comment='AP: turning off to assess capacity' where system='cuda-mac64-test0' ;
Date: 2012-12-06 18:15:41 Database: cbs Application: User: lfriedman Remote:
7 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Dec 07 10 1 - ERROR: relation "bulds" does not exist at character 13
Statement: delete from bulds where active='disabled' ;
Date: 2012-12-07 11:56:13 Database: cbs Application: User: lfriedman Remote: