RC2 upgrade fails @ upgrading log system

[beemer]

Nearly there then I get the following error on upgrading log system on my test system.

I tried increasing thread_stack to no avail?

Code Select Expand


Upgrading log system... Unsuccessful!
This query:

    UPDATE smf_log_boards
    SET ID_MSG = IF(logTime BETWEEN 1126859922 AND 1126859921, 3500, IF(logTime <= 1126860006, 3501, IF(logTime <= 1126860097, 3502, IF(logTime <= 1126860161, 3503, IF(logTime <= 1126860411, 3504, IF(logTime <= 1126860419, 3505, IF(logTime <= 1126860449, 3506, IF(logTime <= 1126860475, 3507, IF(logTime <= 1126860758, 3508, IF(logTime <= 1126861105, 3509, IF(logTime <= 1126861210, 3510, IF(logTime <= 1126861268, 3511, IF(logTime <= 1126861476, 3512, IF(logTime <= 1126861896, 3513, IF(logTime <= 1126863043, 3515, IF(logTime <= 1126863565, 3516, IF(logTime <= 1126863902, 3517, IF(logTime <= 1126864047, 3518, IF(logTime <= 1126864321, 3519, IF(logTime <= 1126866045, 3520, IF(logTime <= 1126866143, 3521, IF(logTime <= 1126866318, 3522, IF(logTime <= 1126867732, 3523, IF(logTime <= 1126867774, 3524, IF(logTime <= 1126868001, 3525, IF(logTime <= 1126868244, 3526, IF(logTime <= 1126870604, 3527, IF(logTime <= 1126870715, 3528, IF(logTime <= 1126873745, 3529, IF(logTime <= 1126873898, 3530, IF(logTime <= 1126875248, 3532, IF(logTime <= 1126876665, 3533, IF(logTime <= 1126880684, 3534, IF(logTime <= 1126880776, 3535, IF(logTime <= 1126881032, 3536, IF(logTime <= 1126881201, 3537, IF(logTime <= 1126881346, 3538, IF(logTime <= 1126883365, 3540, IF(logTime <= 1126883592, 3541, IF(logTime <= 1126883746, 3543, IF(logTime <= 1126885104, 3544, IF(logTime <= 1126885400, 3545, IF(logTime <= 1126885653, 3546, IF(logTime <= 1126886843, 3549, IF(logTime <= 1126887394, 3552, IF(logTime <= 1126888049, 3553, IF(logTime <= 1126888365, 3554, IF(logTime <= 1126888549, 3555, IF(logTime <= 1126888988, 3556, IF(logTime <= 1126889241, 3557, IF(logTime <= 1126889470, 3558, IF(logTime <= 1126890383, 3559, IF(logTime <= 1126890581, 3560, IF(logTime <= 1126891936, 3562, IF(logTime <= 1126896420, 3563, IF(logTime <= 1126896915, 3564, IF(logTime <= 1126900421, 3565, IF(logTime <= 1126900433, 3566, IF(logTime <= 1126902544, 3569, IF(logTime <= 1126902830, 3570, IF(logTime <= 1126902939, 3571, IF(logTime <= 1126903177, 3572, IF(logTime <= 1126904031, 3575, IF(logTime <= 1126907556, 3578, IF(logTime <= 1126908612, 3580, IF(logTime <= 1126908697, 3581, IF(logTime <= 1126955053, 3582, IF(logTime <= 1126962704, 3584, IF(logTime <= 1126963703, 3585, IF(logTime <= 1126964128, 3586, IF(logTime <= 1126964407, 3587, IF(logTime <= 1126964554, 3588, IF(logTime <= 1126966686, 3589, IF(logTime <= 1126967871, 3590, IF(logTime <= 1126969535, 3591, IF(logTime <= 1126970476, 3592, IF(logTime <= 1126990673, 3593, IF(logTime <= 1127005318, 3594, IF(logTime <= 1127022448, 3595, IF(logTime <= 1127025771, 3596, IF(logTime <= 1127027920, 3597, IF(logTime <= 1127028010, 3598, IF(logTime <= 1127032324, 3599, IF(logTime <= 1127037627, 3601, IF(logTime <= 1127039038, 3602, IF(logTime <= 1127040100, 3603, IF(logTime <= 1127040515, 3604, IF(logTime <= 1127043919, 3605, IF(logTime <= 1127049694, 3606, IF(logTime <= 1127050296, 3607, IF(logTime <= 1127057530, 3608, IF(logTime <= 1127065965, 3610, IF(logTime <= 1127066012, 3611, IF(logTime <= 1127068033, 3612, IF(logTime <= 1127068979, 3613, IF(logTime <= 1127069101, 3614, IF(logTime <= 1127070329, 3615, IF(logTime <= 1127070330, 3616, IF(logTime <= 1127070439, 3617, IF(logTime <= 1127070504, 3618, IF(logTime <= 1127071347, 3619, IF(logTime <= 1127072373, 3620, IF(logTime <= 1127072898, 3621, IF(logTime <= 1127074867, 3622, IF(logTime <= 1127075175, 3623, IF(logTime <= 1127075465, 3625, IF(logTime <= 1127075639, 3626, IF(logTime <= 1127076097, 3627, IF(logTime <= 1127076471, 3628, IF(logTime <= 1127076629, 3629, IF(logTime <= 1127076899, 3630, IF(logTime <= 1127077076, 3631, IF(logTime <= 1127077261, 3632, IF(logTime <= 1127078977, 3634, IF(logTime <= 1127083019, 3635, IF(logTime <= 1127087589, 3636, IF(logTime <= 1127103821, 3637, IF(logTime <= 1127112937, 3638, IF(logTime <= 1127115526, 3639, IF(logTime <= 1127116691, 3640, IF(logTime <= 1127116959, 3641, IF(logTime <= 1127117760, 3642, IF(logTime <= 1127118104, 3643, IF(logTime <= 1127119112, 3644, IF(logTime <= 1127119549, 3645, IF(logTime <= 1127119708, 3646, IF(logTime <= 1127120822, 3647, IF(logTime <= 1127121521, 3648, IF(logTime <= 1127129275, 3649, IF(logTime <= 1127129378, 3650, IF(logTime <= 1127130412, 3651, IF(logTime <= 1127133523, 3652, IF(logTime <= 1127133794, 3653, IF(logTime <= 1127137717, 3654, IF(logTime <= 1127138179, 3655, IF(logTime <= 1127138488, 3656, IF(logTime <= 1127142441, 3657, IF(logTime <= 1127142977, 3658, IF(logTime <= 1127143739, 3659, IF(logTime <= 1127148666, 3660, IF(logTime <= 1127151551, 3661, IF(logTime <= 1127153363, 3663, IF(logTime <= 1127153568, 3664, IF(logTime <= 1127153809, 3665, IF(logTime <= 1127156248, 3668, IF(logTime <= 1127156590, 3669, IF(logTime <= 1127157096, 3670, IF(logTime <= 1127157585, 3671, IF(logTime <= 1127157918, 3672, IF(logTime <= 1127159006, 3673, IF(logTime <= 1127159054, 3674, IF(logTime <= 1127163179, 3675, IF(logTime <= 1127164073, 3676, IF(logTime <= 1127165182, 3677, IF(logTime <= 1127167417, 3678, IF(logTime <= 1127168278, 3679, IF(logTime <= 1127168303, 3680, IF(logTime <= 1127168421, 3681, IF(logTime <= 1127168513, 3682, IF(logTime <= 1127168601, 3683, IF(logTime <= 1127168914, 3684, IF(logTime <= 1127187519, 3685, IF(logTime <= 1127202352, 3686, IF(logTime <= 1127202538, 3687, IF(logTime <= 1127202541, 3688, IF(logTime <= 1127202588, 3689, IF(logTime <= 1127202678, 3690, IF(logTime <= 1127203101, 3691, IF(logTime <= 1127203259, 3692, IF(logTime <= 1127205006, 3693, IF(logTime <= 1127205286, 3695, IF(logTime <= 1127211821, 3697, IF(logTime <= 1127211905, 3698, IF(logTime <= 1127212260, 3699, IF(logTime <= 1127214556, 3700, IF(logTime <= 1127216957, 3701, IF(logTime <= 1127217163, 3702, IF(logTime <= 1127217356, 3703, IF(logTime <= 1127217510, 3704, IF(logTime <= 1127222517, 3705, IF(logTime <= 1127223415, 3706, IF(logTime <= 1127224967, 3707, IF(logTime <= 1127225991, 3708, IF(logTime <= 1127226866, 3709, IF(logTime <= 1127230181, 3710, IF(logTime <= 1127230454, 3711, IF(logTime <= 1127231164, 3712, IF(logTime <= 1127231258, 3713, IF(logTime <= 1127232862, 3714, IF(logTime <= 1127234010, 3715, IF(logTime <= 1127234402, 3716, IF(logTime <= 1127234541, 3717, IF(logTime <= 1127234655, 3718, IF(logTime <= 1127234721, 3719, IF(logTime <= 1127234924, 3720, IF(logTime <= 1127235270, 3721, IF(logTime <= 1127236729, 3722, IF(logTime <= 1127236887, 3723, IF(logTime <= 1127238881, 3726, IF(logTime <= 1127239435, 3728, IF(logTime <= 1127240859, 3729, IF(logTime <= 1127243936, 3731, IF(logTime <= 1127244542, 3732, IF(logTime <= 1127245161, 3733, IF(logTime <= 1127245290, 3734, IF(logTime <= 1127247394, 3735, IF(logTime <= 1127247612, 3736, IF(logTime <= 1127247727, 3737, IF(logTime <= 1127248518, 3738, IF(logTime <= 1127251152, 3739, IF(logTime <= 1127251484, 3740, IF(logTime <= 1127251761, 3741, IF(logTime <= 1127254238, 3742, IF(logTime <= 1127264162, 3744, IF(logTime <= 1127287223, 3745, IF(logTime <= 1127288358, 3746, IF(logTime <= 1127289363, 3747, IF(logTime <= 1127289641, 3748, IF(logTime <= 1127290756, 3749, IF(logTime <= 1127292367, 3750, IF(logTime <= 1127292564, 3751, IF(logTime <= 1127294636, 3752, IF(logTime <= 1127294946, 3753, IF(logTime <= 1127295282, 3754, IF(logTime <= 1127295980, 3755, IF(logTime <= 1127296406, 3756, IF(logTime <= 1127297510, 3757, IF(logTime <= 1127298517, 3758, IF(logTime <= 1127302849, 3759, IF(logTime <= 1127303221, 3760, IF(logTime <= 1127305032, 3761, IF(logTime <= 1127309213, 3762, IF(logTime <= 1127309600, 3763, IF(logTime <= 1127310302, 3764, IF(logTime <= 1127313735, 3766, IF(logTime <= 1127313855, 3767, IF(logTime <= 1127317277, 3770, IF(logTime <= 1127318671, 3771, IF(logTime <= 1127319747, 3772, IF(logTime <= 1127319929, 3773, IF(logTime <= 1127320142, 3774, IF(logTime <= 1127320812, 3775, IF(logTime <= 1127321264, 3778, IF(logTime <= 1127321444, 3780, IF(logTime <= 1127321481, 3781, IF(logTime <= 1127321563, 3782, IF(logTime <= 1127321876, 3783, IF(logTime <= 1127324664, 3784, IF(logTime <= 1127328067, 3785, IF(logTime <= 1127329095, 3786, IF(logTime <= 1127329140, 3787, IF(logTime <= 1127329226, 3788, IF(logTime <= 1127331917, 3789, IF(logTime <= 1127333208, 3790, IF(logTime <= 1127333243, 3791, IF(logTime <= 1127333452, 3792, IF(logTime <= 1127333923, 3793, IF(logTime <= 1127334387, 3795, IF(logTime <= 1127334524, 3796, IF(logTime <= 1127334748, 3797, IF(logTime <= 1127334973, 3798, IF(logTime <= 1127335685, 3800, IF(logTime <= 1127336407, 3802, IF(logTime <= 1127338030, 3803, IF(logTime <= 1127338126, 3804, IF(logTime <= 1127348163, 3807, IF(logTime <= 1127348330, 3808, IF(logTime <= 1127367653, 3809, IF(logTime <= 1127374922, 3810, IF(logTime <= 1127375500, 3811, IF(logTime <= 1127383220, 3812, IF(logTime <= 1127383362, 3813, IF(logTime <= 1127390214, 3814, IF(logTime <= 1127395525, 3815, IF(logTime <= 1127399714, 3816, IF(logTime <= 1127401407, 3817, IF(logTime <= 1127403979, 3818, IF(logTime <= 1127403982, 3819, IF(logTime <= 1127404700, 3820, IF(logTime <= 1127405147, 3821, IF(logTime <= 1127405692, 3822, IF(logTime <= 1127408585, 3823, IF(logTime <= 1127412399, 3824, IF(logTime <= 1127416135, 3825, IF(logTime <= 1127416247, 3826, IF(logTime <= 1127416396, 3827, IF(logTime <= 1127416528, 3828, IF(logTime <= 1127416906, 3829, IF(logTime <= 1127419785, 3830, IF(logTime <= 1127420916, 3831, IF(logTime <= 1127421956, 3832, IF(logTime <= 1127422174, 3833, IF(logTime <= 1127423121, 3834, IF(logTime <= 1127423259, 3835, IF(logTime <= 1127423295, 3836, IF(logTime <= 1127423454, 3837, IF(logTime <= 1127425499, 3838, IF(logTime <= 1127426540, 3839, IF(logTime <= 1127426829, 3840, IF(logTime <= 1127427337, 3842, IF(logTime <= 1127467905, 3846, IF(logTime <= 1127468987, 3847, IF(logTime <= 1127469109, 3848, IF(logTime <= 1127469171, 3849, IF(logTime <= 1127476462, 3851, IF(logTime <= 1127481110, 3852, IF(logTime <= 1127484088, 3853, IF(logTime <= 1127484338, 3854, IF(logTime <= 1127486814, 3855, IF(logTime <= 1127487905, 3856, IF(logTime <= 1127489619, 3857, IF(logTime <= 1127490490, 3858, IF(logTime <= 1127491097, 3859, IF(logTime <= 1127491388, 3860, IF(logTime <= 1127491503, 3861, IF(logTime <= 1127491754, 3862, IF(logTime <= 1127492439, 3863, IF(logTime <= 1127492590, 3864, IF(logTime <= 1127492924, 3865, IF(logTime <= 1127493823, 3866, IF(logTime <= 1127494119, 3868, IF(logTime <= 1127494172, 3869, IF(logTime <= 1127494264, 3871, IF(logTime <= 1127494607, 3872, IF(logTime <= 1127494656, 3873, IF(logTime <= 1127494961, 3874, IF(logTime <= 1127497698, 3875, IF(logTime <= 1127497770, 3876, IF(logTime <= 1127499689, 3877, IF(logTime <= 1127503745, 3878, IF(logTime <= 1127504207, 3879, IF(logTime <= 1127504428, 3880, IF(logTime <= 1127509776, 3881, IF(logTime <= 1127512744, 3882, IF(logTime <= 1127514318, 3883, IF(logTime <= 1127517943, 3886, IF(logTime <= 1127518349, 3887, IF(logTime <= 1127518487, 3888, IF(logTime <= 1127518492, 3889, IF(logTime <= 1127519673, 3891, IF(logTime <= 1127520318, 3893, IF(logTime <= 1127541911, 3894, IF(logTime <= 1127542054, 3895, IF(logTime <= 1127544082, 3897, IF(logTime <= 1127545618, 3898, IF(logTime <= 1127546268, 3899, IF(logTime <= 1127552529, 3900, IF(logTime <= 1127558066, 3901, IF(logTime <= 1127560121, 3902, IF(logTime <= 1127562183, 3903, IF(logTime <= 1127565296, 3904, IF(logTime <= 1127565978, 3906, IF(logTime <= 1127568281, 3907, IF(logTime <= 1127571436, 3908, IF(logTime <= 1127573278, 3911, IF(logTime <= 1127574462, 3915, IF(logTime <= 1127575547, 3916, IF(logTime <= 1127576774, 3917, IF(logTime <= 1127590945, 3918, IF(logTime <= 1127594791, 3920, IF(logTime <= 1127596049, 3921, IF(logTime <= 1127596483, 3922, IF(logTime <= 1127596717, 3923, IF(logTime <= 1127596797, 3924, IF(logTime <= 1127597175, 3925, IF(logTime <= 1127597838, 3926, IF(logTime <= 1127598357, 3927, IF(logTime <= 1127605682, 3928, IF(logTime <= 1127613204, 3929, IF(logTime <= 1127613538, 3930, IF(logTime <= 1127637013, 3931, IF(logTime <= 1127639100, 3932, IF(logTime <= 1127639612, 3933, IF(logTime <= 1127639825, 3934, IF(logTime <= 1127646184, 3935, IF(logTime <= 1127647351, 3936, IF(logTime <= 1127665535, 3937, IF(logTime <= 1127675262, 3939, IF(logTime <= 1127676856, 3940, IF(logTime <= 1127680889, 3941, IF(logTime <= 1127681714, 3942, IF(logTime <= 1127682175, 3943, IF(logTime <= 1127722777, 3946, IF(logTime <= 1127723491, 3947, IF(logTime <= 1127724937, 3948, IF(logTime <= 1127739329, 3949, IF(logTime <= 1127741551, 3950, IF(logTime <= 1127742386, 3951, IF(logTime <= 1127743295, 3952, IF(logTime <= 1127743967, 3953, IF(logTime <= 1127744039, 3954, IF(logTime <= 1127747853, 3955, IF(logTime <= 1127752363, 3956, IF(logTime <= 1127753610, 3957, IF(logTime <= 1127754418, 3958, IF(logTime <= 1127754840, 3959, IF(logTime <= 1127755424, 3960, IF(logTime <= 1127755581, 3961, IF(logTime <= 1127755708, 3962, IF(logTime <= 1127756981, 3965, IF(logTime <= 1127764102, 3966, IF(logTime <= 1127768982, 3967, IF(logTime <= 1127769106, 3968, IF(logTime <= 1127769182, 3969, IF(logTime <= 1127773047, 3970, IF(logTime <= 1127773418, 3971, IF(logTime <= 1127807494, 3974, IF(logTime <= 1127811898, 3975, IF(logTime <= 1127823609, 3976, IF(logTime <= 1127824699, 3977, IF(logTime <= 1127828350, 3978, IF(logTime <= 1127839783, 3979, IF(logTime <= 1127840209, 3980, IF(logTime <= 1127841598, 3982, IF(logTime <= 1127843225, 3983, IF(logTime <= 1127845810, 3984, IF(logTime <= 1127851304, 3985, IF(logTime <= 1127851442, 3986, IF(logTime <= 1127852993, 3987, IF(logTime <= 1127853563, 3988, IF(logTime <= 1127859324, 3989, IF(logTime <= 1127859344, 3990, IF(logTime <= 1127859472, 3991, IF(logTime <= 1127859761, 3992, IF(logTime <= 1127860244, 3993, IF(logTime <= 1127860857, 3994, IF(logTime <= 1127861087, 3995, IF(logTime <= 1127861285, 3996, IF(logTime <= 1127861509, 3997, IF(logTime <= 1127861519, 3998, IF(logTime <= 1127861975, 3999, IF(logTime <= 1127863639, 4000, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
    WHERE logTime BETWEEN 1126859922 AND 1127863640
    AND ID_MSG = 0;

Caused the error:

    Thread stack overrun: 123068 bytes used of a 131072 byte stack, and 8192 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.



[Grudge]

Oh dear. Edit upgrade_1-1.sql and find:

Code Select Expand


$request = upgrade_query("
SELECT MAX(ID_MSG) AS ID_MSG, posterTime
FROM {$db_prefix}messages
WHERE ID_MSG BETWEEN $_GET[m] AND " . ($_GET['m'] + 500) . "
GROUP BY posterTime
ORDER BY posterTime
LIMIT 500");


Code Select Expand


$_GET['m'] += 500;


Change all 500's for something smaller until it works.

[beemer]

Oh Dear ?

Thx Grudge 300 worked for me 

[Grudge]

I hope it all worked OK. I realised that you needed to change three instances of 500 (Post edited for future people). IF worst came to worst some of your unread information isn't quite right - please run a board repair and check!

[beemer]

Well it all completed ok, and initially looks OK

But this is only a local install test 

And RC2 looks mighty fine - thx to all involved with SMF

[Spikeh]

I encountered this error and altered all instances of 500 to 300 and the installation went without a hitch.

Thanks.

[djpubba]

I got the error going from 1.0.5 to 1.1 RC1 and changing it to +- 500 worked for me.

[BGonaSTICK]

Just had the same problem. The '300' fix worked for me too. Any reason why this hasn't been changed in the released upgrade_1-1.sql?

Very frustrating.

I wonder how many people have gone through this pain? Spoiled an otherwise excellent upgrade process.

[franklinrony]

thanks vry usefull