[Kar]

How close is R40? It's been over a year now right?

[Adoniiz]

I have a problem

i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens:

pawn Код:

[20:43:22] Unprocessed queries: 26285
[20:44:30] Unprocessed queries: 25808
[20:45:39] Unprocessed queries: 25253
[20:46:48] Unprocessed queries: 24671
[20:47:57] Unprocessed queries: 24171
[20:49:08] Unprocessed queries: 23568
[20:50:17] Unprocessed queries: 22950
[20:51:26] Unprocessed queries: 22404
[20:52:36] Unprocessed queries: 21851
[20:53:46] Unprocessed queries: 21282
[20:54:56] Unprocessed queries: 20752
[20:56:05] Unprocessed queries: 20237
[20:57:14] Unprocessed queries: 19687
[20:58:23] Unprocessed queries: 19174
[20:59:32] Unprocessed queries: 18629
[21:00:41] Unprocessed queries: 18081
[21:01:50] Unprocessed queries: 17555
[21:02:59] Unprocessed queries: 16996
[21:04:08] Unprocessed queries: 16410
[21:05:18] Unprocessed queries: 15808
[21:06:28] Unprocessed queries: 15153
[21:07:38] Unprocessed queries: 14486
[21:08:49] Unprocessed queries: 13825
[21:09:59] Unprocessed queries: 13143
[21:11:09] Unprocessed queries: 12488
[21:12:20] Unprocessed queries: 11855
[21:13:30] Unprocessed queries: 11234
[21:14:40] Unprocessed queries: 10601
[21:15:50] Unprocessed queries: 9966
[21:17:01] Unprocessed queries: 9512
[21:18:11] Unprocessed queries: 9512
[21:19:21] Unprocessed queries: 9512
[21:20:32] Unprocessed queries: 9512
[21:21:42] Unprocessed queries: 9512
[21:22:52] Unprocessed queries: 9512
[21:24:02] Unprocessed queries: 9512
[21:25:13] Unprocessed queries: 9512
[21:26:23] Unprocessed queries: 9512

Why? only half is successful...

Thanks.

[WopsS]

Quote:

Originally Posted by Adoniiz I have a problem i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens: pawn Код: [20:43:22] Unprocessed queries: 26285 [20:44:30] Unprocessed queries: 25808 [20:45:39] Unprocessed queries: 25253 [20:46:48] Unprocessed queries: 24671 [20:47:57] Unprocessed queries: 24171 [20:49:08] Unprocessed queries: 23568 [20:50:17] Unprocessed queries: 22950 [20:51:26] Unprocessed queries: 22404 [20:52:36] Unprocessed queries: 21851 [20:53:46] Unprocessed queries: 21282 [20:54:56] Unprocessed queries: 20752 [20:56:05] Unprocessed queries: 20237 [20:57:14] Unprocessed queries: 19687 [20:58:23] Unprocessed queries: 19174 [20:59:32] Unprocessed queries: 18629 [21:00:41] Unprocessed queries: 18081 [21:01:50] Unprocessed queries: 17555 [21:02:59] Unprocessed queries: 16996 [21:04:08] Unprocessed queries: 16410 [21:05:18] Unprocessed queries: 15808 [21:06:28] Unprocessed queries: 15153 [21:07:38] Unprocessed queries: 14486 [21:08:49] Unprocessed queries: 13825 [21:09:59] Unprocessed queries: 13143 [21:11:09] Unprocessed queries: 12488 [21:12:20] Unprocessed queries: 11855 [21:13:30] Unprocessed queries: 11234 [21:14:40] Unprocessed queries: 10601 [21:15:50] Unprocessed queries: 9966 [21:17:01] Unprocessed queries: 9512 [21:18:11] Unprocessed queries: 9512 [21:19:21] Unprocessed queries: 9512 [21:20:32] Unprocessed queries: 9512 [21:21:42] Unprocessed queries: 9512 [21:22:52] Unprocessed queries: 9512 [21:24:02] Unprocessed queries: 9512 [21:25:13] Unprocessed queries: 9512 [21:26:23] Unprocessed queries: 9512 Why? only half is successful... Thanks.

If this happen when you close the server, then this is already a know issue. (This is fixed in R40)
https://github.com/pBlueG/SA-MP-MySQL/issues/64

[nickdodd25]

Quote:

Originally Posted by Adoniiz I have a problem i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens: pawn Код: [20:43:22] Unprocessed queries: 26285 [20:44:30] Unprocessed queries: 25808 [20:45:39] Unprocessed queries: 25253 [20:46:48] Unprocessed queries: 24671 [20:47:57] Unprocessed queries: 24171 [20:49:08] Unprocessed queries: 23568 [20:50:17] Unprocessed queries: 22950 [20:51:26] Unprocessed queries: 22404 [20:52:36] Unprocessed queries: 21851 [20:53:46] Unprocessed queries: 21282 [20:54:56] Unprocessed queries: 20752 [20:56:05] Unprocessed queries: 20237 [20:57:14] Unprocessed queries: 19687 [20:58:23] Unprocessed queries: 19174 [20:59:32] Unprocessed queries: 18629 [21:00:41] Unprocessed queries: 18081 [21:01:50] Unprocessed queries: 17555 [21:02:59] Unprocessed queries: 16996 [21:04:08] Unprocessed queries: 16410 [21:05:18] Unprocessed queries: 15808 [21:06:28] Unprocessed queries: 15153 [21:07:38] Unprocessed queries: 14486 [21:08:49] Unprocessed queries: 13825 [21:09:59] Unprocessed queries: 13143 [21:11:09] Unprocessed queries: 12488 [21:12:20] Unprocessed queries: 11855 [21:13:30] Unprocessed queries: 11234 [21:14:40] Unprocessed queries: 10601 [21:15:50] Unprocessed queries: 9966 [21:17:01] Unprocessed queries: 9512 [21:18:11] Unprocessed queries: 9512 [21:19:21] Unprocessed queries: 9512 [21:20:32] Unprocessed queries: 9512 [21:21:42] Unprocessed queries: 9512 [21:22:52] Unprocessed queries: 9512 [21:24:02] Unprocessed queries: 9512 [21:25:13] Unprocessed queries: 9512 [21:26:23] Unprocessed queries: 9512 Why? only half is successful... Thanks.

Look into Mysql Transactions for sending bulk query's, transactions also offer the ability to rollback changes in case something went wrong during the transaction.

[maddinat0r]

Quote:

Originally Posted by vannesenn Why I have poor load time on Windows 10 Pro(using WAMP server)? On Windows Pro 8.1 I didn't had poor load time.

<insert Windows10 rant here>
Maybe you forgot to configure something? Try setting everything up exactly as you did on Win8.1.

Quote:

Originally Posted by Kar How close is R40? It's been over a year now right?

Yep, it's been over a year and I still don't have an exact release date.

Quote:

Originally Posted by Adoniiz I have a problem i make 26.000 queries to the database (26.000 is total on number users registered in my server), so, this happens: pawn Код: [20:43:22] Unprocessed queries: 26285 [20:44:30] Unprocessed queries: 25808 [20:45:39] Unprocessed queries: 25253 [20:46:48] Unprocessed queries: 24671 [20:47:57] Unprocessed queries: 24171 [20:49:08] Unprocessed queries: 23568 [20:50:17] Unprocessed queries: 22950 [20:51:26] Unprocessed queries: 22404 [20:52:36] Unprocessed queries: 21851 [20:53:46] Unprocessed queries: 21282 [20:54:56] Unprocessed queries: 20752 [20:56:05] Unprocessed queries: 20237 [20:57:14] Unprocessed queries: 19687 [20:58:23] Unprocessed queries: 19174 [20:59:32] Unprocessed queries: 18629 [21:00:41] Unprocessed queries: 18081 [21:01:50] Unprocessed queries: 17555 [21:02:59] Unprocessed queries: 16996 [21:04:08] Unprocessed queries: 16410 [21:05:18] Unprocessed queries: 15808 [21:06:28] Unprocessed queries: 15153 [21:07:38] Unprocessed queries: 14486 [21:08:49] Unprocessed queries: 13825 [21:09:59] Unprocessed queries: 13143 [21:11:09] Unprocessed queries: 12488 [21:12:20] Unprocessed queries: 11855 [21:13:30] Unprocessed queries: 11234 [21:14:40] Unprocessed queries: 10601 [21:15:50] Unprocessed queries: 9966 [21:17:01] Unprocessed queries: 9512 [21:18:11] Unprocessed queries: 9512 [21:19:21] Unprocessed queries: 9512 [21:20:32] Unprocessed queries: 9512 [21:21:42] Unprocessed queries: 9512 [21:22:52] Unprocessed queries: 9512 [21:24:02] Unprocessed queries: 9512 [21:25:13] Unprocessed queries: 9512 [21:26:23] Unprocessed queries: 9512 Why? only half is successful... Thanks.

You can only queue up to 16876 queries per internal connection. So you either insert long enough delays between queries, execute e.g. 10000 queries in a transaction and execute the other ones in your last query's ("COMMIT") result callback or use mysql_pquery (since it uses multiple internal connections).

[Kar]

Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4?

pawn Код:

[21:14:11] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:33] [WARNING] cache_get_row_int - no active cache
[03:12:33] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[03:12:34] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[09:15:09] [WARNING] cache_get_row_int - no active cache
[09:15:09] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:13:59] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[15:21:50] [WARNING] cache_get_row_int - no active cache
[15:21:50] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[16:41:08] [WARNING] cache_get_row_int - no active cache
[16:41:08] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[20:44:13] [WARNING] cache_get_row_int - no active cache
[20:44:13] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache
[22:55:21] [WARNING] cache_get_row_int - no active cache
[22:55:21] [WARNING] cache_get_row - no active cache

I can't do much with warnings...

[n0minal]

Quote:

Originally Posted by Kar Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4? pawn Код: [21:14:11] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:33] [WARNING] cache_get_row_int - no active cache [03:12:33] [WARNING] cache_get_row - no active cache [03:12:34] [WARNING] cache_get_row_int - no active cache [03:12:34] [WARNING] cache_get_row - no active cache [03:12:34] [WARNING] cache_get_row_int - no active cache [03:12:34] [WARNING] cache_get_row - no active cache [03:12:34] [WARNING] cache_get_row_int - no active cache [03:12:34] [WARNING] cache_get_row - no active cache [03:12:34] [WARNING] cache_get_row_int - no active cache [03:12:34] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [09:15:09] [WARNING] cache_get_row_int - no active cache [09:15:09] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:13:59] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [15:21:50] [WARNING] cache_get_row_int - no active cache [15:21:50] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [16:41:08] [WARNING] cache_get_row_int - no active cache [16:41:08] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [20:44:13] [WARNING] cache_get_row_int - no active cache [20:44:13] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache I can't do much with warnings...

Exactly what I'm thinking, I'm getting this error:

Quote:

[13:02:41] [WARNING] cache_get_row_count - no active cache

It took me ages of tests to find where I was getting this error, and after find it, I noticed that the cache_delete function is the reason of that warning, but there's nothing wrong on my code:

Код:

                        else 
			{
				new Float:OffX, Float:OffY,Float:OffZ, Float:RotX, Float:RotY, Float:RotZ, Float:SclX, Float:SclY, Float:SclZ, Color1, Color2;
				mysql_format(MySQL, query, 512, "SELECT * FROM `equiped_items` WHERE `playerid` = %d AND `slotid` = 8", PlayerInfo[playerid][pid]);
				new Cache:handle = mysql_query(MySQL, query, true);

				OffX = cache_get_field_content_float(0, "OffsetX");
				OffY = cache_get_field_content_float(0, "OffsetY");
				OffZ = cache_get_field_content_float(0, "OffsetZ");
				RotX = cache_get_field_content_float(0, "RotX");
				RotY = cache_get_field_content_float(0, "RotY");
				RotZ = cache_get_field_content_float(0, "RotZ");
				SclX = cache_get_field_content_float(0, "ScaleX");
				SclY = cache_get_field_content_float(0, "ScaleY");
				SclZ = cache_get_field_content_float(0, "ScaleZ");
				Color1 = cache_get_field_content_int(0, "Color1");
				Color2 = cache_get_field_content_int(0, "Color2");

				PlayerEquippedItem[playerid][EItemOffX][8] = OffX;
				PlayerEquippedItem[playerid][EItemOffY][8] = OffY;
				PlayerEquippedItem[playerid][EItemOffZ][8] = OffZ;
				PlayerEquippedItem[playerid][EItemRotX][8] = RotX;
				PlayerEquippedItem[playerid][EItemRotY][8] = RotY;
				PlayerEquippedItem[playerid][EItemRotZ][8] = RotZ;
				PlayerEquippedItem[playerid][EItemSclX][8] = SclX;
				PlayerEquippedItem[playerid][EItemSclY][8] = SclY;
				PlayerEquippedItem[playerid][EItemSclZ][8] = SclZ;
				PlayerEquippedItem[playerid][EItemCol1][8] = Color1;
				PlayerEquippedItem[playerid][EItemCol2][8] = Color2;

				SetPlayerAttachedObject(playerid, 8, 371, 1, OffX, OffY, OffZ, RotX, RotY, RotZ, SclX, SclY, SclZ, Color1, Color2);
				return cache_delete(handle);
			}

If I remove the cache_delete function from this code, I get no errors. I have no problem with the retrieved result from query, but this warning is quite annoying and I don't know why I'm getting it.

[Vince]

Have you actually tried threading your queries every now and then? Judging by the return statement there is absolutely nothing that relies on a value from the database, so you might as well thread the query.

[maddinat0r]

Quote:

Originally Posted by AIl Can anyone compile R39-3 to work with CentOS 6.5 (And MySQL Server 5.1) ? I get this error on running the server: Код: ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [...] [21:24:11] Loading plugin: mysql.so [21:24:11] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory) [21:24:11] Loaded 2 plugins. [...] R39-2 works fine. (i have only libmysqlclient.so.16 but not libmysqlclient.so.18 :/)

The CentOS download for R39-3 is compiled for CentOS7 while the R39-2 download is compiled for CentOS6 (check the filenames of the archives).

Quote:

Originally Posted by Kar Can you update the plugin error code to display the query callback for warnings and make it that the mysql_log shows the day in the timestamp and call it R39-4? pawn Код: [21:14:11] [WARNING] cache_get_row_int - no active cache [...] [22:55:21] [WARNING] cache_get_row_int - no active cache [22:55:21] [WARNING] cache_get_row - no active cache I can't do much with warnings...

I'm already aware of this problem and this is already solved in R40. However, I'm not willing to release such a version (R39-4 as you called it), since this will only halt development on R40. Just wait a little longer.
If you want to help: there's a first beta version coming soon and I'll need some testers for this. I'll post more details when this first beta version is finished.

Quote:

Originally Posted by ipsLeon [...] It took me ages of tests to find where I was getting this error, and after find it, I noticed that the cache_delete function is the reason of that warning, but there's nothing wrong on my code: [...] Код: else { new Float:OffX, Float:OffY,Float:OffZ, Float:RotX, Float:RotY, Float:RotZ, Float:SclX, Float:SclY, Float:SclZ, Color1, Color2; mysql_format(MySQL, query, 512, "SELECT * FROM `equiped_items` WHERE `playerid` = %d AND `slotid` = 8", PlayerInfo[playerid][pid]); new Cache:handle = mysql_query(MySQL, query, true); OffX = cache_get_field_content_float(0, "OffsetX"); OffY = cache_get_field_content_float(0, "OffsetY"); OffZ = cache_get_field_content_float(0, "OffsetZ"); RotX = cache_get_field_content_float(0, "RotX"); RotY = cache_get_field_content_float(0, "RotY"); RotZ = cache_get_field_content_float(0, "RotZ"); SclX = cache_get_field_content_float(0, "ScaleX"); SclY = cache_get_field_content_float(0, "ScaleY"); SclZ = cache_get_field_content_float(0, "ScaleZ"); Color1 = cache_get_field_content_int(0, "Color1"); Color2 = cache_get_field_content_int(0, "Color2"); PlayerEquippedItem[playerid][EItemOffX][8] = OffX; PlayerEquippedItem[playerid][EItemOffY][8] = OffY; PlayerEquippedItem[playerid][EItemOffZ][8] = OffZ; PlayerEquippedItem[playerid][EItemRotX][8] = RotX; PlayerEquippedItem[playerid][EItemRotY][8] = RotY; PlayerEquippedItem[playerid][EItemRotZ][8] = RotZ; PlayerEquippedItem[playerid][EItemSclX][8] = SclX; PlayerEquippedItem[playerid][EItemSclY][8] = SclY; PlayerEquippedItem[playerid][EItemSclZ][8] = SclZ; PlayerEquippedItem[playerid][EItemCol1][8] = Color1; PlayerEquippedItem[playerid][EItemCol2][8] = Color2; SetPlayerAttachedObject(playerid, 8, 371, 1, OffX, OffY, OffZ, RotX, RotY, RotZ, SclX, SclY, SclZ, Color1, Color2); return cache_delete(handle); } If I remove the cache_delete function from this code, I get no errors. I have no problem with the retrieved result from query, but this warning is quite annoying and I don't know why I'm getting it.

Well, of course you won't get the "no active cache" warning if you don't delete your active cache - it will stay active until another cache overwrites it.

[n0minal]

Quote:

Originally Posted by maddinat0r The CentOS download for R39-3 is compiled for CentOS7 while the R39-2 download is compiled for CentOS6 (check the filenames of the archives). I'm already aware of this problem and this is already solved in R40. However, I'm not willing to release such a version (R39-4 as you called it), since this will only halt development on R40. Just wait a little longer. If you want to help: there's a first beta version coming soon and I'll need some testers for this. I'll post more details when this first beta version is finished. Well, of course you won't get the "no active cache" warning if you don't delete your active cache - it will stay active until another cache overwrites it.

I'll search for non-deleted caches, I'm actually using few non-threaded queries, I probably missed to delete a cache in some of those queries then.

@Vince: I already changed that return, but I still get the warning, I maybe forgot something as I said above...

#Edit: Should I still get this warning even after use cache_set_active(0) before creating a new cache? Cause I still get it, also, cache_warning_count isn't called when I get the warning on mysql_log...

[Kar]

Okay but I only asked for that because I use cache_is_valid before EVERY single cache_delete except ONE.

and the code goes like this

pawn Код:

format(gQuery, sizeof(gQuery), "SELECT * FROM `Groups` WHERE `Groupid` = %d LIMIT 0,1", groupid);
    mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnGetGroupMemberData", "iii", playerid, groupid, pQueryQueue[playerid]);

THREAD:OnGetGroupMemberData(playerid, groupid, queryQueue)
{
    if(cache_get_row_count() > 0) {
        new Cache:cacheID = cache_save();

        format(gQuery, sizeof(gQuery), "SELECT `Username`, `pGroupRank` FROM `Accounts` WHERE `pGroupID` = %d ORDER BY `pLastLoginTimestamp` DESC", groupid);
        mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnListGroupMembers", "iiii", playerid, groupid, queryQueue, _:cacheID);
    }
    else SendClientMessage(playerid, WHITE, "Invalid Group ID!");
    return 1;
}

THREAD:OnListGroupMembers(playerid, groupid, queryQueue, Cache:cacheID)
{
    if(pQueryQueue[playerid] != queryQueue) return 1;
    new Cache:curCacheID = cache_save(), row, Username[MAX_PLAYER_NAME], groupRank,
        gRankNames[MAX_GROUP_RANK + 1][MAX_GROUP_RANK_LEN], groupName[MAX_GROUP_NAME_LEN], title[64], groupColour, groupMemCount = 0,
        groupMemLoaded = 0, gMemStr[2048+1], id, next = 0;

    if(cache_is_valid(cacheID)) {
        cache_set_active(cacheID);
    }
    cache_get_row(0, 1, groupName, mysqlConnHandle, MAX_GROUP_NAME_LEN);
    cache_get_row(0, 2, gRankNames[0], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 3, gRankNames[1], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 4, gRankNames[2], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 5, gRankNames[3], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 6, gRankNames[4], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 7, gRankNames[5], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    cache_get_row(0, 8, gRankNames[6], mysqlConnHandle, MAX_GROUP_RANK_LEN);
    groupColour = cache_get_row_int(0, 11, mysqlConnHandle);

    cache_delete(cacheID);

    if(cache_is_valid(curCacheID)) {
        cache_set_active(curCacheID);
    }

There must always be a saved cache, so I'm just wondering why the hell would that return a warning.

Or maybe I'm miss understanding my other cache_deletes... is there only cache when rows are returned? or is it created nevertheless when you query something?

pawn Код:

new Cache:cacheID = mysql_query(mysqlConnHandle, gQuery);
        if(cache_is_valid(cacheID)) {
            if(cache_get_row_count()) {
                cache_get_row(0, 0, groupRankName, mysqlConnHandle, MAX_GROUP_RANK_LEN);
            }
            cache_delete(cacheID);
        }

All my other cache usages are EXACTLY like this ^.

So which one is the issue?

[n0minal]

Quote:

Originally Posted by Kar Okay but I only asked for that because I use cache_is_valid before EVERY single cache_delete except ONE. and the code goes like this pawn Код: format(gQuery, sizeof(gQuery), "SELECT * FROM `Groups` WHERE `Groupid` = %d LIMIT 0,1", groupid);     mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnGetGroupMemberData", "iii", playerid, groupid, pQueryQueue[playerid]); THREAD:OnGetGroupMemberData(playerid, groupid, queryQueue) {     if(cache_get_row_count() > 0) {         new Cache:cacheID = cache_save();         format(gQuery, sizeof(gQuery), "SELECT `Username`, `pGroupRank` FROM `Accounts` WHERE `pGroupID` = %d ORDER BY `pLastLoginTimestamp` DESC", groupid);         mysql_tquery(mysqlConnHandle, gQuery, "Thread_OnListGroupMembers", "iiii", playerid, groupid, queryQueue, _:cacheID);     }     else SendClientMessage(playerid, WHITE, "Invalid Group ID!");     return 1; } THREAD:OnListGroupMembers(playerid, groupid, queryQueue, Cache:cacheID) {     if(pQueryQueue[playerid] != queryQueue) return 1;     new Cache:curCacheID = cache_save(), row, Username[MAX_PLAYER_NAME], groupRank,         gRankNames[MAX_GROUP_RANK + 1][MAX_GROUP_RANK_LEN], groupName[MAX_GROUP_NAME_LEN], title[64], groupColour, groupMemCount = 0,         groupMemLoaded = 0, gMemStr[2048+1], id, next = 0;     if(cache_is_valid(cacheID)) {         cache_set_active(cacheID);     }     cache_get_row(0, 1, groupName, mysqlConnHandle, MAX_GROUP_NAME_LEN);     cache_get_row(0, 2, gRankNames[0], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 3, gRankNames[1], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 4, gRankNames[2], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 5, gRankNames[3], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 6, gRankNames[4], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 7, gRankNames[5], mysqlConnHandle, MAX_GROUP_RANK_LEN);     cache_get_row(0, 8, gRankNames[6], mysqlConnHandle, MAX_GROUP_RANK_LEN);     groupColour = cache_get_row_int(0, 11, mysqlConnHandle);     cache_delete(cacheID);     if(cache_is_valid(curCacheID)) {         cache_set_active(curCacheID);     } There must always be a saved cache, so I'm just wondering why the hell would that return a warning. Or maybe I'm miss understanding my other cache_deletes... is there only cache when rows are returned? or is it created nevertheless when you query something? pawn Код: new Cache:cacheID = mysql_query(mysqlConnHandle, gQuery);         if(cache_is_valid(cacheID)) {             if(cache_get_row_count()) {                 cache_get_row(0, 0, groupRankName, mysqlConnHandle, MAX_GROUP_RANK_LEN);             }             cache_delete(cacheID);         } All my other cache usages are EXACTLY like this ^. So which one is the issue?

Is it needed to delete caches at every threaded query? Cause if it is, I didn't made it and maybe that's why I'm getting that warning

[maddinat0r]

"mysql_query" always creates a cache, unless its third parameter is set to "false" (by default it's "true").
More info at the wiki.

Also it's unnecessary to check if a cache is valid directly after creating it through "mysql_query". Calling "cache_delete" on an invalid cache will only generate a warning and return "false".

[n0minal]

Quote:

Originally Posted by maddinat0r "mysql_query" always creates a cache, unless its third parameter is set to "false" (by default it's "true"). More info at the wiki. Also it's unnecessary to check if a cache is valid directly after creating it through "mysql_query". Calling "cache_delete" on an invalid cache will only generate a warning and return "false".

I really don't understand what's going on, I've been checking my whole code and all the non-threaded queries has their cache deleted after used, I also did cache_set_active(Cache:0) before creating a new cache but even after unset the current (unknown?) cache by this way, I still get the warning in that code, everything goes well in query retrieved results but that's really strange.

[PT]

maddinat0r do you gone add prepared statements on R40?

[n0minal]

Quote:

Originally Posted by AIl It's too hard for you guys? i have a CentOS server that i can give you to do this it's important, thank you for supporting and helping

Quote:

[21:24:11] Loading plugin: mysql.so [21:24:11] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)

Use mysql_static.so instead of mysql.so or try to find the archive "libmysqlclient.so.18" and put on your VPS.

Quote:

Originally Posted by maddinat0r Can't help you further here, sorry. Just wait until R40 is there.

It's okay, thank you sir, I'll remake the code using threaded queries.

[Abagail]

Quote:

Originally Posted by AIl Bro, there isn't any static version binaries in R39-3 is fucked up i already tried static version that is in debian tgz file, doesn't work server just crashed without any log Hey maddinat0r, can you see my post? Alo ?! Maddin, your avatar is so beautiful, is that you ?

that's george costanza

[Riversong]

Thanks, I did not know the tutorial for mySQL account system I read was outdated - I will try to start learning from the new one then

[losrivarola98]

Quote:

Q: I get a Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) error, how do I fix this? A: You don't have the MySQL client library installed. Install the "mysql-client" package.

How I can install mysql-client?

[Evocator]

Hi, a little help with a query please?

SELECT COUNT(*) FROM `Table1` WHERE `rowid1` NOT IN (SELECT `rowid2` FROM `Table2`) AND `Timestamp` <= '60000' AND `Field2` < 3000 AND `Field3` = 0

It used to work without the ANDs, but its throwing me an error.

Nvm, its fixed.