Thread Stack Error

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Running the php script as cacti user in scripts directory
2.
3.

What is the expected output? What do you see instead?

Should see returned data, get thread stack error instead.

 AS binary_log_space ': Thread stack overrun:  120304 bytes used of a
131072 byte stack, and 10788 bytes needed.  Use 'mysqld -O thread_stack=#' 

I've used the older mysql templates with no issues, and fairly sure this is
not a cacti issue, used for a lot of other stuff.

What version of the product are you using? On what operating system?

Debian etch, mysql 5.0 patched to etch security level. Cacti Version 0.8.7a

Please provide any additional information below.

Imported no errors, set the script up with necessary user information,
cacti itself is running fine, including the previous mysql templates the
software is based on.

Original issue reported on code.google.com by matt.t...@gmail.com on 30 Apr 2008 at 12:25

[GoogleCodeExporter]

Please connect to your MySQL server as the Cacti user, and issue the following 
command:

SHOW BINARY LOGS

Does that cause an error?

Original comment by baron.schwartz on 30 Apr 2008 at 12:27

[GoogleCodeExporter]

Ah wait, I was misreading it.  The issue is not the SHOW BINARY LOGS command.

Can you get the text of the SQL the script is trying to run that's causing the 
error?

Original comment by baron.schwartz on 30 Apr 2008 at 12:32

[GoogleCodeExporter]

The code that generates it seems to be this section.

   if (true) {
      $sql = "SELECT "
           . "CONCAT('', " . implode('+', $binlogs) . ") AS xbinary_log_space ";
      # echo("$sql\n");
      $result = run_query($sql, $conn);
      while ( $row = @mysql_fetch_assoc($result) ) {
         foreach ( $row as $key => $val ) {
            $status[$key] = $val;
         }
      }
   }

Here's the entire error message, is kind of large.

Error executing 'SELECT CONCAT('',
0+1147761+566293+3179+504809+272+324+538+695+117+1349034+1436271+4864452+226031+
117+509306+272+538+695+117+1253177+1384901+1234183+1219688+1363042+874883+614885
+3773832+1192261+547236+714014+829795+1167265+1491262+1310643+1202007+3829962+11
69431+1222779+1290268+1235067+1339942+1156778+3740037+1152721+1176589+1164668+11
72964+1271461+1156325+6579401+1158331+1166698+1140011+1151589+1160202+1179520+37
53786+1189646+1255183+1218173+7489992+1265307+1144805+4225510+1900107+117+510697
+272+538+695+117+665611+2050241+1720805+1632462+1243373+1270951+3913208+3097556+
3162025+5402156+1175596+1168785+4656112+14916718+3698234+2481122+6800404+3167418
+3075721+3348074+7472958+38787852+5251568+2147079+3243869+2104577+9213798+476572
9+4151565+2861177+3974732+2064910+5746018+2777949+5812325+11810425+3450030+55346
59+4947049+6498635+10203616+9914944+4005994+4221549+15330433+17994837+16449676+9
706141+10623030+5539827+4270917+5403683+7575578+1722930+7525187+6895021+6203976+
5279272+5368690+6765143+5658015+117+510697+272+538+695+117+31959+2349755+4188263
+3903596+5693327+4599866+7458863+5020271+7116162+5197418+1681828+117+510697+272+
538+695+117+2239227+8271617+38353411+11654374+138195+22382455+24675127+14628425+
13990001+6694425+12783821+13680082+1093199+10432744+12913578+6932190+11286251+51
09796+6323621+7652401+3898256+11600044+8759552+9302043+7185841+8378239+12800897+
6215543+7453318+6729722+5703350+2031492+11216017+9372087+11517397+6838630+761258
2+7364819+7317690+8774966+10164868+9189861+11402292+7835827+7341850+10017206+126
84902+11908219+9865813+5879311+9539117+8643575+8261218+7416222+9689275+12959892+
10884136+7350345+6025725+7782957+11347747+529659+10781386+7780957+5058140+751717
7+5179894+5484659+5887338+5194780+7509395+4387511+7405273+6933279+12634862+32560
920+25981538+18883808+18817840+10337163+9127110+20505852+16696064+22402617+36249
000+17320126+12448694+20046028+14761304+13950926+13398085+16653575+11674663+1432
1515+17632728+10712630+7630371+6124860+12532474+6062755+10366003+10838378+116436
74+9875385+8860951+8971250+4981812+7865059+6296168+5573596+4442157+7847108+71399
73+6118754+11096554+11070780+9490216+7486838+13369579+11055204+9176712+4809928+2
8278+3399961+3128563+6736395+5278209+7017633+5465432+6470296+2660127+13927+67749
60+9892432+6882626+5565623+9829642+5878568+8131493+11696041+8832784+9132243+8885
015+6298481+6720621+11785340+6826417+8337075+9141599+9632681+5773527+7465700+862
8589+7953878+6311004+8524216+8433793+5857885+4870820+9907854+11286818+7633213+48
82821+4596014+5301853+9273030+8515345+4611548+7868205+13303829+6419055+16677431+
7963346+16045858+12652185+5189633+8821882+6547079+4964216+9063656+7936406+527079
9+8784913+9727450+7108077+5971291+11336479+6610459+6003102+8656892+5862051+77225
39+9309441+6852490+9103916+7014188+7262685+6910373+6345907+6285206+4094848+11631
236+13111368+9267272+9499379+6293449+5789228+5558810+9118733+7915479+6292427+998
6897+7900574+5769470+6511171+11822014+8538578+7937797+6788677+7898011+10914726+1
0090006+12691049+10278060+7326156+8512432+6867222+9249209+12029613+15602980+1740
0378+7376834+10526651+6761472+12555317+6737093+12896154+8625219+7490135+6652084+
2717820+8504828+8049395+459820+6080392+7183936+9570395+13564630+7306473+7610890+
7112125+9954096+13251942+8215471+10229490+13938073+6439507+8522549+9670686+94665
94+8369139+9036658+6837746+10353952+14810863+9120444+568192+117+510697+272+538+6
95+117+9077984+8134867+10062464+7863645+11283481+9796600+4824155+8109221+5597384
+8446743+15088532+14462872+5424345+9868629+10978639+8524026+6964102+10210086+675
9908+9693180+8501891+4575416+6320337+11408505+7645300+6650723+9118389+7165492+71
67766+8846360+5133681+2563238+36941243+104859791+104859705+104858340+104103671+1
04868987+3512575+8761049+7282312+4841782+117+510697+272+538+695+117+4978347+9590
765+12975958+9236573+12645964+9412566+14756220+13774216+6051628+6702596+8880992+
9504770+11854601+12803786+7934619+9063743+8643072+9604974+5974910+11285717+73582
79+8122904+7809087+7632826+2656202+117+510697+272+538+695+117+3076004+13901282+8
931744+8240553+2055927+6258481+11460699+20278173+19385408+24316856+17962579+1763
8920+34388883+18811499+18462788+20759732+25228669+18485187+21087038+48162339+307
59963+26419973+24758744+29835936+20682844+29093311+33599705+24505096+23108190+20
302675+21687609+22373065+24858005+28629168+24007072+35449925+22526320+25594804+2
9436883+22074678+29260615+2975242+109922+14605067+27372543+22711789+20365501+256
15711+21285037+25391638+29375308+27398533+27909156+34092243+30048719+39286360+37
522890+39989447+41268888+42904622+45653283+48099523+46035481+58222267+52661914+5
2603849+57572882+52281397+56662908+59110535+62393838+65587860+72553559+59131774+
83621115+63339859+55277041+62625065+64293593+69894040+63249746+61821390+62739730
+65290026+61644061+68278062+75086285+68508483+64524060+72676109+67728814+7201200
7+80199104+86604+28582294+44269311)
AS xbinary_log_space ': Thread stack overrun:  120304 bytes used of a 131072 
byte
stack, and 10788 bytes needed.  Use 'mysqld -O thread_stack=#' to specify a 
bigger stack.

Original comment by matt.t...@gmail.com on 30 Apr 2008 at 12:46

[GoogleCodeExporter]

On another comment's recommendation on the blog (sorry, posted there before 
coming
here) I commented out the sections concerning replication, masters, and the if 
(true)
section.  That eliminated the thread error, and seems to be returning data as 
expected.

But when I run poller, it's still failing to update the RRD's.

an excerpt.

04/29/2008 07:40:10 PM - POLLER: Poller[0] Parsed MULTI output field
‘rows_deleted:5066′ [map rows_deleted->rows_deleted]
04/29/2008 07:40:10 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update
/var/www/cacti/rra/mysql_server_rows_deleted_52.rrd –template 1209516001:U
ERROR: Not enough arguments

seems to be handling the multi output parser fine, but failing when it passes it
through to the rrdtool.  This happens on every data source.

Original comment by matt.t...@gmail.com on 30 Apr 2008 at 12:49

[GoogleCodeExporter]

Matt, maybe you need to purge some binary logs?

Original comment by baron.schwartz on 30 Apr 2008 at 3:52

[GoogleCodeExporter]

Did a master reset to clear the logs, that allowed the script to process 
without the
thread stack error.  Still not getting any data in the RRD - always shows up as 
U as
above paste.

Original comment by matt.t...@gmail.com on 1 May 2008 at 12:49

[GoogleCodeExporter]

Matt, would you mind looking around the Cacti forums and/or trying to post 
there to
see if you can find a solution?  My guess is it's not about this set of
templates/scripts -- it may be something with your particular Cacti version. 
However, if it's something we can find a workaround for, I'm committed to 
making that
happen.  Even if it means we have to customize the template/script for many 
different
versions of Cacti, or even release different versions of the scripts/templates, 
I
want people to come here and find something that will Just Work for them.  If 
you can
debug what's going on, that would be a huge help!

Original comment by baron.schwartz on 1 May 2008 at 12:53

[GoogleCodeExporter]

Matt, I'm pretty sure the U error is a more general problem, and not related to 
the
thread stack, so I'm going to close this issue.  If you find a separate issue, 
please
open a new report.

Original comment by baron.schwartz on 7 May 2008 at 12:20

• Changed state: WontFix