Skip Menu |

This queue is for tickets about the Test-Smoke CPAN distribution.

Report information
The Basics
Id: 83243
Status: resolved
Priority: 0/
Queue: Test-Smoke

People
Owner: Nobody in particular
Requestors: perl [...] greerga.m-l.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.53
Fixed in: (no value)



Subject: SmokeDB report fails at server with Win32
Sending report to SmokeDB fails at the server on Windows 2000 (MSWin32). The returned JSON is: - - - 8< - - - 8< - - - {"db_error":"DBIx::Class::ResultSet::create(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type timestamp with time zone: \"2013-02-08 Eastern Standard Time\" [for Statement \"INSERT INTO report ( applied_patches, architecture, compiler_msgs, config_count, cpu_count, cpu_description, duration, git_describe, git_id, harness3opts, harness_only, hostname, lang, lc_all, log_file, manifest_msgs, osname, osversion, out_file, perl_id, reporter, reporter_version, sconfig_id, skipped_tests, smoke_date, smoke_perl, smoke_revision, smoke_version, smoker_version, summary, test_jobs, user_note, username) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING id\" with ParamValues: 1='SMOKE23aa77bc9fa488ace3ef1089104e999c23821171', 2='x86', 3=[...], 4='4', 5='1', 6='Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz(~2650 MHz)', 7='9797', 8='v5.17.8-126-g23aa77b', 9='23aa77bc9fa488ace3ef1089104e999c23821171', 10='', 11='0', 12='perl-win2k', 13=undef, 14=undef, 15=undef, 16='', 17='MSWin32', 18='Win2000 SP4', 19=undef, 20='5.17.9', 21=[...], 22='0.050', 23='1', 24='', 25='2013-02-08 Eastern Standard Time', 26='5.10.0', 27='1374', 28='1.53', 29='0.045', 30='PASS', 31=undef, 32='', 33='Tivrusky'] at /home/abeltje/tsgateway/lib/Test/Smoke/Gateway.pm line 126\n","error":"Unexpected error."} - - - 8< - - - 8< - - -
Hi, Can you send me the mktest.jsn and mktest.out file that were generated (in the perl-current dir) That helps me debug the thing. Thanks in advance! -- Abe. On Sat Feb 09 13:13:44 2013, perl@greerga.m-l.org wrote: Show quoted text
> Sending report to SmokeDB fails at the server on Windows 2000 (MSWin32). > The returned JSON is: > > - - - 8< - - - 8< - - - > {"db_error":"DBIx::Class::ResultSet::create(): DBI Exception: > DBD::Pg::st execute failed: ERROR: invalid input syntax for type > timestamp with time zone: \"2013-02-08 Eastern Standard Time\" [for > Statement \"INSERT INTO report ( applied_patches, architecture, > compiler_msgs, config_count, cpu_count, cpu_description, duration, > git_describe, git_id, harness3opts, harness_only, hostname, lang, > lc_all, log_file, manifest_msgs, osname, osversion, out_file, perl_id, > reporter, reporter_version, sconfig_id, skipped_tests, smoke_date, > smoke_perl, smoke_revision, smoke_version, smoker_version, summary, > test_jobs, user_note, username) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) > RETURNING id\" with ParamValues: > 1='SMOKE23aa77bc9fa488ace3ef1089104e999c23821171', 2='x86', 3=[...], > 4='4', 5='1', 6='Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz(~2650 MHz)', > 7='9797', 8='v5.17.8-126-g23aa77b', > 9='23aa77bc9fa488ace3ef1089104e999c23821171', 10='', 11='0', > 12='perl-win2k', 13=undef, 14=undef, 15=undef, 16='', 17='MSWin32', > 18='Win2000 SP4', 19=undef, 20='5.17.9', 21=[...], 22='0.050', 23='1', > 24='', 25='2013-02-08 Eastern Standard Time', 26='5.10.0', 27='1374', > 28='1.53', 29='0.045', 30='PASS', 31=undef, 32='', 33='Tivrusky'] at > /home/abeltje/tsgateway/lib/Test/Smoke/Gateway.pm line > 126\n","error":"Unexpected error."} > - - - 8< - - - 8< - - -
Subject: Re: [rt.cpan.org #83243] SmokeDB report fails at server with Win32
Date: Wed, 5 Jun 2013 13:52:08 -0400 (EDT)
To: Abe Timmerman via RT <bug-Test-Smoke [...] rt.cpan.org>
From: George Greer <perl [...] greerga.m-l.org>
On Thu, 9 May 2013, Abe Timmerman via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=83243 > > > Hi, > > Can you send me the mktest.jsn and mktest.out file that were generated (in the perl-current dir)
I don't see "mktest" prefixes, but they are some with those suffixes in the log directory that I rsync to a web server: http://m-l.org/~perl/smoke/perl/win32/blead/ A log file with the PostgreSQL errors at the bottom is at (for 30-ish days): http://m-l.org/~perl/smoke/perl/win32/smoke-me_smoke.log -- George Greer
commit 18648c5b28576f3dcc88a858a46e7b0ceb270d3d Author: abeltje <abeltje@test-smoke.org> Date: Sun May 31 13:37:49 2015 +0200 BUGFIX: my Windows doesn't support strftime("%T") On strawberry it seems POSIX::strftime() has some issues: %z acts like %Z and %T doesn't work