Author Topic: Database Errors  (Read 304 times)

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 84
    • PHAZE FM
Database Errors
« on: January 11, 2019, 02:15:44 PM »
Hey Folks,

Can someone point me in the right direction to fix this issue, i have checked permissions and its not that so it has to be something from when i dumped the database and moved it to another server and re-imported it.

Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(8398,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]David Guetta[[:>:]]';UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Sia[[:>:]]';)
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

stinga

  • Full Member

  • Online
  • ***
  • 218
    • CoastFM
Re: Database Errors
« Reply #1 on: January 11, 2019, 07:00:08 PM »
Can you put the code in a quote block please.
What DB and version are you using?
Have you tried running the updates manually?
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 84
    • PHAZE FM
Re: Database Errors
« Reply #2 on: January 12, 2019, 12:12:26 AM »
Hey,

The issue is the error keeps changing but it resolves all around "Database Insert Error: Illegal argument to a regular expression. "

What tipped me off to this is there is gaps in the audio, loike RDJ freezes and becomes unresponsive and then will continue. All of our tracks have been manually edited re cross fades etc (for the most part)

This seems to be only music tracks, every other file is fine.

Here is the latest error from this minutes ago

Code: [Select]
Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(9087,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Maroon 5[[:>:]]';)
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

OnePlayRadio

  • Jr. Member

  • Offline
  • **
  • 98
    • One Play Radio
Re: Database Errors
« Reply #3 on: January 12, 2019, 04:13:20 AM »
hello, we too have had and continue to present this error in the database:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

like you, all the songs have been edited in the cue points manually, but every so often we have generated this error. This last one corresponds to the 6th of January of this year.

regrads.
One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5347
    • Radio DJ Romania
Re: Database Errors
« Reply #4 on: January 12, 2019, 08:38:04 AM »
Which version of RadioDJ?
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 84
    • PHAZE FM
Re: Database Errors
« Reply #5 on: January 12, 2019, 06:56:33 PM »
PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

Your error is your file server / database server is out of system memory or the swap is full. Is your database server linux or Windows?

Which version of RadioDJ?

Hi Marius - 2.0.0.6, Windows 10 Pro x64 Netframework 4.5 (Patched), As you know we have made several adjustments to the database to get our now playing script to work properly with it, however it has been working flawlessly until we had to upgrade from CentOS6 to CentOS 7. I am presuming mysql was upgraded as well
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

OnePlayRadio

  • Jr. Member

  • Offline
  • **
  • 98
    • One Play Radio
Re: Database Errors
« Reply #6 on: January 12, 2019, 09:45:22 PM »
Which version of RadioDJ?

in my case is radiodj 2.0.0.1 on an inter i5-3470 equipment of 2,90 GHz and 8 GB of RAM with windows 7 professional and mariadb database of 64bits.
One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

stinga

  • Full Member

  • Online
  • ***
  • 218
    • CoastFM
Re: Database Errors
« Reply #7 on: January 13, 2019, 10:56:04 AM »
One thing I note is that there a 3 [[[.
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

stinga

  • Full Member

  • Online
  • ***
  • 218
    • CoastFM
Re: Database Errors
« Reply #8 on: January 14, 2019, 05:51:31 PM »
This error would seem to be a DB error of some description and not a rdj error.
Have a look at the database logs, also have a look at the windows event logs.
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

OnePlayRadio

  • Jr. Member

  • Offline
  • **
  • 98
    • One Play Radio
Re: Database Errors
« Reply #9 on: January 15, 2019, 02:28:42 AM »
This error would seem to be a DB error of some description and not a rdj error.
Have a look at the database logs, also have a look at the windows event logs.

is correct, the error is database and not radiodj, but affects the operation of rdj. We know the effect, but not the cause, in windows events (in my case) I have several errors but the one shown directly as database is:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'.  (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

I have investigated before because it is not the first time that it happens to me, but I have not been able to find a solution. Some time ago Marius recommended me to use MariaDB and that's what I did, but I still have this kind of events from time to time.

One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

stinga

  • Full Member

  • Online
  • ***
  • 218
    • CoastFM
Re: Database Errors
« Reply #10 on: January 16, 2019, 12:23:18 AM »
So, you should look at the sql logs and see if that sheds any light.
I am still suspicious of the '[[[' but I have not tested it.
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

stinga

  • Full Member

  • Online
  • ***
  • 218
    • CoastFM
Re: Database Errors
« Reply #11 on: January 16, 2019, 12:24:41 AM »
I tested it and got
Code: [Select]
nostromo Tue Jan 15 23:22:34 2019 [radiodjtest]: UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]';
ERROR 1139 (42000): Got error 'unknown POSIX class name at offset 4' from regexp
nostromo Tue Jan 15 23:22:44 2019 [radiodjtest]: UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Evanescence[[:>:]]';
Query OK, 0 rows affected (0.10 sec)
Rows matched: 0  Changed: 0  Warnings: 0
So the '[[[' is possibly invalid, where did it come from?
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 84
    • PHAZE FM
Re: Database Errors
« Reply #12 on: January 16, 2019, 03:09:41 AM »
Guys,

I have said form the start that my issue is with the database, however i am not sure what the error is exactly and how to fix it. I have tried to run a database check from MYSQL and all tables are reporting that they are fine.

I dont want to just overwrite the database as there is some customization for our web player in it.

I dont know how a SQL dump and a SQL import could cause this issue as its a straight export and import
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

rkriggs

  • Sr. Member

  • Offline
  • ****
  • 338
Re: Database Errors
« Reply #13 on: January 16, 2019, 04:41:18 AM »
Make sure the old system and new system have the exact same version of radio dj.

Randy

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5347
    • Radio DJ Romania
Re: Database Errors
« Reply #14 on: January 16, 2019, 12:03:31 PM »
One thing I note is that there a 3 [[[.

I noticed too. What is confusing is that the query it doesn't have 3 items. It looks like this:

Code: [Select]
"UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]" & rdjInterface.Utils.QueryFixRegex(sWord.Trim) & "[[:>:]]';"
Even if the "sWord.Trim" variable would contain a bracket, it would not be placed there.

@PHAZE FM:
If you play the track from Maroon 5 which was caused the error, can you reproduce it again? Which version of MySQL do you use?
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.