Comment 14 for bug 982421

Can somebody else confirme that this is working ? (As I don't have this bug
to test with)

On Sun, Jun 3, 2012 at 8:09 AM, Michael Collard <email address hidden>wrote:

> I've put together a patch for ME-TV which should resolve (workaround)
> this SQLite issue on EXT4 with barrier options. Note, it requires
> SQLite3.7 or above.
>
> Note, I'm not any form of professional C/C++ programmer. I got the idea
> from elsewhere and SQLite documentation. Take it or leave it, but the
> patch is working rather well for me :)
>
> ** Patch added: "me-tv-sqlite-fix.patch"
>
> https://bugs.launchpad.net/me-tv/+bug/982421/+attachment/3173772/+files/me-tv-sqlite-fix.patch
>
> --
> You received this bug notification because you are subscribed to Me TV.
> https://bugs.launchpad.net/bugs/982421
>
> Title:
> "epg_event row replaced for id" is causing high usage of harddrive
>
> Status in Me TV, it's TV for me computer:
> Opinion
>
> Bug description:
> Precise Pangolin
> updates from April 15
> Me-TV 1.4.0.9
>
> While me-tv-server is working with epg row replacing, me-tv-client is
> not responding to mouse clicks and harddisk has high usage. I have
> encrypted whole home folder if it helps.
>
> Log from me-tv-server verbose option, watch the time:
> 2012-04-15 18:01:02: epg_event row replaced for id 4042
> 2012-04-15 18:01:02: epg_event row replaced for id 4043
> 2012-04-15 18:01:02: epg_event row replaced for id 4044
> 2012-04-15 18:01:02: epg_event row replaced for id 4045
> 2012-04-15 18:01:02: epg_event row replaced for id 4046
> 2012-04-15 18:01:02: epg_event row replaced for id 4047
> 2012-04-15 18:01:02: epg_event row replaced for id 4048
> 2012-04-15 18:01:02: epg_event row replaced for id 4049
> 2012-04-15 18:01:02: epg_event row replaced for id 4050
> 2012-04-15 18:01:03: epg_event row replaced for id 4051
> 2012-04-15 18:01:03: epg_event row replaced for id 4052
> 2012-04-15 18:01:03: epg_event row replaced for id 4053
> 2012-04-15 18:01:03: epg_event row replaced for id 4054
> 2012-04-15 18:01:03: epg_event row replaced for id 4055
> 2012-04-15 18:01:03: epg_event row replaced for id 4056
> 2012-04-15 18:01:03: epg_event row replaced for id 4057
> 2012-04-15 18:01:03: epg_event row replaced for id 4058
> 2012-04-15 18:01:04: epg_event row replaced for id 4059
> 2012-04-15 18:01:04: epg_event row replaced for id 4060
> 2012-04-15 18:01:04: epg_event row replaced for id 4061
> 2012-04-15 18:01:04: epg_event row replaced for id 4062
> 2012-04-15 18:01:04: epg_event row replaced for id 4063
> 2012-04-15 18:01:04: epg_event row replaced for id 4064
> 2012-04-15 18:01:04: epg_event row replaced for id 4065
> 2012-04-15 18:01:04: epg_event row replaced for id 4066
> 2012-04-15 18:01:04: epg_event row replaced for id 4067
> 2012-04-15 18:01:05: epg_event row replaced for id 4068
> 2012-04-15 18:01:05: epg_event row replaced for id 4069
> 2012-04-15 18:01:05: epg_event row replaced for id 4070
> 2012-04-15 18:01:05: epg_event row replaced for id 4071
> 2012-04-15 18:01:05: epg_event row replaced for id 4072
> 2012-04-15 18:01:05: epg_event row replaced for id 4073
> 2012-04-15 18:01:05: epg_event row replaced for id 4074
> 2012-04-15 18:01:05: epg_event row replaced for id 4075
> 2012-04-15 18:01:06: epg_event row replaced for id 4076
> 2012-04-15 18:01:06: epg_event row replaced for id 4077
> 2012-04-15 18:01:06: epg_event row replaced for id 4078
> 2012-04-15 18:01:06: epg_event row replaced for id 4079
> 2012-04-15 18:01:06: epg_event row replaced for id 4080
> 2012-04-15 18:01:06: epg_event row replaced for id 4081
> 2012-04-15 18:01:06: epg_event row replaced for id 4082
> 2012-04-15 18:01:06: epg_event row replaced for id 4083
> 2012-04-15 18:01:06: epg_event row replaced for id 4084
> 2012-04-15 18:01:07: epg_event row replaced for id 4085
> 2012-04-15 18:01:07: epg_event row replaced for id 4086
> 2012-04-15 18:01:07: epg_event row replaced for id 4087
> 2012-04-15 18:01:07: epg_event row replaced for id 4088
> 2012-04-15 18:01:07: epg_event row replaced for id 4089
> 2012-04-15 18:01:07: epg_event row replaced for id 4090
> 2012-04-15 18:01:07: epg_event row replaced for id 4091
> 2012-04-15 18:01:07: epg_event row replaced for id 4092
> 2012-04-15 18:01:08: epg_event row replaced for id 4093
> 2012-04-15 18:01:08: epg_event row replaced for id 4094
> 2012-04-15 18:01:08: epg_event row replaced for id 4095
> 2012-04-15 18:01:08: epg_event row replaced for id 4096
> 2012-04-15 18:01:08: epg_event row replaced for id 4097
> 2012-04-15 18:01:08: epg_event row replaced for id 4098
> 2012-04-15 18:01:08: epg_event row replaced for id 4099
> 2012-04-15 18:01:08: epg_event row replaced for id 4100
> 2012-04-15 18:01:08: epg_event row replaced for id 4101
> 2012-04-15 18:01:09: epg_event row replaced for id 4102
> 2012-04-15 18:01:09: epg_event row replaced for id 4103
> 2012-04-15 18:01:09: epg_event row replaced for id 4104
> 2012-04-15 18:01:09: epg_event row replaced for id 4105
> 2012-04-15 18:01:09: epg_event row replaced for id 4106
> 2012-04-15 18:01:09: epg_event row replaced for id 4107
> 2012-04-15 18:01:09: epg_event row replaced for id 4108
> 2012-04-15 18:01:09: epg_event row replaced for id 4109
> 2012-04-15 18:01:10: epg_event row replaced for id 4110
> 2012-04-15 18:01:10: epg_event row replaced for id 4111
> 2012-04-15 18:01:10: epg_event row replaced for id 4112
> 2012-04-15 18:01:10: epg_event row replaced for id 4113
> 2012-04-15 18:01:10: epg_event row replaced for id 4114
> 2012-04-15 18:01:10: epg_event row replaced for id 4115
> 2012-04-15 18:01:10: epg_event row replaced for id 4116
> 2012-04-15 18:01:10: epg_event row replaced for id 4117
> 2012-04-15 18:01:11: epg_event row replaced for id 4118
> 2012-04-15 18:01:11: epg_event row replaced for id 4119
> 2012-04-15 18:01:11: epg_event row replaced for id 4120
> 2012-04-15 18:01:11: epg_event row replaced for id 4121
> 2012-04-15 18:01:11: epg_event row replaced for id 4122
> 2012-04-15 18:01:11: epg_event row replaced for id 4123
> 2012-04-15 18:01:11: epg_event row replaced for id 4124
> 2012-04-15 18:01:11: epg_event row replaced for id 4125
> 2012-04-15 18:01:12: epg_event row replaced for id 4126
> 2012-04-15 18:01:12: epg_event row replaced for id 4127
> 2012-04-15 18:01:12: epg_event row replaced for id 4128
> 2012-04-15 18:01:12: epg_event row replaced for id 4129
> 2012-04-15 18:01:12: epg_event row replaced for id 4130
> 2012-04-15 18:01:12: epg_event row replaced for id 4131
> 2012-04-15 18:01:12: epg_event row replaced for id 4132
> 2012-04-15 18:01:12: epg_event row replaced for id 4133
> 2012-04-15 18:01:13: epg_event row replaced for id 4134
> 2012-04-15 18:01:13: epg_event row replaced for id 4135
> 2012-04-15 18:01:13: epg_event row replaced for id 4136
> 2012-04-15 18:01:13: epg_event row replaced for id 4137
> 2012-04-15 18:01:13: epg_event row replaced for id 4138
> 2012-04-15 18:01:13: epg_event row replaced for id 4139
> 2012-04-15 18:01:13: epg_event row replaced for id 4140
> 2012-04-15 18:01:13: epg_event row replaced for id 4141
> 2012-04-15 18:01:14: epg_event row replaced for id 4142
> 2012-04-15 18:01:14: epg_event row replaced for id 4143
> 2012-04-15 18:01:14: epg_event row replaced for id 4144
> 2012-04-15 18:01:14: epg_event row replaced for id 4145
> 2012-04-15 18:01:14: epg_event row replaced for id 4146
> 2012-04-15 18:01:14: epg_event row replaced for id 4147
> 2012-04-15 18:01:14: epg_event row replaced for id 4148
> 2012-04-15 18:01:14: epg_event row replaced for id 4149
> 2012-04-15 18:01:14: epg_event row replaced for id 4150
> 2012-04-15 18:01:15: epg_event row replaced for id 4151
> 2012-04-15 18:01:15: epg_event row replaced for id 4152
> 2012-04-15 18:01:15: epg_event row replaced for id 4153
> 2012-04-15 18:01:15: epg_event row replaced for id 4154
> 2012-04-15 18:01:15: epg_event row replaced for id 4155
> 2012-04-15 18:01:15: epg_event row replaced for id 4156
> 2012-04-15 18:01:15: epg_event row replaced for id 4157
> 2012-04-15 18:01:15: epg_event row replaced for id 4158
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/me-tv/+bug/982421/+subscriptions
>

--
"In a world without walls, who really needs Windows"
"Nothing is foolproof because fools are so ingenious"