[Spce-user] error 500 internal error on we portal

gerry kernan gerry.kernan at infinityit.ie
Mon Jan 18 05:48:01 EST 2016


We have 285M free in /tmp


root at sipwise:~# df -h
Filesystem              Size  Used Avail Use% Mounted on
rootfs                  3.9G  709M  3.0G  19% /
udev                     10M     0   10M   0% /dev
tmpfs                   784M   48M  737M   7% /run
/dev/mapper/sip02-root  3.9G  709M  3.0G  19% /
tmpfs                   5.0M     0  5.0M   0% /run/lock
tmpfs                   1.6G     0  1.6G   0% /run/shm
/dev/sda1               229M   55M  162M  26% /boot
/dev/mapper/sip02-home   79G   28G   47G  38% /home
/dev/mapper/sip02-tmp   360M   80M  258M  24% /tmp
/dev/mapper/sip02-usr   8.2G  1.3G  6.5G  17% /usr
/dev/mapper/sip02-var   4.9G  4.0G  683M  86% /var

Gerry Kernan
 


Infinity IT   |   17 The Mall   |   Beacon Court   |   Sandyford   |   Dublin D18 E3C8   |   Ireland
Tel:  +353 - (0)1 - 293 0090   |   E-Mail:  gerry.kernan at infinityit.ie

Managed IT Services       Infinity IT - www.infinityit.ie
IP Telephony                    Asterisk Consulting - www.asteriskconsulting.com
Contact Centre                Total Interact - www.totalinteract.com


-----Original Message-----
From: Daniel Grotti [mailto:dgrotti at sipwise.com] 
Sent: Monday 18 January 2016 10:46
To: gerry kernan <gerry.kernan at infinityit.ie>; spce-user at lists.sipwise.com
Subject: Re: [Spce-user] error 500 internal error on we portal

Hi,
looks like a problem in that table:

DBD::mysql::st execute failed: Incorrect key file for table '/tmp/#sql_f0b_0.MYI'; try to repair it



Sometimes when this error happens with temp tables:

#126 - Incorrect key file for table '/tmp/#sql_64d_0.MYI'; try to repair it


It can be because the /tmp folder is running out of space. On some Linux installations, /tmp is in its own partition and does not have much space
- big MySQL queries will fill it up.

You can use df -h to check whether \tmp is in its own partition, and how much space is allocated to it.


*Daniel Grotti *
VoIP Engineer

Sipwise GmbH <http://www.sipwise.com> , Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Phone:  +43(0)1 301 2032 <callto:+4313012032>
Email:  dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
Website:  www.sipwise.com <http://www.sipwise.com>

Particulars according Austrian Companies Code paragraph 14 "Sipwise GmbH" - Europaring F15 - 2345 Brunn am Gebirge FN:305595f, Commercial Court Vienna, ATU64002206

On 01/18/2016 11:27 AM, gerry kernan wrote:
> Hi Daniel
>
> Output of the grep below.
>
> /var/log/ngcp/panel.log:Jan 18 10:10:48 sipwise ngcp-panel: ERROR: 
> fatal error, id=142A7D86E37D0FC0, 
> timestamp=2016-01-18T10:10:48.076120000Z, 
> error=DBIx::Class::ResultSet::all(): DBI Exception: DBD::mysql::st 
> execute failed: Incorrect key file for table '/tmp/#sql_f0b_0.MYI'; 
> try to repair it [for Statement "SELECT `me`.`id`, `me`.`update_time`, 
> `me`.`source_user_id`, `me`.`source_provider_id`, 
> `me`.`source_external_subscriber_id`, 
> `me`.`source_external_contract_id`, `me`.`source_account_id`, 
> `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`, 
> `me`.`source_clir`, `me`.`source_ip`, `me`.`source_gpp0`, 
> `me`.`source_gpp1`, `me`.`source_gpp2`, `me`.`source_gpp3`, 
> `me`.`source_gpp4`, `me`.`source_gpp5`, `me`.`source_gpp6`, 
> `me`.`source_gpp7`, `me`.`source_gpp8`, `me`.`source_gpp9`, 
> `me`.`destination_user_id`, `me`.`destination_provider_id`, 
> `me`.`destination_external_subscriber_id`, 
> `me`.`destination_external_contract_id`, 
> `me`.`destination_account_id`, `me`.`destination_user`, 
> `me`.`destination_domain`, `me`.`destination_user_dialed`, 
> `me`.`destination_user_in`, `me`.`destination_domain_in`, 
> `me`.`destination_gpp0`, `me`.`destination_gpp1`, 
> `me`.`destination_gpp2`, `me`.`destination_gpp3`, 
> `me`.`destination_gpp4`, `me`.`destination_gpp5`, 
> `me`.`destination_gpp6`, `me`.`destination_gpp7`, 
> `me`.`destination_gpp8`, `me`.`destination_gpp9`, 
> `me`.`peer_auth_user`, `me`.`peer_auth_realm`, `me`.`call_type`, 
> `me`.`call_status`, `me`.`call_code`, `me`.`duration`, `me`.`call_id`, 
> `me`.`source_carrier_cost`, `me`.`source_reseller_cost`, 
> `me`.`source_customer_cost`, `me`.`source_carrier_free_time`, 
> `me`.`source_reseller_free_time`, `me`.`source_customer_free_time`, 
> `me`.`source_carrier_billing_fee_id`, 
> `me`.`source_reseller_billing_fee_id`, 
> `me`.`source_customer_billing_fee_id`, 
> `me`.`source_carrier_billing_zone_id`, 
> `me`.`source_reseller_billing_zone_id`, 
> `me`.`source_customer_billing_zone_id`, 
> `me`.`destination_carrier_cost`, `me`.`destination_reseller_cost`, 
> `me`.`destination_customer_cost`, 
> `me`.`destination_carrier_free_time`, 
> `me`.`destination_reseller_free_time`, 
> `me`.`destination_customer_free_time`, 
> `me`.`destination_carrier_billing_fee_id`, 
> `me`.`destination_reseller_billing_fee_id`, 
> `me`.`destination_customer_billing_fee_id`, 
> `me`.`destination_carrier_billing_zone_id`, 
> `me`.`destination_reseller_billing_zone_id`, 
> `me`.`destination_customer_billing_zone_id`, 
> `me`.`frag_carrier_onpeak`, `me`.`frag_reseller_onpeak`, 
> `me`.`frag_customer_onpeak`, `me`.`is_fragmented`, `me`.`split`, 
> `me`.`rated_at`, `me`.`rating_status`, `me`.`exported_at`, 
> `me`.`export_status`, `me`.`init_time`, `me`.`start_time` FROM (SELECT 
> `me`.`id`, `me`.`update_time`, `me`.`source_user_id`, 
> `me`.`source_provider_id`, `me`.`source_external_subscriber_id`, 
> `me`.`source_external_contract_id`, `me`.`source_account_id`, 
> `me`.`source_user`, `me`.`source_domain`, `me`.`source_cli`, 
> `me`.`source_clir`, `me`.`source_ip`, `me`.`source_gpp0`, 
> `me`.`source_gpp1`, `me`.`source_gpp2`, `me`.`source_gpp3`, 
> `me`.`source_gpp4`, `me`.`source_gpp5`, `me`.`source_gpp6`, 
> `me`.`source_gpp7`, `me`.`source_gpp8`, `me`.`source_gpp9`, 
> `me`.`destination_user_id`, `me`.`destination_provider_id`, 
> `me`.`destination_external_subscriber_id`, 
> `me`.`destination_external_contract_id`, 
> `me`.`destination_account_id`, `me`.`destination_user`, 
> `me`.`destination_domain`, `me`.`destination_user_dialed`, 
> `me`.`destination_user_in`, `me`.`destination_domain_in`, 
> `me`.`destination_gpp0`, `me`.`destination_gpp1`, 
> `me`.`destination_gpp2`, `me`.`destination_gpp3`, 
> `me`.`destination_gpp4`, `me`.`destination_gpp5`, 
> `me`.`destination_gpp6`, `me`.`destination_gpp7`, 
> `me`.`destination_gpp8`, `me`.`destination_gpp9`, 
> `me`.`peer_auth_user`, `me`.`peer_auth_realm`, `me`.`call_type`, 
> `me`.`call_status`, `me`.`call_code`, `me`.`duration`, `me`.`call_id`, 
> `me`.`source_carrier_cost`, `me`.`source_reseller_cost`, 
> `me`.`source_customer_cost`, `me`.`source_carrier_free_time`, 
> `me`.`source_reseller_free_time`, `me`.`source_customer_free_time`, 
> `me`.`source_carrier_billing_fee_id`, 
> `me`.`source_reseller_billing_fee_id`, `me`.`source_custom
>
> Gerry Kernan
>  
>
>
> Infinity IT   |   17 The Mall   |   Beacon Court   |   Sandyford   |   Dublin D18 E3C8   |   Ireland
> Tel:  +353 - (0)1 - 293 0090   |   E-Mail:  gerry.kernan at infinityit.ie
>
> Managed IT Services       Infinity IT - www.infinityit.ie
> IP Telephony                    Asterisk Consulting - www.asteriskconsulting.com
> Contact Centre                Total Interact - www.totalinteract.com
>
>
> -----Original Message-----
> From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf 
> Of Daniel Grotti
> Sent: Monday 18 January 2016 10:17
> To: spce-user at lists.sipwise.com
> Subject: Re: [Spce-user] error 500 internal error on we portal
>
> Hi Gerry,
> can you grep "142A7D86E37D0FC0" in /var/log/ngcp/panel.log and /var/log/ngcp/panel-debug.log ?
>
>
> *Daniel Grotti *
> VoIP Engineer
>
> Sipwise GmbH <http://www.sipwise.com> , Campus 21/Europaring F15
> AT-2345 Brunn am Gebirge
>
> Phone:  +43(0)1 301 2032 <callto:+4313012032>
> Email:  dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
> Website:  www.sipwise.com <http://www.sipwise.com>
>
> Particulars according Austrian Companies Code paragraph 14 "Sipwise 
> GmbH" - Europaring F15 - 2345 Brunn am Gebirge FN:305595f, Commercial 
> Court Vienna, ATU64002206
>
> On 01/18/2016 11:14 AM, gerry kernan wrote:
>> Hi
>>
>> I´m getting the error below when one subscriber logs in to the web 
>> portal other subscribers are ok.
>>
>>  
>>
>> 500 Internal server error
>>
>> We are terribly sorry, an exceptional error has occured:
>>
>> incident number: 142A7D86E37D0FC0
>>
>> time of incident: 2016-01-18T10:10:48.076120000Z
>>
>>  
>>
>>  
>>
>>  
>>
>> *Gerry Kernan*
>>
>>  
>>
>> cid:image001.jpg at 01D105A5.2701B0E0
>>
>>  
>>
>> *Infinity IT   |   17 The Mall   |   Beacon Court   |   Sandyford  
>> |   Dublin D18 E3C8   |   Ireland*
>>
>> *Tel:  +353 - (0)1 - 293 0090   |   E-Mail: 
>> *gerry.kernan at infinityit.ie <mailto:gerry.kernan at infinityit.ie>**
>>
>> * *
>>
>> *Managed IT Services_       _Infinity IT*- www.infinityit.ie
>> <http://www.infinityit.ie/>
>>
>> *IP Telephony_                    _Asterisk Consulting*-
>> www.asteriskconsulting.com <http://www.asteriskconsulting.com>
>>
>> *Contact Centre_                _Total Interact*-
>> www.totalinteract.com <http://www.totalinteract.com>
>>
>>  
>>
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>






More information about the Spce-user mailing list