[Spce-user] error 500 internal error on we portal
Daniel Grotti
dgrotti at sipwise.com
Mon Jan 18 10:57:44 EST 2016
cool.
*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 04:51 PM, gerry kernan wrote:
> Hi Daniel
>
> Got it sorted , added 10Gb to /tmp and panel is working for this subscriber now.
>
>
> 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 15:22
> 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,
> mybe some mysql 'guru' can help you here.
>
>
>
> *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 04:21 PM, gerry kernan wrote:
>> Hi
>> I've increased the /tmp filesystem by 1 Gb but still getting this error. Is there anything else I can do.
>>
>>
>> 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