[Spce-user] 500 Internal Server Error after uploading a .wave file

Sun Nov 4 14:11:54 EST 2018

Hello again 😊

MariaDB [(none)]> select id,from_unixtime(origtime),length(recording) from kamailio.voicemail_spool where dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';

+----+-------------------------+-------------------+

| id | from_unixtime(origtime) | length(recording) |

+----+-------------------------+-------------------+

| 86 | 2018-10-10 19:43:27     |              3506 |

| 87 | 2018-10-10 19:44:54     |              3506 |

+----+-------------------------+-------------------+

2 rows in set (0.00 sec)

MariaDB [(none)]>

MariaDB [(none)]> delete from kamailio.voicemail_spool where id=87;

Query OK, 1 row affected (0.01 sec)

MariaDB [(none)]>

MariaDB [(none)]> select id,from_unixtime(origtime),length(recording) from kamailio.voicemail_spool where dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';

+----+-------------------------+-------------------+

| id | from_unixtime(origtime) | length(recording) |

+----+-------------------------+-------------------+

| 86 | 2018-10-10 19:43:27     |              3506 |

+----+-------------------------+-------------------+

1 row in set (0.00 sec)

MariaDB [(none)]>

Von: Irina Peshinskaya <ipeshinskaya at sipwise.com> 
Gesendet: Sonntag, 4. November 2018 20:01
An: Hohl Matthias <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com
Betreff: Re: AW: AW: [Spce-user] 500 Internal Server Error after uploading a .wave file

Dear Matthias,

The last line is the reason of of the 500 response code. Normally, there shouldn't be two "unavail" or "busy" records for one user. Panel use proper call for data creation, but seems like some error occurred in the library that Panel use during recording creation.

Could you please inspect your data further with query:

select id,from_unixtime(origtime),length(recording) from kamailio.voicemail_spool where dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';

You will see data like this:
+----+-------------------------+-------------------+
| id | from_unixtime(origtime) | length(recording) |
+----+-------------------------+-------------------+
|  5 | 2018-11-04 09:45:12     |              3636 |
|  9 | 2018-11-04 09:45:12     |                 0 |
+----+-------------------------+-------------------+

If you can point wrong record, kindly remove it with proper query:

delete from kamailio.voicemail_spool where id=INCORRECT_RECORD_ID;

INCORRECT_RECORD_ID should be replaced with value from the "id" column.

Best regards,
Irina Peshinskaya

On 2018-11-04 19:23, Hohl Matthias wrote:

Hello,

this is the result:

MariaDB [(none)]> select `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as cnt from kamailio.voicemail_spool group by dir having cnt>1;

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

| dir                                                                                | mailboxcontext | mailboxuser                          | msgnum | origtime   | cnt |

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

| /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/INBOX   | default        | 15d95e8d-38a9-4e1f-9504-f3808d265081 |      0 | 1527060205 |  17 |

| /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/Old     | default        | 15d95e8d-38a9-4e1f-9504-f3808d265081 |      0 | 1522754696 |   3 |

| /var/spool/asterisk/voicemail/default/522f1f30-5317-46ee-a4ef-0f3b8fbbe52f/INBOX   | default        | 522f1f30-5317-46ee-a4ef-0f3b8fbbe52f |      0 | 1515516247 |  28 |

| /var/spool/asterisk/voicemail/default/56850236-a35d-40ec-9448-276004b63da2/INBOX   | default        | 56850236-a35d-40ec-9448-276004b63da2 |      0 | 1478708840 |  11 |

| /var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail | default        | e893a9ab-28a3-48a0-8d5a-faebb297d286 |     -1 | 1539193407 |   2 |

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

5 rows in set (0.02 sec)

MariaDB [(none)]>

Von: Irina Peshinskaya  <mailto:ipeshinskaya at sipwise.com> <ipeshinskaya at sipwise.com> 
Gesendet: Sonntag, 4. November 2018 10:29
An: Hohl Matthias  <mailto:matthias.hohl at telematica.at> <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> 
Betreff: Re: AW: [Spce-user] 500 Internal Server Error after uploading a .wave file

Dear Matthias,

Could you please check if you have duplicates in voicemal_spool table:

select `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as cnt from kamailio.voicemail_spool group by dir having cnt>1;

Thank you in advance.

Best regards,
Irina Peshinskaya

On 2018-10-16 10:08, Hohl Matthias wrote:

Hello,

i sent it to you private :)

thank you for your help.

Von: Irina Peshinskaya  <mailto:ipeshinskaya at sipwise.com> <ipeshinskaya at sipwise.com> 
Gesendet: Montag, 15. Oktober 2018 11:21
An: Hohl Matthias  <mailto:matthias.hohl at telematica.at> <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> 
Betreff: Re: [Spce-user] 500 Internal Server Error after uploading a .wave file

Dear Matthias,

Could you please send me your log files from dates, related to the situation
"The upload started but failed and next the customer saw a 500 Internal Server Error screen"

Necessary log files you can find as:

/var/log/ngcp/old/panel.log-2018*.gz
/var/log/ngcp/old/panel-debug.log-2018*.gz
/var/log/ngcp/old/api.log-2018*.gz

Thank you in advance.

Best regards,
Irina Peshinskaya

On 2018-10-11 11:06, Hohl Matthias wrote:

Hello,

Server: mr5.5.5

One of our customers wanted to upload a .wave file for the voicebox over his customer care panel.

The upload started but failed and next the customer saw a 500 Internal Server Error screen.

The customer report this issue to us and we also get now a 500 Internal Server Error if we want to open the subscriber preferences page.

It is the only subscriber witch has this Error by accessing the prefences page. All other once work fine.

In the panel.log and panel-debug.log I see this entries:

1.       Oct 11 10:57:24 spce ngcp-panel: ERROR: fatal error, id=155C821F96E17CC0, timestamp=2018-10-11T08:57:24.840824000Z, error=Caught exception in NGCP::Panel::Controller::Subscriber->preferences "Not a HASH reference at /usr/share/perl5/NGCP/Panel/Controller/Subscriber.pm line 651."

2.        

3.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: *** Root::auto grant access for authenticated user

4.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: NGCP::Panel::Controller::Subscriber::auto

5.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: catchup contract 324 contract_balances (now = 2018-10-11 10:57:24)

Anybody an idea what is going on there and how to fix it?

Mit freundlichen Grüßen,

Matthias Hohl

_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com> 
https://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181104/7a104e91/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5532 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181104/7a104e91/attachment-0001.p7s>