Reply to thread

Message

Hi,

It took me a while to find this, so I thought I'd share.

I had MP setup and powerscheduler working fine. PC would suspend OK and wake up to record.

But then I had problems with a RAID card locking up the system and crashing it.

It turns out that the crashes had caused corruption in the MpTvDb database.

The corruption prevented powersheduler from suspending the machine (even though it thought it was successful). Pressing Sleep on my keyboard was seemingly ignored (except for log entries showing that powersheduler had tried to suspend). Strangely if I stopped TVservice my computer would immediately suspend.

I only found the solution because I got the following error message and decided to investigate.

[CODE]2011-01-20 23:33:26.656645 [Powerscheduler Timer(9)]: Powerscheduler: Exception in OnTimerElapsed(): The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.
[/CODE]

Note that initially when I had the problem this did not show - I must not have corrupted this table yet. In either case using mysql to repair the table fixed it. I was getting this error though. Perhaps it was an indicator...

[CODE]2011-01-20 20:27:39.075000 [PowerEventThread(8)]: TV service PowerEventThread: Exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at TvService.TVController.get_CanSuspend()
   at TvService.Service1.OnPowerEventHandler(PowerEventType powerStatus)
   at TvService.Service1.OnPowerEvent(PowerEventType powerStatus)
   at TvService.Service1.PowerEventThreadWndProc(IntPtr hWnd, UInt32 msg, IntPtr wParam, IntPtr lParam)
   at TvService.Service1.GetMessageA(MSG& msg, IntPtr hWnd, Int32 uMsgFilterMin, Int32 uMsgFilterMax)
   at TvService.Service1.PowerEventThread()[/CODE]

Going to MySql Workbench and trying to run a query resulted in the attached error showing..
[CODE]
Error Code: 145
Table '.\mptvdb\program' is marked as crashed and should be repaired.[/CODE]

This was a pretty good tip that there was database corruption. A bit of googling and playing later lead to me running the following command which fixed the tables. After that NO PROBLEM! FIXED! I pressed suspend and it worked straight away.

Regards,
Feizex.

[CODE]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck --database MpTvDb -r --au
to-repair --user root --password
Enter password: ***********
mptvdb.canceledschedule OK
mptvdb.card OK
mptvdb.cardgroup    OK
mptvdb.cardgroupmap OK
mptvdb.channel    OK
mptvdb.channelgroup OK
mptvdb.channellinkagemap    OK
mptvdb.channelmap OK
mptvdb.conflict OK
mptvdb.diseqcmotor    OK
mptvdb.favorite OK
mptvdb.groupmap OK
mptvdb.history    OK
mptvdb.keyword    OK
mptvdb.keywordmap OK
mptvdb.personaltvguidemap OK
mptvdb.program
warning : Number of rows changed from 5898 to 5857
status   : OK
mptvdb.radiochannelgroup    OK
mptvdb.radiogroupmap    OK
mptvdb.recording
warning : Number of rows changed from 23 to 22
status   : OK
mptvdb.satellite    OK
mptvdb.schedule OK
mptvdb.server OK
mptvdb.setting    OK
mptvdb.timespan OK
mptvdb.tuningdetail OK
mptvdb.tvmoviemapping OK
mptvdb.version    OK[/CODE]

<blockquote data-quote="feizex" data-source="post: 705605" data-attributes="member: 96644">Hi,It took me a while to find this, so I thought I'd share.I had MP setup and powerscheduler working fine. PC would suspend OK and wake up to record.But then I had problems with a RAID card locking up the system and crashing it.It turns out that the crashes had caused corruption in the MpTvDb database.The corruption prevented powersheduler from suspending the machine (even though it thought it was successful). Pressing Sleep on my keyboard was seemingly ignored (except for log entries showing that powersheduler had tried to suspend). Strangely if I stopped TVservice my computer would immediately suspend.I only found the solution because I got the following error message and decided to investigate. [CODE]2011-01-20 23:33:26.656645 [Powerscheduler Timer(9)]: Powerscheduler: Exception in OnTimerElapsed(): The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.[/CODE]Note that initially when I had the problem this did not show - I must not have corrupted this table yet. In either case using mysql to repair the table fixed it. I was getting this error though. Perhaps it was an indicator...[CODE]2011-01-20 20:27:39.075000 [PowerEventThread(8)]: TV service PowerEventThread: Exception: System.NullReferenceException: Object reference not set to an instance of an object.&nbsp;&nbsp; at TvService.TVController.get_CanSuspend()&nbsp;&nbsp; at TvService.Service1.OnPowerEventHandler(PowerEventType powerStatus)&nbsp;&nbsp; at TvService.Service1.OnPowerEvent(PowerEventType powerStatus)&nbsp;&nbsp; at TvService.Service1.PowerEventThreadWndProc(IntPtr hWnd, UInt32 msg, IntPtr wParam, IntPtr lParam)&nbsp;&nbsp; at TvService.Service1.GetMessageA(MSG&amp; msg, IntPtr hWnd, Int32 uMsgFilterMin, Int32 uMsgFilterMax)&nbsp;&nbsp; at TvService.Service1.PowerEventThread()[/CODE]Going to MySql Workbench and trying to run a query resulted in the attached error showing..[CODE]Error Code: 145Table '.\mptvdb\program' is marked as crashed and should be repaired.[/CODE]This was a pretty good tip that there was database corruption. A bit of googling and playing later lead to me running the following command which fixed the tables. After that NO PROBLEM! FIXED! I pressed suspend and it worked straight away. Regards,Feizex. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />[CODE]C:\Program Files\MySQL\MySQL Server 5.1\bin&gt;mysqlcheck --database MpTvDb -r --auto-repair --user root --passwordEnter password: ***********mptvdb.canceledschedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.card&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.cardgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.cardgroupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.channel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.channelgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.channellinkagemap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.channelmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.conflict&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.diseqcmotor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.favorite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.groupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.history&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.keyword&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.keywordmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.personaltvguidemap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.programwarning&nbsp; : Number of rows changed from 5898 to 5857status&nbsp;&nbsp; : OKmptvdb.radiochannelgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.radiogroupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.recordingwarning&nbsp; : Number of rows changed from 23 to 22status&nbsp;&nbsp; : OKmptvdb.satellite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.server&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.setting&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.timespan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.tuningdetail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.tvmoviemapping&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OK[/CODE]</blockquote>

[QUOTE="feizex, post: 705605, member: 96644"] Hi, It took me a while to find this, so I thought I'd share. I had MP setup and powerscheduler working fine. PC would suspend OK and wake up to record. But then I had problems with a RAID card locking up the system and crashing it. It turns out that the crashes had caused corruption in the MpTvDb database. The corruption prevented powersheduler from suspending the machine (even though it thought it was successful). Pressing Sleep on my keyboard was seemingly ignored (except for log entries showing that powersheduler had tried to suspend). Strangely if I stopped TVservice my computer would immediately suspend. I only found the solution because I got the following error message and decided to investigate. [CODE]2011-01-20 23:33:26.656645 [Powerscheduler Timer(9)]: Powerscheduler: Exception in OnTimerElapsed(): The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist. [/CODE] Note that initially when I had the problem this did not show - I must not have corrupted this table yet. In either case using mysql to repair the table fixed it. I was getting this error though. Perhaps it was an indicator... [CODE]2011-01-20 20:27:39.075000 [PowerEventThread(8)]: TV service PowerEventThread: Exception: System.NullReferenceException: Object reference not set to an instance of an object. at TvService.TVController.get_CanSuspend() at TvService.Service1.OnPowerEventHandler(PowerEventType powerStatus) at TvService.Service1.OnPowerEvent(PowerEventType powerStatus) at TvService.Service1.PowerEventThreadWndProc(IntPtr hWnd, UInt32 msg, IntPtr wParam, IntPtr lParam) at TvService.Service1.GetMessageA(MSG& msg, IntPtr hWnd, Int32 uMsgFilterMin, Int32 uMsgFilterMax) at TvService.Service1.PowerEventThread()[/CODE] Going to MySql Workbench and trying to run a query resulted in the attached error showing.. [CODE] Error Code: 145 Table '.\mptvdb\program' is marked as crashed and should be repaired.[/CODE] This was a pretty good tip that there was database corruption. A bit of googling and playing later lead to me running the following command which fixed the tables. After that NO PROBLEM! FIXED! I pressed suspend and it worked straight away. Regards, Feizex. :D [CODE]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck --database MpTvDb -r --au to-repair --user root --password Enter password: *********** mptvdb.canceledschedule OK mptvdb.card OK mptvdb.cardgroup OK mptvdb.cardgroupmap OK mptvdb.channel OK mptvdb.channelgroup OK mptvdb.channellinkagemap OK mptvdb.channelmap OK mptvdb.conflict OK mptvdb.diseqcmotor OK mptvdb.favorite OK mptvdb.groupmap OK mptvdb.history OK mptvdb.keyword OK mptvdb.keywordmap OK mptvdb.personaltvguidemap OK mptvdb.program warning : Number of rows changed from 5898 to 5857 status : OK mptvdb.radiochannelgroup OK mptvdb.radiogroupmap OK mptvdb.recording warning : Number of rows changed from 23 to 22 status : OK mptvdb.satellite OK mptvdb.schedule OK mptvdb.server OK mptvdb.setting OK mptvdb.timespan OK mptvdb.tuningdetail OK mptvdb.tvmoviemapping OK mptvdb.version OK[/CODE] [/QUOTE]