OTRS 3.3.5 I/O Perl Errors on Windows/IIS

[alf12]

Hello,
one week ago I updated from OTRS 3.3.4 to 3.3.5.
I'm running OTRS on a 'Windows 2008 R2 Standard 64bit' Server with IIS7.5.7600 and ActiveState Perl for quite a while w/o any problems.

Since the update we are experiencing intermedient File and Socket I/O Erros:
See some examples from otrs.log:

Code: Select all

 24293: [Tue Mar  4 09:06:29 2014][Error][Kernel::System::Stats::Static::StateAction::_GetDBDataPerDay][169] [Microsoft][ODBC SQL Server Driver]Ungültiger Zeichenwert für  Konvertierungsangabe (SQL-22018), SQL: 'SELECT count(*) FROM ticket_history WHERE history_type_id = ? AND create_time >= ? AND create_time <= ?'
	Line 24302: [Tue Mar  4 09:25:44 2014][Error][Kernel::System::Ticket::ArticleStorageFS::ArticlePlain][421] [b]Can't open[/b] E:/article.fs/2014/03/04/20950/plain.txt: 
	Line 24402: [Tue Mar  4 11:30:15 2014][Error][main::_AutoRestart][678] Could not start-up new Scheduler instance.
	Line 24535: [Tue Mar  4 14:05:03 2014][Error][Kernel::System::Cache::FileStorable::__ANON__][194] [b]Can't remove file[/b] C:/otrs/OTRS/var/tmp/CacheFileStorable/CacheInternalUser/4/d/4d78e4ada7f0265e153d957804340954: Permission denied
	Line 24536: [Tue Mar  4 14:05:03 2014][Error][Kernel::System::Cache::FileStorable::__ANON__][194] Can't remove file C:/otrs/OTRS/var/tmp/CacheFileStorable/CacheInternalUser/6/1/614f4e6a2f4f3c444ae205bdc958fc63: Permission denied
	Line 24537: [Tue Mar  4 14:05:03 2014][Error][Kernel::System::Cache::FileStorable::__ANON__][194] Can't remove file C:/otrs/OTRS/var/tmp/CacheFileStorable/CacheInternalUser/9/9/99e30ce893dc22a6ffb2b141236dc38c: Permission denied
...
	Line 25924: [Thu Mar  6 07:41:41 2014][Error][[b]Kernel::System::Main::FileRead[/b]][371] Can't open 'C:/otrs/OTRS/Kernel/Output/HTML/xxx/Footer.dtl': [b]Bad file descriptor[/b]
	Line 25925: [Thu Mar  6 07:41:41 2014][Error][Kernel::Output::HTML::Layout::Output][553] Can't read C:/otrs/OTRS/Kernel/Output/HTML/xxx/Footer.dtl: [b]Inappropriate I/O control operation[/b]
	Line 25926: [Thu Mar  6 07:44:12 2014][Error][Kernel::System::CustomerUser::new][100] Module Kernel/System/CustomerUser/DB.pm not found/could not be loaded!
	Line 25927: [Thu Mar  6 07:44:12 2014][Error][Kernel::System::CustomerUser::new][100] Can't load backend module Kernel::System::CustomerUser::DB! 
	Line 25987: [Thu Mar  6 08:37:44 2014][Error][Kernel::System::Main::FileRead][371] Can't open 'C:/otrs/OTRS/Kernel/Output/HTML/xxx/AgentDashboardTicketGeneric.dtl': Bad file descriptor
	Line 25988: [Thu Mar  6 08:37:44 2014][Error][Kernel::Output::HTML::Layout::Output][553] Can't read C:/otrs/OTRS/Kernel/Output/HTML/xxx/AgentDashboardTicketGeneric.dtl: Inappropriate I/O control operation
	Line 25989: [Thu Mar  6 08:37:44 2014][Error][Kernel::Modules::AgentDashboardCommon::Run][434] Can't get element data of 0130-TicketOpen!
	Line 26028: [Thu Mar  6 09:09:20 2014][Error][[b]Kernel::System::Main::FileWrite[/b]][485] Can't write 'C:/otrs/OTRS/var/sessions/State-42KNwdV9VmZ4UXtI3YNIuwZx3QbkBuMYcA': Bad file descriptor
	Line 26068: [Thu Mar  6 09:21:42 2014][Error][Kernel::System::Web::InterfaceAgent::Run][734] Module Kernel::Modules::AgentDashboard not registered in Kernel/Config.pm!
	Line 26147: [Thu Mar  6 10:30:18 2014][Error][Kernel::System::Main::FileWrite][485] Can't write 'C:/otrs/OTRS/var/sessions/State-42RtiC7zhG7ohPlkkBI7Qhs6Z6AK1sYCUx': Bad file descriptor
	Line 26213: [Thu Mar  6 11:39:38 2014][Error][Kernel::System::Main::FileWrite][485] Can't write 'C:/otrs/OTRS/var/tmp/CacheFileStorable/Dashboard/3/6/36d0846e40e445a21d47896f5b5836bb': Bad file descriptor

Permissions have been unchanged and re-checked and are ok. These files exist on OS level.

Also in the Perl error logs I find those errors all over the place:

Code: Select all

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/03/05 15:12:20
Precompiler: Execute Error:
	Filename:[C:\otrs\OTRS\bin\cgi-bin\index.pl]
	Package:[PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl]
Params[]
[b]Can't connect to dc2: IO::Socket::INET: Bad file descriptor[/b] at C:/otrs/OTRS/bin/cgi-bin/../../Kernel/System/CustomerUser/LDAP.pm line 173.
...
ERROR: OTRS-CGI-42 Perl: 5.16.3 OS: MSWin32 Time: Thu Mar  6 08:37:44 2014
 Message: Can't read C:/otrs/OTRS/Kernel/Output/HTML/xxx/AgentDashboardTicketGeneric.dtl: [b]Inappropriate I/O control operation[/b]
 RemoteAddress: 172.16.1.214
 RequestURI: /otrs/index.pl
 Traceback (2624): 
   Module: Kernel::Output::HTML::Layout::Output (OTRS 3.3.5) Line: 553
   Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (OTRS 3.3.5) Line: 1530
   Module: Kernel::Modules::AgentDashboardCommon::_Element (OTRS 3.3.5) Line: 830
   Module: Kernel::Modules::AgentDashboardCommon::Run (OTRS 3.3.5) Line: 423
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.3.5) Line: 871
   Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41
   Module: (eval) (unknown version) Line: 458
   Module: PerlEx::Precompiler::Execute (unknown version) Line: 458
ERROR: OTRS-CGI-42 Perl: 5.16.3 OS: MSWin32 Time: Thu Mar  6 08:37:44 2014
...
*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/03/06 09:11:13
recompiler: Script C:\otrs\OTRS\bin\cgi-bin\[b]index.pl does not exist[/b], returning -1 at line 286

*** 'C:\otrs\OTRS\bin\cgi-bin\index.pl' log message at: 2014/03/06 10:31:03
ERROR: OTRS-CGI-42 Perl: 5.16.3 OS: MSWin32 Time: Thu Mar  6 10:30:18 2014
 Message: [b]Can't write[/b] 'C:/otrs/OTRS/var/sessions/State-42RtiC7zhG7ohPlkkBI7Qhs6Z6AK1sYCUx': [b]Bad file descriptor[/b]

This is really screwing us up and we get a lot of web application errors.
The system has been double checkd for viruses online and offline, Virus Scanners disabled.
The errors are reproducable on another windows system too.

On our test system I rolled back to v3.3.4 and those erros seem to be gone.

Here my desperate questions:
Did something change in 3.3.5 concerning the Loader mechanism?
Did 3.3.5 introduce new perl lib files which have not been tested on windows or maybe are incompatible (Kernel/cpan-lib)?
What difference between 3.3.4 and 3.3.5 might possibly cause such behavior?

Thanks for some feedback
N.Rieker

[crythias]

some of the errors say permission denied so you might want to check if "Everyone" has permission to the tmp folder and below.

[alf12]

Yes, good guess. But permissions haven't changed and I gave Everybody Full access to make sure.
The system is also working most of the time but then failing with I/O.

Permissions are fine.

[alf12]

Also I get read errors below Kernel/
Chkdsk is fine and same on other system. Something is fishy with 3.3.5...

[crythias]

I'm not sure I'll be of much help, then. I'm in linux land.

[alf12]

Yes, me too. I have been forced to use Windows
Maybe somebody else can help me...

Thanks anyway.

[jbaker]

Ok this just started happening to me. If you have not solved it then you need to add the IIS_IUSRS to the tmp folder and give them full access.
If you used a different user for the IIS access then you will need to give that user full access adding everyone does not work and is a security risk.

[diginin]

Hast du Views igrendwo eingebunden? Es scheint ein ziemliches BUG mit ODBC an dieser Stelle zu geben. Auch wenn du window benutzen muss, kannst du vielleicht auf MySQL. Mit das OTRS Free Feature CloneDB, geht es mittlerweile sehr einfach und Bequeme. Für ein kleinerer Installation, gibt es auch das OTRS Appliance.

Ich schlage vor, du entfernst alle eigenen Konfigurationen und arbeitest die alle neu durch. Falls, wenn entfernt, das Problem verschwindet.

Note: Hier empfiehlt sich OTRS Free. Es lässt sich auch ohne Installer "fast" bequeme installieren.